6: /* ----------------------------------------------------------------------- */
7:
8: -- API name : Apply_Element_Parameters
9: -- Type : Private
10: -- Pre-reqs : FND_API, FND_MESSAGE
11: -- .
12: -- Version : Current version 1.0
13: -- Initial version 1.0
14: -- Created 12/09/1997 by Supriyo Ghosh
17: --
18:
19: PROCEDURE Apply_Element_Parameters
20: ( p_api_version IN NUMBER,
21: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
22: p_return_status OUT NOCOPY VARCHAR2,
23: p_worksheet_id IN NUMBER,
24: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
20: ( p_api_version IN NUMBER,
21: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
22: p_return_status OUT NOCOPY VARCHAR2,
23: p_worksheet_id IN NUMBER,
24: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
26: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
27: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
28: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
21: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
22: p_return_status OUT NOCOPY VARCHAR2,
23: p_worksheet_id IN NUMBER,
24: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
26: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
27: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
28: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
22: p_return_status OUT NOCOPY VARCHAR2,
23: p_worksheet_id IN NUMBER,
24: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
26: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
27: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
28: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
23: p_worksheet_id IN NUMBER,
24: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
26: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
27: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
28: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
31: );
24: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
25: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
26: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
27: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
28: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
31: );
32:
25: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
26: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
27: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
28: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
31: );
32:
33: /* ----------------------------------------------------------------------- */
26: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
27: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
28: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
30: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
31: );
32:
33: /* ----------------------------------------------------------------------- */
34:
33: /* ----------------------------------------------------------------------- */
34:
35: -- API name : Apply_Position_Parameters
36: -- Type : Private
37: -- Pre-reqs : FND_API, FND_MESSAGE
38: -- .
39: -- Version : Current version 1.0
40: -- Initial version 1.0
41: -- Created 12/09/1997 by Supriyo Ghosh
44: --
45:
46: PROCEDURE Apply_Position_Parameters
47: ( p_api_version IN NUMBER,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
49: p_return_status OUT NOCOPY VARCHAR2,
50: p_worksheet_id IN NUMBER,
51: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
47: ( p_api_version IN NUMBER,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
49: p_return_status OUT NOCOPY VARCHAR2,
50: p_worksheet_id IN NUMBER,
51: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
54: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
49: p_return_status OUT NOCOPY VARCHAR2,
50: p_worksheet_id IN NUMBER,
51: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
54: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
49: p_return_status OUT NOCOPY VARCHAR2,
50: p_worksheet_id IN NUMBER,
51: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
54: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
57: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
50: p_worksheet_id IN NUMBER,
51: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
54: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
57: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
58: );
51: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
52: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
54: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
57: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
58: );
59:
52: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
53: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
54: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
57: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
58: );
59:
60: /* ----------------------------------------------------------------------- */
53: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
54: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
55: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
56: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
57: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
58: );
59:
60: /* ----------------------------------------------------------------------- */
61:
60: /* ----------------------------------------------------------------------- */
61:
62: -- API name : Redistribute_Follow_Salary
63: -- Type : Private
64: -- Pre-reqs : FND_API, FND_MESSAGE
65: -- .
66: -- Version : Current version 1.0
67: -- Initial version 1.0
68: -- Created 12/09/1997 by Supriyo Ghosh
71: --
72:
73: PROCEDURE Redistribute_Follow_Salary
74: ( p_api_version IN NUMBER,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
76: p_return_status OUT NOCOPY VARCHAR2,
77: p_worksheet_id IN NUMBER,
78: p_position_line_id IN NUMBER,
79: p_budget_year_id IN NUMBER := FND_API.G_MISS_NUM,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
76: p_return_status OUT NOCOPY VARCHAR2,
77: p_worksheet_id IN NUMBER,
78: p_position_line_id IN NUMBER,
79: p_budget_year_id IN NUMBER := FND_API.G_MISS_NUM,
80: p_service_package_id IN NUMBER,
81: p_stage_set_id IN NUMBER,
82: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR
83: );
78: p_position_line_id IN NUMBER,
79: p_budget_year_id IN NUMBER := FND_API.G_MISS_NUM,
80: p_service_package_id IN NUMBER,
81: p_stage_set_id IN NUMBER,
82: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR
83: );
84:
85: /* ----------------------------------------------------------------------- */
86:
108: /* ----------------------------------------------------------------------- */
109:
110: -- API name : Apply_Position_Constraints
111: -- Type : Private
112: -- Pre-reqs : FND_API, FND_MESSAGE
113: -- .
114: -- Version : Current version 1.0
115: -- Initial version 1.0
116: -- Created 12/09/1997 by Supriyo Ghosh
176: p_business_group_id IN NUMBER,
177: p_parameter_id IN NUMBER,
178: p_parameter_start_date IN DATE,
179: p_compound_annually IN VARCHAR2,
180: p_compound_factor IN NUMBER := FND_API.G_MISS_NUM,
181: p_parameter_autoinc_rule IN VARCHAR2,
182: p_currency_code IN VARCHAR2,
183: p_start_date IN DATE,
184: p_end_date IN DATE,
223: /* ----------------------------------------------------------------------- */
224:
225: -- API name : Revise_Position_Projections
226: -- Type : Private
227: -- Pre-reqs : FND_API, FND_MESSAGE
228: -- .
229: -- Version : Current version 1.0
230: -- Initial version 1.0
231: -- Created 04/10/2000 by Supriyo Ghosh
234: --
235:
236: PROCEDURE Revise_Position_Projections
237: ( p_api_version IN NUMBER,
238: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
239: p_return_status OUT NOCOPY VARCHAR2,
240: --Bug No 3315330 Start
241: x_msg_data OUT NOCOPY VARCHAR2,
242: x_msg_count OUT NOCOPY NUMBER,
249: /* Bug No 2482305 Start */
250:
251: PROCEDURE Revise_Element_Projections
252: ( p_api_version IN NUMBER,
253: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
254: p_return_status OUT NOCOPY VARCHAR2,
255: p_worksheet_id IN NUMBER,
256: p_parameter_id IN NUMBER,
257: p_recalculate_flag IN BOOLEAN := TRUE