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_001 dependencies on IGS_PS_VER

Line 74: gv_cv_rec IGS_PS_VER%ROWTYPE;

70: -------------------------------------------------------------------------------------------
71: cst_ret_message_name CONSTANT VARCHAR2(30) := 'IGS_PS_FAIL_COPY_PRGVER_DETAI';
72: cst_max_error_range CONSTANT NUMBER := -20999;
73: cst_min_error_range CONSTANT NUMBER := -20000;
74: gv_cv_rec IGS_PS_VER%ROWTYPE;
75: gv_con_rec IGS_PS_OFR_NOTE%ROWTYPE;
76: gv_coon_rec IGS_PS_OFR_OPT_NOTE%ROWTYPE;
77: gv_co_rec IGS_PS_OFR%ROWTYPE;
78: gv_coo_rec IGS_PS_OFR_OPT%ROWTYPE;

Line 90: gv_cvn_rec IGS_PS_VER_NOTE%ROWTYPE;

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;
94: gv_cfos_rec IGS_PS_FIELD_STUDY%ROWTYPE;

Line 121: FROM IGS_PS_VER

117:
118:
119: CURSOR gc_cv_old_rec IS
120: SELECT *
121: FROM IGS_PS_VER
122: WHERE course_cd = p_old_course_cd AND
123: version_number = p_old_version_number;
124: CURSOR gc_cv_new_rec IS
125: SELECT *

Line 126: FROM IGS_PS_VER

122: WHERE course_cd = p_old_course_cd AND
123: version_number = p_old_version_number;
124: CURSOR gc_cv_new_rec IS
125: SELECT *
126: FROM IGS_PS_VER
127: WHERE course_cd = p_new_course_cd AND
128: version_number = p_new_version_number;
129: CURSOR gc_ca_rec IS
130: SELECT *

Line 150: FROM IGS_PS_VER_NOTE cvn

