DBA Data[Home] [Help]

APPS.ICX_CAT_R12_UPGRADE_PVT dependencies on ICX_CAT_R12_UPGRADE_PVT

Line 1: PACKAGE BODY ICX_CAT_R12_UPGRADE_PVT AS

1: PACKAGE BODY ICX_CAT_R12_UPGRADE_PVT AS
2: /* $Header: ICXV12UB.pls 120.24.12010000.2 2008/08/02 14:38:35 kkram ship $*/
3:
4: -----------------------------------------------------------
5: -- Global variables --

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ICX_CAT_R12_UPGRADE_PVT';

4: -----------------------------------------------------------
5: -- Global variables --
6: -----------------------------------------------------------
7: -- Constants
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ICX_CAT_R12_UPGRADE_PVT';
9: g_GBPA_hdr_count PLS_INTEGER := 0;
10: g_total_row_count PLS_INTEGER := 0;
11: g_PDOI_batch_id NUMBER;
12: g_interface_source_code po_headers_interface.interface_source_code%TYPE := 'CATALOG R12 UPGRADE';

Line 7962: -- ICX_CAT_R12_UPGRADE_PVT.runDataExcptnRptChildProcess;

7958: p_data_exception_job := fnd_request.submit_request
7959: (
7960: 'ICX', -- application
7961: 'ICXCUCDER', -- program
7962: -- ICX_CAT_R12_UPGRADE_PVT.runDataExcptnRptChildProcess;
7963: null, -- description
7964: NULL, -- start_time
7965: is_sub_request, -- sub_request (TRUE from pre-upgrade, FALSE from upgrade)
7966: ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id, -- p_parent_int_req_id

Line 8241: ICX_CAT_R12_UPGRADE_PVT.updateR12UpgradeJob(ICX_CAT_UTIL_PVT.g_job_complete_status);

8237: ICX_CAT_R12_DATA_EXCEP_RPT_PVT.process_data_exceptions_report(p_pdoi_batch_id);
8238:
8239: l_err_loc := 900;
8240: ICX_CAT_UTIL_PVT.g_job_complete_date := SYSDATE;
8241: ICX_CAT_R12_UPGRADE_PVT.updateR12UpgradeJob(ICX_CAT_UTIL_PVT.g_job_complete_status);
8242:
8243: l_err_loc := 1000;
8244: x_retcode := 0;
8245: x_errbuf := l_api_name ||' done';

Line 8381: END ICX_CAT_R12_UPGRADE_PVT;

8377: G_PKG_NAME, l_api_name,
8378: ' --> l_err_loc:' ||l_err_loc ||' '|| SQLERRM);
8379: END updateR12UpgradeJob;
8380:
8381: END ICX_CAT_R12_UPGRADE_PVT;