[Home] [Help]
251: | any setup and overflow documents.
252: |
253: | x_payment_id
254: | Payment id of the actual single payment. This value maps to
255: | IBY_PAYMENTS_ALL.payment_id.
256: |
257: | x_paper_doc_num
258: | Paper document number of the actual single payment. This could be
259: | a check number, for example.
398: l_profile_attribs IBY_DISBURSE_SUBMIT_PUB_PKG.profileProcessAttribs;
399: l_pmtInstrTab IBY_PAYINSTR_PUB.pmtInstrTabType;
400:
401: /* used to record manual payments */
402: l_pmt_rec IBY_PAYMENTS_ALL%ROWTYPE;
403: l_pmts_tab IBY_PAYGROUP_PUB.paymentTabType;
404: l_payment_id IBY_PAYMENTS_ALL.payment_id%TYPE;
405:
406: /* used to store access types for manual payment */
400:
401: /* used to record manual payments */
402: l_pmt_rec IBY_PAYMENTS_ALL%ROWTYPE;
403: l_pmts_tab IBY_PAYGROUP_PUB.paymentTabType;
404: l_payment_id IBY_PAYMENTS_ALL.payment_id%TYPE;
405:
406: /* used to store access types for manual payment */
407: l_process_func_rec IBY_PROCESS_FUNCTIONS%ROWTYPE;
408: l_process_org_rec IBY_PROCESS_ORGS%ROWTYPE;
450: SELECT
451: err.transaction_error_id
452: FROM
453: IBY_TRANSACTION_ERRORS err,
454: IBY_PAYMENTS_ALL pmt,
455: IBY_PAY_SERVICE_REQUESTS prq
456: WHERE
457: err.transaction_id = pmt.payment_id AND
458: err.transaction_type = TRXN_TYPE_PMT AND
470: SELECT
471: err.transaction_error_id
472: FROM
473: IBY_TRANSACTION_ERRORS err,
474: IBY_PAYMENTS_ALL pmt,
475: IBY_PAY_INSTRUCTIONS_ALL ins,
476: IBY_PAY_SERVICE_REQUESTS prq
477: WHERE
478: err.transaction_id = ins.payment_instruction_id AND
1065:
1066: --l_pmts_tab(l_pmts_tab.COUNT) := l_pmt_rec;
1067:
1068: /*
1069: * Insert manual payment into IBY_PAYMENTS_ALL
1070: * table.
1071: */
1072: IBY_PAYGROUP_PUB.insertPayments;
1073:
2532: p_payreq_id IN IBY_PAY_SERVICE_REQUESTS.
2533: payment_service_request_id%TYPE,
2534: p_processing_type IN IBY_PAYMENT_PROFILES.processing_type%TYPE,
2535: x_num_printed_docs OUT NOCOPY NUMBER,
2536: x_payment_id OUT NOCOPY IBY_PAYMENTS_ALL.
2537: payment_id%TYPE,
2538: x_paper_doc_num OUT NOCOPY IBY_PAYMENTS_ALL.
2539: paper_document_number%TYPE,
2540: x_pmt_ref_num OUT NOCOPY IBY_PAYMENTS_ALL.
2534: p_processing_type IN IBY_PAYMENT_PROFILES.processing_type%TYPE,
2535: x_num_printed_docs OUT NOCOPY NUMBER,
2536: x_payment_id OUT NOCOPY IBY_PAYMENTS_ALL.
2537: payment_id%TYPE,
2538: x_paper_doc_num OUT NOCOPY IBY_PAYMENTS_ALL.
2539: paper_document_number%TYPE,
2540: x_pmt_ref_num OUT NOCOPY IBY_PAYMENTS_ALL.
2541: payment_reference_number%TYPE
2542: )
2536: x_payment_id OUT NOCOPY IBY_PAYMENTS_ALL.
2537: payment_id%TYPE,
2538: x_paper_doc_num OUT NOCOPY IBY_PAYMENTS_ALL.
2539: paper_document_number%TYPE,
2540: x_pmt_ref_num OUT NOCOPY IBY_PAYMENTS_ALL.
2541: payment_reference_number%TYPE
2542: )
2543: IS
2544:
2615: x_payment_id,
2616: x_pmt_ref_num,
2617: x_paper_doc_num
2618: FROM
2619: IBY_PAYMENTS_ALL pmt
2620: WHERE
2621: pmt.payment_service_request_id = p_payreq_id AND
2622: pmt.payment_status IN
2623: (
2686: x_payment_id,
2687: x_pmt_ref_num,
2688: x_paper_doc_num
2689: FROM
2690: IBY_PAYMENTS_ALL pmt
2691: WHERE
2692: pmt.payment_service_request_id = p_payreq_id AND
2693: pmt.payment_status = PMT_STATUS_INS_CREATED
2694: ;
2704: count(*)
2705: INTO
2706: x_num_printed_docs
2707: FROM
2708: IBY_PAYMENTS_ALL
2709: WHERE
2710: payment_service_request_id = p_payreq_id AND
2711: payment_status IN (
2712: PMT_STATUS_INS_CREATED,
2827: SELECT
2828: err.transaction_error_id
2829: FROM
2830: IBY_TRANSACTION_ERRORS err,
2831: IBY_PAYMENTS_ALL pmt,
2832: IBY_PAY_SERVICE_REQUESTS prq
2833: WHERE
2834: err.transaction_id = pmt.payment_id AND
2835: err.transaction_type = TRXN_TYPE_PMT AND
2847: SELECT
2848: err.transaction_error_id
2849: FROM
2850: IBY_TRANSACTION_ERRORS err,
2851: IBY_PAYMENTS_ALL pmt,
2852: IBY_PAY_INSTRUCTIONS_ALL ins,
2853: IBY_PAY_SERVICE_REQUESTS prq
2854: WHERE
2855: err.transaction_id = ins.payment_instruction_id AND