[Home] [Help]
1132:
1133: /*
1134: * There is no question of reviewing the payment for
1135: * single payments. Review payments flag is only
1136: * applicable to standard payments built by the
1137: * Build Program.
1138: *
1139: * Hardcode the review payments flag to 'N' for single
1140: * payments.
5867:
5868: /* moving the initalizePmts logic to this block, to avoid unnecessary looping through payments */
5869:
5870: x_paymentRec.payment_status := 'CREATED';
5871: x_paymentRec.process_type := 'STANDARD';
5872:
5873: /*
5874: * Fix for bug 5115270:
5875: *
6279: /* moving the initalizePmts logic to this block, to avoid unnecessary looping through payments */
6280:
6281: /*
6282: x_paymentRec.payment_status := 'CREATED';
6283: x_paymentRec.process_type := 'STANDARD';
6284: */
6285:
6286:
6287: IBY_PAYGROUP_PUB.pmtTable.payment_status(l_trx_pmt_index) :='CREATED';
6287: IBY_PAYGROUP_PUB.pmtTable.payment_status(l_trx_pmt_index) :='CREATED';
6288: IF(l_calling_app_procedure = 'IBY_DISBURSE_SINGLE_PMT_PKG') THEN
6289: IBY_PAYGROUP_PUB.pmtTable.process_type(l_trx_pmt_index) := 'IMMEDIATE';
6290: ELSE
6291: IBY_PAYGROUP_PUB.pmtTable.process_type(l_trx_pmt_index) := 'STANDARD';
6292: END IF;
6293: IBY_PAYGROUP_PUB.pmtTable.payments_complete_flag(l_trx_pmt_index) := 'N';
6294: IBY_PAYGROUP_PUB.pmtTable.bill_payable_flag(l_trx_pmt_index) :=nvl(iby_disburse_submit_pub_pkg.docspayTab.support_bills_payable_flag(p_trx_line_index),'N');
6295:
6576: IBY_PAYGROUP_PUB.pmtTable.payment_status(l_trx_pmt_index) := 'CREATED';
6577: IF(l_calling_app_procedure = 'IBY_DISBURSE_SINGLE_PMT_PKG') THEN
6578: IBY_PAYGROUP_PUB.pmtTable.process_type(l_trx_pmt_index) := 'IMMEDIATE';
6579: ELSE
6580: IBY_PAYGROUP_PUB.pmtTable.process_type(l_trx_pmt_index) := 'STANDARD';
6581: END IF;
6582:
6583: /*
6584: * Fix for bug 5115270:
6922: := p_paymentTab(i).payment_method_code;
6923: paymentTab.payment_service_request_id(i)
6924: := p_paymentTab(i).payment_service_request_id;
6925: paymentTab.process_type(i)
6926: := NVL(p_paymentTab(i).process_type, 'STANDARD');
6927: paymentTab.payment_status(i)
6928: := NVL(p_paymentTab(i).payment_status, 'CREATED');
6929: paymentTab.payments_complete_flag(i)
6930: := NVL(p_paymentTab(i).payments_complete_flag, 'N');
19236: | DBMS_XMLGEN is a built-in package in C. It is fast. However,
19237: | it is supported only in Oracle 9i and above.
19238: |
19239: | 2. SQLX
19240: | This is the new emerging standard for SQL -> XML.
19241: | It is both fast and easy. However, only Oracle 9i and
19242: | above.
19243: |
19244: *---------------------------------------------------------------------*/
22301:
22302: FOR i IN x_paymentTab.FIRST .. x_paymentTab.LAST LOOP
22303:
22304: x_paymentTab(i).payment_status := 'CREATED';
22305: x_paymentTab(i).process_type := 'STANDARD';
22306:
22307: /*
22308: * Fix for bug 5115270:
22309: *
26884: IBY_PAYGROUP_PUB.pmtTable.uri_check_digit(l_trx_pmt_index) := NULL;
26885: IBY_PAYGROUP_PUB.pmtTable.payment_id(l_trx_pmt_index) := NULL;
26886: IBY_PAYGROUP_PUB.pmtTable.payment_details(l_trx_pmt_index) := NULL;
26887: IBY_PAYGROUP_PUB.pmtTable.payment_status(l_trx_pmt_index) :='CREATED';
26888: IBY_PAYGROUP_PUB.pmtTable.process_type(l_trx_pmt_index) := 'STANDARD';
26889: IBY_PAYGROUP_PUB.pmtTable.payments_complete_flag(l_trx_pmt_index) := 'N';
26890: IBY_PAYGROUP_PUB.pmtTable.exclusive_payment_flag(l_trx_pmt_index) :='N';
26891: IBY_PAYGROUP_PUB.pmtTable.declare_payment_flag(l_trx_pmt_index) :='N';
26892: IBY_PAYGROUP_PUB.pmtTable.created_by(l_trx_pmt_index) := fnd_global.user_id;