APPS.IGS_PR_RU_CAT_PKG dependencies on IGS_PR_RU_CAT

Line 1: package body IGS_PR_RU_CAT_PKG AS

1: package body IGS_PR_RU_CAT_PKG AS
2: /* $Header: IGSQI11B.pls 115.6 2003/05/19 04:46:43 ijeddy ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PR_RU_CAT%RowType;
5: new_references IGS_PR_RU_CAT%RowType;

Line 4: old_references IGS_PR_RU_CAT%RowType;

1: package body IGS_PR_RU_CAT_PKG AS
2: /* $Header: IGSQI11B.pls 115.6 2003/05/19 04:46:43 ijeddy ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PR_RU_CAT%RowType;
5: new_references IGS_PR_RU_CAT%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_PR_RU_CAT%RowType;

1: package body IGS_PR_RU_CAT_PKG AS
2: /* $Header: IGSQI11B.pls 115.6 2003/05/19 04:46:43 ijeddy ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PR_RU_CAT%RowType;
5: new_references IGS_PR_RU_CAT%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 25: FROM IGS_PR_RU_CAT

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

Line 68: -- ON IGS_PR_RU_CAT

64:
65: -- Trigger description :-
66: -- "OSS_TST".trg_prgc_br_iu
67: -- BEFORE INSERT OR UPDATE
68: -- ON IGS_PR_RU_CAT
69: -- FOR EACH ROW
70:
71: PROCEDURE BeforeRowInsertUpdate1(
72: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 127: IGS_PR_RULE_PKG.GET_FK_IGS_PR_RU_CAT (

123:
124: PROCEDURE Check_Child_Existance AS
125: BEGIN
126:
127: IGS_PR_RULE_PKG.GET_FK_IGS_PR_RU_CAT (
128: old_references.progression_rule_cat
129: );
130:
131: IGS_PR_RU_APPL_PKG.GET_FK_IGS_PR_RU_CAT (

Line 131: IGS_PR_RU_APPL_PKG.GET_FK_IGS_PR_RU_CAT (

127: IGS_PR_RULE_PKG.GET_FK_IGS_PR_RU_CAT (
128: old_references.progression_rule_cat
129: );
130:
131: IGS_PR_RU_APPL_PKG.GET_FK_IGS_PR_RU_CAT (
132: old_references.progression_rule_cat
133: );
134:
135: END Check_Child_Existance;

Line 143: FROM IGS_PR_RU_CAT

139: ) RETURN BOOLEAN AS
140:
141: CURSOR cur_rowid IS
142: SELECT rowid
143: FROM IGS_PR_RU_CAT
144: WHERE progression_rule_cat = x_progression_rule_cat
145: FOR UPDATE NOWAIT;
146:
147: lv_rowid cur_rowid%RowType;

Line 169: FROM IGS_PR_RU_CAT

165: ) IS
166:
167: CURSOR cur_rowid IS
168: SELECT rowid
169: FROM IGS_PR_RU_CAT
170: WHERE s_rule_call_cd = x_s_rule_call_cd ;
171:
172: lv_rowid cur_rowid%RowType;
173:

Line 278: cursor C is select ROWID from IGS_PR_RU_CAT

274: X_MESSAGE in VARCHAR2,
275: X_POSITIVE_RULE_IND IN VARCHAR2 DEFAULT 'N',
276: X_MODE in VARCHAR2 default 'R'
277: ) AS
278: cursor C is select ROWID from IGS_PR_RU_CAT
279: where PROGRESSION_RULE_CAT = X_PROGRESSION_RULE_CAT;
280: X_LAST_UPDATE_DATE DATE;
281: X_LAST_UPDATED_BY NUMBER;
282: X_LAST_UPDATE_LOGIN NUMBER;

Line 319: insert into IGS_PR_RU_CAT (

315: x_last_updated_by => x_last_updated_by ,
316: x_last_update_login => x_last_update_login
317: );
318:
319: insert into IGS_PR_RU_CAT (
320: PROGRESSION_RULE_CAT,
321: DESCRIPTION,
322: S_RULE_CALL_CD,
323: CLOSED_IND,

Line 369: from IGS_PR_RU_CAT

365: S_RULE_CALL_CD,
366: CLOSED_IND,
367: MESSAGE,
368: POSITIVE_RULE_IND
369: from IGS_PR_RU_CAT
370: where ROWID = X_ROWID for update nowait;
371: tlinfo c1%rowtype;
372:
373: begin

Line 453: update IGS_PR_RU_CAT set

449: x_last_update_login => x_last_update_login
450: );
451:
452:
453: update IGS_PR_RU_CAT set
454: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
455: S_RULE_CALL_CD = NEW_REFERENCES.S_RULE_CALL_CD,
456: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
457: MESSAGE = NEW_REFERENCES.MESSAGE,

Line 480: cursor c1 is select rowid from IGS_PR_RU_CAT

476: X_MESSAGE in VARCHAR2,
477: X_POSITIVE_RULE_IND IN VARCHAR2 DEFAULT 'N',
478: X_MODE in VARCHAR2 default 'R'
479: ) AS
480: cursor c1 is select rowid from IGS_PR_RU_CAT
481: where PROGRESSION_RULE_CAT = X_PROGRESSION_RULE_CAT
482: ;
483: begin
484: open c1;

Line 520: delete from IGS_PR_RU_CAT

516: p_action => 'DELETE',
517: x_rowid => X_ROWID
518: );
519:
520: delete from IGS_PR_RU_CAT
521: where ROWID = X_ROWID;
522: if (sql%notfound) then
523: raise no_data_found;
524: end if;

Line 571: end IGS_PR_RU_CAT_PKG;

567: END IF;
568:
569: END Check_Constraints;
570:
571: end IGS_PR_RU_CAT_PKG;