APPS.IGS_PS_UNIT_RU_PKG dependencies on IGS_PS_UNIT_RU

Line 1: package body IGS_PS_UNIT_RU_PKG as

1: package body IGS_PS_UNIT_RU_PKG as
2: /* $Header: IGSPI90B.pls 115.7 2002/11/29 02:41:32 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_RU%RowType;

Line 5: old_references IGS_PS_UNIT_RU%RowType;

1: package body IGS_PS_UNIT_RU_PKG as
2: /* $Header: IGSPI90B.pls 115.7 2002/11/29 02:41:32 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_RU%RowType;
6: new_references IGS_PS_UNIT_RU%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_UNIT_RU%RowType;

2: /* $Header: IGSPI90B.pls 115.7 2002/11/29 02:41:32 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_RU%RowType;
6: new_references IGS_PS_UNIT_RU%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 23: FROM IGS_PS_UNIT_RU

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

Line 146: FROM IGS_PS_UNIT_RU

142: ) RETURN BOOLEAN AS
143:
144: CURSOR cur_rowid IS
145: SELECT rowid
146: FROM IGS_PS_UNIT_RU
147: WHERE unit_cd = x_unit_cd
148: AND s_rule_call_cd = x_s_rule_call_cd
149: FOR UPDATE NOWAIT;
150:

Line 173: FROM IGS_PS_UNIT_RU

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

Line 199: FROM IGS_PS_UNIT_RU

195: ) AS
196:
197: CURSOR cur_rowid IS
198: SELECT rowid
199: FROM IGS_PS_UNIT_RU
200: WHERE unit_cd = x_unit_cd ;
201:
202: lv_rowid cur_rowid%RowType;
203:

Line 225: FROM IGS_PS_UNIT_RU

221: ) AS
222:
223: CURSOR cur_rowid IS
224: SELECT rowid
225: FROM IGS_PS_UNIT_RU
226: WHERE rul_sequence_number = x_sequence_number ;
227:
228: lv_rowid cur_rowid%RowType;
229:

Line 321: cursor C is select ROWID from IGS_PS_UNIT_RU

317: X_S_RULE_CALL_CD in VARCHAR2,
318: X_RUL_SEQUENCE_NUMBER in NUMBER,
319: X_MODE in VARCHAR2 default 'R'
320: ) AS
321: cursor C is select ROWID from IGS_PS_UNIT_RU
322: where UNIT_CD = X_UNIT_CD
323: and S_RULE_CALL_CD = X_S_RULE_CALL_CD;
324: X_LAST_UPDATE_DATE DATE;
325: X_LAST_UPDATED_BY NUMBER;

Line 360: insert into IGS_PS_UNIT_RU (

356: x_last_updated_by => X_LAST_UPDATED_BY,
357: x_last_update_login => X_LAST_UPDATE_LOGIN
358: );
359:
360: insert into IGS_PS_UNIT_RU (
361: UNIT_CD,
362: S_RULE_CALL_CD,
363: RUL_SEQUENCE_NUMBER,
364: CREATION_DATE,

Line 402: from IGS_PS_UNIT_RU

398: X_RUL_SEQUENCE_NUMBER in NUMBER
399: ) AS
400: cursor c1 is select
401: RUL_SEQUENCE_NUMBER
402: from IGS_PS_UNIT_RU
403: where ROWID = X_ROWID for update nowait;
404: tlinfo c1%rowtype;
405:
406: begin

Line 472: update IGS_PS_UNIT_RU set

468: x_last_updated_by => X_LAST_UPDATED_BY,
469: x_last_update_login => X_LAST_UPDATE_LOGIN
470: );
471:
472: update IGS_PS_UNIT_RU set
473: RUL_SEQUENCE_NUMBER = NEW_REFERENCES.RUL_SEQUENCE_NUMBER,
474: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
475: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
476: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 496: cursor c1 is select rowid from IGS_PS_UNIT_RU

492: X_S_RULE_CALL_CD in VARCHAR2,
493: X_RUL_SEQUENCE_NUMBER in NUMBER,
494: X_MODE in VARCHAR2 default 'R'
495: ) AS
496: cursor c1 is select rowid from IGS_PS_UNIT_RU
497: where UNIT_CD = X_UNIT_CD
498: and S_RULE_CALL_CD = X_S_RULE_CALL_CD
499: ;
500: begin

Line 530: delete from IGS_PS_UNIT_RU

526: Before_DML (
527: p_action => 'DELETE',
528: x_rowid => X_ROWID
529: );
530: delete from IGS_PS_UNIT_RU
531: where ROWID = X_ROWID;
532: if (sql%notfound) then
533: raise no_data_found;
534: end if;

Line 541: end IGS_PS_UNIT_RU_PKG;

537: x_rowid => X_ROWID
538: );
539: end DELETE_ROW;
540:
541: end IGS_PS_UNIT_RU_PKG;