PACKAGE: APPS.IGS_PS_UNIT_OFR_PAT_PKG

Source

1 package  IGS_PS_UNIT_OFR_PAT_PKG as
2 /* $Header: IGSPI87S.pls 120.2 2005/06/29 06:28:56 appldev ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_UNIT_CD in VARCHAR2,
7   X_VERSION_NUMBER in NUMBER,
8   X_CI_SEQUENCE_NUMBER in NUMBER,
9   X_CAL_TYPE in VARCHAR2,
10   X_CI_START_DT in DATE,
11   X_CI_END_DT in DATE,
12   X_WAITLIST_ALLOWED in VARCHAR2,
13   X_MAX_STUDENTS_PER_WAITLIST  in NUMBER,
14   X_MODE in VARCHAR2 default 'R',
15   X_ORG_ID in NUMBER,
16   X_DELETE_FLAG IN VARCHAR2 DEFAULT NULL,
17   x_abort_flag  IN VARCHAR2 DEFAULT 'N'
18   );
19 
20 procedure LOCK_ROW (
21   X_ROWID in VARCHAR2,
22   X_UNIT_CD in VARCHAR2,
23   X_VERSION_NUMBER in NUMBER,
24   X_CI_SEQUENCE_NUMBER in NUMBER,
25   X_CAL_TYPE in VARCHAR2,
26   X_CI_START_DT in DATE,
27   X_CI_END_DT in DATE,
28   X_WAITLIST_ALLOWED in VARCHAR2,
29   X_MAX_STUDENTS_PER_WAITLIST  in NUMBER,
30   X_DELETE_FLAG IN VARCHAR2 DEFAULT NULL,
31   x_abort_flag  IN VARCHAR2 DEFAULT 'N'
32 );
33 
34 procedure UPDATE_ROW (
35   X_ROWID in VARCHAR2,
36   X_UNIT_CD in VARCHAR2,
37   X_VERSION_NUMBER in NUMBER,
38   X_CI_SEQUENCE_NUMBER in NUMBER,
39   X_CAL_TYPE in VARCHAR2,
40   X_CI_START_DT in DATE,
41   X_CI_END_DT in DATE,
42   X_WAITLIST_ALLOWED in VARCHAR2,
43   X_MAX_STUDENTS_PER_WAITLIST  in NUMBER,
44   X_MODE in VARCHAR2 default 'R',
45   X_DELETE_FLAG IN VARCHAR2 DEFAULT NULL,
46   x_abort_flag  IN VARCHAR2  DEFAULT 'N'
47   );
48 
49 procedure ADD_ROW (
50   X_ROWID in out NOCOPY VARCHAR2,
51   X_UNIT_CD in VARCHAR2,
52   X_VERSION_NUMBER in NUMBER,
53   X_CI_SEQUENCE_NUMBER in NUMBER,
54   X_CAL_TYPE in VARCHAR2,
55   X_CI_START_DT in DATE,
56   X_CI_END_DT in DATE,
57   X_WAITLIST_ALLOWED in VARCHAR2,
58   X_MAX_STUDENTS_PER_WAITLIST  in NUMBER,
59   X_MODE in VARCHAR2 default 'R',
60   X_ORG_ID in NUMBER,
61   X_DELETE_FLAG IN VARCHAR2 DEFAULT NULL,
62   x_abort_flag  IN VARCHAR2 DEFAULT 'N'
63   );
64 
65 procedure DELETE_ROW (
66   X_ROWID in VARCHAR2
67 );
68 
69   FUNCTION Get_PK_For_Validation (
70     x_unit_cd IN VARCHAR2,
71     x_version_number IN NUMBER,
72     x_cal_type IN VARCHAR2,
73     x_ci_sequence_number IN NUMBER
74     )RETURN BOOLEAN;
75 
76   PROCEDURE GET_UFK_IGS_CA_INST (
77     x_cal_type IN VARCHAR2,
78     x_sequence_number IN NUMBER,
79     x_start_dt IN DATE,
80     x_end_dt IN DATE
81     );
82 
83   PROCEDURE GET_FK_IGS_PS_UNIT_OFR (
84     x_unit_cd IN VARCHAR2,
85     x_version_number IN NUMBER,
86     x_cal_type IN VARCHAR2
87     );
88 
89 PROCEDURE Check_Constraints(
90    Column_Name IN VARCHAR2 DEFAULT NULL,
91    Column_Value IN VARCHAR2 DEFAULT NULL
92    );
93 
94 
95   PROCEDURE Before_DML (
96     p_action IN VARCHAR2,
97     x_rowid IN VARCHAR2 DEFAULT NULL,
98     x_unit_cd IN VARCHAR2 DEFAULT NULL,
99     x_version_number IN NUMBER DEFAULT NULL,
100     x_cal_type IN VARCHAR2 DEFAULT NULL,
101     x_ci_sequence_number IN NUMBER DEFAULT NULL,
102     x_ci_start_dt IN DATE DEFAULT NULL,
103     x_ci_end_dt IN DATE DEFAULT NULL,
104     x_waitlist_allowed in VARCHAR2 DEFAULT NULL,
105     x_max_students_per_waitlist in NUMBER DEFAULT NULL,
106     x_creation_date IN DATE DEFAULT NULL,
107     x_created_by IN NUMBER DEFAULT NULL,
108     x_last_update_date IN DATE DEFAULT NULL,
109     x_last_updated_by IN NUMBER DEFAULT NULL,
110     x_last_update_login IN NUMBER DEFAULT NULL,
111     X_ORG_ID IN NUMBER DEFAULT NULL,
112     X_DELETE_FLAG IN VARCHAR2 DEFAULT NULL,
113     x_abort_flag  IN VARCHAR2 DEFAULT 'N'
114   );
115 
116 
117 end IGS_PS_UNIT_OFR_PAT_PKG;