APPS.AP_XLA_UPGRADE_PKG dependencies on AP_INVOICES_UPG_CONTROL

Line 1782: FROM ap_invoices_upg_control

1778:
1779: BEGIN
1780: SELECT sub_module
1781: INTO l_inv_script_name
1782: FROM ap_invoices_upg_control
1783: WHERE module_name = 'SLA_ONDEMAND_INV_UPGRADE'
1784: AND end_date IS NULL;
1785:
1786: AP_Debug_Pkg.Print('Y', 'Existing script name for invoices '||l_inv_script_name);

Line 1793: INSERT INTO ap_invoices_upg_control

1789:
1790: l_inv_script_name := 'apidstln.sql'||l_batch_id;
1791: AP_Debug_Pkg.Print('Y', 'New script name for invoices '||l_inv_script_name);
1792:
1793: INSERT INTO ap_invoices_upg_control
1794: (Module_Name,
1795: Sub_Module,
1796: Upgrade_Phase,
1797: Start_Date,

Line 1825: FROM ap_invoices_upg_control

1821:
1822: BEGIN
1823: SELECT sub_module
1824: INTO l_pay_script_name
1825: FROM ap_invoices_upg_control
1826: WHERE module_name = 'SLA_ONDEMAND_PAY_UPGRADE'
1827: AND end_date IS NULL;
1828:
1829: AP_Debug_Pkg.Print('Y', 'Existing script name for payments '||l_pay_script_name);

Line 1836: INSERT INTO ap_invoices_upg_control

1832:
1833: l_pay_script_name := 'appdstln.sql'||l_batch_id;
1834: AP_Debug_Pkg.Print('Y', 'New script name for payments '||l_pay_script_name);
1835:
1836: INSERT INTO ap_invoices_upg_control
1837: (Module_Name,
1838: Sub_Module,
1839: Upgrade_Phase,
1840: Start_Date,

Line 1959: UPDATE AP_Invoices_Upg_Control

1955: RAISE l_gps_update_error;
1956: END IF;
1957: END IF;
1958:
1959: UPDATE AP_Invoices_Upg_Control
1960: SET End_Date = Sysdate
1961: WHERE Module_Name IN ('SLA_ONDEMAND_INV_UPGRADE', 'SLA_ONDEMAND_PAY_UPGRADE')
1962: AND Upgrade_Phase = 'AP_SLA_ONDEMAND'
1963: AND End_Date IS NULL;