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_OPS_PVT dependencies on FND_API

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

23:
24: PROCEDURE Enforce_WS_Concurrency
25: (
26: p_api_version IN NUMBER ,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
30: p_return_status OUT NOCOPY VARCHAR2 ,
31: p_msg_count OUT NOCOPY NUMBER ,

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

24: PROCEDURE Enforce_WS_Concurrency
25: (
26: p_api_version IN NUMBER ,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
30: p_return_status OUT NOCOPY VARCHAR2 ,
31: p_msg_count OUT NOCOPY NUMBER ,
32: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

25: (
26: p_api_version IN NUMBER ,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
29: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
30: p_return_status OUT NOCOPY VARCHAR2 ,
31: p_msg_count OUT NOCOPY NUMBER ,
32: p_msg_data OUT NOCOPY VARCHAR2 ,
33: --

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

39:
40: PROCEDURE Check_WS_Ops_Concurrency
41: (
42: p_api_version IN NUMBER ,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
46: p_return_status OUT NOCOPY VARCHAR2 ,
47: p_msg_count OUT NOCOPY NUMBER ,

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

40: PROCEDURE Check_WS_Ops_Concurrency
41: (
42: p_api_version IN NUMBER ,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
46: p_return_status OUT NOCOPY VARCHAR2 ,
47: p_msg_count OUT NOCOPY NUMBER ,
48: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

41: (
42: p_api_version IN NUMBER ,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
46: p_return_status OUT NOCOPY VARCHAR2 ,
47: p_msg_count OUT NOCOPY NUMBER ,
48: p_msg_data OUT NOCOPY VARCHAR2 ,
49: --

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

54:
55: PROCEDURE Create_Worksheet
56: (
57: p_api_version IN NUMBER ,
58: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
59: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
60: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
61: p_return_status OUT NOCOPY VARCHAR2 ,
62: p_msg_count OUT NOCOPY NUMBER ,

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

55: PROCEDURE Create_Worksheet
56: (
57: p_api_version IN NUMBER ,
58: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
59: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
60: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
61: p_return_status OUT NOCOPY VARCHAR2 ,
62: p_msg_count OUT NOCOPY NUMBER ,
63: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 60: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

56: (
57: p_api_version IN NUMBER ,
58: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
59: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
60: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
61: p_return_status OUT NOCOPY VARCHAR2 ,
62: p_msg_count OUT NOCOPY NUMBER ,
63: p_msg_data OUT NOCOPY VARCHAR2 ,
64: --

Line 69: IN NUMBER := FND_API.G_MISS_NUM ,

65: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
66: p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,
67: p_account_position_set_tbl IN account_position_set_tbl_type ,
68: p_service_package_operation_id
69: IN NUMBER := FND_API.G_MISS_NUM ,
70: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
71: );
72:
73:

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

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

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

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

Line 79: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

75: (
76: p_api_version IN NUMBER ,
77: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
78: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
79: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
80: p_return_status OUT NOCOPY VARCHAR2 ,
81: p_msg_count OUT NOCOPY NUMBER ,
82: p_msg_data OUT NOCOPY VARCHAR2 ,
83: --

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

89:
90: PROCEDURE Copy_Worksheet
91: (
92: p_api_version IN NUMBER ,
93: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
94: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
95: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
96: p_return_status OUT NOCOPY VARCHAR2 ,
97: p_msg_count OUT NOCOPY NUMBER ,

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

90: PROCEDURE Copy_Worksheet
91: (
92: p_api_version IN NUMBER ,
93: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
94: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
95: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
96: p_return_status OUT NOCOPY VARCHAR2 ,
97: p_msg_count OUT NOCOPY NUMBER ,
98: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 95: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

91: (
92: p_api_version IN NUMBER ,
93: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
94: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
95: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
96: p_return_status OUT NOCOPY VARCHAR2 ,
97: p_msg_count OUT NOCOPY NUMBER ,
98: p_msg_data OUT NOCOPY VARCHAR2 ,
99: --

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

104:
105: PROCEDURE Merge_Worksheets
106: (
107: p_api_version IN NUMBER ,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
111: p_return_status OUT NOCOPY VARCHAR2 ,
112: p_msg_count OUT NOCOPY NUMBER ,

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

105: PROCEDURE Merge_Worksheets
106: (
107: p_api_version IN NUMBER ,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
111: p_return_status OUT NOCOPY VARCHAR2 ,
112: p_msg_count OUT NOCOPY NUMBER ,
113: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

106: (
107: p_api_version IN NUMBER ,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
111: p_return_status OUT NOCOPY VARCHAR2 ,
112: p_msg_count OUT NOCOPY NUMBER ,
113: p_msg_data OUT NOCOPY VARCHAR2 ,
114: --

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

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

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

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

Line 125: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

121: (
122: p_api_version IN NUMBER ,
123: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
124: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
125: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
126: p_return_status OUT NOCOPY VARCHAR2 ,
127: p_msg_count OUT NOCOPY NUMBER ,
128: p_msg_data OUT NOCOPY VARCHAR2 ,
129: --

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

134:
135: PROCEDURE Add_Worksheet_Line
136: (
137: p_api_version IN NUMBER ,
138: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
139: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
141: p_return_status OUT NOCOPY VARCHAR2 ,
142: p_msg_count OUT NOCOPY NUMBER ,

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

135: PROCEDURE Add_Worksheet_Line
136: (
137: p_api_version IN NUMBER ,
138: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
139: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
141: p_return_status OUT NOCOPY VARCHAR2 ,
142: p_msg_count OUT NOCOPY NUMBER ,
143: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

136: (
137: p_api_version IN NUMBER ,
138: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
139: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
141: p_return_status OUT NOCOPY VARCHAR2 ,
142: p_msg_count OUT NOCOPY NUMBER ,
143: p_msg_data OUT NOCOPY VARCHAR2 ,
144: --

Line 147: p_add_in_current_worksheet IN VARCHAR2 := FND_API.G_FALSE

143: p_msg_data OUT NOCOPY VARCHAR2 ,
144: --
145: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
146: p_account_line_id IN psb_ws_account_lines.account_line_id%TYPE,
147: p_add_in_current_worksheet IN VARCHAR2 := FND_API.G_FALSE
148: );
149:
150:
151: PROCEDURE Add_Worksheet_Line

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

149:
150:
151: PROCEDURE Add_Worksheet_Line
152: ( p_api_version IN NUMBER ,
153: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
154: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
156: p_return_status OUT NOCOPY VARCHAR2 ,
157: p_msg_count OUT NOCOPY NUMBER ,

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

150:
151: PROCEDURE Add_Worksheet_Line
152: ( p_api_version IN NUMBER ,
153: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
154: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
156: p_return_status OUT NOCOPY VARCHAR2 ,
157: p_msg_count OUT NOCOPY NUMBER ,
158: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

151: PROCEDURE Add_Worksheet_Line
152: ( p_api_version IN NUMBER ,
153: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
154: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
155: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
156: p_return_status OUT NOCOPY VARCHAR2 ,
157: p_msg_count OUT NOCOPY NUMBER ,
158: p_msg_data OUT NOCOPY VARCHAR2 ,
159: p_worksheet_id IN NUMBER,

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

163:
164: PROCEDURE Add_Line_To_Worksheets
165: (
166: p_api_version IN NUMBER ,
167: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
168: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
169: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
170: p_return_status OUT NOCOPY VARCHAR2 ,
171: p_msg_count OUT NOCOPY NUMBER ,

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

164: PROCEDURE Add_Line_To_Worksheets
165: (
166: p_api_version IN NUMBER ,
167: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
168: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
169: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
170: p_return_status OUT NOCOPY VARCHAR2 ,
171: p_msg_count OUT NOCOPY NUMBER ,
172: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 169: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

165: (
166: p_api_version IN NUMBER ,
167: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
168: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
169: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
170: p_return_status OUT NOCOPY VARCHAR2 ,
171: p_msg_count OUT NOCOPY NUMBER ,
172: p_msg_data OUT NOCOPY VARCHAR2 ,
173: --

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

178:
179: PROCEDURE Add_Worksheet_Position_Line
180: (
181: p_api_version IN NUMBER ,
182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
183: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
185: p_return_status OUT NOCOPY VARCHAR2 ,
186: p_msg_count OUT NOCOPY NUMBER ,

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

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

Line 184: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

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

Line 191: p_add_in_current_worksheet IN VARCHAR2 := FND_API.G_FALSE

187: p_msg_data OUT NOCOPY VARCHAR2 ,
188: --
189: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
190: p_position_line_id IN psb_ws_position_lines.position_line_id%TYPE,
191: p_add_in_current_worksheet IN VARCHAR2 := FND_API.G_FALSE
192: );
193:
194:
195: PROCEDURE Add_Pos_Line_To_Worksheets

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

194:
195: PROCEDURE Add_Pos_Line_To_Worksheets
196: (
197: p_api_version IN NUMBER ,
198: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
199: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
200: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
201: p_return_status OUT NOCOPY VARCHAR2 ,
202: p_msg_count OUT NOCOPY NUMBER ,

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

195: PROCEDURE Add_Pos_Line_To_Worksheets
196: (
197: p_api_version IN NUMBER ,
198: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
199: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
200: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
201: p_return_status OUT NOCOPY VARCHAR2 ,
202: p_msg_count OUT NOCOPY NUMBER ,
203: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 200: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

196: (
197: p_api_version IN NUMBER ,
198: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
199: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
200: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
201: p_return_status OUT NOCOPY VARCHAR2 ,
202: p_msg_count OUT NOCOPY NUMBER ,
203: p_msg_data OUT NOCOPY VARCHAR2 ,
204: --

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

209:
210: PROCEDURE Freeze_Worksheet
211: (
212: p_api_version IN NUMBER ,
213: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
214: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
216: p_return_status OUT NOCOPY VARCHAR2 ,
217: p_msg_count OUT NOCOPY NUMBER ,

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

210: PROCEDURE Freeze_Worksheet
211: (
212: p_api_version IN NUMBER ,
213: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
214: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
216: p_return_status OUT NOCOPY VARCHAR2 ,
217: p_msg_count OUT NOCOPY NUMBER ,
218: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

211: (
212: p_api_version IN NUMBER ,
213: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
214: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
215: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
216: p_return_status OUT NOCOPY VARCHAR2 ,
217: p_msg_count OUT NOCOPY NUMBER ,
218: p_msg_data OUT NOCOPY VARCHAR2 ,
219: --

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

224:
225: PROCEDURE Change_Worksheet_Stage
226: (
227: p_api_version IN NUMBER ,
228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
229: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
230: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
231: p_return_status OUT NOCOPY VARCHAR2 ,
232: p_msg_count OUT NOCOPY NUMBER ,

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

225: PROCEDURE Change_Worksheet_Stage
226: (
227: p_api_version IN NUMBER ,
228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
229: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
230: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
231: p_return_status OUT NOCOPY VARCHAR2 ,
232: p_msg_count OUT NOCOPY NUMBER ,
233: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 230: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

226: (
227: p_api_version IN NUMBER ,
228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
229: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
230: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
231: p_return_status OUT NOCOPY VARCHAR2 ,
232: p_msg_count OUT NOCOPY NUMBER ,
233: p_msg_data OUT NOCOPY VARCHAR2 ,
234: --

Line 237: := FND_API.G_MISS_NUM ,

233: p_msg_data OUT NOCOPY VARCHAR2 ,
234: --
235: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
236: p_stage_seq IN psb_worksheets.current_stage_seq%TYPE
237: := FND_API.G_MISS_NUM ,
238: p_operation_id IN NUMBER := FND_API.G_MISS_NUM
239: );
240:
241:

Line 238: p_operation_id IN NUMBER := FND_API.G_MISS_NUM

234: --
235: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
236: p_stage_seq IN psb_worksheets.current_stage_seq%TYPE
237: := FND_API.G_MISS_NUM ,
238: p_operation_id IN NUMBER := FND_API.G_MISS_NUM
239: );
240:
241:
242:

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

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

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

243: PROCEDURE Find_Parent_Worksheet
244: (
245: p_api_version IN NUMBER ,
246: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
247: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
249: p_return_status OUT NOCOPY VARCHAR2 ,
250: p_msg_count OUT NOCOPY NUMBER ,
251: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

244: (
245: p_api_version IN NUMBER ,
246: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
247: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
248: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
249: p_return_status OUT NOCOPY VARCHAR2 ,
250: p_msg_count OUT NOCOPY NUMBER ,
251: p_msg_data OUT NOCOPY VARCHAR2 ,
252: --

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

257:
258: PROCEDURE Find_Parent_Worksheets
259: (
260: p_api_version IN NUMBER ,
261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
262: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
264: p_return_status OUT NOCOPY VARCHAR2 ,
265: p_msg_count OUT NOCOPY NUMBER ,

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

258: PROCEDURE Find_Parent_Worksheets
259: (
260: p_api_version IN NUMBER ,
261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
262: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
264: p_return_status OUT NOCOPY VARCHAR2 ,
265: p_msg_count OUT NOCOPY NUMBER ,
266: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

259: (
260: p_api_version IN NUMBER ,
261: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
262: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
263: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
264: p_return_status OUT NOCOPY VARCHAR2 ,
265: p_msg_count OUT NOCOPY NUMBER ,
266: p_msg_data OUT NOCOPY VARCHAR2 ,
267: --

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

271:
272:
273: PROCEDURE Find_Child_Worksheets
274: ( p_api_version IN NUMBER,
275: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276: p_commit IN VARCHAR2 := FND_API.G_FALSE,
277: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
278: p_return_status OUT NOCOPY VARCHAR2 ,
279: p_msg_count OUT NOCOPY NUMBER ,

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

272:
273: PROCEDURE Find_Child_Worksheets
274: ( p_api_version IN NUMBER,
275: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276: p_commit IN VARCHAR2 := FND_API.G_FALSE,
277: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
278: p_return_status OUT NOCOPY VARCHAR2 ,
279: p_msg_count OUT NOCOPY NUMBER ,
280: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 277: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

273: PROCEDURE Find_Child_Worksheets
274: ( p_api_version IN NUMBER,
275: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276: p_commit IN VARCHAR2 := FND_API.G_FALSE,
277: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
278: p_return_status OUT NOCOPY VARCHAR2 ,
279: p_msg_count OUT NOCOPY NUMBER ,
280: p_msg_data OUT NOCOPY VARCHAR2 ,
281: --

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

286:
287: PROCEDURE Update_Worksheet
288: (
289: p_api_version IN NUMBER ,
290: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
291: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
293: p_return_status OUT NOCOPY VARCHAR2 ,
294: p_msg_count OUT NOCOPY NUMBER ,

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

287: PROCEDURE Update_Worksheet
288: (
289: p_api_version IN NUMBER ,
290: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
291: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
293: p_return_status OUT NOCOPY VARCHAR2 ,
294: p_msg_count OUT NOCOPY NUMBER ,
295: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

288: (
289: p_api_version IN NUMBER ,
290: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
291: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
293: p_return_status OUT NOCOPY VARCHAR2 ,
294: p_msg_count OUT NOCOPY NUMBER ,
295: p_msg_data OUT NOCOPY VARCHAR2 ,
296: --

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

311:
312: PROCEDURE Create_New_Position_Worksheet
313: (
314: p_api_version IN NUMBER ,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
317: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
318: p_return_status OUT NOCOPY VARCHAR2 ,
319: p_msg_count OUT NOCOPY NUMBER ,

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

312: PROCEDURE Create_New_Position_Worksheet
313: (
314: p_api_version IN NUMBER ,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
317: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
318: p_return_status OUT NOCOPY VARCHAR2 ,
319: p_msg_count OUT NOCOPY NUMBER ,
320: p_msg_data OUT NOCOPY VARCHAR2 ,

Line 317: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,

313: (
314: p_api_version IN NUMBER ,
315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
316: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
317: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
318: p_return_status OUT NOCOPY VARCHAR2 ,
319: p_msg_count OUT NOCOPY NUMBER ,
320: p_msg_data OUT NOCOPY VARCHAR2 ,
321: --

Line 325: IN NUMBER := FND_API.G_MISS_NUM ,

321: --
322: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
323: p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,
324: p_service_package_operation_id
325: IN NUMBER := FND_API.G_MISS_NUM ,
326: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
327: );
328:
329: