APPS.IGS_PS_UNIT_DSCP_PKG dependencies on IGS_PS_UNIT_DSCP

Line 1: package body IGS_PS_UNIT_DSCP_PKG as

1: package body IGS_PS_UNIT_DSCP_PKG as
2: /* $Header: IGSPI76B.pls 115.6 2002/11/29 02:37:33 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_DSCP%RowType;

Line 5: old_references IGS_PS_UNIT_DSCP%RowType;

1: package body IGS_PS_UNIT_DSCP_PKG as
2: /* $Header: IGSPI76B.pls 115.6 2002/11/29 02:37:33 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_DSCP%RowType;
6: new_references IGS_PS_UNIT_DSCP%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_UNIT_DSCP%RowType;

2: /* $Header: IGSPI76B.pls 115.6 2002/11/29 02:37:33 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_DSCP%RowType;
6: new_references IGS_PS_UNIT_DSCP%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,

Line 24: FROM IGS_PS_UNIT_DSCP

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

Line 67: v_unit_cd IGS_PS_UNIT_DSCP.unit_cd%TYPE;

63: p_inserting IN BOOLEAN ,
64: p_updating IN BOOLEAN ,
65: p_deleting IN BOOLEAN
66: ) AS
67: v_unit_cd IGS_PS_UNIT_DSCP.unit_cd%TYPE;
68: v_version_number IGS_PS_UNIT_DSCP.version_number%TYPE;
69: v_percentage IGS_PS_UNIT_DSCP.percentage%TYPE;
70: v_message_name Varchar2(30);
71: BEGIN

Line 68: v_version_number IGS_PS_UNIT_DSCP.version_number%TYPE;

64: p_updating IN BOOLEAN ,
65: p_deleting IN BOOLEAN
66: ) AS
67: v_unit_cd IGS_PS_UNIT_DSCP.unit_cd%TYPE;
68: v_version_number IGS_PS_UNIT_DSCP.version_number%TYPE;
69: v_percentage IGS_PS_UNIT_DSCP.percentage%TYPE;
70: v_message_name Varchar2(30);
71: BEGIN
72: -- Set variables.

Line 69: v_percentage IGS_PS_UNIT_DSCP.percentage%TYPE;

65: p_deleting IN BOOLEAN
66: ) AS
67: v_unit_cd IGS_PS_UNIT_DSCP.unit_cd%TYPE;
68: v_version_number IGS_PS_UNIT_DSCP.version_number%TYPE;
69: v_percentage IGS_PS_UNIT_DSCP.percentage%TYPE;
70: v_message_name Varchar2(30);
71: BEGIN
72: -- Set variables.
73: IF p_deleting THEN

Line 218: FROM IGS_PS_UNIT_DSCP

214: ) RETURN BOOLEAN AS
215:
216: CURSOR cur_rowid IS
217: SELECT rowid
218: FROM IGS_PS_UNIT_DSCP
219: WHERE unit_cd = x_unit_cd
220: AND version_number = x_version_number
221: AND discipline_group_cd = x_discipline_group_cd
222: FOR UPDATE NOWAIT;

Line 247: FROM IGS_PS_UNIT_DSCP

243: ) AS
244:
245: CURSOR cur_rowid IS
246: SELECT rowid
247: FROM IGS_PS_UNIT_DSCP
248: WHERE discipline_group_cd = x_discipline_group_cd ;
249:
250: lv_rowid cur_rowid%RowType;
251:

Line 274: FROM IGS_PS_UNIT_DSCP

270: ) AS
271:
272: CURSOR cur_rowid IS
273: SELECT rowid
274: FROM IGS_PS_UNIT_DSCP
275: WHERE unit_cd = x_unit_cd
276: AND version_number = x_version_number ;
277:
278: lv_rowid cur_rowid%RowType;

Line 379: cursor C is select ROWID from IGS_PS_UNIT_DSCP

375: X_DISCIPLINE_GROUP_CD in VARCHAR2,
376: X_PERCENTAGE in NUMBER,
377: X_MODE in VARCHAR2
378: ) AS
379: cursor C is select ROWID from IGS_PS_UNIT_DSCP
380: where UNIT_CD = X_UNIT_CD
381: and VERSION_NUMBER = X_VERSION_NUMBER
382: and DISCIPLINE_GROUP_CD = X_DISCIPLINE_GROUP_CD;
383: X_LAST_UPDATE_DATE DATE;

Line 420: insert into IGS_PS_UNIT_DSCP (

416: x_last_updated_by => X_LAST_UPDATED_BY,
417: x_last_update_login => X_LAST_UPDATE_LOGIN
418: );
419:
420: insert into IGS_PS_UNIT_DSCP (
421: UNIT_CD,
422: VERSION_NUMBER,
423: DISCIPLINE_GROUP_CD,
424: PERCENTAGE,

Line 464: from IGS_PS_UNIT_DSCP

460: X_PERCENTAGE in NUMBER
461: ) AS
462: cursor c1 is select
463: PERCENTAGE
464: from IGS_PS_UNIT_DSCP
465: where ROWID = X_ROWID
466: for update nowait;
467: tlinfo c1%rowtype;
468:

Line 536: update IGS_PS_UNIT_DSCP set

532: x_last_update_date => X_LAST_UPDATE_DATE,
533: x_last_updated_by => X_LAST_UPDATED_BY,
534: x_last_update_login => X_LAST_UPDATE_LOGIN
535: );
536: update IGS_PS_UNIT_DSCP set
537: PERCENTAGE = NEW_REFERENCES.PERCENTAGE,
538: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
539: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
540: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 561: cursor c1 is select rowid from IGS_PS_UNIT_DSCP

557: X_DISCIPLINE_GROUP_CD in VARCHAR2,
558: X_PERCENTAGE in NUMBER,
559: X_MODE in VARCHAR2
560: ) AS
561: cursor c1 is select rowid from IGS_PS_UNIT_DSCP
562: where UNIT_CD = X_UNIT_CD
563: and VERSION_NUMBER = X_VERSION_NUMBER
564: and DISCIPLINE_GROUP_CD = X_DISCIPLINE_GROUP_CD
565: ;

Line 598: delete from IGS_PS_UNIT_DSCP

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

Line 609: end IGS_PS_UNIT_DSCP_PKG;

605: x_rowid => X_ROWID
606: );
607: end DELETE_ROW;
608:
609: end IGS_PS_UNIT_DSCP_PKG;