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.

[Home] [Help]

APPS.IGS_GR_GEN_002 dependencies on IGS_GR_STAT

Line 13: p_potential_graduand_status IGS_GR_STAT.graduand_status%TYPE ,

9: p_award_cd IGS_PS_AWD.award_cd%TYPE ,
10: p_nominated_completion VARCHAR2 ,
11: p_derived_completion VARCHAR2 ,
12: p_restrict_rqrmnt_complete VARCHAR2 ,
13: p_potential_graduand_status IGS_GR_STAT.graduand_status%TYPE ,
14: p_eligible_graduand_status IGS_GR_STAT.graduand_status%TYPE ,
15: p_graduand_appr_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE,
16: p_org_id IN NUMBER,
17: p_graduand_status IGS_GR_STAT.graduand_status%TYPE ,

Line 14: p_eligible_graduand_status IGS_GR_STAT.graduand_status%TYPE ,

10: p_nominated_completion VARCHAR2 ,
11: p_derived_completion VARCHAR2 ,
12: p_restrict_rqrmnt_complete VARCHAR2 ,
13: p_potential_graduand_status IGS_GR_STAT.graduand_status%TYPE ,
14: p_eligible_graduand_status IGS_GR_STAT.graduand_status%TYPE ,
15: p_graduand_appr_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE,
16: p_org_id IN NUMBER,
17: p_graduand_status IGS_GR_STAT.graduand_status%TYPE ,
18: p_approval_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE) AS

Line 17: p_graduand_status IGS_GR_STAT.graduand_status%TYPE ,

13: p_potential_graduand_status IGS_GR_STAT.graduand_status%TYPE ,
14: p_eligible_graduand_status IGS_GR_STAT.graduand_status%TYPE ,
15: p_graduand_appr_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE,
16: p_org_id IN NUMBER,
17: p_graduand_status IGS_GR_STAT.graduand_status%TYPE ,
18: p_approval_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE) AS
19: -------------------------------------------------------
20: -- Change History :
21: -- Who When What

Line 187: IGS_GR_STAT gst

183: cp_course_cd igs_gr_graduand.course_cd%TYPE,
184: cp_award_cd igs_en_spa_awd_aim.award_cd%TYPE) IS
185: SELECT 'x'
186: FROM igs_gr_graduand gr,
187: IGS_GR_STAT gst
188: WHERE gr.person_id = cp_person_id AND
189: gr.course_cd = cp_course_cd AND
190: gr.award_cd = cp_award_cd AND
191: gr.graduand_status = gst.graduand_status AND

Line 227: cp_graduand_status IGS_GR_STAT.graduand_status%TYPE,

223: BEGIN -- grdpl_val_graduand_status
224: -- Validate the status values provided
225: DECLARE
226: CURSOR c_gst (
227: cp_graduand_status IGS_GR_STAT.graduand_status%TYPE,
228: cp_s_graduand_status IGS_GR_STAT.s_graduand_status%TYPE) IS
229: SELECT gst.closed_ind
230: FROM IGS_GR_STAT gst
231: WHERE gst.graduand_status = cp_graduand_status AND

Line 228: cp_s_graduand_status IGS_GR_STAT.s_graduand_status%TYPE) IS

224: -- Validate the status values provided
225: DECLARE
226: CURSOR c_gst (
227: cp_graduand_status IGS_GR_STAT.graduand_status%TYPE,
228: cp_s_graduand_status IGS_GR_STAT.s_graduand_status%TYPE) IS
229: SELECT gst.closed_ind
230: FROM IGS_GR_STAT gst
231: WHERE gst.graduand_status = cp_graduand_status AND
232: gst.s_graduand_status = cp_s_graduand_status;

Line 230: FROM IGS_GR_STAT gst

226: CURSOR c_gst (
227: cp_graduand_status IGS_GR_STAT.graduand_status%TYPE,
228: cp_s_graduand_status IGS_GR_STAT.s_graduand_status%TYPE) IS
229: SELECT gst.closed_ind
230: FROM IGS_GR_STAT gst
231: WHERE gst.graduand_status = cp_graduand_status AND
232: gst.s_graduand_status = cp_s_graduand_status;
233: v_gst_rec c_gst%ROWTYPE;
234: CURSOR c_gas IS

Line 383: v_graduand_status IGS_GR_STAT.graduand_status%TYPE;

379: --
380: -- End of new code added to fix Bug# 2683072
381: --
382:
383: v_graduand_status IGS_GR_STAT.graduand_status%TYPE;
384: v_approval_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE;
385: v_records_update NUMBER DEFAULT 0;
386: v_records_not_found NUMBER DEFAULT 0;
387: v_last_start_dt DATE;

Line 1012: p_graduand_status IGS_GR_STAT.GRADUAND_STATUS%TYPE;

