[Home] [Help]
PACKAGE: APPS.PAY_WC_STATE_SURCHARGES_PKG
Source
1 PACKAGE PAY_WC_STATE_SURCHARGES_PKG AUTHID CURRENT_USER as
2 /* $Header: pywss01t.pkh 115.0 99/07/17 06:50:55 porting ship $ */
3
4
5 PROCEDURE Insert_Row(X_Rowid IN OUT VARCHAR2,
6 X_Surcharge_Id IN OUT NUMBER,
7 X_State_Code VARCHAR2,
8 X_Add_To_Rt VARCHAR2,
9 X_Name VARCHAR2,
10 X_Position VARCHAR2,
11 X_Rate NUMBER
12 );
13
14 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
15 X_Surcharge_Id NUMBER,
16 X_State_Code VARCHAR2,
17 X_Add_To_Rt VARCHAR2,
18 X_Name VARCHAR2,
19 X_Position VARCHAR2,
20 X_Rate NUMBER
21 );
22
23
24
25 PROCEDURE Update_Row(X_Rowid VARCHAR2,
26 X_Surcharge_Id NUMBER,
27 X_State_Code VARCHAR2,
28 X_Add_To_Rt VARCHAR2,
29 X_Name VARCHAR2,
30 X_Position VARCHAR2,
31 X_Rate NUMBER
32 );
33 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
34
35 PROCEDURE check_unique (p_surcharge_id NUMBER,
36 p_state_code VARCHAR2,
37 p_name VARCHAR2,
38 p_position VARCHAR2 );
39
40 PROCEDURE check_position ( p_state_code VARCHAR2,
41 p_position VARCHAR2,
42 p_event VARCHAR2 );
43
44 END PAY_WC_STATE_SURCHARGES_PKG;