eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_PAYGROUP_PUB dependencies on IBY_DOCS_PAYABLE_ALL

Line 1272: prev_pmt_due_date IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,

1268: (
1269: due_date_common_flag VARCHAR2(1),
1270: delv_chnl_common_flag VARCHAR2(1),
1271: uri_common_flag VARCHAR2(1),
1272: prev_pmt_due_date IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1273: curr_pmt_due_date IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1274: prev_delivery_channel IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1275: curr_delivery_channel IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1276: prev_uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,

Line 1273: curr_pmt_due_date IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,

1269: due_date_common_flag VARCHAR2(1),
1270: delv_chnl_common_flag VARCHAR2(1),
1271: uri_common_flag VARCHAR2(1),
1272: prev_pmt_due_date IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1273: curr_pmt_due_date IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1274: prev_delivery_channel IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1275: curr_delivery_channel IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1276: prev_uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1277: curr_uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,

Line 1274: prev_delivery_channel IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,

1270: delv_chnl_common_flag VARCHAR2(1),
1271: uri_common_flag VARCHAR2(1),
1272: prev_pmt_due_date IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1273: curr_pmt_due_date IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1274: prev_delivery_channel IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1275: curr_delivery_channel IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1276: prev_uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1277: curr_uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1278: prev_uri_checkdigits IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,

Line 1275: curr_delivery_channel IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,

1271: uri_common_flag VARCHAR2(1),
1272: prev_pmt_due_date IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1273: curr_pmt_due_date IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1274: prev_delivery_channel IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1275: curr_delivery_channel IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1276: prev_uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1277: curr_uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1278: prev_uri_checkdigits IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
1279: curr_uri_checkdigits IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE

Line 1276: prev_uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,

1272: prev_pmt_due_date IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1273: curr_pmt_due_date IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1274: prev_delivery_channel IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1275: curr_delivery_channel IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1276: prev_uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1277: curr_uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1278: prev_uri_checkdigits IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
1279: curr_uri_checkdigits IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE
1280:

Line 1277: curr_uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,

1273: curr_pmt_due_date IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1274: prev_delivery_channel IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1275: curr_delivery_channel IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1276: prev_uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1277: curr_uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1278: prev_uri_checkdigits IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
1279: curr_uri_checkdigits IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE
1280:
1281: );

Line 1278: prev_uri_checkdigits IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,

1274: prev_delivery_channel IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1275: curr_delivery_channel IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1276: prev_uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1277: curr_uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1278: prev_uri_checkdigits IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
1279: curr_uri_checkdigits IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE
1280:
1281: );
1282:

Line 1279: curr_uri_checkdigits IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE

1275: curr_delivery_channel IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1276: prev_uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1277: curr_uri IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1278: prev_uri_checkdigits IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
1279: curr_uri_checkdigits IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE
1280:
1281: );
1282:
1283: TYPE failDocsOfPaymentRecType IS RECORD

Line 1285: payment_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE,

