APPS.IGS_PR_OU_PS_PKG dependencies on IGS_PR_OU_PS_ALL

Line 4: old_references IGS_PR_OU_PS_ALL%RowType;

1: package body IGS_PR_OU_PS_PKG as
2: /* $Header: IGSQI05B.pls 115.7 2003/02/25 09:11:31 anilk ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PR_OU_PS_ALL%RowType;
5: new_references IGS_PR_OU_PS_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_PR_OU_PS_ALL%RowType;

1: package body IGS_PR_OU_PS_PKG as
2: /* $Header: IGSQI05B.pls 115.7 2003/02/25 09:11:31 anilk ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PR_OU_PS_ALL%RowType;
5: new_references IGS_PR_OU_PS_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM IGS_PR_OU_PS_ALL

20: ) AS
21:
22: CURSOR cur_old_ref_values IS
23: SELECT *
24: FROM IGS_PR_OU_PS_ALL
25: WHERE rowid = x_rowid;
26:
27: BEGIN
28:

Line 111: FROM IGS_PR_OU_PS_ALL

107: ) RETURN BOOLEAN AS
108:
109: CURSOR cur_rowid IS
110: SELECT rowid
111: FROM IGS_PR_OU_PS_ALL
112: WHERE progression_rule_cat = x_progression_rule_cat
113: AND pra_sequence_number = x_pra_sequence_number
114: AND pro_sequence_number = x_pro_sequence_number
115: AND course_cd = x_course_cd

Line 138: FROM IGS_PR_OU_PS_ALL

134: ) AS
135:
136: CURSOR cur_rowid IS
137: SELECT rowid
138: FROM IGS_PR_OU_PS_ALL
139: WHERE course_cd = x_course_cd ;
140:
141: lv_rowid cur_rowid%RowType;
142:

Line 166: FROM IGS_PR_OU_PS_ALL

162: ) AS
163:
164: CURSOR cur_rowid IS
165: SELECT rowid
166: FROM IGS_PR_OU_PS_ALL
167: WHERE progression_rule_cat = x_progression_rule_cat
168: AND pra_sequence_number = x_pra_sequence_number
169: AND pro_sequence_number = x_sequence_number ;
170:

Line 321: cursor C is select ROWID from IGS_PR_OU_PS_ALL

317: X_COURSE_CD in VARCHAR2,
318: X_MODE in VARCHAR2 default 'R',
319: X_ORG_ID in NUMBER
320: ) as
321: cursor C is select ROWID from IGS_PR_OU_PS_ALL
322: where PROGRESSION_RULE_CAT = X_PROGRESSION_RULE_CAT
323: and PRA_SEQUENCE_NUMBER = X_PRA_SEQUENCE_NUMBER
324: and PRO_SEQUENCE_NUMBER = X_PRO_SEQUENCE_NUMBER
325: and COURSE_CD = X_COURSE_CD;

Line 364: insert into IGS_PR_OU_PS_ALL (

360: x_last_update_login => x_last_update_login,
361: x_org_id => igs_ge_gen_003.get_org_id
362: );
363:
364: insert into IGS_PR_OU_PS_ALL (
365: PROGRESSION_RULE_CAT,
366: PRA_SEQUENCE_NUMBER,
367: PRO_SEQUENCE_NUMBER,
368: COURSE_CD,

Line 406: from IGS_PR_OU_PS_ALL

402: X_COURSE_CD in VARCHAR2
403: ) as
404: cursor c1 is select
405: rowid
406: from IGS_PR_OU_PS_ALL
407: Where ROWID = X_ROWID for update nowait;
408: tlinfo c1%rowtype;
409:
410: begin

Line 433: delete from IGS_PR_OU_PS_ALL

429: p_action => 'DELETE',
430: x_rowid => X_ROWID
431: );
432:
433: delete from IGS_PR_OU_PS_ALL
434: where ROWID = X_ROWID;
435: if (sql%notfound) then
436: raise no_data_found;
437: end if;