1008: AS
1009: p_grd_cal_type igs_ca_inst.cal_type%type;
1010: p_grd_ci_sequence_number igs_ca_inst.sequence_number%type;
1011: p_location_cd IGS_AD_LOCATION.LOCATION_CD%TYPE;
1012: p_graduand_status IGS_GR_STAT.GRADUAND_STATUS%TYPE;
1013:
1014: BEGIN -- grdp_prc_gac
1015: -- This process manages the initial allocation of IGS_GR_GRADUAND records to
1016: -- ceremonies by creating IGS_GR_AWD_CRMN records and the

Line 1026: -- location_cd, and IGS_GR_STAT which do not have an existing

1022: -- The process finds closed IGS_GR_AWD_CRM_US_GP records for the specified
1023: -- IGS_GR_CRMN_ROUND, calls GENP_PRC_ACUSG_CLOSE to re-allocate any associated
1024: -- graduands.
1025: -- The process finds any IGS_GR_GRADUAND records for the specified IGS_GR_CRMN_ROUND,
1026: -- location_cd, and IGS_GR_STAT which do not have an existing
1027: -- IGS_GR_AWD_CRMN record and calls GENP_INS_GAC to determine if a
1028: -- ceremony exists suitable for the IGS_GR_GRADUAND and if one is suitable create
1029: -- a IGS_GR_AWD_CRMN record linking the IGS_GR_GRADUAND to it.
1030:

Line 1089: IGS_GR_STAT gst,

1085: gr.s_graduand_type,
1086: gr.grd_cal_type,
1087: gr.grd_ci_sequence_number
1088: FROM IGS_GR_GRADUAND gr,
1089: IGS_GR_STAT gst,
1090: IGS_EN_STDNT_PS_ATT sca
1091: WHERE gr.grd_cal_type = p_grd_cal_type AND
1092: gr.grd_ci_sequence_number = p_grd_ci_sequence_number AND
1093: gr.graduand_status = gst.graduand_status AND

Line 1183: -- and IGS_GR_STAT specified which do not have an existing

1179: App_Exception.Raise_Exception;
1180: END IF;
1181: END LOOP; -- c_acusg
1182: -- 4.1 Find any IGS_GR_GRADUAND records matching the IGS_GR_CRMN_ROUND, location_cd
1183: -- and IGS_GR_STAT specified which do not have an existing
1184: -- IGS_GR_AWD_CRMN record and loop through them.
1185: FOR v_gr_rec IN c_gr LOOP
1186: SAVEPOINT sp_prc_gac;
1187: -- 4.2 If the IGS_GR_GRADUAND has been deferred into this IGS_GR_CRMN_ROUND update the

Line 1325: p_eligible_graduand_status IGS_GR_STAT.graduand_status%TYPE ,

1321:
1322: PROCEDURE grdp_set_gr_gst(
1323: errbuf out NOCOPY varchar2,
1324: retcode out NOCOPY NUMBER,
1325: p_eligible_graduand_status IGS_GR_STAT.graduand_status%TYPE ,
1326: p_potential_graduand_status IGS_GR_STAT.graduand_status%TYPE,
1327: p_org_id NUMBER,
1328: p_graduand_status IGS_GR_STAT.graduand_status%TYPE ,
1329: p_approval_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE)

Line 1326: p_potential_graduand_status IGS_GR_STAT.graduand_status%TYPE,

1322: PROCEDURE grdp_set_gr_gst(
1323: errbuf out NOCOPY varchar2,
1324: retcode out NOCOPY NUMBER,
1325: p_eligible_graduand_status IGS_GR_STAT.graduand_status%TYPE ,
1326: p_potential_graduand_status IGS_GR_STAT.graduand_status%TYPE,
1327: p_org_id NUMBER,
1328: p_graduand_status IGS_GR_STAT.graduand_status%TYPE ,
1329: p_approval_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE)
1330: AS

Line 1328: p_graduand_status IGS_GR_STAT.graduand_status%TYPE ,

1324: retcode out NOCOPY NUMBER,
1325: p_eligible_graduand_status IGS_GR_STAT.graduand_status%TYPE ,
1326: p_potential_graduand_status IGS_GR_STAT.graduand_status%TYPE,
1327: p_org_id NUMBER,
1328: p_graduand_status IGS_GR_STAT.graduand_status%TYPE ,
1329: p_approval_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE)
1330: AS
1331:
1332: BEGIN -- grdp_set_gr_gst

Line 1343: v_graduand_status IGS_GR_STAT.graduand_status%TYPE;

