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.

APPS.IGS_PS_UNIT_OFR_OPT_PKG dependencies on IGS_PS_UNIT_OFR_OPT_ALL

Line 17: old_references IGS_PS_UNIT_OFR_OPT_ALL%RowType;

13: rgangara 07-May-2001 Added Ss
14: (reverse chronological order - newest change first)
15: ***************************************************************/
16: l_rowid VARCHAR2(25);
17: old_references IGS_PS_UNIT_OFR_OPT_ALL%RowType;
18: new_references IGS_PS_UNIT_OFR_OPT_ALL%RowType;
19:
20: PROCEDURE beforerowdelete AS
21: ------------------------------------------------------------------

Line 18: new_references IGS_PS_UNIT_OFR_OPT_ALL%RowType;

14: (reverse chronological order - newest change first)
15: ***************************************************************/
16: l_rowid VARCHAR2(25);
17: old_references IGS_PS_UNIT_OFR_OPT_ALL%RowType;
18: new_references IGS_PS_UNIT_OFR_OPT_ALL%RowType;
19:
20: PROCEDURE beforerowdelete AS
21: ------------------------------------------------------------------
22: --Created by : SMVK, Oracle India

Line 69: CURSOR c_discontin(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

65: -------------------------------------------------------------------
66:
67:
68: -- Cursor to check whether any unit attempt exists for the unit section with unit attempt status other than 'DISCONTIN' and 'DROPPED'.
69: CURSOR c_discontin(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
70: SELECT unit_attempt_status
71: FROM igs_en_su_attempt_all
72: WHERE uoo_id= cp_n_uoo_id
73: AND unit_attempt_status NOT IN ('DISCONTIN', 'DROPPED')

Line 79: CURSOR c_exist (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

75:
76: l_c_unit_attempt_status igs_en_su_attempt_all.unit_attempt_status%TYPE;
77:
78: -- Cursor to check whether any unit attempt exists for the unit section.
79: CURSOR c_exist (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
80: SELECT 1
81: FROM igs_en_su_attempt_all
82: WHERE uoo_id = cp_n_uoo_id
83: AND ROWNUM < 2 ;

Line 89: CURSOR c_enrollment_status(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

85: l_n_exist NUMBER;
86:
87: -- Cursor to check whether unit attempt exists for the unit section in unit attempt statuses
88: -- other than 'DISCONTIN','DROPPED','COMPLETED','DUPLICATE'
89: CURSOR c_enrollment_status(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
90: SELECT DISTINCT unit_attempt_status
91: FROM igs_en_su_attempt_all
92: WHERE uoo_id = cp_n_uoo_id
93: AND unit_attempt_status NOT IN ('DISCONTIN','DROPPED','COMPLETED','DUPLICATE');

Line 97: CURSOR c_unit_sts (cp_n_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.UOO_ID%TYPE) IS

93: AND unit_attempt_status NOT IN ('DISCONTIN','DROPPED','COMPLETED','DUPLICATE');
94:
95:
96: -- Cursor to get system unit status for the unit section.
97: CURSOR c_unit_sts (cp_n_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.UOO_ID%TYPE) IS
98: SELECT a.s_unit_status
99: FROM igs_ps_unit_stat a,
100: igs_ps_unit_ver_all b,
101: igs_ps_unit_ofr_opt_all c

Line 101: igs_ps_unit_ofr_opt_all c

97: CURSOR c_unit_sts (cp_n_uoo_id IN IGS_PS_UNIT_OFR_OPT_ALL.UOO_ID%TYPE) IS
98: SELECT a.s_unit_status
99: FROM igs_ps_unit_stat a,
100: igs_ps_unit_ver_all b,
101: igs_ps_unit_ofr_opt_all c
102: WHERE a.unit_status = b.unit_status
103: AND b.unit_cd = c.unit_cd
104: AND b.version_number = c.version_number
105: AND c.uoo_id = cp_n_uoo_id;

Line 325: FROM IGS_PS_UNIT_OFR_OPT_ALL

321: (reverse chronological order - newest change first)
322: ***************************************************************/
323: CURSOR cur_old_ref_values IS
324: SELECT *
325: FROM IGS_PS_UNIT_OFR_OPT_ALL
326: WHERE rowid = x_rowid;
327:
328: BEGIN
329:

Line 409: v_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE;

405: p_inserting IN BOOLEAN ,
406: p_updating IN BOOLEAN ,
407: p_deleting IN BOOLEAN
408: ) AS
409: v_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE;
410: v_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE;
411: v_cal_type IGS_PS_UNIT_OFR_OPT_ALL.cal_type%TYPE;
412: v_ci_sequence_number IGS_PS_UNIT_OFR_OPT_ALL.ci_sequence_number%TYPE;
413: v_message_name Varchar2(30);

Line 410: v_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE;

406: p_updating IN BOOLEAN ,
407: p_deleting IN BOOLEAN
408: ) AS
409: v_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE;
410: v_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE;
411: v_cal_type IGS_PS_UNIT_OFR_OPT_ALL.cal_type%TYPE;
412: v_ci_sequence_number IGS_PS_UNIT_OFR_OPT_ALL.ci_sequence_number%TYPE;
413: v_message_name Varchar2(30);
414: BEGIN

Line 411: v_cal_type IGS_PS_UNIT_OFR_OPT_ALL.cal_type%TYPE;

407: p_deleting IN BOOLEAN
408: ) AS
409: v_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE;
410: v_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE;
411: v_cal_type IGS_PS_UNIT_OFR_OPT_ALL.cal_type%TYPE;
412: v_ci_sequence_number IGS_PS_UNIT_OFR_OPT_ALL.ci_sequence_number%TYPE;
413: v_message_name Varchar2(30);
414: BEGIN
415:

Line 412: v_ci_sequence_number IGS_PS_UNIT_OFR_OPT_ALL.ci_sequence_number%TYPE;

408: ) AS
409: v_unit_cd IGS_PS_UNIT_OFR_OPT_ALL.unit_cd%TYPE;
410: v_version_number IGS_PS_UNIT_OFR_OPT_ALL.version_number%TYPE;
411: v_cal_type IGS_PS_UNIT_OFR_OPT_ALL.cal_type%TYPE;
412: v_ci_sequence_number IGS_PS_UNIT_OFR_OPT_ALL.ci_sequence_number%TYPE;
413: v_message_name Varchar2(30);
414: BEGIN
415:
416: -- Validation : Unit Section Start Date is mandatory for Non Standard Unit Section

Line 555: CURSOR cur_detail (cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,

551: FROM igs_ca_load_to_teach_v
552: WHERE load_cal_type=cp_cal_type
553: AND load_ci_sequence_number=cp_sequence_number;
554:
555: CURSOR cur_detail (cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
556: cp_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE) IS
557: SELECT 'X'
558: FROM igs_ps_unit_ofr_opt_all
559: WHERE cal_type=cp_cal_type

Line 556: cp_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE) IS

552: WHERE load_cal_type=cp_cal_type
553: AND load_ci_sequence_number=cp_sequence_number;
554:
555: CURSOR cur_detail (cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
556: cp_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE) IS
557: SELECT 'X'
558: FROM igs_ps_unit_ofr_opt_all
559: WHERE cal_type=cp_cal_type
560: AND ci_sequence_number=cp_sequence_number

Line 558: FROM igs_ps_unit_ofr_opt_all

554:
555: CURSOR cur_detail (cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,
556: cp_sequence_number igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE) IS
557: SELECT 'X'
558: FROM igs_ps_unit_ofr_opt_all
559: WHERE cal_type=cp_cal_type
560: AND ci_sequence_number=cp_sequence_number
561: AND call_number=p_call_number
562: AND (rowid <> p_rowid OR (p_rowid IS NULL))

Line 592: sarakshi 09-Apr-2002 Removed the unique key igs_ps_unit_ofr_opt_all_uk2, hence removing the

588: Purpose :
589: Know limitations, enhancements or remarks
590: Change History
591: Who When What
592: sarakshi 09-Apr-2002 Removed the unique key igs_ps_unit_ofr_opt_all_uk2, hence removing the
593: call to the get_uk2_for_validation , bug#1689872
594: (reverse chronological order - newest change first)
595: ***************************************************************/
596: BEGIN

Line 1082: FROM IGS_PS_UNIT_OFR_OPT_ALL

1078: ***************************************************************/
1079:
1080: CURSOR cur_rowid IS
1081: SELECT rowid
1082: FROM IGS_PS_UNIT_OFR_OPT_ALL
1083: WHERE sup_uoo_id=x_uoo_id;
1084:
1085: lv_rowid cur_rowid%RowType;
1086:

Line 1110: svuppala 15-JUL-2005 Enh 3442712 - Called igs_fi_invln_int_pkg.get_fk_igs_ps_unit_ofr_opt_all

1106: Purpose :
1107: Know limitations, enhancements or remarks
1108: Change History
1109: Who When What
1110: svuppala 15-JUL-2005 Enh 3442712 - Called igs_fi_invln_int_pkg.get_fk_igs_ps_unit_ofr_opt_all
1111: sarakshi 27-Jul-2004 Bug#3795883, shifted Uk related child to Check_UK_Child_Existance procedure.
1112: sarakshi 15-sep-2003 Enh#2520994,added a call to igs_ps_usec_pri_pkg.get_ufk_igs_ps_unit_ofr_opt
1113: vvutukur 10-Jun-2003 Enh#2831572.Financial Accounting Build.Added call to igs_fi_ftci_accts_pkg.get_ufk_igs_ps_unit_ofr_opt.
1114: smvk 08-May-2003 Bug #2532094. Added child table call igs_ps_usec_x_grpmem_pkg.get_ufk_igs_ps_unit_ofr_opt.

Line 1172: igs_fi_invln_int_pkg.get_fk_igs_ps_unit_ofr_opt_all (

1168: old_references.location_cd,
1169: old_references.unit_class
1170: );
1171:
1172: igs_fi_invln_int_pkg.get_fk_igs_ps_unit_ofr_opt_all (
1173: old_references.uoo_id
1174: );
1175:
1176: END Check_Child_Existance;

Line 1284: FROM IGS_PS_UNIT_OFR_OPT_ALL

1280: ***************************************************************/
1281:
1282: CURSOR cur_rowid IS
1283: SELECT rowid
1284: FROM IGS_PS_UNIT_OFR_OPT_ALL
1285: WHERE unit_cd = x_unit_cd
1286: AND version_number = x_version_number
1287: AND cal_type = x_cal_type
1288: AND ci_sequence_number = x_ci_sequence_number

Line 1295: FROM IGS_PS_UNIT_OFR_OPT_ALL

1291: FOR UPDATE NOWAIT;
1292:
1293: CURSOR cur_status IS
1294: SELECT unit_section_status
1295: FROM IGS_PS_UNIT_OFR_OPT_ALL
1296: WHERE unit_cd = x_unit_cd
1297: AND version_number = x_version_number
1298: AND cal_type = x_cal_type
1299: AND ci_sequence_number = x_ci_sequence_number

Line 1304: l_c_usec_status igs_ps_unit_ofr_opt_all.unit_section_status%TYPE;

1300: AND location_cd = x_location_cd
1301: AND unit_class = x_unit_class;
1302:
1303: lv_rowid cur_rowid%RowType;
1304: l_c_usec_status igs_ps_unit_ofr_opt_all.unit_section_status%TYPE;
1305:
1306: BEGIN
1307:
1308: OPEN cur_status ;

Line 1348: FROM IGS_PS_UNIT_OFR_OPT_ALL

1344: ***************************************************************/
1345:
1346: CURSOR cur_rowid IS
1347: SELECT rowid
1348: FROM IGS_PS_UNIT_OFR_OPT_ALL
1349: WHERE uoo_id = x_uoo_id
1350: AND (l_rowid IS NULL OR rowid <> l_rowid)
1351: FOR UPDATE NOWAIT;
1352:

Line 1355: FROM IGS_PS_UNIT_OFR_OPT_ALL

1351: FOR UPDATE NOWAIT;
1352:
1353: CURSOR cur_status IS
1354: SELECT unit_section_status
1355: FROM IGS_PS_UNIT_OFR_OPT_ALL
1356: WHERE uoo_id = x_uoo_id
1357: AND (l_rowid IS NULL OR rowid <> l_rowid);
1358:
1359: lv_rowid cur_rowid%RowType;

Line 1360: l_c_usec_status igs_ps_unit_ofr_opt_all.unit_section_status%TYPE;

1356: WHERE uoo_id = x_uoo_id
1357: AND (l_rowid IS NULL OR rowid <> l_rowid);
1358:
1359: lv_rowid cur_rowid%RowType;
1360: l_c_usec_status igs_ps_unit_ofr_opt_all.unit_section_status%TYPE;
1361:
1362: BEGIN
1363: OPEN cur_status ;
1364: FETCH cur_status INTO l_c_usec_status;

Line 1405: FROM IGS_PS_UNIT_OFR_OPT_ALL

1401: ***************************************************************/
1402:
1403: CURSOR cur_rowid IS
1404: SELECT rowid
1405: FROM IGS_PS_UNIT_OFR_OPT_ALL
1406: WHERE grading_schema_cd = x_grading_schema_cd
1407: AND gs_version_number = x_version_number ;
1408:
1409: lv_rowid cur_rowid%RowType;

Line 1442: FROM IGS_PS_UNIT_OFR_OPT_ALL

1438: ***************************************************************/
1439:
1440: CURSOR cur_rowid IS
1441: SELECT rowid
1442: FROM IGS_PS_UNIT_OFR_OPT_ALL
1443: WHERE location_cd = x_location_cd ;
1444:
1445: lv_rowid cur_rowid%RowType;
1446:

Line 1478: FROM IGS_PS_UNIT_OFR_OPT_ALL

1474: ***************************************************************/
1475:
1476: CURSOR cur_rowid IS
1477: SELECT rowid
1478: FROM IGS_PS_UNIT_OFR_OPT_ALL
1479: WHERE unit_contact = x_person_id ;
1480:
1481: lv_rowid cur_rowid%RowType;
1482:

Line 1517: FROM IGS_PS_UNIT_OFR_OPT_ALL

1513: ***************************************************************/
1514:
1515: CURSOR cur_rowid IS
1516: SELECT rowid
1517: FROM IGS_PS_UNIT_OFR_OPT_ALL
1518: WHERE unit_cd = x_unit_cd
1519: AND version_number = x_version_number
1520: AND cal_type = x_cal_type
1521: AND ci_sequence_number = x_ci_sequence_number ;

Line 1620: CURSOR c_audit_credit (cp_c_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS

1616: WHERE teach_cal_type=cp_cal_type
1617: AND teach_ci_sequence_number=cp_sequence_number;
1618: l_cur_teach_to_load cur_teach_to_load%ROWTYPE;
1619:
1620: CURSOR c_audit_credit (cp_c_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
1621: SELECT ucp.rowid,ucp.*
1622: FROM igs_ps_usec_cps ucp
1623: WHERE ucp.uoo_id= cp_c_uoo_id
1624: AND ucp.billing_credit_points IS NOT NULL;

Line 1892: igs_ps_unit_ofr_opt_all uoo,

1888: ATTRIBUTE18 ,
1889: ATTRIBUTE19 ,
1890: ATTRIBUTE20
1891: FROM
1892: igs_ps_unit_ofr_opt_all uoo,
1893: igs_ps_unit_ver uv
1894: WHERE
1895: uv.unit_cd = uoo.unit_cd
1896: AND

Line 2074: cursor C is select ROWID from IGS_PS_UNIT_OFR_OPT_ALL

2070: as part of SWCR006 build.
2071: rgangara 07-May-2001 Ss_enrol_ind column added
2072: (reverse chronological order - newest change first)
2073: ***************************************************************/
2074: cursor C is select ROWID from IGS_PS_UNIT_OFR_OPT_ALL
2075: where UNIT_CD = X_UNIT_CD
2076: and VERSION_NUMBER = X_VERSION_NUMBER
2077: and LOCATION_CD = X_LOCATION_CD
2078: and UNIT_CLASS = X_UNIT_CLASS

Line 2186: insert into IGS_PS_UNIT_OFR_OPT_ALL (

2182: app_exception.raise_exception;
2183: END IF;
2184: END IF;
2185:
2186: insert into IGS_PS_UNIT_OFR_OPT_ALL (
2187: UNIT_CD
2188: ,VERSION_NUMBER
2189: ,CAL_TYPE
2190: ,CI_SEQUENCE_NUMBER

Line 2409: from IGS_PS_UNIT_OFR_OPT_ALL

2405: sup_uoo_id,
2406: relation_type,
2407: default_enroll_flag,
2408: abort_flag
2409: from IGS_PS_UNIT_OFR_OPT_ALL
2410: where ROWID = X_ROWID
2411: for update nowait;
2412:
2413: tlinfo c1%rowtype;

Line 2699: update IGS_PS_UNIT_OFR_OPT_ALL set

2695: X_PROGRAM_UPDATE_DATE := SYSDATE;
2696: end if;
2697: end if;
2698:
2699: update IGS_PS_UNIT_OFR_OPT_ALL set
2700: UOO_ID = NEW_REFERENCES.UOO_ID,
2701: IVRS_AVAILABLE_IND = NEW_REFERENCES.IVRS_AVAILABLE_IND,
2702: CALL_NUMBER = NEW_REFERENCES.CALL_NUMBER,
2703: UNIT_SECTION_STATUS = NEW_REFERENCES.UNIT_SECTION_STATUS,

Line 2873: cursor c1 is select ROWID from IGS_PS_UNIT_OFR_OPT_ALL

2869: rgangara 07-May-2001 Added ss_enrol_ind col
2870: (reverse chronological order - newest change first)
2871: ***************************************************************/
2872:
2873: cursor c1 is select ROWID from IGS_PS_UNIT_OFR_OPT_ALL
2874: where UNIT_CD= X_UNIT_CD
2875: and VERSION_NUMBER = X_VERSION_NUMBER
2876: and CAL_TYPE = X_CAL_TYPE
2877: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER

Line 3007: delete from IGS_PS_UNIT_OFR_OPT_ALL

3003: p_action => 'DELETE',
3004: x_rowid => X_ROWID
3005: );
3006:
3007: delete from IGS_PS_UNIT_OFR_OPT_ALL
3008: where ROWID = X_ROWID
3009: ;
3010: if (sql%notfound) then
3011: raise no_data_found;