eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_WS_POS_PVT dependencies on FND_API

Line 8: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1

4: /* ----------------------------------------------------------------------- */
5:
6: -- API name : Check_Allowed
7: -- Type : Private
8: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
9: -- Parameters :
10: -- IN : p_api_version IN NUMBER Required
11: -- p_init_msg_list IN VARCHAR2 Optional
12: -- Default = FND_API.G_FALSE

Line 12: -- Default = FND_API.G_FALSE

8: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
9: -- Parameters :
10: -- IN : p_api_version IN NUMBER Required
11: -- p_init_msg_list IN VARCHAR2 Optional
12: -- Default = FND_API.G_FALSE
13: -- p_validation_level IN NUMBER Optional
14: -- Default = FND_API.G_VALID_LEVEL_NONE
15: -- p_worksheet_id IN NUMBER Required
16: -- p_position_budget_group_id IN NUMBER Required

Line 14: -- Default = FND_API.G_VALID_LEVEL_NONE

10: -- IN : p_api_version IN NUMBER Required
11: -- p_init_msg_list IN VARCHAR2 Optional
12: -- Default = FND_API.G_FALSE
13: -- p_validation_level IN NUMBER Optional
14: -- Default = FND_API.G_VALID_LEVEL_NONE
15: -- p_worksheet_id IN NUMBER Required
16: -- p_position_budget_group_id IN NUMBER Required
17: -- .
18: -- OUT NOCOPY : p_msg_count OUT NOCOPY NUMBER

Line 27: -- returns values FND_API.G_TRUE or FND_API.G_FALSE.

