index

Package BANINST1.foktext

Common routines for text (FOKTEXT).

Program units
f_get_last_seq   Selects the highest line number for a given text item.
f_exists   Checks to see if a text record exists.
p_delete   Deletes a text record.
p_create   Creates a text record with text column <= 50 characters long.
p_create   Creates a text record with text column > 50 characters long.

Cursors
fobtext_cursor   Selects text record.

fobtext_cursor 

CURSOR fobtext_cursor(
              doc_type    fobtext.fobtext_dtyp_seq_num%TYPE,
              doc_code    fobtext.fobtext_code%TYPE,
              chg_seq     fobtext.fobtext_chg_seq_num%TYPE DEFAULT NULL,
              item_num    fobtext.fobtext_item%TYPE DEFAULT NULL,
              pidm        fobtext.fobtext_pidm%TYPE DEFAULT NULL,
              seq_num     fobtext.fobtext_seq_num%TYPE DEFAULT NULL,
              cla_num     fobtext.fobtext_cla_num%TYPE DEFAULT NULL,
              prt_ind     fobtext.fobtext_prt_ind%TYPE DEFAULT NULL
              )
  RETURN fobtext%ROWTYPE;

Selects text record.

f_get_last_seq 

Function f_get_last_seq(doc_type fobtext.fobtext_dtyp_seq_num%TYPE,
                        doc_code fobtext.fobtext_code%TYPE,
                        chg_seq  fobtext.fobtext_chg_seq_num%TYPE DEFAULT NULL,
                        item_num fobtext.fobtext_item%TYPE DEFAULT NULL,
                        pidm     fobtext.fobtext_pidm%TYPE DEFAULT NULL)
  RETURN fobtext.fobtext_seq_num%TYPE

Selects the highest line number for a given text item.

Returns
the highest line number if found, otherwise 0.

f_exists 

Function f_exists(doc_type fobtext.fobtext_dtyp_seq_num%TYPE,
                  doc_code fobtext.fobtext_code%TYPE,
                  chg_seq  fobtext.fobtext_chg_seq_num%TYPE DEFAULT NULL,
                  item_num fobtext.fobtext_item%TYPE DEFAULT NULL,
                  pidm     fobtext.fobtext_pidm%TYPE DEFAULT NULL,
                  seq_num  fobtext.fobtext_seq_num%TYPE DEFAULT NULL,
                  cla_num  fobtext.fobtext_cla_num%TYPE DEFAULT NULL,
                  prt_ind  fobtext.fobtext_prt_ind%TYPE DEFAULT NULL)
  RETURN VARCHAR2

Checks to see if a text record exists.

Returns
Y if found, otherwise N.

p_delete 

Procedure p_delete(doc_type fobtext.fobtext_dtyp_seq_num%TYPE,
                   doc_code fobtext.fobtext_code%TYPE,
                   chg_seq  fobtext.fobtext_chg_seq_num%TYPE DEFAULT NULL,
                   item_num fobtext.fobtext_item%TYPE DEFAULT NULL,
                   pidm     fobtext.fobtext_pidm%TYPE DEFAULT NULL,
                   seq_num  fobtext.fobtext_seq_num%TYPE DEFAULT NULL)

Deletes a text record.

p_create 

Procedure p_create(doc_type fobtext.fobtext_dtyp_seq_num%TYPE,
                   doc_code fobtext.fobtext_code%TYPE,
                   seq_num  fobtext.fobtext_seq_num%TYPE,
                   in_text  fobtext.fobtext_text%TYPE,
                   chg_seq  fobtext.fobtext_chg_seq_num%TYPE DEFAULT NULL,
                   item_num fobtext.fobtext_item%TYPE DEFAULT NULL,
                   pidm     fobtext.fobtext_pidm%TYPE DEFAULT NULL,
                   user_id  fobtext.fobtext_user_id%TYPE DEFAULT USER,
                   cla_num  fobtext.fobtext_cla_num%TYPE DEFAULT NULL,
                   prt_ind  fobtext.fobtext_prt_ind%TYPE DEFAULT 'Y')

Creates a text record with text column <= 50 characters long.

p_create 

Procedure p_create(doc_type          fobtext.fobtext_dtyp_seq_num%TYPE,
                   doc_code          fobtext.fobtext_code%TYPE,
                   textstring        VARCHAR2,
                   append_or_replace VARCHAR2 DEFAULT 'append',
                   chg_seq           fobtext.fobtext_chg_seq_num%TYPE DEFAULT NULL,
                   item_num          fobtext.fobtext_item%TYPE DEFAULT NULL,
                   pidm              fobtext.fobtext_pidm%TYPE DEFAULT NULL,
                   user_id           fobtext.fobtext_user_id%TYPE DEFAULT USER,
                   cla_num           fobtext.fobtext_cla_num%TYPE DEFAULT NULL,
                   printable         fobtext.fobtext_prt_ind%TYPE DEFAULT 'Y')

Creates a text record with text column > 50 characters long.