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_AV_STND_UNIT_PKG dependencies on IGS_AV_STND_UNIT_ALL

Line 5: old_references IGS_AV_STND_UNIT_ALL%RowType;

1: package body IGS_AV_STND_UNIT_PKG AS
2: /* $Header: IGSBI04B.pls 120.0 2005/07/05 12:12:01 appldev noship $ */
3: --msrinivi 24-AUG-2001 Bug No. 1956374 .Repointed genp_val_prsn_id
4: l_rowid VARCHAR2(25);
5: old_references IGS_AV_STND_UNIT_ALL%RowType;
6: new_references IGS_AV_STND_UNIT_ALL%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 6: new_references IGS_AV_STND_UNIT_ALL%RowType;

2: /* $Header: IGSBI04B.pls 120.0 2005/07/05 12:12:01 appldev noship $ */
3: --msrinivi 24-AUG-2001 Bug No. 1956374 .Repointed genp_val_prsn_id
4: l_rowid VARCHAR2(25);
5: old_references IGS_AV_STND_UNIT_ALL%RowType;
6: new_references IGS_AV_STND_UNIT_ALL%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,
10: x_person_id IN NUMBER DEFAULT NULL,

Line 48: FROM IGS_AV_STND_UNIT_ALL

44: X_DEG_AUD_DETAIL_ID IN NUMBER DEFAULT NULL
45: ) AS
46: CURSOR cur_old_ref_values IS
47: SELECT *
48: FROM IGS_AV_STND_UNIT_ALL
49: WHERE rowid = x_rowid;
50: BEGIN
51: l_rowid := x_rowid;
52: -- Code for setting the Old and New Reference Values.

Line 112: -- ON IGS_AV_STND_UNIT_ALL

108:
109: -- Trigger description :-
110: -- "OSS_TST".trg_asu_br_iud
111: -- BEFORE INSERT OR DELETE OR UPDATE
112: -- ON IGS_AV_STND_UNIT_ALL
113: -- FOR EACH ROW
114: PROCEDURE BeforeRowInsertUpdateDelete1(
115: p_inserting IN BOOLEAN DEFAULT FALSE,
116: p_updating IN BOOLEAN DEFAULT FALSE,

Line 122: v_Person_id igs_av_stnd_unit_all.person_id%TYPE;

118: p_adv_stnd_trans IN VARCHAR2 DEFAULT 'N' -- This parameter has been added for Career Impact DLD.
119: ) AS
120: v_message_name VARCHAR2(30);
121: v_return_val igs_pe_std_todo.sequence_number%TYPE;
122: v_Person_id igs_av_stnd_unit_all.person_id%TYPE;
123: v_course_cd igs_av_stnd_unit_all.as_course_cd%TYPE;
124: v_version_number igs_av_stnd_unit_all.as_version_number%TYPE;
125: v_exemption_institution_cd igs_av_stnd_unit_all.exemption_institution_cd%TYPE;
126: BEGIN

Line 123: v_course_cd igs_av_stnd_unit_all.as_course_cd%TYPE;

119: ) AS
120: v_message_name VARCHAR2(30);
121: v_return_val igs_pe_std_todo.sequence_number%TYPE;
122: v_Person_id igs_av_stnd_unit_all.person_id%TYPE;
123: v_course_cd igs_av_stnd_unit_all.as_course_cd%TYPE;
124: v_version_number igs_av_stnd_unit_all.as_version_number%TYPE;
125: v_exemption_institution_cd igs_av_stnd_unit_all.exemption_institution_cd%TYPE;
126: BEGIN
127: -- Validate conditions on insert (these apply to the trigger only).

Line 124: v_version_number igs_av_stnd_unit_all.as_version_number%TYPE;

120: v_message_name VARCHAR2(30);
121: v_return_val igs_pe_std_todo.sequence_number%TYPE;
122: v_Person_id igs_av_stnd_unit_all.person_id%TYPE;
123: v_course_cd igs_av_stnd_unit_all.as_course_cd%TYPE;
124: v_version_number igs_av_stnd_unit_all.as_version_number%TYPE;
125: v_exemption_institution_cd igs_av_stnd_unit_all.exemption_institution_cd%TYPE;
126: BEGIN
127: -- Validate conditions on insert (these apply to the trigger only).
128: IF p_inserting THEN

Line 125: v_exemption_institution_cd igs_av_stnd_unit_all.exemption_institution_cd%TYPE;

121: v_return_val igs_pe_std_todo.sequence_number%TYPE;
122: v_Person_id igs_av_stnd_unit_all.person_id%TYPE;
123: v_course_cd igs_av_stnd_unit_all.as_course_cd%TYPE;
124: v_version_number igs_av_stnd_unit_all.as_version_number%TYPE;
125: v_exemption_institution_cd igs_av_stnd_unit_all.exemption_institution_cd%TYPE;
126: BEGIN
127: -- Validate conditions on insert (these apply to the trigger only).
128: IF p_inserting THEN
129: IF new_references.s_adv_stnd_type <> 'UNIT' THEN

