APPS.IGS_PS_USEC_SCHEDULE dependencies on IGS_PS_SCH_PAT_INT_S

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 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 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 );