APPS.IGS_FI_PRC_LOCKBOX dependencies on IGS_FI_LOCKBOX_INTS

Line 406: p_v_record_identifier_cd igs_fi_lockbox_ints.record_identifier_cd%TYPE) RETURN VARCHAR2 AS

402: RETURN l_v_desc;
403: END get_fee_period;
404:
405: FUNCTION get_record_type_meaning(p_v_lockbox_name igs_fi_lockboxes.lockbox_name%TYPE,
406: p_v_record_identifier_cd igs_fi_lockbox_ints.record_identifier_cd%TYPE) RETURN VARCHAR2 AS
407: /******************************************************************
408: Created By : Amit Gairola
409: Date Created By : 12-Jun-2003
410: Purpose : Function for getting the record type meaning

Line 417: cp_rec_identifier_cd igs_fi_lockbox_ints.record_identifier_cd%TYPE) IS

413: Change History
414: Who When What
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;

Line 450: FROM igs_fi_lockbox_ints lb

446: -- from the Interface table
447: CURSOR cur_lb_ints(cp_lockbox_name VARCHAR2,
448: cp_status VARCHAR2) IS
449: SELECT rowid row_id, lb.*
450: FROM igs_fi_lockbox_ints lb
451: WHERE lockbox_name = cp_lockbox_name
452: AND record_status = cp_status
453: FOR UPDATE NOWAIT
454: ORDER BY lockbox_interface_id;

Line 458: CURSOR cur_lb_batch(cp_batch_name igs_fi_lockbox_ints.batch_name%TYPE,

454: ORDER BY lockbox_interface_id;
455:
456: -- Cursor for getting the TODO records for the Batch Name passed as input
457: -- from the Interface table where lockbox name is null
458: CURSOR cur_lb_batch(cp_batch_name igs_fi_lockbox_ints.batch_name%TYPE,
459: cp_status VARCHAR2) IS
460: SELECT rowid row_id,
461: lb.*
462: FROM igs_fi_lockbox_ints lb

Line 462: FROM igs_fi_lockbox_ints lb

458: CURSOR cur_lb_batch(cp_batch_name igs_fi_lockbox_ints.batch_name%TYPE,
459: cp_status VARCHAR2) IS
460: SELECT rowid row_id,
461: lb.*
462: FROM igs_fi_lockbox_ints lb
463: WHERE batch_name = cp_batch_name
464: AND record_status = cp_status
465: AND lockbox_name IS NULL
466: FOR UPDATE NOWAIT

Line 725: TYPE t_distinct_batch IS TABLE OF igs_fi_lockbox_ints.batch_name%TYPE

721: l_n_cntr NUMBER(38) := 0;
722: l_n_cntr1 NUMBER(38) := 0;
723: l_v_val_status VARCHAR2(1);
724:
725: TYPE t_distinct_batch IS TABLE OF igs_fi_lockbox_ints.batch_name%TYPE
726: INDEX BY BINARY_INTEGER;
727:
728: l_t_distinct_batch t_distinct_batch;
729: l_n_receipt_amount igs_fi_credits.amount%TYPE;

Line 736: l_n_amt_appl igs_fi_lockbox_ints.applied_amt1%TYPE;

732: l_n_batch_amount igs_fi_credits.amount%TYPE;
733: l_b_rec_batch BOOLEAN;
734: l_b_batch_unq BOOLEAN;
735: l_b_chg_amt_match BOOLEAN;
736: l_n_amt_appl igs_fi_lockbox_ints.applied_amt1%TYPE;
737: l_b_rc_ro_match BOOLEAN;
738: l_b_ro_chg_appl BOOLEAN;
739: l_n_distinct_batch_count NUMBER(38);
740: l_b_dup_batches BOOLEAN;

Line 1745: PROCEDURE update_lbint_status(p_v_status igs_fi_lockbox_ints.record_status%TYPE) AS

1741: g_v_line_sep);
1742: return l_v_val_status;
1743: END validate_type1;
1744:
1745: PROCEDURE update_lbint_status(p_v_status igs_fi_lockbox_ints.record_status%TYPE) AS
1746: /******************************************************************
1747: Created By : Amit Gairola
1748: Date Created By : 12-Jun-2003
1749: Purpose : Procedure for updating the interface table record status.

Line 1760: igs_fi_lockbox_ints_pkg.update_row(x_rowid => g_lb_int_tab(l_n_rec_cntr).row_id,

1756: BEGIN
1757: IF g_lb_int_tab.COUNT > 0 THEN
1758: FOR l_n_rec_cntr IN g_lb_int_tab.FIRST..g_lb_int_tab.LAST LOOP
1759: IF g_lb_int_tab.EXISTS(l_n_rec_cntr) THEN
1760: igs_fi_lockbox_ints_pkg.update_row(x_rowid => g_lb_int_tab(l_n_rec_cntr).row_id,
1761: x_lockbox_interface_id => g_lb_int_tab(l_n_rec_cntr).lockbox_interface_id,
1762: x_record_identifier_cd => g_lb_int_tab(l_n_rec_cntr).record_identifier_cd,
1763: x_record_status => p_v_status,
1764: x_deposit_date => g_lb_int_tab(l_n_rec_cntr).deposit_date,