APPS.ZX_CORE_REP_EXTRACT_PKG dependencies on ZX_TCM_GEO_JUR_PKG

Line 866: l_location_type_tbl ZX_TCM_GEO_JUR_PKG.location_type_tbl_type;

862:
863: P_REPORT_NAME VARCHAR2(30);
864: P_REQUEST_ID NUMBER;
865: l_place_of_supply ZX_LINES.place_of_supply_type_code%type;
866: l_location_type_tbl ZX_TCM_GEO_JUR_PKG.location_type_tbl_type;
867: l_location_id_tbl ZX_TCM_GEO_JUR_PKG.location_id_tbl_type;
868: l_geo_val_found BOOLEAN;
869: x_return_status VARCHAR2(1);
870: prev_event_class_mapping_id NUMBER;

Line 867: l_location_id_tbl ZX_TCM_GEO_JUR_PKG.location_id_tbl_type;

863: P_REPORT_NAME VARCHAR2(30);
864: P_REQUEST_ID NUMBER;
865: l_place_of_supply ZX_LINES.place_of_supply_type_code%type;
866: l_location_type_tbl ZX_TCM_GEO_JUR_PKG.location_type_tbl_type;
867: l_location_id_tbl ZX_TCM_GEO_JUR_PKG.location_id_tbl_type;
868: l_geo_val_found BOOLEAN;
869: x_return_status VARCHAR2(1);
870: prev_event_class_mapping_id NUMBER;
871:

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

1094: BEGIN
1095:
1096: IF ( g_level_statement>= g_current_runtime_level ) THEN
1097: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1098: 'Before call to ZX_TCM_GEO_JUR_PKG.populate_loc_geography_info ');
1099: END IF;
1100:
1101: ZX_TCM_GEO_JUR_PKG.populate_loc_geography_info
1102: (l_event_class_mapping_id_tbl(i),

Line 1101: ZX_TCM_GEO_JUR_PKG.populate_loc_geography_info

1097: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1098: 'Before call to ZX_TCM_GEO_JUR_PKG.populate_loc_geography_info ');
1099: END IF;
1100:
1101: ZX_TCM_GEO_JUR_PKG.populate_loc_geography_info
1102: (l_event_class_mapping_id_tbl(i),
1103: l_trx_id_tbl(i),
1104: l_trx_line_id_tbl(i),
1105: l_trx_level_type_tbl(i),

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

1110: WHEN OTHERS THEN
1111: null;
1112: IF ( g_level_statement>= g_current_runtime_level ) THEN
1113: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1114: 'Error Message : ZX_TCM_GEO_JUR_PKG.populate_loc_geography_info : '||substrb(SQLERRM,1,120) );
1115: END IF;
1116: /*
1117: IF PG_DEBUG = 'Y' THEN
1118: l_err_msg := substrb(SQLERRM,1,120);