eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGR_IMP_002 dependencies on IGR_I_APPL_INT

Line 28: Purpose : Procedure to set the IGR_I_APPL_INT.STATUS value to Warning (status='4') when IGR_I_APPL_INT record

24: PROCEDURE update_parent_record_status ( p_interface_run_id IN NUMBER ) AS
25: /*************************************************************
26: Created By : rbezawad
27: Date Created By : 27-Feb-05
28: Purpose : Procedure to set the IGR_I_APPL_INT.STATUS value to Warning (status='4') when IGR_I_APPL_INT record
29: is processed successfully (status='1') but processing of any of the child interface records is not
30: successful (status<>'1'). Also set the IGS_AD_INTERFACE.STATUS to Error (Status='3') when processing any
31: of the child interface records (IGR_I_APPL_INT) is not successful (status<>'1').
32: Know limitations, enhancements or remarks

Line 31: of the child interface records (IGR_I_APPL_INT) is not successful (status<>'1').

27: Date Created By : 27-Feb-05
28: Purpose : Procedure to set the IGR_I_APPL_INT.STATUS value to Warning (status='4') when IGR_I_APPL_INT record
29: is processed successfully (status='1') but processing of any of the child interface records is not
30: successful (status<>'1'). Also set the IGS_AD_INTERFACE.STATUS to Error (Status='3') when processing any
31: of the child interface records (IGR_I_APPL_INT) is not successful (status<>'1').
32: Know limitations, enhancements or remarks
33: Change History
34: Who When What
35: (reverse chronological order - newest change first)

Line 40: UPDATE igr_i_appl_int iappl

36: ***************************************************************/
37: BEGIN
38:
39: -- Based upon inquiry child
40: UPDATE igr_i_appl_int iappl
41: SET status = '4',
42: error_code = 'E347',
43: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E347', 8405)
44: WHERE status = '1'

Line 61: AND (EXISTS (SELECT 1 FROM igr_i_appl_int WHERE status <> '1' AND interface_id = ad.interface_id));

57: status = '4',
58: error_code = 'E347'
59: WHERE status = '1'
60: AND interface_run_id = p_interface_run_id
61: AND (EXISTS (SELECT 1 FROM igr_i_appl_int WHERE status <> '1' AND interface_id = ad.interface_id));
62: COMMIT;
63:
64: END update_parent_record_status;
65:

Line 130: UPDATE igr_i_appl_int a

126: p_token_value => l_meaning);
127: END IF;
128:
129: -- Populating the interface table with the interface_run_id value
130: UPDATE igr_i_appl_int a
131: SET interface_run_id = p_interface_run_id,
132: person_id = (SELECT person_id
133: FROM igs_ad_interface
134: WHERE interface_id = a.interface_id)

Line 142: UPDATE igr_i_appl_int

138: AND status IN ('1','4'));
139:
140: -- If record failed only due to child record failure
141: -- then set status back to 1 and nullify error code/text
142: UPDATE igr_i_appl_int
143: SET error_code = NULL,
144: error_text = NULL,
145: status = '1'
146: WHERE interface_run_id = p_interface_run_id

Line 152: tabname => 'IGR_I_APPL_INT',

