APPS.IGS_PR_OU_UNIT_SET_PKG dependencies on IGS_PR_OU_UNIT_SET_ALL

Line 5: old_references IGS_PR_OU_UNIT_SET_ALL%RowType;

1: package body IGS_PR_OU_UNIT_SET_PKG AS
2: /* $Header: IGSQI08B.pls 115.6 2003/02/25 09:09:24 anilk ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_OU_UNIT_SET_ALL%RowType;
6: new_references IGS_PR_OU_UNIT_SET_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PR_OU_UNIT_SET_ALL%RowType;

2: /* $Header: IGSQI08B.pls 115.6 2003/02/25 09:09:24 anilk ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_OU_UNIT_SET_ALL%RowType;
6: new_references IGS_PR_OU_UNIT_SET_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 26: FROM IGS_PR_OU_UNIT_SET_ALL

22: ) AS
23:
24: CURSOR cur_old_ref_values IS
25: SELECT *
26: FROM IGS_PR_OU_UNIT_SET_ALL
27: WHERE rowid = x_rowid;
28:
29: BEGIN
30:

Line 118: FROM IGS_PR_OU_UNIT_SET_ALL

114: ) RETURN BOOLEAN AS
115:
116: CURSOR cur_rowid IS
117: SELECT rowid
118: FROM IGS_PR_OU_UNIT_SET_ALL
119: WHERE progression_rule_cat = x_progression_rule_cat
120: AND pra_sequence_number = x_pra_sequence_number
121: AND pro_sequence_number = x_pro_sequence_number
122: AND unit_set_cd = x_unit_set_cd

Line 150: FROM IGS_PR_OU_UNIT_SET_ALL

146: ) AS
147:
148: CURSOR cur_rowid IS
149: SELECT rowid
150: FROM IGS_PR_OU_UNIT_SET_ALL
151: WHERE progression_rule_cat = x_progression_rule_cat
152: AND pra_sequence_number = x_pra_sequence_number
153: AND pro_sequence_number = x_sequence_number ;
154:

Line 179: FROM IGS_PR_OU_UNIT_SET_ALL

175: ) AS
176:
177: CURSOR cur_rowid IS
178: SELECT rowid
179: FROM IGS_PR_OU_UNIT_SET_ALL
180: WHERE unit_set_cd = x_unit_set_cd
181: AND us_version_number = x_version_number ;
182:
183: lv_rowid cur_rowid%RowType;

Line 336: cursor C is select ROWID from IGS_PR_OU_UNIT_SET_ALL

332: X_US_VERSION_NUMBER in NUMBER,
333: X_MODE in VARCHAR2 default 'R',
334: X_ORG_ID IN NUMBER
335: ) AS
336: cursor C is select ROWID from IGS_PR_OU_UNIT_SET_ALL
337: where PROGRESSION_RULE_CAT = X_PROGRESSION_RULE_CAT
338: and PRA_SEQUENCE_NUMBER = X_PRA_SEQUENCE_NUMBER
339: and PRO_SEQUENCE_NUMBER = X_PRO_SEQUENCE_NUMBER
340: and UNIT_SET_CD = X_UNIT_SET_CD

Line 379: insert into IGS_PR_OU_UNIT_SET_ALL (

375: x_last_updated_by => x_last_updated_by ,
376: x_last_update_login => x_last_update_login ,
377: x_org_id => igs_ge_gen_003.get_org_id
378: );
379: insert into IGS_PR_OU_UNIT_SET_ALL (
380: PROGRESSION_RULE_CAT,
381: PRA_SEQUENCE_NUMBER,
382: PRO_SEQUENCE_NUMBER,
383: UNIT_SET_CD,

Line 424: from IGS_PR_OU_UNIT_SET_ALL

420: X_US_VERSION_NUMBER in NUMBER
421: ) AS
422: cursor c1 is select
423: rowid
424: from IGS_PR_OU_UNIT_SET_ALL
425: where ROWID = X_ROWID for update nowait;
426: tlinfo c1%rowtype;
427:
428: begin

Line 451: delete from IGS_PR_OU_UNIT_SET_ALL

447: p_action => 'DELETE',
448: x_rowid => X_ROWID
449: );
450:
451: delete from IGS_PR_OU_UNIT_SET_ALL
452: where ROWID = X_ROWID;
453: if (sql%notfound) then
454: raise no_data_found;
455: end if;