APPS.IGS_AS_SC_ATMPT_NOTE_PKG dependencies on IGS_AS_SC_ATMPT_NOTE

Line 1: package body IGS_AS_SC_ATMPT_NOTE_PKG AS

1: package body IGS_AS_SC_ATMPT_NOTE_PKG AS
2: /* $Header: IGSDI20B.pls 120.0 2005/07/05 11:51:58 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_SC_ATMPT_NOTE%RowType;

Line 5: old_references IGS_AS_SC_ATMPT_NOTE%RowType;

1: package body IGS_AS_SC_ATMPT_NOTE_PKG AS
2: /* $Header: IGSDI20B.pls 120.0 2005/07/05 11:51:58 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_SC_ATMPT_NOTE%RowType;
6: new_references IGS_AS_SC_ATMPT_NOTE%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 6: new_references IGS_AS_SC_ATMPT_NOTE%RowType;

2: /* $Header: IGSDI20B.pls 120.0 2005/07/05 11:51:58 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_SC_ATMPT_NOTE%RowType;
6: new_references IGS_AS_SC_ATMPT_NOTE%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 22: FROM IGS_AS_SC_ATMPT_NOTE

18: x_last_update_login IN NUMBER DEFAULT NULL
19: ) AS
20: CURSOR cur_old_ref_values IS
21: SELECT *
22: FROM IGS_AS_SC_ATMPT_NOTE
23: WHERE rowid = x_rowid;
24: BEGIN
25: l_rowid := x_rowid;
26: -- Code for setting the Old and New Reference Values.

Line 144: FROM IGS_AS_SC_ATMPT_NOTE

140: x_reference_number IN NUMBER
141: ) RETURN BOOLEAN AS
142: CURSOR cur_rowid IS
143: SELECT rowid
144: FROM IGS_AS_SC_ATMPT_NOTE
145: WHERE person_id = x_person_id
146: AND course_cd = x_course_cd
147: AND reference_number = x_reference_number
148: FOR UPDATE NOWAIT;

Line 169: FROM IGS_AS_SC_ATMPT_NOTE

165: x_enr_note_type IN VARCHAR2
166: ) AS
167: CURSOR cur_rowid IS
168: SELECT rowid
169: FROM IGS_AS_SC_ATMPT_NOTE
170: WHERE enr_note_type= x_enr_note_type ;
171: lv_rowid cur_rowid%RowType;
172: BEGIN
173: Open cur_rowid;

Line 190: FROM IGS_AS_SC_ATMPT_NOTE

186: x_reference_number IN NUMBER
187: ) AS
188: CURSOR cur_rowid IS
189: SELECT rowid
190: FROM IGS_AS_SC_ATMPT_NOTE
191: WHERE reference_number = x_reference_number ;
192: lv_rowid cur_rowid%RowType;
193: BEGIN
194: Open cur_rowid;

Line 212: FROM IGS_AS_SC_ATMPT_NOTE

208: x_course_cd IN VARCHAR2
209: ) AS
210: CURSOR cur_rowid IS
211: SELECT rowid
212: FROM IGS_AS_SC_ATMPT_NOTE
213: WHERE person_id = x_person_id
214: AND course_cd = x_course_cd ;
215: lv_rowid cur_rowid%RowType;
216: BEGIN

Line 302: cursor C is select ROWID from IGS_AS_SC_ATMPT_NOTE

298: X_REFERENCE_NUMBER in NUMBER,
299: X_ENR_NOTE_TYPE in VARCHAR2,
300: X_MODE in VARCHAR2 default 'R'
301: ) AS
302: cursor C is select ROWID from IGS_AS_SC_ATMPT_NOTE
303: where PERSON_ID = X_PERSON_ID
304: and COURSE_CD = X_COURSE_CD
305: and REFERENCE_NUMBER = X_REFERENCE_NUMBER;
306: X_LAST_UPDATE_DATE DATE;

Line 344: insert into IGS_AS_SC_ATMPT_NOTE (

340: );
341: IF (x_mode = 'S') THEN
342: igs_sc_gen_001.set_ctx('R');
343: END IF;
344: insert into IGS_AS_SC_ATMPT_NOTE (
345: PERSON_ID,
346: COURSE_CD,
347: REFERENCE_NUMBER,
348: ENR_NOTE_TYPE,

Line 400: from IGS_AS_SC_ATMPT_NOTE

396: X_ENR_NOTE_TYPE in VARCHAR2
397: ) AS
398: cursor c1 is select
399: ENR_NOTE_TYPE
400: from IGS_AS_SC_ATMPT_NOTE
401: where ROWID = X_ROWID for update nowait;
402: tlinfo c1%rowtype;
403: begin
404: open c1;

Line 470: update IGS_AS_SC_ATMPT_NOTE set

466: );
467: IF (x_mode = 'S') THEN
468: igs_sc_gen_001.set_ctx('R');
469: END IF;
470: update IGS_AS_SC_ATMPT_NOTE set
471: ENR_NOTE_TYPE = NEW_REFERENCES.ENR_NOTE_TYPE,
472: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
473: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
474: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 509: cursor c1 is select rowid from IGS_AS_SC_ATMPT_NOTE

505: X_REFERENCE_NUMBER in NUMBER,
506: X_ENR_NOTE_TYPE in VARCHAR2,
507: X_MODE in VARCHAR2 default 'R'
508: ) AS
509: cursor c1 is select rowid from IGS_AS_SC_ATMPT_NOTE
510: where PERSON_ID = X_PERSON_ID
511: and COURSE_CD = X_COURSE_CD
512: and REFERENCE_NUMBER = X_REFERENCE_NUMBER
513: ;

Line 548: delete from IGS_AS_SC_ATMPT_NOTE

544: );
545: IF (x_mode = 'S') THEN
546: igs_sc_gen_001.set_ctx('R');
547: END IF;
548: delete from IGS_AS_SC_ATMPT_NOTE
549: where ROWID = X_ROWID;
550: if (sql%notfound) then
551: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
552: igs_ge_msg_stack.add;

Line 562: end IGS_AS_SC_ATMPT_NOTE_PKG;

558: END IF;
559:
560:
561: end DELETE_ROW;
562: end IGS_AS_SC_ATMPT_NOTE_PKG;