148: AND status = '4';
149:
150: -- Gather statistics of the table
151: FND_STATS.GATHER_TABLE_STATS(ownname => p_schema,
152: tabname => 'IGR_I_APPL_INT',
153: cascade => TRUE);
154:
155: -- Call category entity import procedure
156: igr_imp_003.process_person_inquiry (p_interface_run_id => p_interface_run_id,

Line 177: FROM igr_i_appl_int

173: UPDATE igr_i_lines_int a
174: SET interface_run_id = p_interface_run_id,
175: (person_id,enquiry_appl_number,inquiry_date,inquiry_source_type,sales_lead_id)
176: = (SELECT person_id,enquiry_appl_number,inquiry_dt,inquiry_source_type,sales_lead_id
177: FROM igr_i_appl_int
178: WHERE interface_inq_appl_id = a.interface_inq_appl_id)
179: WHERE interface_inq_appl_id IN (SELECT interface_inq_appl_id
180: FROM igr_i_appl_int
181: WHERE interface_run_id = p_interface_run_id

Line 180: FROM igr_i_appl_int

176: = (SELECT person_id,enquiry_appl_number,inquiry_dt,inquiry_source_type,sales_lead_id
177: FROM igr_i_appl_int
178: WHERE interface_inq_appl_id = a.interface_inq_appl_id)
179: WHERE interface_inq_appl_id IN (SELECT interface_inq_appl_id
180: FROM igr_i_appl_int
181: WHERE interface_run_id = p_interface_run_id
182: AND status IN ('1','4'));
183:
184: -- Gather statistics of the table

Line 210: FROM igr_i_appl_int

206: UPDATE igr_i_pkg_int a
207: SET interface_run_id = p_interface_run_id,
208: (person_id,enquiry_appl_number,sales_lead_id)
209: = (SELECT person_id,enquiry_appl_number,sales_lead_id
210: FROM igr_i_appl_int
211: WHERE interface_inq_appl_id = a.interface_inq_appl_id)
212: WHERE interface_inq_appl_id IN (SELECT interface_inq_appl_id
213: FROM igr_i_appl_int
214: WHERE interface_run_id = p_interface_run_id

Line 213: FROM igr_i_appl_int

209: = (SELECT person_id,enquiry_appl_number,sales_lead_id
210: FROM igr_i_appl_int
211: WHERE interface_inq_appl_id = a.interface_inq_appl_id)
212: WHERE interface_inq_appl_id IN (SELECT interface_inq_appl_id
213: FROM igr_i_appl_int
214: WHERE interface_run_id = p_interface_run_id
215: AND status IN ('1','4'));
216:
217: -- Gather statistics of the table

Line 243: FROM igr_i_appl_int

239: UPDATE igr_i_info_int a
240: SET interface_run_id = p_interface_run_id,
241: (person_id,enquiry_appl_number)
242: = (SELECT person_id,enquiry_appl_number
243: FROM igr_i_appl_int
244: WHERE interface_inq_appl_id = a.interface_inq_appl_id)
245: WHERE interface_inq_appl_id IN (SELECT interface_inq_appl_id
246: FROM igr_i_appl_int
247: WHERE interface_run_id = p_interface_run_id

Line 246: FROM igr_i_appl_int

242: = (SELECT person_id,enquiry_appl_number
243: FROM igr_i_appl_int
244: WHERE interface_inq_appl_id = a.interface_inq_appl_id)
245: WHERE interface_inq_appl_id IN (SELECT interface_inq_appl_id
246: FROM igr_i_appl_int
247: WHERE interface_run_id = p_interface_run_id
248: AND status IN ('1','4'));
249:
250: -- Gather statistics of the table

Line 276: FROM igr_i_appl_int

272: UPDATE igr_i_char_int a
273: SET interface_run_id = p_interface_run_id,
274: (person_id,enquiry_appl_number)
275: = (SELECT person_id,enquiry_appl_number
276: FROM igr_i_appl_int
277: WHERE interface_inq_appl_id = a.interface_inq_appl_id)
278: WHERE interface_inq_appl_id IN (SELECT interface_inq_appl_id
279: FROM igr_i_appl_int
280: WHERE interface_run_id = p_interface_run_id

Line 279: FROM igr_i_appl_int

275: = (SELECT person_id,enquiry_appl_number
276: FROM igr_i_appl_int
277: WHERE interface_inq_appl_id = a.interface_inq_appl_id)
278: WHERE interface_inq_appl_id IN (SELECT interface_inq_appl_id
279: FROM igr_i_appl_int
280: WHERE interface_run_id = p_interface_run_id
281: AND status IN ('1','4'));
282:
283: -- Gather statistics of the table

Line 341: DELETE FROM igr_i_appl_int

337: COMMIT;
338: END IF; -- g_inquiry_char_inc
339:
340: IF g_inquiry_dtls_inc THEN
341: DELETE FROM igr_i_appl_int
342: WHERE status = '1'
343: AND interface_run_id = p_interface_run_id;
344: COMMIT;
345: END IF; -- g_inquiry_dtls_inc