APPS.AP_XLA_UPGRADE_PKG dependencies on AP_INVOICES_UPG_CONTROL

Line 2482: FROM ap_invoices_upg_control

2478:
2479: BEGIN
2480: SELECT sub_module
2481: INTO l_inv_script_name
2482: FROM ap_invoices_upg_control
2483: WHERE module_name = 'SLA_ONDEMAND_INV_UPGRADE'
2484: AND end_date IS NULL;
2485:
2486: AP_Debug_Pkg.Print('Y', 'Existing script name for invoices '||l_inv_script_name);

Line 2493: INSERT INTO ap_invoices_upg_control

2489:
2490: l_inv_script_name := 'apidstln.sql'||l_batch_id;
2491: AP_Debug_Pkg.Print('Y', 'New script name for invoices '||l_inv_script_name);
2492:
2493: INSERT INTO ap_invoices_upg_control
2494: (Module_Name,
2495: Sub_Module,
2496: Upgrade_Phase,
2497: Start_Date,

Line 2525: FROM ap_invoices_upg_control

2521:
2522: BEGIN
2523: SELECT sub_module
2524: INTO l_pay_script_name
2525: FROM ap_invoices_upg_control
2526: WHERE module_name = 'SLA_ONDEMAND_PAY_UPGRADE'
2527: AND end_date IS NULL;
2528:
2529: AP_Debug_Pkg.Print('Y', 'Existing script name for payments '||l_pay_script_name);

Line 2536: INSERT INTO ap_invoices_upg_control

2532:
2533: l_pay_script_name := 'appdstln.sql'||l_batch_id;
2534: AP_Debug_Pkg.Print('Y', 'New script name for payments '||l_pay_script_name);
2535:
2536: INSERT INTO ap_invoices_upg_control
2537: (Module_Name,
2538: Sub_Module,
2539: Upgrade_Phase,
2540: Start_Date,

Line 2660: UPDATE AP_Invoices_Upg_Control

2656: RAISE l_gps_update_error;
2657: END IF;
2658: END IF;
2659:
2660: UPDATE AP_Invoices_Upg_Control
2661: SET End_Date = Sysdate
2662: WHERE Module_Name IN ('SLA_ONDEMAND_INV_UPGRADE', 'SLA_ONDEMAND_PAY_UPGRADE')
2663: AND Upgrade_Phase = 'AP_SLA_ONDEMAND'
2664: AND End_Date IS NULL;