APPS.ZX_SRVC_TYP_PKG dependencies on ZX_PTNR_LOCATION_INFO_GT

Line 4769: DELETE from ZX_PTNR_LOCATION_INFO_GT;

4765:
4766: DELETE from ZX_TRX_PRE_PROC_OPTIONS_GT;
4767: DELETE from ZX_PRVDR_HDR_EXTNS_GT;
4768: DELETE from ZX_PRVDR_LINE_EXTNS_GT;
4769: DELETE from ZX_PTNR_LOCATION_INFO_GT;
4770:
4771: delete_ptnr_location_tbl;
4772:
4773: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 6250: INSERT INTO ZX_PTNR_LOCATION_INFO_GT

6246: --------------------------------------------------------------------------------------
6247: -- Bulk inserting the record of tables into the global temp table
6248: --------------------------------------------------------------------------------------
6249: FORALL i IN nvl(l_ptnr_loc_tbl.trx_id.FIRST,0) .. nvl(l_ptnr_loc_tbl.trx_id.LAST,-99)
6250: INSERT INTO ZX_PTNR_LOCATION_INFO_GT
6251: (EVENT_CLASS_MAPPING_ID ,
6252: TRX_ID ,
6253: TRX_LINE_ID ,
6254: TRX_LEVEL_TYPE ,

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

6616: ZX_GLOBAL_STRUCTURES_PKG.g_ptnr_srvc_subscr_flag := 'Y';
6617: END IF;
6618:
6619: --------------------------------------------------------------------------------------
6620: -- Need to insert records in table ZX_PTNR_LOCATION_INFO_GT into the global temp table
6621: --------------------------------------------------------------------------------------
6622: BEGIN
6623: SELECT 'Y'
6624: INTO l_record_exists

Line 6625: FROM ZX_PTNR_LOCATION_INFO_GT zpli

6621: --------------------------------------------------------------------------------------
6622: BEGIN
6623: SELECT 'Y'
6624: INTO l_record_exists
6625: FROM ZX_PTNR_LOCATION_INFO_GT zpli
6626: WHERE zpli.event_class_mapping_id = ptnr_del_lines.event_class_mapping_id
6627: AND zpli.trx_id = ptnr_del_lines.trx_id
6628: AND zpli.trx_line_id = ptnr_del_lines.trx_line_id
6629: AND zpli.trx_level_type = ptnr_del_lines.trx_level_type;

Line 6632: INSERT INTO ZX_PTNR_LOCATION_INFO_GT

6628: AND zpli.trx_line_id = ptnr_del_lines.trx_line_id
6629: AND zpli.trx_level_type = ptnr_del_lines.trx_level_type;
6630: EXCEPTION
6631: WHEN NO_DATA_FOUND THEN
6632: INSERT INTO ZX_PTNR_LOCATION_INFO_GT
6633: (EVENT_CLASS_MAPPING_ID,
6634: TRX_ID,
6635: TRX_LINE_ID,
6636: TRX_LEVEL_TYPE