1281: );
1282:
1283: TYPE failDocsOfPaymentRecType IS RECORD
1284: (
1285: payment_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE,
1286: document_payable_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1287: document_status IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
1288: calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
1289: calling_app_doc_unique_ref1 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,

Line 1286: document_payable_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

1282:
1283: TYPE failDocsOfPaymentRecType IS RECORD
1284: (
1285: payment_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE,
1286: document_payable_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1287: document_status IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
1288: calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
1289: calling_app_doc_unique_ref1 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
1290: calling_app_doc_unique_ref2 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,

Line 1287: document_status IBY_DOCS_PAYABLE_ALL.document_status%TYPE,

1283: TYPE failDocsOfPaymentRecType IS RECORD
1284: (
1285: payment_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE,
1286: document_payable_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1287: document_status IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
1288: calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
1289: calling_app_doc_unique_ref1 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
1290: calling_app_doc_unique_ref2 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
1291: calling_app_doc_unique_ref3 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,

Line 1288: calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,

1284: (
1285: payment_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE,
1286: document_payable_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1287: document_status IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
1288: calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
1289: calling_app_doc_unique_ref1 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
1290: calling_app_doc_unique_ref2 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
1291: calling_app_doc_unique_ref3 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
1292: calling_app_doc_unique_ref4 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,

Line 1289: calling_app_doc_unique_ref1 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,

1285: payment_id IBY_DOCS_PAYABLE_ALL.payment_id%TYPE,
1286: document_payable_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1287: document_status IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
1288: calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
1289: calling_app_doc_unique_ref1 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
1290: calling_app_doc_unique_ref2 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
1291: calling_app_doc_unique_ref3 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
1292: calling_app_doc_unique_ref4 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
1293: calling_app_doc_unique_ref5 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,

Line 1290: calling_app_doc_unique_ref2 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,

1286: document_payable_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1287: document_status IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
1288: calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
1289: calling_app_doc_unique_ref1 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
1290: calling_app_doc_unique_ref2 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
1291: calling_app_doc_unique_ref3 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
1292: calling_app_doc_unique_ref4 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
1293: calling_app_doc_unique_ref5 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
1294: pay_proc_trxn_type_code IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

Line 1291: calling_app_doc_unique_ref3 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,

1287: document_status IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
1288: calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
1289: calling_app_doc_unique_ref1 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
1290: calling_app_doc_unique_ref2 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
1291: calling_app_doc_unique_ref3 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
1292: calling_app_doc_unique_ref4 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
1293: calling_app_doc_unique_ref5 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
1294: pay_proc_trxn_type_code IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
1295: document_amount IBY_DOCS_PAYABLE_ALL.document_amount%TYPE,

Line 1292: calling_app_doc_unique_ref4 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,

1288: calling_app_id IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
1289: calling_app_doc_unique_ref1 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
1290: calling_app_doc_unique_ref2 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
1291: calling_app_doc_unique_ref3 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
1292: calling_app_doc_unique_ref4 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
1293: calling_app_doc_unique_ref5 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
1294: pay_proc_trxn_type_code IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
1295: document_amount IBY_DOCS_PAYABLE_ALL.document_amount%TYPE,
1296: payment_grouping_number IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE

Line 1293: calling_app_doc_unique_ref5 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,

1289: calling_app_doc_unique_ref1 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
1290: calling_app_doc_unique_ref2 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
1291: calling_app_doc_unique_ref3 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
1292: calling_app_doc_unique_ref4 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
1293: calling_app_doc_unique_ref5 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
1294: pay_proc_trxn_type_code IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
1295: document_amount IBY_DOCS_PAYABLE_ALL.document_amount%TYPE,
1296: payment_grouping_number IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE
1297:

Line 1294: pay_proc_trxn_type_code IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

1290: calling_app_doc_unique_ref2 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
1291: calling_app_doc_unique_ref3 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
1292: calling_app_doc_unique_ref4 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
1293: calling_app_doc_unique_ref5 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
1294: pay_proc_trxn_type_code IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
1295: document_amount IBY_DOCS_PAYABLE_ALL.document_amount%TYPE,
1296: payment_grouping_number IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE
1297:
1298: );

Line 1295: document_amount IBY_DOCS_PAYABLE_ALL.document_amount%TYPE,

1291: calling_app_doc_unique_ref3 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
1292: calling_app_doc_unique_ref4 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
1293: calling_app_doc_unique_ref5 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
1294: pay_proc_trxn_type_code IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
1295: document_amount IBY_DOCS_PAYABLE_ALL.document_amount%TYPE,
1296: payment_grouping_number IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE
1297:
1298: );
1299:

Line 1296: payment_grouping_number IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE

1292: calling_app_doc_unique_ref4 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
1293: calling_app_doc_unique_ref5 IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
1294: pay_proc_trxn_type_code IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
1295: document_amount IBY_DOCS_PAYABLE_ALL.document_amount%TYPE,
1296: payment_grouping_number IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE
1297:
1298: );
1299:
1300: TYPE failDocsOfPaymentTabType IS TABLE OF failDocsOfPaymentRecType

Line 1423: -- completed, the IBY_DOCS_PAYABLE_ALL table needs to be

1419: --
1420: -- Therefore, we need a separate data structure to keep track
1421: -- of the documents that are part of a payment. The docsInPaymentRecType
1422: -- is that data structure. After all the grouping operations are
1423: -- completed, the IBY_DOCS_PAYABLE_ALL table needs to be
1424: -- updated to indicate the PAYMENT_ID for each document that
1425: -- has been put into a payment. The docsInPaymentRecType
1426: -- is used for this update.
1427: --

Line 1435: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

1431: TYPE docsInPaymentRecType IS RECORD (
1432: payment_id
1433: IBY_PAYMENTS_ALL.payment_id%TYPE,
1434: document_id
1435: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1436: calling_app_id
1437: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
1438: calling_app_doc_id1
1439: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,

Line 1437: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,

1433: IBY_PAYMENTS_ALL.payment_id%TYPE,
1434: document_id
1435: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1436: calling_app_id
1437: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
1438: calling_app_doc_id1
1439: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
1440: calling_app_doc_id2
1441: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,

Line 1439: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,

1435: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1436: calling_app_id
1437: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
1438: calling_app_doc_id1
1439: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
1440: calling_app_doc_id2
1441: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
1442: calling_app_doc_id3
1443: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,

Line 1441: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,

1437: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
1438: calling_app_doc_id1
1439: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
1440: calling_app_doc_id2
1441: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
1442: calling_app_doc_id3
1443: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
1444: calling_app_doc_id4
1445: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,

Line 1443: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,

1439: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
1440: calling_app_doc_id2
1441: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
1442: calling_app_doc_id3
1443: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
1444: calling_app_doc_id4
1445: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
1446: calling_app_doc_id5
1447: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,

Line 1445: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,

1441: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
1442: calling_app_doc_id3
1443: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
1444: calling_app_doc_id4
1445: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
1446: calling_app_doc_id5
1447: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
1448: pay_proc_ttype_cd
1449: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

Line 1447: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,

1443: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
1444: calling_app_doc_id4
1445: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
1446: calling_app_doc_id5
1447: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
1448: pay_proc_ttype_cd
1449: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
1450: document_amount
1451: IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,

Line 1449: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

1445: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
1446: calling_app_doc_id5
1447: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
1448: pay_proc_ttype_cd
1449: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
1450: document_amount
1451: IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,
1452: document_currency
1453: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

Line 1451: IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,

1447: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
1448: pay_proc_ttype_cd
1449: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
1450: document_amount
1451: IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,
1452: document_currency
1453: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1454: payment_grp_num
1455: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,

Line 1453: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

1449: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
1450: document_amount
1451: IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,
1452: document_currency
1453: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1454: payment_grp_num
1455: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
1456: document_status
1457: IBY_DOCS_PAYABLE_ALL.document_status%TYPE := 'PAYMENT_CREATED',

Line 1455: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,

1451: IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,
1452: document_currency
1453: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1454: payment_grp_num
1455: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
1456: document_status
1457: IBY_DOCS_PAYABLE_ALL.document_status%TYPE := 'PAYMENT_CREATED',
1458: amount_withheld
1459: IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE := 0,

Line 1457: IBY_DOCS_PAYABLE_ALL.document_status%TYPE := 'PAYMENT_CREATED',

1453: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1454: payment_grp_num
1455: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
1456: document_status
1457: IBY_DOCS_PAYABLE_ALL.document_status%TYPE := 'PAYMENT_CREATED',
1458: amount_withheld
1459: IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE := 0,
1460: pmt_due_date
1461: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,

Line 1459: IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE := 0,

1455: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
1456: document_status
1457: IBY_DOCS_PAYABLE_ALL.document_status%TYPE := 'PAYMENT_CREATED',
1458: amount_withheld
1459: IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE := 0,
1460: pmt_due_date
1461: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1462: discount_date
1463: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,

Line 1461: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,

1457: IBY_DOCS_PAYABLE_ALL.document_status%TYPE := 'PAYMENT_CREATED',
1458: amount_withheld
1459: IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE := 0,
1460: pmt_due_date
1461: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1462: discount_date
1463: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,
1464: int_bank_acct_id
1465: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,

Line 1463: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,

1459: IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE := 0,
1460: pmt_due_date
1461: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1462: discount_date
1463: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,
1464: int_bank_acct_id
1465: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
1466: ext_payee_id
1467: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,

Line 1465: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,

1461: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1462: discount_date
1463: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,
1464: int_bank_acct_id
1465: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
1466: ext_payee_id
1467: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
1468: payee_id
1469: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,

Line 1467: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,

1463: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,
1464: int_bank_acct_id
1465: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
1466: ext_payee_id
1467: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
1468: payee_id
1469: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,
1470: payee_site_id
1471: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,

Line 1469: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,

1465: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
1466: ext_payee_id
1467: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
1468: payee_id
1469: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,
1470: payee_site_id
1471: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,
1472: supplier_site_id
1473: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,

Line 1471: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,

1467: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
1468: payee_id
1469: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,
1470: payee_site_id
1471: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,
1472: supplier_site_id
1473: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,
1474: org_id
1475: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

Line 1473: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,

1469: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,
1470: payee_site_id
1471: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,
1472: supplier_site_id
1473: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,
1474: org_id
1475: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1476: org_type
1477: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

Line 1475: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

1471: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,
1472: supplier_site_id
1473: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,
1474: org_id
1475: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1476: org_type
1477: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1478: ext_bank_acct_id
1479: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,

Line 1477: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

1473: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,
1474: org_id
1475: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1476: org_type
1477: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1478: ext_bank_acct_id
1479: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,
1480: pmt_curr_discount
1481: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,

Line 1479: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,

1475: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1476: org_type
1477: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1478: ext_bank_acct_id
1479: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,
1480: pmt_curr_discount
1481: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,
1482: delivery_channel
1483: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,

Line 1481: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,

1477: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1478: ext_bank_acct_id
1479: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,
1480: pmt_curr_discount
1481: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,
1482: delivery_channel
1483: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1484: unique_remit_id
1485: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,

Line 1483: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,

1479: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,
1480: pmt_curr_discount
1481: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,
1482: delivery_channel
1483: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1484: unique_remit_id
1485: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1486: uri_ckdigits
1487: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,

Line 1485: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,

1481: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,
1482: delivery_channel
1483: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1484: unique_remit_id
1485: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1486: uri_ckdigits
1487: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
1488:
1489: /*TPP-Start*/

Line 1487: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,

1483: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1484: unique_remit_id
1485: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1486: uri_ckdigits
1487: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
1488:
1489: /*TPP-Start*/
1490: inv_payee_party_id IBY_DOCS_PAYABLE_ALL.inv_payee_party_id%TYPE,
1491: inv_party_site_id IBY_DOCS_PAYABLE_ALL.inv_party_site_id%TYPE,

Line 1490: inv_payee_party_id IBY_DOCS_PAYABLE_ALL.inv_payee_party_id%TYPE,

1486: uri_ckdigits
1487: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
1488:
1489: /*TPP-Start*/
1490: inv_payee_party_id IBY_DOCS_PAYABLE_ALL.inv_payee_party_id%TYPE,
1491: inv_party_site_id IBY_DOCS_PAYABLE_ALL.inv_party_site_id%TYPE,
1492: inv_supplier_site_id IBY_DOCS_PAYABLE_ALL.inv_supplier_site_id%TYPE,
1493: inv_beneficiary_party IBY_DOCS_PAYABLE_ALL.inv_beneficiary_party%TYPE,
1494: ext_inv_payee_id IBY_DOCS_PAYABLE_ALL.ext_inv_payee_id%TYPE,

Line 1491: inv_party_site_id IBY_DOCS_PAYABLE_ALL.inv_party_site_id%TYPE,

1487: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
1488:
1489: /*TPP-Start*/
1490: inv_payee_party_id IBY_DOCS_PAYABLE_ALL.inv_payee_party_id%TYPE,
1491: inv_party_site_id IBY_DOCS_PAYABLE_ALL.inv_party_site_id%TYPE,
1492: inv_supplier_site_id IBY_DOCS_PAYABLE_ALL.inv_supplier_site_id%TYPE,
1493: inv_beneficiary_party IBY_DOCS_PAYABLE_ALL.inv_beneficiary_party%TYPE,
1494: ext_inv_payee_id IBY_DOCS_PAYABLE_ALL.ext_inv_payee_id%TYPE,
1495: relationship_id IBY_DOCS_PAYABLE_ALL.relationship_id%TYPE

Line 1492: inv_supplier_site_id IBY_DOCS_PAYABLE_ALL.inv_supplier_site_id%TYPE,

1488:
1489: /*TPP-Start*/
1490: inv_payee_party_id IBY_DOCS_PAYABLE_ALL.inv_payee_party_id%TYPE,
1491: inv_party_site_id IBY_DOCS_PAYABLE_ALL.inv_party_site_id%TYPE,
1492: inv_supplier_site_id IBY_DOCS_PAYABLE_ALL.inv_supplier_site_id%TYPE,
1493: inv_beneficiary_party IBY_DOCS_PAYABLE_ALL.inv_beneficiary_party%TYPE,
1494: ext_inv_payee_id IBY_DOCS_PAYABLE_ALL.ext_inv_payee_id%TYPE,
1495: relationship_id IBY_DOCS_PAYABLE_ALL.relationship_id%TYPE
1496: /*TPP-End*/

Line 1493: inv_beneficiary_party IBY_DOCS_PAYABLE_ALL.inv_beneficiary_party%TYPE,

1489: /*TPP-Start*/
1490: inv_payee_party_id IBY_DOCS_PAYABLE_ALL.inv_payee_party_id%TYPE,
1491: inv_party_site_id IBY_DOCS_PAYABLE_ALL.inv_party_site_id%TYPE,
1492: inv_supplier_site_id IBY_DOCS_PAYABLE_ALL.inv_supplier_site_id%TYPE,
1493: inv_beneficiary_party IBY_DOCS_PAYABLE_ALL.inv_beneficiary_party%TYPE,
1494: ext_inv_payee_id IBY_DOCS_PAYABLE_ALL.ext_inv_payee_id%TYPE,
1495: relationship_id IBY_DOCS_PAYABLE_ALL.relationship_id%TYPE
1496: /*TPP-End*/
1497: );

Line 1494: ext_inv_payee_id IBY_DOCS_PAYABLE_ALL.ext_inv_payee_id%TYPE,

1490: inv_payee_party_id IBY_DOCS_PAYABLE_ALL.inv_payee_party_id%TYPE,
1491: inv_party_site_id IBY_DOCS_PAYABLE_ALL.inv_party_site_id%TYPE,
1492: inv_supplier_site_id IBY_DOCS_PAYABLE_ALL.inv_supplier_site_id%TYPE,
1493: inv_beneficiary_party IBY_DOCS_PAYABLE_ALL.inv_beneficiary_party%TYPE,
1494: ext_inv_payee_id IBY_DOCS_PAYABLE_ALL.ext_inv_payee_id%TYPE,
1495: relationship_id IBY_DOCS_PAYABLE_ALL.relationship_id%TYPE
1496: /*TPP-End*/
1497: );
1498:

Line 1495: relationship_id IBY_DOCS_PAYABLE_ALL.relationship_id%TYPE

1491: inv_party_site_id IBY_DOCS_PAYABLE_ALL.inv_party_site_id%TYPE,
1492: inv_supplier_site_id IBY_DOCS_PAYABLE_ALL.inv_supplier_site_id%TYPE,
1493: inv_beneficiary_party IBY_DOCS_PAYABLE_ALL.inv_beneficiary_party%TYPE,
1494: ext_inv_payee_id IBY_DOCS_PAYABLE_ALL.ext_inv_payee_id%TYPE,
1495: relationship_id IBY_DOCS_PAYABLE_ALL.relationship_id%TYPE
1496: /*TPP-End*/
1497: );
1498:
1499: --

Line 1500: -- Used to update of the IBY_DOCS_PAYABLE_ALL table.

1496: /*TPP-End*/
1497: );
1498:
1499: --
1500: -- Used to update of the IBY_DOCS_PAYABLE_ALL table.
1501: --
1502: TYPE docsInPaymentTabType IS TABLE OF docsInPaymentRecType
1503: INDEX BY BINARY_INTEGER;
1504:

Line 1557: TYPE docPayTabType IS TABLE OF IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE

1553:
1554: --
1555: -- The document id table
1556: --
1557: TYPE docPayTabType IS TABLE OF IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE
1558: INDEX BY BINARY_INTEGER;
1559:
1560: --
1561: -- This record stores all the document fields that are used in

