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_PAT_INT

Line 198: FROM igs_ps_sch_pat_int

194: WHERE int_pat_id = cp_int_pat_id;
195:
196: CURSOR c_pattern_int_exists(cp_transaction_id IN NUMBER) IS
197: SELECT 'X'
198: FROM igs_ps_sch_pat_int
199: WHERE transaction_id = cp_transaction_id;
200:
201: CURSOR c_pattern_prod(cp_transaction_id IN NUMBER) IS
202: SELECT *

Line 203: FROM igs_ps_sch_pat_int

199: WHERE transaction_id = cp_transaction_id;
200:
201: CURSOR c_pattern_prod(cp_transaction_id IN NUMBER) IS
202: SELECT *
203: FROM igs_ps_sch_pat_int
204: WHERE transaction_id=cp_transaction_id;
205:
206: CURSOR c_section(cp_int_pat_id IN NUMBER) IS
207: SELECT *

Line 423: INSERT INTO IGS_PS_SCH_PAT_INT

419: END IF;
420: CLOSE c_section_exists;
421:
422: --Insert into pattern interface table
423: INSERT INTO IGS_PS_SCH_PAT_INT
424: (int_pat_id ,
425: transaction_id ,
426: calendar_type ,
427: sequence_number ,

Line 445: IGS_PS_SCH_PAT_INT_S.NEXTVAL,

441: last_updated_by ,
442: last_update_date ,
443: last_update_login)
444: VALUES(
445: IGS_PS_SCH_PAT_INT_S.NEXTVAL,
446: l_trans_id,
447: l_cal_type,
448: l_ci_sequence_number,
449: p_pat_cur_rec.alternate_code,

Line 1404: DELETE IGS_PS_SCH_PAT_INT WHERE int_pat_id=l_int_pat_id;

1400: OPEN c_section_int_exists(l_int_pat_id);
1401: FETCH c_section_int_exists INTO l_c_var;
1402: IF c_section_int_exists%NOTFOUND THEN
1403: IF (p_sch_type = 'REQUEST' AND l_unit_status IS NULL) OR (p_sch_type IN ('UPDATE','CANCEL') ) THEN
1404: DELETE IGS_PS_SCH_PAT_INT WHERE int_pat_id=l_int_pat_id;
1405: END IF;
1406: END IF;
1407: CLOSE c_section_int_exists;
1408:

Line 1890: FROM igs_ps_sch_pat_int;

1886: ***************************************************************/
1887:
1888: CURSOR cur_pat IS
1889: SELECT DISTINCT calendar_type,sequence_number
1890: FROM igs_ps_sch_pat_int;
1891:
1892: BEGIN
1893:
1894: -- set the multi org id

Line 2966: UPDATE igs_ps_sch_pat_int set import_done_flag='Y' WHERE int_pat_id = rec_int_uso.int_pat_id;

2962: --Update the interface pattern import_done_flag
2963: OPEN cur_pattern_import(rec_int_uso.int_pat_id);
2964: FETCH cur_pattern_import INTO l_c_var;
2965: IF cur_pattern_import%NOTFOUND THEN
2966: UPDATE igs_ps_sch_pat_int set import_done_flag='Y' WHERE int_pat_id = rec_int_uso.int_pat_id;
2967: END IF;
2968: CLOSE cur_pattern_import;
2969: END IF;
2970:

Line 3590: FROM igs_ps_sch_pat_int pt

3586: --all the interface pattern records
3587: CURSOR c_int_pat_ss (cp_sequence_number igs_ps_sch_int_all.sequence_number%TYPE,
3588: cp_cal_type igs_ps_sch_int_all.calendar_type%TYPE) IS
3589: SELECT pt.ROWID intrid,pt.*
3590: FROM igs_ps_sch_pat_int pt
3591: WHERE pt.calendar_type=cp_cal_type
3592: AND pt.sequence_number =cp_sequence_number
3593: AND pt.unit_cd= NVL (p_unit_cd,pt.unit_cd)
3594: AND pt.version_number=NVL (p_version_number, pt.version_number);

Line 3922: UPDATE igs_ps_sch_pat_int SET abort_flag = l_abort_flag

3918: END IF;
3919:
3920:
3921: --update the interface table
3922: UPDATE igs_ps_sch_pat_int SET abort_flag = l_abort_flag
3923: WHERE ROWID =c_int_pat_ss_rec.intrid ;
3924:
3925: --update the production table
3926: OPEN c_prod_pat(l_ci_sequence_number,l_cal_type,c_int_pat_ss_rec.unit_cd ,c_int_pat_ss_rec.version_number );

Line 4029: FROM igs_ps_sch_pat_int pat

4025: CURSOR c_pat( cp_c_cal_type igs_ps_sch_usec_int_all.calendar_type%TYPE,
4026: cp_n_seq_num igs_ps_sch_usec_int_all.sequence_number%TYPE,
4027: cp_aborted VARCHAR2) IS
4028: SELECT pat.int_pat_id, pat.unit_cd,pat.version_number
4029: FROM igs_ps_sch_pat_int pat
4030: WHERE pat.calendar_type= cp_c_cal_type
4031: AND pat.sequence_number=cp_n_seq_num
4032: AND (import_done_flag = 'Y' OR (import_done_flag='N' AND (pat.abort_flag = 'Y' AND cp_aborted ='Y')))
4033: AND NOT EXISTS (SELECT 'X' FROM igs_ps_sch_usec_int_all us WHERE us.int_pat_id=pat.int_pat_id) ;

Line 4038: WHERE NOT EXISTS ( SELECT 'X' FROM igs_ps_sch_pat_int pat WHERE pat.transaction_id = hdr.transaction_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;
4042: l_end_date DATE;

Line 4194: DELETE FROM igs_ps_sch_pat_int WHERE int_pat_id=rec_pat.int_pat_id;

4190: DELETE FROM igs_ps_sch_loc_int WHERE int_pat_id=rec_pat.int_pat_id;
4191: DELETE FROM igs_ps_sch_fac_int WHERE int_pat_id=rec_pat.int_pat_id;
4192:
4193: -- Deleting pattern record
4194: DELETE FROM igs_ps_sch_pat_int WHERE int_pat_id=rec_pat.int_pat_id;
4195:
4196: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_CD' )
4197: || ' : ' || rec_pat.unit_cd );
4198: fnd_file.put_line ( fnd_file.LOG, igs_ge_gen_004.genp_get_lookup ( 'LEGACY_TOKENS', 'UNIT_VER_NUM' )