DBA Data[Home] [Help]

APPS.IBY_BUILD_UTILS_PKG dependencies on IBY_DOCS_PAYABLE_ALL

Line 8: profile_id IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE

4: --
5: -- Payment profile record
6: --
7: TYPE pmtProfRecType IS RECORD (
8: profile_id IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE
9: );
10:
11: --
12: -- Payment profiles table

Line 226: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,

222: |
223: *---------------------------------------------------------------------*/
224: PROCEDURE createErrorRecord(
225: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE,
226: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
227: p_doc_status IN IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
228: p_ca_id IN IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
229: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.
230: calling_app_doc_unique_ref1%TYPE,

Line 227: p_doc_status IN IBY_DOCS_PAYABLE_ALL.document_status%TYPE,

223: *---------------------------------------------------------------------*/
224: PROCEDURE createErrorRecord(
225: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE,
226: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
227: p_doc_status IN IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
228: p_ca_id IN IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
229: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.
230: calling_app_doc_unique_ref1%TYPE,
231: p_ca_doc_id2 IN IBY_DOCS_PAYABLE_ALL.

Line 228: p_ca_id IN IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,

224: PROCEDURE createErrorRecord(
225: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE,
226: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
227: p_doc_status IN IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
228: p_ca_id IN IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
229: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.
230: calling_app_doc_unique_ref1%TYPE,
231: p_ca_doc_id2 IN IBY_DOCS_PAYABLE_ALL.
232: calling_app_doc_unique_ref2%TYPE,

Line 229: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.

225: p_trxn_type IN IBY_TRANSACTION_ERRORS.transaction_type%TYPE,
226: p_doc_id IN IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE,
227: p_doc_status IN IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
228: p_ca_id IN IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
229: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.
230: calling_app_doc_unique_ref1%TYPE,
231: p_ca_doc_id2 IN IBY_DOCS_PAYABLE_ALL.
232: calling_app_doc_unique_ref2%TYPE,
233: p_ca_doc_id3 IN IBY_DOCS_PAYABLE_ALL.

Line 231: p_ca_doc_id2 IN IBY_DOCS_PAYABLE_ALL.

227: p_doc_status IN IBY_DOCS_PAYABLE_ALL.document_status%TYPE,
228: p_ca_id IN IBY_DOCS_PAYABLE_ALL.calling_app_id%TYPE,
229: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.
230: calling_app_doc_unique_ref1%TYPE,
231: p_ca_doc_id2 IN IBY_DOCS_PAYABLE_ALL.
232: calling_app_doc_unique_ref2%TYPE,
233: p_ca_doc_id3 IN IBY_DOCS_PAYABLE_ALL.
234: calling_app_doc_unique_ref3%TYPE,
235: p_ca_doc_id4 IN IBY_DOCS_PAYABLE_ALL.

Line 233: p_ca_doc_id3 IN IBY_DOCS_PAYABLE_ALL.

229: p_ca_doc_id1 IN IBY_DOCS_PAYABLE_ALL.
230: calling_app_doc_unique_ref1%TYPE,
231: p_ca_doc_id2 IN IBY_DOCS_PAYABLE_ALL.
232: calling_app_doc_unique_ref2%TYPE,
233: p_ca_doc_id3 IN IBY_DOCS_PAYABLE_ALL.
234: calling_app_doc_unique_ref3%TYPE,
235: p_ca_doc_id4 IN IBY_DOCS_PAYABLE_ALL.
236: calling_app_doc_unique_ref4%TYPE,
237: p_ca_doc_id5 IN IBY_DOCS_PAYABLE_ALL.

Line 235: p_ca_doc_id4 IN IBY_DOCS_PAYABLE_ALL.

231: p_ca_doc_id2 IN IBY_DOCS_PAYABLE_ALL.
232: calling_app_doc_unique_ref2%TYPE,
233: p_ca_doc_id3 IN IBY_DOCS_PAYABLE_ALL.
234: calling_app_doc_unique_ref3%TYPE,
235: p_ca_doc_id4 IN IBY_DOCS_PAYABLE_ALL.
236: calling_app_doc_unique_ref4%TYPE,
237: p_ca_doc_id5 IN IBY_DOCS_PAYABLE_ALL.
238: calling_app_doc_unique_ref5%TYPE,
239: p_pp_tt_cd IN IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

Line 237: p_ca_doc_id5 IN IBY_DOCS_PAYABLE_ALL.

233: p_ca_doc_id3 IN IBY_DOCS_PAYABLE_ALL.
234: calling_app_doc_unique_ref3%TYPE,
235: p_ca_doc_id4 IN IBY_DOCS_PAYABLE_ALL.
236: calling_app_doc_unique_ref4%TYPE,
237: p_ca_doc_id5 IN IBY_DOCS_PAYABLE_ALL.
238: calling_app_doc_unique_ref5%TYPE,
239: p_pp_tt_cd IN IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
240: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
241: x_docTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType,

Line 239: p_pp_tt_cd IN IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,

235: p_ca_doc_id4 IN IBY_DOCS_PAYABLE_ALL.
236: calling_app_doc_unique_ref4%TYPE,
237: p_ca_doc_id5 IN IBY_DOCS_PAYABLE_ALL.
238: calling_app_doc_unique_ref5%TYPE,
239: p_pp_tt_cd IN IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
240: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
241: x_docTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType,
242: p_rel_doc_id IN IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE
243: DEFAULT NULL, -- AWT Enh 16296267

Line 242: p_rel_doc_id IN IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE

238: calling_app_doc_unique_ref5%TYPE,
239: p_pp_tt_cd IN IBY_DOCS_PAYABLE_ALL.pay_proc_trxn_type_code%TYPE,
240: x_docErrorRec IN OUT NOCOPY IBY_TRANSACTION_ERRORS%ROWTYPE,
241: x_docTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType,
242: p_rel_doc_id IN IBY_DOCS_PAYABLE_ALL.calling_app_doc_ref_number%TYPE
243: DEFAULT NULL, -- AWT Enh 16296267
244: p_error_code IN VARCHAR2 DEFAULT NULL
245: );
246:

Line 297: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

293: | NOTES: Mark For Removal
294: |
295: *---------------------------------------------------------------------*/
296: PROCEDURE getProfListFromProfileDrivers(
297: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
298: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
299: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
300: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
301: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,

Line 298: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

294: |
295: *---------------------------------------------------------------------*/
296: PROCEDURE getProfListFromProfileDrivers(
297: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
298: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
299: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
300: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
301: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
302: x_profilesTab IN OUT NOCOPY pmtProfTabType

Line 299: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

295: *---------------------------------------------------------------------*/
296: PROCEDURE getProfListFromProfileDrivers(
297: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
298: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
299: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
300: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
301: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
302: x_profilesTab IN OUT NOCOPY pmtProfTabType
303: );

Line 300: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

296: PROCEDURE getProfListFromProfileDrivers(
297: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
298: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
299: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
300: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
301: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
302: x_profilesTab IN OUT NOCOPY pmtProfTabType
303: );
304:

Line 301: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,

297: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
298: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
299: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
300: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
301: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
302: x_profilesTab IN OUT NOCOPY pmtProfTabType
303: );
304:
305:

Line 328: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,

324: | NOTES:
325: |
326: *---------------------------------------------------------------------*/
327: PROCEDURE getProfListFromProfileDrivers(
328: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
329: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
330: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
331: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
332: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,

Line 329: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,

325: |
326: *---------------------------------------------------------------------*/
327: PROCEDURE getProfListFromProfileDrivers(
328: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
329: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
330: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
331: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
332: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
333: p_profile_id IN OUT NOCOPY IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,

Line 330: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,

326: *---------------------------------------------------------------------*/
327: PROCEDURE getProfListFromProfileDrivers(
328: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
329: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
330: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
331: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
332: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
333: p_profile_id IN OUT NOCOPY IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
334: p_valid_flag OUT NOCOPY VARCHAR2

Line 331: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,

327: PROCEDURE getProfListFromProfileDrivers(
328: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
329: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
330: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
331: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
332: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
333: p_profile_id IN OUT NOCOPY IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
334: p_valid_flag OUT NOCOPY VARCHAR2
335: );

Line 332: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,

328: p_pmt_method_cd IN IBY_DOCS_PAYABLE_ALL.payment_method_code%TYPE,
329: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
330: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
331: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
332: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
333: p_profile_id IN OUT NOCOPY IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
334: p_valid_flag OUT NOCOPY VARCHAR2
335: );
336:

Line 333: p_profile_id IN OUT NOCOPY IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,

329: p_org_id IN IBY_DOCS_PAYABLE_ALL.org_id%TYPE,
330: p_org_type IN IBY_DOCS_PAYABLE_ALL.org_type%TYPE,
331: p_pmt_currency IN IBY_DOCS_PAYABLE_ALL.payment_currency_code%TYPE,
332: p_int_bank_acct_id IN IBY_DOCS_PAYABLE_ALL.internal_bank_account_id%TYPE,
333: p_profile_id IN OUT NOCOPY IBY_DOCS_PAYABLE_ALL.payment_profile_id%TYPE,
334: p_valid_flag OUT NOCOPY VARCHAR2
335: );
336:
337: /*--------------------------------------------------------------------