[Home] [Help]
415: ***************************************************************** */
416: CURSOR cur_rc_type(cp_lockbox_name igs_fi_lockboxes.lockbox_name%TYPE,
417: cp_rec_identifier_cd igs_fi_lockbox_ints.record_identifier_cd%TYPE) IS
418: SELECT record_type_code
419: FROM igs_fi_lb_rec_types
420: WHERE lockbox_name = cp_lockbox_name
421: AND record_identifier_cd = cp_rec_identifier_cd;
422:
423: l_v_rc_type igs_fi_lb_rec_types.record_type_code%TYPE;
419: FROM igs_fi_lb_rec_types
420: WHERE lockbox_name = cp_lockbox_name
421: AND record_identifier_cd = cp_rec_identifier_cd;
422:
423: l_v_rc_type igs_fi_lb_rec_types.record_type_code%TYPE;
424: BEGIN
425: l_v_rc_type := NULL;
426: OPEN cur_rc_type(p_v_lockbox_name,
427: p_v_record_identifier_cd);
469: l_b_upd_err BOOLEAN;
470: l_n_cntr NUMBER(38);
471: l_n_cntr1 NUMBER(38);
472: l_b_batch_head_exists BOOLEAN;
473: l_v_rec_type_meaning igs_fi_lb_rec_types.record_type_code%TYPE;
474: BEGIN
475: l_b_upd_err := FALSE;
476: l_b_batch_head_exists := FALSE;
477: