1 PACKAGE PSB_POSITIONS_I_PVT AS
2 /* $Header: PSBWPOIS.pls 120.2 2005/07/13 11:36:39 shtripat ship $ */
3
4 -- View Functions
5
6 PROCEDURE Initialize_View ( p_worksheet_id IN NUMBER,
7 p_start_date IN DATE,
8 p_end_date IN DATE,
9 p_select_date IN DATE := fnd_api.g_miss_date);
10
11 PROCEDURE Define_Worksheet_Values (
12 p_api_version in number,
13 p_init_msg_list in varchar2 := fnd_api.g_false,
14 p_commit in varchar2 := fnd_api.g_false,
15 p_validation_level in number := fnd_api.g_valid_level_full,
16 p_return_status OUT NOCOPY varchar2,
17 p_msg_count OUT NOCOPY number,
18 p_msg_data OUT NOCOPY varchar2,
19 p_worksheet_id in number,
20 p_position_id in number,
21 p_pos_effective_start_date in date := FND_API.G_MISS_DATE,
22 p_pos_effective_end_date in date := FND_API.G_MISS_DATE,
23 p_budget_source in varchar2:= FND_API.G_MISS_CHAR,
24 p_out_worksheet_id OUT NOCOPY number,
25 p_out_start_date OUT NOCOPY date,
26 p_out_end_date OUT NOCOPY date);
27
28 -- modify_assignment used for insert/modify assignments
29
30 PROCEDURE Modify_Assignment (
31 p_api_version in number,
32 p_init_msg_list in varchar2 := fnd_api.g_false,
33 p_commit in varchar2 := fnd_api.g_false,
34 p_validation_level in number := fnd_api.g_valid_level_full,
35 p_return_status OUT NOCOPY varchar2,
36 p_msg_count OUT NOCOPY number,
37 p_msg_data OUT NOCOPY varchar2,
38 p_position_assignment_id in OUT NOCOPY number,
39 p_data_extract_id in number,
40 p_worksheet_id in number,
41 p_position_id in number,
42 p_assignment_type in varchar2,
43 p_attribute_id in number,
44 p_attribute_value_id in number,
45 p_attribute_value in varchar2,
46 p_pay_element_id in number,
47 p_pay_element_option_id in number,
48 p_effective_start_date in date,
49 p_effective_end_date in date,
50 p_element_value_type in varchar2,
51 p_element_value in number,
52 p_currency_code in varchar2,
53 p_pay_basis in varchar2,
54 p_employee_id in number,
55 p_primary_employee_flag in varchar2,
56 p_global_default_flag in varchar2,
57 p_assignment_default_rule_id in number,
58 p_modify_flag in varchar2,
59 p_rowid in OUT NOCOPY varchar2,
60 p_mode in varchar2 default 'R'
61 );
62
63
64 PROCEDURE Create_Default_Assignments(
65 p_api_version in number,
66 p_init_msg_list in varchar2 := FND_API.G_FALSE,
67 p_commit in varchar2 := FND_API.G_FALSE,
68 p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
69 p_return_status OUT NOCOPY varchar2,
70 p_msg_count OUT NOCOPY number,
71 p_msg_data OUT NOCOPY varchar2,
72 p_worksheet_id in number := FND_API.G_MISS_NUM,
73 p_data_extract_id in number,
74 p_position_id in number := FND_API.G_MISS_NUM,
75 p_position_start_date in date := FND_API.G_MISS_DATE,
76 p_position_end_date in date := FND_API.G_MISS_DATE);
77
78 FUNCTION Get_Select_Date RETURN DATE;
79 pragma RESTRICT_REFERENCES ( Get_SELECT_DATE, WNDS, WNPS );
80
81 FUNCTION Check_Allowed
82 ( p_api_version IN NUMBER,
83 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
84 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
85 p_msg_count OUT NOCOPY NUMBER,
86 p_msg_data OUT NOCOPY VARCHAR2,
87 p_worksheet_id IN NUMBER,
88 p_position_budget_group_id IN NUMBER
89 ) RETURN VARCHAR2;
90
91
92 FUNCTION Rev_Check_Allowed
93 ( p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
95 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
96 p_msg_count OUT NOCOPY NUMBER,
97 p_msg_data OUT NOCOPY VARCHAR2,
98 p_startdate_pp IN DATE,
99 p_enddate_cy IN DATE,
100 p_worksheet_id IN NUMBER,
101 p_position_budget_group_id IN NUMBER
102 ) RETURN VARCHAR2;
103
104 PROCEDURE Modify_Distribution_WS
105 ( p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107 p_commit IN VARCHAR2 := FND_API.G_FALSE,
108 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109 p_return_status OUT NOCOPY VARCHAR2,
110 p_msg_count OUT NOCOPY NUMBER,
111 p_msg_data OUT NOCOPY VARCHAR2,
112 p_distribution_id IN OUT NOCOPY NUMBER,
113 p_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
114 p_position_id IN NUMBER,
115 p_data_extract_id IN NUMBER,
116 p_effective_start_date IN DATE,
117 p_effective_end_date IN DATE,
118 p_chart_of_accounts_id IN NUMBER,
119 p_code_combination_id IN NUMBER,
120 p_distribution_percent IN NUMBER,
121 p_global_default_flag IN VARCHAR2,
122 p_distribution_default_rule_id IN NUMBER,
123 p_rowid IN OUT NOCOPY VARCHAR2,
124 p_budget_revision_pos_line_id IN NUMBER:= FND_API.G_MISS_NUM,
125 p_mode IN VARCHAR2 default 'R'
126 );
127
128 PROCEDURE DELETE_ROW (
129 p_api_version in number,
130 p_init_msg_list in varchar2 := fnd_api.g_false,
131 p_commit in varchar2 := fnd_api.g_false,
132 p_validation_level in number := fnd_api.g_valid_level_full,
133 p_return_status OUT NOCOPY varchar2,
134 p_msg_count OUT NOCOPY number,
135 p_msg_data OUT NOCOPY varchar2,
136 p_distribution_id in number
137 );
138 --
139
140 PROCEDURE LOCK_ROW (
141 p_api_version in number,
142 p_init_msg_list in varchar2 := fnd_api.g_false,
143 p_commit in varchar2 := fnd_api.g_false,
144 p_validation_level in number := fnd_api.g_valid_level_full,
145 p_return_status OUT NOCOPY varchar2,
146 p_msg_count OUT NOCOPY number,
147 p_msg_data OUT NOCOPY varchar2,
148 p_row_locked OUT NOCOPY varchar2,
149 p_distribution_id in number,
150 p_position_id in number,
151 p_data_extract_id in number,
152 p_effective_start_date in date,
153 p_effective_end_date in date,
154 p_chart_of_accounts_id in number,
155 p_code_combination_id in number,
156 p_distribution_percent in number,
157 p_global_default_flag in varchar2,
158 p_distribution_default_rule_id in number
159 );
160
161 --
162 ---
163 END PSB_POSITIONS_I_PVT ;