[Home] [Help]
PACKAGE: APPS.HRWCDCR_PKG
Source
1 PACKAGE HRWCDCR_PKG AUTHID CURRENT_USER AS
2 /* $Header: pywcdcr.pkh 115.0 99/07/17 06:50:06 porting ship $ */
3 --
4 --
5 --
6 --
7 PROCEDURE INSERT_ROW( X_ROWID IN OUT VARCHAR2,
8 X_FUND_ID IN OUT NUMBER,
9 X_BUSINESS_GROUP_ID NUMBER,
10 X_CARRIER_ID NUMBER,
11 X_LOCATION_ID NUMBER,
12 X_STATE_CODE VARCHAR2,
13 X_CALCULATION_METHOD VARCHAR2,
14 X_CALCULATION_METHOD2 VARCHAR2,
15 X_CALCULATION_METHOD3 VARCHAR2);
16 --
17 PROCEDURE UPDATE_ROW( X_ROWID VARCHAR2,
18 X_FUND_ID NUMBER,
19 X_BUSINESS_GROUP_ID NUMBER,
20 X_CARRIER_ID NUMBER,
21 X_LOCATION_ID NUMBER,
22 X_STATE_CODE VARCHAR2,
23 X_CALCULATION_METHOD VARCHAR2,
24 X_CALCULATION_METHOD2 VARCHAR2,
25 X_CALCULATION_METHOD3 VARCHAR2);
26 --
27 PROCEDURE DELETE_ROW( X_ROWID VARCHAR2,
28 X_FUND_ID NUMBER,
29 X_BUSINESS_GROUP_ID NUMBER,
30 X_CARRIER_ID NUMBER,
31 X_LOCATION_ID NUMBER,
32 X_STATE_CODE VARCHAR2,
33 X_CALCULATION_METHOD VARCHAR2,
34 X_CALCULATION_METHOD2 VARCHAR2,
35 X_CALCULATION_METHOD3 VARCHAR2);
36 --
37 PROCEDURE LOCK_ROW( X_ROWID VARCHAR2,
38 X_FUND_ID NUMBER,
39 X_BUSINESS_GROUP_ID NUMBER,
40 X_CARRIER_ID NUMBER,
41 X_LOCATION_ID NUMBER,
42 X_STATE_CODE VARCHAR2,
43 X_CALCULATION_METHOD VARCHAR2,
44 X_CALCULATION_METHOD2 VARCHAR2,
45 X_CALCULATION_METHOD3 VARCHAR2);
46 --
47 PROCEDURE CARRIER_STATE_LOC_UNIQUE( P_ROWID VARCHAR2,
48 P_CARRIER_ID NUMBER,
49 P_STATE_CODE VARCHAR2,
50 P_LOCATION_ID NUMBER);
51 --
52 PROCEDURE FUND_WC_CODE_UNIQUE( P_ROWID VARCHAR2,
53 P_FUND_ID NUMBER,
54 P_WC_CODE NUMBER);
55 --
56 PROCEDURE CODES_AND_RATES_EXIST( P_FUND_ID NUMBER);
57 --
58 PROCEDURE CODE_IN_USE ( P_FUND_ID NUMBER,
59 P_STATE_CODE VARCHAR2,
60 P_ROWID VARCHAR2,
61 P_WC_CODE NUMBER,
62 P_BUSINESS_GROUP_ID NUMBER,
63 P_CARRIER_ID NUMBER,
64 P_LOCATION_ID NUMBER);
65 --
66 --
67 END HRWCDCR_PKG;