PACKAGE: APPS.IGS_PS_UNT_DSCP_HIST_PKG

Source

1 package IGS_PS_UNT_DSCP_HIST_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSPI77S.pls 115.4 2002/11/29 02:37:56 nsidana ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_UNIT_CD in VARCHAR2,
7   X_HIST_START_DT in DATE,
8   X_DISCIPLINE_GROUP_CD in VARCHAR2,
9   X_VERSION_NUMBER in NUMBER,
10   X_HIST_END_DT in DATE,
11   X_HIST_WHO in NUMBER,
12   X_PERCENTAGE in NUMBER,
13   X_MODE in VARCHAR2 default 'R' ,
14   X_ORG_ID in NUMBER
15   );
16 procedure LOCK_ROW (
17   X_ROWID IN VARCHAR2,
18   X_UNIT_CD in VARCHAR2,
19   X_HIST_START_DT in DATE,
20   X_DISCIPLINE_GROUP_CD in VARCHAR2,
21   X_VERSION_NUMBER in NUMBER,
22   X_HIST_END_DT in DATE,
23   X_HIST_WHO in NUMBER,
24   X_PERCENTAGE in NUMBER
25 );
26 procedure UPDATE_ROW (
27   X_ROWID IN VARCHAR2,
28   X_UNIT_CD in VARCHAR2,
29   X_HIST_START_DT in DATE,
30   X_DISCIPLINE_GROUP_CD in VARCHAR2,
31   X_VERSION_NUMBER in NUMBER,
32   X_HIST_END_DT in DATE,
33   X_HIST_WHO in NUMBER,
34   X_PERCENTAGE in NUMBER,
35   X_MODE in VARCHAR2 default 'R'
36   );
37 procedure ADD_ROW (
38   X_ROWID in out NOCOPY VARCHAR2,
39   X_UNIT_CD in VARCHAR2,
40   X_HIST_START_DT in DATE,
41   X_DISCIPLINE_GROUP_CD in VARCHAR2,
42   X_VERSION_NUMBER in NUMBER,
43   X_HIST_END_DT in DATE,
44   X_HIST_WHO in NUMBER,
45   X_PERCENTAGE in NUMBER,
46   X_MODE in VARCHAR2 default 'R',
47   X_ORG_ID in NUMBER
48   );
49 procedure DELETE_ROW (
50   X_ROWID IN VARCHAR2
51 );
52  FUNCTION Get_PK_For_Validation (
53     x_unit_cd IN VARCHAR2,
54     x_version_number IN NUMBER,
55     x_discipline_group_cd IN VARCHAR2,
56     x_hist_start_dt IN DATE
57     ) RETURN BOOLEAN;
58 
59   PROCEDURE GET_FK_IGS_PS_DSCP (
60     x_discipline_group_cd IN VARCHAR2
61     );
62 
63   PROCEDURE GET_FK_IGS_PS_UNIT_VER (
64     x_unit_cd IN VARCHAR2,
65     x_version_number IN NUMBER
66     );
67 
68 PROCEDURE Check_Constraints(
69 				Column_Name 	IN	VARCHAR2	DEFAULT NULL,
70 				Column_Value 	IN	VARCHAR2	DEFAULT NULL);
71 
72 
73   PROCEDURE Before_DML (
74     p_action IN VARCHAR2,
75     x_rowid IN VARCHAR2 DEFAULT NULL,
76     x_unit_cd IN VARCHAR2 DEFAULT NULL,
77     x_version_number IN NUMBER DEFAULT NULL,
78     x_discipline_group_cd IN VARCHAR2 DEFAULT NULL,
79     x_hist_start_dt IN DATE DEFAULT NULL,
80     x_hist_end_dt IN DATE DEFAULT NULL,
81     x_hist_who IN NUMBER DEFAULT NULL,
82     x_percentage IN NUMBER DEFAULT NULL,
83     x_creation_date IN DATE DEFAULT NULL,
84     x_created_by IN NUMBER DEFAULT NULL,
85     x_last_update_date IN DATE DEFAULT NULL,
86     x_last_updated_by IN NUMBER DEFAULT NULL,
87     x_last_update_login IN NUMBER DEFAULT NULL,
88     x_org_id IN NUMBER DEFAULT NULL
89   );
90 
91 end IGS_PS_UNT_DSCP_HIST_PKG;