APPS.IGS_PR_RULE_PKG dependencies on IGS_PR_RULE_ALL

Line 5: old_references IGS_PR_RULE_ALL%RowType;

1: package body IGS_PR_RULE_PKG AS
2: /* $Header: IGSQI09B.pls 115.10 2003/05/19 06:14:14 ijeddy ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_RULE_ALL%RowType;
6: new_references IGS_PR_RULE_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PR_RULE_ALL%RowType;

2: /* $Header: IGSQI09B.pls 115.10 2003/05/19 06:14:14 ijeddy ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_RULE_ALL%RowType;
6: new_references IGS_PR_RULE_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 27: FROM IGS_PR_RULE_ALL

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

Line 148: FROM IGS_PR_RULE_ALL

144: ) RETURN BOOLEAN AS
145:
146: CURSOR cur_rowid IS
147: SELECT rowid
148: FROM IGS_PR_RULE_ALL
149: WHERE progression_rule_cat = x_progression_rule_cat
150: AND progression_rule_cd = x_progression_rule_cd
151: FOR UPDATE NOWAIT;
152:

Line 175: FROM IGS_PR_RULE_ALL

171: ) AS
172:
173: CURSOR cur_rowid IS
174: SELECT rowid
175: FROM IGS_PR_RULE_ALL
176: WHERE progression_rule_cat = x_progression_rule_cat ;
177:
178: lv_rowid cur_rowid%RowType;
179:

Line 201: FROM IGS_PR_RULE_ALL

197: ) AS
198:
199: CURSOR cur_rowid IS
200: SELECT rowid
201: FROM IGS_PR_RULE_ALL
202: WHERE rul_sequence_number = x_sequence_number ;
203:
204: lv_rowid cur_rowid%RowType;
205:

Line 313: cursor C is select ROWID from IGS_PR_RULE_ALL

309: X_MESSAGE in VARCHAR2,
310: X_MODE in VARCHAR2 default 'R',
311: X_ORG_ID in NUMBER
312: ) AS
313: cursor C is select ROWID from IGS_PR_RULE_ALL
314: where PROGRESSION_RULE_CAT = X_PROGRESSION_RULE_CAT
315: and PROGRESSION_RULE_CD = X_PROGRESSION_RULE_CD;
316: X_LAST_UPDATE_DATE DATE;
317: X_LAST_UPDATED_BY NUMBER;

Line 354: insert into IGS_PR_RULE_ALL (

350: x_last_updated_by => x_last_updated_by,
351: x_last_update_login => x_last_update_login,
352: x_org_id=>igs_ge_gen_003.get_org_id
353: ) ;
354: insert into IGS_PR_RULE_ALL (
355: PROGRESSION_RULE_CAT,
356: PROGRESSION_RULE_CD,
357: DESCRIPTION,
358: RUL_SEQUENCE_NUMBER,

Line 405: from IGS_PR_RULE_ALL

401: DESCRIPTION,
402: RUL_SEQUENCE_NUMBER,
403: CLOSED_IND,
404: MESSAGE
405: from IGS_PR_RULE_ALL
406: where ROWID = X_ROWID for update nowait;
407: tlinfo c1%rowtype;
408:
409: begin

Line 486: update IGS_PR_RULE_ALL set

482: x_last_update_login => x_last_update_login
483:
484: ) ;
485:
486: update IGS_PR_RULE_ALL set
487: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
488: RUL_SEQUENCE_NUMBER = NEW_REFERENCES.RUL_SEQUENCE_NUMBER,
489: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
490: MESSAGE = NEW_REFERENCES.MESSAGE,

Line 512: cursor c1 is select rowid from IGS_PR_RULE_ALL

508: X_MESSAGE in VARCHAR2,
509: X_MODE in VARCHAR2 default 'R',
510: X_ORG_ID in NUMBER
511: ) AS
512: cursor c1 is select rowid from IGS_PR_RULE_ALL
513: where PROGRESSION_RULE_CAT = X_PROGRESSION_RULE_CAT
514: and PROGRESSION_RULE_CD = X_PROGRESSION_RULE_CD
515: ;
516: begin

Line 555: delete from IGS_PR_RULE_ALL

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