APPS.IGS_PS_GEN_001 dependencies on IGS_PS_OWN

Line 89: gv_cow_rec IGS_PS_OWN%ROWTYPE;

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;
93: gv_fsr_rec IGS_FI_FND_SRC_RSTN%ROWTYPE;

Line 143: FROM IGS_PS_OWN

139: version_number = p_old_version_number AND
140: award_cd = gv_ca_rec.award_cd;
141: CURSOR gc_cow_rec IS
142: SELECT *
143: FROM IGS_PS_OWN
144: WHERE course_cd = p_old_course_cd AND
145: version_number = p_old_version_number;
146: -- Only interested in notes that are not OLE type as
147: -- currently unable to copy long raw field within PL/SQL

Line 1375: -- procedure for inserting new IGS_PS_OWN records

1371: ELSE
1372: App_Exception.Raise_Exception;
1373: END IF;
1374: END crsp_ins_ca_rec;
1375: -- procedure for inserting new IGS_PS_OWN records
1376: PROCEDURE crsp_ins_cow_rec (
1377: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1378: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1379: BEGIN

Line 1381: IGS_PS_OWN_PKG.INSERT_ROW(

1377: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1378: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1379: BEGIN
1380: X_ROWID := NULL ;
1381: IGS_PS_OWN_PKG.INSERT_ROW(
1382: X_ROWID => x_rowid,
1383: X_COURSE_CD => p_new_course_cd,
1384: X_OU_START_DT => gv_cow_rec.ou_start_dt,
1385: X_ORG_UNIT_CD => gv_cow_rec.org_unit_cd,

Line 1920: -- calling procedure to insert IGS_PS_OWN records

1916: EXIT;
1917: END IF;
1918: END LOOP;
1919: CLOSE gc_ca_rec;
1920: -- calling procedure to insert IGS_PS_OWN records
1921: OPEN gc_cow_rec;
1922: LOOP
1923: FETCH gc_cow_rec INTO gv_cow_rec;
1924: IF gc_cow_rec%FOUND THEN