1 PACKAGE PSB_WS_POS2 AS
2 /* $Header: PSBVWP2S.pls 120.3 2005/10/05 18:28:35 matthoma ship $ */
3
4 /* ----------------------------------------------------------------------- */
5
6 -- API name : Create_Worksheet_Positions
7 -- Type : Private <Implementation>
8 -- Pre-reqs : FND_API, FND_MESSAGE
9 -- .
10 -- Version : Current version 1.0
11 -- Initial version 1.0
12 -- Created 12/09/1997 by Supriyo Ghosh
13 --
14 -- Notes : Create Worksheet Positions
15 --
16
17 PROCEDURE Create_Worksheet_Positions
18 ( p_return_status OUT NOCOPY VARCHAR2,
19 p_root_budget_group_id IN NUMBER,
20 p_global_worksheet_id IN NUMBER,
21 p_worksheet_id IN NUMBER,
22 p_global_worksheet IN VARCHAR2,
23 p_budget_group_id IN NUMBER,
24 p_worksheet_numyrs IN NUMBER,
25 p_rounding_factor IN NUMBER,
26 p_service_package_id IN NUMBER,
27 p_stage_set_id IN NUMBER,
28 p_start_stage_seq IN NUMBER,
29 p_current_stage_seq IN NUMBER,
30 p_data_extract_id IN NUMBER,
31 p_business_group_id IN NUMBER,
32 p_budget_calendar_id IN NUMBER,
33 p_parameter_set_id IN NUMBER,
34 p_func_currency IN VARCHAR2,
35 p_flex_mapping_set_id IN NUMBER,
36 p_flex_code IN NUMBER,
37 p_apply_element_parameters IN VARCHAR2,
38 p_apply_position_parameters IN VARCHAR2
39 );
40
41 /* ----------------------------------------------------------------------- */
42
43 -- API name : Calculate_Position_Cost
44 -- Type : Private <Implementation>
45 -- Pre-reqs : FND_API, FND_MESSAGE
46 -- .
47 -- Version : Current version 1.0
48 -- Initial version 1.0
49 -- Created 12/09/1997 by Supriyo Ghosh
50 --
51 -- Notes : Calculate Position Cost
52 --
53
54 PROCEDURE Calculate_Position_Cost
55 ( p_api_version IN NUMBER,
56 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
57 p_return_status OUT NOCOPY VARCHAR2,
58 p_worksheet_id IN NUMBER,
59 p_position_line_id IN NUMBER,
60 p_recalculate_flag IN VARCHAR2 := FND_API.G_TRUE,
61 p_root_budget_group_id IN NUMBER default null,
62 p_global_worksheet_id IN NUMBER default null,
63 p_assign_worksheet_id IN NUMBER default null,
64 p_worksheet_numyrs IN NUMBER default null,
65 p_rounding_factor IN NUMBER default null,
66 p_service_package_id IN NUMBER default null,
67 p_stage_set_id IN NUMBER default null,
68 p_start_stage_seq IN NUMBER default null,
69 p_current_stage_seq IN NUMBER default null,
70 p_data_extract_id IN NUMBER default null,
71 p_business_group_id IN NUMBER default null,
72 p_budget_calendar_id IN NUMBER default null,
73 p_func_currency IN VARCHAR2 default null,
74 p_flex_mapping_set_id IN NUMBER default null,
75 p_flex_code IN NUMBER default null,
76 p_position_id IN NUMBER default null,
77 p_position_name IN VARCHAR2 default null,
78 p_position_start_date IN DATE default null,
79 p_position_end_date IN DATE default null,
80 p_budget_year_id IN NUMBER DEFAULT NULL -- Bug 4379636
81
82 );
83
84 /* ----------------------------------------------------------------------- */
85
86 FUNCTION Get_Attribute_Value
87 ( p_attribute_value_id IN NUMBER
88 ) RETURN NUMBER;
89
90 END PSB_WS_POS2;