APPS.IGS_PE_STD_TODO_PKG dependencies on IGS_PE_STD_TODO

Line 1: package body IGS_PE_STD_TODO_PKG AS

1: package body IGS_PE_STD_TODO_PKG AS
2: /* $Header: IGSNI38B.pls 120.2 2006/01/25 09:21:18 skpandey ship $ */
3:
4: g_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: l_rowid VARCHAR2(25);

Line 6: old_references IGS_PE_STD_TODO%RowType;

2: /* $Header: IGSNI38B.pls 120.2 2006/01/25 09:21:18 skpandey ship $ */
3:
4: g_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: l_rowid VARCHAR2(25);
6: old_references IGS_PE_STD_TODO%RowType;
7: new_references IGS_PE_STD_TODO%RowType;
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 7: new_references IGS_PE_STD_TODO%RowType;

3:
4: g_debug_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: l_rowid VARCHAR2(25);
6: old_references IGS_PE_STD_TODO%RowType;
7: new_references IGS_PE_STD_TODO%RowType;
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,
11: x_person_id IN NUMBER DEFAULT NULL,

Line 24: FROM IGS_PE_STD_TODO

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

Line 110: IGS_PE_STD_TODO_REF_PKG.GET_FK_IGS_PE_STD_TODO (

106: END IF;
107: END Check_Parent_Existance;
108: PROCEDURE Check_Child_Existance AS
109: BEGIN
110: IGS_PE_STD_TODO_REF_PKG.GET_FK_IGS_PE_STD_TODO (
111: old_references.person_id,
112: old_references.s_student_todo_type,
113: old_references.sequence_number
114: );

Line 123: FROM IGS_PE_STD_TODO

119: x_sequence_number IN NUMBER
120: ) RETURN BOOLEAN AS
121: CURSOR cur_rowid IS
122: SELECT rowid
123: FROM IGS_PE_STD_TODO
124: WHERE person_id = x_person_id
125: AND s_student_todo_type = x_s_student_todo_type
126: AND sequence_number = x_sequence_number
127: FOR UPDATE NOWAIT;

Line 142: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_pe_std_todo_pkg.get_pk_for_validation :',SQLERRM);

138: END IF;
139: EXCEPTION
140: WHEN OTHERS THEN
141: IF (FND_LOG.LEVEL_UNEXPECTED >= g_debug_level ) THEN
142: FND_LOG.STRING(fnd_log.level_unexpected, 'igs.patch.115.sql.igs_pe_std_todo_pkg.get_pk_for_validation :',SQLERRM);
143: END IF;
144: RAISE;
145: END Get_PK_For_Validation;
146:

Line 152: FROM IGS_PE_STD_TODO

148: x_person_id IN NUMBER
149: ) AS
150: CURSOR cur_rowid IS
151: SELECT rowid
152: FROM IGS_PE_STD_TODO
153: WHERE person_id = x_person_id ;
154: lv_rowid cur_rowid%RowType;
155: BEGIN
156: Open cur_rowid;

Line 274: cursor C is select ROWID from IGS_PE_STD_TODO

270: X_TODO_DT in DATE,
271: X_LOGICAL_DELETE_DT in DATE,
272: X_MODE in VARCHAR2 default 'R'
273: ) AS
274: cursor C is select ROWID from IGS_PE_STD_TODO
275: where PERSON_ID = X_PERSON_ID
276: and S_STUDENT_TODO_TYPE = X_S_STUDENT_TODO_TYPE
277: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;
278: X_LAST_UPDATE_DATE DATE;

Line 329: insert into IGS_PE_STD_TODO (

325: x_last_update_date=>X_LAST_UPDATE_DATE,
326: x_last_updated_by=>X_LAST_UPDATED_BY,
327: x_last_update_login=>X_LAST_UPDATE_LOGIN
328: );
329: insert into IGS_PE_STD_TODO (
330: PERSON_ID,
331: S_STUDENT_TODO_TYPE,
332: SEQUENCE_NUMBER,
333: TODO_DT,

Line 383: from IGS_PE_STD_TODO

379: ) AS
380: cursor c1 is select
381: TODO_DT,
382: LOGICAL_DELETE_DT
383: from IGS_PE_STD_TODO
384: where ROWID = X_ROWID
385: for update nowait;
386: tlinfo c1%rowtype;
387: begin

Line 476: update IGS_PE_STD_TODO set

472: else
473: X_PROGRAM_UPDATE_DATE := SYSDATE;
474: end if;
475: end if;
476: update IGS_PE_STD_TODO set
477: TODO_DT = NEW_REFERENCES.TODO_DT,
478: LOGICAL_DELETE_DT = NEW_REFERENCES.LOGICAL_DELETE_DT,
479: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
480: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 505: cursor c1 is select rowid from IGS_PE_STD_TODO

501: X_TODO_DT in DATE,
502: X_LOGICAL_DELETE_DT in DATE,
503: X_MODE in VARCHAR2 default 'R'
504: ) AS
505: cursor c1 is select rowid from IGS_PE_STD_TODO
506: where PERSON_ID = X_PERSON_ID
507: and S_STUDENT_TODO_TYPE = X_S_STUDENT_TODO_TYPE
508: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER
509: ;

Line 543: delete from IGS_PE_STD_TODO

539: Before_DML(
540: p_action => 'DELETE',
541: x_rowid => X_ROWID
542: );
543: delete from IGS_PE_STD_TODO
544: where ROWID = X_ROWID;
545: if (sql%notfound) then
546: raise no_data_found;
547: end if;

Line 553: end IGS_PE_STD_TODO_PKG;

549: p_action => 'DELETE',
550: x_rowid => X_ROWID
551: );
552: end DELETE_ROW;
553: end IGS_PE_STD_TODO_PKG;