DBA Data[Home] [Help]

APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on ZX_TCM_GEO_JUR_PKG

Line 1377: l_location_type_tbl ZX_TCM_GEO_JUR_PKG.location_type_tbl_type;

1373: P_REPORT_NAME VARCHAR2(30);
1374: P_POSTING_STATUS VARCHAR2(30);
1375: P_REQUEST_ID NUMBER;
1376: l_place_of_supply ZX_LINES.place_of_supply_type_code%type;
1377: l_location_type_tbl ZX_TCM_GEO_JUR_PKG.location_type_tbl_type;
1378: l_location_id_tbl ZX_TCM_GEO_JUR_PKG.location_id_tbl_type;
1379: l_geo_val_found BOOLEAN;
1380: x_return_status VARCHAR2(1);
1381: prev_event_class_mapping_id NUMBER;

Line 1378: l_location_id_tbl ZX_TCM_GEO_JUR_PKG.location_id_tbl_type;

1374: P_POSTING_STATUS VARCHAR2(30);
1375: P_REQUEST_ID NUMBER;
1376: l_place_of_supply ZX_LINES.place_of_supply_type_code%type;
1377: l_location_type_tbl ZX_TCM_GEO_JUR_PKG.location_type_tbl_type;
1378: l_location_id_tbl ZX_TCM_GEO_JUR_PKG.location_id_tbl_type;
1379: l_geo_val_found BOOLEAN;
1380: x_return_status VARCHAR2(1);
1381: prev_event_class_mapping_id NUMBER;
1382:

Line 2372: 'Before call to ZX_TCM_GEO_JUR_PKG.populate_loc_geography_info ');

2368: BEGIN
2369:
2370: IF ( g_level_statement>= g_current_runtime_level ) THEN
2371: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2372: 'Before call to ZX_TCM_GEO_JUR_PKG.populate_loc_geography_info ');
2373: END IF;
2374:
2375: ZX_TCM_GEO_JUR_PKG.populate_loc_geography_info
2376: (l_event_class_mapping_id_tbl(i),

Line 2375: ZX_TCM_GEO_JUR_PKG.populate_loc_geography_info

2371: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2372: 'Before call to ZX_TCM_GEO_JUR_PKG.populate_loc_geography_info ');
2373: END IF;
2374:
2375: ZX_TCM_GEO_JUR_PKG.populate_loc_geography_info
2376: (l_event_class_mapping_id_tbl(i),
2377: l_trx_id_tbl(i),
2378: l_trx_line_id_tbl(i),
2379: l_trx_level_type_tbl(i),

Line 2388: 'Error Message : ZX_TCM_GEO_JUR_PKG.populate_loc_geography_info : '||substrb(SQLERRM,1,120) );

2384: WHEN OTHERS THEN
2385: null;
2386: IF ( g_level_statement>= g_current_runtime_level ) THEN
2387: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
2388: 'Error Message : ZX_TCM_GEO_JUR_PKG.populate_loc_geography_info : '||substrb(SQLERRM,1,120) );
2389: END IF;
2390: /*
2391: IF PG_DEBUG = 'Y' THEN
2392: l_err_msg := substrb(SQLERRM,1,120);