eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.AP_RETRO_PRICING_PKG dependencies on AP_PPA_INVOICE_DISTS_GT

Line 1005: INSERT INTO ap_ppa_invoice_dists_gt values l_ppa_invoice_dists_list(i);

1001: debug_info := 'Reverse_Existing_Ppa_Dists Step 3. Insert PPA Reversal '
1002: ||' Dists in the Global Temp Table';
1003: ------------------------------------------------------------------------
1004: FORALL i IN 1..l_ppa_invoice_dists_list.COUNT
1005: INSERT INTO ap_ppa_invoice_dists_gt values l_ppa_invoice_dists_list(i);
1006:
1007:
1008: ----------------------------------------------------------------------
1009: debug_info := 'Reverse_Existing_Ppa_Dists Step 4. Clear PL/SQL tables';

Line 1680: FROM ap_ppa_invoice_dists_gt

1676: PA_CC_AR_INVOICE_ID,
1677: PA_CC_AR_INVOICE_LINE_NUM,
1678: PA_CC_PROCESSED_CODE,
1679: pay_awt_group_id --bug6817107
1680: FROM ap_ppa_invoice_dists_gt
1681: WHERE invoice_id = p_adj_lines_rec.invoice_id
1682: AND invoice_line_number = p_adj_lines_rec.line_number
1683: AND line_type_lookup_code IN ('RETROEXPENSE', 'RETROACCRUAL', 'ERV')
1684: ORDER BY invoice_distribution_id;

Line 1769: INSERT INTO ap_ppa_invoice_dists_gt values l_ppa_invoice_dists_list(i);

1765: debug_info := 'Create_Adjustment_Corrections Step 5. Insert the Adj Dists in the'
1766: ||' Global Temp Table';
1767: ----------------------------------------------------------------------------
1768: FORALL i IN 1..l_ppa_invoice_dists_list.COUNT
1769: INSERT INTO ap_ppa_invoice_dists_gt values l_ppa_invoice_dists_list(i);
1770:
1771: ----------------------------------------------------------------------------
1772: debug_info := 'Create_Adjustment_Corrections Step 6. Update Related Id';
1773: ----------------------------------------------------------------------------

Line 1774: UPDATE ap_ppa_invoice_dists_gt d1