Line 483: -- ON IGS_AV_STND_UNIT_ALL

479:
480: -- Trigger description :-
481: -- "OSS_TST".trg_asu_ar_iud
482: -- AFTER INSERT OR DELETE OR UPDATE
483: -- ON IGS_AV_STND_UNIT_ALL
484: -- FOR EACH ROW
485: -- Trigger description :-
486: -- "OSS_TST".trg_asu_as_iud
487: -- AFTER INSERT OR DELETE OR UPDATE

Line 488: -- ON IGS_AV_STND_UNIT_ALL

484: -- FOR EACH ROW
485: -- Trigger description :-
486: -- "OSS_TST".trg_asu_as_iud
487: -- AFTER INSERT OR DELETE OR UPDATE
488: -- ON IGS_AV_STND_UNIT_ALL
489: PROCEDURE AfterRowInsertUpdateDelete2(
490: p_inserting IN BOOLEAN DEFAULT FALSE,
491: p_updating IN BOOLEAN DEFAULT FALSE,
492: p_deleting IN BOOLEAN DEFAULT FALSE

Line 821: FROM IGS_AV_STND_UNIT_ALL

817: x_av_stnd_unit_id IN NUMBER
818: ) RETURN BOOLEAN AS
819: CURSOR cur_rowid IS
820: SELECT rowid
821: FROM IGS_AV_STND_UNIT_ALL
822: WHERE av_stnd_unit_id = x_av_stnd_unit_id
823: FOR UPDATE NOWAIT;
824: lv_rowid cur_rowid%RowType;
825: BEGIN

Line 864: FROM igs_av_stnd_unit_all

860: ***************************************************************/
861:
862: CURSOR cur_rowid IS
863: SELECT rowid
864: FROM igs_av_stnd_unit_all
865: WHERE person_id = x_person_id AND
866: exemption_institution_cd = x_exemption_institution_cd AND
867: ((unit_details_id = x_unit_details_id) OR (unit_details_id IS NULL AND x_unit_details_id IS NULL)) AND
868: ((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 896: FROM IGS_AV_STND_UNIT_ALL

892: x_s_adv_stnd_recognition_type IN VARCHAR2
893: ) AS
894: CURSOR cur_rowid IS
895: SELECT rowid
896: FROM IGS_AV_STND_UNIT_ALL
897: WHERE s_adv_stnd_recognition_type = x_s_adv_stnd_recognition_type ;
898: lv_rowid cur_rowid%RowType;
899: BEGIN
900: Open cur_rowid;

Line 920: FROM IGS_AV_STND_UNIT_ALL

916: x_exemption_institution_cd IN VARCHAR2
917: ) AS
918: CURSOR cur_rowid IS
919: SELECT rowid
920: FROM IGS_AV_STND_UNIT_ALL
921: WHERE person_id = x_person_id
922: AND as_course_cd = x_course_cd
923: AND as_version_number = x_version_number
924: AND exemption_institution_cd=x_exemption_institution_cd;

Line 945: FROM IGS_AV_STND_UNIT_ALL

941: x_unit_details_id IN NUMBER
942: ) AS
943: CURSOR cur_rowid IS
944: SELECT rowid
945: FROM IGS_AV_STND_UNIT_ALL
946: WHERE unit_details_id = x_unit_details_id;
947: l_rowid cur_rowid%RowType;
948: BEGIN
949: Open cur_rowid;

Line 966: FROM IGS_AV_STND_UNIT_ALL

962: x_tst_rslt_dtls_id IN NUMBER
963: ) AS
964: CURSOR cur_rowid IS
965: SELECT rowid
966: FROM IGS_AV_STND_UNIT_ALL
967: WHERE tst_rslt_dtls_id = x_tst_rslt_dtls_id;
968: l_rowid cur_rowid%RowType;
969: BEGIN
970: Open cur_rowid;

Line 988: FROM IGS_AV_STND_UNIT_ALL

984: x_person_id IN NUMBER
985: ) AS
986: CURSOR cur_rowid IS
987: SELECT rowid
988: FROM IGS_AV_STND_UNIT_ALL
989: WHERE authorising_person_id = x_person_id ;
990: lv_rowid cur_rowid%RowType;
991: BEGIN
992: Open cur_rowid;

Line 1009: FROM IGS_AV_STND_UNIT_ALL

1005: x_s_adv_stnd_granting_status IN VARCHAR2
1006: ) AS
1007: CURSOR cur_rowid IS
1008: SELECT rowid
1009: FROM IGS_AV_STND_UNIT_ALL
1010: WHERE s_adv_stnd_granting_status = x_s_adv_stnd_granting_status ;
1011: lv_rowid cur_rowid%RowType;
1012: BEGIN
1013: Open cur_rowid;

Line 1031: FROM IGS_AV_STND_UNIT_ALL

1027: x_version_number IN NUMBER
1028: ) AS
1029: CURSOR cur_rowid IS
1030: SELECT rowid
1031: FROM IGS_AV_STND_UNIT_ALL
1032: WHERE unit_cd = x_unit_cd
1033: AND version_number = x_version_number ;
1034: lv_rowid cur_rowid%RowType;
1035: BEGIN