1339: cst_eligible CONSTANT VARCHAR2(10) := 'ELIGIBLE';
1340: cst_potential CONSTANT VARCHAR2(10) := 'POTENTIAL';
1341: e_resource_busy EXCEPTION;
1342: PRAGMA EXCEPTION_INIT(e_resource_busy, -54);
1343: v_graduand_status IGS_GR_STAT.graduand_status%TYPE;
1344: v_s_graduand_status IGS_GR_STAT.s_graduand_status%TYPE;
1345: v_message_name VARCHAR2(30);
1346: v_closed_ind IGS_GR_STAT.closed_ind%TYPE;
1347: CURSOR c_gst (

Line 1344: v_s_graduand_status IGS_GR_STAT.s_graduand_status%TYPE;

1340: cst_potential CONSTANT VARCHAR2(10) := 'POTENTIAL';
1341: e_resource_busy EXCEPTION;
1342: PRAGMA EXCEPTION_INIT(e_resource_busy, -54);
1343: v_graduand_status IGS_GR_STAT.graduand_status%TYPE;
1344: v_s_graduand_status IGS_GR_STAT.s_graduand_status%TYPE;
1345: v_message_name VARCHAR2(30);
1346: v_closed_ind IGS_GR_STAT.closed_ind%TYPE;
1347: CURSOR c_gst (
1348: cp_graduand_status IGS_GR_STAT.graduand_status%TYPE,

Line 1346: v_closed_ind IGS_GR_STAT.closed_ind%TYPE;

1342: PRAGMA EXCEPTION_INIT(e_resource_busy, -54);
1343: v_graduand_status IGS_GR_STAT.graduand_status%TYPE;
1344: v_s_graduand_status IGS_GR_STAT.s_graduand_status%TYPE;
1345: v_message_name VARCHAR2(30);
1346: v_closed_ind IGS_GR_STAT.closed_ind%TYPE;
1347: CURSOR c_gst (
1348: cp_graduand_status IGS_GR_STAT.graduand_status%TYPE,
1349: cp_s_graduand_status IGS_GR_STAT.s_graduand_status%TYPE) IS
1350: SELECT gst.closed_ind

Line 1348: cp_graduand_status IGS_GR_STAT.graduand_status%TYPE,

1344: v_s_graduand_status IGS_GR_STAT.s_graduand_status%TYPE;
1345: v_message_name VARCHAR2(30);
1346: v_closed_ind IGS_GR_STAT.closed_ind%TYPE;
1347: CURSOR c_gst (
1348: cp_graduand_status IGS_GR_STAT.graduand_status%TYPE,
1349: cp_s_graduand_status IGS_GR_STAT.s_graduand_status%TYPE) IS
1350: SELECT gst.closed_ind
1351: FROM IGS_GR_STAT gst
1352: WHERE gst.graduand_status = cp_graduand_status AND

Line 1349: cp_s_graduand_status IGS_GR_STAT.s_graduand_status%TYPE) IS

1345: v_message_name VARCHAR2(30);
1346: v_closed_ind IGS_GR_STAT.closed_ind%TYPE;
1347: CURSOR c_gst (
1348: cp_graduand_status IGS_GR_STAT.graduand_status%TYPE,
1349: cp_s_graduand_status IGS_GR_STAT.s_graduand_status%TYPE) IS
1350: SELECT gst.closed_ind
1351: FROM IGS_GR_STAT gst
1352: WHERE gst.graduand_status = cp_graduand_status AND
1353: gst.s_graduand_status = cp_s_graduand_status;

Line 1351: FROM IGS_GR_STAT gst

1347: CURSOR c_gst (
1348: cp_graduand_status IGS_GR_STAT.graduand_status%TYPE,
1349: cp_s_graduand_status IGS_GR_STAT.s_graduand_status%TYPE) IS
1350: SELECT gst.closed_ind
1351: FROM IGS_GR_STAT gst
1352: WHERE gst.graduand_status = cp_graduand_status AND
1353: gst.s_graduand_status = cp_s_graduand_status;
1354:
1355: CURSOR c_sp_exists(

Line 1412: IGS_GR_STAT gst

1408: gr.attribute18,
1409: gr.attribute19,
1410: gr.attribute20
1411: FROM IGS_GR_GRADUAND gr,
1412: IGS_GR_STAT gst
1413: WHERE gr.graduand_status = gst.graduand_status AND
1414: gst.s_graduand_status IN
1415: ('POTENTIAL',
1416: 'ELIGIBLE')

Line 1919: 'IGS_GR_STAT gst, ' ||

1915: 'gac.grd_ci_sequence_number, '||
1916: 'gac.ceremony_number ' ||
1917: 'FROM IGS_GR_AWD_CRMN gac, ' ||
1918: 'IGS_GR_GRADUAND gr, ' ||
1919: 'IGS_GR_STAT gst, ' ||
1920: 'IGS_PE_PERSON pe, ' ||
1921: 'IGS_GR_AWD_CEREMONY awc, ' ||
1922: 'IGS_GR_AWD_CRM_US_GP acusg, '||
1923: 'IGS_GR_APRV_STAT gas ' ||