[Home] [Help]
3084: | NOTES : None |
3085: | 12-Aug-2008 Pmarada bug Added code for OPM Financials to support AP PO |
3086: | reconciliation in R12, bug6995413 |
3087: | 21-nov-2008 pmarada, bug7516621, added nvl to the inventory_item_id in |
3088: | insert cst_reconciliation_gtt where clause, for expanse PO |
3089: +===========================================================================*/
3090:
3091: Procedure Load_ap_po_data(p_operating_unit IN VARCHAR2,
3092: p_from_date IN DATE,
3261: xla_security_pkg.set_security_context(p_application_id => 707);
3262:
3263: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
3264:
3265: INSERT into cst_reconciliation_gtt
3266: (
3267: Transaction_date,
3268: Amount,
3269: Entered_amount,
3379: xla_security_pkg.set_security_context(p_application_id => 555);
3380:
3381: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
3382:
3383: INSERT into cst_reconciliation_gtt
3384: (
3385: Transaction_date,
3386: Amount,
3387: Entered_amount,
3510:
3511: debug(' Inserting the AP data into the accrual table');
3512: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
3513:
3514: Insert into cst_reconciliation_gtt
3515: (
3516: transaction_date,
3517: Amount,
3518: Entered_amount,
3626: debug(' Inserting the write off data into the accrual table');
3627:
3628: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
3629:
3630: Insert into cst_reconciliation_gtt
3631: (
3632: transaction_date,
3633: amount,
3634: entered_amount,
3710:
3711: /* There will be a hint added to force the GTT to use the index. This is required as the
3712: Temp table is a global temp table */
3713:
3714: debug(' populating CRS from cst_reconciliation_gtt');
3715:
3716: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
3717:
3718: Insert into CST_RECONCILIATION_SUMMARY
3739: program_application_id,
3740: program_id,
3741: program_update_date
3742: )
3743: SELECT /*+ INDEX(gtt, cst_reconciliation_gtt_n1) */
3744: gtt.po_distribution_id,
3745: gtt.accrual_account_id,
3746: SUM(decode(gtt.invoice_distribution_id,
3747: NULL,Decode(gtt.write_off_id,
3792: l_request_id,
3793: l_program_application_id,
3794: l_program_id,
3795: l_program_update_date
3796: FROM cst_reconciliation_gtt gtt
3797: WHERE gtt.operating_unit_id = p_operating_unit
3798: AND gtt.po_distribution_id = po_dists_tab(indx)
3799: AND gtt.build_id = l_build_id
3800: AND gtt.request_id = FND_GLOBAL.CONC_REQUEST_ID
3835: )
3836: ) <> 0 ;
3837:
3838:
3839: debug(' Done Inserting the new data into CRS from cst_reconciliation_gtt');
3840:
3841: l_stmt_num := 80;
3842: debug(' l_stmt_num :' ||l_stmt_num);
3843:
3919: l_program_update_date,
3920: gtt.ae_header_id,
3921: gtt.ae_line_num
3922: FROM
3923: cst_reconciliation_gtt gtt
3924: WHERE gtt.operating_unit_id = p_operating_unit
3925: AND gtt.po_distribution_id = po_dists_tab(indx)
3926: AND EXISTS (
3927: SELECT 1