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_ST_VAL_GSC dependencies on IGS_ST_GVT_SPSHT_CTL

Line 14: v_submission_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE;

10: RETURN BOOLEAN AS
11: BEGIN
12: DECLARE
13: v_delete_snapshot_ind IGS_EN_ST_SPSHT_CTL.delete_snapshot_ind%TYPE;
14: v_submission_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE;
15: CURSOR c_essc(
16: cp_snapshot_dt_time IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time%TYPE) IS
17: SELECT essc.delete_snapshot_ind
18: FROM IGS_EN_ST_SPSHT_CTL essc

Line 16: cp_snapshot_dt_time IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time%TYPE) IS

12: DECLARE
13: v_delete_snapshot_ind IGS_EN_ST_SPSHT_CTL.delete_snapshot_ind%TYPE;
14: v_submission_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE;
15: CURSOR c_essc(
16: cp_snapshot_dt_time IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time%TYPE) IS
17: SELECT essc.delete_snapshot_ind
18: FROM IGS_EN_ST_SPSHT_CTL essc
19: WHERE essc.snapshot_dt_time = cp_snapshot_dt_time;
20: CURSOR c_gsc(

Line 21: cp_snapshot_dt_time IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time%TYPE,

17: SELECT essc.delete_snapshot_ind
18: FROM IGS_EN_ST_SPSHT_CTL essc
19: WHERE essc.snapshot_dt_time = cp_snapshot_dt_time;
20: CURSOR c_gsc(
21: cp_snapshot_dt_time IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time%TYPE,
22: cp_submission_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE) IS
23: SELECT gsc.submission_yr
24: FROM IGS_ST_GVT_SPSHT_CTL gsc
25: WHERE gsc.ess_snapshot_dt_time = cp_snapshot_dt_time AND

Line 22: cp_submission_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE) IS

18: FROM IGS_EN_ST_SPSHT_CTL essc
19: WHERE essc.snapshot_dt_time = cp_snapshot_dt_time;
20: CURSOR c_gsc(
21: cp_snapshot_dt_time IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time%TYPE,
22: cp_submission_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE) IS
23: SELECT gsc.submission_yr
24: FROM IGS_ST_GVT_SPSHT_CTL gsc
25: WHERE gsc.ess_snapshot_dt_time = cp_snapshot_dt_time AND
26: gsc.submission_yr <> cp_submission_yr;

Line 24: FROM IGS_ST_GVT_SPSHT_CTL gsc

20: CURSOR c_gsc(
21: cp_snapshot_dt_time IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time%TYPE,
22: cp_submission_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE) IS
23: SELECT gsc.submission_yr
24: FROM IGS_ST_GVT_SPSHT_CTL gsc
25: WHERE gsc.ess_snapshot_dt_time = cp_snapshot_dt_time AND
26: gsc.submission_yr <> cp_submission_yr;
27: BEGIN
28: -- Validate the IGS_ST_GVT_SPSHT_CTL.snapshot_dt_time.

Line 28: -- Validate the IGS_ST_GVT_SPSHT_CTL.snapshot_dt_time.

24: FROM IGS_ST_GVT_SPSHT_CTL gsc
25: WHERE gsc.ess_snapshot_dt_time = cp_snapshot_dt_time AND
26: gsc.submission_yr <> cp_submission_yr;
27: BEGIN
28: -- Validate the IGS_ST_GVT_SPSHT_CTL.snapshot_dt_time.
29: -- An Enrolment Statistics Snapshot which is marked for delete cannot
30: -- be used by a Government Snapshot.
31: -- An Enrolment Statistics Snapshot which is used by another Government
32: -- Snapshot submission in another year cannot be used by a Government

Line 77: v_submission_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE;

73: p_message_name OUT NOCOPY VARCHAR2 )
74: RETURN BOOLEAN AS
75: BEGIN
76: DECLARE
77: v_submission_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE;
78: CURSOR c_gsc(
79: cp_submission_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE,
80: cp_submission_number IGS_ST_GVT_SPSHT_CTL.submission_number%TYPE) IS
81: SELECT gsc.submission_yr

Line 79: cp_submission_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE,

75: BEGIN
76: DECLARE
77: v_submission_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE;
78: CURSOR c_gsc(
79: cp_submission_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE,
80: cp_submission_number IGS_ST_GVT_SPSHT_CTL.submission_number%TYPE) IS
81: SELECT gsc.submission_yr
82: FROM IGS_ST_GVT_SPSHT_CTL gsc
83: WHERE gsc.submission_yr = cp_submission_yr AND

Line 80: cp_submission_number IGS_ST_GVT_SPSHT_CTL.submission_number%TYPE) IS

76: DECLARE
77: v_submission_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE;
78: CURSOR c_gsc(
79: cp_submission_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE,
80: cp_submission_number IGS_ST_GVT_SPSHT_CTL.submission_number%TYPE) IS
81: SELECT gsc.submission_yr
82: FROM IGS_ST_GVT_SPSHT_CTL gsc
83: WHERE gsc.submission_yr = cp_submission_yr AND
84: gsc.submission_number = cp_submission_number AND

Line 82: FROM IGS_ST_GVT_SPSHT_CTL gsc

78: CURSOR c_gsc(
79: cp_submission_yr IGS_ST_GVT_SPSHT_CTL.submission_yr%TYPE,
80: cp_submission_number IGS_ST_GVT_SPSHT_CTL.submission_number%TYPE) IS
81: SELECT gsc.submission_yr
82: FROM IGS_ST_GVT_SPSHT_CTL gsc
83: WHERE gsc.submission_yr = cp_submission_yr AND
84: gsc.submission_number = cp_submission_number AND
85: gsc.completion_dt IS NOT NULL;
86: BEGIN

Line 87: -- Validate update of the IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time.

83: WHERE gsc.submission_yr = cp_submission_yr AND
84: gsc.submission_number = cp_submission_number AND
85: gsc.completion_dt IS NOT NULL;
86: BEGIN
87: -- Validate update of the IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time.
88: -- The IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time cannot be updated if the
89: -- govt_snapshot_ctlcompletion_dt is set.
90: p_message_name := NULL;
91: -- Retrieve the Government Snapshot control data.

Line 88: -- The IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time cannot be updated if the

84: gsc.submission_number = cp_submission_number AND
85: gsc.completion_dt IS NOT NULL;
86: BEGIN
87: -- Validate update of the IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time.
88: -- The IGS_ST_GVT_SPSHT_CTL.ess_snapshot_dt_time cannot be updated if the
89: -- govt_snapshot_ctlcompletion_dt is set.
90: p_message_name := NULL;
91: -- Retrieve the Government Snapshot control data.
92: OPEN c_gsc(