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.IGS_PS_USEC_SCHEDULE dependencies on IGS_PS_SCH_HDR_INT

Line 221: l_trans_id igs_ps_sch_hdr_int.transaction_id%TYPE;

217: l_valid_occur BOOLEAN;
218: l_unit_status igs_ps_unit_ver_all.unit_status%TYPE;
219: ---
220:
221: l_trans_id igs_ps_sch_hdr_int.transaction_id%TYPE;
222: l_request_id igs_ps_sch_hdr_int.request_id%TYPE;
223: l_program_id igs_ps_sch_hdr_int.program_id%TYPE;
224: l_program_application_id igs_ps_sch_hdr_int.program_application_id%TYPE;
225: l_derd_sch_type VARCHAR2(13); -- Changed as varchar2(13) from igs_ps_sch_int_all.transaction_type%TYPE w.r.t. Bug # 2383553

Line 222: l_request_id igs_ps_sch_hdr_int.request_id%TYPE;

218: l_unit_status igs_ps_unit_ver_all.unit_status%TYPE;
219: ---
220:
221: l_trans_id igs_ps_sch_hdr_int.transaction_id%TYPE;
222: l_request_id igs_ps_sch_hdr_int.request_id%TYPE;
223: l_program_id igs_ps_sch_hdr_int.program_id%TYPE;
224: l_program_application_id igs_ps_sch_hdr_int.program_application_id%TYPE;
225: l_derd_sch_type VARCHAR2(13); -- Changed as varchar2(13) from igs_ps_sch_int_all.transaction_type%TYPE w.r.t. Bug # 2383553
226: l_int_sch_status igs_ps_sch_int_all.transaction_type%TYPE;

Line 223: l_program_id igs_ps_sch_hdr_int.program_id%TYPE;

219: ---
220:
221: l_trans_id igs_ps_sch_hdr_int.transaction_id%TYPE;
222: l_request_id igs_ps_sch_hdr_int.request_id%TYPE;
223: l_program_id igs_ps_sch_hdr_int.program_id%TYPE;
224: l_program_application_id igs_ps_sch_hdr_int.program_application_id%TYPE;
225: l_derd_sch_type VARCHAR2(13); -- Changed as varchar2(13) from igs_ps_sch_int_all.transaction_type%TYPE w.r.t. Bug # 2383553
226: l_int_sch_status igs_ps_sch_int_all.transaction_type%TYPE;
227: l_cal_type igs_ca_inst.cal_type%TYPE;

Line 224: l_program_application_id igs_ps_sch_hdr_int.program_application_id%TYPE;

220:
221: l_trans_id igs_ps_sch_hdr_int.transaction_id%TYPE;
222: l_request_id igs_ps_sch_hdr_int.request_id%TYPE;
223: l_program_id igs_ps_sch_hdr_int.program_id%TYPE;
224: l_program_application_id igs_ps_sch_hdr_int.program_application_id%TYPE;
225: l_derd_sch_type VARCHAR2(13); -- Changed as varchar2(13) from igs_ps_sch_int_all.transaction_type%TYPE w.r.t. Bug # 2383553
226: l_int_sch_status igs_ps_sch_int_all.transaction_type%TYPE;
227: l_cal_type igs_ca_inst.cal_type%TYPE;
228: l_enrollment_maximum igs_ps_usec_lim_wlst.enrollment_maximum%TYPE;

Line 252: INSERT INTO igs_ps_sch_hdr_int_all (

248:
249: PROCEDURE create_header IS
250: -- create a header record for the process.
251: BEGIN
252: INSERT INTO igs_ps_sch_hdr_int_all (
253: transaction_id ,
254: originator ,
255: request_date ,
256: org_id ,

Line 263: IGS_PS_SCH_HDR_INT_S.NEXTVAL,

259: last_updated_by ,
260: last_update_date ,
261: last_update_login)
262: VALUES (
263: IGS_PS_SCH_HDR_INT_S.NEXTVAL,
264: 'INTERNAL',
265: SYSDATE,
266: p_org_id,
267: g_n_user_id,

Line 1416: DELETE IGS_PS_SCH_HDR_INT_ALL WHERE transaction_id = l_trans_id;

1412: IF l_trans_id IS NOT NULL THEN
1413: OPEN c_pattern_int_exists(l_trans_id);
1414: FETCH c_pattern_int_exists INTO l_c_var;
1415: IF c_pattern_int_exists%NOTFOUND THEN
1416: DELETE IGS_PS_SCH_HDR_INT_ALL WHERE transaction_id = l_trans_id;
1417: l_data_found := FALSE;
1418: ELSE
1419: l_data_found := TRUE;
1420: --Update all the production records for the abort_flag='N'

Line 2594: l_originator igs_ps_sch_hdr_int.originator%TYPE;

2590: smvk 31-Dec-2002 Bug # 2710978. Collecting the statistics of the interface table as per standards.
2591: (reverse chronological order - newest change first)
2592: ***************************************************************/
2593:
2594: l_originator igs_ps_sch_hdr_int.originator%TYPE;
2595: l_status igs_ps_usec_occurs.schedule_status%TYPE;
2596: l_unit_section_occurrence_id igs_ps_usec_occurs.unit_section_occurrence_id%TYPE;
2597: l_schedule_status igs_ps_usec_occurs.schedule_status%TYPE;
2598: l_inter_error_text igs_ps_usec_occurs.error_text%TYPE;

Line 2648: FROM igs_ps_sch_hdr_int_ALL

2644: FOR UPDATE NOWAIT;
2645:
2646: CURSOR c_get_originator(p_transaction_id NUMBER) IS
2647: SELECT originator
2648: FROM igs_ps_sch_hdr_int_ALL
2649: WHERE transaction_id=p_transaction_id;
2650:
2651: CURSOR c_ipsuo(p_usec_id NUMBER) IS
2652: SELECT *

Line 3088: tablenames_tbl(8) := 'IGS_PS_SCH_HDR_INT_ALL';

3084: tablenames_tbl(4) := 'IGS_PS_SCH_X_USEC_INT_ALL';
3085: tablenames_tbl(5) := 'IGS_PS_SCH_USEC_INT_ALL';
3086: tablenames_tbl(6) := 'IGS_PS_SCH_INT_ALL';
3087: tablenames_tbl(7) := 'IGS_PS_PREFS_SCH_INT_ALL';
3088: tablenames_tbl(8) := 'IGS_PS_SCH_HDR_INT_ALL';
3089:
3090: FOR i IN 1.. tablenames_tbl.LAST
3091: LOOP
3092: fnd_stats.gather_table_stats(ownname => l_c_schema,

Line 4037: FROM igs_ps_sch_hdr_int hdr

4033: AND NOT EXISTS (SELECT 'X' FROM igs_ps_sch_usec_int_all us WHERE us.int_pat_id=pat.int_pat_id) ;
4034:
4035: CURSOR c_header IS
4036: SELECT hdr.transaction_id
4037: FROM igs_ps_sch_hdr_int hdr
4038: WHERE NOT EXISTS ( SELECT 'X' FROM igs_ps_sch_pat_int pat WHERE pat.transaction_id = hdr.transaction_id);
4039:
4040:
4041: l_start_date DATE;

Line 4214: DELETE FROM igs_ps_sch_hdr_int_all WHERE transaction_id=rec_header.transaction_id;

4210: /********************** Purging the header Records***************************/
4211: FOR rec_header IN c_header LOOP
4212:
4213: -- Deleting transaction header record
4214: DELETE FROM igs_ps_sch_hdr_int_all WHERE transaction_id=rec_header.transaction_id;
4215:
4216: END LOOP;
4217:
4218: