APPS.ZX_SRVC_TYP_PKG dependencies on ZX_PTNR_LOCATION_INFO_GT

Line 5596: DELETE from ZX_PTNR_LOCATION_INFO_GT;

5592:
5593: DELETE from ZX_TRX_PRE_PROC_OPTIONS_GT;
5594: DELETE from ZX_PRVDR_HDR_EXTNS_GT;
5595: DELETE from ZX_PRVDR_LINE_EXTNS_GT;
5596: DELETE from ZX_PTNR_LOCATION_INFO_GT;
5597:
5598: delete_ptnr_location_tbl;
5599:
5600: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 7088: INSERT INTO ZX_PTNR_LOCATION_INFO_GT

7084: --------------------------------------------------------------------------------------
7085: -- Bulk inserting the record of tables into the global temp table
7086: --------------------------------------------------------------------------------------
7087: FORALL i IN nvl(l_ptnr_loc_tbl.trx_id.FIRST,0) .. nvl(l_ptnr_loc_tbl.trx_id.LAST,-99)
7088: INSERT INTO ZX_PTNR_LOCATION_INFO_GT
7089: (EVENT_CLASS_MAPPING_ID ,
7090: TRX_ID ,
7091: TRX_LINE_ID ,
7092: TRX_LEVEL_TYPE ,

Line 7458: -- Need to insert records in table ZX_PTNR_LOCATION_INFO_GT into the global temp table

7454: ZX_GLOBAL_STRUCTURES_PKG.g_ptnr_srvc_subscr_flag := 'Y';
7455: END IF;
7456:
7457: --------------------------------------------------------------------------------------
7458: -- Need to insert records in table ZX_PTNR_LOCATION_INFO_GT into the global temp table
7459: --------------------------------------------------------------------------------------
7460: BEGIN
7461: SELECT 'Y'
7462: INTO l_record_exists

Line 7463: FROM ZX_PTNR_LOCATION_INFO_GT zpli

7459: --------------------------------------------------------------------------------------
7460: BEGIN
7461: SELECT 'Y'
7462: INTO l_record_exists
7463: FROM ZX_PTNR_LOCATION_INFO_GT zpli
7464: WHERE zpli.event_class_mapping_id = ptnr_del_lines.event_class_mapping_id
7465: AND zpli.trx_id = ptnr_del_lines.trx_id
7466: AND zpli.trx_line_id = ptnr_del_lines.trx_line_id
7467: AND zpli.trx_level_type = ptnr_del_lines.trx_level_type;

Line 7470: INSERT INTO ZX_PTNR_LOCATION_INFO_GT

7466: AND zpli.trx_line_id = ptnr_del_lines.trx_line_id
7467: AND zpli.trx_level_type = ptnr_del_lines.trx_level_type;
7468: EXCEPTION
7469: WHEN NO_DATA_FOUND THEN
7470: INSERT INTO ZX_PTNR_LOCATION_INFO_GT
7471: (EVENT_CLASS_MAPPING_ID,
7472: TRX_ID,
7473: TRX_LINE_ID,
7474: TRX_LEVEL_TYPE