23: -- Created 01/04/1998 by Supriyo Ghosh
24: -- .
25: -- Notes : Check if Position Budget Group is within the Budget
26: -- Group Hierarchy for the Worksheet. This function
27: -- returns values FND_API.G_TRUE or FND_API.G_FALSE.
28: --
29:
30: FUNCTION Check_Allowed
31: ( p_api_version IN NUMBER,

Line 32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

28: --
29:
30: FUNCTION Check_Allowed
31: ( p_api_version IN NUMBER,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
34: p_msg_count OUT NOCOPY NUMBER,
35: p_msg_data OUT NOCOPY VARCHAR2,
36: p_worksheet_id IN NUMBER,

Line 33: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

29:
30: FUNCTION Check_Allowed
31: ( p_api_version IN NUMBER,
32: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
34: p_msg_count OUT NOCOPY NUMBER,
35: p_msg_data OUT NOCOPY VARCHAR2,
36: p_worksheet_id IN NUMBER,
37: p_position_budget_group_id IN NUMBER

Line 44: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1

40: /* ----------------------------------------------------------------------- */
41:
42: -- API name : Create_Position_Lines
43: -- Type : Private
44: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
45: -- Parameters :
46: -- IN : p_api_version IN NUMBER Required
47: -- p_init_msg_list IN VARCHAR2 Optional
48: -- Default = FND_API.G_FALSE

Line 48: -- Default = FND_API.G_FALSE

44: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
45: -- Parameters :
46: -- IN : p_api_version IN NUMBER Required
47: -- p_init_msg_list IN VARCHAR2 Optional
48: -- Default = FND_API.G_FALSE
49: -- p_commit IN VARCHAR2 Optional
50: -- Default = FND_API.G_FALSE
51: -- p_validation_level IN NUMBER Optional
52: -- Default = FND_API.G_VALID_LEVEL_NONE

Line 50: -- Default = FND_API.G_FALSE

46: -- IN : p_api_version IN NUMBER Required
47: -- p_init_msg_list IN VARCHAR2 Optional
48: -- Default = FND_API.G_FALSE
49: -- p_commit IN VARCHAR2 Optional
50: -- Default = FND_API.G_FALSE
51: -- p_validation_level IN NUMBER Optional
52: -- Default = FND_API.G_VALID_LEVEL_NONE
53: -- p_worksheet_id IN NUMBER Required
54: -- p_position_id IN NUMBER Required

Line 52: -- Default = FND_API.G_VALID_LEVEL_NONE

48: -- Default = FND_API.G_FALSE
49: -- p_commit IN VARCHAR2 Optional
50: -- Default = FND_API.G_FALSE
51: -- p_validation_level IN NUMBER Optional
52: -- Default = FND_API.G_VALID_LEVEL_NONE
53: -- p_worksheet_id IN NUMBER Required
54: -- p_position_id IN NUMBER Required
55: -- p_budget_group_id IN NUMBER Required
56: -- p_copy_of_position_line_id IN NUMBER Optional

Line 57: -- Default = FND_API.G_MISS_NUM

53: -- p_worksheet_id IN NUMBER Required
54: -- p_position_id IN NUMBER Required
55: -- p_budget_group_id IN NUMBER Required
56: -- p_copy_of_position_line_id IN NUMBER Optional
57: -- Default = FND_API.G_MISS_NUM
58: -- .
59: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
60: -- p_msg_count OUT NOCOPY NUMBER
61: -- p_msg_data OUT NOCOPY VARCHAR2(2000)

Line 75: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

71: --
72:
73: PROCEDURE Create_Position_Lines
74: ( p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76: p_commit IN VARCHAR2 := FND_API.G_FALSE,
77: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
78: p_return_status OUT NOCOPY VARCHAR2,
79: p_msg_count OUT NOCOPY NUMBER,

Line 76: p_commit IN VARCHAR2 := FND_API.G_FALSE,

72:
73: PROCEDURE Create_Position_Lines
74: ( p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76: p_commit IN VARCHAR2 := FND_API.G_FALSE,
77: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
78: p_return_status OUT NOCOPY VARCHAR2,
79: p_msg_count OUT NOCOPY NUMBER,
80: p_msg_data OUT NOCOPY VARCHAR2,

Line 77: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

73: PROCEDURE Create_Position_Lines
74: ( p_api_version IN NUMBER,
75: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76: p_commit IN VARCHAR2 := FND_API.G_FALSE,
77: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
78: p_return_status OUT NOCOPY VARCHAR2,
79: p_msg_count OUT NOCOPY NUMBER,
80: p_msg_data OUT NOCOPY VARCHAR2,
81: p_position_line_id OUT NOCOPY NUMBER,

Line 85: p_copy_of_position_line_id IN NUMBER := FND_API.G_MISS_NUM

81: p_position_line_id OUT NOCOPY NUMBER,
82: p_worksheet_id IN NUMBER,
83: p_position_id IN NUMBER,
84: p_budget_group_id IN NUMBER,
85: p_copy_of_position_line_id IN NUMBER := FND_API.G_MISS_NUM
86: );
87:
88: /* ----------------------------------------------------------------------- */
89:

Line 92: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1

88: /* ----------------------------------------------------------------------- */
89:
90: -- API name : Create_Position_Matrix
91: -- Type : Private
92: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
93: -- Parameters :
94: -- IN : p_api_version IN NUMBER Required
95: -- p_init_msg_list IN VARCHAR2 Optional
96: -- Default = FND_API.G_FALSE

Line 96: -- Default = FND_API.G_FALSE

92: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
93: -- Parameters :
94: -- IN : p_api_version IN NUMBER Required
95: -- p_init_msg_list IN VARCHAR2 Optional
96: -- Default = FND_API.G_FALSE
97: -- p_commit IN VARCHAR2 Optional
98: -- Default = FND_API.G_FALSE
99: -- p_validation_level IN NUMBER Optional
100: -- Default = FND_API.G_VALID_LEVEL_NONE

Line 98: -- Default = FND_API.G_FALSE

94: -- IN : p_api_version IN NUMBER Required
95: -- p_init_msg_list IN VARCHAR2 Optional
96: -- Default = FND_API.G_FALSE
97: -- p_commit IN VARCHAR2 Optional
98: -- Default = FND_API.G_FALSE
99: -- p_validation_level IN NUMBER Optional
100: -- Default = FND_API.G_VALID_LEVEL_NONE
101: -- p_worksheet_id IN NUMBER Required
102: -- p_position_line_id IN NUMBER Required

Line 100: -- Default = FND_API.G_VALID_LEVEL_NONE

96: -- Default = FND_API.G_FALSE
97: -- p_commit IN VARCHAR2 Optional
98: -- Default = FND_API.G_FALSE
99: -- p_validation_level IN NUMBER Optional
100: -- Default = FND_API.G_VALID_LEVEL_NONE
101: -- p_worksheet_id IN NUMBER Required
102: -- p_position_line_id IN NUMBER Required
103: -- p_freeze_flag IN VARCHAR2 Optional
104: -- Default = FND_API.G_FALSE

Line 104: -- Default = FND_API.G_FALSE

100: -- Default = FND_API.G_VALID_LEVEL_NONE
101: -- p_worksheet_id IN NUMBER Required
102: -- p_position_line_id IN NUMBER Required
103: -- p_freeze_flag IN VARCHAR2 Optional
104: -- Default = FND_API.G_FALSE
105: -- p_view_line_flag IN VARCHAR2 Optional
106: -- Default = FND_API.G_TRUE
107: -- .
108: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)

Line 106: -- Default = FND_API.G_TRUE

102: -- p_position_line_id IN NUMBER Required
103: -- p_freeze_flag IN VARCHAR2 Optional
104: -- Default = FND_API.G_FALSE
105: -- p_view_line_flag IN VARCHAR2 Optional
106: -- Default = FND_API.G_TRUE
107: -- .
108: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
109: -- p_msg_count OUT NOCOPY NUMBER
110: -- p_msg_data OUT NOCOPY VARCHAR2(2000)

Line 122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

118: --
119:
120: PROCEDURE Create_Position_Matrix
121: ( p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
125: p_return_status OUT NOCOPY VARCHAR2,
126: p_msg_count OUT NOCOPY NUMBER,

Line 123: p_commit IN VARCHAR2 := FND_API.G_FALSE,

119:
120: PROCEDURE Create_Position_Matrix
121: ( p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
125: p_return_status OUT NOCOPY VARCHAR2,
126: p_msg_count OUT NOCOPY NUMBER,
127: p_msg_data OUT NOCOPY VARCHAR2,

Line 124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

120: PROCEDURE Create_Position_Matrix
121: ( p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123: p_commit IN VARCHAR2 := FND_API.G_FALSE,
124: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
125: p_return_status OUT NOCOPY VARCHAR2,
126: p_msg_count OUT NOCOPY NUMBER,
127: p_msg_data OUT NOCOPY VARCHAR2,
128: p_worksheet_id IN NUMBER,

Line 130: p_freeze_flag IN VARCHAR2 := FND_API.G_FALSE,

126: p_msg_count OUT NOCOPY NUMBER,
127: p_msg_data OUT NOCOPY VARCHAR2,
128: p_worksheet_id IN NUMBER,
129: p_position_line_id IN NUMBER,
130: p_freeze_flag IN VARCHAR2 := FND_API.G_FALSE,
131: p_view_line_flag IN VARCHAR2 := FND_API.G_TRUE
132: );
133:
134: /* ----------------------------------------------------------------------- */

Line 131: p_view_line_flag IN VARCHAR2 := FND_API.G_TRUE

127: p_msg_data OUT NOCOPY VARCHAR2,
128: p_worksheet_id IN NUMBER,
129: p_position_line_id IN NUMBER,
130: p_freeze_flag IN VARCHAR2 := FND_API.G_FALSE,
131: p_view_line_flag IN VARCHAR2 := FND_API.G_TRUE
132: );
133:
134: /* ----------------------------------------------------------------------- */
135:

Line 138: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1

134: /* ----------------------------------------------------------------------- */
135:
136: -- API name : Create_FTE_Lines
137: -- Type : Private
138: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
139: -- Parameters :
140: -- IN : p_api_version IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional
142: -- Default = FND_API.G_FALSE

Line 142: -- Default = FND_API.G_FALSE

138: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
139: -- Parameters :
140: -- IN : p_api_version IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional
142: -- Default = FND_API.G_FALSE
143: -- p_commit IN VARCHAR2 Optional
144: -- Default = FND_API.G_FALSE
145: -- p_validation_level IN NUMBER Optional
146: -- Default = FND_API.G_VALID_LEVEL_NONE

Line 144: -- Default = FND_API.G_FALSE

140: -- IN : p_api_version IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional
142: -- Default = FND_API.G_FALSE
143: -- p_commit IN VARCHAR2 Optional
144: -- Default = FND_API.G_FALSE
145: -- p_validation_level IN NUMBER Optional
146: -- Default = FND_API.G_VALID_LEVEL_NONE
147: -- p_check_spfl_exists IN VARCHAR2 Optional
148: -- Default = FND_API.G_TRUE

Line 146: -- Default = FND_API.G_VALID_LEVEL_NONE

142: -- Default = FND_API.G_FALSE
143: -- p_commit IN VARCHAR2 Optional
144: -- Default = FND_API.G_FALSE
145: -- p_validation_level IN NUMBER Optional
146: -- Default = FND_API.G_VALID_LEVEL_NONE
147: -- p_check_spfl_exists IN VARCHAR2 Optional
148: -- Default = FND_API.G_TRUE
149: -- p_recalculate_flag IN VARCHAR2 Optional
150: -- Default = FND_API.G_FALSE

Line 148: -- Default = FND_API.G_TRUE

144: -- Default = FND_API.G_FALSE
145: -- p_validation_level IN NUMBER Optional
146: -- Default = FND_API.G_VALID_LEVEL_NONE
147: -- p_check_spfl_exists IN VARCHAR2 Optional
148: -- Default = FND_API.G_TRUE
149: -- p_recalculate_flag IN VARCHAR2 Optional
150: -- Default = FND_API.G_FALSE
151: -- p_worksheet_id IN NUMBER Required
152: -- p_flex_mapping_set_id IN NUMBER Optional

Line 150: -- Default = FND_API.G_FALSE

146: -- Default = FND_API.G_VALID_LEVEL_NONE
147: -- p_check_spfl_exists IN VARCHAR2 Optional
148: -- Default = FND_API.G_TRUE
149: -- p_recalculate_flag IN VARCHAR2 Optional
150: -- Default = FND_API.G_FALSE
151: -- p_worksheet_id IN NUMBER Required
152: -- p_flex_mapping_set_id IN NUMBER Optional
153: -- Default = FND_API.G_MISS_NUM
154: -- p_position_line_id IN NUMBER Required

Line 153: -- Default = FND_API.G_MISS_NUM

149: -- p_recalculate_flag IN VARCHAR2 Optional
150: -- Default = FND_API.G_FALSE
151: -- p_worksheet_id IN NUMBER Required
152: -- p_flex_mapping_set_id IN NUMBER Optional
153: -- Default = FND_API.G_MISS_NUM
154: -- p_position_line_id IN NUMBER Required
155: -- p_budget_year_id IN NUMBER Required
156: -- p_budget_group_id IN NUMBER Optional
157: -- Default = FND_API.G_MISS_NUM

Line 157: -- Default = FND_API.G_MISS_NUM

153: -- Default = FND_API.G_MISS_NUM
154: -- p_position_line_id IN NUMBER Required
155: -- p_budget_year_id IN NUMBER Required
156: -- p_budget_group_id IN NUMBER Optional
157: -- Default = FND_API.G_MISS_NUM
158: -- p_annual_fte IN NUMBER Optional
159: -- Default = FND_API.G_MISS_NUM
160: -- p_service_package_id IN NUMBER Required
161: -- p_stage_set_id IN NUMBER Required

Line 159: -- Default = FND_API.G_MISS_NUM

155: -- p_budget_year_id IN NUMBER Required
156: -- p_budget_group_id IN NUMBER Optional
157: -- Default = FND_API.G_MISS_NUM
158: -- p_annual_fte IN NUMBER Optional
159: -- Default = FND_API.G_MISS_NUM
160: -- p_service_package_id IN NUMBER Required
161: -- p_stage_set_id IN NUMBER Required
162: -- p_start_stage_seq IN NUMBER Optional
163: -- Default = FND_API.G_MISS_NUM

Line 163: -- Default = FND_API.G_MISS_NUM

159: -- Default = FND_API.G_MISS_NUM
160: -- p_service_package_id IN NUMBER Required
161: -- p_stage_set_id IN NUMBER Required
162: -- p_start_stage_seq IN NUMBER Optional
163: -- Default = FND_API.G_MISS_NUM
164: -- p_current_stage_seq IN NUMBER Required
165: -- p_end_stage_seq IN NUMBER Optional
166: -- Default = FND_API.G_MISS_NUM
167: -- p_period_fte IN TABLE Required

Line 166: -- Default = FND_API.G_MISS_NUM

162: -- p_start_stage_seq IN NUMBER Optional
163: -- Default = FND_API.G_MISS_NUM
164: -- p_current_stage_seq IN NUMBER Required
165: -- p_end_stage_seq IN NUMBER Optional
166: -- Default = FND_API.G_MISS_NUM
167: -- p_period_fte IN TABLE Required
168: -- .
169: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
170: -- p_msg_count OUT NOCOPY NUMBER

Line 183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

179: --
180:
181: PROCEDURE Create_FTE_Lines
182: ( p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
186: p_return_status OUT NOCOPY VARCHAR2,
187: p_msg_count OUT NOCOPY NUMBER,

Line 184: p_commit IN VARCHAR2 := FND_API.G_FALSE,

180:
181: PROCEDURE Create_FTE_Lines
182: ( p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
186: p_return_status OUT NOCOPY VARCHAR2,
187: p_msg_count OUT NOCOPY NUMBER,
188: p_msg_data OUT NOCOPY VARCHAR2,

Line 185: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

181: PROCEDURE Create_FTE_Lines
182: ( p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
184: p_commit IN VARCHAR2 := FND_API.G_FALSE,
185: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
186: p_return_status OUT NOCOPY VARCHAR2,
187: p_msg_count OUT NOCOPY NUMBER,
188: p_msg_data OUT NOCOPY VARCHAR2,
189: p_fte_line_id OUT NOCOPY NUMBER,

Line 190: p_check_spfl_exists IN VARCHAR2 := FND_API.G_TRUE,

186: p_return_status OUT NOCOPY VARCHAR2,
187: p_msg_count OUT NOCOPY NUMBER,
188: p_msg_data OUT NOCOPY VARCHAR2,
189: p_fte_line_id OUT NOCOPY NUMBER,
190: p_check_spfl_exists IN VARCHAR2 := FND_API.G_TRUE,
191: p_recalculate_flag IN VARCHAR2 := FND_API.G_FALSE,
192: p_worksheet_id IN NUMBER,
193: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_position_line_id IN NUMBER,

Line 191: p_recalculate_flag IN VARCHAR2 := FND_API.G_FALSE,

187: p_msg_count OUT NOCOPY NUMBER,
188: p_msg_data OUT NOCOPY VARCHAR2,
189: p_fte_line_id OUT NOCOPY NUMBER,
190: p_check_spfl_exists IN VARCHAR2 := FND_API.G_TRUE,
191: p_recalculate_flag IN VARCHAR2 := FND_API.G_FALSE,
192: p_worksheet_id IN NUMBER,
193: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_position_line_id IN NUMBER,
195: p_budget_year_id IN NUMBER,

Line 193: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,

189: p_fte_line_id OUT NOCOPY NUMBER,
190: p_check_spfl_exists IN VARCHAR2 := FND_API.G_TRUE,
191: p_recalculate_flag IN VARCHAR2 := FND_API.G_FALSE,
192: p_worksheet_id IN NUMBER,
193: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_position_line_id IN NUMBER,
195: p_budget_year_id IN NUMBER,
196: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,

Line 196: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,

192: p_worksheet_id IN NUMBER,
193: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_position_line_id IN NUMBER,
195: p_budget_year_id IN NUMBER,
196: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
198: p_service_package_id IN NUMBER,
199: p_stage_set_id IN NUMBER,
200: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

Line 197: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,

193: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
194: p_position_line_id IN NUMBER,
195: p_budget_year_id IN NUMBER,
196: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
198: p_service_package_id IN NUMBER,
199: p_stage_set_id IN NUMBER,
200: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
201: p_current_stage_seq IN NUMBER,

Line 200: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

196: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
197: p_annual_fte IN NUMBER := FND_API.G_MISS_NUM,
198: p_service_package_id IN NUMBER,
199: p_stage_set_id IN NUMBER,
200: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
201: p_current_stage_seq IN NUMBER,
202: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
203: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type
204: );

Line 202: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

198: p_service_package_id IN NUMBER,
199: p_stage_set_id IN NUMBER,
200: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
201: p_current_stage_seq IN NUMBER,
202: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
203: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type
204: );
205:
206: /* ----------------------------------------------------------------------- */

Line 210: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1

206: /* ----------------------------------------------------------------------- */
207:
208: -- API name : Create_FTE_Lines
209: -- Type : Private
210: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
211: -- Parameters :
212: -- IN : p_api_version IN NUMBER Required
213: -- p_init_msg_list IN VARCHAR2 Optional
214: -- Default = FND_API.G_FALSE

Line 214: -- Default = FND_API.G_FALSE

210: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
211: -- Parameters :
212: -- IN : p_api_version IN NUMBER Required
213: -- p_init_msg_list IN VARCHAR2 Optional
214: -- Default = FND_API.G_FALSE
215: -- p_commit IN VARCHAR2 Optional
216: -- Default = FND_API.G_FALSE
217: -- p_validation_level IN NUMBER Optional
218: -- Default = FND_API.G_VALID_LEVEL_NONE

Line 216: -- Default = FND_API.G_FALSE

212: -- IN : p_api_version IN NUMBER Required
213: -- p_init_msg_list IN VARCHAR2 Optional
214: -- Default = FND_API.G_FALSE
215: -- p_commit IN VARCHAR2 Optional
216: -- Default = FND_API.G_FALSE
217: -- p_validation_level IN NUMBER Optional
218: -- Default = FND_API.G_VALID_LEVEL_NONE
219: -- p_check_stages IN VARCHAR2 Optional
220: -- Default = FND_API.G_TRUE

Line 218: -- Default = FND_API.G_VALID_LEVEL_NONE

214: -- Default = FND_API.G_FALSE
215: -- p_commit IN VARCHAR2 Optional
216: -- Default = FND_API.G_FALSE
217: -- p_validation_level IN NUMBER Optional
218: -- Default = FND_API.G_VALID_LEVEL_NONE
219: -- p_check_stages IN VARCHAR2 Optional
220: -- Default = FND_API.G_TRUE
221: -- p_worksheet_id IN NUMBER Required
222: -- p_fte_line_id IN NUMBER Required

Line 220: -- Default = FND_API.G_TRUE

216: -- Default = FND_API.G_FALSE
217: -- p_validation_level IN NUMBER Optional
218: -- Default = FND_API.G_VALID_LEVEL_NONE
219: -- p_check_stages IN VARCHAR2 Optional
220: -- Default = FND_API.G_TRUE
221: -- p_worksheet_id IN NUMBER Required
222: -- p_fte_line_id IN NUMBER Required
223: -- p_service_package_id IN NUMBER Optional
224: -- Default = FND_API.G_MISS_NUM

Line 224: -- Default = FND_API.G_MISS_NUM

220: -- Default = FND_API.G_TRUE
221: -- p_worksheet_id IN NUMBER Required
222: -- p_fte_line_id IN NUMBER Required
223: -- p_service_package_id IN NUMBER Optional
224: -- Default = FND_API.G_MISS_NUM
225: -- p_current_stage_seq IN NUMBER Optional
226: -- Default = FND_API.G_MISS_NUM
227: -- p_period_fte IN TABLE Required
228: -- p_budget_group_id IN NUMBER Optional

Line 226: -- Default = FND_API.G_MISS_NUM

222: -- p_fte_line_id IN NUMBER Required
223: -- p_service_package_id IN NUMBER Optional
224: -- Default = FND_API.G_MISS_NUM
225: -- p_current_stage_seq IN NUMBER Optional
226: -- Default = FND_API.G_MISS_NUM
227: -- p_period_fte IN TABLE Required
228: -- p_budget_group_id IN NUMBER Optional
229: -- Default = FND_API.G_MISS_NUM
230: -- .

Line 229: -- Default = FND_API.G_MISS_NUM

225: -- p_current_stage_seq IN NUMBER Optional
226: -- Default = FND_API.G_MISS_NUM
227: -- p_period_fte IN TABLE Required
228: -- p_budget_group_id IN NUMBER Optional
229: -- Default = FND_API.G_MISS_NUM
230: -- .
231: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
232: -- p_msg_count OUT NOCOPY NUMBER
233: -- p_msg_data OUT NOCOPY VARCHAR2(2000)

Line 244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

240: --
241:
242: PROCEDURE Create_FTE_Lines
243: ( p_api_version IN NUMBER,
244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
245: p_commit IN VARCHAR2 := FND_API.G_FALSE,
246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
247: p_return_status OUT NOCOPY VARCHAR2,
248: p_msg_count OUT NOCOPY NUMBER,

Line 245: p_commit IN VARCHAR2 := FND_API.G_FALSE,

241:
242: PROCEDURE Create_FTE_Lines
243: ( p_api_version IN NUMBER,
244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
245: p_commit IN VARCHAR2 := FND_API.G_FALSE,
246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
247: p_return_status OUT NOCOPY VARCHAR2,
248: p_msg_count OUT NOCOPY NUMBER,
249: p_msg_data OUT NOCOPY VARCHAR2,

Line 246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

242: PROCEDURE Create_FTE_Lines
243: ( p_api_version IN NUMBER,
244: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
245: p_commit IN VARCHAR2 := FND_API.G_FALSE,
246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
247: p_return_status OUT NOCOPY VARCHAR2,
248: p_msg_count OUT NOCOPY NUMBER,
249: p_msg_data OUT NOCOPY VARCHAR2,
250: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,

Line 250: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,

246: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
247: p_return_status OUT NOCOPY VARCHAR2,
248: p_msg_count OUT NOCOPY NUMBER,
249: p_msg_data OUT NOCOPY VARCHAR2,
250: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
251: p_worksheet_id IN NUMBER,
252: p_fte_line_id IN NUMBER,
253: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
254: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

Line 253: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,

249: p_msg_data OUT NOCOPY VARCHAR2,
250: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
251: p_worksheet_id IN NUMBER,
252: p_fte_line_id IN NUMBER,
253: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
254: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
255: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type,
256: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM
257: );

Line 254: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

250: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
251: p_worksheet_id IN NUMBER,
252: p_fte_line_id IN NUMBER,
253: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
254: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
255: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type,
256: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM
257: );
258:

Line 256: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM

252: p_fte_line_id IN NUMBER,
253: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
254: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
255: p_period_fte IN PSB_WS_ACCT1.g_prdamt_tbl_type,
256: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM
257: );
258:
259: /* ----------------------------------------------------------------------- */
260:

Line 263: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1

259: /* ----------------------------------------------------------------------- */
260:
261: -- API name : Create_Element_Lines
262: -- Type : Private
263: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
264: -- Parameters :
265: -- IN : p_api_version IN NUMBER Required
266: -- p_init_msg_list IN VARCHAR2 Optional
267: -- Default = FND_API.G_FALSE

Line 267: -- Default = FND_API.G_FALSE

263: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
264: -- Parameters :
265: -- IN : p_api_version IN NUMBER Required
266: -- p_init_msg_list IN VARCHAR2 Optional
267: -- Default = FND_API.G_FALSE
268: -- p_commit IN VARCHAR2 Optional
269: -- Default = FND_API.G_FALSE
270: -- p_validation_level IN NUMBER Optional
271: -- Default = FND_API.G_VALID_LEVEL_NONE

Line 269: -- Default = FND_API.G_FALSE

265: -- IN : p_api_version IN NUMBER Required
266: -- p_init_msg_list IN VARCHAR2 Optional
267: -- Default = FND_API.G_FALSE
268: -- p_commit IN VARCHAR2 Optional
269: -- Default = FND_API.G_FALSE
270: -- p_validation_level IN NUMBER Optional
271: -- Default = FND_API.G_VALID_LEVEL_NONE
272: -- p_check_spel_exists IN VARCHAR2 Optional
273: -- Default = FND_API.G_TRUE

Line 271: -- Default = FND_API.G_VALID_LEVEL_NONE

267: -- Default = FND_API.G_FALSE
268: -- p_commit IN VARCHAR2 Optional
269: -- Default = FND_API.G_FALSE
270: -- p_validation_level IN NUMBER Optional
271: -- Default = FND_API.G_VALID_LEVEL_NONE
272: -- p_check_spel_exists IN VARCHAR2 Optional
273: -- Default = FND_API.G_TRUE
274: -- p_position_line_id IN NUMBER Required
275: -- p_budget_year_id IN NUMBER Required

Line 273: -- Default = FND_API.G_TRUE

269: -- Default = FND_API.G_FALSE
270: -- p_validation_level IN NUMBER Optional
271: -- Default = FND_API.G_VALID_LEVEL_NONE
272: -- p_check_spel_exists IN VARCHAR2 Optional
273: -- Default = FND_API.G_TRUE
274: -- p_position_line_id IN NUMBER Required
275: -- p_budget_year_id IN NUMBER Required
276: -- p_pay_element_id IN NUMBER Required
277: -- p_currency_code IN VARCHAR2 Required

Line 283: -- Default = FND_API.G_MISS_NUM

279: -- p_element_set_id IN NUMBER Required
280: -- p_service_package_id IN NUMBER Required
281: -- p_stage_set_id IN NUMBER Required
282: -- p_start_stage_seq IN NUMBER Optional
283: -- Default = FND_API.G_MISS_NUM
284: -- p_current_stage_seq IN NUMBER Required
285: -- p_end_stage_seq IN NUMBER Optional
286: -- Default = FND_API.G_MISS_NUM
287: -- .

Line 286: -- Default = FND_API.G_MISS_NUM

282: -- p_start_stage_seq IN NUMBER Optional
283: -- Default = FND_API.G_MISS_NUM
284: -- p_current_stage_seq IN NUMBER Required
285: -- p_end_stage_seq IN NUMBER Optional
286: -- Default = FND_API.G_MISS_NUM
287: -- .
288: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
289: -- p_msg_count OUT NOCOPY NUMBER
290: -- p_msg_data OUT NOCOPY VARCHAR2(2000)

Line 302: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

298: --
299:
300: PROCEDURE Create_Element_Lines
301: ( p_api_version IN NUMBER,
302: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
303: p_commit IN VARCHAR2 := FND_API.G_FALSE,
304: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
305: p_return_status OUT NOCOPY VARCHAR2,
306: p_msg_count OUT NOCOPY NUMBER,

Line 303: p_commit IN VARCHAR2 := FND_API.G_FALSE,

299:
300: PROCEDURE Create_Element_Lines
301: ( p_api_version IN NUMBER,
302: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
303: p_commit IN VARCHAR2 := FND_API.G_FALSE,
304: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
305: p_return_status OUT NOCOPY VARCHAR2,
306: p_msg_count OUT NOCOPY NUMBER,
307: p_msg_data OUT NOCOPY VARCHAR2,

Line 304: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

300: PROCEDURE Create_Element_Lines
301: ( p_api_version IN NUMBER,
302: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
303: p_commit IN VARCHAR2 := FND_API.G_FALSE,
304: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
305: p_return_status OUT NOCOPY VARCHAR2,
306: p_msg_count OUT NOCOPY NUMBER,
307: p_msg_data OUT NOCOPY VARCHAR2,
308: p_element_line_id OUT NOCOPY NUMBER,

Line 309: p_check_spel_exists IN VARCHAR2 := FND_API.G_TRUE,

305: p_return_status OUT NOCOPY VARCHAR2,
306: p_msg_count OUT NOCOPY NUMBER,
307: p_msg_data OUT NOCOPY VARCHAR2,
308: p_element_line_id OUT NOCOPY NUMBER,
309: p_check_spel_exists IN VARCHAR2 := FND_API.G_TRUE,
310: p_position_line_id IN NUMBER,
311: p_budget_year_id IN NUMBER,
312: p_pay_element_id IN NUMBER,
313: p_currency_code IN VARCHAR2,

Line 318: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

314: p_element_cost IN NUMBER,
315: p_element_set_id IN NUMBER,
316: p_service_package_id IN NUMBER,
317: p_stage_set_id IN NUMBER,
318: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
319: p_current_stage_seq IN NUMBER,
320: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM);
321:
322: /* ----------------------------------------------------------------------- */

Line 320: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM);

316: p_service_package_id IN NUMBER,
317: p_stage_set_id IN NUMBER,
318: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
319: p_current_stage_seq IN NUMBER,
320: p_end_stage_seq IN NUMBER := FND_API.G_MISS_NUM);
321:
322: /* ----------------------------------------------------------------------- */
323:
324: -- API name : Create_Element_Lines

Line 326: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1

322: /* ----------------------------------------------------------------------- */
323:
324: -- API name : Create_Element_Lines
325: -- Type : Private
326: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
327: -- Parameters :
328: -- IN : p_api_version IN NUMBER Required
329: -- p_init_msg_list IN VARCHAR2 Optional
330: -- Default = FND_API.G_FALSE

Line 330: -- Default = FND_API.G_FALSE

326: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
327: -- Parameters :
328: -- IN : p_api_version IN NUMBER Required
329: -- p_init_msg_list IN VARCHAR2 Optional
330: -- Default = FND_API.G_FALSE
331: -- p_commit IN VARCHAR2 Optional
332: -- Default = FND_API.G_FALSE
333: -- p_validation_level IN NUMBER Optional
334: -- Default = FND_API.G_VALID_LEVEL_NONE

Line 332: -- Default = FND_API.G_FALSE

328: -- IN : p_api_version IN NUMBER Required
329: -- p_init_msg_list IN VARCHAR2 Optional
330: -- Default = FND_API.G_FALSE
331: -- p_commit IN VARCHAR2 Optional
332: -- Default = FND_API.G_FALSE
333: -- p_validation_level IN NUMBER Optional
334: -- Default = FND_API.G_VALID_LEVEL_NONE
335: -- p_check_stages IN VARCHAR2 Optional
336: -- Default = FND_API.G_TRUE

Line 334: -- Default = FND_API.G_VALID_LEVEL_NONE

330: -- Default = FND_API.G_FALSE
331: -- p_commit IN VARCHAR2 Optional
332: -- Default = FND_API.G_FALSE
333: -- p_validation_level IN NUMBER Optional
334: -- Default = FND_API.G_VALID_LEVEL_NONE
335: -- p_check_stages IN VARCHAR2 Optional
336: -- Default = FND_API.G_TRUE
337: -- p_element_line_id IN NUMBER Required
338: -- p_service_package_id IN NUMBER Optional

Line 336: -- Default = FND_API.G_TRUE

332: -- Default = FND_API.G_FALSE
333: -- p_validation_level IN NUMBER Optional
334: -- Default = FND_API.G_VALID_LEVEL_NONE
335: -- p_check_stages IN VARCHAR2 Optional
336: -- Default = FND_API.G_TRUE
337: -- p_element_line_id IN NUMBER Required
338: -- p_service_package_id IN NUMBER Optional
339: -- Default = FND_API.G_MISS_NUM
340: -- p_current_stage_seq IN NUMBER Optional

Line 339: -- Default = FND_API.G_MISS_NUM

335: -- p_check_stages IN VARCHAR2 Optional
336: -- Default = FND_API.G_TRUE
337: -- p_element_line_id IN NUMBER Required
338: -- p_service_package_id IN NUMBER Optional
339: -- Default = FND_API.G_MISS_NUM
340: -- p_current_stage_seq IN NUMBER Optional
341: -- Default = FND_API.G_MISS_NUM
342: -- p_element_cost IN NUMBER Optional
343: -- Default = FND_API.G_MISS_NUM

Line 341: -- Default = FND_API.G_MISS_NUM

337: -- p_element_line_id IN NUMBER Required
338: -- p_service_package_id IN NUMBER Optional
339: -- Default = FND_API.G_MISS_NUM
340: -- p_current_stage_seq IN NUMBER Optional
341: -- Default = FND_API.G_MISS_NUM
342: -- p_element_cost IN NUMBER Optional
343: -- Default = FND_API.G_MISS_NUM
344: -- .
345: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)

Line 343: -- Default = FND_API.G_MISS_NUM

339: -- Default = FND_API.G_MISS_NUM
340: -- p_current_stage_seq IN NUMBER Optional
341: -- Default = FND_API.G_MISS_NUM
342: -- p_element_cost IN NUMBER Optional
343: -- Default = FND_API.G_MISS_NUM
344: -- .
345: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
346: -- p_msg_count OUT NOCOPY NUMBER
347: -- p_msg_data OUT NOCOPY VARCHAR2(2000)

Line 358: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

354: --
355:
356: PROCEDURE Create_Element_Lines
357: ( p_api_version IN NUMBER,
358: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
359: p_commit IN VARCHAR2 := FND_API.G_FALSE,
360: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
361: p_return_status OUT NOCOPY VARCHAR2,
362: p_msg_count OUT NOCOPY NUMBER,

Line 359: p_commit IN VARCHAR2 := FND_API.G_FALSE,

355:
356: PROCEDURE Create_Element_Lines
357: ( p_api_version IN NUMBER,
358: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
359: p_commit IN VARCHAR2 := FND_API.G_FALSE,
360: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
361: p_return_status OUT NOCOPY VARCHAR2,
362: p_msg_count OUT NOCOPY NUMBER,
363: p_msg_data OUT NOCOPY VARCHAR2,

Line 360: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

356: PROCEDURE Create_Element_Lines
357: ( p_api_version IN NUMBER,
358: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
359: p_commit IN VARCHAR2 := FND_API.G_FALSE,
360: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
361: p_return_status OUT NOCOPY VARCHAR2,
362: p_msg_count OUT NOCOPY NUMBER,
363: p_msg_data OUT NOCOPY VARCHAR2,
364: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,

Line 364: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,

360: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
361: p_return_status OUT NOCOPY VARCHAR2,
362: p_msg_count OUT NOCOPY NUMBER,
363: p_msg_data OUT NOCOPY VARCHAR2,
364: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
365: p_element_line_id IN NUMBER,
366: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
367: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
368: p_element_cost IN NUMBER := FND_API.G_MISS_NUM

Line 366: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,

362: p_msg_count OUT NOCOPY NUMBER,
363: p_msg_data OUT NOCOPY VARCHAR2,
364: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
365: p_element_line_id IN NUMBER,
366: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
367: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
368: p_element_cost IN NUMBER := FND_API.G_MISS_NUM
369: );
370:

Line 367: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

363: p_msg_data OUT NOCOPY VARCHAR2,
364: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
365: p_element_line_id IN NUMBER,
366: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
367: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
368: p_element_cost IN NUMBER := FND_API.G_MISS_NUM
369: );
370:
371: /* ----------------------------------------------------------------------- */

Line 368: p_element_cost IN NUMBER := FND_API.G_MISS_NUM

364: p_check_stages IN VARCHAR2 := FND_API.G_TRUE,
365: p_element_line_id IN NUMBER,
366: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
367: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
368: p_element_cost IN NUMBER := FND_API.G_MISS_NUM
369: );
370:
371: /* ----------------------------------------------------------------------- */
372:

Line 375: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1

371: /* ----------------------------------------------------------------------- */
372:
373: -- API name : Update_Annual_FTE
374: -- Type : Private
375: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
376: -- Parameters :
377: -- IN : p_api_version IN NUMBER Required
378: -- p_init_msg_list IN VARCHAR2 Optional
379: -- Default = FND_API.G_FALSE

Line 379: -- Default = FND_API.G_FALSE

375: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
376: -- Parameters :
377: -- IN : p_api_version IN NUMBER Required
378: -- p_init_msg_list IN VARCHAR2 Optional
379: -- Default = FND_API.G_FALSE
380: -- p_commit IN VARCHAR2 Optional
381: -- Default = FND_API.G_FALSE
382: -- p_validation_level IN NUMBER Optional
383: -- Default = FND_API.G_VALID_LEVEL_NONE

Line 381: -- Default = FND_API.G_FALSE

377: -- IN : p_api_version IN NUMBER Required
378: -- p_init_msg_list IN VARCHAR2 Optional
379: -- Default = FND_API.G_FALSE
380: -- p_commit IN VARCHAR2 Optional
381: -- Default = FND_API.G_FALSE
382: -- p_validation_level IN NUMBER Optional
383: -- Default = FND_API.G_VALID_LEVEL_NONE
384: -- p_worksheet_id IN NUMBER Required
385: -- p_position_line_id IN NUMBER Required

Line 383: -- Default = FND_API.G_VALID_LEVEL_NONE

379: -- Default = FND_API.G_FALSE
380: -- p_commit IN VARCHAR2 Optional
381: -- Default = FND_API.G_FALSE
382: -- p_validation_level IN NUMBER Optional
383: -- Default = FND_API.G_VALID_LEVEL_NONE
384: -- p_worksheet_id IN NUMBER Required
385: -- p_position_line_id IN NUMBER Required
386: -- p_budget_year_id IN NUMBER Required
387: -- p_service_package_id IN NUMBER Required

Line 391: -- Default = FND_API.G_MISS_NUM

387: -- p_service_package_id IN NUMBER Required
388: -- p_stage_set_id IN NUMBER Required
389: -- p_current_stage_seq IN NUMBER Required
390: -- p_budget_group_id IN NUMBER Optional
391: -- Default = FND_API.G_MISS_NUM
392: -- .
393: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
394: -- p_msg_count OUT NOCOPY NUMBER
395: -- p_msg_data OUT NOCOPY VARCHAR2(2000)

Line 406: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

402: --
403:
404: PROCEDURE Update_Annual_FTE
405: ( p_api_version IN NUMBER,
406: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
407: p_commit IN VARCHAR2 := FND_API.G_FALSE,
408: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
409: p_return_status OUT NOCOPY VARCHAR2,
410: p_msg_count OUT NOCOPY NUMBER,

Line 407: p_commit IN VARCHAR2 := FND_API.G_FALSE,

403:
404: PROCEDURE Update_Annual_FTE
405: ( p_api_version IN NUMBER,
406: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
407: p_commit IN VARCHAR2 := FND_API.G_FALSE,
408: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
409: p_return_status OUT NOCOPY VARCHAR2,
410: p_msg_count OUT NOCOPY NUMBER,
411: p_msg_data OUT NOCOPY VARCHAR2,

Line 408: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

404: PROCEDURE Update_Annual_FTE
405: ( p_api_version IN NUMBER,
406: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
407: p_commit IN VARCHAR2 := FND_API.G_FALSE,
408: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
409: p_return_status OUT NOCOPY VARCHAR2,
410: p_msg_count OUT NOCOPY NUMBER,
411: p_msg_data OUT NOCOPY VARCHAR2,
412: p_worksheet_id IN NUMBER,

Line 418: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM

414: p_budget_year_id IN NUMBER,
415: p_service_package_id IN NUMBER,
416: p_stage_set_id IN NUMBER,
417: p_current_stage_seq IN NUMBER,
418: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM
419: );
420:
421: /* ----------------------------------------------------------------------- */
422:

Line 425: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1

421: /* ----------------------------------------------------------------------- */
422:
423: -- API name : Redistribute_Follow_Salary
424: -- Type : Private
425: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
426: -- Parameters :
427: -- IN : p_api_version IN NUMBER Required
428: -- p_init_msg_list IN VARCHAR2 Optional
429: -- Default = FND_API.G_FALSE

Line 429: -- Default = FND_API.G_FALSE

425: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
426: -- Parameters :
427: -- IN : p_api_version IN NUMBER Required
428: -- p_init_msg_list IN VARCHAR2 Optional
429: -- Default = FND_API.G_FALSE
430: -- p_commit IN VARCHAR2 Optional
431: -- Default = FND_API.G_FALSE
432: -- p_validation_level IN NUMBER Optional
433: -- Default = FND_API.G_VALID_LEVEL_NONE

Line 431: -- Default = FND_API.G_FALSE

427: -- IN : p_api_version IN NUMBER Required
428: -- p_init_msg_list IN VARCHAR2 Optional
429: -- Default = FND_API.G_FALSE
430: -- p_commit IN VARCHAR2 Optional
431: -- Default = FND_API.G_FALSE
432: -- p_validation_level IN NUMBER Optional
433: -- Default = FND_API.G_VALID_LEVEL_NONE
434: -- p_worksheet_id IN NUMBER Required
435: -- p_position_line_id IN NUMBER Required

Line 433: -- Default = FND_API.G_VALID_LEVEL_NONE

429: -- Default = FND_API.G_FALSE
430: -- p_commit IN VARCHAR2 Optional
431: -- Default = FND_API.G_FALSE
432: -- p_validation_level IN NUMBER Optional
433: -- Default = FND_API.G_VALID_LEVEL_NONE
434: -- p_worksheet_id IN NUMBER Required
435: -- p_position_line_id IN NUMBER Required
436: -- p_budget_year_id IN NUMBER Optional
437: -- Default = FND_API.G_MISS_NUM

Line 437: -- Default = FND_API.G_MISS_NUM

433: -- Default = FND_API.G_VALID_LEVEL_NONE
434: -- p_worksheet_id IN NUMBER Required
435: -- p_position_line_id IN NUMBER Required
436: -- p_budget_year_id IN NUMBER Optional
437: -- Default = FND_API.G_MISS_NUM
438: -- p_service_package_id IN NUMBER Required
439: -- p_stage_set_id IN NUMBER Required
440: -- p_func_currency IN VARCHAR2 Optional
441: -- Default = FND_API.G_MISS_CHAR

Line 441: -- Default = FND_API.G_MISS_CHAR

437: -- Default = FND_API.G_MISS_NUM
438: -- p_service_package_id IN NUMBER Required
439: -- p_stage_set_id IN NUMBER Required
440: -- p_func_currency IN VARCHAR2 Optional
441: -- Default = FND_API.G_MISS_CHAR
442: -- .
443: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
444: -- p_msg_count OUT NOCOPY NUMBER
445: -- p_msg_data OUT NOCOPY VARCHAR2(2000)

Line 456: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

452: --
453:
454: PROCEDURE Redistribute_Follow_Salary
455: ( p_api_version IN NUMBER,
456: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
457: p_commit IN VARCHAR2 := FND_API.G_FALSE,
458: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
459: p_return_status OUT NOCOPY VARCHAR2,
460: p_msg_count OUT NOCOPY NUMBER,

Line 457: p_commit IN VARCHAR2 := FND_API.G_FALSE,

453:
454: PROCEDURE Redistribute_Follow_Salary
455: ( p_api_version IN NUMBER,
456: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
457: p_commit IN VARCHAR2 := FND_API.G_FALSE,
458: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
459: p_return_status OUT NOCOPY VARCHAR2,
460: p_msg_count OUT NOCOPY NUMBER,
461: p_msg_data OUT NOCOPY VARCHAR2,

Line 458: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

454: PROCEDURE Redistribute_Follow_Salary
455: ( p_api_version IN NUMBER,
456: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
457: p_commit IN VARCHAR2 := FND_API.G_FALSE,
458: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
459: p_return_status OUT NOCOPY VARCHAR2,
460: p_msg_count OUT NOCOPY NUMBER,
461: p_msg_data OUT NOCOPY VARCHAR2,
462: p_worksheet_id IN NUMBER,

Line 464: p_budget_year_id IN NUMBER := FND_API.G_MISS_NUM,

460: p_msg_count OUT NOCOPY NUMBER,
461: p_msg_data OUT NOCOPY VARCHAR2,
462: p_worksheet_id IN NUMBER,
463: p_position_line_id IN NUMBER,
464: p_budget_year_id IN NUMBER := FND_API.G_MISS_NUM,
465: p_service_package_id IN NUMBER,
466: p_stage_set_id IN NUMBER,
467: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR
468: );

Line 467: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR

463: p_position_line_id IN NUMBER,
464: p_budget_year_id IN NUMBER := FND_API.G_MISS_NUM,
465: p_service_package_id IN NUMBER,
466: p_stage_set_id IN NUMBER,
467: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR
468: );
469:
470: /* ----------------------------------------------------------------------- */
471:

Line 474: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1

470: /* ----------------------------------------------------------------------- */
471:
472: -- API name : Apply_Element_Parameters
473: -- Type : Private
474: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
475: -- Parameters :
476: -- IN : p_api_version IN NUMBER Required
477: -- p_init_msg_list IN VARCHAR2 Optional
478: -- Default = FND_API.G_FALSE

Line 478: -- Default = FND_API.G_FALSE

474: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
475: -- Parameters :
476: -- IN : p_api_version IN NUMBER Required
477: -- p_init_msg_list IN VARCHAR2 Optional
478: -- Default = FND_API.G_FALSE
479: -- p_commit IN VARCHAR2 Optional
480: -- Default = FND_API.G_FALSE
481: -- p_validation_level IN NUMBER Optional
482: -- Default = FND_API.G_VALID_LEVEL_NONE

Line 480: -- Default = FND_API.G_FALSE

476: -- IN : p_api_version IN NUMBER Required
477: -- p_init_msg_list IN VARCHAR2 Optional
478: -- Default = FND_API.G_FALSE
479: -- p_commit IN VARCHAR2 Optional
480: -- Default = FND_API.G_FALSE
481: -- p_validation_level IN NUMBER Optional
482: -- Default = FND_API.G_VALID_LEVEL_NONE
483: -- p_worksheet_id IN NUMBER Required
484: -- p_global_worksheet IN VARCHAR2 Optional

Line 482: -- Default = FND_API.G_VALID_LEVEL_NONE

478: -- Default = FND_API.G_FALSE
479: -- p_commit IN VARCHAR2 Optional
480: -- Default = FND_API.G_FALSE
481: -- p_validation_level IN NUMBER Optional
482: -- Default = FND_API.G_VALID_LEVEL_NONE
483: -- p_worksheet_id IN NUMBER Required
484: -- p_global_worksheet IN VARCHAR2 Optional
485: -- Default = FND_API.G_MISS_CHAR
486: -- p_budget_group_id IN NUMBER Optional

Line 485: -- Default = FND_API.G_MISS_CHAR

481: -- p_validation_level IN NUMBER Optional
482: -- Default = FND_API.G_VALID_LEVEL_NONE
483: -- p_worksheet_id IN NUMBER Required
484: -- p_global_worksheet IN VARCHAR2 Optional
485: -- Default = FND_API.G_MISS_CHAR
486: -- p_budget_group_id IN NUMBER Optional
487: -- Default = FND_API.G_MISS_NUM
488: -- p_data_extract_id IN NUMBER Optional
489: -- Default = FND_API.G_MISS_NUM

Line 487: -- Default = FND_API.G_MISS_NUM

483: -- p_worksheet_id IN NUMBER Required
484: -- p_global_worksheet IN VARCHAR2 Optional
485: -- Default = FND_API.G_MISS_CHAR
486: -- p_budget_group_id IN NUMBER Optional
487: -- Default = FND_API.G_MISS_NUM
488: -- p_data_extract_id IN NUMBER Optional
489: -- Default = FND_API.G_MISS_NUM
490: -- p_business_group_id IN NUMBER Optional
491: -- Default = FND_API.G_MISS_NUM

Line 489: -- Default = FND_API.G_MISS_NUM

485: -- Default = FND_API.G_MISS_CHAR
486: -- p_budget_group_id IN NUMBER Optional
487: -- Default = FND_API.G_MISS_NUM
488: -- p_data_extract_id IN NUMBER Optional
489: -- Default = FND_API.G_MISS_NUM
490: -- p_business_group_id IN NUMBER Optional
491: -- Default = FND_API.G_MISS_NUM
492: -- p_func_currency IN VARCHAR2 Optional
493: -- Default = FND_API.G_MISS_CHAR

Line 491: -- Default = FND_API.G_MISS_NUM

487: -- Default = FND_API.G_MISS_NUM
488: -- p_data_extract_id IN NUMBER Optional
489: -- Default = FND_API.G_MISS_NUM
490: -- p_business_group_id IN NUMBER Optional
491: -- Default = FND_API.G_MISS_NUM
492: -- p_func_currency IN VARCHAR2 Optional
493: -- Default = FND_API.G_MISS_CHAR
494: -- p_budget_calendar_id IN NUMBER Optional
495: -- Default = FND_API.G_MISS_NUM

Line 493: -- Default = FND_API.G_MISS_CHAR

489: -- Default = FND_API.G_MISS_NUM
490: -- p_business_group_id IN NUMBER Optional
491: -- Default = FND_API.G_MISS_NUM
492: -- p_func_currency IN VARCHAR2 Optional
493: -- Default = FND_API.G_MISS_CHAR
494: -- p_budget_calendar_id IN NUMBER Optional
495: -- Default = FND_API.G_MISS_NUM
496: -- p_parameter_set_id IN NUMBER Optional
497: -- Default = FND_API.G_MISS_NUM

Line 495: -- Default = FND_API.G_MISS_NUM

491: -- Default = FND_API.G_MISS_NUM
492: -- p_func_currency IN VARCHAR2 Optional
493: -- Default = FND_API.G_MISS_CHAR
494: -- p_budget_calendar_id IN NUMBER Optional
495: -- Default = FND_API.G_MISS_NUM
496: -- p_parameter_set_id IN NUMBER Optional
497: -- Default = FND_API.G_MISS_NUM
498: -- .
499: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)

Line 497: -- Default = FND_API.G_MISS_NUM

493: -- Default = FND_API.G_MISS_CHAR
494: -- p_budget_calendar_id IN NUMBER Optional
495: -- Default = FND_API.G_MISS_NUM
496: -- p_parameter_set_id IN NUMBER Optional
497: -- Default = FND_API.G_MISS_NUM
498: -- .
499: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
500: -- p_msg_count OUT NOCOPY NUMBER
501: -- p_msg_data OUT NOCOPY VARCHAR2(2000)

Line 513: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

509: --
510:
511: PROCEDURE Apply_Element_Parameters
512: ( p_api_version IN NUMBER,
513: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
514: p_commit IN VARCHAR2 := FND_API.G_FALSE,
515: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
516: p_return_status OUT NOCOPY VARCHAR2,
517: p_msg_count OUT NOCOPY NUMBER,

Line 514: p_commit IN VARCHAR2 := FND_API.G_FALSE,

510:
511: PROCEDURE Apply_Element_Parameters
512: ( p_api_version IN NUMBER,
513: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
514: p_commit IN VARCHAR2 := FND_API.G_FALSE,
515: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
516: p_return_status OUT NOCOPY VARCHAR2,
517: p_msg_count OUT NOCOPY NUMBER,
518: p_msg_data OUT NOCOPY VARCHAR2,

Line 515: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

511: PROCEDURE Apply_Element_Parameters
512: ( p_api_version IN NUMBER,
513: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
514: p_commit IN VARCHAR2 := FND_API.G_FALSE,
515: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
516: p_return_status OUT NOCOPY VARCHAR2,
517: p_msg_count OUT NOCOPY NUMBER,
518: p_msg_data OUT NOCOPY VARCHAR2,
519: p_worksheet_id IN NUMBER,

Line 520: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,

516: p_return_status OUT NOCOPY VARCHAR2,
517: p_msg_count OUT NOCOPY NUMBER,
518: p_msg_data OUT NOCOPY VARCHAR2,
519: p_worksheet_id IN NUMBER,
520: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
522: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
523: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
524: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 521: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,

517: p_msg_count OUT NOCOPY NUMBER,
518: p_msg_data OUT NOCOPY VARCHAR2,
519: p_worksheet_id IN NUMBER,
520: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
522: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
523: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
524: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,

Line 522: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,

518: p_msg_data OUT NOCOPY VARCHAR2,
519: p_worksheet_id IN NUMBER,
520: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
522: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
523: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
524: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
526: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM

Line 523: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,

519: p_worksheet_id IN NUMBER,
520: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
522: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
523: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
524: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
526: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
527: );

Line 524: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,

520: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
521: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
522: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
523: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
524: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
526: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
527: );
528:

Line 525: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,

521: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
522: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
523: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
524: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
526: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
527: );
528:
529: /* ----------------------------------------------------------------------- */

Line 526: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM

522: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
523: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
524: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
525: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
526: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
527: );
528:
529: /* ----------------------------------------------------------------------- */
530:

Line 533: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1

529: /* ----------------------------------------------------------------------- */
530:
531: -- API name : Apply_Position_Parameters
532: -- Type : Private
533: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
534: -- Parameters :
535: -- IN : p_api_version IN NUMBER Required
536: -- p_init_msg_list IN VARCHAR2 Optional
537: -- Default = FND_API.G_FALSE

Line 537: -- Default = FND_API.G_FALSE

533: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS1
534: -- Parameters :
535: -- IN : p_api_version IN NUMBER Required
536: -- p_init_msg_list IN VARCHAR2 Optional
537: -- Default = FND_API.G_FALSE
538: -- p_commit IN VARCHAR2 Optional
539: -- Default = FND_API.G_FALSE
540: -- p_validation_level IN NUMBER Optional
541: -- Default = FND_API.G_VALID_LEVEL_NONE

Line 539: -- Default = FND_API.G_FALSE

535: -- IN : p_api_version IN NUMBER Required
536: -- p_init_msg_list IN VARCHAR2 Optional
537: -- Default = FND_API.G_FALSE
538: -- p_commit IN VARCHAR2 Optional
539: -- Default = FND_API.G_FALSE
540: -- p_validation_level IN NUMBER Optional
541: -- Default = FND_API.G_VALID_LEVEL_NONE
542: -- p_worksheet_id IN NUMBER Required
543: -- p_global_worksheet IN VARCHAR2 Optional

Line 541: -- Default = FND_API.G_VALID_LEVEL_NONE

537: -- Default = FND_API.G_FALSE
538: -- p_commit IN VARCHAR2 Optional
539: -- Default = FND_API.G_FALSE
540: -- p_validation_level IN NUMBER Optional
541: -- Default = FND_API.G_VALID_LEVEL_NONE
542: -- p_worksheet_id IN NUMBER Required
543: -- p_global_worksheet IN VARCHAR2 Optional
544: -- Default = FND_API.G_MISS_CHAR
545: -- p_budget_group_id IN NUMBER Optional

Line 544: -- Default = FND_API.G_MISS_CHAR

540: -- p_validation_level IN NUMBER Optional
541: -- Default = FND_API.G_VALID_LEVEL_NONE
542: -- p_worksheet_id IN NUMBER Required
543: -- p_global_worksheet IN VARCHAR2 Optional
544: -- Default = FND_API.G_MISS_CHAR
545: -- p_budget_group_id IN NUMBER Optional
546: -- Default = FND_API.G_MISS_NUM
547: -- p_data_extract_id IN NUMBER Optional
548: -- Default = FND_API.G_MISS_NUM

Line 546: -- Default = FND_API.G_MISS_NUM

542: -- p_worksheet_id IN NUMBER Required
543: -- p_global_worksheet IN VARCHAR2 Optional
544: -- Default = FND_API.G_MISS_CHAR
545: -- p_budget_group_id IN NUMBER Optional
546: -- Default = FND_API.G_MISS_NUM
547: -- p_data_extract_id IN NUMBER Optional
548: -- Default = FND_API.G_MISS_NUM
549: -- p_business_group_id IN NUMBER Optional
550: -- Default = FND_API.G_MISS_NUM

Line 548: -- Default = FND_API.G_MISS_NUM

544: -- Default = FND_API.G_MISS_CHAR
545: -- p_budget_group_id IN NUMBER Optional
546: -- Default = FND_API.G_MISS_NUM
547: -- p_data_extract_id IN NUMBER Optional
548: -- Default = FND_API.G_MISS_NUM
549: -- p_business_group_id IN NUMBER Optional
550: -- Default = FND_API.G_MISS_NUM
551: -- p_func_currency IN VARCHAR2 Optional
552: -- Default = FND_API.G_MISS_CHAR

Line 550: -- Default = FND_API.G_MISS_NUM

546: -- Default = FND_API.G_MISS_NUM
547: -- p_data_extract_id IN NUMBER Optional
548: -- Default = FND_API.G_MISS_NUM
549: -- p_business_group_id IN NUMBER Optional
550: -- Default = FND_API.G_MISS_NUM
551: -- p_func_currency IN VARCHAR2 Optional
552: -- Default = FND_API.G_MISS_CHAR
553: -- p_budget_calendar_id IN NUMBER Optional
554: -- Default = FND_API.G_MISS_NUM

Line 552: -- Default = FND_API.G_MISS_CHAR

548: -- Default = FND_API.G_MISS_NUM
549: -- p_business_group_id IN NUMBER Optional
550: -- Default = FND_API.G_MISS_NUM
551: -- p_func_currency IN VARCHAR2 Optional
552: -- Default = FND_API.G_MISS_CHAR
553: -- p_budget_calendar_id IN NUMBER Optional
554: -- Default = FND_API.G_MISS_NUM
555: -- p_parameter_set_id IN NUMBER Optional
556: -- Default = FND_API.G_MISS_NUM

Line 554: -- Default = FND_API.G_MISS_NUM

550: -- Default = FND_API.G_MISS_NUM
551: -- p_func_currency IN VARCHAR2 Optional
552: -- Default = FND_API.G_MISS_CHAR
553: -- p_budget_calendar_id IN NUMBER Optional
554: -- Default = FND_API.G_MISS_NUM
555: -- p_parameter_set_id IN NUMBER Optional
556: -- Default = FND_API.G_MISS_NUM
557: -- .
558: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)

Line 556: -- Default = FND_API.G_MISS_NUM

552: -- Default = FND_API.G_MISS_CHAR
553: -- p_budget_calendar_id IN NUMBER Optional
554: -- Default = FND_API.G_MISS_NUM
555: -- p_parameter_set_id IN NUMBER Optional
556: -- Default = FND_API.G_MISS_NUM
557: -- .
558: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)
559: -- p_msg_count OUT NOCOPY NUMBER
560: -- p_msg_data OUT NOCOPY VARCHAR2(2000)

Line 572: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

568: --
569:
570: PROCEDURE Apply_Position_Parameters
571: ( p_api_version IN NUMBER,
572: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
573: p_commit IN VARCHAR2 := FND_API.G_FALSE,
574: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
575: p_return_status OUT NOCOPY VARCHAR2,
576: p_msg_count OUT NOCOPY NUMBER,

Line 573: p_commit IN VARCHAR2 := FND_API.G_FALSE,

569:
570: PROCEDURE Apply_Position_Parameters
571: ( p_api_version IN NUMBER,
572: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
573: p_commit IN VARCHAR2 := FND_API.G_FALSE,
574: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
575: p_return_status OUT NOCOPY VARCHAR2,
576: p_msg_count OUT NOCOPY NUMBER,
577: p_msg_data OUT NOCOPY VARCHAR2,

Line 574: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

570: PROCEDURE Apply_Position_Parameters
571: ( p_api_version IN NUMBER,
572: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
573: p_commit IN VARCHAR2 := FND_API.G_FALSE,
574: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
575: p_return_status OUT NOCOPY VARCHAR2,
576: p_msg_count OUT NOCOPY NUMBER,
577: p_msg_data OUT NOCOPY VARCHAR2,
578: p_worksheet_id IN NUMBER,

Line 579: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,

575: p_return_status OUT NOCOPY VARCHAR2,
576: p_msg_count OUT NOCOPY NUMBER,
577: p_msg_data OUT NOCOPY VARCHAR2,
578: p_worksheet_id IN NUMBER,
579: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
580: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
581: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
582: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
583: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 580: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,

576: p_msg_count OUT NOCOPY NUMBER,
577: p_msg_data OUT NOCOPY VARCHAR2,
578: p_worksheet_id IN NUMBER,
579: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
580: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
581: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
582: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
583: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
584: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,

Line 581: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,

577: p_msg_data OUT NOCOPY VARCHAR2,
578: p_worksheet_id IN NUMBER,
579: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
580: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
581: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
582: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
583: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
584: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
585: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM

Line 582: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,

578: p_worksheet_id IN NUMBER,
579: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
580: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
581: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
582: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
583: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
584: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
585: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
586: );

Line 583: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,

579: p_global_worksheet IN VARCHAR2 := FND_API.G_MISS_CHAR,
580: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
581: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
582: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
583: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
584: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
585: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
586: );
587:

Line 584: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,

580: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
581: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
582: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
583: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
584: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
585: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
586: );
587:
588: /* ----------------------------------------------------------------------- */

Line 585: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM

581: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
582: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
583: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
584: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
585: p_parameter_set_id IN NUMBER := FND_API.G_MISS_NUM
586: );
587:
588: /* ----------------------------------------------------------------------- */
589:

Line 592: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS2

588: /* ----------------------------------------------------------------------- */
589:
590: -- API name : Calculate_Position_Cost
591: -- Type : Private
592: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS2
593: -- Parameters :
594: -- IN : p_api_version IN NUMBER Required
595: -- p_init_msg_list IN VARCHAR2 Optional
596: -- Default = FND_API.G_FALSE

Line 596: -- Default = FND_API.G_FALSE

592: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_POS2
593: -- Parameters :
594: -- IN : p_api_version IN NUMBER Required
595: -- p_init_msg_list IN VARCHAR2 Optional
596: -- Default = FND_API.G_FALSE
597: -- p_commit IN VARCHAR2 Optional
598: -- Default = FND_API.G_FALSE
599: -- p_validation_level IN NUMBER Optional
600: -- Default = FND_API.G_VALID_LEVEL_NONE

Line 598: -- Default = FND_API.G_FALSE

594: -- IN : p_api_version IN NUMBER Required
595: -- p_init_msg_list IN VARCHAR2 Optional
596: -- Default = FND_API.G_FALSE
597: -- p_commit IN VARCHAR2 Optional
598: -- Default = FND_API.G_FALSE
599: -- p_validation_level IN NUMBER Optional
600: -- Default = FND_API.G_VALID_LEVEL_NONE
601: -- p_worksheet_id IN NUMBER Required
602: -- p_position_line_id IN NUMBER Required

Line 600: -- Default = FND_API.G_VALID_LEVEL_NONE

596: -- Default = FND_API.G_FALSE
597: -- p_commit IN VARCHAR2 Optional
598: -- Default = FND_API.G_FALSE
599: -- p_validation_level IN NUMBER Optional
600: -- Default = FND_API.G_VALID_LEVEL_NONE
601: -- p_worksheet_id IN NUMBER Required
602: -- p_position_line_id IN NUMBER Required
603: -- p_recalculate_flag IN VARCHAR2 Optional
604: -- Default = FND_API.G_MISS_TRUE

Line 604: -- Default = FND_API.G_MISS_TRUE

600: -- Default = FND_API.G_VALID_LEVEL_NONE
601: -- p_worksheet_id IN NUMBER Required
602: -- p_position_line_id IN NUMBER Required
603: -- p_recalculate_flag IN VARCHAR2 Optional
604: -- Default = FND_API.G_MISS_TRUE
605: -- p_root_budget_group_id IN NUMBER Optional
606: -- Default = FND_API.G_MISS_NUM
607: -- p_global_worksheet_id IN NUMBER Optional
608: -- Default = FND_API.G_MISS_NUM

Line 606: -- Default = FND_API.G_MISS_NUM

602: -- p_position_line_id IN NUMBER Required
603: -- p_recalculate_flag IN VARCHAR2 Optional
604: -- Default = FND_API.G_MISS_TRUE
605: -- p_root_budget_group_id IN NUMBER Optional
606: -- Default = FND_API.G_MISS_NUM
607: -- p_global_worksheet_id IN NUMBER Optional
608: -- Default = FND_API.G_MISS_NUM
609: -- p_assign_worksheet_id IN NUMBER Optional
610: -- Default = FND_API.G_MISS_NUM

Line 608: -- Default = FND_API.G_MISS_NUM

604: -- Default = FND_API.G_MISS_TRUE
605: -- p_root_budget_group_id IN NUMBER Optional
606: -- Default = FND_API.G_MISS_NUM
607: -- p_global_worksheet_id IN NUMBER Optional
608: -- Default = FND_API.G_MISS_NUM
609: -- p_assign_worksheet_id IN NUMBER Optional
610: -- Default = FND_API.G_MISS_NUM
611: -- p_worksheet_numyrs IN NUMBER Optional
612: -- Default = FND_API.G_MISS_NUM

Line 610: -- Default = FND_API.G_MISS_NUM

606: -- Default = FND_API.G_MISS_NUM
607: -- p_global_worksheet_id IN NUMBER Optional
608: -- Default = FND_API.G_MISS_NUM
609: -- p_assign_worksheet_id IN NUMBER Optional
610: -- Default = FND_API.G_MISS_NUM
611: -- p_worksheet_numyrs IN NUMBER Optional
612: -- Default = FND_API.G_MISS_NUM
613: -- p_rounding_factor IN NUMBER Optional
614: -- Default = FND_API.G_MISS_NUM

Line 612: -- Default = FND_API.G_MISS_NUM

608: -- Default = FND_API.G_MISS_NUM
609: -- p_assign_worksheet_id IN NUMBER Optional
610: -- Default = FND_API.G_MISS_NUM
611: -- p_worksheet_numyrs IN NUMBER Optional
612: -- Default = FND_API.G_MISS_NUM
613: -- p_rounding_factor IN NUMBER Optional
614: -- Default = FND_API.G_MISS_NUM
615: -- p_service_package_id IN NUMBER Optional
616: -- Default = FND_API.G_MISS_NUM

Line 614: -- Default = FND_API.G_MISS_NUM

610: -- Default = FND_API.G_MISS_NUM
611: -- p_worksheet_numyrs IN NUMBER Optional
612: -- Default = FND_API.G_MISS_NUM
613: -- p_rounding_factor IN NUMBER Optional
614: -- Default = FND_API.G_MISS_NUM
615: -- p_service_package_id IN NUMBER Optional
616: -- Default = FND_API.G_MISS_NUM
617: -- p_stage_set_id IN NUMBER Optional
618: -- Default = FND_API.G_MISS_NUM

Line 616: -- Default = FND_API.G_MISS_NUM

612: -- Default = FND_API.G_MISS_NUM
613: -- p_rounding_factor IN NUMBER Optional
614: -- Default = FND_API.G_MISS_NUM
615: -- p_service_package_id IN NUMBER Optional
616: -- Default = FND_API.G_MISS_NUM
617: -- p_stage_set_id IN NUMBER Optional
618: -- Default = FND_API.G_MISS_NUM
619: -- p_start_stage_seq IN NUMBER Optional
620: -- Default = FND_API.G_MISS_NUM

Line 618: -- Default = FND_API.G_MISS_NUM

614: -- Default = FND_API.G_MISS_NUM
615: -- p_service_package_id IN NUMBER Optional
616: -- Default = FND_API.G_MISS_NUM
617: -- p_stage_set_id IN NUMBER Optional
618: -- Default = FND_API.G_MISS_NUM
619: -- p_start_stage_seq IN NUMBER Optional
620: -- Default = FND_API.G_MISS_NUM
621: -- p_current_stage_seq IN NUMBER Optional
622: -- Default = FND_API.G_MISS_NUM

Line 620: -- Default = FND_API.G_MISS_NUM

616: -- Default = FND_API.G_MISS_NUM
617: -- p_stage_set_id IN NUMBER Optional
618: -- Default = FND_API.G_MISS_NUM
619: -- p_start_stage_seq IN NUMBER Optional
620: -- Default = FND_API.G_MISS_NUM
621: -- p_current_stage_seq IN NUMBER Optional
622: -- Default = FND_API.G_MISS_NUM
623: -- p_data_extract_id IN NUMBER Optional
624: -- Default = FND_API.G_MISS_NUM

Line 622: -- Default = FND_API.G_MISS_NUM

618: -- Default = FND_API.G_MISS_NUM
619: -- p_start_stage_seq IN NUMBER Optional
620: -- Default = FND_API.G_MISS_NUM
621: -- p_current_stage_seq IN NUMBER Optional
622: -- Default = FND_API.G_MISS_NUM
623: -- p_data_extract_id IN NUMBER Optional
624: -- Default = FND_API.G_MISS_NUM
625: -- p_business_group_id IN NUMBER Optional
626: -- Default = FND_API.G_MISS_NUM

Line 624: -- Default = FND_API.G_MISS_NUM

620: -- Default = FND_API.G_MISS_NUM
621: -- p_current_stage_seq IN NUMBER Optional
622: -- Default = FND_API.G_MISS_NUM
623: -- p_data_extract_id IN NUMBER Optional
624: -- Default = FND_API.G_MISS_NUM
625: -- p_business_group_id IN NUMBER Optional
626: -- Default = FND_API.G_MISS_NUM
627: -- p_budget_calendar_id IN NUMBER Optional
628: -- Default = FND_API.G_MISS_NUM

Line 626: -- Default = FND_API.G_MISS_NUM

622: -- Default = FND_API.G_MISS_NUM
623: -- p_data_extract_id IN NUMBER Optional
624: -- Default = FND_API.G_MISS_NUM
625: -- p_business_group_id IN NUMBER Optional
626: -- Default = FND_API.G_MISS_NUM
627: -- p_budget_calendar_id IN NUMBER Optional
628: -- Default = FND_API.G_MISS_NUM
629: -- p_func_currency IN VARCHAR2 Optional
630: -- Default = FND_API.G_MISS_CHAR

Line 628: -- Default = FND_API.G_MISS_NUM

624: -- Default = FND_API.G_MISS_NUM
625: -- p_business_group_id IN NUMBER Optional
626: -- Default = FND_API.G_MISS_NUM
627: -- p_budget_calendar_id IN NUMBER Optional
628: -- Default = FND_API.G_MISS_NUM
629: -- p_func_currency IN VARCHAR2 Optional
630: -- Default = FND_API.G_MISS_CHAR
631: -- p_flex_code IN NUMBER Optional
632: -- Default = FND_API.G_MISS_NUM

Line 630: -- Default = FND_API.G_MISS_CHAR

626: -- Default = FND_API.G_MISS_NUM
627: -- p_budget_calendar_id IN NUMBER Optional
628: -- Default = FND_API.G_MISS_NUM
629: -- p_func_currency IN VARCHAR2 Optional
630: -- Default = FND_API.G_MISS_CHAR
631: -- p_flex_code IN NUMBER Optional
632: -- Default = FND_API.G_MISS_NUM
633: -- p_position_id IN NUMBER Optional
634: -- Default = FND_API.G_MISS_NUM

Line 632: -- Default = FND_API.G_MISS_NUM

628: -- Default = FND_API.G_MISS_NUM
629: -- p_func_currency IN VARCHAR2 Optional
630: -- Default = FND_API.G_MISS_CHAR
631: -- p_flex_code IN NUMBER Optional
632: -- Default = FND_API.G_MISS_NUM
633: -- p_position_id IN NUMBER Optional
634: -- Default = FND_API.G_MISS_NUM
635: -- p_position_name IN NUMBER Optional
636: -- Default = FND_API.G_MISS_CHAR

Line 634: -- Default = FND_API.G_MISS_NUM

630: -- Default = FND_API.G_MISS_CHAR
631: -- p_flex_code IN NUMBER Optional
632: -- Default = FND_API.G_MISS_NUM
633: -- p_position_id IN NUMBER Optional
634: -- Default = FND_API.G_MISS_NUM
635: -- p_position_name IN NUMBER Optional
636: -- Default = FND_API.G_MISS_CHAR
637: -- p_position_start_date IN DATE Optional
638: -- Default = FND_API.G_MISS_DATE

Line 636: -- Default = FND_API.G_MISS_CHAR

632: -- Default = FND_API.G_MISS_NUM
633: -- p_position_id IN NUMBER Optional
634: -- Default = FND_API.G_MISS_NUM
635: -- p_position_name IN NUMBER Optional
636: -- Default = FND_API.G_MISS_CHAR
637: -- p_position_start_date IN DATE Optional
638: -- Default = FND_API.G_MISS_DATE
639: -- p_position_end_date IN DATE Optional
640: -- Default = FND_API.G_MISS_DATE

Line 638: -- Default = FND_API.G_MISS_DATE

634: -- Default = FND_API.G_MISS_NUM
635: -- p_position_name IN NUMBER Optional
636: -- Default = FND_API.G_MISS_CHAR
637: -- p_position_start_date IN DATE Optional
638: -- Default = FND_API.G_MISS_DATE
639: -- p_position_end_date IN DATE Optional
640: -- Default = FND_API.G_MISS_DATE
641: -- .
642: -- OUT NOCOPY :p_return_status OUT NOCOPY VARCHAR2(1)

Line 640: -- Default = FND_API.G_MISS_DATE

636: -- Default = FND_API.G_MISS_CHAR
637: -- p_position_start_date IN DATE Optional
638: -- Default = FND_API.G_MISS_DATE
639: -- p_position_end_date IN DATE Optional
640: -- Default = FND_API.G_MISS_DATE
641: -- .
642: -- OUT NOCOPY :p_return_status OUT NOCOPY VARCHAR2(1)
643: -- p_msg_count OUT NOCOPY NUMBER
644: -- p_msg_data OUT NOCOPY VARCHAR2(2000)

Line 651: -- If p_recalculate_flag is set to FND_API.G_TRUE,

647: -- Initial version 1.0
648: -- Created 01/04/1998 by Supriyo Ghosh
649: --
650: -- Notes : Calculate Position Cost for a Position Instance.
651: -- If p_recalculate_flag is set to FND_API.G_TRUE,
652: -- this process recalculates the Position Costs for the
653: -- Position Instance
654: --
655:

Line 658: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

654: --
655:
656: PROCEDURE Calculate_Position_Cost
657: ( p_api_version IN NUMBER,
658: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
659: p_commit IN VARCHAR2 := FND_API.G_FALSE,
660: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
661: p_return_status OUT NOCOPY VARCHAR2,
662: p_msg_count OUT NOCOPY NUMBER,

Line 659: p_commit IN VARCHAR2 := FND_API.G_FALSE,

655:
656: PROCEDURE Calculate_Position_Cost
657: ( p_api_version IN NUMBER,
658: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
659: p_commit IN VARCHAR2 := FND_API.G_FALSE,
660: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
661: p_return_status OUT NOCOPY VARCHAR2,
662: p_msg_count OUT NOCOPY NUMBER,
663: p_msg_data OUT NOCOPY VARCHAR2,

Line 660: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

656: PROCEDURE Calculate_Position_Cost
657: ( p_api_version IN NUMBER,
658: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
659: p_commit IN VARCHAR2 := FND_API.G_FALSE,
660: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
661: p_return_status OUT NOCOPY VARCHAR2,
662: p_msg_count OUT NOCOPY NUMBER,
663: p_msg_data OUT NOCOPY VARCHAR2,
664: p_worksheet_id IN NUMBER,

Line 666: p_recalculate_flag IN VARCHAR2 := FND_API.G_TRUE,

662: p_msg_count OUT NOCOPY NUMBER,
663: p_msg_data OUT NOCOPY VARCHAR2,
664: p_worksheet_id IN NUMBER,
665: p_position_line_id IN NUMBER,
666: p_recalculate_flag IN VARCHAR2 := FND_API.G_TRUE,
667: p_root_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
668: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
669: p_assign_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
670: p_worksheet_numyrs IN NUMBER := FND_API.G_MISS_NUM,

Line 667: p_root_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,

663: p_msg_data OUT NOCOPY VARCHAR2,
664: p_worksheet_id IN NUMBER,
665: p_position_line_id IN NUMBER,
666: p_recalculate_flag IN VARCHAR2 := FND_API.G_TRUE,
667: p_root_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
668: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
669: p_assign_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
670: p_worksheet_numyrs IN NUMBER := FND_API.G_MISS_NUM,
671: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,

Line 668: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

664: p_worksheet_id IN NUMBER,
665: p_position_line_id IN NUMBER,
666: p_recalculate_flag IN VARCHAR2 := FND_API.G_TRUE,
667: p_root_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
668: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
669: p_assign_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
670: p_worksheet_numyrs IN NUMBER := FND_API.G_MISS_NUM,
671: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
672: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,

Line 669: p_assign_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,

665: p_position_line_id IN NUMBER,
666: p_recalculate_flag IN VARCHAR2 := FND_API.G_TRUE,
667: p_root_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
668: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
669: p_assign_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
670: p_worksheet_numyrs IN NUMBER := FND_API.G_MISS_NUM,
671: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
672: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
673: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,

Line 670: p_worksheet_numyrs IN NUMBER := FND_API.G_MISS_NUM,

666: p_recalculate_flag IN VARCHAR2 := FND_API.G_TRUE,
667: p_root_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
668: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
669: p_assign_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
670: p_worksheet_numyrs IN NUMBER := FND_API.G_MISS_NUM,
671: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
672: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
673: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
674: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

Line 671: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,

667: p_root_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
668: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
669: p_assign_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
670: p_worksheet_numyrs IN NUMBER := FND_API.G_MISS_NUM,
671: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
672: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
673: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
674: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
675: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

Line 672: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,

668: p_global_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
669: p_assign_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
670: p_worksheet_numyrs IN NUMBER := FND_API.G_MISS_NUM,
671: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
672: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
673: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
674: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
675: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
676: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,

Line 673: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,

669: p_assign_worksheet_id IN NUMBER := FND_API.G_MISS_NUM,
670: p_worksheet_numyrs IN NUMBER := FND_API.G_MISS_NUM,
671: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
672: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
673: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
674: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
675: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
676: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
677: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,

Line 674: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

670: p_worksheet_numyrs IN NUMBER := FND_API.G_MISS_NUM,
671: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
672: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
673: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
674: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
675: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
676: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
677: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
678: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,

Line 675: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,

671: p_rounding_factor IN NUMBER := FND_API.G_MISS_NUM,
672: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
673: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
674: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
675: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
676: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
677: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
678: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
679: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 676: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,

672: p_service_package_id IN NUMBER := FND_API.G_MISS_NUM,
673: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
674: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
675: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
676: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
677: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
678: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
679: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
680: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,

Line 677: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,

673: p_stage_set_id IN NUMBER := FND_API.G_MISS_NUM,
674: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
675: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
676: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
677: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
678: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
679: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
680: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
681: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,

Line 678: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,

674: p_start_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
675: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
676: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
677: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
678: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
679: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
680: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
681: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
682: p_position_id IN NUMBER := FND_API.G_MISS_NUM,

Line 679: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,

675: p_current_stage_seq IN NUMBER := FND_API.G_MISS_NUM,
676: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
677: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
678: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
679: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
680: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
681: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
682: p_position_id IN NUMBER := FND_API.G_MISS_NUM,
683: p_position_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 680: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,

676: p_data_extract_id IN NUMBER := FND_API.G_MISS_NUM,
677: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
678: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
679: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
680: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
681: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
682: p_position_id IN NUMBER := FND_API.G_MISS_NUM,
683: p_position_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_position_start_date IN DATE := FND_API.G_MISS_DATE,

Line 681: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,

677: p_business_group_id IN NUMBER := FND_API.G_MISS_NUM,
678: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
679: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
680: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
681: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
682: p_position_id IN NUMBER := FND_API.G_MISS_NUM,
683: p_position_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_position_start_date IN DATE := FND_API.G_MISS_DATE,
685: p_position_end_date IN DATE := FND_API.G_MISS_DATE

Line 682: p_position_id IN NUMBER := FND_API.G_MISS_NUM,

678: p_budget_calendar_id IN NUMBER := FND_API.G_MISS_NUM,
679: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
680: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
681: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
682: p_position_id IN NUMBER := FND_API.G_MISS_NUM,
683: p_position_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_position_start_date IN DATE := FND_API.G_MISS_DATE,
685: p_position_end_date IN DATE := FND_API.G_MISS_DATE
686: );

Line 683: p_position_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

679: p_func_currency IN VARCHAR2 := FND_API.G_MISS_CHAR,
680: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
681: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
682: p_position_id IN NUMBER := FND_API.G_MISS_NUM,
683: p_position_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_position_start_date IN DATE := FND_API.G_MISS_DATE,
685: p_position_end_date IN DATE := FND_API.G_MISS_DATE
686: );
687:

Line 684: p_position_start_date IN DATE := FND_API.G_MISS_DATE,

680: p_flex_mapping_set_id IN NUMBER := FND_API.G_MISS_NUM,
681: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
682: p_position_id IN NUMBER := FND_API.G_MISS_NUM,
683: p_position_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_position_start_date IN DATE := FND_API.G_MISS_DATE,
685: p_position_end_date IN DATE := FND_API.G_MISS_DATE
686: );
687:
688: /* ----------------------------------------------------------------------- */

Line 685: p_position_end_date IN DATE := FND_API.G_MISS_DATE

681: p_flex_code IN NUMBER := FND_API.G_MISS_NUM,
682: p_position_id IN NUMBER := FND_API.G_MISS_NUM,
683: p_position_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
684: p_position_start_date IN DATE := FND_API.G_MISS_DATE,
685: p_position_end_date IN DATE := FND_API.G_MISS_DATE
686: );
687:
688: /* ----------------------------------------------------------------------- */
689:

Line 692: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT2

688: /* ----------------------------------------------------------------------- */
689:
690: -- API name : Revise_Position_Projections
691: -- Type : Private
692: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT2
693: -- Parameters :
694: -- IN : p_api_version IN NUMBER Required
695: -- p_init_msg_list IN VARCHAR2 Optional
696: -- Default = FND_API.G_FALSE

Line 696: -- Default = FND_API.G_FALSE

692: -- Pre-reqs : FND_API, FND_MESSAGE, PSB_WS_ACCT2
693: -- Parameters :
694: -- IN : p_api_version IN NUMBER Required
695: -- p_init_msg_list IN VARCHAR2 Optional
696: -- Default = FND_API.G_FALSE
697: -- p_commit IN VARCHAR2 Optional
698: -- Default = FND_API.G_FALSE
699: -- p_validation_level IN NUMBER Optional
700: -- Default = FND_API.G_VALID_LEVEL_NONE

Line 698: -- Default = FND_API.G_FALSE

694: -- IN : p_api_version IN NUMBER Required
695: -- p_init_msg_list IN VARCHAR2 Optional
696: -- Default = FND_API.G_FALSE
697: -- p_commit IN VARCHAR2 Optional
698: -- Default = FND_API.G_FALSE
699: -- p_validation_level IN NUMBER Optional
700: -- Default = FND_API.G_VALID_LEVEL_NONE
701: -- p_worksheet_id IN NUMBER Required
702: -- p_parameter_id IN NUMBER Required

Line 700: -- Default = FND_API.G_VALID_LEVEL_NONE

696: -- Default = FND_API.G_FALSE
697: -- p_commit IN VARCHAR2 Optional
698: -- Default = FND_API.G_FALSE
699: -- p_validation_level IN NUMBER Optional
700: -- Default = FND_API.G_VALID_LEVEL_NONE
701: -- p_worksheet_id IN NUMBER Required
702: -- p_parameter_id IN NUMBER Required
703: -- .
704: -- OUT NOCOPY : p_return_status OUT NOCOPY VARCHAR2(1)

Line 715: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

711: --
712:
713: PROCEDURE Revise_Position_Projections
714: ( p_api_version IN NUMBER,
715: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
716: p_commit IN VARCHAR2 := FND_API.G_FALSE,
717: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
718: p_return_status OUT NOCOPY VARCHAR2,
719: p_msg_count OUT NOCOPY NUMBER,

Line 716: p_commit IN VARCHAR2 := FND_API.G_FALSE,

712:
713: PROCEDURE Revise_Position_Projections
714: ( p_api_version IN NUMBER,
715: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
716: p_commit IN VARCHAR2 := FND_API.G_FALSE,
717: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
718: p_return_status OUT NOCOPY VARCHAR2,
719: p_msg_count OUT NOCOPY NUMBER,
720: p_msg_data OUT NOCOPY VARCHAR2,

Line 717: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

713: PROCEDURE Revise_Position_Projections
714: ( p_api_version IN NUMBER,
715: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
716: p_commit IN VARCHAR2 := FND_API.G_FALSE,
717: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
718: p_return_status OUT NOCOPY VARCHAR2,
719: p_msg_count OUT NOCOPY NUMBER,
720: p_msg_data OUT NOCOPY VARCHAR2,
721: p_worksheet_id IN NUMBER,

Line 764: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

760: );
761:
762: PROCEDURE Revise_Element_Projections
763: ( p_api_version IN NUMBER,
764: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
765: p_commit IN VARCHAR2 := FND_API.G_FALSE,
766: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
767: p_return_status OUT NOCOPY VARCHAR2,
768: p_msg_count OUT NOCOPY NUMBER,

Line 765: p_commit IN VARCHAR2 := FND_API.G_FALSE,

761:
762: PROCEDURE Revise_Element_Projections
763: ( p_api_version IN NUMBER,
764: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
765: p_commit IN VARCHAR2 := FND_API.G_FALSE,
766: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
767: p_return_status OUT NOCOPY VARCHAR2,
768: p_msg_count OUT NOCOPY NUMBER,
769: p_msg_data OUT NOCOPY VARCHAR2,

Line 766: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

762: PROCEDURE Revise_Element_Projections
763: ( p_api_version IN NUMBER,
764: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
765: p_commit IN VARCHAR2 := FND_API.G_FALSE,
766: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
767: p_return_status OUT NOCOPY VARCHAR2,
768: p_msg_count OUT NOCOPY NUMBER,
769: p_msg_data OUT NOCOPY VARCHAR2,
770: p_worksheet_id IN NUMBER,