APPS.AP_LINES_UPGRADE_PKG dependencies on AP_INVOICES_UPG_CONTROL

Line 2539: /* Inserting into the ap_invoices_upg_control table information

2535: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
2536: END IF;
2537:
2538:
2539: /* Inserting into the ap_invoices_upg_control table information
2540: about the Transaction Upgrade Subworkers that have been
2541: submitted from the Main program */
2542: INSERT INTO ap_invoices_upg_control
2543: (Module_Name,

Line 2542: INSERT INTO ap_invoices_upg_control

2538:
2539: /* Inserting into the ap_invoices_upg_control table information
2540: about the Transaction Upgrade Subworkers that have been
2541: submitted from the Main program */
2542: INSERT INTO ap_invoices_upg_control
2543: (Module_Name,
2544: Sub_Module,
2545: Upgrade_Phase,
2546: Start_Date,

Line 2652: UPDATE ap_invoices_upg_control

2648: END IF;
2649:
2650: END LOOP;
2651:
2652: UPDATE ap_invoices_upg_control
2653: SET end_date = sysdate
2654: WHERE parent_request_id = p_parent_request_id
2655: AND request_id = l_request_id;
2656:

Line 2747: Truncate_Table('AP_INVOICES_UPG_CONTROL');

2743: IF p_force_upgrade = 'Y' THEN
2744:
2745: Truncate_Table('AP_INV_DISTS_UPDATE');
2746: Truncate_Table('AP_INVOICE_LINES_ALL');
2747: Truncate_Table('AP_INVOICES_UPG_CONTROL');
2748:
2749: ad_parallel_updates_pkg.delete_update_information
2750: (ad_parallel_updates_pkg.ROWID_RANGE,
2751: l_table_owner,

Line 2761: FROM ap_invoices_upg_control

2757:
2758: /* Getting the previous run information for this program */
2759: SELECT count(*), max(end_date)
2760: INTO l_control_count, l_end_date
2761: FROM ap_invoices_upg_control
2762: WHERE module_name = 'TRANSACTION_UPGRADE_MAIN';
2763:
2764:
2765: IF l_control_count = 1 and l_end_date IS NULL THEN

Line 2778: l_debug_info := 'Inserting record in the ap_invoices_upg_control table';

2774: EXECUTE IMMEDIATE 'ALTER TRIGGER ap_invoice_distributions_aiud ENABLE';
2775: EXECUTE IMMEDIATE 'ALTER TRIGGER ap_chrg_allocations_aiud ENABLE';
2776:
2777:
2778: l_debug_info := 'Inserting record in the ap_invoices_upg_control table';
2779: IF g_debug_flag = 'Y' THEN
2780: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
2781: END IF;
2782:

Line 2783: /* Inserting into ap_invoices_upg_control table information about the

2779: IF g_debug_flag = 'Y' THEN
2780: AP_Debug_Pkg.Print(g_debug_flag, l_debug_info);
2781: END IF;
2782:
2783: /* Inserting into ap_invoices_upg_control table information about the
2784: Main program so as to track the progress of the upgrade */
2785: INSERT INTO ap_invoices_upg_control
2786: (Module_Name,
2787: Sub_Module,

Line 2785: INSERT INTO ap_invoices_upg_control

2781: END IF;
2782:
2783: /* Inserting into ap_invoices_upg_control table information about the
2784: Main program so as to track the progress of the upgrade */
2785: INSERT INTO ap_invoices_upg_control
2786: (Module_Name,
2787: Sub_Module,
2788: Upgrade_Phase,
2789: Start_Date,

Line 2955: FROM ap_invoices_upg_control

2951:
2952:
2953: SELECT count(*)
2954: INTO l_failed_count
2955: FROM ap_invoices_upg_control
2956: WHERE parent_request_id = g_parent_request_id
2957: AND end_date IS NULL;
2958:
2959: IF l_failed_count = 0 THEN

Line 2961: UPDATE ap_invoices_upg_control

2957: AND end_date IS NULL;
2958:
2959: IF l_failed_count = 0 THEN
2960:
2961: UPDATE ap_invoices_upg_control
2962: SET end_date = sysdate
2963: WHERE module_name = 'TRANSACTION_UPGRADE_MAIN'
2964: AND request_id = FND_GLOBAL.conc_request_id;
2965: