APPS.IBY_DISBURSE_SINGLE_PMT_PKG dependencies on IBY_PAYMENTS_ALL

Line 254: | IBY_PAYMENTS_ALL.payment_id.

250: | any setup and overflow documents.
251: |
252: | x_payment_id
253: | Payment id of the actual single payment. This value maps to
254: | IBY_PAYMENTS_ALL.payment_id.
255: |
256: | x_paper_doc_num
257: | Paper document number of the actual single payment. This could be
258: | a check number, for example.

Line 401: l_pmt_rec IBY_PAYMENTS_ALL%ROWTYPE;

397: l_profile_attribs IBY_DISBURSE_SUBMIT_PUB_PKG.profileProcessAttribs;
398: l_pmtInstrTab IBY_PAYINSTR_PUB.pmtInstrTabType;
399:
400: /* used to record manual payments */
401: l_pmt_rec IBY_PAYMENTS_ALL%ROWTYPE;
402: l_pmts_tab IBY_PAYGROUP_PUB.paymentTabType;
403: l_payment_id IBY_PAYMENTS_ALL.payment_id%TYPE;
404:
405: /* used to store access types for manual payment */

Line 403: l_payment_id IBY_PAYMENTS_ALL.payment_id%TYPE;

399:
400: /* used to record manual payments */
401: l_pmt_rec IBY_PAYMENTS_ALL%ROWTYPE;
402: l_pmts_tab IBY_PAYGROUP_PUB.paymentTabType;
403: l_payment_id IBY_PAYMENTS_ALL.payment_id%TYPE;
404:
405: /* used to store access types for manual payment */
406: l_process_func_rec IBY_PROCESS_FUNCTIONS%ROWTYPE;
407: l_process_org_rec IBY_PROCESS_ORGS%ROWTYPE;

Line 451: IBY_PAYMENTS_ALL pmt,

447: SELECT
448: err.transaction_error_id
449: FROM
450: IBY_TRANSACTION_ERRORS err,
451: IBY_PAYMENTS_ALL pmt,
452: IBY_PAY_SERVICE_REQUESTS prq
453: WHERE
454: err.transaction_id = pmt.payment_id AND
455: err.transaction_type = TRXN_TYPE_PMT AND

Line 471: IBY_PAYMENTS_ALL pmt,

467: SELECT
468: err.transaction_error_id
469: FROM
470: IBY_TRANSACTION_ERRORS err,
471: IBY_PAYMENTS_ALL pmt,
472: IBY_PAY_INSTRUCTIONS_ALL ins,
473: IBY_PAY_SERVICE_REQUESTS prq
474: WHERE
475: err.transaction_id = ins.payment_instruction_id AND

Line 991: * Insert manual payment into IBY_PAYMENTS_ALL

987:
988: l_pmts_tab(l_pmts_tab.COUNT) := l_pmt_rec;
989:
990: /*
991: * Insert manual payment into IBY_PAYMENTS_ALL
992: * table.
993: */
994: IBY_PAYGROUP_PUB.insertPayments(l_pmts_tab);
995:

Line 2305: x_payment_id OUT NOCOPY IBY_PAYMENTS_ALL.

2301: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
2302: payment_service_request_id%TYPE,
2303: p_processing_type IN IBY_PAYMENT_PROFILES.processing_type%TYPE,
2304: x_num_printed_docs OUT NOCOPY NUMBER,
2305: x_payment_id OUT NOCOPY IBY_PAYMENTS_ALL.
2306: payment_id%TYPE,
2307: x_paper_doc_num OUT NOCOPY IBY_PAYMENTS_ALL.
2308: paper_document_number%TYPE,
2309: x_pmt_ref_num OUT NOCOPY IBY_PAYMENTS_ALL.

Line 2307: x_paper_doc_num OUT NOCOPY IBY_PAYMENTS_ALL.

2303: p_processing_type IN IBY_PAYMENT_PROFILES.processing_type%TYPE,
2304: x_num_printed_docs OUT NOCOPY NUMBER,
2305: x_payment_id OUT NOCOPY IBY_PAYMENTS_ALL.
2306: payment_id%TYPE,
2307: x_paper_doc_num OUT NOCOPY IBY_PAYMENTS_ALL.
2308: paper_document_number%TYPE,
2309: x_pmt_ref_num OUT NOCOPY IBY_PAYMENTS_ALL.
2310: payment_reference_number%TYPE
2311: )

Line 2309: x_pmt_ref_num OUT NOCOPY IBY_PAYMENTS_ALL.

2305: x_payment_id OUT NOCOPY IBY_PAYMENTS_ALL.
2306: payment_id%TYPE,
2307: x_paper_doc_num OUT NOCOPY IBY_PAYMENTS_ALL.
2308: paper_document_number%TYPE,
2309: x_pmt_ref_num OUT NOCOPY IBY_PAYMENTS_ALL.
2310: payment_reference_number%TYPE
2311: )
2312: IS
2313:

Line 2376: IBY_PAYMENTS_ALL pmt

2372: INTO
2373: x_payment_id,
2374: x_pmt_ref_num
2375: FROM
2376: IBY_PAYMENTS_ALL pmt
2377: WHERE
2378: pmt.payment_service_request_id = p_payreq_id AND
2379: pmt.payment_status IN
2380: (

Line 2443: IBY_PAYMENTS_ALL pmt

2439: x_payment_id,
2440: x_pmt_ref_num,
2441: x_paper_doc_num
2442: FROM
2443: IBY_PAYMENTS_ALL pmt
2444: WHERE
2445: pmt.payment_service_request_id = p_payreq_id AND
2446: pmt.payment_status = PMT_STATUS_INS_CREATED
2447: ;

Line 2461: IBY_PAYMENTS_ALL

2457: count(*)
2458: INTO
2459: x_num_printed_docs
2460: FROM
2461: IBY_PAYMENTS_ALL
2462: WHERE
2463: payment_service_request_id = p_payreq_id AND
2464: payment_status IN (
2465: PMT_STATUS_INS_CREATED,

Line 2576: IBY_PAYMENTS_ALL pmt,

2572: SELECT
2573: err.transaction_error_id
2574: FROM
2575: IBY_TRANSACTION_ERRORS err,
2576: IBY_PAYMENTS_ALL pmt,
2577: IBY_PAY_SERVICE_REQUESTS prq
2578: WHERE
2579: err.transaction_id = pmt.payment_id AND
2580: err.transaction_type = TRXN_TYPE_PMT AND

Line 2596: IBY_PAYMENTS_ALL pmt,

2592: SELECT
2593: err.transaction_error_id
2594: FROM
2595: IBY_TRANSACTION_ERRORS err,
2596: IBY_PAYMENTS_ALL pmt,
2597: IBY_PAY_INSTRUCTIONS_ALL ins,
2598: IBY_PAY_SERVICE_REQUESTS prq
2599: WHERE
2600: err.transaction_id = ins.payment_instruction_id AND