APPS.AP_LINES_UPGRADE_PKG dependencies on AP_LINE_TEMP_GT

Line 1886: AP_Line_Temp_GT Line

1882: 'N' RCV_Charge_Addition_Flag
1883: FROM AP_Invoices_ALL AI,
1884: AP_Dist_Line_GT AID,
1885: AP_Tax_Alloc_Amount_GT ACA,
1886: AP_Line_Temp_GT Line
1887: WHERE AI.Invoice_ID = AID.Invoice_ID
1888: AND AID.Line_Type_Lookup_Code IN ('ITEM', 'PREPAY', 'AWT', 'ICMS',
1889: 'IPI', 'FREIGHT', 'MISCELLANEOUS')
1890: AND AID.Invoice_Distribution_ID = ACA.Old_Dist_ID (+)

Line 2336: AP_Line_Temp_GT Line

2332: AID.Base_Amount,
2333: AID.Tax_Recovery_Rate,
2334: AID.Set_Of_Books_ID
2335: ) ALLOC,
2336: AP_Line_Temp_GT Line
2337: WHERE AI.Invoice_ID = AID.Invoice_ID
2338: AND NVL(AI.Org_ID,-99) = NVL(ASP.Org_ID,-99)
2339: AND AI.Invoice_Currency_Code = FC.Currency_Code
2340: AND AID.Line_Type_Lookup_Code = 'TAX'

Line 2575: INSERT INTO AP_Line_Temp_GT (Line_Type)

2571: DECODE(p_upgrade_mode, 'PRE-UPGRADE', l_request_id, NULL));
2572:
2573:
2574: FORALL i IN linetype.FIRST..linetype.LAST
2575: INSERT INTO AP_Line_Temp_GT (Line_Type)
2576: VALUES (linetype(i));
2577:
2578: IF (FND_INSTALLATION.GET_APP_INFO('SQLAP', l_status, l_industry, l_table_owner)) THEN
2579: NULL;

Line 2822: l_debug_info := 'Inserting into AP_Line_Temp_GT table';

2818: not completed successfully during the previous run then we will perform
2819: the upgrade */
2820: IF l_control_count = 0 OR l_end_date IS NULL THEN
2821:
2822: l_debug_info := 'Inserting into AP_Line_Temp_GT table';
2823: IF g_debug_flag = 'Y' THEN
2824: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
2825: END IF;
2826:

Line 2828: INSERT INTO AP_Line_Temp_GT (Line_Type)

2824: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
2825: END IF;
2826:
2827: FORALL i IN linetype.FIRST..linetype.LAST
2828: INSERT INTO AP_Line_Temp_GT (Line_Type)
2829: VALUES (linetype(i));
2830:
2831: /* When the program is run in pre-upgrade mode it is submitted from
2832: the concurrent program and hence we need to spawn multiple child