APPS.IGS_PS_UNIT_VER_HIST_PKG dependencies on IGS_PS_UNIT_VER_HIST_ALL

Line 4: old_references IGS_PS_UNIT_VER_HIST_ALL%RowType;

1: package body IGS_PS_UNIT_VER_HIST_PKG as
2: /* $Header: IGSPI93B.pls 120.1 2006/08/10 14:05:07 pkpatel noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_UNIT_VER_HIST_ALL%RowType;
5: new_references IGS_PS_UNIT_VER_HIST_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_PS_UNIT_VER_HIST_ALL%RowType;

1: package body IGS_PS_UNIT_VER_HIST_PKG as
2: /* $Header: IGSPI93B.pls 120.1 2006/08/10 14:05:07 pkpatel noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_UNIT_VER_HIST_ALL%RowType;
5: new_references IGS_PS_UNIT_VER_HIST_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 109: FROM IGS_PS_UNIT_VER_HIST_ALL

105: ) AS
106:
107: CURSOR cur_old_ref_values IS
108: SELECT *
109: FROM IGS_PS_UNIT_VER_HIST_ALL
110: WHERE rowid = x_rowid;
111:
112: BEGIN
113:

Line 468: FROM IGS_PS_UNIT_VER_HIST_ALL

464: ) RETURN BOOLEAN AS
465:
466: CURSOR cur_rowid IS
467: SELECT rowid
468: FROM IGS_PS_UNIT_VER_HIST_ALL
469: WHERE unit_cd = x_unit_cd
470: AND version_number = x_version_number
471: AND hist_start_dt = x_hist_start_dt
472: FOR UPDATE NOWAIT;

Line 856: cursor C is select ROWID from IGS_PS_UNIT_VER_HIST_ALL

852: x_ovrd_wkld_val_flag IN VARCHAR2 ,
853: x_workload_val_code IN VARCHAR2 ,
854: x_billing_hrs IN NUMBER
855: ) AS
856: cursor C is select ROWID from IGS_PS_UNIT_VER_HIST_ALL
857: where UNIT_CD = X_UNIT_CD
858: and VERSION_NUMBER = X_VERSION_NUMBER
859: and HIST_START_DT = X_HIST_START_DT;
860: X_LAST_UPDATE_DATE DATE;

Line 983: INSERT INTO IGS_PS_UNIT_VER_HIST_ALL (

979: x_workload_val_code => x_workload_val_code,
980: x_billing_hrs => x_billing_hrs
981: );
982:
983: INSERT INTO IGS_PS_UNIT_VER_HIST_ALL (
984: UNIT_CD,
985: VERSION_NUMBER,
986: HIST_START_DT,
987: HIST_END_DT,

Line 1370: from IGS_PS_UNIT_VER_HIST_ALL

1366: billing_credit_points,
1367: ovrd_wkld_val_flag,
1368: workload_val_code,
1369: billing_hrs
1370: from IGS_PS_UNIT_VER_HIST_ALL
1371: where ROWID = X_ROWID for update nowait;
1372: tlinfo c1%rowtype;
1373:
1374: begin

Line 1863: UPDATE IGS_PS_UNIT_VER_HIST_ALL SET

1859: x_workload_val_code => x_workload_val_code,
1860: x_billing_hrs => x_billing_hrs
1861: );
1862:
1863: UPDATE IGS_PS_UNIT_VER_HIST_ALL SET
1864: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
1865: HIST_WHO = NEW_REFERENCES.HIST_WHO,
1866: START_DT = NEW_REFERENCES.START_DT,
1867: REVIEW_DT = NEW_REFERENCES.REVIEW_DT,

Line 2059: cursor c1 is select rowid from IGS_PS_UNIT_VER_HIST_ALL

2055: x_ovrd_wkld_val_flag IN VARCHAR2,
2056: x_workload_val_code IN VARCHAR2 ,
2057: x_billing_hrs IN NUMBER
2058: ) AS
2059: cursor c1 is select rowid from IGS_PS_UNIT_VER_HIST_ALL
2060: where UNIT_CD = X_UNIT_CD
2061: and VERSION_NUMBER = X_VERSION_NUMBER
2062: and HIST_START_DT = X_HIST_START_DT
2063: ;

Line 2271: delete from IGS_PS_UNIT_VER_HIST_ALL

2267: Before_DML (
2268: p_action => 'DELETE',
2269: x_rowid => X_ROWID
2270: );
2271: delete from IGS_PS_UNIT_VER_HIST_ALL
2272: where ROWID = X_ROWID;
2273: if (sql%notfound) then
2274: raise no_data_found;
2275: end if;