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_AD_APP_INTENT_PKG dependencies on IGS_AD_APP_INTENT

Line 1: PACKAGE BODY igs_ad_app_intent_pkg AS

1: PACKAGE BODY igs_ad_app_intent_pkg AS
2: /* $Header: IGSAI94B.pls 120.3 2005/10/03 08:20:10 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_app_intent%RowType;
5: new_references igs_ad_app_intent%RowType;

Line 4: old_references igs_ad_app_intent%RowType;

1: PACKAGE BODY igs_ad_app_intent_pkg AS
2: /* $Header: IGSAI94B.pls 120.3 2005/10/03 08:20:10 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_app_intent%RowType;
5: new_references igs_ad_app_intent%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ad_app_intent%RowType;

1: PACKAGE BODY igs_ad_app_intent_pkg AS
2: /* $Header: IGSAI94B.pls 120.3 2005/10/03 08:20:10 appldev ship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ad_app_intent%RowType;
5: new_references igs_ad_app_intent%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 56: FROM IGS_AD_APP_INTENT

52: ***************************************************************/
53:
54: CURSOR cur_old_ref_values IS
55: SELECT *
56: FROM IGS_AD_APP_INTENT
57: WHERE rowid = x_rowid;
58:
59: BEGIN
60:

Line 223: FROM igs_ad_app_intent

219: ***************************************************************/
220:
221: CURSOR cur_rowid IS
222: SELECT rowid
223: FROM igs_ad_app_intent
224: WHERE app_intent_id = x_app_intent_id
225: FOR UPDATE NOWAIT;
226:
227: lv_rowid cur_rowid%RowType;

Line 261: FROM igs_ad_app_intent

257: ***************************************************************/
258:
259: CURSOR cur_rowid IS
260: SELECT rowid
261: FROM igs_ad_app_intent
262: WHERE admission_appl_number = x_admission_appl_number
263: AND intent_type_id = x_intent_type_id
264: AND person_id = x_person_id
265: AND ((l_rowid is null) or (rowid <> l_rowid));

Line 297: FROM igs_ad_app_intent

293: ***************************************************************/
294:
295: CURSOR cur_rowid IS
296: SELECT rowid
297: FROM igs_ad_app_intent
298: WHERE intent_type_id = x_code_id ;
299:
300: lv_rowid cur_rowid%RowType;
301:

Line 335: FROM igs_ad_app_intent

331: ***************************************************************/
332:
333: CURSOR cur_rowid IS
334: SELECT rowid
335: FROM igs_ad_app_intent
336: WHERE person_id = x_person_id
337: AND admission_appl_number = x_admission_appl_number;
338:
339: lv_rowid cur_rowid%RowType;

Line 559: cursor C is select ROWID from IGS_AD_APP_INTENT

555:
556: (reverse chronological order - newest change first)
557: ***************************************************************/
558:
559: cursor C is select ROWID from IGS_AD_APP_INTENT
560: where APP_INTENT_ID= X_APP_INTENT_ID
561: ;
562: X_LAST_UPDATE_DATE DATE ;
563: X_LAST_UPDATED_BY NUMBER ;

Line 638: insert into IGS_AD_APP_INTENT (

634: x_last_update_login=>X_LAST_UPDATE_LOGIN);
635: IF (x_mode = 'S') THEN
636: igs_sc_gen_001.set_ctx('R');
637: END IF;
638: insert into IGS_AD_APP_INTENT (
639: APP_INTENT_ID
640: ,PERSON_ID
641: ,ADMISSION_APPL_NUMBER
642: ,INTENT_TYPE_ID

Line 674: IGS_AD_APP_INTENT_S.NEXTVAL

670: ,PROGRAM_ID
671: ,PROGRAM_APPLICATION_ID
672: ,PROGRAM_UPDATE_DATE
673: ) values (
674: IGS_AD_APP_INTENT_S.NEXTVAL
675: ,NEW_REFERENCES.PERSON_ID
676: ,NEW_REFERENCES.ADMISSION_APPL_NUMBER
677: ,NEW_REFERENCES.INTENT_TYPE_ID
678: ,NEW_REFERENCES.ATTRIBUTE_CATEGORY

Line 805: from IGS_AD_APP_INTENT

801: , ATTRIBUTE17
802: , ATTRIBUTE18
803: , ATTRIBUTE19
804: , ATTRIBUTE20
805: from IGS_AD_APP_INTENT
806: where ROWID = X_ROWID
807: for update nowait;
808: tlinfo c1%rowtype;
809: begin

Line 1012: UPDATE IGS_AD_APP_INTENT set

1008:
1009: IF (x_mode = 'S') THEN
1010: igs_sc_gen_001.set_ctx('R');
1011: END IF;
1012: UPDATE IGS_AD_APP_INTENT set
1013: PERSON_ID = NEW_REFERENCES.PERSON_ID,
1014: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,
1015: INTENT_TYPE_ID = NEW_REFERENCES.INTENT_TYPE_ID,
1016: ATTRIBUTE_CATEGORY = NEW_REFERENCES.ATTRIBUTE_CATEGORY,

Line 1121: cursor c1 is select ROWID from IGS_AD_APP_INTENT

1117:
1118: (reverse chronological order - newest change first)
1119: ***************************************************************/
1120:
1121: cursor c1 is select ROWID from IGS_AD_APP_INTENT
1122: where APP_INTENT_ID= X_APP_INTENT_ID
1123: ;
1124: begin
1125: open c1;

Line 1212: delete from IGS_AD_APP_INTENT

1208: );
1209: IF (x_mode = 'S') THEN
1210: igs_sc_gen_001.set_ctx('R');
1211: END IF;
1212: delete from IGS_AD_APP_INTENT
1213: where ROWID = X_ROWID;
1214: if (sql%notfound) then
1215: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1216: igs_ge_msg_stack.add;

Line 1249: END igs_ad_app_intent_pkg;

1245: ELSE
1246: RAISE;
1247: END IF;
1248: end DELETE_ROW;
1249: END igs_ad_app_intent_pkg;