PACKAGE: APPS.IGS_EN_UNITSETFEETRG_PKG

Source

1 package IGS_EN_UNITSETFEETRG_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSEI11S.pls 115.4 2003/02/12 10:21:32 shtatiko ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_FEE_CAT in VARCHAR2,
7   X_FEE_CAL_TYPE in VARCHAR2,
8   X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
9   X_FEE_TYPE in VARCHAR2,
10   X_UNIT_SET_CD in VARCHAR2,
11   X_VERSION_NUMBER in NUMBER,
12   X_CREATE_DT in out NOCOPY DATE,
13   X_FEE_TRIGGER_GROUP_NUMBER in NUMBER,
14   X_LOGICAL_DELETE_DT in DATE,
15   X_MODE in VARCHAR2 default 'R'
16   );
17 procedure LOCK_ROW (
18   X_ROWID in VARCHAR2,
19   X_FEE_CAT in VARCHAR2,
20   X_FEE_CAL_TYPE in VARCHAR2,
21   X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
22   X_FEE_TYPE in VARCHAR2,
23   X_UNIT_SET_CD in VARCHAR2,
24   X_VERSION_NUMBER in NUMBER,
25   X_CREATE_DT in DATE,
26   X_FEE_TRIGGER_GROUP_NUMBER in NUMBER,
27   X_LOGICAL_DELETE_DT in DATE
28 );
29 procedure UPDATE_ROW (
30   X_ROWID in VARCHAR2,
31   X_FEE_CAT in VARCHAR2,
32   X_FEE_CAL_TYPE in VARCHAR2,
33   X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
34   X_FEE_TYPE in VARCHAR2,
35   X_UNIT_SET_CD in VARCHAR2,
36   X_VERSION_NUMBER in NUMBER,
37   X_CREATE_DT in DATE,
38   X_FEE_TRIGGER_GROUP_NUMBER in NUMBER,
39   X_LOGICAL_DELETE_DT in DATE,
40   X_MODE in VARCHAR2 default 'R'
41   );
42 procedure ADD_ROW (
43   X_ROWID in out NOCOPY VARCHAR2,
44   X_FEE_CAT in VARCHAR2,
45   X_FEE_CAL_TYPE in VARCHAR2,
46   X_FEE_CI_SEQUENCE_NUMBER in NUMBER,
47   X_FEE_TYPE in VARCHAR2,
48   X_UNIT_SET_CD in VARCHAR2,
49   X_VERSION_NUMBER in NUMBER,
50   X_CREATE_DT in out NOCOPY DATE,
51   X_FEE_TRIGGER_GROUP_NUMBER in NUMBER,
52   X_LOGICAL_DELETE_DT in DATE,
53   X_MODE in VARCHAR2 default 'R'
54   );
55 procedure DELETE_ROW (
56     X_ROWID in VARCHAR2
57 );
58 
59 FUNCTION Get_PK_For_Validation (
60     x_fee_cat IN VARCHAR2,
61     x_fee_cal_type IN VARCHAR2,
62     x_fee_ci_sequence_number IN NUMBER,
63     x_fee_type IN VARCHAR2,
64     x_unit_set_cd IN VARCHAR2,
65     x_version_number IN NUMBER,
66     x_create_dt IN DATE
67     ) RETURN BOOLEAN;
68 
69 PROCEDURE GET_FK_IGS_FI_FEE_TRG_GRP (
70     x_fee_cat IN VARCHAR2,
71     x_fee_cal_type IN VARCHAR2,
72     x_fee_ci_sequence_number IN NUMBER,
73     x_fee_type IN VARCHAR2,
74     x_fee_trigger_group_number IN NUMBER
75     );
76 PROCEDURE GET_FK_IGS_EN_UNIT_SET (
77     x_unit_set_cd IN VARCHAR2,
78     x_version_number IN NUMBER
79     );
80 
81 PROCEDURE Before_DML (
82     p_action IN VARCHAR2,
83     x_rowid IN VARCHAR2 DEFAULT NULL,
84     x_fee_cat IN VARCHAR2 DEFAULT NULL,
85     x_fee_cal_type IN VARCHAR2 DEFAULT NULL,
86     x_fee_ci_sequence_number IN NUMBER DEFAULT NULL,
87     x_fee_type IN VARCHAR2 DEFAULT NULL,
88     x_unit_set_cd IN VARCHAR2 DEFAULT NULL,
89     x_version_number IN NUMBER DEFAULT NULL,
90     x_create_dt IN DATE DEFAULT NULL,
91     x_fee_trigger_group_number IN NUMBER DEFAULT NULL,
92     x_logical_delete_dt IN DATE DEFAULT NULL,
93     x_creation_date IN DATE DEFAULT NULL,
94     x_created_by IN NUMBER DEFAULT NULL,
95     x_last_update_date IN DATE DEFAULT NULL,
96     x_last_updated_by IN NUMBER DEFAULT NULL,
97     x_last_update_login IN NUMBER DEFAULT NULL
98   );
99 
100  PROCEDURE Check_Constraints (
101  	Column_Name	IN	VARCHAR2	DEFAULT NULL,
102  	Column_Value 	IN	VARCHAR2	DEFAULT NULL
103  );
104 
105 end IGS_EN_UNITSETFEETRG_PKG;