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_PE_ACAD_INTENTS_PKG dependencies on IGS_PE_ACAD_INTENTS

Line 1: PACKAGE BODY igs_pe_acad_intents_pkg AS

1: PACKAGE BODY igs_pe_acad_intents_pkg AS
2: /* $Header: IGSNIB6B.pls 120.0 2006/05/23 12:32:39 vskumar noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_acad_intents%ROWTYPE;

Line 5: old_references igs_pe_acad_intents%ROWTYPE;

1: PACKAGE BODY igs_pe_acad_intents_pkg AS
2: /* $Header: IGSNIB6B.pls 120.0 2006/05/23 12:32:39 vskumar noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_acad_intents%ROWTYPE;
6: new_references igs_pe_acad_intents%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_pe_acad_intents%ROWTYPE;

2: /* $Header: IGSNIB6B.pls 120.0 2006/05/23 12:32:39 vskumar noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_pe_acad_intents%ROWTYPE;
6: new_references igs_pe_acad_intents%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 35: FROM igs_pe_acad_intents

31: */
32:
33: CURSOR cur_old_ref_values IS
34: SELECT *
35: FROM igs_pe_acad_intents
36: WHERE rowid = x_rowid;
37:
38: BEGIN
39:

Line 95: lv_acad_intent_code IGS_PE_ACAD_INTENTS.acad_intent_code%TYPE;

91: --Change History:
92: --Who When What
93: ----------------------------------------------------------------------------------------------
94: lv_rowid varchar2(25);
95: lv_acad_intent_code IGS_PE_ACAD_INTENTS.acad_intent_code%TYPE;
96: ln_acad_intent_id NUMBER;
97:
98: CURSOR c_act (cp_person_id IGS_PE_ACAD_INTENTS.person_id%TYPE,
99: cp_cal_type IGS_PE_ACAD_INTENTS.cal_type%TYPE,

Line 98: CURSOR c_act (cp_person_id IGS_PE_ACAD_INTENTS.person_id%TYPE,

94: lv_rowid varchar2(25);
95: lv_acad_intent_code IGS_PE_ACAD_INTENTS.acad_intent_code%TYPE;
96: ln_acad_intent_id NUMBER;
97:
98: CURSOR c_act (cp_person_id IGS_PE_ACAD_INTENTS.person_id%TYPE,
99: cp_cal_type IGS_PE_ACAD_INTENTS.cal_type%TYPE,
100: cp_sequence_number IGS_PE_ACAD_INTENTS.sequence_number%TYPE,
101: cp_active_flag IGS_PE_ACAD_INTENTS.active_flag%TYPE,
102: cp_l_rowid varchar2) IS

Line 99: cp_cal_type IGS_PE_ACAD_INTENTS.cal_type%TYPE,

95: lv_acad_intent_code IGS_PE_ACAD_INTENTS.acad_intent_code%TYPE;
96: ln_acad_intent_id NUMBER;
97:
98: CURSOR c_act (cp_person_id IGS_PE_ACAD_INTENTS.person_id%TYPE,
99: cp_cal_type IGS_PE_ACAD_INTENTS.cal_type%TYPE,
100: cp_sequence_number IGS_PE_ACAD_INTENTS.sequence_number%TYPE,
101: cp_active_flag IGS_PE_ACAD_INTENTS.active_flag%TYPE,
102: cp_l_rowid varchar2) IS
103: SELECT rowid, acad_intent_code

Line 100: cp_sequence_number IGS_PE_ACAD_INTENTS.sequence_number%TYPE,

96: ln_acad_intent_id NUMBER;
97:
98: CURSOR c_act (cp_person_id IGS_PE_ACAD_INTENTS.person_id%TYPE,
99: cp_cal_type IGS_PE_ACAD_INTENTS.cal_type%TYPE,
100: cp_sequence_number IGS_PE_ACAD_INTENTS.sequence_number%TYPE,
101: cp_active_flag IGS_PE_ACAD_INTENTS.active_flag%TYPE,
102: cp_l_rowid varchar2) IS
103: SELECT rowid, acad_intent_code
104: FROM IGS_PE_ACAD_INTENTS

Line 101: cp_active_flag IGS_PE_ACAD_INTENTS.active_flag%TYPE,

97:
98: CURSOR c_act (cp_person_id IGS_PE_ACAD_INTENTS.person_id%TYPE,
99: cp_cal_type IGS_PE_ACAD_INTENTS.cal_type%TYPE,
100: cp_sequence_number IGS_PE_ACAD_INTENTS.sequence_number%TYPE,
101: cp_active_flag IGS_PE_ACAD_INTENTS.active_flag%TYPE,
102: cp_l_rowid varchar2) IS
103: SELECT rowid, acad_intent_code
104: FROM IGS_PE_ACAD_INTENTS
105: WHERE person_id = cp_person_id

Line 104: FROM IGS_PE_ACAD_INTENTS

100: cp_sequence_number IGS_PE_ACAD_INTENTS.sequence_number%TYPE,
101: cp_active_flag IGS_PE_ACAD_INTENTS.active_flag%TYPE,
102: cp_l_rowid varchar2) IS
103: SELECT rowid, acad_intent_code
104: FROM IGS_PE_ACAD_INTENTS
105: WHERE person_id = cp_person_id
106: AND cal_type = cp_cal_type
107: AND sequence_number = cp_sequence_number
108: AND active_flag = cp_active_flag

Line 122: UPDATE igs_pe_acad_intents

118: l_rowid);
119:
120: FETCH c_act INTO lv_rowid, lv_acad_intent_code;
121: IF (c_act%FOUND) THEN
122: UPDATE igs_pe_acad_intents
123: SET active_flag = 'N'
124: WHERE rowid= lv_rowid;
125: END IF;
126:

Line 137: INSERT INTO igs_pe_acad_intents (

133: P_ACAD_INTENT_CODE=>new_references.acad_intent_code,
134: P_OLD_ACAD_INTENT_CODE=>lv_acad_intent_code);
135:
136: ELSIF p_updating THEN
137: INSERT INTO igs_pe_acad_intents (
138: acad_intent_id,
139: person_id,
140: cal_type,
141: sequence_number,

Line 150: igs_pe_acad_intents_s.NEXTVAL,

146: last_update_date,
147: last_updated_by,
148: last_update_login
149: ) VALUES (
150: igs_pe_acad_intents_s.NEXTVAL,
151: new_references.person_id,
152: new_references.cal_type,
153: new_references.sequence_number,
154: new_references.acad_intent_code,

Line 202: FROM igs_pe_acad_intents

198: || (reverse chronological order - newest change first)
199: */
200: CURSOR cur_rowid IS
201: SELECT rowid
202: FROM igs_pe_acad_intents
203: WHERE acad_intent_id = x_acad_intent_id
204: FOR UPDATE NOWAIT;
205:
206: lv_rowid cur_rowid%RowType;

Line 354: fnd_message.set_token ('ROUTINE', 'igs_pe_acad_intents_PKG.INSERT_ROW');

350: x_last_update_login := -1;
351: END IF;
352: ELSE
353: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
354: fnd_message.set_token ('ROUTINE', 'igs_pe_acad_intents_PKG.INSERT_ROW');
355: igs_ge_msg_stack.add;
356: app_exception.raise_exception;
357: END IF;
358:

Line 381: INSERT INTO igs_pe_acad_intents (

377: IF (x_mode = 'S') THEN
378: igs_sc_gen_001.set_ctx('R');
379: END IF;
380:
381: INSERT INTO igs_pe_acad_intents (
382: acad_intent_id,
383: person_id,
384: cal_type,
385: sequence_number,

Line 394: igs_pe_acad_intents_s.NEXTVAL,

390: last_update_date,
391: last_updated_by,
392: last_update_login
393: ) VALUES (
394: igs_pe_acad_intents_s.NEXTVAL,
395: new_references.person_id,
396: new_references.cal_type,
397: new_references.sequence_number,
398: new_references.acad_intent_code,

Line 458: FROM igs_pe_acad_intents

454: cal_type,
455: sequence_number,
456: acad_intent_code,
457: active_flag
458: FROM igs_pe_acad_intents
459: WHERE rowid = x_rowid
460: FOR UPDATE NOWAIT;
461:
462: tlinfo c1%ROWTYPE;

Line 536: fnd_message.set_token ('ROUTINE', 'igs_pe_acad_intents_PKG.UPDATE_ROW');

532: x_last_update_login := -1;
533: END IF;
534: ELSE
535: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
536: fnd_message.set_token ('ROUTINE', 'igs_pe_acad_intents_PKG.UPDATE_ROW');
537: igs_ge_msg_stack.add;
538: app_exception.raise_exception;
539: END IF;
540:

Line 561: UPDATE igs_pe_acad_intents

557: IF (x_mode = 'S') THEN
558: igs_sc_gen_001.set_ctx('R');
559: END IF;
560:
561: UPDATE igs_pe_acad_intents
562: SET
563: person_id = new_references.person_id,
564: cal_type = new_references.cal_type,
565: sequence_number = new_references.sequence_number,

Line 624: FROM igs_pe_acad_intents

620: || (reverse chronological order - newest change first)
621: */
622: CURSOR c1 IS
623: SELECT rowid
624: FROM igs_pe_acad_intents
625: WHERE acad_intent_id = x_acad_intent_id;
626:
627: BEGIN
628:

Line 685: DELETE FROM igs_pe_acad_intents

681:
682: IF (x_mode = 'S') THEN
683: igs_sc_gen_001.set_ctx('R');
684: END IF;
685: DELETE FROM igs_pe_acad_intents
686: WHERE rowid = x_rowid;
687:
688: if (sql%notfound) then
689: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 701: END igs_pe_acad_intents_pkg;

697:
698: END delete_row;
699:
700:
701: END igs_pe_acad_intents_pkg;