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 PSB_WORKSHEETS

Line 34: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

30: p_return_status OUT NOCOPY VARCHAR2 ,
31: p_msg_count OUT NOCOPY NUMBER ,
32: p_msg_data OUT NOCOPY VARCHAR2 ,
33: --
34: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
35: p_parent_or_child_mode IN VARCHAR2 ,
36: p_maintenance_mode IN VARCHAR2 := 'MAINTENANCE'
37: );
38:

Line 50: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

46: p_return_status OUT NOCOPY VARCHAR2 ,
47: p_msg_count OUT NOCOPY NUMBER ,
48: p_msg_data OUT NOCOPY VARCHAR2 ,
49: --
50: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
51: p_operation_type IN VARCHAR2
52: );
53:
54:

Line 65: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

61: p_return_status OUT NOCOPY VARCHAR2 ,
62: p_msg_count OUT NOCOPY NUMBER ,
63: p_msg_data OUT NOCOPY VARCHAR2 ,
64: --
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 ,

Line 66: p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,

62: p_msg_count OUT NOCOPY NUMBER ,
63: p_msg_data OUT NOCOPY VARCHAR2 ,
64: --
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

Line 70: p_worksheet_id_OUT OUT NOCOPY 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:
74: PROCEDURE Create_Worksheet

Line 84: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

80: p_return_status OUT NOCOPY VARCHAR2 ,
81: p_msg_count OUT NOCOPY NUMBER ,
82: p_msg_data OUT NOCOPY VARCHAR2 ,
83: --
84: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
85: p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,
86: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
87: );
88:

Line 85: p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,

81: p_msg_count OUT NOCOPY NUMBER ,
82: p_msg_data OUT NOCOPY VARCHAR2 ,
83: --
84: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
85: p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,
86: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
87: );
88:
89:

Line 86: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE

82: p_msg_data OUT NOCOPY VARCHAR2 ,
83: --
84: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
85: p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,
86: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
87: );
88:
89:
90: PROCEDURE Copy_Worksheet

Line 100: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

96: p_return_status OUT NOCOPY VARCHAR2 ,
97: p_msg_count OUT NOCOPY NUMBER ,
98: p_msg_data OUT NOCOPY VARCHAR2 ,
99: --
100: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
101: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
102: );
103:
104:

Line 101: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE

97: p_msg_count OUT NOCOPY NUMBER ,
98: p_msg_data OUT NOCOPY VARCHAR2 ,
99: --
100: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
101: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
102: );
103:
104:
105: PROCEDURE Merge_Worksheets

Line 115: p_source_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

111: p_return_status OUT NOCOPY VARCHAR2 ,
112: p_msg_count OUT NOCOPY NUMBER ,
113: p_msg_data OUT NOCOPY VARCHAR2 ,
114: --
115: p_source_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
116: p_target_worksheet_id IN psb_worksheets.worksheet_id%TYPE
117: );
118:
119:

Line 116: p_target_worksheet_id IN psb_worksheets.worksheet_id%TYPE

112: p_msg_count OUT NOCOPY NUMBER ,
113: p_msg_data OUT NOCOPY VARCHAR2 ,
114: --
115: p_source_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
116: p_target_worksheet_id IN psb_worksheets.worksheet_id%TYPE
117: );
118:
119:
120: PROCEDURE Delete_Worksheet

Line 130: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

126: p_return_status OUT NOCOPY VARCHAR2 ,
127: p_msg_count OUT NOCOPY NUMBER ,
128: p_msg_data OUT NOCOPY VARCHAR2 ,
129: --
130: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
131: p_keep_local_copy_flag IN VARCHAR2 := 'N'
132: );
133:
134:

Line 145: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

141: p_return_status OUT NOCOPY VARCHAR2 ,
142: p_msg_count OUT NOCOPY NUMBER ,
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:

Line 189: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

185: p_return_status OUT NOCOPY VARCHAR2 ,
186: p_msg_count OUT NOCOPY NUMBER ,
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:

Line 220: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

216: p_return_status OUT NOCOPY VARCHAR2 ,
217: p_msg_count OUT NOCOPY NUMBER ,
218: p_msg_data OUT NOCOPY VARCHAR2 ,
219: --
220: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
221: p_freeze_flag IN psb_ws_lines.freeze_flag%TYPE
222: );
223:
224:

Line 235: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

231: p_return_status OUT NOCOPY VARCHAR2 ,
232: p_msg_count OUT NOCOPY NUMBER ,
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: );

Line 236: p_stage_seq IN psb_worksheets.current_stage_seq%TYPE

232: p_msg_count OUT NOCOPY NUMBER ,
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:

Line 253: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

249: p_return_status OUT NOCOPY VARCHAR2 ,
250: p_msg_count OUT NOCOPY NUMBER ,
251: p_msg_data OUT NOCOPY VARCHAR2 ,
252: --
253: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
254: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
255: );
256:
257:

Line 254: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE

250: p_msg_count OUT NOCOPY NUMBER ,
251: p_msg_data OUT NOCOPY VARCHAR2 ,
252: --
253: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
254: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE
255: );
256:
257:
258: PROCEDURE Find_Parent_Worksheets

Line 268: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

264: p_return_status OUT NOCOPY VARCHAR2 ,
265: p_msg_count OUT NOCOPY NUMBER ,
266: p_msg_data OUT NOCOPY VARCHAR2 ,
267: --
268: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
269: p_worksheet_tbl IN OUT NOCOPY Worksheet_Tbl_Type
270: );
271:
272:

Line 282: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

278: p_return_status OUT NOCOPY VARCHAR2 ,
279: p_msg_count OUT NOCOPY NUMBER ,
280: p_msg_data OUT NOCOPY VARCHAR2 ,
281: --
282: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
283: p_worksheet_tbl IN OUT NOCOPY Worksheet_Tbl_Type
284: );
285:
286:

Line 297: p_source_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

293: p_return_status OUT NOCOPY VARCHAR2 ,
294: p_msg_count OUT NOCOPY NUMBER ,
295: p_msg_data OUT NOCOPY VARCHAR2 ,
296: --
297: p_source_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
298: p_target_worksheet_id IN psb_worksheets.worksheet_id%TYPE
299: );
300:
301:

Line 298: p_target_worksheet_id IN psb_worksheets.worksheet_id%TYPE

294: p_msg_count OUT NOCOPY NUMBER ,
295: p_msg_data OUT NOCOPY VARCHAR2 ,
296: --
297: p_source_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,
298: p_target_worksheet_id IN psb_worksheets.worksheet_id%TYPE
299: );
300:
301:
302: PROCEDURE Delete_Worksheet_CP

Line 322: p_worksheet_id IN psb_worksheets.worksheet_id%TYPE ,

318: p_return_status OUT NOCOPY VARCHAR2 ,
319: p_msg_count OUT NOCOPY NUMBER ,
320: p_msg_data OUT NOCOPY VARCHAR2 ,
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

Line 323: p_budget_group_id IN psb_worksheets.budget_group_id%TYPE ,

319: p_msg_count OUT NOCOPY NUMBER ,
320: p_msg_data OUT NOCOPY VARCHAR2 ,
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: );

Line 326: p_worksheet_id_OUT OUT NOCOPY psb_worksheets.worksheet_id%TYPE

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:
330: END PSB_WS_Ops_Pvt ;