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_AV_STND_UNIT_LVL_PKG dependencies on IGS_AV_STND_UNIT_LVL_ALL

Line 10: old_references IGS_AV_STND_UNIT_LVL_ALL%RowType;

6: admp_val_asu_inst reference is changed
7: admp_val_expiry_dt reference is changed
8: *****/
9: l_rowid VARCHAR2(25);
10: old_references IGS_AV_STND_UNIT_LVL_ALL%RowType;
11: new_references IGS_AV_STND_UNIT_LVL_ALL%RowType;
12: PROCEDURE Set_Column_Values (
13: p_action IN VARCHAR2,
14: x_rowid IN VARCHAR2,

Line 11: new_references IGS_AV_STND_UNIT_LVL_ALL%RowType;

7: admp_val_expiry_dt reference is changed
8: *****/
9: l_rowid VARCHAR2(25);
10: old_references IGS_AV_STND_UNIT_LVL_ALL%RowType;
11: new_references IGS_AV_STND_UNIT_LVL_ALL%RowType;
12: PROCEDURE Set_Column_Values (
13: p_action IN VARCHAR2,
14: x_rowid IN VARCHAR2,
15: x_person_id IN NUMBER,

Line 50: FROM IGS_AV_STND_UNIT_LVL_ALL

46: ) AS
47:
48: CURSOR cur_old_ref_values IS
49: SELECT *
50: FROM IGS_AV_STND_UNIT_LVL_ALL
51: WHERE rowid = x_rowid;
52: BEGIN
53: l_rowid := x_rowid;
54: -- Code for setting the Old and New Reference Values.

Line 115: v_person_id igs_av_stnd_unit_lvl_all.person_id%TYPE;

111: p_deleting IN BOOLEAN,
112: p_adv_stnd_trans IN VARCHAR2 -- This parameter has been added for Career Impact DLD.
113: ) AS
114: v_message_name VARCHAR2(30);
115: v_person_id igs_av_stnd_unit_lvl_all.person_id%TYPE;
116: v_course_cd igs_av_stnd_unit_lvl_all.as_course_cd%TYPE;
117: v_version_number igs_av_stnd_unit_lvl_all.as_version_number%TYPE;
118: v_exemption_institution_cd igs_av_stnd_unit_lvl_all.exemption_institution_cd%TYPE;
119: BEGIN

Line 116: v_course_cd igs_av_stnd_unit_lvl_all.as_course_cd%TYPE;

112: p_adv_stnd_trans IN VARCHAR2 -- This parameter has been added for Career Impact DLD.
113: ) AS
114: v_message_name VARCHAR2(30);
115: v_person_id igs_av_stnd_unit_lvl_all.person_id%TYPE;
116: v_course_cd igs_av_stnd_unit_lvl_all.as_course_cd%TYPE;
117: v_version_number igs_av_stnd_unit_lvl_all.as_version_number%TYPE;
118: v_exemption_institution_cd igs_av_stnd_unit_lvl_all.exemption_institution_cd%TYPE;
119: BEGIN
120: -- Validate conditions on insert (these apply to the trigger only).

Line 117: v_version_number igs_av_stnd_unit_lvl_all.as_version_number%TYPE;

113: ) AS
114: v_message_name VARCHAR2(30);
115: v_person_id igs_av_stnd_unit_lvl_all.person_id%TYPE;
116: v_course_cd igs_av_stnd_unit_lvl_all.as_course_cd%TYPE;
117: v_version_number igs_av_stnd_unit_lvl_all.as_version_number%TYPE;
118: v_exemption_institution_cd igs_av_stnd_unit_lvl_all.exemption_institution_cd%TYPE;
119: BEGIN
120: -- Validate conditions on insert (these apply to the trigger only).
121: IF p_inserting THEN

Line 118: v_exemption_institution_cd igs_av_stnd_unit_lvl_all.exemption_institution_cd%TYPE;

114: v_message_name VARCHAR2(30);
115: v_person_id igs_av_stnd_unit_lvl_all.person_id%TYPE;
116: v_course_cd igs_av_stnd_unit_lvl_all.as_course_cd%TYPE;
117: v_version_number igs_av_stnd_unit_lvl_all.as_version_number%TYPE;
118: v_exemption_institution_cd igs_av_stnd_unit_lvl_all.exemption_institution_cd%TYPE;
119: BEGIN
120: -- Validate conditions on insert (these apply to the trigger only).
121: IF p_inserting THEN
122: IF new_references.s_adv_stnd_type <> 'LEVEL' THEN

Line 428: -- ON IGS_AV_STND_UNIT_LVL_ALL

