APPS.IGS_PS_GEN_001 dependencies on IGS_PS_AWD_OWN

Line 88: gv_cao_rec IGS_PS_AWD_OWN%ROWTYPE;

84: gv_ref_num IGS_GE_NOTE.reference_number%TYPE;
85: gv_coo_seq_num IGS_PS_OFR_OPT.coo_id%TYPE;
86: gv_cop_seq_num IGS_PS_OFR_PAT.cop_id%TYPE;
87: gv_ca_rec IGS_PS_AWARD%ROWTYPE;
88: gv_cao_rec IGS_PS_AWD_OWN%ROWTYPE;
89: gv_cow_rec IGS_PS_OWN%ROWTYPE;
90: gv_cvn_rec IGS_PS_VER_NOTE%ROWTYPE;
91: gv_ae_rec IGS_PE_ALTERNATV_EXT%ROWTYPE;
92: gv_cgm_rec IGS_PS_GRP_MBR%ROWTYPE;

Line 137: FROM IGS_PS_AWD_OWN

133: version_number = p_old_version_number AND
134: CLOSED_IND = 'N';
135: CURSOR gc_cao_rec IS
136: SELECT *
137: FROM IGS_PS_AWD_OWN
138: WHERE course_cd = p_old_course_cd AND
139: version_number = p_old_version_number AND
140: award_cd = gv_ca_rec.award_cd;
141: CURSOR gc_cow_rec IS

Line 1285: -- procedure for inserting new IGS_PS_AWD_OWN records

1281: ELSE
1282: App_Exception.Raise_Exception;
1283: END IF;
1284: END crsp_ins_co_rec;
1285: -- procedure for inserting new IGS_PS_AWD_OWN records
1286: PROCEDURE crsp_ins_cao_rec (
1287: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1288: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1289: BEGIN

Line 1291: IGS_PS_AWD_OWN_PKG.INSERT_ROW(

1287: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1288: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1289: BEGIN
1290: X_ROWID := NULL ;
1291: IGS_PS_AWD_OWN_PKG.INSERT_ROW(
1292: X_ROWID => x_rowid,
1293: X_COURSE_CD => p_new_course_cd,
1294: X_ORG_UNIT_CD => gv_cao_rec.org_unit_cd,
1295: X_OU_START_DT => gv_cao_rec.ou_start_dt,

Line 1355: -- calling procedure to insert IGS_PS_AWD_OWN records

1351: X_MODE => 'R',
1352: X_DEFAULT_IND => gv_ca_rec.default_ind,
1353: X_CLOSED_IND => gv_ca_rec.closed_ind
1354: );
1355: -- calling procedure to insert IGS_PS_AWD_OWN records
1356: -- associated with each IGS_PS_AWARD record
1357: OPEN gc_cao_rec;
1358: LOOP
1359: FETCH gc_cao_rec INTO gv_cao_rec;