APPS.AP_LINES_UPGRADE_PKG dependencies on AP_LINE_TEMP_GT

Line 1987: AP_Line_Temp_GT Line,

1983: 'N' RCV_Charge_Addition_Flag
1984: FROM AP_Invoices_ALL AI,
1985: AP_Dist_Line_GT AID,
1986: AP_Tax_Alloc_Amount_GT ACA,
1987: AP_Line_Temp_GT Line,
1988: PO_Distributions_All POD --13444893
1989: WHERE AI.Invoice_ID = AID.Invoice_ID
1990: AND AID.Line_Type_Lookup_Code IN ('ITEM', 'PREPAY', 'AWT', 'ICMS',
1991: 'IPI', 'FREIGHT', 'MISCELLANEOUS')

Line 2423: AP_Line_Temp_GT Line,

2419: AID.Base_Amount,
2420: AID.Tax_Recovery_Rate,
2421: AID.Set_Of_Books_ID
2422: ) ALLOC,
2423: AP_Line_Temp_GT Line,
2424: AP_Tax_Alloc_Amount_GT TAA2 --8608129
2425: WHERE AI.Invoice_ID = AID.Invoice_ID
2426: AND NVL(AI.Org_ID,-99) = NVL(ASP.Org_ID,-99)
2427: AND AI.Invoice_Currency_Code = FC.Currency_Code

Line 2640: INSERT INTO AP_Line_Temp_GT (Line_Type)

2636: DECODE(p_upgrade_mode, 'PRE-UPGRADE', l_request_id, NULL));
2637:
2638:
2639: FORALL i IN linetype.FIRST..linetype.LAST
2640: INSERT INTO AP_Line_Temp_GT (Line_Type)
2641: VALUES (linetype(i));
2642:
2643: IF (FND_INSTALLATION.GET_APP_INFO('SQLAP', l_status, l_industry, l_table_owner)) THEN
2644: NULL;

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

2883: not completed successfully during the previous run then we will perform
2884: the upgrade */
2885: IF l_control_count = 0 OR l_end_date IS NULL THEN
2886:
2887: l_debug_info := 'Inserting into AP_Line_Temp_GT table';
2888: IF g_debug_flag = 'Y' THEN
2889: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
2890: END IF;
2891:

Line 2893: INSERT INTO AP_Line_Temp_GT (Line_Type)

2889: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
2890: END IF;
2891:
2892: FORALL i IN linetype.FIRST..linetype.LAST
2893: INSERT INTO AP_Line_Temp_GT (Line_Type)
2894: VALUES (linetype(i));
2895:
2896: /* When the program is run in pre-upgrade mode it is submitted from
2897: the concurrent program and hence we need to spawn multiple child