1 PACKAGE PSB_WS_LINE_YEAR_L_PVT AS
2 /* $Header: PSBWLYLS.pls 120.2 2005/07/13 11:35:28 shtripat ship $ */
3
4
5 PROCEDURE Lock_Row
6 (
7 p_api_version IN NUMBER,
8 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
9 p_commit IN VARCHAR2 := FND_API.G_FALSE,
10 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11 p_return_status OUT NOCOPY VARCHAR2,
12 p_msg_count OUT NOCOPY NUMBER,
13 p_msg_data OUT NOCOPY VARCHAR2,
14 p_row_locked OUT NOCOPY VARCHAR2,
15 --
16 p_service_package_id IN NUMBER,
17 --
18 p_column_count IN NUMBER,
19 --
20 p_wal_id_C1 IN NUMBER,
21 p_balance_type_C1 IN VARCHAR2,
22 p_ytd_amount_C1 IN NUMBER,
23 p_wal_id_C2 IN NUMBER,
24 p_balance_type_C2 IN VARCHAR2,
25 p_ytd_amount_C2 IN NUMBER,
26 p_wal_id_C3 IN NUMBER,
27 p_balance_type_C3 IN VARCHAR2,
28 p_ytd_amount_C3 IN NUMBER,
29 p_wal_id_C4 IN NUMBER,
30 p_balance_type_C4 IN VARCHAR2,
31 p_ytd_amount_C4 IN NUMBER,
32 p_wal_id_C5 IN NUMBER,
33 p_balance_type_C5 IN VARCHAR2,
34 p_ytd_amount_C5 IN NUMBER,
35 p_wal_id_C6 IN NUMBER,
36 p_balance_type_C6 IN VARCHAR2,
37 p_ytd_amount_C6 IN NUMBER,
38 p_wal_id_C7 IN NUMBER,
39 p_balance_type_C7 IN VARCHAR2,
40 p_ytd_amount_C7 IN NUMBER,
41 p_wal_id_C8 IN NUMBER,
42 p_balance_type_C8 IN VARCHAR2,
43 p_ytd_amount_C8 IN NUMBER,
44 p_wal_id_C9 IN NUMBER,
45 p_balance_type_C9 IN VARCHAR2,
46 p_ytd_amount_C9 IN NUMBER,
47 p_wal_id_C10 IN NUMBER,
48 p_balance_type_C10 IN VARCHAR2,
49 p_ytd_amount_C10 IN NUMBER,
50 p_wal_id_C11 IN NUMBER,
51 p_balance_type_C11 IN VARCHAR2,
52 p_ytd_amount_C11 IN NUMBER,
53 p_wal_id_C12 IN NUMBER,
54 p_balance_type_C12 IN VARCHAR2,
55 p_ytd_amount_C12 IN NUMBER
56
57 );
58
59
60 END PSB_WS_LINE_YEAR_L_PVT;