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_RLOVR_FAC_TSK dependencies on IGS_PS_FAC_ASG_TASK

Line 602: CURSOR cur_fac_asg_task(cp_fac_wl_id igs_ps_fac_asg_task.fac_wl_id%TYPE) IS

598: AND fw.ci_sequence_number = l_source_sequence_number
599: AND fw.person_id > -1
600: ORDER BY person_id ;
601:
602: CURSOR cur_fac_asg_task(cp_fac_wl_id igs_ps_fac_asg_task.fac_wl_id%TYPE) IS
603: SELECT 'x' FROM igs_ps_fac_asg_task
604: WHERE fac_wl_id = cp_fac_wl_id
605: AND NVL(num_rollover_period,99) >= 1
606: AND NVL(rollover_flag,' ') <> 'S';

Line 603: SELECT 'x' FROM igs_ps_fac_asg_task

599: AND fw.person_id > -1
600: ORDER BY person_id ;
601:
602: CURSOR cur_fac_asg_task(cp_fac_wl_id igs_ps_fac_asg_task.fac_wl_id%TYPE) IS
603: SELECT 'x' FROM igs_ps_fac_asg_task
604: WHERE fac_wl_id = cp_fac_wl_id
605: AND NVL(num_rollover_period,99) >= 1
606: AND NVL(rollover_flag,' ') <> 'S';
607: cur_fac_asg_task_rec cur_fac_asg_task%ROWTYPE;

Line 619: CURSOR cur_fat_exists(cp_fac_wl_id igs_ps_fac_asg_task.fac_wl_id%TYPE ,

615: ci_sequence_number = l_dest_sequence_number ;
616:
617: -- check if faculty task record already exists in the destination calendar
618: --
619: CURSOR cur_fat_exists(cp_fac_wl_id igs_ps_fac_asg_task.fac_wl_id%TYPE ,
620: cp_faculty_task_type igs_ps_fac_asg_task.faculty_task_type%TYPE) IS
621: SELECT 'x'
622: FROM igs_ps_fac_asg_task
623: WHERE fac_wl_id = cp_fac_wl_id AND

Line 620: cp_faculty_task_type igs_ps_fac_asg_task.faculty_task_type%TYPE) IS

616:
617: -- check if faculty task record already exists in the destination calendar
618: --
619: CURSOR cur_fat_exists(cp_fac_wl_id igs_ps_fac_asg_task.fac_wl_id%TYPE ,
620: cp_faculty_task_type igs_ps_fac_asg_task.faculty_task_type%TYPE) IS
621: SELECT 'x'
622: FROM igs_ps_fac_asg_task
623: WHERE fac_wl_id = cp_fac_wl_id AND
624: faculty_task_type = cp_faculty_task_type ;

Line 622: FROM igs_ps_fac_asg_task

618: --
619: CURSOR cur_fat_exists(cp_fac_wl_id igs_ps_fac_asg_task.fac_wl_id%TYPE ,
620: cp_faculty_task_type igs_ps_fac_asg_task.faculty_task_type%TYPE) IS
621: SELECT 'x'
622: FROM igs_ps_fac_asg_task
623: WHERE fac_wl_id = cp_fac_wl_id AND
624: faculty_task_type = cp_faculty_task_type ;
625: cur_fat_exists_rec cur_fat_exists%ROWTYPE ;
626:

Line 629: CURSOR cur_source_tasks(cp_fac_wl_id igs_ps_fac_asg_task.fac_wl_id%TYPE) IS

625: cur_fat_exists_rec cur_fat_exists%ROWTYPE ;
626:
627: -- get all the assigned tasks for the faculty
628: --
629: CURSOR cur_source_tasks(cp_fac_wl_id igs_ps_fac_asg_task.fac_wl_id%TYPE) IS
630: SELECT *
631: FROM igs_ps_fac_Asg_task_v
632: WHERE fac_wl_id = cp_fac_wl_id AND
633: NVL(num_rollover_period,99) >= 1 ;

Line 631: FROM igs_ps_fac_Asg_task_v

627: -- get all the assigned tasks for the faculty
628: --
629: CURSOR cur_source_tasks(cp_fac_wl_id igs_ps_fac_asg_task.fac_wl_id%TYPE) IS
630: SELECT *
631: FROM igs_ps_fac_Asg_task_v
632: WHERE fac_wl_id = cp_fac_wl_id AND
633: NVL(num_rollover_period,99) >= 1 ;
634:
635: --update the source task type to set rollover_flag='S'

Line 638: SELECT rowid,igs_ps_fac_asg_task.*

634:
635: --update the source task type to set rollover_flag='S'
636: --
637: CURSOR cur_upd_src_task(cp_rowid VARCHAR2 ) IS
638: SELECT rowid,igs_ps_fac_asg_task.*
639: FROM igs_ps_fac_asg_task
640: WHERE rowid = cp_rowid
641: FOR UPDATE OF rollover_flag NOWAIT;
642:

Line 639: FROM igs_ps_fac_asg_task

635: --update the source task type to set rollover_flag='S'
636: --
637: CURSOR cur_upd_src_task(cp_rowid VARCHAR2 ) IS
638: SELECT rowid,igs_ps_fac_asg_task.*
639: FROM igs_ps_fac_asg_task
640: WHERE rowid = cp_rowid
641: FOR UPDATE OF rollover_flag NOWAIT;
642:
643: cur_upd_src_task_rec cur_upd_src_task%ROWTYPE ;

Line 825: IGS_PS_FAC_ASG_TASK_PKG.INSERT_ROW(

821: IF cur_fat_exists%NOTFOUND THEN
822: DECLARE
823: l_rowid1 VARCHAR2(40);
824: BEGIN
825: IGS_PS_FAC_ASG_TASK_PKG.INSERT_ROW(
826: X_ROWID => l_rowid1 ,
827: X_FAC_WL_ID => l_fac_wl_id ,
828: X_FACULTY_TASK_TYPE => cur_source_tasks_rec.faculty_task_type ,
829: X_CONFIRMED_IND => cur_source_tasks_rec.confirmed_ind,

Line 849: IGS_PS_FAC_ASG_TASK_PKG.UPDATE_ROW(

845: --
846: OPEN cur_upd_src_task( cur_source_tasks_rec.row_id);
847: FETCH cur_upd_src_task INTO cur_upd_src_task_rec ;
848: IF cur_upd_src_task%FOUND THEN
849: IGS_PS_FAC_ASG_TASK_PKG.UPDATE_ROW(
850: X_ROWID => cur_upd_src_task_rec.rowid,
851: X_FAC_WL_ID => cur_upd_src_task_rec.fac_wl_id ,
852: X_FACULTY_TASK_TYPE => cur_upd_src_task_rec.faculty_task_type ,
853: X_CONFIRMED_IND => cur_upd_src_task_rec.confirmed_ind,