APPS.IGS_PS_VER_PKG dependencies on IGS_PS_REF_CD

Line 1529: igs_ps_ref_cd_pkg.get_fk_igs_ps_ver (

1525: igs_ps_occup_titles_pkg.get_fk_igs_ps_ver (
1526: old_references.course_cd
1527: );
1528:
1529: igs_ps_ref_cd_pkg.get_fk_igs_ps_ver (
1530: old_references.course_cd,
1531: old_references.version_number
1532: );
1533:

Line 1534: igs_ps_ref_cd_hist_pkg.get_fk_igs_ps_ver (

1530: old_references.course_cd,
1531: old_references.version_number
1532: );
1533:
1534: igs_ps_ref_cd_hist_pkg.get_fk_igs_ps_ver (
1535: old_references.course_cd,
1536: old_references.version_number
1537: );
1538:

Line 2114: Purpose : Insertion into table IGS_PS_REF_CD for mandatory ref code types and default ref codes

2110:
2111: /************************************************************************
2112: Created By : Aiyer
2113: Date Created By : 12/06/2001
2114: Purpose : Insertion into table IGS_PS_REF_CD for mandatory ref code types and default ref codes
2115: Known limitations, enhancements or remarks:
2116: Change History :
2117: Who When What
2118: *************************************************************************/

Line 2137: CURSOR c_igs_ge_ref_cd (p_c_reference_cd_type IGS_PS_REF_CD.REFERENCE_CD_TYPE%TYPE)

2133: restricted_flag='Y'
2134: AND
2135: closed_ind = 'N';
2136:
2137: CURSOR c_igs_ge_ref_cd (p_c_reference_cd_type IGS_PS_REF_CD.REFERENCE_CD_TYPE%TYPE)
2138: IS
2139: SELECT
2140: reference_cd,
2141: description

Line 2153: -- insert a value in igs_ps_ref_cd for every value of course_cd and version_number having

2149: FOR cur_igs_ge_ref_cd_type_all IN c_igs_ge_ref_cd_type_all
2150: LOOP
2151: FOR cur_igs_ge_ref_cd IN c_igs_ge_ref_cd(cur_igs_ge_ref_cd_type_all.reference_cd_type)
2152: LOOP
2153: -- insert a value in igs_ps_ref_cd for every value of course_cd and version_number having
2154: -- a applicable program level defined as mandatory and a default reference code
2155: BEGIN
2156: l_c_rowid:=NULL;
2157: igs_ps_ref_cd_pkg.INSERT_ROW (

Line 2157: igs_ps_ref_cd_pkg.INSERT_ROW (

2153: -- insert a value in igs_ps_ref_cd for every value of course_cd and version_number having
2154: -- a applicable program level defined as mandatory and a default reference code
2155: BEGIN
2156: l_c_rowid:=NULL;
2157: igs_ps_ref_cd_pkg.INSERT_ROW (
2158: X_ROWID => l_c_rowid,
2159: X_COURSE_CD => p_course_cd,
2160: X_VERSION_NUMBER => p_version_number,
2161: X_REFERENCE_CD_TYPE => cur_igs_ge_ref_cd_type_all.reference_cd_type ,

Line 2176: -- If an error occurs during insertion in igs_ps_ref_cd then raise an exception.

2172: END LOOP;
2173: END LOOP;
2174: EXCEPTION
2175: WHEN OTHERS THEN
2176: -- If an error occurs during insertion in igs_ps_ref_cd then raise an exception.
2177: igs_ge_msg_stack.add;
2178: app_exception.raise_exception;
2179: RETURN;
2180: END dflt_prgm_ref_code;

Line 2214: -- This code has been added by aiyer to insert rows into table igs_ps_ref_cd for corresponding course_cd and version_number

2210: -- Call all the PROCEDUREs related to After Insert.
2211: afterrowinsertupdate2 ( p_inserting => TRUE,
2212: p_updating => FALSE,
2213: p_deleting => FALSE);
2214: -- This code has been added by aiyer to insert rows into table igs_ps_ref_cd for corresponding course_cd and version_number
2215: OPEN c_fetch_cou_ver;
2216: FETCH c_fetch_cou_ver INTO cur_fetch_cou_ver;
2217: dflt_prgm_ref_code ( p_course_cd => cur_fetch_cou_ver.course_cd,
2218: p_version_number => cur_fetch_cou_ver.version_number