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_APRV_STAT

Line 15: p_graduand_appr_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE,

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
19: -------------------------------------------------------

Line 18: p_approval_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE) AS

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
22: -- (reverse chronological order - newest change first)

Line 236: FROM IGS_GR_APRV_STAT gas

232: gst.s_graduand_status = cp_s_graduand_status;
233: v_gst_rec c_gst%ROWTYPE;
234: CURSOR c_gas IS
235: SELECT gas.closed_ind
236: FROM IGS_GR_APRV_STAT gas
237: WHERE gas.graduand_appr_status = p_graduand_appr_status AND
238: gas.s_graduand_appr_status IN (
239: cst_waiting,
240: cst_approved);

Line 384: v_approval_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE;

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;
388: v_last_complete_ind VARCHAR2(1);

Line 1329: p_approval_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE)

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
1333: -- This module checks if a IGS_GR_GRADUAND with a 'POTENTIAL' IGS_GR_GRADUAND status is

Line 1419: v_approval_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE;

1415: ('POTENTIAL',
1416: 'ELIGIBLE')
1417: FOR UPDATE OF gr.graduand_status NOWAIT;
1418:
1419: v_approval_status IGS_GR_APRV_STAT.graduand_appr_status%TYPE;
1420: lc_sp_exists VARCHAR2(10);
1421: BEGIN
1422:
1423: -- Next check has been added as per the 'Progression Completion' TD Bug# 2636792

Line 1923: 'IGS_GR_APRV_STAT gas ' ||

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 ' ||
1924: 'WHERE gac.grd_cal_type=''' || p_grd_cal_type || ''' AND ' ||
1925: 'gac.grd_ci_sequence_number=' || TO_CHAR(p_grd_ci_sequence_number) || ' AND '||
1926: 'gac.ceremony_number=' || TO_CHAR(v_gc_rec.ceremony_number) || ' AND '||
1927: 'gac.person_id=gr.person_id AND ' ||