PACKAGE: APPS.IGS_OR_UNIT_HIST_PKG

Source

1 package IGS_OR_UNIT_HIST_PKG AUTHID CURRENT_USER AS
2  /* $Header: IGSOI12S.pls 115.5 2002/11/29 01:40:11 nsidana ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_ORG_UNIT_CD in VARCHAR2,
6   X_OU_START_DT in DATE,
7   X_HIST_START_DT in DATE,
8   X_HIST_END_DT in DATE,
9   X_HIST_WHO in NUMBER,
10   X_OU_END_DT in DATE,
11   X_DESCRIPTION in VARCHAR2,
12   X_ORG_STATUS in VARCHAR2,
13   X_ORG_TYPE in VARCHAR2,
14   X_MEMBER_TYPE in VARCHAR2,
15   X_INSTITUTION_CD in VARCHAR2,
16   X_NAME in VARCHAR2,
17   X_MODE in VARCHAR2 default 'R' ,
18   X_ORG_ID in NUMBER
19   );
20 procedure LOCK_ROW (
21   X_ROWID in VARCHAR2,
22   X_ORG_UNIT_CD in VARCHAR2,
23   X_OU_START_DT in DATE,
24   X_HIST_START_DT in DATE,
25   X_HIST_END_DT in DATE,
26   X_HIST_WHO in NUMBER,
27   X_OU_END_DT in DATE,
28   X_DESCRIPTION in VARCHAR2,
29   X_ORG_STATUS in VARCHAR2,
30   X_ORG_TYPE in VARCHAR2,
31   X_MEMBER_TYPE in VARCHAR2,
32   X_INSTITUTION_CD in VARCHAR2,
33   X_NAME in VARCHAR2
34 
35 );
36 procedure UPDATE_ROW (
37   X_ROWID in VARCHAR2,
38   X_ORG_UNIT_CD in VARCHAR2,
39   X_OU_START_DT in DATE,
40   X_HIST_START_DT in DATE,
41   X_HIST_END_DT in DATE,
42   X_HIST_WHO in NUMBER,
43   X_OU_END_DT in DATE,
44   X_DESCRIPTION in VARCHAR2,
45   X_ORG_STATUS in VARCHAR2,
46   X_ORG_TYPE in VARCHAR2,
47   X_MEMBER_TYPE in VARCHAR2,
48   X_INSTITUTION_CD in VARCHAR2,
49   X_NAME in VARCHAR2,
50   X_MODE in VARCHAR2 default 'R'
51   );
52 procedure ADD_ROW (
53   X_ROWID in out NOCOPY VARCHAR2,
54   X_ORG_UNIT_CD in VARCHAR2,
55   X_OU_START_DT in DATE,
56   X_HIST_START_DT in DATE,
57   X_HIST_END_DT in DATE,
58   X_HIST_WHO in NUMBER,
59   X_OU_END_DT in DATE,
60   X_DESCRIPTION in VARCHAR2,
61   X_ORG_STATUS in VARCHAR2,
62   X_ORG_TYPE in VARCHAR2,
63   X_MEMBER_TYPE in VARCHAR2,
64   X_INSTITUTION_CD in VARCHAR2,
65   X_NAME in VARCHAR2,
66   X_MODE in VARCHAR2 default 'R',
67   X_ORG_ID in NUMBER
68   );
69 procedure DELETE_ROW (
70   X_ROWID in VARCHAR2
71   );
72 
73   FUNCTION Get_PK_For_Validation (
74     x_org_unit_cd IN VARCHAR2,
75     x_ou_start_dt IN DATE,
76     x_hist_start_dt IN DATE
77     )RETURN BOOLEAN;
78 
79 procedure Check_Constraints (
80   Column_Name in VARCHAR2 DEFAULT NULL ,
81   Column_Value in VARCHAR2 DEFAULT NULL
82   ) ;
83 
84   PROCEDURE Before_DML (
85     p_action IN VARCHAR2,
86     x_rowid IN VARCHAR2 DEFAULT NULL,
87     x_org_unit_cd IN VARCHAR2 DEFAULT NULL,
88     x_ou_start_dt IN DATE DEFAULT NULL,
89     x_hist_start_dt IN DATE DEFAULT NULL,
90     x_hist_end_dt IN DATE DEFAULT NULL,
91     x_hist_who IN VARCHAR2 DEFAULT NULL,
92     x_ou_end_dt IN DATE DEFAULT NULL,
93     x_description IN VARCHAR2 DEFAULT NULL,
94     x_org_status IN VARCHAR2 DEFAULT NULL,
95     x_org_type IN VARCHAR2 DEFAULT NULL,
96     x_member_type IN VARCHAR2 DEFAULT NULL,
97     x_institution_cd IN VARCHAR2 DEFAULT NULL,
98     x_name IN VARCHAR2 DEFAULT NULL,
99     x_creation_date IN DATE DEFAULT NULL,
100     x_created_by IN NUMBER DEFAULT NULL,
101     x_last_update_date IN DATE DEFAULT NULL,
102     x_last_updated_by IN NUMBER DEFAULT NULL,
103     x_last_update_login IN NUMBER DEFAULT NULL,
104     X_ORG_ID in NUMBER DEFAULT NULL
105   ) ;
106 
107 end IGS_OR_UNIT_HIST_PKG;