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.PA_PLANNING_RESOURCE_PUB dependencies on FND_API

Line 16: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

12: * pa_res_list_members_pkg.insert_row
13: * pa_planning_resource_utils. Get_Plan_Res_Combination
14: ****************************************************************/
15: PROCEDURE Create_Planning_Resource(
16: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
17: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
18: p_resource_list_id IN VARCHAR2,
19: P_planning_resource_in_tbl IN Planning_Resource_In_Tbl,
20: X_planning_resource_out_tbl OUT NOCOPY Planning_Resource_Out_Tbl,

Line 17: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

13: * pa_planning_resource_utils. Get_Plan_Res_Combination
14: ****************************************************************/
15: PROCEDURE Create_Planning_Resource(
16: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
17: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
18: p_resource_list_id IN VARCHAR2,
19: P_planning_resource_in_tbl IN Planning_Resource_In_Tbl,
20: X_planning_resource_out_tbl OUT NOCOPY Planning_Resource_Out_Tbl,
21: x_return_status OUT NOCOPY VARCHAR2,

Line 27: IF FND_API.to_boolean( p_init_msg_list )

23: x_error_msg_data OUT NOCOPY VARCHAR2 )
24: IS
25: BEGIN
26: -- First clear the message stack.
27: IF FND_API.to_boolean( p_init_msg_list )
28: THEN
29: FND_MSG_PUB.initialize;
30: END IF;
31:

Line 42: x_return_status := FND_API.G_RET_STS_SUCCESS;

38: /*************************************************
39: * Assigning Initial values for some of the elements.
40: *************************************************/
41: x_msg_count := 0;
42: x_return_status := FND_API.G_RET_STS_SUCCESS;
43: /******************************************************
44: * Call to pa_planning_resource_pvt.create_planning_resource
45: * which would take care of the validation and creation
46: * of the resource list members. The table elements are being passed as

Line 129: IF FND_API.to_boolean( p_commit )

125: END LOOP;
126: /************************************************
127: * Check the Commit flag. if it is true then Commit.
128: ***********************************************/
129: IF FND_API.to_boolean( p_commit )
130: THEN
131: COMMIT;
132: END IF;
133: /***************/

Line 216: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

212: p_bom_resource_name IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
213: p_team_role IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
214: p_incur_by_res_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
215: p_incur_by_res_type IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
216: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
217: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
218: p_project_id IN NUMBER DEFAULT NULL,
219: x_resource_list_member_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,
220: x_record_version_number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,

Line 217: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

213: p_team_role IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT NULL,
214: p_incur_by_res_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
215: p_incur_by_res_type IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL,
216: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
217: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
218: p_project_id IN NUMBER DEFAULT NULL,
219: x_resource_list_member_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,
220: x_record_version_number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,
221: x_return_status OUT NOCOPY VARCHAR2 ,

Line 232: IF FND_API.to_boolean(p_init_msg_list)

228: x_record_version_number.extend(p_res_format_id.count) ;
229: x_resource_list_member_id.extend(p_res_format_id.count) ;
230:
231: -- First clear the message stack.
232: IF FND_API.to_boolean(p_init_msg_list)
233: THEN
234: FND_MSG_PUB.initialize;
235: END IF;
236:

Line 247: x_return_status := FND_API.G_RET_STS_SUCCESS;

243: /*************************************************
244: * Assigning Initial values for some of the elements.
245: *************************************************/
246: x_msg_count := 0;
247: x_return_status := FND_API.G_RET_STS_SUCCESS;
248: /******************************************************
249: * Call to pa_planning_resource_pvt.create_planning_resource
250: * which would take care of the validation and creation
251: * of the resource list members. The table elements are being passed as

Line 328: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

324: x_return_status => x_return_status,
325: x_msg_count => x_msg_count,
326: x_error_msg_data => x_error_msg_data);
327:
328: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
329: RETURN;
330: END IF;
331: END LOOP;
332:

Line 336: IF FND_API.to_boolean( p_commit )

332:
333: /************************************************
334: * Check the Commit flag. if it is true then Commit.
335: ***********************************************/
336: IF FND_API.to_boolean( p_commit )
337: THEN
338: COMMIT;
339: END IF;
340: /***************/

Line 357: (p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

353: * Calls Prog : Pa_Planning_Resource_Utils.Get_Plan_Res_Combination
354: * pa_res_list_members_pkg.update_row
355: ******************************************************/
356: PROCEDURE Update_Planning_Resource
357: (p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
358: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
359: p_resource_list_id IN NUMBER,
360: p_enabled_flag IN VARCHAR2,
361: P_planning_resource_in_tbl IN Planning_Resource_In_Tbl,

Line 358: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

354: * pa_res_list_members_pkg.update_row
355: ******************************************************/
356: PROCEDURE Update_Planning_Resource
357: (p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
358: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
359: p_resource_list_id IN NUMBER,
360: p_enabled_flag IN VARCHAR2,
361: P_planning_resource_in_tbl IN Planning_Resource_In_Tbl,
362: X_planning_resource_out_tbl OUT NOCOPY Planning_Resource_Out_Tbl,

Line 370: IF FND_API.to_boolean( p_init_msg_list )

366: IS
367: BEGIN
368:
369: -- First clear the message stack.
370: IF FND_API.to_boolean( p_init_msg_list )
371: THEN
372: FND_MSG_PUB.initialize;
373: END IF;
374:

Line 378: x_return_status := FND_API.G_RET_STS_SUCCESS;

374:
375: FOR i IN 1..P_Planning_Resource_In_Tbl.COUNT
376: LOOP
377: x_msg_count := 0;
378: x_return_status := FND_API.G_RET_STS_SUCCESS;
379:
380: pa_planning_resource_pvt.Update_Planning_Resource(
381: p_resource_list_id => p_resource_list_id,
382: p_resource_list_member_id =>

Line 435: IF FND_API.to_boolean( p_commit )

431:
432: /************************************************
433: * Check the Commit flag. if it is true then Commit.
434: ***********************************************/
435: IF FND_API.to_boolean( p_commit )
436: THEN
437: COMMIT;
438: END IF;
439: /***************/

Line 483: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

479: p_attribute28 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
480: p_attribute29 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
481: p_attribute30 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
482: p_record_version_number IN SYSTEM.PA_NUM_TBL_TYPE ,
483: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
484: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
485: x_record_version_number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,
486: x_return_status OUT NOCOPY VARCHAR2 ,
487: x_msg_count OUT NOCOPY NUMBER ,

Line 484: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

480: p_attribute29 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
481: p_attribute30 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT NULL,
482: p_record_version_number IN SYSTEM.PA_NUM_TBL_TYPE ,
483: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
484: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
485: x_record_version_number OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE ,
486: x_return_status OUT NOCOPY VARCHAR2 ,
487: x_msg_count OUT NOCOPY NUMBER ,
488: x_error_msg_data OUT NOCOPY VARCHAR2 )

Line 492: IF FND_API.to_boolean( p_init_msg_list )

488: x_error_msg_data OUT NOCOPY VARCHAR2 )
489: IS
490: BEGIN
491: -- First clear the message stack.
492: IF FND_API.to_boolean( p_init_msg_list )
493: THEN
494: FND_MSG_PUB.initialize;
495: END IF;
496: x_record_version_number := SYSTEM.PA_NUM_TBL_TYPE();

Line 507: x_return_status := FND_API.G_RET_STS_SUCCESS;

503:
504: FOR i IN 1..p_resource_list_member_id.COUNT
505: LOOP
506: x_msg_count := 0;
507: x_return_status := FND_API.G_RET_STS_SUCCESS;
508:
509: Pa_Planning_Resource_Pvt.Update_Planning_Resource
510: (p_resource_list_id =>p_resource_list_id,
511: p_resource_list_member_id =>p_resource_list_member_id(i),

Line 559: IF FND_API.to_boolean( p_commit )

555:
556: /************************************************
557: * Check the Commit flag. if it is true then Commit.
558: ***********************************************/
559: IF FND_API.to_boolean( p_commit )
560: THEN
561: COMMIT;
562: END IF;
563: /***************/

Line 586: IF FND_API.to_boolean( p_init_msg_list )

582:
583: IS
584: BEGIN
585: -- First clear the message stack.
586: IF FND_API.to_boolean( p_init_msg_list )
587: THEN
588: FND_MSG_PUB.initialize;
589: END IF;
590: /********************************************

Line 608: IF FND_API.to_boolean( p_commit )

604: END LOOP;
605: /************************************************
606: * Check the Commit flag. if it is true then Commit.
607: ***********************************************/
608: IF FND_API.to_boolean( p_commit )
609: THEN
610: COMMIT;
611: END IF;
612: /***************/