APPS.IGS_PR_OU_UNIT_PKG dependencies on IGS_PR_OU_UNIT_ALL

Line 5: old_references IGS_PR_OU_UNIT_ALL%RowType;

1: package body IGS_PR_OU_UNIT_PKG as
2: /* $Header: IGSQI07B.pls 115.7 2003/02/25 09:15:13 anilk ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_OU_UNIT_ALL%RowType;
6: new_references IGS_PR_OU_UNIT_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PR_OU_UNIT_ALL%RowType;

2: /* $Header: IGSQI07B.pls 115.7 2003/02/25 09:15:13 anilk ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_OU_UNIT_ALL%RowType;
6: new_references IGS_PR_OU_UNIT_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_ALL

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

Line 114: FROM IGS_PR_OU_UNIT_ALL

110: ) RETURN BOOLEAN AS
111:
112: CURSOR cur_rowid IS
113: SELECT rowid
114: FROM IGS_PR_OU_UNIT_ALL
115: WHERE progression_rule_cat = x_progression_rule_cat
116: AND pra_sequence_number = x_pra_sequence_number
117: AND pro_sequence_number = x_pro_sequence_number
118: AND unit_cd = x_unit_cd

Line 145: FROM IGS_PR_OU_UNIT_ALL

141: ) AS
142:
143: CURSOR cur_rowid IS
144: SELECT rowid
145: FROM IGS_PR_OU_UNIT_ALL
146: WHERE progression_rule_cat = x_progression_rule_cat
147: AND pra_sequence_number = x_pra_sequence_number
148: AND pro_sequence_number = x_sequence_number ;
149:

Line 173: FROM IGS_PR_OU_UNIT_ALL

169: ) AS
170:
171: CURSOR cur_rowid IS
172: SELECT rowid
173: FROM IGS_PR_OU_UNIT_ALL
174: WHERE unit_cd = x_unit_cd ;
175:
176: lv_rowid cur_rowid%RowType;
177:

Line 329: cursor C is select ROWID from IGS_PR_OU_UNIT_ALL

325: X_S_UNIT_TYPE in VARCHAR2,
326: X_MODE in VARCHAR2 default 'R',
327: X_ORG_ID IN NUMBER
328: ) AS
329: cursor C is select ROWID from IGS_PR_OU_UNIT_ALL
330: where PROGRESSION_RULE_CAT = X_PROGRESSION_RULE_CAT
331: and PRA_SEQUENCE_NUMBER = X_PRA_SEQUENCE_NUMBER
332: and PRO_SEQUENCE_NUMBER = X_PRO_SEQUENCE_NUMBER
333: and UNIT_CD = X_UNIT_CD;

Line 371: insert into IGS_PR_OU_UNIT_ALL (

367: x_last_updated_by => x_last_updated_by,
368: x_last_update_login => x_last_update_login,
369: x_org_id => igs_ge_gen_003.get_org_id
370: );
371: insert into IGS_PR_OU_UNIT_ALL (
372: PROGRESSION_RULE_CAT,
373: PRA_SEQUENCE_NUMBER,
374: PRO_SEQUENCE_NUMBER,
375: UNIT_CD,

Line 416: from IGS_PR_OU_UNIT_ALL

412: X_S_UNIT_TYPE in VARCHAR2
413: ) AS
414: cursor c1 is select
415: S_UNIT_TYPE
416: from IGS_PR_OU_UNIT_ALL
417: where ROWID = X_ROWID for update nowait;
418: tlinfo c1%rowtype;
419:
420: begin

Line 489: update IGS_PR_OU_UNIT_ALL set

485: x_last_updated_by => x_last_updated_by,
486: x_last_update_login => x_last_update_login
487: );
488:
489: update IGS_PR_OU_UNIT_ALL set
490: S_UNIT_TYPE = NEW_REFERENCES.S_UNIT_TYPE,
491: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
492: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
493: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 511: cursor c1 is select rowid from IGS_PR_OU_UNIT_ALL

507: X_S_UNIT_TYPE in VARCHAR2,
508: X_MODE in VARCHAR2 default 'R',
509: X_ORG_ID IN NUMBER
510: ) AS
511: cursor c1 is select rowid from IGS_PR_OU_UNIT_ALL
512: where PROGRESSION_RULE_CAT = X_PROGRESSION_RULE_CAT
513: and PRA_SEQUENCE_NUMBER = X_PRA_SEQUENCE_NUMBER
514: and PRO_SEQUENCE_NUMBER = X_PRO_SEQUENCE_NUMBER
515: and UNIT_CD = X_UNIT_CD

Line 553: delete from IGS_PR_OU_UNIT_ALL

549: p_action => 'DELETE',
550: x_rowid => X_ROWID
551: ) ;
552:
553: delete from IGS_PR_OU_UNIT_ALL
554: where ROWID = X_ROWID;
555: if (sql%notfound) then
556: raise no_data_found;
557: end if;