146: -- Only interested in notes that are not OLE type as
147: -- currently unable to copy long raw field within PL/SQL
148: CURSOR gc_cvn_rec IS
149: SELECT *
150: FROM IGS_PS_VER_NOTE cvn
151: WHERE cvn.course_cd = p_old_course_cd AND
152: cvn.version_number = p_old_version_number AND
153: EXISTS (SELECT 1
154: FROM IGS_GE_NOTE nte

Line 287: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

283: FROM DUAL;
284:
285: -- procedure for inserting new IGS_GE_NOTE and IGS_PS_OFR_OPT_NOTE records
286: PROCEDURE crsp_ins_coon_rec (
287: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
288: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
289:
290: CURSOR Cur_SGN IS
291: SELECT rowid,IGS_GE_NOTE.*

Line 288: p_new_version_number IGS_PS_VER.version_number%TYPE) AS

284:
285: -- procedure for inserting new IGS_GE_NOTE and IGS_PS_OFR_OPT_NOTE records
286: PROCEDURE crsp_ins_coon_rec (
287: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
288: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
289:
290: CURSOR Cur_SGN IS
291: SELECT rowid,IGS_GE_NOTE.*
292: FROM IGS_GE_NOTE

Line 340: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

336: END crsp_ins_coon_rec;
337: -- procedure for inserting new IGS_GE_NOTE and IGS_PS_OFR_PAT_NOTE records
338:
339: PROCEDURE crsp_ins_copn_rec (
340: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
341: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
342: CURSOR Cur_SGN
343: IS
344: SELECT

Line 341: p_new_version_number IGS_PS_VER.version_number%TYPE) AS

337: -- procedure for inserting new IGS_GE_NOTE and IGS_PS_OFR_PAT_NOTE records
338:
339: PROCEDURE crsp_ins_copn_rec (
340: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
341: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
342: CURSOR Cur_SGN
343: IS
344: SELECT
345: rowid , IGS_GE_NOTE.*

Line 395: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

391: END crsp_ins_copn_rec;
392: -- procedure for inserting new IGS_GE_NOTE and IGS_PS_OFR_PAT records
393:
394: PROCEDURE crsp_ins_cop_rec (
395: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
396: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
397: BEGIN
398: DECLARE
399: v_gs_version_number IGS_AS_GRD_SCHEMA.version_number%TYPE;

Line 396: p_new_version_number IGS_PS_VER.version_number%TYPE) AS

392: -- procedure for inserting new IGS_GE_NOTE and IGS_PS_OFR_PAT records
393:
394: PROCEDURE crsp_ins_cop_rec (
395: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
396: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
397: BEGIN
398: DECLARE
399: v_gs_version_number IGS_AS_GRD_SCHEMA.version_number%TYPE;
400: v_message_name VARCHAR2(30);

Line 500: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

496: END IF;
497: END crsp_ins_cop_rec;
498: -- procedure for inserting new IGS_GE_NOTE and IGS_PS_OFR_NOTE records
499: PROCEDURE crsp_ins_con_rec (
500: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
501: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
502: CURSOR
503: Cur_SGN
504: IS

Line 501: p_new_version_number IGS_PS_VER.version_number%TYPE) AS

497: END crsp_ins_cop_rec;
498: -- procedure for inserting new IGS_GE_NOTE and IGS_PS_OFR_NOTE records
499: PROCEDURE crsp_ins_con_rec (
500: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
501: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
502: CURSOR
503: Cur_SGN
504: IS
505: SELECT

Line 550: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

546: END IF;
547: END crsp_ins_con_rec;
548: -- procedure for inserting new IGS_PS_ENT_PT_REF_CD records
549: PROCEDURE crsp_ins_ceprcd_rec (
550: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
551: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
552: BEGIN
553: x_rowid := NULL;
554: IGS_PS_ENT_PT_REF_CD_PKG.INSERT_ROW(

Line 551: p_new_version_number IGS_PS_VER.version_number%TYPE) AS

547: END crsp_ins_con_rec;
548: -- procedure for inserting new IGS_PS_ENT_PT_REF_CD records
549: PROCEDURE crsp_ins_ceprcd_rec (
550: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
551: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
552: BEGIN
553: x_rowid := NULL;
554: IGS_PS_ENT_PT_REF_CD_PKG.INSERT_ROW(
555: X_ROWID => x_rowid,

Line 691: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

687: -- procedure for inserting new IGS_PS_OFR_OPT records
688: --modified by shtatiko on 21-OCT-2002 to incorporate the addition of two new columns to IGS_PS_OFR_OPT viz. program_length, program_length_measurement.
689: --this has been done as per bug# 2608227.
690: PROCEDURE crsp_ins_coo_rec(
691: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
692: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
693: BEGIN
694: DECLARE
695: CURSOR c_coous IS

Line 692: p_new_version_number IGS_PS_VER.version_number%TYPE) AS

688: --modified by shtatiko on 21-OCT-2002 to incorporate the addition of two new columns to IGS_PS_OFR_OPT viz. program_length, program_length_measurement.
689: --this has been done as per bug# 2608227.
690: PROCEDURE crsp_ins_coo_rec(
691: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
692: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
693: BEGIN
694: DECLARE
695: CURSOR c_coous IS
696: SELECT coous.cal_type,

Line 834: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

830: END IF;
831: END crsp_ins_coo_rec;
832: -- procedure for inserting new IGS_PS_OFR_INST records
833: PROCEDURE crsp_ins_coi_rec (
834: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
835: p_new_version_number IGS_PS_VER.version_number%TYPE)
836: IS
837: BEGIN
838: DECLARE

Line 835: p_new_version_number IGS_PS_VER.version_number%TYPE)

831: END crsp_ins_coo_rec;
832: -- procedure for inserting new IGS_PS_OFR_INST records
833: PROCEDURE crsp_ins_coi_rec (
834: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
835: p_new_version_number IGS_PS_VER.version_number%TYPE)
836: IS
837: BEGIN
838: DECLARE
839: CURSOR c_coo_new (

Line 1202: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

1198: END IF;
1199: END crspl_ins_cous_rec;
1200: -- procedure for inserting new IGS_PS_OFR records
1201: PROCEDURE crsp_ins_co_rec (
1202: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1203: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1204:
1205: l_org_id NUMBER(15);
1206: BEGIN

Line 1203: p_new_version_number IGS_PS_VER.version_number%TYPE) AS

1199: END crspl_ins_cous_rec;
1200: -- procedure for inserting new IGS_PS_OFR records
1201: PROCEDURE crsp_ins_co_rec (
1202: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1203: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1204:
1205: l_org_id NUMBER(15);
1206: BEGIN
1207: X_ROWID := NULL;

Line 1287: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

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
1290: X_ROWID := NULL ;
1291: IGS_PS_AWD_OWN_PKG.INSERT_ROW(

Line 1288: p_new_version_number IGS_PS_VER.version_number%TYPE) AS

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
1290: X_ROWID := NULL ;
1291: IGS_PS_AWD_OWN_PKG.INSERT_ROW(
1292: X_ROWID => x_rowid,

Line 1311: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

1307: END IF;
1308: END crsp_ins_cao_rec;
1309: -- procedure for inserting new IGS_PS_ANL_LOAD_U_LN records
1310: PROCEDURE crsp_ins_calulink_rec (
1311: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1312: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1313: BEGIN
1314: x_rowid := NULL;
1315: IGS_PS_ANL_LOAD_U_LN_PKG.INSERT_ROW(

Line 1312: p_new_version_number IGS_PS_VER.version_number%TYPE) AS

1308: END crsp_ins_cao_rec;
1309: -- procedure for inserting new IGS_PS_ANL_LOAD_U_LN records
1310: PROCEDURE crsp_ins_calulink_rec (
1311: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1312: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1313: BEGIN
1314: x_rowid := NULL;
1315: IGS_PS_ANL_LOAD_U_LN_PKG.INSERT_ROW(
1316: X_ROWID => x_rowid,

Line 1335: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

1331: END IF;
1332: END crsp_ins_calulink_rec;
1333: -- procedure for inserting new IGS_PS_AWARD records
1334: PROCEDURE crsp_ins_ca_rec (
1335: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1336: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1337: BEGIN
1338: -- Bug#2983445 Removed the column award_title from call to igs_ps_award_pkg.insert_row.
1339: -- inserting IGS_PS_AWARD records

Line 1336: p_new_version_number IGS_PS_VER.version_number%TYPE) AS

1332: END crsp_ins_calulink_rec;
1333: -- procedure for inserting new IGS_PS_AWARD records
1334: PROCEDURE crsp_ins_ca_rec (
1335: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1336: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1337: BEGIN
1338: -- Bug#2983445 Removed the column award_title from call to igs_ps_award_pkg.insert_row.
1339: -- inserting IGS_PS_AWARD records
1340:

Line 1377: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

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
1380: X_ROWID := NULL ;
1381: IGS_PS_OWN_PKG.INSERT_ROW(

Line 1378: p_new_version_number IGS_PS_VER.version_number%TYPE) AS

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
1380: X_ROWID := NULL ;
1381: IGS_PS_OWN_PKG.INSERT_ROW(
1382: X_ROWID => x_rowid,

Line 1400: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

1396: END IF;
1397: END crsp_ins_cow_rec;
1398: -- procedure for inserting new IGS_PE_ALTERNATV_EXT records
1399: PROCEDURE crsp_ins_ae_rec (
1400: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1401: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1402: BEGIN
1403: X_ROWID := NULL;
1404: IGS_PE_ALTERNATV_EXT_PKG.INSERT_ROW(

Line 1401: p_new_version_number IGS_PS_VER.version_number%TYPE) AS

1397: END crsp_ins_cow_rec;
1398: -- procedure for inserting new IGS_PE_ALTERNATV_EXT records
1399: PROCEDURE crsp_ins_ae_rec (
1400: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1401: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1402: BEGIN
1403: X_ROWID := NULL;
1404: IGS_PE_ALTERNATV_EXT_PKG.INSERT_ROW(
1405: X_ROWID => X_ROWID,

Line 1422: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

1418: END IF;
1419: END crsp_ins_ae_rec;
1420: -- procedure for inserting new IGS_PS_GRP_MBR records
1421: PROCEDURE crsp_ins_cgm_rec (
1422: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1423: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1424: BEGIN
1425: x_rowid := NULL;
1426: IGS_PS_GRP_MBR_PKG.INSERT_ROW(

Line 1423: p_new_version_number IGS_PS_VER.version_number%TYPE) AS

1419: END crsp_ins_ae_rec;
1420: -- procedure for inserting new IGS_PS_GRP_MBR records
1421: PROCEDURE crsp_ins_cgm_rec (
1422: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1423: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1424: BEGIN
1425: x_rowid := NULL;
1426: IGS_PS_GRP_MBR_PKG.INSERT_ROW(
1427: X_ROWID => x_rowid,

Line 1449: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

1445: -- Replaced the string 'Y' with gv_fsr_rec.restricted_ind as the parameter being passed to X_RESTRICTED_IND
1446:
1447:
1448: PROCEDURE crsp_ins_fsr_rec (
1449: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1450: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1451: BEGIN
1452: x_rowid := NULL;
1453: IGS_FI_FND_SRC_RSTN_PKG.INSERT_ROW(

Line 1450: p_new_version_number IGS_PS_VER.version_number%TYPE) AS

1446:
1447:
1448: PROCEDURE crsp_ins_fsr_rec (
1449: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1450: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1451: BEGIN
1452: x_rowid := NULL;
1453: IGS_FI_FND_SRC_RSTN_PKG.INSERT_ROW(
1454: X_ROWID => x_rowid,

Line 1472: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

1468: END IF;
1469: END crsp_ins_fsr_rec;
1470: -- procedure for inserting new IGS_PS_FIELD_STUDY records
1471: PROCEDURE crsp_ins_cfos_rec (
1472: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1473: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1474: BEGIN
1475: x_rowid := NULL;
1476: IGS_PS_FIELD_STUDY_PKG.INSERT_ROW(

Line 1473: p_new_version_number IGS_PS_VER.version_number%TYPE) AS

1469: END crsp_ins_fsr_rec;
1470: -- procedure for inserting new IGS_PS_FIELD_STUDY records
1471: PROCEDURE crsp_ins_cfos_rec (
1472: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1473: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1474: BEGIN
1475: x_rowid := NULL;
1476: IGS_PS_FIELD_STUDY_PKG.INSERT_ROW(
1477: X_ROWID => x_rowid,

Line 1495: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

1491: END IF;
1492: END crsp_ins_cfos_rec;
1493: -- procedure for inserting new IGS_PS_CATEGORISE records
1494: PROCEDURE crsp_ins_ccat_rec (
1495: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1496: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1497:
1498: l_org_id NUMBER(15);
1499: BEGIN

Line 1496: p_new_version_number IGS_PS_VER.version_number%TYPE) AS

1492: END crsp_ins_cfos_rec;
1493: -- procedure for inserting new IGS_PS_CATEGORISE records
1494: PROCEDURE crsp_ins_ccat_rec (
1495: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1496: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1497:
1498: l_org_id NUMBER(15);
1499: BEGIN
1500: x_rowid := NULL;

Line 1520: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

1516: END IF;
1517: END crsp_ins_ccat_rec;
1518: -- procedure for inserting new IGS_PS_REF_CD records
1519: PROCEDURE crsp_ins_crcd_rec (
1520: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1521: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1522: BEGIN
1523: x_rowid := NULL;
1524: IGS_PS_REF_CD_PKG.INSERT_ROW(

Line 1521: p_new_version_number IGS_PS_VER.version_number%TYPE) AS

1517: END crsp_ins_ccat_rec;
1518: -- procedure for inserting new IGS_PS_REF_CD records
1519: PROCEDURE crsp_ins_crcd_rec (
1520: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1521: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1522: BEGIN
1523: x_rowid := NULL;
1524: IGS_PS_REF_CD_PKG.INSERT_ROW(
1525: X_ROWID => x_rowid,

Line 1543: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

1539: END IF;
1540: END crsp_ins_crcd_rec;
1541: -- procedure for inserting new IGS_PS_ANL_LOAD records
1542: PROCEDURE crsp_ins_cal_rec (
1543: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1544: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1545: BEGIN
1546: x_rowid := NULL;
1547: IGS_PS_ANL_LOAD_PKG.INSERT_ROW(

Line 1544: p_new_version_number IGS_PS_VER.version_number%TYPE) AS

1540: END crsp_ins_crcd_rec;
1541: -- procedure for inserting new IGS_PS_ANL_LOAD records
1542: PROCEDURE crsp_ins_cal_rec (
1543: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1544: p_new_version_number IGS_PS_VER.version_number%TYPE) AS
1545: BEGIN
1546: x_rowid := NULL;
1547: IGS_PS_ANL_LOAD_PKG.INSERT_ROW(
1548: X_ROWID => x_rowid,

Line 1577: -- inserting new IGS_GE_NOTE and IGS_PS_VER_NOTE records

1573: ELSE
1574: App_Exception.Raise_Exception;
1575: END IF;
1576: END crsp_ins_cal_rec;
1577: -- inserting new IGS_GE_NOTE and IGS_PS_VER_NOTE records
1578: PROCEDURE crsp_ins_cvn_rec (
1579: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1580: p_new_version_number IGS_PS_VER.version_number%TYPE)
1581: AS

Line 1579: p_new_course_cd IGS_PS_VER.course_cd%TYPE,

1575: END IF;
1576: END crsp_ins_cal_rec;
1577: -- inserting new IGS_GE_NOTE and IGS_PS_VER_NOTE records
1578: PROCEDURE crsp_ins_cvn_rec (
1579: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1580: p_new_version_number IGS_PS_VER.version_number%TYPE)
1581: AS
1582: CURSOR Cur_SGN IS
1583: SELECT rowid,IGS_GE_NOTE.*

Line 1580: p_new_version_number IGS_PS_VER.version_number%TYPE)

1576: END crsp_ins_cal_rec;
1577: -- inserting new IGS_GE_NOTE and IGS_PS_VER_NOTE records
1578: PROCEDURE crsp_ins_cvn_rec (
1579: p_new_course_cd IGS_PS_VER.course_cd%TYPE,
1580: p_new_version_number IGS_PS_VER.version_number%TYPE)
1581: AS
1582: CURSOR Cur_SGN IS
1583: SELECT rowid,IGS_GE_NOTE.*
1584: FROM IGS_GE_NOTE

Line 1604: -- inserting new IGS_PS_VER_NOTE records

1600: X_S_NOTE_FORMAT_TYPE => Rec_SGN.s_note_format_type,
1601: X_NOTE_TEXT =>Rec_SGN.note_text,
1602: X_MODE =>'R');
1603: END LOOP;
1604: -- inserting new IGS_PS_VER_NOTE records
1605: x_rowid := NULL;
1606: IGS_PS_VER_NOTE_PKG.INSERT_ROW(
1607: X_ROWID => x_rowid,
1608: X_COURSE_CD => p_new_course_cd,

Line 1606: IGS_PS_VER_NOTE_PKG.INSERT_ROW(

1602: X_MODE =>'R');
1603: END LOOP;
1604: -- inserting new IGS_PS_VER_NOTE records
1605: x_rowid := NULL;
1606: IGS_PS_VER_NOTE_PKG.INSERT_ROW(
1607: X_ROWID => x_rowid,
1608: X_COURSE_CD => p_new_course_cd,
1609: X_VERSION_NUMBER => p_new_version_number,
1610: X_REFERENCE_NUMBER => gv_ref_num,

Line 1719: v_new_rul_seq_number IGS_PS_VER_RU.rul_sequence_number%TYPE;

1715: PROCEDURE crspl_ins_cvr_rec
1716: AS
1717: BEGIN
1718: DECLARE
1719: v_new_rul_seq_number IGS_PS_VER_RU.rul_sequence_number%TYPE;
1720: CURSOR c_cvr IS
1721: SELECT cvr.s_rule_call_cd,
1722: cvr.rul_sequence_number
1723: FROM IGS_PS_VER_RU cvr

Line 1723: FROM IGS_PS_VER_RU cvr

1719: v_new_rul_seq_number IGS_PS_VER_RU.rul_sequence_number%TYPE;
1720: CURSOR c_cvr IS
1721: SELECT cvr.s_rule_call_cd,
1722: cvr.rul_sequence_number
1723: FROM IGS_PS_VER_RU cvr
1724: WHERE cvr.course_cd = p_old_course_cd AND
1725: cvr.version_number = p_old_version_number;
1726: BEGIN
1727: FOR v_cvr_rec IN c_cvr LOOP

Line 1733: IGS_PS_VER_RU_PKG.INSERT_ROW(

1729: v_new_rul_seq_number := IGS_RU_GEN_003.rulp_ins_copy_rule(
1730: v_cvr_rec.s_rule_call_cd,
1731: v_cvr_rec.rul_sequence_number);
1732: x_rowid := NULL;
1733: IGS_PS_VER_RU_PKG.INSERT_ROW(
1734: X_ROWID => x_rowid,
1735: X_COURSE_CD => p_new_course_cd,
1736: X_VERSION_NUMBER => p_new_version_number,
1737: X_S_RULE_CALL_CD => v_cvr_rec.s_rule_call_cd,

Line 2008: -- calling procedure to insert IGS_PS_VER_NOTE records

2004: EXIT;
2005: END IF;
2006: END LOOP;
2007: CLOSE gc_cal_rec;
2008: -- calling procedure to insert IGS_PS_VER_NOTE records
2009: OPEN gc_cvn_rec;
2010: LOOP
2011: FETCH gc_cvn_rec INTO gv_cvn_rec;
2012: IF gc_cvn_rec%FOUND THEN

Line 2036: -- calling procedure to insert IGS_PS_VER_RU records

2032:
2033: -- calling procedure to insert IGS_PS_STAGE records and its
2034: -- child records
2035: crspl_ins_cst_rec;
2036: -- calling procedure to insert IGS_PS_VER_RU records
2037: crspl_ins_cvr_rec;
2038: -- calling procedure to insert IGS_RE_DFLT_MS_SET records
2039: crspl_ins_dms_rec;
2040: