[Home] [Help]
487: fnd_global.conc_request_id));
488:
489: IF (p_mode = 'RECORD') THEN
490:
491: INSERT INTO ar_reviewed_lines_gt
492: (
493: customer_trx_line_id,
494: customer_trx_id,
495: amount_due_original,
535: debug('acceptance rows inserted: ' || SQL%ROWCOUNT);
536:
537: ELSE
538:
539: INSERT INTO ar_reviewed_lines_gt
540: (
541: customer_trx_line_id,
542: customer_trx_id,
543: amount_due_original,
615:
616: l_request_id := nvl(p_customer_trx_line_id, nvl(p_customer_trx_id,
617: fnd_global.conc_request_id));
618:
619: INSERT INTO ar_reviewed_lines_gt
620: (
621: customer_trx_line_id,
622: customer_trx_id,
623: amount_due_original,
649: AND dl.customer_trx_line_id = nvl(p_customer_trx_line_id,
650: dl.customer_trx_line_id)
651: AND NOT EXISTS
652: ( SELECT 'already inserted'
653: FROM ar_reviewed_lines_gt rl
654: WHERE rl.customer_trx_line_id = dl.customer_trx_line_id);
655:
656: debug('no contingency rows inserted: ' || SQL%ROWCOUNT);
657:
702: does not match the ONT_SOURCE_CODE profile */
703:
704: /* 5229211 - Added code to populate so_line_id */
705:
706: INSERT INTO ar_reviewed_lines_gt
707: (
708: customer_trx_line_id,
709: customer_trx_id,
710: amount_due_original,
730: 'CHILD',
731: l_request_id,
732: child_line.interface_line_attribute6,
733: max(lc.expiration_date)
734: FROM ar_reviewed_lines_gt parent,
735: ra_customer_trx_lines parent_line,
736: ar_deferred_lines child,
737: ra_customer_trx_lines child_line,
738: ar_line_conts lc,
793: fnd_global.conc_request_id));
794:
795: IF p_mode = 'NORMAL' THEN
796:
797: INSERT INTO ar_reviewed_lines_gt
798: (
799: customer_trx_line_id,
800: customer_trx_id,
801: amount_due_original,
835: AND dl.customer_trx_line_id = nvl(p_customer_trx_line_id,
836: dl.customer_trx_line_id)
837: AND NOT EXISTS
838: ( SELECT 'already inserted'
839: FROM ar_reviewed_lines_gt rl
840: WHERE rl.customer_trx_line_id = dl.customer_trx_line_id)
841: GROUP BY dl.customer_trx_line_id;
842:
843: ELSE
841: GROUP BY dl.customer_trx_line_id;
842:
843: ELSE
844:
845: INSERT INTO ar_reviewed_lines_gt
846: (
847: customer_trx_line_id,
848: customer_trx_id,
849: amount_due_original,
910: CURSOR rev_lines (p_req_id NUMBER) IS
911: SELECT rl.customer_trx_line_id,
912: rl.customer_trx_id,
913: rl.so_line_id
914: FROM ar_reviewed_lines_gt rl,
915: ra_customer_trx_lines tl
916: WHERE rl.request_id = p_req_id
917: AND tl.customer_trx_line_id = rl.customer_trx_line_id
918: AND tl.customer_trx_id = rl.customer_trx_id
5269: amount_recognized,
5270: acctd_amount_recognized,
5271: amount_pending,
5272: acctd_amount_pending
5273: FROM ar_reviewed_lines_gt
5274: WHERE request_id = nvl(p_customer_trx_line_id, -- 7328069
5275: nvl(p_customer_trx_id,
5276: request_id));
5277:
5637: END LOOP;
5638:
5639: END LOOP;
5640:
5641: -- it is possible that there are no rows in ar_reviewed_lines_gt
5642: -- in that no revenue will be recognized.
5643: IF (x_first_adjustment_number IS NULL) AND
5644: (x_last_adjustment_number IS NULL) THEN
5645: x_scenario := c_not_recognized;
5739: MAX(acctd_amount_recognized),
5740: MAX(amount_pending),
5741: MAX(acctd_amount_pending),
5742: MAX(expiration_date)
5743: FROM ar_reviewed_lines_gt
5744: WHERE request_id = p_request_id
5745: GROUP BY customer_trx_line_id;
5746:
5747: /*Bug 4675710 */
5792: delete from ar_rdr_parameters_gt;
5793: delete from ar_trx_errors_gt;
5794: delete from ar_trx_header_gt;
5795: delete from ar_trx_lines_gt;
5796: delete from ar_reviewed_lines_gt;
5797: delete from fun_rule_bulk_result_gt;
5798: delete from ar_trx_contingencies_gt;
5799:
5800: populate_acceptance_rows;