eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_PS_UNIT_VER_RU_PKG dependencies on IGS_PS_UNIT_VER_RU

Line 1: package body IGS_PS_UNIT_VER_RU_PKG as

1: package body IGS_PS_UNIT_VER_RU_PKG as
2: /* $Header: IGSPI95B.pls 115.6 2002/11/29 02:43:12 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_UNIT_VER_RU%RowType;
5: new_references IGS_PS_UNIT_VER_RU%RowType;

Line 4: old_references IGS_PS_UNIT_VER_RU%RowType;

1: package body IGS_PS_UNIT_VER_RU_PKG as
2: /* $Header: IGSPI95B.pls 115.6 2002/11/29 02:43:12 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_UNIT_VER_RU%RowType;
5: new_references IGS_PS_UNIT_VER_RU%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_PS_UNIT_VER_RU%RowType;

1: package body IGS_PS_UNIT_VER_RU_PKG as
2: /* $Header: IGSPI95B.pls 115.6 2002/11/29 02:43:12 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_UNIT_VER_RU%RowType;
5: new_references IGS_PS_UNIT_VER_RU%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 23: FROM IGS_PS_UNIT_VER_RU

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

Line 197: FROM IGS_PS_UNIT_VER_RU

193: ) RETURN BOOLEAN AS
194:
195: CURSOR cur_rowid IS
196: SELECT rowid
197: FROM IGS_PS_UNIT_VER_RU
198: WHERE unit_cd = x_unit_cd
199: AND version_number = x_version_number
200: AND s_rule_call_cd = x_s_rule_call_cd
201: FOR UPDATE NOWAIT;

Line 225: FROM IGS_PS_UNIT_VER_RU

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

Line 251: FROM IGS_PS_UNIT_VER_RU

247: ) AS
248:
249: CURSOR cur_rowid IS
250: SELECT rowid
251: FROM IGS_PS_UNIT_VER_RU
252: WHERE s_rule_call_cd = x_s_rule_call_cd ;
253:
254: lv_rowid cur_rowid%RowType;
255:

Line 278: FROM IGS_PS_UNIT_VER_RU

274: ) AS
275:
276: CURSOR cur_rowid IS
277: SELECT rowid
278: FROM IGS_PS_UNIT_VER_RU
279: WHERE unit_cd = x_unit_cd
280: AND version_number = x_version_number ;
281:
282: lv_rowid cur_rowid%RowType;

Line 383: cursor C is select ROWID from IGS_PS_UNIT_VER_RU

379: X_S_RULE_CALL_CD in VARCHAR2,
380: X_RUL_SEQUENCE_NUMBER in NUMBER,
381: X_MODE in VARCHAR2 default 'R'
382: ) AS
383: cursor C is select ROWID from IGS_PS_UNIT_VER_RU
384: where UNIT_CD = X_UNIT_CD
385: and VERSION_NUMBER = X_VERSION_NUMBER
386: and S_RULE_CALL_CD = X_S_RULE_CALL_CD;
387: X_LAST_UPDATE_DATE DATE;

Line 424: insert into IGS_PS_UNIT_VER_RU (

420: x_last_updated_by => X_LAST_UPDATED_BY,
421: x_last_update_login => X_LAST_UPDATE_LOGIN
422: );
423:
424: insert into IGS_PS_UNIT_VER_RU (
425: UNIT_CD,
426: VERSION_NUMBER,
427: S_RULE_CALL_CD,
428: RUL_SEQUENCE_NUMBER,

Line 469: from IGS_PS_UNIT_VER_RU

465: X_RUL_SEQUENCE_NUMBER in NUMBER
466: ) AS
467: cursor c1 is select
468: RUL_SEQUENCE_NUMBER
469: from IGS_PS_UNIT_VER_RU
470: where ROWID = X_ROWID for update nowait;
471: tlinfo c1%rowtype;
472:
473: begin

Line 540: update IGS_PS_UNIT_VER_RU set

536: x_last_update_date => X_LAST_UPDATE_DATE,
537: x_last_updated_by => X_LAST_UPDATED_BY,
538: x_last_update_login => X_LAST_UPDATE_LOGIN
539: );
540: update IGS_PS_UNIT_VER_RU set
541: RUL_SEQUENCE_NUMBER = NEW_REFERENCES.RUL_SEQUENCE_NUMBER,
542: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
543: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
544: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 563: cursor c1 is select rowid from IGS_PS_UNIT_VER_RU

559: X_S_RULE_CALL_CD in VARCHAR2,
560: X_RUL_SEQUENCE_NUMBER in NUMBER,
561: X_MODE in VARCHAR2 default 'R'
562: ) AS
563: cursor c1 is select rowid from IGS_PS_UNIT_VER_RU
564: where UNIT_CD = X_UNIT_CD
565: and VERSION_NUMBER = X_VERSION_NUMBER
566: and S_RULE_CALL_CD = X_S_RULE_CALL_CD
567: ;

Line 600: delete from IGS_PS_UNIT_VER_RU

596: Before_DML (
597: p_action => 'DELETE',
598: x_rowid => X_ROWID
599: );
600: delete from IGS_PS_UNIT_VER_RU
601: where ROWID = X_ROWID;
602: if (sql%notfound) then
603: raise no_data_found;
604: end if;

Line 611: end IGS_PS_UNIT_VER_RU_PKG;

607: x_rowid => X_ROWID
608: );
609: end DELETE_ROW;
610:
611: end IGS_PS_UNIT_VER_RU_PKG;