1 PACKAGE PSB_WS_LINE_YEAR_I_PVT AS
2 /* $Header: PSBWLYIS.pls 120.3 2005/09/23 07:18:38 shtripat ship $ */
3
4
5
6
7 -- Bug#4571412.
8 -- Added p_year_name_C1..12 parameters to
9 -- pass Budget Year name to Create_Notes API.
10
11 PROCEDURE Insert_Row
12 (
13 p_api_version IN NUMBER,
14 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15 p_commit IN VARCHAR2 := FND_API.G_FALSE,
16 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17 p_return_status OUT NOCOPY VARCHAR2,
18 p_msg_count OUT NOCOPY NUMBER,
19 p_msg_data OUT NOCOPY VARCHAR2,
20 --
21 p_worksheet_id IN NUMBER,
22 p_position_line_id IN NUMBER,
23 p_element_set_id IN NUMBER,
24 p_salary_account_line IN VARCHAR2,
25 p_budget_group_id IN NUMBER,
26 p_service_package_id IN NUMBER,
27 p_flex_code IN NUMBER,
28 p_concatenated_segments IN VARCHAR2,
29 p_currency_code IN VARCHAR2,
30 --
31 p_note IN VARCHAR2 DEFAULT NULL,
32 p_column_count IN NUMBER,
33 --
34 p_year_id_C1 IN NUMBER,
35 p_year_name_C1 IN VARCHAR2,
36 p_ytd_amount_C1 IN NUMBER,
37 p_year_id_C2 IN NUMBER,
38 p_year_name_C2 IN VARCHAR2,
39 p_ytd_amount_C2 IN NUMBER,
40 p_year_id_C3 IN NUMBER,
41 p_year_name_C3 IN VARCHAR2,
42 p_ytd_amount_C3 IN NUMBER,
43 p_year_id_C4 IN NUMBER,
44 p_year_name_C4 IN VARCHAR2,
45 p_ytd_amount_C4 IN NUMBER,
46 p_year_id_C5 IN NUMBER,
47 p_year_name_C5 IN VARCHAR2,
48 p_ytd_amount_C5 IN NUMBER,
49 p_year_id_C6 IN NUMBER,
50 p_year_name_C6 IN VARCHAR2,
51 p_ytd_amount_C6 IN NUMBER,
52 p_year_id_C7 IN NUMBER,
53 p_year_name_C7 IN VARCHAR2,
54 p_ytd_amount_C7 IN NUMBER,
55 p_year_id_C8 IN NUMBER,
56 p_year_name_C8 IN VARCHAR2,
57 p_ytd_amount_C8 IN NUMBER,
58 p_year_id_C9 IN NUMBER,
59 p_year_name_C9 IN VARCHAR2,
60 p_ytd_amount_C9 IN NUMBER,
61 p_year_id_C10 IN NUMBER,
62 p_year_name_C10 IN VARCHAR2,
63 p_ytd_amount_C10 IN NUMBER,
64 p_year_id_C11 IN NUMBER,
65 p_year_name_C11 IN VARCHAR2,
66 p_ytd_amount_C11 IN NUMBER,
67 p_year_id_C12 IN NUMBER,
68 p_year_name_C12 IN VARCHAR2,
69 p_ytd_amount_C12 IN NUMBER
70 );
71
72
73 END PSB_WS_LINE_YEAR_I_PVT;