14: Added column holds_released_yn to LB_RECEIPT_REC
15: ***************************************************************** */
16:
17: TYPE LB_INT_REC IS RECORD(row_id ROWID,
18: lockbox_interface_id igs_fi_lockbox_ints.lockbox_interface_id%TYPE,
19: record_identifier_cd igs_fi_lockbox_ints.record_identifier_cd%TYPE,
20: record_status igs_fi_lockbox_ints.record_status%TYPE,
21: deposit_date igs_fi_lockbox_ints.deposit_date%TYPE,
22: transmission_record_count igs_fi_lockbox_ints.transmission_record_count%TYPE,
15: ***************************************************************** */
16:
17: TYPE LB_INT_REC IS RECORD(row_id ROWID,
18: lockbox_interface_id igs_fi_lockbox_ints.lockbox_interface_id%TYPE,
19: record_identifier_cd igs_fi_lockbox_ints.record_identifier_cd%TYPE,
20: record_status igs_fi_lockbox_ints.record_status%TYPE,
21: deposit_date igs_fi_lockbox_ints.deposit_date%TYPE,
22: transmission_record_count igs_fi_lockbox_ints.transmission_record_count%TYPE,
23: transmission_amt igs_fi_lockbox_ints.transmission_amt%TYPE,
16:
17: TYPE LB_INT_REC IS RECORD(row_id ROWID,
18: lockbox_interface_id igs_fi_lockbox_ints.lockbox_interface_id%TYPE,
19: record_identifier_cd igs_fi_lockbox_ints.record_identifier_cd%TYPE,
20: record_status igs_fi_lockbox_ints.record_status%TYPE,
21: deposit_date igs_fi_lockbox_ints.deposit_date%TYPE,
22: transmission_record_count igs_fi_lockbox_ints.transmission_record_count%TYPE,
23: transmission_amt igs_fi_lockbox_ints.transmission_amt%TYPE,
24: lockbox_name igs_fi_lockbox_ints.lockbox_name%TYPE,
17: TYPE LB_INT_REC IS RECORD(row_id ROWID,
18: lockbox_interface_id igs_fi_lockbox_ints.lockbox_interface_id%TYPE,
19: record_identifier_cd igs_fi_lockbox_ints.record_identifier_cd%TYPE,
20: record_status igs_fi_lockbox_ints.record_status%TYPE,
21: deposit_date igs_fi_lockbox_ints.deposit_date%TYPE,
22: transmission_record_count igs_fi_lockbox_ints.transmission_record_count%TYPE,
23: transmission_amt igs_fi_lockbox_ints.transmission_amt%TYPE,
24: lockbox_name igs_fi_lockbox_ints.lockbox_name%TYPE,
25: lockbox_batch_count igs_fi_lockbox_ints.lockbox_batch_count%TYPE,
18: lockbox_interface_id igs_fi_lockbox_ints.lockbox_interface_id%TYPE,
19: record_identifier_cd igs_fi_lockbox_ints.record_identifier_cd%TYPE,
20: record_status igs_fi_lockbox_ints.record_status%TYPE,
21: deposit_date igs_fi_lockbox_ints.deposit_date%TYPE,
22: transmission_record_count igs_fi_lockbox_ints.transmission_record_count%TYPE,
23: transmission_amt igs_fi_lockbox_ints.transmission_amt%TYPE,
24: lockbox_name igs_fi_lockbox_ints.lockbox_name%TYPE,
25: lockbox_batch_count igs_fi_lockbox_ints.lockbox_batch_count%TYPE,
26: lockbox_record_count igs_fi_lockbox_ints.lockbox_record_count%TYPE,
19: record_identifier_cd igs_fi_lockbox_ints.record_identifier_cd%TYPE,
20: record_status igs_fi_lockbox_ints.record_status%TYPE,
21: deposit_date igs_fi_lockbox_ints.deposit_date%TYPE,
22: transmission_record_count igs_fi_lockbox_ints.transmission_record_count%TYPE,
23: transmission_amt igs_fi_lockbox_ints.transmission_amt%TYPE,
24: lockbox_name igs_fi_lockbox_ints.lockbox_name%TYPE,
25: lockbox_batch_count igs_fi_lockbox_ints.lockbox_batch_count%TYPE,
26: lockbox_record_count igs_fi_lockbox_ints.lockbox_record_count%TYPE,
27: lockbox_amt igs_fi_lockbox_ints.lockbox_amt%TYPE,
20: record_status igs_fi_lockbox_ints.record_status%TYPE,
21: deposit_date igs_fi_lockbox_ints.deposit_date%TYPE,
22: transmission_record_count igs_fi_lockbox_ints.transmission_record_count%TYPE,
23: transmission_amt igs_fi_lockbox_ints.transmission_amt%TYPE,
24: lockbox_name igs_fi_lockbox_ints.lockbox_name%TYPE,
25: lockbox_batch_count igs_fi_lockbox_ints.lockbox_batch_count%TYPE,
26: lockbox_record_count igs_fi_lockbox_ints.lockbox_record_count%TYPE,
27: lockbox_amt igs_fi_lockbox_ints.lockbox_amt%TYPE,
28: batch_name igs_fi_lockbox_ints.batch_name%TYPE,
21: deposit_date igs_fi_lockbox_ints.deposit_date%TYPE,
22: transmission_record_count igs_fi_lockbox_ints.transmission_record_count%TYPE,
23: transmission_amt igs_fi_lockbox_ints.transmission_amt%TYPE,
24: lockbox_name igs_fi_lockbox_ints.lockbox_name%TYPE,
25: lockbox_batch_count igs_fi_lockbox_ints.lockbox_batch_count%TYPE,
26: lockbox_record_count igs_fi_lockbox_ints.lockbox_record_count%TYPE,
27: lockbox_amt igs_fi_lockbox_ints.lockbox_amt%TYPE,
28: batch_name igs_fi_lockbox_ints.batch_name%TYPE,
29: batch_amt igs_fi_lockbox_ints.batch_amt%TYPE,
22: transmission_record_count igs_fi_lockbox_ints.transmission_record_count%TYPE,
23: transmission_amt igs_fi_lockbox_ints.transmission_amt%TYPE,
24: lockbox_name igs_fi_lockbox_ints.lockbox_name%TYPE,
25: lockbox_batch_count igs_fi_lockbox_ints.lockbox_batch_count%TYPE,
26: lockbox_record_count igs_fi_lockbox_ints.lockbox_record_count%TYPE,
27: lockbox_amt igs_fi_lockbox_ints.lockbox_amt%TYPE,
28: batch_name igs_fi_lockbox_ints.batch_name%TYPE,
29: batch_amt igs_fi_lockbox_ints.batch_amt%TYPE,
30: batch_record_count igs_fi_lockbox_ints.batch_record_count%TYPE,
23: transmission_amt igs_fi_lockbox_ints.transmission_amt%TYPE,
24: lockbox_name igs_fi_lockbox_ints.lockbox_name%TYPE,
25: lockbox_batch_count igs_fi_lockbox_ints.lockbox_batch_count%TYPE,
26: lockbox_record_count igs_fi_lockbox_ints.lockbox_record_count%TYPE,
27: lockbox_amt igs_fi_lockbox_ints.lockbox_amt%TYPE,
28: batch_name igs_fi_lockbox_ints.batch_name%TYPE,
29: batch_amt igs_fi_lockbox_ints.batch_amt%TYPE,
30: batch_record_count igs_fi_lockbox_ints.batch_record_count%TYPE,
31: item_number igs_fi_lockbox_ints.item_number%TYPE,
24: lockbox_name igs_fi_lockbox_ints.lockbox_name%TYPE,
25: lockbox_batch_count igs_fi_lockbox_ints.lockbox_batch_count%TYPE,
26: lockbox_record_count igs_fi_lockbox_ints.lockbox_record_count%TYPE,
27: lockbox_amt igs_fi_lockbox_ints.lockbox_amt%TYPE,
28: batch_name igs_fi_lockbox_ints.batch_name%TYPE,
29: batch_amt igs_fi_lockbox_ints.batch_amt%TYPE,
30: batch_record_count igs_fi_lockbox_ints.batch_record_count%TYPE,
31: item_number igs_fi_lockbox_ints.item_number%TYPE,
32: receipt_amt igs_fi_lockbox_ints.receipt_amt%TYPE,
25: lockbox_batch_count igs_fi_lockbox_ints.lockbox_batch_count%TYPE,
26: lockbox_record_count igs_fi_lockbox_ints.lockbox_record_count%TYPE,
27: lockbox_amt igs_fi_lockbox_ints.lockbox_amt%TYPE,
28: batch_name igs_fi_lockbox_ints.batch_name%TYPE,
29: batch_amt igs_fi_lockbox_ints.batch_amt%TYPE,
30: batch_record_count igs_fi_lockbox_ints.batch_record_count%TYPE,
31: item_number igs_fi_lockbox_ints.item_number%TYPE,
32: receipt_amt igs_fi_lockbox_ints.receipt_amt%TYPE,
33: check_cd igs_fi_lockbox_ints.check_cd%TYPE,
26: lockbox_record_count igs_fi_lockbox_ints.lockbox_record_count%TYPE,
27: lockbox_amt igs_fi_lockbox_ints.lockbox_amt%TYPE,
28: batch_name igs_fi_lockbox_ints.batch_name%TYPE,
29: batch_amt igs_fi_lockbox_ints.batch_amt%TYPE,
30: batch_record_count igs_fi_lockbox_ints.batch_record_count%TYPE,
31: item_number igs_fi_lockbox_ints.item_number%TYPE,
32: receipt_amt igs_fi_lockbox_ints.receipt_amt%TYPE,
33: check_cd igs_fi_lockbox_ints.check_cd%TYPE,
34: party_number igs_fi_lockbox_ints.party_number%TYPE,
27: lockbox_amt igs_fi_lockbox_ints.lockbox_amt%TYPE,
28: batch_name igs_fi_lockbox_ints.batch_name%TYPE,
29: batch_amt igs_fi_lockbox_ints.batch_amt%TYPE,
30: batch_record_count igs_fi_lockbox_ints.batch_record_count%TYPE,
31: item_number igs_fi_lockbox_ints.item_number%TYPE,
32: receipt_amt igs_fi_lockbox_ints.receipt_amt%TYPE,
33: check_cd igs_fi_lockbox_ints.check_cd%TYPE,
34: party_number igs_fi_lockbox_ints.party_number%TYPE,
35: payer_name igs_fi_lockbox_ints.payer_name%TYPE,
28: batch_name igs_fi_lockbox_ints.batch_name%TYPE,
29: batch_amt igs_fi_lockbox_ints.batch_amt%TYPE,
30: batch_record_count igs_fi_lockbox_ints.batch_record_count%TYPE,
31: item_number igs_fi_lockbox_ints.item_number%TYPE,
32: receipt_amt igs_fi_lockbox_ints.receipt_amt%TYPE,
33: check_cd igs_fi_lockbox_ints.check_cd%TYPE,
34: party_number igs_fi_lockbox_ints.party_number%TYPE,
35: payer_name igs_fi_lockbox_ints.payer_name%TYPE,
36: charge_cd1 igs_fi_lockbox_ints.charge_cd1%TYPE,
29: batch_amt igs_fi_lockbox_ints.batch_amt%TYPE,
30: batch_record_count igs_fi_lockbox_ints.batch_record_count%TYPE,
31: item_number igs_fi_lockbox_ints.item_number%TYPE,
32: receipt_amt igs_fi_lockbox_ints.receipt_amt%TYPE,
33: check_cd igs_fi_lockbox_ints.check_cd%TYPE,
34: party_number igs_fi_lockbox_ints.party_number%TYPE,
35: payer_name igs_fi_lockbox_ints.payer_name%TYPE,
36: charge_cd1 igs_fi_lockbox_ints.charge_cd1%TYPE,
37: charge_cd2 igs_fi_lockbox_ints.charge_cd2%TYPE,
30: batch_record_count igs_fi_lockbox_ints.batch_record_count%TYPE,
31: item_number igs_fi_lockbox_ints.item_number%TYPE,
32: receipt_amt igs_fi_lockbox_ints.receipt_amt%TYPE,
33: check_cd igs_fi_lockbox_ints.check_cd%TYPE,
34: party_number igs_fi_lockbox_ints.party_number%TYPE,
35: payer_name igs_fi_lockbox_ints.payer_name%TYPE,
36: charge_cd1 igs_fi_lockbox_ints.charge_cd1%TYPE,
37: charge_cd2 igs_fi_lockbox_ints.charge_cd2%TYPE,
38: charge_cd3 igs_fi_lockbox_ints.charge_cd3%TYPE,
31: item_number igs_fi_lockbox_ints.item_number%TYPE,
32: receipt_amt igs_fi_lockbox_ints.receipt_amt%TYPE,
33: check_cd igs_fi_lockbox_ints.check_cd%TYPE,
34: party_number igs_fi_lockbox_ints.party_number%TYPE,
35: payer_name igs_fi_lockbox_ints.payer_name%TYPE,
36: charge_cd1 igs_fi_lockbox_ints.charge_cd1%TYPE,
37: charge_cd2 igs_fi_lockbox_ints.charge_cd2%TYPE,
38: charge_cd3 igs_fi_lockbox_ints.charge_cd3%TYPE,
39: charge_cd4 igs_fi_lockbox_ints.charge_cd4%TYPE,
32: receipt_amt igs_fi_lockbox_ints.receipt_amt%TYPE,
33: check_cd igs_fi_lockbox_ints.check_cd%TYPE,
34: party_number igs_fi_lockbox_ints.party_number%TYPE,
35: payer_name igs_fi_lockbox_ints.payer_name%TYPE,
36: charge_cd1 igs_fi_lockbox_ints.charge_cd1%TYPE,
37: charge_cd2 igs_fi_lockbox_ints.charge_cd2%TYPE,
38: charge_cd3 igs_fi_lockbox_ints.charge_cd3%TYPE,
39: charge_cd4 igs_fi_lockbox_ints.charge_cd4%TYPE,
40: charge_cd5 igs_fi_lockbox_ints.charge_cd5%TYPE,
33: check_cd igs_fi_lockbox_ints.check_cd%TYPE,
34: party_number igs_fi_lockbox_ints.party_number%TYPE,
35: payer_name igs_fi_lockbox_ints.payer_name%TYPE,
36: charge_cd1 igs_fi_lockbox_ints.charge_cd1%TYPE,
37: charge_cd2 igs_fi_lockbox_ints.charge_cd2%TYPE,
38: charge_cd3 igs_fi_lockbox_ints.charge_cd3%TYPE,
39: charge_cd4 igs_fi_lockbox_ints.charge_cd4%TYPE,
40: charge_cd5 igs_fi_lockbox_ints.charge_cd5%TYPE,
41: charge_cd6 igs_fi_lockbox_ints.charge_cd6%TYPE,
34: party_number igs_fi_lockbox_ints.party_number%TYPE,
35: payer_name igs_fi_lockbox_ints.payer_name%TYPE,
36: charge_cd1 igs_fi_lockbox_ints.charge_cd1%TYPE,
37: charge_cd2 igs_fi_lockbox_ints.charge_cd2%TYPE,
38: charge_cd3 igs_fi_lockbox_ints.charge_cd3%TYPE,
39: charge_cd4 igs_fi_lockbox_ints.charge_cd4%TYPE,
40: charge_cd5 igs_fi_lockbox_ints.charge_cd5%TYPE,
41: charge_cd6 igs_fi_lockbox_ints.charge_cd6%TYPE,
42: charge_cd7 igs_fi_lockbox_ints.charge_cd7%TYPE,
35: payer_name igs_fi_lockbox_ints.payer_name%TYPE,
36: charge_cd1 igs_fi_lockbox_ints.charge_cd1%TYPE,
37: charge_cd2 igs_fi_lockbox_ints.charge_cd2%TYPE,
38: charge_cd3 igs_fi_lockbox_ints.charge_cd3%TYPE,
39: charge_cd4 igs_fi_lockbox_ints.charge_cd4%TYPE,
40: charge_cd5 igs_fi_lockbox_ints.charge_cd5%TYPE,
41: charge_cd6 igs_fi_lockbox_ints.charge_cd6%TYPE,
42: charge_cd7 igs_fi_lockbox_ints.charge_cd7%TYPE,
43: charge_cd8 igs_fi_lockbox_ints.charge_cd8%TYPE,
36: charge_cd1 igs_fi_lockbox_ints.charge_cd1%TYPE,
37: charge_cd2 igs_fi_lockbox_ints.charge_cd2%TYPE,
38: charge_cd3 igs_fi_lockbox_ints.charge_cd3%TYPE,
39: charge_cd4 igs_fi_lockbox_ints.charge_cd4%TYPE,
40: charge_cd5 igs_fi_lockbox_ints.charge_cd5%TYPE,
41: charge_cd6 igs_fi_lockbox_ints.charge_cd6%TYPE,
42: charge_cd7 igs_fi_lockbox_ints.charge_cd7%TYPE,
43: charge_cd8 igs_fi_lockbox_ints.charge_cd8%TYPE,
44: applied_amt1 igs_fi_lockbox_ints.applied_amt1%TYPE,
37: charge_cd2 igs_fi_lockbox_ints.charge_cd2%TYPE,
38: charge_cd3 igs_fi_lockbox_ints.charge_cd3%TYPE,
39: charge_cd4 igs_fi_lockbox_ints.charge_cd4%TYPE,
40: charge_cd5 igs_fi_lockbox_ints.charge_cd5%TYPE,
41: charge_cd6 igs_fi_lockbox_ints.charge_cd6%TYPE,
42: charge_cd7 igs_fi_lockbox_ints.charge_cd7%TYPE,
43: charge_cd8 igs_fi_lockbox_ints.charge_cd8%TYPE,
44: applied_amt1 igs_fi_lockbox_ints.applied_amt1%TYPE,
45: applied_amt2 igs_fi_lockbox_ints.applied_amt2%TYPE,
38: charge_cd3 igs_fi_lockbox_ints.charge_cd3%TYPE,
39: charge_cd4 igs_fi_lockbox_ints.charge_cd4%TYPE,
40: charge_cd5 igs_fi_lockbox_ints.charge_cd5%TYPE,
41: charge_cd6 igs_fi_lockbox_ints.charge_cd6%TYPE,
42: charge_cd7 igs_fi_lockbox_ints.charge_cd7%TYPE,
43: charge_cd8 igs_fi_lockbox_ints.charge_cd8%TYPE,
44: applied_amt1 igs_fi_lockbox_ints.applied_amt1%TYPE,
45: applied_amt2 igs_fi_lockbox_ints.applied_amt2%TYPE,
46: applied_amt3 igs_fi_lockbox_ints.applied_amt3%TYPE,
39: charge_cd4 igs_fi_lockbox_ints.charge_cd4%TYPE,
40: charge_cd5 igs_fi_lockbox_ints.charge_cd5%TYPE,
41: charge_cd6 igs_fi_lockbox_ints.charge_cd6%TYPE,
42: charge_cd7 igs_fi_lockbox_ints.charge_cd7%TYPE,
43: charge_cd8 igs_fi_lockbox_ints.charge_cd8%TYPE,
44: applied_amt1 igs_fi_lockbox_ints.applied_amt1%TYPE,
45: applied_amt2 igs_fi_lockbox_ints.applied_amt2%TYPE,
46: applied_amt3 igs_fi_lockbox_ints.applied_amt3%TYPE,
47: applied_amt4 igs_fi_lockbox_ints.applied_amt4%TYPE,
40: charge_cd5 igs_fi_lockbox_ints.charge_cd5%TYPE,
41: charge_cd6 igs_fi_lockbox_ints.charge_cd6%TYPE,
42: charge_cd7 igs_fi_lockbox_ints.charge_cd7%TYPE,
43: charge_cd8 igs_fi_lockbox_ints.charge_cd8%TYPE,
44: applied_amt1 igs_fi_lockbox_ints.applied_amt1%TYPE,
45: applied_amt2 igs_fi_lockbox_ints.applied_amt2%TYPE,
46: applied_amt3 igs_fi_lockbox_ints.applied_amt3%TYPE,
47: applied_amt4 igs_fi_lockbox_ints.applied_amt4%TYPE,
48: applied_amt5 igs_fi_lockbox_ints.applied_amt5%TYPE,
41: charge_cd6 igs_fi_lockbox_ints.charge_cd6%TYPE,
42: charge_cd7 igs_fi_lockbox_ints.charge_cd7%TYPE,
43: charge_cd8 igs_fi_lockbox_ints.charge_cd8%TYPE,
44: applied_amt1 igs_fi_lockbox_ints.applied_amt1%TYPE,
45: applied_amt2 igs_fi_lockbox_ints.applied_amt2%TYPE,
46: applied_amt3 igs_fi_lockbox_ints.applied_amt3%TYPE,
47: applied_amt4 igs_fi_lockbox_ints.applied_amt4%TYPE,
48: applied_amt5 igs_fi_lockbox_ints.applied_amt5%TYPE,
49: applied_amt6 igs_fi_lockbox_ints.applied_amt6%TYPE,
42: charge_cd7 igs_fi_lockbox_ints.charge_cd7%TYPE,
43: charge_cd8 igs_fi_lockbox_ints.charge_cd8%TYPE,
44: applied_amt1 igs_fi_lockbox_ints.applied_amt1%TYPE,
45: applied_amt2 igs_fi_lockbox_ints.applied_amt2%TYPE,
46: applied_amt3 igs_fi_lockbox_ints.applied_amt3%TYPE,
47: applied_amt4 igs_fi_lockbox_ints.applied_amt4%TYPE,
48: applied_amt5 igs_fi_lockbox_ints.applied_amt5%TYPE,
49: applied_amt6 igs_fi_lockbox_ints.applied_amt6%TYPE,
50: applied_amt7 igs_fi_lockbox_ints.applied_amt7%TYPE,
43: charge_cd8 igs_fi_lockbox_ints.charge_cd8%TYPE,
44: applied_amt1 igs_fi_lockbox_ints.applied_amt1%TYPE,
45: applied_amt2 igs_fi_lockbox_ints.applied_amt2%TYPE,
46: applied_amt3 igs_fi_lockbox_ints.applied_amt3%TYPE,
47: applied_amt4 igs_fi_lockbox_ints.applied_amt4%TYPE,
48: applied_amt5 igs_fi_lockbox_ints.applied_amt5%TYPE,
49: applied_amt6 igs_fi_lockbox_ints.applied_amt6%TYPE,
50: applied_amt7 igs_fi_lockbox_ints.applied_amt7%TYPE,
51: applied_amt8 igs_fi_lockbox_ints.applied_amt8%TYPE,
44: applied_amt1 igs_fi_lockbox_ints.applied_amt1%TYPE,
45: applied_amt2 igs_fi_lockbox_ints.applied_amt2%TYPE,
46: applied_amt3 igs_fi_lockbox_ints.applied_amt3%TYPE,
47: applied_amt4 igs_fi_lockbox_ints.applied_amt4%TYPE,
48: applied_amt5 igs_fi_lockbox_ints.applied_amt5%TYPE,
49: applied_amt6 igs_fi_lockbox_ints.applied_amt6%TYPE,
50: applied_amt7 igs_fi_lockbox_ints.applied_amt7%TYPE,
51: applied_amt8 igs_fi_lockbox_ints.applied_amt8%TYPE,
52: credit_type_cd igs_fi_lockbox_ints.credit_type_cd%TYPE,
45: applied_amt2 igs_fi_lockbox_ints.applied_amt2%TYPE,
46: applied_amt3 igs_fi_lockbox_ints.applied_amt3%TYPE,
47: applied_amt4 igs_fi_lockbox_ints.applied_amt4%TYPE,
48: applied_amt5 igs_fi_lockbox_ints.applied_amt5%TYPE,
49: applied_amt6 igs_fi_lockbox_ints.applied_amt6%TYPE,
50: applied_amt7 igs_fi_lockbox_ints.applied_amt7%TYPE,
51: applied_amt8 igs_fi_lockbox_ints.applied_amt8%TYPE,
52: credit_type_cd igs_fi_lockbox_ints.credit_type_cd%TYPE,
53: fee_cal_instance_cd igs_fi_lockbox_ints.fee_cal_instance_cd%TYPE,
46: applied_amt3 igs_fi_lockbox_ints.applied_amt3%TYPE,
47: applied_amt4 igs_fi_lockbox_ints.applied_amt4%TYPE,
48: applied_amt5 igs_fi_lockbox_ints.applied_amt5%TYPE,
49: applied_amt6 igs_fi_lockbox_ints.applied_amt6%TYPE,
50: applied_amt7 igs_fi_lockbox_ints.applied_amt7%TYPE,
51: applied_amt8 igs_fi_lockbox_ints.applied_amt8%TYPE,
52: credit_type_cd igs_fi_lockbox_ints.credit_type_cd%TYPE,
53: fee_cal_instance_cd igs_fi_lockbox_ints.fee_cal_instance_cd%TYPE,
54: adm_application_id igs_fi_lockbox_ints.adm_application_id%TYPE,
47: applied_amt4 igs_fi_lockbox_ints.applied_amt4%TYPE,
48: applied_amt5 igs_fi_lockbox_ints.applied_amt5%TYPE,
49: applied_amt6 igs_fi_lockbox_ints.applied_amt6%TYPE,
50: applied_amt7 igs_fi_lockbox_ints.applied_amt7%TYPE,
51: applied_amt8 igs_fi_lockbox_ints.applied_amt8%TYPE,
52: credit_type_cd igs_fi_lockbox_ints.credit_type_cd%TYPE,
53: fee_cal_instance_cd igs_fi_lockbox_ints.fee_cal_instance_cd%TYPE,
54: adm_application_id igs_fi_lockbox_ints.adm_application_id%TYPE,
55: attribute_category igs_fi_lockbox_ints.attribute_category%TYPE,
48: applied_amt5 igs_fi_lockbox_ints.applied_amt5%TYPE,
49: applied_amt6 igs_fi_lockbox_ints.applied_amt6%TYPE,
50: applied_amt7 igs_fi_lockbox_ints.applied_amt7%TYPE,
51: applied_amt8 igs_fi_lockbox_ints.applied_amt8%TYPE,
52: credit_type_cd igs_fi_lockbox_ints.credit_type_cd%TYPE,
53: fee_cal_instance_cd igs_fi_lockbox_ints.fee_cal_instance_cd%TYPE,
54: adm_application_id igs_fi_lockbox_ints.adm_application_id%TYPE,
55: attribute_category igs_fi_lockbox_ints.attribute_category%TYPE,
56: attribute1 igs_fi_lockbox_ints.attribute1%TYPE,
49: applied_amt6 igs_fi_lockbox_ints.applied_amt6%TYPE,
50: applied_amt7 igs_fi_lockbox_ints.applied_amt7%TYPE,
51: applied_amt8 igs_fi_lockbox_ints.applied_amt8%TYPE,
52: credit_type_cd igs_fi_lockbox_ints.credit_type_cd%TYPE,
53: fee_cal_instance_cd igs_fi_lockbox_ints.fee_cal_instance_cd%TYPE,
54: adm_application_id igs_fi_lockbox_ints.adm_application_id%TYPE,
55: attribute_category igs_fi_lockbox_ints.attribute_category%TYPE,
56: attribute1 igs_fi_lockbox_ints.attribute1%TYPE,
57: attribute2 igs_fi_lockbox_ints.attribute2%TYPE,
50: applied_amt7 igs_fi_lockbox_ints.applied_amt7%TYPE,
51: applied_amt8 igs_fi_lockbox_ints.applied_amt8%TYPE,
52: credit_type_cd igs_fi_lockbox_ints.credit_type_cd%TYPE,
53: fee_cal_instance_cd igs_fi_lockbox_ints.fee_cal_instance_cd%TYPE,
54: adm_application_id igs_fi_lockbox_ints.adm_application_id%TYPE,
55: attribute_category igs_fi_lockbox_ints.attribute_category%TYPE,
56: attribute1 igs_fi_lockbox_ints.attribute1%TYPE,
57: attribute2 igs_fi_lockbox_ints.attribute2%TYPE,
58: attribute3 igs_fi_lockbox_ints.attribute3%TYPE,
51: applied_amt8 igs_fi_lockbox_ints.applied_amt8%TYPE,
52: credit_type_cd igs_fi_lockbox_ints.credit_type_cd%TYPE,
53: fee_cal_instance_cd igs_fi_lockbox_ints.fee_cal_instance_cd%TYPE,
54: adm_application_id igs_fi_lockbox_ints.adm_application_id%TYPE,
55: attribute_category igs_fi_lockbox_ints.attribute_category%TYPE,
56: attribute1 igs_fi_lockbox_ints.attribute1%TYPE,
57: attribute2 igs_fi_lockbox_ints.attribute2%TYPE,
58: attribute3 igs_fi_lockbox_ints.attribute3%TYPE,
59: attribute4 igs_fi_lockbox_ints.attribute4%TYPE,
52: credit_type_cd igs_fi_lockbox_ints.credit_type_cd%TYPE,
53: fee_cal_instance_cd igs_fi_lockbox_ints.fee_cal_instance_cd%TYPE,
54: adm_application_id igs_fi_lockbox_ints.adm_application_id%TYPE,
55: attribute_category igs_fi_lockbox_ints.attribute_category%TYPE,
56: attribute1 igs_fi_lockbox_ints.attribute1%TYPE,
57: attribute2 igs_fi_lockbox_ints.attribute2%TYPE,
58: attribute3 igs_fi_lockbox_ints.attribute3%TYPE,
59: attribute4 igs_fi_lockbox_ints.attribute4%TYPE,
60: attribute5 igs_fi_lockbox_ints.attribute5%TYPE,
53: fee_cal_instance_cd igs_fi_lockbox_ints.fee_cal_instance_cd%TYPE,
54: adm_application_id igs_fi_lockbox_ints.adm_application_id%TYPE,
55: attribute_category igs_fi_lockbox_ints.attribute_category%TYPE,
56: attribute1 igs_fi_lockbox_ints.attribute1%TYPE,
57: attribute2 igs_fi_lockbox_ints.attribute2%TYPE,
58: attribute3 igs_fi_lockbox_ints.attribute3%TYPE,
59: attribute4 igs_fi_lockbox_ints.attribute4%TYPE,
60: attribute5 igs_fi_lockbox_ints.attribute5%TYPE,
61: attribute6 igs_fi_lockbox_ints.attribute6%TYPE,
54: adm_application_id igs_fi_lockbox_ints.adm_application_id%TYPE,
55: attribute_category igs_fi_lockbox_ints.attribute_category%TYPE,
56: attribute1 igs_fi_lockbox_ints.attribute1%TYPE,
57: attribute2 igs_fi_lockbox_ints.attribute2%TYPE,
58: attribute3 igs_fi_lockbox_ints.attribute3%TYPE,
59: attribute4 igs_fi_lockbox_ints.attribute4%TYPE,
60: attribute5 igs_fi_lockbox_ints.attribute5%TYPE,
61: attribute6 igs_fi_lockbox_ints.attribute6%TYPE,
62: attribute7 igs_fi_lockbox_ints.attribute7%TYPE,
55: attribute_category igs_fi_lockbox_ints.attribute_category%TYPE,
56: attribute1 igs_fi_lockbox_ints.attribute1%TYPE,
57: attribute2 igs_fi_lockbox_ints.attribute2%TYPE,
58: attribute3 igs_fi_lockbox_ints.attribute3%TYPE,
59: attribute4 igs_fi_lockbox_ints.attribute4%TYPE,
60: attribute5 igs_fi_lockbox_ints.attribute5%TYPE,
61: attribute6 igs_fi_lockbox_ints.attribute6%TYPE,
62: attribute7 igs_fi_lockbox_ints.attribute7%TYPE,
63: attribute8 igs_fi_lockbox_ints.attribute8%TYPE,
56: attribute1 igs_fi_lockbox_ints.attribute1%TYPE,
57: attribute2 igs_fi_lockbox_ints.attribute2%TYPE,
58: attribute3 igs_fi_lockbox_ints.attribute3%TYPE,
59: attribute4 igs_fi_lockbox_ints.attribute4%TYPE,
60: attribute5 igs_fi_lockbox_ints.attribute5%TYPE,
61: attribute6 igs_fi_lockbox_ints.attribute6%TYPE,
62: attribute7 igs_fi_lockbox_ints.attribute7%TYPE,
63: attribute8 igs_fi_lockbox_ints.attribute8%TYPE,
64: attribute9 igs_fi_lockbox_ints.attribute9%TYPE,
57: attribute2 igs_fi_lockbox_ints.attribute2%TYPE,
58: attribute3 igs_fi_lockbox_ints.attribute3%TYPE,
59: attribute4 igs_fi_lockbox_ints.attribute4%TYPE,
60: attribute5 igs_fi_lockbox_ints.attribute5%TYPE,
61: attribute6 igs_fi_lockbox_ints.attribute6%TYPE,
62: attribute7 igs_fi_lockbox_ints.attribute7%TYPE,
63: attribute8 igs_fi_lockbox_ints.attribute8%TYPE,
64: attribute9 igs_fi_lockbox_ints.attribute9%TYPE,
65: attribute10 igs_fi_lockbox_ints.attribute10%TYPE,
58: attribute3 igs_fi_lockbox_ints.attribute3%TYPE,
59: attribute4 igs_fi_lockbox_ints.attribute4%TYPE,
60: attribute5 igs_fi_lockbox_ints.attribute5%TYPE,
61: attribute6 igs_fi_lockbox_ints.attribute6%TYPE,
62: attribute7 igs_fi_lockbox_ints.attribute7%TYPE,
63: attribute8 igs_fi_lockbox_ints.attribute8%TYPE,
64: attribute9 igs_fi_lockbox_ints.attribute9%TYPE,
65: attribute10 igs_fi_lockbox_ints.attribute10%TYPE,
66: attribute11 igs_fi_lockbox_ints.attribute11%TYPE,
59: attribute4 igs_fi_lockbox_ints.attribute4%TYPE,
60: attribute5 igs_fi_lockbox_ints.attribute5%TYPE,
61: attribute6 igs_fi_lockbox_ints.attribute6%TYPE,
62: attribute7 igs_fi_lockbox_ints.attribute7%TYPE,
63: attribute8 igs_fi_lockbox_ints.attribute8%TYPE,
64: attribute9 igs_fi_lockbox_ints.attribute9%TYPE,
65: attribute10 igs_fi_lockbox_ints.attribute10%TYPE,
66: attribute11 igs_fi_lockbox_ints.attribute11%TYPE,
67: attribute12 igs_fi_lockbox_ints.attribute12%TYPE,
60: attribute5 igs_fi_lockbox_ints.attribute5%TYPE,
61: attribute6 igs_fi_lockbox_ints.attribute6%TYPE,
62: attribute7 igs_fi_lockbox_ints.attribute7%TYPE,
63: attribute8 igs_fi_lockbox_ints.attribute8%TYPE,
64: attribute9 igs_fi_lockbox_ints.attribute9%TYPE,
65: attribute10 igs_fi_lockbox_ints.attribute10%TYPE,
66: attribute11 igs_fi_lockbox_ints.attribute11%TYPE,
67: attribute12 igs_fi_lockbox_ints.attribute12%TYPE,
68: attribute13 igs_fi_lockbox_ints.attribute13%TYPE,
61: attribute6 igs_fi_lockbox_ints.attribute6%TYPE,
62: attribute7 igs_fi_lockbox_ints.attribute7%TYPE,
63: attribute8 igs_fi_lockbox_ints.attribute8%TYPE,
64: attribute9 igs_fi_lockbox_ints.attribute9%TYPE,
65: attribute10 igs_fi_lockbox_ints.attribute10%TYPE,
66: attribute11 igs_fi_lockbox_ints.attribute11%TYPE,
67: attribute12 igs_fi_lockbox_ints.attribute12%TYPE,
68: attribute13 igs_fi_lockbox_ints.attribute13%TYPE,
69: attribute14 igs_fi_lockbox_ints.attribute14%TYPE,
62: attribute7 igs_fi_lockbox_ints.attribute7%TYPE,
63: attribute8 igs_fi_lockbox_ints.attribute8%TYPE,
64: attribute9 igs_fi_lockbox_ints.attribute9%TYPE,
65: attribute10 igs_fi_lockbox_ints.attribute10%TYPE,
66: attribute11 igs_fi_lockbox_ints.attribute11%TYPE,
67: attribute12 igs_fi_lockbox_ints.attribute12%TYPE,
68: attribute13 igs_fi_lockbox_ints.attribute13%TYPE,
69: attribute14 igs_fi_lockbox_ints.attribute14%TYPE,
70: attribute15 igs_fi_lockbox_ints.attribute15%TYPE,
63: attribute8 igs_fi_lockbox_ints.attribute8%TYPE,
64: attribute9 igs_fi_lockbox_ints.attribute9%TYPE,
65: attribute10 igs_fi_lockbox_ints.attribute10%TYPE,
66: attribute11 igs_fi_lockbox_ints.attribute11%TYPE,
67: attribute12 igs_fi_lockbox_ints.attribute12%TYPE,
68: attribute13 igs_fi_lockbox_ints.attribute13%TYPE,
69: attribute14 igs_fi_lockbox_ints.attribute14%TYPE,
70: attribute15 igs_fi_lockbox_ints.attribute15%TYPE,
71: attribute16 igs_fi_lockbox_ints.attribute16%TYPE,
64: attribute9 igs_fi_lockbox_ints.attribute9%TYPE,
65: attribute10 igs_fi_lockbox_ints.attribute10%TYPE,
66: attribute11 igs_fi_lockbox_ints.attribute11%TYPE,
67: attribute12 igs_fi_lockbox_ints.attribute12%TYPE,
68: attribute13 igs_fi_lockbox_ints.attribute13%TYPE,
69: attribute14 igs_fi_lockbox_ints.attribute14%TYPE,
70: attribute15 igs_fi_lockbox_ints.attribute15%TYPE,
71: attribute16 igs_fi_lockbox_ints.attribute16%TYPE,
72: attribute17 igs_fi_lockbox_ints.attribute17%TYPE,
65: attribute10 igs_fi_lockbox_ints.attribute10%TYPE,
66: attribute11 igs_fi_lockbox_ints.attribute11%TYPE,
67: attribute12 igs_fi_lockbox_ints.attribute12%TYPE,
68: attribute13 igs_fi_lockbox_ints.attribute13%TYPE,
69: attribute14 igs_fi_lockbox_ints.attribute14%TYPE,
70: attribute15 igs_fi_lockbox_ints.attribute15%TYPE,
71: attribute16 igs_fi_lockbox_ints.attribute16%TYPE,
72: attribute17 igs_fi_lockbox_ints.attribute17%TYPE,
73: attribute18 igs_fi_lockbox_ints.attribute18%TYPE,
66: attribute11 igs_fi_lockbox_ints.attribute11%TYPE,
67: attribute12 igs_fi_lockbox_ints.attribute12%TYPE,
68: attribute13 igs_fi_lockbox_ints.attribute13%TYPE,
69: attribute14 igs_fi_lockbox_ints.attribute14%TYPE,
70: attribute15 igs_fi_lockbox_ints.attribute15%TYPE,
71: attribute16 igs_fi_lockbox_ints.attribute16%TYPE,
72: attribute17 igs_fi_lockbox_ints.attribute17%TYPE,
73: attribute18 igs_fi_lockbox_ints.attribute18%TYPE,
74: attribute19 igs_fi_lockbox_ints.attribute19%TYPE,
67: attribute12 igs_fi_lockbox_ints.attribute12%TYPE,
68: attribute13 igs_fi_lockbox_ints.attribute13%TYPE,
69: attribute14 igs_fi_lockbox_ints.attribute14%TYPE,
70: attribute15 igs_fi_lockbox_ints.attribute15%TYPE,
71: attribute16 igs_fi_lockbox_ints.attribute16%TYPE,
72: attribute17 igs_fi_lockbox_ints.attribute17%TYPE,
73: attribute18 igs_fi_lockbox_ints.attribute18%TYPE,
74: attribute19 igs_fi_lockbox_ints.attribute19%TYPE,
75: attribute20 igs_fi_lockbox_ints.attribute20%TYPE,
68: attribute13 igs_fi_lockbox_ints.attribute13%TYPE,
69: attribute14 igs_fi_lockbox_ints.attribute14%TYPE,
70: attribute15 igs_fi_lockbox_ints.attribute15%TYPE,
71: attribute16 igs_fi_lockbox_ints.attribute16%TYPE,
72: attribute17 igs_fi_lockbox_ints.attribute17%TYPE,
73: attribute18 igs_fi_lockbox_ints.attribute18%TYPE,
74: attribute19 igs_fi_lockbox_ints.attribute19%TYPE,
75: attribute20 igs_fi_lockbox_ints.attribute20%TYPE,
76: system_record_identifier igs_lookup_values.lookup_code%TYPE);
69: attribute14 igs_fi_lockbox_ints.attribute14%TYPE,
70: attribute15 igs_fi_lockbox_ints.attribute15%TYPE,
71: attribute16 igs_fi_lockbox_ints.attribute16%TYPE,
72: attribute17 igs_fi_lockbox_ints.attribute17%TYPE,
73: attribute18 igs_fi_lockbox_ints.attribute18%TYPE,
74: attribute19 igs_fi_lockbox_ints.attribute19%TYPE,
75: attribute20 igs_fi_lockbox_ints.attribute20%TYPE,
76: system_record_identifier igs_lookup_values.lookup_code%TYPE);
77:
70: attribute15 igs_fi_lockbox_ints.attribute15%TYPE,
71: attribute16 igs_fi_lockbox_ints.attribute16%TYPE,
72: attribute17 igs_fi_lockbox_ints.attribute17%TYPE,
73: attribute18 igs_fi_lockbox_ints.attribute18%TYPE,
74: attribute19 igs_fi_lockbox_ints.attribute19%TYPE,
75: attribute20 igs_fi_lockbox_ints.attribute20%TYPE,
76: system_record_identifier igs_lookup_values.lookup_code%TYPE);
77:
78: TYPE LB_RECEIPT_REC IS RECORD(row_id ROWID,
71: attribute16 igs_fi_lockbox_ints.attribute16%TYPE,
72: attribute17 igs_fi_lockbox_ints.attribute17%TYPE,
73: attribute18 igs_fi_lockbox_ints.attribute18%TYPE,
74: attribute19 igs_fi_lockbox_ints.attribute19%TYPE,
75: attribute20 igs_fi_lockbox_ints.attribute20%TYPE,
76: system_record_identifier igs_lookup_values.lookup_code%TYPE);
77:
78: TYPE LB_RECEIPT_REC IS RECORD(row_id ROWID,
79: lockbox_interface_id igs_fi_lb_rect_errs.lockbox_interface_id%TYPE,