424:
425: -- Trigger description :-
426: -- "OSS_TST".trg_asule_ar_iud
427: -- AFTER INSERT OR DELETE OR UPDATE
428: -- ON IGS_AV_STND_UNIT_LVL_ALL
429: -- FOR EACH ROW
430:
431: PROCEDURE AfterRowInsertUpdateDelete2(
432: p_inserting IN BOOLEAN,

Line 438: v_person_id IGS_AV_STND_UNIT_LVL_ALL.person_id%TYPE;

434: p_deleting IN BOOLEAN
435: ) AS
436: v_rowid_saved BOOLEAN := FALSE;
437: v_message_name varchar2(30);
438: v_person_id IGS_AV_STND_UNIT_LVL_ALL.person_id%TYPE;
439: v_course_cd IGS_AV_STND_UNIT_LVL_ALL.as_course_cd%TYPE;
440: v_version_number IGS_AV_STND_UNIT_LVL_ALL.as_version_number%TYPE;
441: BEGIN
442: -- If trigger has not been disabled, perform required processing

Line 439: v_course_cd IGS_AV_STND_UNIT_LVL_ALL.as_course_cd%TYPE;

435: ) AS
436: v_rowid_saved BOOLEAN := FALSE;
437: v_message_name varchar2(30);
438: v_person_id IGS_AV_STND_UNIT_LVL_ALL.person_id%TYPE;
439: v_course_cd IGS_AV_STND_UNIT_LVL_ALL.as_course_cd%TYPE;
440: v_version_number IGS_AV_STND_UNIT_LVL_ALL.as_version_number%TYPE;
441: BEGIN
442: -- If trigger has not been disabled, perform required processing
443: IF (p_inserting) THEN

Line 440: v_version_number IGS_AV_STND_UNIT_LVL_ALL.as_version_number%TYPE;

436: v_rowid_saved BOOLEAN := FALSE;
437: v_message_name varchar2(30);
438: v_person_id IGS_AV_STND_UNIT_LVL_ALL.person_id%TYPE;
439: v_course_cd IGS_AV_STND_UNIT_LVL_ALL.as_course_cd%TYPE;
440: v_version_number IGS_AV_STND_UNIT_LVL_ALL.as_version_number%TYPE;
441: BEGIN
442: -- If trigger has not been disabled, perform required processing
443: IF (p_inserting) THEN
444: IF IGS_AV_GEN_001.ADVP_UPD_AS_TOTALS (

Line 783: FROM IGS_AV_STND_UNIT_LVL_ALL

779: ) Return Boolean
780: AS
781: CURSOR cur_rowid IS
782: SELECT rowid
783: FROM IGS_AV_STND_UNIT_LVL_ALL
784: WHERE av_stnd_unit_lvl_id = x_av_stnd_unit_lvl_id
785: FOR UPDATE NOWAIT;
786: lv_rowid cur_rowid%RowType;
787: BEGIN

Line 825: FROM igs_av_stnd_unit_lvl_all

821: ***************************************************************/
822:
823: CURSOR cur_rowid IS
824: SELECT rowid
825: FROM igs_av_stnd_unit_lvl_all
826: WHERE person_id = x_person_id AND
827: exemption_institution_cd = x_exemption_institution_cd AND
828: ((unit_details_id = x_unit_details_id ) OR (unit_details_id IS NULL AND x_unit_details_id IS NULL)) AND
829: ((tst_rslt_dtls_id = x_tst_rslt_dtls_id) OR ( tst_rslt_dtls_id IS NULL AND x_tst_rslt_dtls_id IS NULL)) AND

Line 865: FROM IGS_AV_STND_UNIT_LVL_ALL

861: x_exemption_institution_cd IN VARCHAR2
862: ) AS
863: CURSOR cur_rowid IS
864: SELECT rowid
865: FROM IGS_AV_STND_UNIT_LVL_ALL
866: WHERE person_id = x_person_id
867: AND as_course_cd = x_course_cd
868: AND as_version_number = x_version_number
869: AND exemption_institution_cd=x_exemption_institution_cd ;

Line 892: FROM IGS_AV_STND_UNIT_LVL_ALL

888: x_person_id IN NUMBER
889: ) AS
890: CURSOR cur_rowid IS
891: SELECT rowid
892: FROM IGS_AV_STND_UNIT_LVL_ALL
893: WHERE authorising_person_id = x_person_id ;
894: lv_rowid cur_rowid%RowType;
895: BEGIN
896: Open cur_rowid;

Line 913: FROM IGS_AV_STND_UNIT_LVL_ALL

909: x_s_adv_stnd_granting_status IN VARCHAR2
910: ) AS
911: CURSOR cur_rowid IS
912: SELECT rowid
913: FROM IGS_AV_STND_UNIT_LVL_ALL
914: WHERE s_adv_stnd_granting_status = x_s_adv_stnd_granting_status ;
915: lv_rowid cur_rowid%RowType;
916: BEGIN
917: Open cur_rowid;

Line 937: FROM IGS_AV_STND_UNIT_LVL_ALL

