APPS.IGS_OR_PRC_CWLK dependencies on IGS_OR_CWLK_INT

Line 40: l_status IGS_OR_CWLK_INT.Status%TYPE;

36: ***************************************************************** */
37: l_rowid VARCHAR2(25);
38: l_cwlk_id IGS_OR_CWLK.Crosswalk_Id%TYPE;
39: l_cwlk_dtl_id IGS_OR_CWLK_DTL.Crosswalk_Dtl_Id%TYPE;
40: l_status IGS_OR_CWLK_INT.Status%TYPE;
41: l_exception BOOLEAN := FALSE;
42: l_records_processed NUMBER(3);
43:
44: l_in_proc_alt_id igs_or_cwlk_dtl_int.alt_id_type%TYPE;

Line 47: -- Cursor for fetching the records from IGS_OR_CWLK_INT table

43:
44: l_in_proc_alt_id igs_or_cwlk_dtl_int.alt_id_type%TYPE;
45: l_in_proc_alt_value igs_or_cwlk_dtl_int.alt_id_value%TYPE;
46:
47: -- Cursor for fetching the records from IGS_OR_CWLK_INT table
48: -- based on the status passed as input
49: CURSOR cur_cwlk_int(cp_stat VARCHAR2) IS
50: SELECT *
51: FROM IGS_OR_CWLK_INT

Line 51: FROM IGS_OR_CWLK_INT

47: -- Cursor for fetching the records from IGS_OR_CWLK_INT table
48: -- based on the status passed as input
49: CURSOR cur_cwlk_int(cp_stat VARCHAR2) IS
50: SELECT *
51: FROM IGS_OR_CWLK_INT
52: WHERE status = cp_stat;
53:
54: -- Cursor for fetching the records from the Crosswalk Detail Interface
55: -- tables based on the Crosswalk Interface Id from the Crosswalk table

Line 56: CURSOR cur_cwlk_dtl_int(cp_cwlk_int_id IGS_OR_CWLK_INT.Interface_Crosswalk_Id%TYPE) IS

52: WHERE status = cp_stat;
53:
54: -- Cursor for fetching the records from the Crosswalk Detail Interface
55: -- tables based on the Crosswalk Interface Id from the Crosswalk table
56: CURSOR cur_cwlk_dtl_int(cp_cwlk_int_id IGS_OR_CWLK_INT.Interface_Crosswalk_Id%TYPE) IS
57: SELECT *
58: FROM IGS_OR_CWLK_DTL_INT
59: WHERE interface_crosswalk_id = cp_cwlk_int_id;
60:

Line 176: UPDATE IGS_OR_CWLK_INT

172: l_status := g_stat_prc;
173: END IF;
174:
175: -- Call the Update DML for updating the status appropriately
176: UPDATE IGS_OR_CWLK_INT
177: SET status = l_status
178: WHERE interface_crosswalk_id = cwlkrec.interface_crosswalk_id;
179:
180: -- Issue Commit for every 100 records

Line 196: FROM IGS_OR_CWLK_INT MSTR

192: -- Modification made for IGS.L, delete records that are successfully inserted/updated
193: DELETE FROM IGS_OR_CWLK_DTL_INT DTL
194: WHERE EXISTS
195: (SELECT 1
196: FROM IGS_OR_CWLK_INT MSTR
197: WHERE MSTR.STATUS = '1' AND
198: MSTR.INTERFACE_CROSSWALK_ID = DTL.INTERFACE_CROSSWALK_ID);
199:
200: DELETE FROM IGS_OR_CWLK_INT WHERE STATUS = '1';

Line 200: DELETE FROM IGS_OR_CWLK_INT WHERE STATUS = '1';

196: FROM IGS_OR_CWLK_INT MSTR
197: WHERE MSTR.STATUS = '1' AND
198: MSTR.INTERFACE_CROSSWALK_ID = DTL.INTERFACE_CROSSWALK_ID);
199:
200: DELETE FROM IGS_OR_CWLK_INT WHERE STATUS = '1';
201:
202: commit;
203:
204: EXCEPTION