1 PACKAGE PSB_WS_LINE_YEAR_O_PVT AS
2 /* $Header: PSBWLYOS.pls 120.3 2005/09/23 08:39:56 shtripat ship $ */
3
4 -- Bug#4571412.
5 -- Added p_year_name_C1..12 parameters to
6 -- pass Budget Year name to Create_Notes API.
7
8 PROCEDURE Update_Row
9 (
10 p_api_version IN NUMBER,
11 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
12 p_commit IN VARCHAR2 := FND_API.G_FALSE,
13 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
14 p_return_status OUT NOCOPY VARCHAR2,
15 p_msg_count OUT NOCOPY NUMBER,
16 p_msg_data OUT NOCOPY VARCHAR2,
17 --
18 p_worksheet_id IN NUMBER,
19 p_position_line_id IN NUMBER,
20 p_element_set_id IN NUMBER,
21 p_salary_account_line IN VARCHAR2,
22 p_budget_group_id IN NUMBER,
23 p_service_package_id IN NUMBER,
24 p_flex_code IN NUMBER,
25 p_concatenated_segments IN VARCHAR2,
26 p_currency_code IN VARCHAR2,
27 p_note IN VARCHAR2 DEFAULT NULL,
28 p_sbi_year_option_year_id IN NUMBER DEFAULT NULL,
29 p_column_count IN NUMBER,
30 --
31 p_wal_id_C1 IN NUMBER,
32 p_year_id_C1 IN NUMBER,
33 p_year_name_C1 IN VARCHAR2,
34 p_balance_type_C1 IN VARCHAR2,
35 p_ytd_amount_C1 IN NUMBER,
36 p_wal_id_C2 IN NUMBER,
37 p_year_id_C2 IN NUMBER,
38 p_year_name_C2 IN VARCHAR2,
39 p_balance_type_C2 IN VARCHAR2,
40 p_ytd_amount_C2 IN NUMBER,
41 p_wal_id_C3 IN NUMBER,
42 p_year_id_C3 IN NUMBER,
43 p_year_name_C3 IN VARCHAR2,
44 p_balance_type_C3 IN VARCHAR2,
45 p_ytd_amount_C3 IN NUMBER,
46 p_wal_id_C4 IN NUMBER,
47 p_year_id_C4 IN NUMBER,
48 p_year_name_C4 IN VARCHAR2,
49 p_balance_type_C4 IN VARCHAR2,
50 p_ytd_amount_C4 IN NUMBER,
51 p_wal_id_C5 IN NUMBER,
52 p_year_id_C5 IN NUMBER,
53 p_year_name_C5 IN VARCHAR2,
54 p_balance_type_C5 IN VARCHAR2,
55 p_ytd_amount_C5 IN NUMBER,
56 p_wal_id_C6 IN NUMBER,
57 p_year_id_C6 IN NUMBER,
58 p_year_name_C6 IN VARCHAR2,
59 p_balance_type_C6 IN VARCHAR2,
60 p_ytd_amount_C6 IN NUMBER,
61 p_wal_id_C7 IN NUMBER,
62 p_year_id_C7 IN NUMBER,
63 p_year_name_C7 IN VARCHAR2,
64 p_balance_type_C7 IN VARCHAR2,
65 p_ytd_amount_C7 IN NUMBER,
66 p_wal_id_C8 IN NUMBER,
67 p_year_id_C8 IN NUMBER,
68 p_year_name_C8 IN VARCHAR2,
69 p_balance_type_C8 IN VARCHAR2,
70 p_ytd_amount_C8 IN NUMBER,
71 p_wal_id_C9 IN NUMBER,
72 p_year_id_C9 IN NUMBER,
73 p_year_name_C9 IN VARCHAR2,
74 p_balance_type_C9 IN VARCHAR2,
75 p_ytd_amount_C9 IN NUMBER,
76 p_wal_id_C10 IN NUMBER,
77 p_year_id_C10 IN NUMBER,
78 p_year_name_C10 IN VARCHAR2,
79 p_balance_type_C10 IN VARCHAR2,
80 p_ytd_amount_C10 IN NUMBER,
81 p_wal_id_C11 IN NUMBER,
82 p_year_id_C11 IN NUMBER,
83 p_year_name_C11 IN VARCHAR2,
84 p_balance_type_C11 IN VARCHAR2,
85 p_ytd_amount_C11 IN NUMBER,
86 p_wal_id_C12 IN NUMBER,
87 p_year_id_C12 IN NUMBER,
88 p_year_name_C12 IN VARCHAR2,
89 p_balance_type_C12 IN VARCHAR2,
90 p_ytd_amount_C12 IN NUMBER
91 );
92
93 END PSB_WS_LINE_YEAR_O_PVT;