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_PS_GEN_008 dependencies on IGS_PS_UNIT_VER

Line 773: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,

769: END IF;
770: END crspl_ins_duplicate_note;
771:
772: PROCEDURE crspl_ins_unit_ver_note (
773: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
774: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
775: AS
776: v_unit_ver_note_rec IGS_PS_UNIT_VER_NOTE%ROWTYPE;
777: v_new_ref_number IGS_GE_NOTE.reference_number%TYPE;

Line 774: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )

770: END crspl_ins_duplicate_note;
771:
772: PROCEDURE crspl_ins_unit_ver_note (
773: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
774: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
775: AS
776: v_unit_ver_note_rec IGS_PS_UNIT_VER_NOTE%ROWTYPE;
777: v_new_ref_number IGS_GE_NOTE.reference_number%TYPE;
778: --- The following cursor excludes notes records with NULL values in the

Line 776: v_unit_ver_note_rec IGS_PS_UNIT_VER_NOTE%ROWTYPE;

772: PROCEDURE crspl_ins_unit_ver_note (
773: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
774: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
775: AS
776: v_unit_ver_note_rec IGS_PS_UNIT_VER_NOTE%ROWTYPE;
777: v_new_ref_number IGS_GE_NOTE.reference_number%TYPE;
778: --- The following cursor excludes notes records with NULL values in the
779: --- note_text field as this implies that it contains data in the note_ole
780: --- field which cannot be copied with the current product limitations.

Line 783: FROM IGS_PS_UNIT_VER_NOTE uvn

779: --- note_text field as this implies that it contains data in the note_ole
780: --- field which cannot be copied with the current product limitations.
781: CURSOR c_unit_ver_note_rec IS
782: SELECT *
783: FROM IGS_PS_UNIT_VER_NOTE uvn
784: WHERE uvn.unit_cd = p_unit_cd AND
785: uvn.version_number = p_version_number AND
786: EXISTS (
787: SELECT 'x'

Line 798: IGS_PS_UNIT_VER_NOTE_PKG.Insert_Row(

794: v_unit_ver_note_rec.reference_number,
795: v_new_ref_number);
796: BEGIN
797: x_rowid := NULL;
798: IGS_PS_UNIT_VER_NOTE_PKG.Insert_Row(
799: X_ROWID => x_rowid,
800: X_UNIT_CD => p_new_unit_cd,
801: X_REFERENCE_NUMBER => v_new_ref_number,
802: X_VERSION_NUMBER => p_new_version_number,

Line 825: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,

821: App_Exception.Raise_Exception;
822: END IF;
823: END crspl_ins_unit_ver_note;
824: PROCEDURE crspl_ins_unit_offer_note (
825: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
826: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
827: AS
828: v_unit_offer_note_rec IGS_PS_UNIT_OFR_NOTE%ROWTYPE;
829: v_new_ref_number IGS_GE_NOTE.reference_number%TYPE;

Line 826: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )

822: END IF;
823: END crspl_ins_unit_ver_note;
824: PROCEDURE crspl_ins_unit_offer_note (
825: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
826: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
827: AS
828: v_unit_offer_note_rec IGS_PS_UNIT_OFR_NOTE%ROWTYPE;
829: v_new_ref_number IGS_GE_NOTE.reference_number%TYPE;
830: --- The following cursor excludes notes records with NULL values in the

Line 879: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,

875: App_Exception.Raise_Exception;
876: END IF;
877: END crspl_ins_unit_offer_note;
878: PROCEDURE crspl_ins_teach_resp (
879: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
880: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
881: AS
882: v_teach_resp_rec IGS_PS_TCH_RESP%ROWTYPE;
883: CURSOR c_teach_resp_rec IS

Line 880: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )

876: END IF;
877: END crspl_ins_unit_offer_note;
878: PROCEDURE crspl_ins_teach_resp (
879: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
880: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
881: AS
882: v_teach_resp_rec IGS_PS_TCH_RESP%ROWTYPE;
883: CURSOR c_teach_resp_rec IS
884: SELECT *

Line 921: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,

917: App_Exception.Raise_Exception;
918: END IF;
919: END crspl_ins_teach_resp;
920: PROCEDURE crspl_ins_unit_discipline (
921: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
922: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
923: AS
924: v_unit_discipline_rec IGS_PS_UNIT_DSCP%ROWTYPE;
925: CURSOR c_unit_discipline_rec IS

Line 922: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )

918: END IF;
919: END crspl_ins_teach_resp;
920: PROCEDURE crspl_ins_unit_discipline (
921: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
922: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
923: AS
924: v_unit_discipline_rec IGS_PS_UNIT_DSCP%ROWTYPE;
925: CURSOR c_unit_discipline_rec IS
926: SELECT *

Line 962: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,

958: App_Exception.Raise_Exception;
959: END IF;
960: END crspl_ins_unit_discipline;
961: PROCEDURE crspl_ins_unit_categorisation (
962: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
963: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
964: AS
965: v_unit_cat_rec IGS_PS_UNIT_CATEGORY%ROWTYPE;
966: CURSOR c_unit_cat_rec IS

Line 963: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )

959: END IF;
960: END crspl_ins_unit_discipline;
961: PROCEDURE crspl_ins_unit_categorisation (
962: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
963: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
964: AS
965: v_unit_cat_rec IGS_PS_UNIT_CATEGORY%ROWTYPE;
966: CURSOR c_unit_cat_rec IS
967: SELECT *

Line 1008: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,

1004: App_Exception.Raise_Exception;
1005: END IF;
1006: END crspl_ins_unit_categorisation;
1007: PROCEDURE crspl_ins_crs_unit_lvl (
1008: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
1009: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
1010: AS
1011: v_crs_unit_lvl_rec IGS_PS_UNIT_LVL%ROWTYPE;
1012: CURSOR c_crs_unit_lvl_rec IS

Line 1009: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )

1005: END IF;
1006: END crspl_ins_unit_categorisation;
1007: PROCEDURE crspl_ins_crs_unit_lvl (
1008: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
1009: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
1010: AS
1011: v_crs_unit_lvl_rec IGS_PS_UNIT_LVL%ROWTYPE;
1012: CURSOR c_crs_unit_lvl_rec IS
1013: SELECT *

Line 1059: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,

1055: App_Exception.Raise_Exception;
1056: END IF;
1057: END crspl_ins_crs_unit_lvl;
1058: PROCEDURE crspl_ins_unit_ref_cd (
1059: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
1060: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
1061: AS
1062: v_unit_ref_cd_rec IGS_PS_UNIT_REF_CD%ROWTYPE;
1063: CURSOR c_unit_ref_cd_rec IS

Line 1060: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )

1056: END IF;
1057: END crspl_ins_crs_unit_lvl;
1058: PROCEDURE crspl_ins_unit_ref_cd (
1059: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
1060: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
1061: AS
1062: v_unit_ref_cd_rec IGS_PS_UNIT_REF_CD%ROWTYPE;
1063: CURSOR c_unit_ref_cd_rec IS
1064: SELECT *

Line 1160: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,

1156: App_Exception.Raise_Exception;
1157: END IF;
1158: END crspl_ins_unit_off_opt_note;
1159: PROCEDURE crspl_ins_teach_resp_ovrd(
1160: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
1161: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE,
1162: p_cal_type IN IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
1163: p_ci_sequence_number IN IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
1164: p_location_cd IN IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,

Line 1161: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE,

1157: END IF;
1158: END crspl_ins_unit_off_opt_note;
1159: PROCEDURE crspl_ins_teach_resp_ovrd(
1160: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
1161: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE,
1162: p_cal_type IN IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
1163: p_ci_sequence_number IN IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
1164: p_location_cd IN IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
1165: p_unit_class IN IGS_PS_UNIT_OFR_OPT.unit_class%TYPE,

Line 1185: -- copy old IGS_PS_UNIT_VER IGS_PS_TCH_RESP_OVRD details to

1181:
1182: l_org_id NUMBER(15);
1183: BEGIN
1184: FOR c_tro_rec in c_tro LOOP
1185: -- copy old IGS_PS_UNIT_VER IGS_PS_TCH_RESP_OVRD details to
1186: -- new IGS_PS_UNIT-version
1187: BEGIN
1188: x_rowid := NULL;
1189:

Line 1186: -- new IGS_PS_UNIT-version

1182: l_org_id NUMBER(15);
1183: BEGIN
1184: FOR c_tro_rec in c_tro LOOP
1185: -- copy old IGS_PS_UNIT_VER IGS_PS_TCH_RESP_OVRD details to
1186: -- new IGS_PS_UNIT-version
1187: BEGIN
1188: x_rowid := NULL;
1189:
1190: l_org_id := igs_ge_gen_003.get_org_id;

Line 1269: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv, igs_ps_unit_stat us

1265: cp_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
1266: cp_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE
1267: )IS
1268: SELECT uoo.*
1269: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv, igs_ps_unit_stat us
1270: WHERE uoo.cal_type = cp_cal_type
1271: AND uoo.ci_sequence_number = cp_ci_sequence_number
1272: AND uoo.location_cd = cp_location_cd
1273: AND uoo.unit_class = cp_unit_class

Line 1292: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv, igs_ps_unit_stat us

1288: cp_unit_cd igs_ps_unit_ofr_opt_all.unit_cd%TYPE,
1289: cp_version_number igs_ps_unit_ofr_opt_all.version_number%TYPE
1290: )IS
1291: SELECT uoo.*
1292: FROM igs_ps_unit_ofr_opt_all uoo,igs_ps_unit_ver_all uv, igs_ps_unit_stat us
1293: WHERE uoo.cal_type = cp_cal_type
1294: AND uoo.ci_sequence_number = cp_ci_sequence_number
1295: AND uoo.location_cd = cp_location_cd
1296: AND uoo.unit_class = cp_unit_class

Line 1386: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,

1382: END crspl_upd_usec_relation;
1383:
1384:
1385: PROCEDURE crspl_ins_unit_off_opt (
1386: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
1387: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE,
1388: p_cal_type IN IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
1389: p_ci_sequence_number IN IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE )
1390: AS

Line 1387: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE,

1383:
1384:
1385: PROCEDURE crspl_ins_unit_off_opt (
1386: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
1387: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE,
1388: p_cal_type IN IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
1389: p_ci_sequence_number IN IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE )
1390: AS
1391: /*

Line 1773: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,

1769: * Creation Date : 25 Aug 2000
1770: * Created By : Sreenivas.Bonam
1771: */
1772: PROCEDURE crspl_uofr_wlist_details(
1773: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
1774: p_version_number IN igs_ps_unit_ver.version_number%TYPE,
1775: p_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
1776: p_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE)
1777: AS

Line 1774: p_version_number IN igs_ps_unit_ver.version_number%TYPE,

1770: * Created By : Sreenivas.Bonam
1771: */
1772: PROCEDURE crspl_uofr_wlist_details(
1773: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
1774: p_version_number IN igs_ps_unit_ver.version_number%TYPE,
1775: p_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,
1776: p_ci_sequence_number IN igs_ps_unit_ofr_pat.ci_sequence_number%TYPE)
1777: AS
1778:

Line 1838: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,

1834: END IF;
1835: END crspl_uofr_wlist_details;
1836:
1837: PROCEDURE crspl_ins_unit_off_pat (
1838: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
1839: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE,
1840: p_cal_type IN IGS_PS_UNIT_OFR.cal_type%TYPE )
1841: AS
1842: v_unit_offer_pat_rec IGS_PS_UNIT_OFR_PAT%ROWTYPE;

Line 1839: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE,

1835: END crspl_uofr_wlist_details;
1836:
1837: PROCEDURE crspl_ins_unit_off_pat (
1838: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
1839: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE,
1840: p_cal_type IN IGS_PS_UNIT_OFR.cal_type%TYPE )
1841: AS
1842: v_unit_offer_pat_rec IGS_PS_UNIT_OFR_PAT%ROWTYPE;
1843: --- This cursor is used to select the IGS_PS_UNIT offering pattern with the latest

Line 1933: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,

1929: App_Exception.Raise_Exception;
1930: END IF;
1931: END crspl_ins_unit_off_pat;
1932: PROCEDURE crspl_ins_unit_offer (
1933: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
1934: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
1935: AS
1936: v_unit_offer_rec IGS_PS_UNIT_OFR%ROWTYPE;
1937: CURSOR c_unit_offer_rec IS

Line 1934: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )

1930: END IF;
1931: END crspl_ins_unit_off_pat;
1932: PROCEDURE crspl_ins_unit_offer (
1933: p_unit_cd IN IGS_PS_UNIT_VER.unit_cd%TYPE,
1934: p_version_number IN IGS_PS_UNIT_VER.version_number%TYPE )
1935: AS
1936: v_unit_offer_rec IGS_PS_UNIT_OFR%ROWTYPE;
1937: CURSOR c_unit_offer_rec IS
1938: SELECT *

Line 1988: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,

1984: * Creation Date : 25 Aug 2000
1985: * Created By : Sreenivas.Bonam
1986: */
1987: PROCEDURE crspl_ins_location_details(
1988: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
1989: p_version_number IN igs_ps_unit_ver.version_number%TYPE )
1990: AS
1991: CURSOR c_unit_loc_det IS
1992: SELECT *

Line 1989: p_version_number IN igs_ps_unit_ver.version_number%TYPE )

1985: * Created By : Sreenivas.Bonam
1986: */
1987: PROCEDURE crspl_ins_location_details(
1988: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
1989: p_version_number IN igs_ps_unit_ver.version_number%TYPE )
1990: AS
1991: CURSOR c_unit_loc_det IS
1992: SELECT *
1993: FROM igs_ps_unit_location

Line 2030: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,

2026: * Creation Date : 25 Aug 2000
2027: * Created By : Sreenivas.Bonam
2028: */
2029: PROCEDURE crspl_ins_facility_details(
2030: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
2031: p_version_number IN igs_ps_unit_ver.version_number%TYPE )
2032: AS
2033: CURSOR c_unit_fac_det IS
2034: SELECT *

Line 2031: p_version_number IN igs_ps_unit_ver.version_number%TYPE )

2027: * Created By : Sreenivas.Bonam
2028: */
2029: PROCEDURE crspl_ins_facility_details(
2030: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
2031: p_version_number IN igs_ps_unit_ver.version_number%TYPE )
2032: AS
2033: CURSOR c_unit_fac_det IS
2034: SELECT *
2035: FROM igs_ps_unit_facility

Line 2070: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,

2066: * Creation Date : 25 Aug 2000
2067: * Created By : Sreenivas.Bonam
2068: */
2069: PROCEDURE crspl_ins_cros_ref_details(
2070: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
2071: p_version_number IN igs_ps_unit_ver.version_number%TYPE )
2072: AS
2073: CURSOR c_unit_cros_ref_det IS
2074: SELECT *

Line 2071: p_version_number IN igs_ps_unit_ver.version_number%TYPE )

2067: * Created By : Sreenivas.Bonam
2068: */
2069: PROCEDURE crspl_ins_cros_ref_details(
2070: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
2071: p_version_number IN igs_ps_unit_ver.version_number%TYPE )
2072: AS
2073: CURSOR c_unit_cros_ref_det IS
2074: SELECT *
2075: FROM igs_ps_unit_cros_ref

Line 2112: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,

2108: * Creation Date : 25 Aug 2000
2109: * Created By : Sreenivas.Bonam
2110: */
2111: PROCEDURE crspl_ins_grd_schm_details(
2112: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
2113: p_version_number IN igs_ps_unit_ver.version_number%TYPE )
2114: AS
2115: CURSOR c_unit_grd_schm_det IS
2116: SELECT *

Line 2113: p_version_number IN igs_ps_unit_ver.version_number%TYPE )

2109: * Created By : Sreenivas.Bonam
2110: */
2111: PROCEDURE crspl_ins_grd_schm_details(
2112: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
2113: p_version_number IN igs_ps_unit_ver.version_number%TYPE )
2114: AS
2115: CURSOR c_unit_grd_schm_det IS
2116: SELECT *
2117: FROM igs_ps_unit_grd_schm

Line 2155: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,

2151: * Creation Date : 25 Aug 2000
2152: * Created By : Sreenivas.Bonam
2153: */
2154: PROCEDURE crspl_ins_unt_fld_details(
2155: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
2156: p_version_number IN igs_ps_unit_ver.version_number%TYPE )
2157: AS
2158: CURSOR c_unit_fld_stdy_det IS
2159: SELECT *

Line 2156: p_version_number IN igs_ps_unit_ver.version_number%TYPE )

2152: * Created By : Sreenivas.Bonam
2153: */
2154: PROCEDURE crspl_ins_unt_fld_details(
2155: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
2156: p_version_number IN igs_ps_unit_ver.version_number%TYPE )
2157: AS
2158: CURSOR c_unit_fld_stdy_det IS
2159: SELECT *
2160: FROM igs_ps_unit_fld_stdy

Line 2199: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,

2195: * Creation Date : 03 Jan 2002
2196: * Created By : Nishikant
2197: */
2198: PROCEDURE crsp_ins_appr_ass_itm_grd(
2199: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
2200: p_version_number IN igs_ps_unit_ver.version_number%TYPE
2201: )
2202: AS
2203: CURSOR c_appr_grd_sch IS

Line 2200: p_version_number IN igs_ps_unit_ver.version_number%TYPE

2196: * Created By : Nishikant
2197: */
2198: PROCEDURE crsp_ins_appr_ass_itm_grd(
2199: p_unit_cd IN igs_ps_unit_ver.unit_cd%TYPE,
2200: p_version_number IN igs_ps_unit_ver.version_number%TYPE
2201: )
2202: AS
2203: CURSOR c_appr_grd_sch IS
2204: SELECT *

Line 2278: cp_new_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,

2274:
2275: DECLARE
2276:
2277: CURSOR c_new_unit_vers_rec (
2278: cp_new_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
2279: cp_new_version_number IGS_PS_UNIT_VER.version_number%TYPE ) IS
2280: SELECT 'x'
2281: FROM IGS_PS_UNIT_VER
2282: WHERE unit_cd = cp_new_unit_cd AND

Line 2279: cp_new_version_number IGS_PS_UNIT_VER.version_number%TYPE ) IS

2275: DECLARE
2276:
2277: CURSOR c_new_unit_vers_rec (
2278: cp_new_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
2279: cp_new_version_number IGS_PS_UNIT_VER.version_number%TYPE ) IS
2280: SELECT 'x'
2281: FROM IGS_PS_UNIT_VER
2282: WHERE unit_cd = cp_new_unit_cd AND
2283: version_number = cp_new_version_number;

Line 2281: FROM IGS_PS_UNIT_VER

2277: CURSOR c_new_unit_vers_rec (
2278: cp_new_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
2279: cp_new_version_number IGS_PS_UNIT_VER.version_number%TYPE ) IS
2280: SELECT 'x'
2281: FROM IGS_PS_UNIT_VER
2282: WHERE unit_cd = cp_new_unit_cd AND
2283: version_number = cp_new_version_number;
2284: CURSOR c_old_unit_vers_rec (
2285: cp_old_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,

Line 2285: cp_old_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,

2281: FROM IGS_PS_UNIT_VER
2282: WHERE unit_cd = cp_new_unit_cd AND
2283: version_number = cp_new_version_number;
2284: CURSOR c_old_unit_vers_rec (
2285: cp_old_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
2286: cp_old_version_number IGS_PS_UNIT_VER.version_number%TYPE ) IS
2287: SELECT 'x'
2288: FROM IGS_PS_UNIT_VER
2289: WHERE unit_cd = cp_old_unit_cd AND

Line 2286: cp_old_version_number IGS_PS_UNIT_VER.version_number%TYPE ) IS

2282: WHERE unit_cd = cp_new_unit_cd AND
2283: version_number = cp_new_version_number;
2284: CURSOR c_old_unit_vers_rec (
2285: cp_old_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
2286: cp_old_version_number IGS_PS_UNIT_VER.version_number%TYPE ) IS
2287: SELECT 'x'
2288: FROM IGS_PS_UNIT_VER
2289: WHERE unit_cd = cp_old_unit_cd AND
2290: version_number = cp_old_version_number;

Line 2288: FROM IGS_PS_UNIT_VER

2284: CURSOR c_old_unit_vers_rec (
2285: cp_old_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE,
2286: cp_old_version_number IGS_PS_UNIT_VER.version_number%TYPE ) IS
2287: SELECT 'x'
2288: FROM IGS_PS_UNIT_VER
2289: WHERE unit_cd = cp_old_unit_cd AND
2290: version_number = cp_old_version_number;
2291: l_status NUMBER;
2292:

Line 2296: -- Check if the new IGS_PS_UNIT version exists

2292:
2293: BEGIN
2294: --- Set default message number
2295: p_message_name := 'IGS_PS_SUCCESS_COPY_PRG_VER';
2296: -- Check if the new IGS_PS_UNIT version exists
2297: OPEN c_new_unit_vers_rec(
2298: p_new_unit_cd,
2299: p_new_version_number);
2300: FETCH c_new_unit_vers_rec INTO gv_unit_version_exist;

Line 2307: --- Check if the old IGS_PS_UNIT version exists

2303: CLOSE c_new_unit_vers_rec;
2304: RETURN;
2305: END IF;
2306: CLOSE c_new_unit_vers_rec;
2307: --- Check if the old IGS_PS_UNIT version exists
2308: OPEN c_old_unit_vers_rec(
2309: p_old_unit_cd,
2310: p_old_version_number);
2311: FETCH c_old_unit_vers_rec INTO gv_unit_version_exist;

Line 2318: --- Check if the IGS_PS_UNIT_VER_NOTE record exists for the old IGS_PS_UNIT code and

2314: CLOSE c_old_unit_vers_rec;
2315: RETURN;
2316: END IF;
2317: CLOSE c_old_unit_vers_rec;
2318: --- Check if the IGS_PS_UNIT_VER_NOTE record exists for the old IGS_PS_UNIT code and
2319: --- version number. If it does exist, create the new record with the
2320: --- substituted values. A new IGS_GE_NOTE record must be created as well.
2321: crspl_ins_unit_ver_note(
2322: p_old_unit_cd,

Line 2723: igs_ps_unit_ver_all uv,

2719: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2720: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2721: SELECT uoo.*
2722: FROM igs_ps_unit_ofr_opt uoo,
2723: igs_ps_unit_ver_all uv,
2724: igs_ps_unit_stat us
2725: WHERE uoo.unit_cd = cp_unit_cd
2726: AND uoo.version_number = cp_version_number
2727: AND uoo.location_cd = cp_location_cd

Line 2776: igs_ps_unit_ver_all uv,

2772: cp_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE,
2773: cp_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE) IS
2774: SELECT uoo.uoo_id,uoo.sup_uoo_id
2775: FROM igs_ps_unit_ofr_opt uoo,
2776: igs_ps_unit_ver_all uv,
2777: igs_ps_unit_stat us
2778: WHERE uoo.unit_cd = cp_unit_cd
2779: AND uoo.version_number = cp_version_number
2780: AND uoo.location_cd = cp_location_cd