Line 1578: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

1574: TYPE paymentGroupCriteriaType IS RECORD (
1575: calling_app_payreq_cd
1576: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
1577: document_id
1578: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1579: calling_app_id
1580: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
1581: calling_app_doc_id1
1582: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,

Line 1580: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,

1576: IBY_PAY_SERVICE_REQUESTS.call_app_pay_service_req_code%TYPE,
1577: document_id
1578: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1579: calling_app_id
1580: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
1581: calling_app_doc_id1
1582: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
1583: calling_app_doc_id2
1584: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,

Line 1582: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,

1578: IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
1579: calling_app_id
1580: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
1581: calling_app_doc_id1
1582: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
1583: calling_app_doc_id2
1584: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
1585: calling_app_doc_id3
1586: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,

Line 1584: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,

1580: IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
1581: calling_app_doc_id1
1582: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
1583: calling_app_doc_id2
1584: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
1585: calling_app_doc_id3
1586: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
1587: calling_app_doc_id4
1588: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,

Line 1586: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,

1582: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref1%TYPE,
1583: calling_app_doc_id2
1584: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
1585: calling_app_doc_id3
1586: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
1587: calling_app_doc_id4
1588: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
1589: calling_app_doc_id5
1590: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,

Line 1588: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,

1584: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref2%TYPE,
1585: calling_app_doc_id3
1586: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
1587: calling_app_doc_id4
1588: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
1589: calling_app_doc_id5
1590: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
1591: pay_proc_ttype_cd
1592: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

Line 1590: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,

1586: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref3%TYPE,
1587: calling_app_doc_id4
1588: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
1589: calling_app_doc_id5
1590: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
1591: pay_proc_ttype_cd
1592: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
1593: payment_grp_num
1594: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,

Line 1592: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

1588: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref4%TYPE,
1589: calling_app_doc_id5
1590: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
1591: pay_proc_ttype_cd
1592: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
1593: payment_grp_num
1594: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
1595: payment_method_cd
1596: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

Line 1594: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,

1590: IBY_DOCS_PAYABLE_ALL.calling_app_doc_unique_ref5%TYPE,
1591: pay_proc_ttype_cd
1592: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
1593: payment_grp_num
1594: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
1595: payment_method_cd
1596: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1597: int_bank_acct_id
1598: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,

Line 1596: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

1592: IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
1593: payment_grp_num
1594: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
1595: payment_method_cd
1596: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1597: int_bank_acct_id
1598: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
1599: ext_bank_acct_id
1600: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,

Line 1598: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,

1594: IBY_DOCS_PAYABLE_ALL.payment_grouping_number%TYPE,
1595: payment_method_cd
1596: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1597: int_bank_acct_id
1598: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
1599: ext_bank_acct_id
1600: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,
1601: payment_profile_id
1602: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,

Line 1600: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,

1596: IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
1597: int_bank_acct_id
1598: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
1599: ext_bank_acct_id
1600: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,
1601: payment_profile_id
1602: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
1603: org_id
1604: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

Line 1602: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,

1598: IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
1599: ext_bank_acct_id
1600: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,
1601: payment_profile_id
1602: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
1603: org_id
1604: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1605: org_type
1606: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

Line 1604: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

1600: IBY_DOCS_PAYABLE_ALL.external_bank_account_id%TYPE,
1601: payment_profile_id
1602: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
1603: org_id
1604: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1605: org_type
1606: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1607: payment_function
1608: IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,

Line 1606: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

1602: IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
1603: org_id
1604: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1605: org_type
1606: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1607: payment_function
1608: IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
1609: ext_payee_id
1610: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,

Line 1608: IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,

1604: IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
1605: org_type
1606: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1607: payment_function
1608: IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
1609: ext_payee_id
1610: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
1611: payee_party_id
1612: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,

Line 1610: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,

1606: IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
1607: payment_function
1608: IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
1609: ext_payee_id
1610: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
1611: payee_party_id
1612: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,
1613: payee_party_site_id
1614: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,

Line 1612: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,

1608: IBY_DOCS_PAYABLE_ALL.payment_function%TYPE,
1609: ext_payee_id
1610: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
1611: payee_party_id
1612: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,
1613: payee_party_site_id
1614: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,
1615: supplier_site_id
1616: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,

Line 1614: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,

1610: IBY_DOCS_PAYABLE_ALL.ext_payee_id%TYPE,
1611: payee_party_id
1612: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,
1613: payee_party_site_id
1614: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,
1615: supplier_site_id
1616: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,
1617: remit_loc_id
1618: IBY_DOCS_PAYABLE_ALL.remit_to_location_id%TYPE,

Line 1616: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,

1612: IBY_DOCS_PAYABLE_ALL.payee_party_id%TYPE,
1613: payee_party_site_id
1614: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,
1615: supplier_site_id
1616: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,
1617: remit_loc_id
1618: IBY_DOCS_PAYABLE_ALL.remit_to_location_id%TYPE,
1619: amount_withheld
1620: IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE,

Line 1618: IBY_DOCS_PAYABLE_ALL.remit_to_location_id%TYPE,

1614: IBY_DOCS_PAYABLE_ALL.party_site_id%TYPE,
1615: supplier_site_id
1616: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,
1617: remit_loc_id
1618: IBY_DOCS_PAYABLE_ALL.remit_to_location_id%TYPE,
1619: amount_withheld
1620: IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE,
1621: bank_inst1_code
1622: IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE,

Line 1620: IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE,

1616: IBY_DOCS_PAYABLE_ALL.supplier_site_id%TYPE,
1617: remit_loc_id
1618: IBY_DOCS_PAYABLE_ALL.remit_to_location_id%TYPE,
1619: amount_withheld
1620: IBY_DOCS_PAYABLE_ALL.amount_withheld%TYPE,
1621: bank_inst1_code
1622: IBY_EXTERNAL_PAYEES_ALL.bank_instruction1_code%TYPE,
1623: bank_inst2_code
1624: IBY_EXTERNAL_PAYEES_ALL.bank_instruction2_code%TYPE,

Line 1632: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

1628: IBY_EXTERNAL_PAYEES_ALL.payment_text_message2%TYPE,
1629: pmt_txt_msg3
1630: IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE,
1631: payment_currency
1632: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1633: payment_amount
1634: IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,
1635: payment_date
1636: IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,

Line 1634: IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,

1630: IBY_EXTERNAL_PAYEES_ALL.payment_text_message3%TYPE,
1631: payment_currency
1632: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1633: payment_amount
1634: IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,
1635: payment_date
1636: IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
1637: pay_alone_flag
1638: IBY_DOCS_PAYABLE_ALL.exclusive_payment_flag%TYPE,

Line 1636: IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,

1632: IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
1633: payment_amount
1634: IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,
1635: payment_date
1636: IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
1637: pay_alone_flag
1638: IBY_DOCS_PAYABLE_ALL.exclusive_payment_flag%TYPE,
1639: bank_charge_bearer
1640: IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,

Line 1638: IBY_DOCS_PAYABLE_ALL.exclusive_payment_flag%TYPE,

1634: IBY_DOCS_PAYABLE_ALL.payment_amount%TYPE,
1635: payment_date
1636: IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
1637: pay_alone_flag
1638: IBY_DOCS_PAYABLE_ALL.exclusive_payment_flag%TYPE,
1639: bank_charge_bearer
1640: IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
1641: delivery_channel
1642: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,

Line 1640: IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,

1636: IBY_DOCS_PAYABLE_ALL.payment_date%TYPE,
1637: pay_alone_flag
1638: IBY_DOCS_PAYABLE_ALL.exclusive_payment_flag%TYPE,
1639: bank_charge_bearer
1640: IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
1641: delivery_channel
1642: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1643: settle_priority
1644: IBY_DOCS_PAYABLE_ALL.settlement_priority%TYPE,

Line 1642: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,

1638: IBY_DOCS_PAYABLE_ALL.exclusive_payment_flag%TYPE,
1639: bank_charge_bearer
1640: IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
1641: delivery_channel
1642: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1643: settle_priority
1644: IBY_DOCS_PAYABLE_ALL.settlement_priority%TYPE,
1645: supplier_message1
1646: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,

Line 1644: IBY_DOCS_PAYABLE_ALL.settlement_priority%TYPE,

1640: IBY_DOCS_PAYABLE_ALL.bank_charge_bearer%TYPE,
1641: delivery_channel
1642: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1643: settle_priority
1644: IBY_DOCS_PAYABLE_ALL.settlement_priority%TYPE,
1645: supplier_message1
1646: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,
1647: supplier_message2
1648: IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE,

Line 1646: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,

1642: IBY_DOCS_PAYABLE_ALL.delivery_channel_code%TYPE,
1643: settle_priority
1644: IBY_DOCS_PAYABLE_ALL.settlement_priority%TYPE,
1645: supplier_message1
1646: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,
1647: supplier_message2
1648: IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE,
1649: supplier_message3
1650: IBY_DOCS_PAYABLE_ALL.remittance_message3%TYPE,

Line 1648: IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE,

1644: IBY_DOCS_PAYABLE_ALL.settlement_priority%TYPE,
1645: supplier_message1
1646: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,
1647: supplier_message2
1648: IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE,
1649: supplier_message3
1650: IBY_DOCS_PAYABLE_ALL.remittance_message3%TYPE,
1651: unique_remit_id
1652: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,

Line 1650: IBY_DOCS_PAYABLE_ALL.remittance_message3%TYPE,

1646: IBY_DOCS_PAYABLE_ALL.remittance_message1%TYPE,
1647: supplier_message2
1648: IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE,
1649: supplier_message3
1650: IBY_DOCS_PAYABLE_ALL.remittance_message3%TYPE,
1651: unique_remit_id
1652: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1653: uri_checkdigit
1654: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,

Line 1652: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,

1648: IBY_DOCS_PAYABLE_ALL.remittance_message2%TYPE,
1649: supplier_message3
1650: IBY_DOCS_PAYABLE_ALL.remittance_message3%TYPE,
1651: unique_remit_id
1652: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1653: uri_checkdigit
1654: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
1655: pmt_reason_code
1656: IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,

Line 1654: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,

1650: IBY_DOCS_PAYABLE_ALL.remittance_message3%TYPE,
1651: unique_remit_id
1652: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1653: uri_checkdigit
1654: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
1655: pmt_reason_code
1656: IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,
1657: pmt_reason_comments
1658: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,

Line 1656: IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,

1652: IBY_DOCS_PAYABLE_ALL.unique_remittance_identifier%TYPE,
1653: uri_checkdigit
1654: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
1655: pmt_reason_code
1656: IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,
1657: pmt_reason_comments
1658: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,
1659: pmt_due_date
1660: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,

Line 1658: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,

1654: IBY_DOCS_PAYABLE_ALL.uri_check_digit%TYPE,
1655: pmt_reason_code
1656: IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,
1657: pmt_reason_comments
1658: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,
1659: pmt_due_date
1660: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1661: discount_date
1662: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,

Line 1660: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,

1656: IBY_DOCS_PAYABLE_ALL.payment_reason_code%TYPE,
1657: pmt_reason_comments
1658: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,
1659: pmt_due_date
1660: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1661: discount_date
1662: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,
1663: discount_amount
1664: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,

Line 1662: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,

1658: IBY_DOCS_PAYABLE_ALL.payment_reason_comments%TYPE,
1659: pmt_due_date
1660: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1661: discount_date
1662: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,
1663: discount_amount
1664: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,
1665: benef_party
1666: IBY_DOCS_PAYABLE_ALL.beneficiary_party%TYPE,

Line 1664: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,

1660: IBY_DOCS_PAYABLE_ALL.payment_due_date%TYPE,
1661: discount_date
1662: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,
1663: discount_amount
1664: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,
1665: benef_party
1666: IBY_DOCS_PAYABLE_ALL.beneficiary_party%TYPE,
1667: addr_source
1668: IBY_DOCS_PAYABLE_ALL.address_source%TYPE,

Line 1666: IBY_DOCS_PAYABLE_ALL.beneficiary_party%TYPE,

1662: IBY_DOCS_PAYABLE_ALL.discount_date%TYPE,
1663: discount_amount
1664: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,
1665: benef_party
1666: IBY_DOCS_PAYABLE_ALL.beneficiary_party%TYPE,
1667: addr_source
1668: IBY_DOCS_PAYABLE_ALL.address_source%TYPE,
1669: emp_addr_code
1670: IBY_DOCS_PAYABLE_ALL.employee_address_code%TYPE,

Line 1668: IBY_DOCS_PAYABLE_ALL.address_source%TYPE,

1664: IBY_DOCS_PAYABLE_ALL.payment_curr_discount_taken%TYPE,
1665: benef_party
1666: IBY_DOCS_PAYABLE_ALL.beneficiary_party%TYPE,
1667: addr_source
1668: IBY_DOCS_PAYABLE_ALL.address_source%TYPE,
1669: emp_addr_code
1670: IBY_DOCS_PAYABLE_ALL.employee_address_code%TYPE,
1671: emp_person_id
1672: IBY_DOCS_PAYABLE_ALL.employee_person_id%TYPE,

Line 1670: IBY_DOCS_PAYABLE_ALL.employee_address_code%TYPE,

1666: IBY_DOCS_PAYABLE_ALL.beneficiary_party%TYPE,
1667: addr_source
1668: IBY_DOCS_PAYABLE_ALL.address_source%TYPE,
1669: emp_addr_code
1670: IBY_DOCS_PAYABLE_ALL.employee_address_code%TYPE,
1671: emp_person_id
1672: IBY_DOCS_PAYABLE_ALL.employee_person_id%TYPE,
1673: emp_address_id
1674: IBY_DOCS_PAYABLE_ALL.employee_address_id%TYPE,

Line 1672: IBY_DOCS_PAYABLE_ALL.employee_person_id%TYPE,

1668: IBY_DOCS_PAYABLE_ALL.address_source%TYPE,
1669: emp_addr_code
1670: IBY_DOCS_PAYABLE_ALL.employee_address_code%TYPE,
1671: emp_person_id
1672: IBY_DOCS_PAYABLE_ALL.employee_person_id%TYPE,
1673: emp_address_id
1674: IBY_DOCS_PAYABLE_ALL.employee_address_id%TYPE,
1675: emp_payment_flag
1676: IBY_DOCS_PAYABLE_ALL.employee_payment_flag%TYPE,

Line 1674: IBY_DOCS_PAYABLE_ALL.employee_address_id%TYPE,

1670: IBY_DOCS_PAYABLE_ALL.employee_address_code%TYPE,
1671: emp_person_id
1672: IBY_DOCS_PAYABLE_ALL.employee_person_id%TYPE,
1673: emp_address_id
1674: IBY_DOCS_PAYABLE_ALL.employee_address_id%TYPE,
1675: emp_payment_flag
1676: IBY_DOCS_PAYABLE_ALL.employee_payment_flag%TYPE,
1677: supplier_msg_flag
1678: IBY_PMT_CREATION_RULES.group_by_remittance_message%TYPE,

Line 1676: IBY_DOCS_PAYABLE_ALL.employee_payment_flag%TYPE,

1672: IBY_DOCS_PAYABLE_ALL.employee_person_id%TYPE,
1673: emp_address_id
1674: IBY_DOCS_PAYABLE_ALL.employee_address_id%TYPE,
1675: emp_payment_flag
1676: IBY_DOCS_PAYABLE_ALL.employee_payment_flag%TYPE,
1677: supplier_msg_flag
1678: IBY_PMT_CREATION_RULES.group_by_remittance_message%TYPE,
1679: bnk_chg_bearer_flag
1680: IBY_PMT_CREATION_RULES.group_by_bank_charge_bearer%TYPE,

Line 3312: p_docStatus IN IBY_DOCS_PAYABLE_ALL.

3308: |
3309: *---------------------------------------------------------------------*/
3310: PROCEDURE failDocsOfPayment(
3311: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
3312: p_docStatus IN IBY_DOCS_PAYABLE_ALL.
3313: document_status%TYPE,
3314: x_docsInPmtTab IN OUT NOCOPY docsInPaymentTabType,
3315: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3316: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType

Line 3340: p_docStatus IN IBY_DOCS_PAYABLE_ALL.

3336: |
3337: *---------------------------------------------------------------------*/
3338: PROCEDURE failDocsOfPayment(
3339: p_paymentId IN IBY_PAYMENTS_ALL.payment_id%TYPE,
3340: p_docStatus IN IBY_DOCS_PAYABLE_ALL.
3341: document_status%TYPE,
3342: x_docErrorTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.docErrorTabType,
3343: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
3344: );