1770:
1771: ----------------------------------------------------------------------------
1772: debug_info := 'Create_Adjustment_Corrections Step 6. Update Related Id';
1773: ----------------------------------------------------------------------------
1774: UPDATE ap_ppa_invoice_dists_gt d1
1775: SET related_id = invoice_distribution_id
1776: WHERE invoice_id = l_ppa_lines_rec.invoice_id
1777: AND invoice_line_number = l_ppa_lines_rec.line_number
1778: AND related_id = ( SELECT related_id

Line 1779: FROM ap_ppa_invoice_dists_gt d2

1775: SET related_id = invoice_distribution_id
1776: WHERE invoice_id = l_ppa_lines_rec.invoice_id
1777: AND invoice_line_number = l_ppa_lines_rec.line_number
1778: AND related_id = ( SELECT related_id
1779: FROM ap_ppa_invoice_dists_gt d2
1780: WHERE d1.related_id = d2.related_id
1781: AND line_type_lookup_code = 'ERV');
1782:
1783: -------------------------------------------------------------------------

Line 2226: INSERT INTO ap_ppa_invoice_dists_gt values l_adj_dists_list(i);

2222: debug_info := 'Reverse_Redistribute_IPV Step 6. Insert the Adj Dists in '
2223: ||'the Global Temp Table ';
2224: -------------------------------------------------------------------------
2225: FORALL i IN 1..l_adj_dists_list.COUNT
2226: INSERT INTO ap_ppa_invoice_dists_gt values l_adj_dists_list(i);
2227: --
2228:
2229: -------------------------------------------------------------------------
2230: debug_info := 'Reverse_Redistribute_IPV Step 7. Clear PL/SQL tables';

Line 2681: INSERT INTO ap_ppa_invoice_dists_gt values l_tipv_adj_dists_list(i);

2677: debug_info := 'Reverse_Redistribute_TIPV Step 4. Insert the '
2678: ||'Adjustments in the Global Temp Table';
2679: --------------------------------------------------------------------------
2680: FORALL i IN 1..l_tipv_adj_dists_list.COUNT
2681: INSERT INTO ap_ppa_invoice_dists_gt values l_tipv_adj_dists_list(i);
2682:
2683: -------------------------------------------------------------------------
2684: debug_info := 'Reverse_Redistribute_TIPV Step 5. Clear PL/SQL tables';
2685: -------------------------------------------------------------------------

Line 3116: from ap_ppa_invoice_dists_gt

3112: l_ppa_invoice_dists_list(i).invoice_distribution_id := Null;
3113: l_ppa_invoice_dists_list(i).distribution_line_number := i;
3114: /*select max(distribution_line_number) + 1
3115: into l_ppa_invoice_dists_list(i).distribution_line_number
3116: from ap_ppa_invoice_dists_gt
3117: where invoice_id = l_ppa_lines_rec.invoice_id
3118: and invoice_line_number = l_ppa_lines_rec.line_number; */
3119: -- line_type_lookup_code = 'RETROITEM' for Price Corrections
3120: l_ppa_invoice_dists_list(i).line_type_lookup_code := AP_RETRO_PRICING_UTIL_PKG.get_dist_type_lookup_code(

Line 3211: INSERT INTO ap_ppa_invoice_dists_gt values l_ppa_invoice_dists_list(i);

3207: debug_info := 'Create_Po_Price_Adjustments Step 4. Insert the PPA Dists in'
3208: ||' the Global Temp Table';
3209: ---------------------------------------------------------------------------
3210: FORALL i IN 1..l_ppa_invoice_dists_list.COUNT
3211: INSERT INTO ap_ppa_invoice_dists_gt values l_ppa_invoice_dists_list(i);
3212:
3213: -------------------------------------------------------------------------
3214: debug_info := 'Create_Po_Price_Adjustments Step 5. Clear PL/SQL tables';
3215: -------------------------------------------------------------------------

Line 4530: FROM ap_ppa_invoice_dists_gt d,

4526: d.unit_price,
4527: 'N',
4528: nvl(d.created_by,5),
4529: SYSDATE
4530: FROM ap_ppa_invoice_dists_gt d,
4531: ap_ppa_invoice_lines_gt l
4532: WHERE d.instruction_id = p_instruction_id
4533: AND d.instruction_id = l.instruction_id
4534: AND d.invoice_id = l.invoice_id

Line 6209: FROM ap_ppa_invoice_dists_gt

6205: FND_GLOBAL.conc_program_id, --program_id,
6206: SYSDATE, --program_update_date,
6207: FND_GLOBAL.conc_request_id, --request_id,
6208: 'N' --rcv_charge_addition_flag
6209: FROM ap_ppa_invoice_dists_gt
6210: WHERE instruction_id = p_instruction_id
6211: AND invoice_id = l_ppa_invoice_id;
6212:
6213: -- Bug 5525506

Line 6382: FROM ap_ppa_invoice_dists_gt d,

6378:
6379: CURSOR po_shipments IS
6380: SELECT pd.line_location_id,
6381: SUM(d.amount)
6382: FROM ap_ppa_invoice_dists_gt d,
6383: ap_ppa_invoice_lines_gt l,
6384: po_distributions_all pd
6385: WHERE l.instruction_id = d.instruction_id
6386: AND l.adj_type = 'PPA'

Line 6399: FROM ap_ppa_invoice_dists_gt d,

6395: d.matched_uom_lookup_code,
6396: d.amount,
6397: FND_GLOBAL.conc_login_id,
6398: FND_GLOBAL.conc_request_id
6399: FROM ap_ppa_invoice_dists_gt d,
6400: ap_ppa_invoice_lines_gt l,
6401: po_distributions_all pd
6402: WHERE l.instruction_id = d.instruction_id
6403: AND l.adj_type = 'PPA'

Line 6784: ||'ap_ppa_invoice_dists_gt';

6780: WHERE invoice_id = l_invoice_id_list(i)
6781: AND instruction_id = p_instruction_rec.invoice_id;
6782:
6783: debug_info := 'Import_Retroprice_Adjustments 8.3. delete from '
6784: ||'ap_ppa_invoice_dists_gt';
6785: FORALL i IN l_invoice_id_list.FIRST..l_invoice_id_list.LAST
6786: DELETE FROM ap_ppa_invoice_dists_gt D
6787: WHERE invoice_id = l_invoice_id_list(i)
6788: AND instruction_id = p_instruction_rec.invoice_id;

Line 6786: DELETE FROM ap_ppa_invoice_dists_gt D

6782:
6783: debug_info := 'Import_Retroprice_Adjustments 8.3. delete from '
6784: ||'ap_ppa_invoice_dists_gt';
6785: FORALL i IN l_invoice_id_list.FIRST..l_invoice_id_list.LAST
6786: DELETE FROM ap_ppa_invoice_dists_gt D
6787: WHERE invoice_id = l_invoice_id_list(i)
6788: AND instruction_id = p_instruction_rec.invoice_id;
6789: --
6790: END IF;

Line 6987: FROM ap_ppa_invoice_dists_gt d,

6983: invoice_adjustment_flag = 'R'
6984: WHERE invoice_adjustment_flag = 'S'
6985: AND po_distribution_id IN (
6986: SELECT d.po_distribution_id
6987: FROM ap_ppa_invoice_dists_gt d,
6988: ap_ppa_invoice_lines_gt l
6989: WHERE l.instruction_id = d.instruction_id
6990: AND l.adj_type = 'PPA'
6991: AND d.instruction_id = p_instruction_rec.invoice_id