933: x_ci_sequence_number IN NUMBER
934: ) AS
935: CURSOR cur_rowid IS
936: SELECT rowid
937: FROM IGS_AV_STND_UNIT_LVL_ALL
938: WHERE cal_type = x_cal_type
939: AND ci_sequence_number = x_ci_sequence_number ;
940: lv_rowid cur_rowid%RowType;
941: BEGIN

Line 960: FROM IGS_AV_STND_UNIT_LVL_ALL

956: x_qual_dets_id IN NUMBER
957: ) AS
958: CURSOR cur_rowid IS
959: SELECT rowid
960: FROM IGS_AV_STND_UNIT_LVL_ALL
961: WHERE qual_dets_id = x_qual_dets_id;
962: lv_rowid cur_rowid%RowType;
963: BEGIN
964: Open cur_rowid;

Line 982: FROM IGS_AV_STND_UNIT_LVL_ALL

978: x_unit_details_id IN NUMBER
979: ) AS
980: CURSOR cur_rowid IS
981: SELECT rowid
982: FROM IGS_AV_STND_UNIT_LVL_ALL
983: WHERE unit_details_id = x_unit_details_id;
984: l_rowid cur_rowid%RowType;
985: BEGIN
986: Open cur_rowid;

Line 1003: FROM IGS_AV_STND_UNIT_LVL_ALL

999: x_tst_rslt_dtls_id IN NUMBER
1000: ) AS
1001: CURSOR cur_rowid IS
1002: SELECT rowid
1003: FROM IGS_AV_STND_UNIT_LVL_ALL
1004: WHERE tst_rslt_dtls_id = x_tst_rslt_dtls_id;
1005: l_rowid cur_rowid%RowType;
1006: BEGIN
1007: Open cur_rowid;

Line 1201: cursor C is select ROWID from IGS_AV_STND_UNIT_LVL_ALL

1197: X_DEG_AUD_DETAIL_ID IN NUMBER,
1198: X_QUAL_DETS_ID IN NUMBER,
1199: X_UNIT_LEVEL_MARK IN NUMBER
1200: ) AS
1201: cursor C is select ROWID from IGS_AV_STND_UNIT_LVL_ALL
1202: where av_stnd_unit_lvl_id = x_av_stnd_unit_lvl_id;
1203:
1204: X_LAST_UPDATE_DATE DATE;
1205: X_LAST_UPDATED_BY NUMBER;

Line 1282: insert into IGS_AV_STND_UNIT_LVL_ALL (

1278:
1279: IF (x_mode = 'S') THEN
1280: igs_sc_gen_001.set_ctx('R');
1281: END IF;
1282: insert into IGS_AV_STND_UNIT_LVL_ALL (
1283: PERSON_ID,
1284: AS_COURSE_CD,
1285: AS_VERSION_NUMBER,
1286: S_ADV_STND_TYPE,

Line 1433: from IGS_AV_STND_UNIT_LVL_ALL

1429: TST_RSLT_DTLS_ID,
1430: DEG_AUD_DETAIL_ID,
1431: QUAL_DETS_ID,
1432: UNIT_LEVEL_MARK
1433: from IGS_AV_STND_UNIT_LVL_ALL
1434: where ROWID = X_ROWID
1435: for update nowait;
1436: tlinfo c1%rowtype;
1437: begin

Line 1609: UPDATE IGS_AV_STND_UNIT_LVL_ALL SET

1605:
1606: IF (x_mode = 'S') THEN
1607: igs_sc_gen_001.set_ctx('R');
1608: END IF;
1609: UPDATE IGS_AV_STND_UNIT_LVL_ALL SET
1610: S_ADV_STND_GRANTING_STATUS = NEW_REFERENCES.S_ADV_STND_GRANTING_STATUS,
1611: CREDIT_POINTS = NEW_REFERENCES.CREDIT_POINTS,
1612: APPROVED_DT = NEW_REFERENCES.APPROVED_DT,
1613: AUTHORISING_PERSON_ID = NEW_REFERENCES.AUTHORISING_PERSON_ID,

Line 1694: cursor c1 is select rowid from IGS_AV_STND_UNIT_LVL_ALL

1690: X_DEG_AUD_DETAIL_ID IN NUMBER,
1691: X_QUAL_DETS_ID IN NUMBER,
1692: X_UNIT_LEVEL_MARK IN NUMBER
1693: ) AS
1694: cursor c1 is select rowid from IGS_AV_STND_UNIT_LVL_ALL
1695: where AV_STND_UNIT_LVL_ID =X_AV_STND_UNIT_LVL_ID;
1696: begin
1697: open c1;
1698: fetch c1 into X_ROWID ;

Line 1780: delete from IGS_AV_STND_UNIT_LVL_ALL

1776: );
1777: IF (x_mode = 'S') THEN
1778: igs_sc_gen_001.set_ctx('R');
1779: END IF;
1780: delete from IGS_AV_STND_UNIT_LVL_ALL
1781: where ROWID = X_ROWID ;
1782: if (sql%notfound) then
1783: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1784: igs_ge_msg_stack.add;