Line 1055: FROM IGS_AV_STND_UNIT_ALL

1051: x_ci_sequence_number IN NUMBER
1052: ) AS
1053: CURSOR cur_rowid IS
1054: SELECT rowid
1055: FROM IGS_AV_STND_UNIT_ALL
1056: WHERE cal_type = x_cal_type
1057: AND ci_sequence_number = x_ci_sequence_number ;
1058: lv_rowid cur_rowid%RowType;
1059: BEGIN

Line 1079: FROM IGS_AV_STND_UNIT_ALL

1075: x_grade IN VARCHAR2
1076: ) AS
1077: CURSOR cur_rowid IS
1078: SELECT rowid
1079: FROM IGS_AV_STND_UNIT_ALL
1080: WHERE grading_schema_cd = x_grading_schema_cd
1081: AND grd_sch_version_number = x_grd_sch_version_number
1082: AND grade = x_grade;
1083: lv_rowid cur_rowid%RowType;

Line 1277: cursor C is select ROWID from IGS_AV_STND_UNIT_ALL

1273: X_ORG_ID in NUMBER,
1274: X_ADV_STND_TRANS IN VARCHAR2 DEFAULT 'N', -- This parameter has been added for Career Impact DLD.
1275: X_DEG_AUD_DETAIL_ID IN NUMBER DEFAULT NULL
1276: ) AS
1277: cursor C is select ROWID from IGS_AV_STND_UNIT_ALL
1278: where PERSON_ID = new_references.PERSON_ID
1279: and AS_COURSE_CD = new_references.AS_COURSE_CD
1280: and AS_VERSION_NUMBER =new_references.AS_VERSION_NUMBER
1281: and S_ADV_STND_TYPE = new_references.S_ADV_STND_TYPE

Line 1292: cursor c1 is select ROWID from IGS_AV_STND_UNIT_ALL

1288: X_PROGRAM_ID NUMBER ;
1289: X_PROGRAM_APPLICATION_ID NUMBER;
1290: X_PROGRAM_UPDATE_DATE DATE ;
1291:
1292: cursor c1 is select ROWID from IGS_AV_STND_UNIT_ALL
1293: WHERE AV_STND_UNIT_ID = X_AV_STND_UNIT_ID;
1294: begin
1295: X_LAST_UPDATE_DATE := SYSDATE;
1296: if(X_MODE = 'I') then

Line 1371: INSERT INTO IGS_AV_STND_UNIT_ALL (

1367:
1368: IF (x_mode = 'S') THEN
1369: igs_sc_gen_001.set_ctx('R');
1370: END IF;
1371: INSERT INTO IGS_AV_STND_UNIT_ALL (
1372: PERSON_ID,
1373: AS_COURSE_CD,
1374: AS_VERSION_NUMBER,
1375: S_ADV_STND_TYPE,

Line 1539: from IGS_AV_STND_UNIT_ALL

1535: GRD_SCH_VERSION_NUMBER,
1536: GRADE,
1537: ACHIEVABLE_CREDIT_POINTS,
1538: DEG_AUD_DETAIL_ID
1539: from IGS_AV_STND_UNIT_ALL
1540: where ROWID = X_ROWID
1541: for update nowait;
1542: tlinfo c1%rowtype;
1543: begin

Line 1701: UPDATE IGS_AV_STND_UNIT_ALL SET

1697:
1698: IF (x_mode = 'S') THEN
1699: igs_sc_gen_001.set_ctx('R');
1700: END IF;
1701: UPDATE IGS_AV_STND_UNIT_ALL SET
1702: S_ADV_STND_GRANTING_STATUS = X_S_ADV_STND_GRANTING_STATUS,
1703: CREDIT_PERCENTAGE = NULL,
1704: S_ADV_STND_RECOGNITION_TYPE = X_S_ADV_STND_RECOGNITION_TYPE,
1705: APPROVED_DT = X_APPROVED_DT,

Line 1795: cursor c1 is select rowid from IGS_AV_STND_UNIT_ALL

1791: X_MODE in VARCHAR2 default 'R',
1792: X_ORG_ID in NUMBER,
1793: X_DEG_AUD_DETAIL_ID IN NUMBER DEFAULT NULL
1794: ) AS
1795: cursor c1 is select rowid from IGS_AV_STND_UNIT_ALL
1796: where AV_STND_UNIT_ID =X_AV_STND_UNIT_ID
1797: ;
1798: begin
1799: open c1;

Line 1885: delete from IGS_AV_STND_UNIT_ALL

1881: );
1882: IF (x_mode = 'S') THEN
1883: igs_sc_gen_001.set_ctx('R');
1884: END IF;
1885: delete from IGS_AV_STND_UNIT_ALL
1886: where ROWID = X_ROWID ;
1887: if (sql%notfound) then
1888: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1889: igs_ge_msg_stack.add;