DBA Data[Home] [Help]

PACKAGE: APPS.IGS_CA_DA_INST_OFST_PKG

Source


1 package  IGS_CA_DA_INST_OFST_PKG AS
2 /* $Header: IGSCI06S.pls 120.0 2005/06/01 14:28:30 appldev noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_DT_ALIAS in VARCHAR2,
6   X_DAI_SEQUENCE_NUMBER in NUMBER,
7   X_CAL_TYPE in VARCHAR2,
8   X_CI_SEQUENCE_NUMBER in NUMBER,
9   X_OFFSET_DT_ALIAS in VARCHAR2,
10   X_OFFSET_DAI_SEQUENCE_NUMBER in NUMBER,
11   X_OFFSET_CAL_TYPE in VARCHAR2,
12   X_OFFSET_CI_SEQUENCE_NUMBER in NUMBER,
13   X_DAY_OFFSET in NUMBER,
14   X_WEEK_OFFSET in NUMBER,
15   X_MONTH_OFFSET in NUMBER,
16   X_YEAR_OFFSET in NUMBER,
17   X_OFST_OVERRIDE in VARCHAR2,
18   X_MODE in VARCHAR2 default 'R'
19   );
20 procedure LOCK_ROW (
21   X_ROWID in VARCHAR2,
22   X_DT_ALIAS in VARCHAR2,
23   X_DAI_SEQUENCE_NUMBER in NUMBER,
24   X_CAL_TYPE in VARCHAR2,
25   X_CI_SEQUENCE_NUMBER in NUMBER,
26   X_OFFSET_DT_ALIAS in VARCHAR2,
27   X_OFFSET_DAI_SEQUENCE_NUMBER in NUMBER,
28   X_OFFSET_CAL_TYPE in VARCHAR2,
29   X_OFFSET_CI_SEQUENCE_NUMBER in NUMBER,
30   X_DAY_OFFSET in NUMBER,
31   X_WEEK_OFFSET in NUMBER,
32   X_MONTH_OFFSET in NUMBER,
33   X_YEAR_OFFSET in NUMBER,
34   X_OFST_OVERRIDE in VARCHAR2
35 );
36 procedure UPDATE_ROW (
37   X_ROWID in VARCHAR2,
38   X_DT_ALIAS in VARCHAR2,
39   X_DAI_SEQUENCE_NUMBER in NUMBER,
40   X_CAL_TYPE in VARCHAR2,
41   X_CI_SEQUENCE_NUMBER in NUMBER,
42   X_OFFSET_DT_ALIAS in VARCHAR2,
43   X_OFFSET_DAI_SEQUENCE_NUMBER in NUMBER,
44   X_OFFSET_CAL_TYPE in VARCHAR2,
45   X_OFFSET_CI_SEQUENCE_NUMBER in NUMBER,
46   X_DAY_OFFSET in NUMBER,
47   X_WEEK_OFFSET in NUMBER,
48   X_MONTH_OFFSET in NUMBER,
49   X_YEAR_OFFSET in NUMBER,
50   X_OFST_OVERRIDE in VARCHAR2,
51   X_MODE in VARCHAR2 default 'R'
52   );
53 procedure ADD_ROW (
54   X_ROWID in out NOCOPY VARCHAR2,
55   X_DT_ALIAS in VARCHAR2,
56   X_DAI_SEQUENCE_NUMBER in NUMBER,
57   X_CAL_TYPE in VARCHAR2,
58   X_CI_SEQUENCE_NUMBER in NUMBER,
59   X_OFFSET_DT_ALIAS in VARCHAR2,
60   X_OFFSET_DAI_SEQUENCE_NUMBER in NUMBER,
61   X_OFFSET_CAL_TYPE in VARCHAR2,
62   X_OFFSET_CI_SEQUENCE_NUMBER in NUMBER,
63   X_DAY_OFFSET in NUMBER,
64   X_WEEK_OFFSET in NUMBER,
65   X_MONTH_OFFSET in NUMBER,
66   X_YEAR_OFFSET in NUMBER,
67   X_OFST_OVERRIDE in VARCHAR2,
68   X_MODE in VARCHAR2 default 'R'
69   );
70 procedure DELETE_ROW (
71   X_ROWID in VARCHAR2
72 );
73   FUNCTION Get_PK_For_Validation (
74     x_dt_alias IN VARCHAR2,
75     x_dai_sequence_number IN NUMBER,
76     x_cal_type IN VARCHAR2,
77     x_ci_sequence_number IN NUMBER,
78     x_offset_dt_alias IN VARCHAR2,
79     x_offset_dai_sequence_number IN NUMBER,
80     x_offset_cal_type IN VARCHAR2,
81     x_offset_ci_sequence_number IN NUMBER
82     )RETURN BOOLEAN;
83 
84   PROCEDURE Check_Constraints (
85 	Column_Name	      IN	VARCHAR2	DEFAULT NULL,
86 	Column_Value 	IN	VARCHAR2	DEFAULT NULL
87 	);
88 
89   PROCEDURE Before_DML (
90     p_action IN VARCHAR2,
91     x_rowid IN VARCHAR2 DEFAULT NULL,
92     x_offset_ci_sequence_number IN NUMBER DEFAULT NULL,
93     x_day_offset IN NUMBER DEFAULT NULL,
94     x_week_offset IN NUMBER DEFAULT NULL,
95     x_month_offset IN NUMBER DEFAULT NULL,
96     x_year_offset IN NUMBER DEFAULT NULL,
97     x_ofst_override IN VARCHAR2 DEFAULT NULL,
98     x_dt_alias IN VARCHAR2 DEFAULT NULL,
99     x_dai_sequence_number IN NUMBER DEFAULT NULL,
100     x_cal_type IN VARCHAR2 DEFAULT NULL,
101     x_ci_sequence_number IN NUMBER DEFAULT NULL,
102     x_offset_dt_alias IN VARCHAR2 DEFAULT NULL,
103     x_offset_dai_sequence_number IN NUMBER DEFAULT NULL,
104     x_offset_cal_type IN VARCHAR2 DEFAULT NULL,
105     x_creation_date IN DATE DEFAULT NULL,
106     x_created_by IN NUMBER DEFAULT NULL,
107     x_last_update_date IN DATE DEFAULT NULL,
108     x_last_updated_by IN NUMBER DEFAULT NULL,
109     x_last_update_login IN NUMBER DEFAULT NULL
110   ) ;
111 
112   PROCEDURE GET_FK_IGS_CA_DA_INST (
113     x_dt_alias IN VARCHAR2,
114     x_sequence_number IN NUMBER,
115     x_cal_type IN VARCHAR2,
116     x_ci_sequence_number IN NUMBER
117     );
118 end IGS_CA_DA_INST_OFST_PKG;