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.AHL_PRD_WORKORDER_PVT dependencies on AHL_PP_RESRC_REQUIRE_PVT

Line 1858: p_x_resource_tbl IN OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type

1854: PROCEDURE get_op_resource_req
1855: (
1856: p_workorder_rec IN prd_workorder_rec,
1857: p_operation_tbl IN AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,
1858: p_x_resource_tbl IN OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type
1859: )
1860: AS
1861:
1862: -- For Getting Resource Requirements defined for Operation

Line 2071: p_x_resource_tbl IN OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type

2067: PROCEDURE get_rt_resource_req
2068: (
2069: p_workorder_rec IN prd_workorder_rec,
2070: p_operation_tbl IN AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,
2071: p_x_resource_tbl IN OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type
2072: )
2073: AS
2074:
2075: -- For Getting Resource Requirements defined for Route or Operation

Line 2401: x_create_res_tbl OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type,

2397: PROCEDURE aggregate_stg_resource_req
2398: (
2399: p_workorder_rec IN prd_workorder_rec,
2400: p_nrp_res_req_tbl IN number_tbl_type,
2401: x_create_res_tbl OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type,
2402: x_update_res_tbl OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type,
2403: x_delete_res_tbl OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type
2404: )
2405: IS

Line 2402: x_update_res_tbl OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type,

2398: (
2399: p_workorder_rec IN prd_workorder_rec,
2400: p_nrp_res_req_tbl IN number_tbl_type,
2401: x_create_res_tbl OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type,
2402: x_update_res_tbl OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type,
2403: x_delete_res_tbl OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type
2404: )
2405: IS
2406: --

Line 2403: x_delete_res_tbl OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type

2399: p_workorder_rec IN prd_workorder_rec,
2400: p_nrp_res_req_tbl IN number_tbl_type,
2401: x_create_res_tbl OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type,
2402: x_update_res_tbl OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type,
2403: x_delete_res_tbl OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type
2404: )
2405: IS
2406: --
2407: /* Cursor for getting the BOM Resource for the CMRO Resource, Visit's Organization and Department.

Line 2738: l_resource_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;

2734:
2735: l_dummy NUMBER;
2736: l_wo_oper_id NUMBER;
2737: l_res_ctr NUMBER;
2738: l_resource_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;
2739: --
2740: BEGIN
2741:
2742: IF ( G_DEBUG = 'Y' ) THEN

Line 2787: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require

2783: IF ( G_DEBUG = 'Y' ) THEN
2784: AHL_DEBUG_PUB.debug( l_full_name || ' - Invoking Process_resrc_require API for Removing all the Resource Requirements for Workorder id: ' || p_workorder_tbl(i).workorder_id );
2785: END IF;
2786:
2787: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require
2788: (
2789: p_api_version => 1.0,
2790: p_init_msg_list => FND_API.G_FALSE,
2791: p_commit => FND_API.G_FALSE,

Line 3734: x_resource_tbl OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type,

3730: x_msg_data OUT NOCOPY VARCHAR2,
3731: p_wip_load_flag IN VARCHAR2 := 'Y', -- Change to N
3732: p_x_prd_workorder_rec IN OUT NOCOPY prd_workorder_rec,
3733: x_operation_tbl OUT NOCOPY AHL_PRD_OPERATIONS_PVT.prd_operation_tbl,
3734: x_resource_tbl OUT NOCOPY AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type,
3735: x_material_tbl OUT NOCOPY AHL_PP_MATERIALS_PVT.req_material_tbl_type
3736: )
3737: AS
3738: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_JOB';

Line 4207: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require' );

4203:
4204: IF ( x_resource_tbl.COUNT > 0 ) THEN
4205:
4206: IF ( G_DEBUG = 'Y' ) THEN
4207: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require' );
4208: END IF;
4209:
4210: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require
4211: (

Line 4210: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require

4206: IF ( G_DEBUG = 'Y' ) THEN
4207: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require' );
4208: END IF;
4209:
4210: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require
4211: (
4212: p_api_version => 1.0,
4213: p_init_msg_list => FND_API.G_TRUE,
4214: p_commit => FND_API.G_FALSE,

Line 4393: l_resource_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;

4389: l_msg_data VARCHAR2(2000);
4390: l_return_status VARCHAR2(1);
4391: l_job_return_status VARCHAR2(1);
4392: l_prd_workoper_tbl AHL_PRD_OPERATIONS_PVT.prd_operation_tbl;
4393: l_resource_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;
4394: l_material_tbl AHL_PP_MATERIALS_PVT.req_material_tbl_type;
4395: l_parent_workorder_rec prd_workorder_rec;
4396: l_parent_workoper_tbl prd_workoper_tbl;
4397: l_wo_status VARCHAR2(80);

Line 4589: L_RESOURCE_REQ_TBL AHL_PP_RESRC_REQUIRE_PVT.RESRC_REQUIRE_TBL_TYPE;

4585:
4586: L_X_PRD_WORKORDER_REC AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
4587: L_OPERATION_TBL AHL_PRD_OPERATIONS_PVT.PRD_OPERATION_TBL;
4588: L_MATERIAL_REQ_TBL AHL_PP_MATERIALS_PVT.REQ_MATERIAL_TBL_TYPE;
4589: L_RESOURCE_REQ_TBL AHL_PP_RESRC_REQUIRE_PVT.RESRC_REQUIRE_TBL_TYPE;
4590:
4591: -- Begin OGMA Issue # 105 - Balaji
4592: -- cursor for checking if given task is planned task created form forecasted UE.
4593: CURSOR c_can_update_quantity(p_task_id NUMBER)

Line 5388: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require' );

5384: p_x_resource_tbl => l_resource_tbl
5385: );
5386:
5387: IF ( G_DEBUG = 'Y' ) THEN
5388: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require' );
5389: END IF;
5390:
5391: IF ( l_resource_tbl.COUNT > 0 ) THEN
5392: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require

Line 5392: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require

5388: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require' );
5389: END IF;
5390:
5391: IF ( l_resource_tbl.COUNT > 0 ) THEN
5392: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require
5393: (
5394: p_api_version => 1.0,
5395: p_init_msg_list => FND_API.G_TRUE,
5396: p_commit => FND_API.G_FALSE,

Line 5712: -- Though resource requirements are added in call to AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require

5708: AHL_DEBUG_PUB.debug( l_api_name || ' - Before AHL_EAM_JOB_PVT.update_job_operations' );
5709: END IF;
5710:
5711: -- Fix for Bug # 8329755 (FP for Bug # 7697909) -- start
5712: -- Though resource requirements are added in call to AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require
5713: -- above, EAM API is not called due to p_interface_flag being N.
5714: -- Hence the MWO dates are not updated correctly. They need expanded and contracted
5715: -- just before resource addition and after resource addition respectively.
5716: IF (l_resource_tbl.COUNT > 0 AND l_expand_mwo_flag = FALSE)

Line 5720: AHL_PP_RESRC_REQUIRE_PVT.Expand_Master_Wo_Dates(l_resource_tbl(l_res_count));

5716: IF (l_resource_tbl.COUNT > 0 AND l_expand_mwo_flag = FALSE)
5717: THEN
5718: FOR l_res_count IN l_resource_tbl.FIRST .. l_resource_tbl.LAST
5719: LOOP
5720: AHL_PP_RESRC_REQUIRE_PVT.Expand_Master_Wo_Dates(l_resource_tbl(l_res_count));
5721: END LOOP;
5722: END IF;
5723: -- Fix for Bug # 8329755 (FP for Bug # 7697909) -- end
5724:

Line 6291: l_resource_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;

6287: l_return_status VARCHAR2(1);
6288: l_mr_workorder_tbl prd_workorder_tbl;
6289: l_dummy_op_tbl prd_workoper_tbl;
6290: l_operation_tbl AHL_PRD_OPERATIONS_PVT.prd_operation_tbl;
6291: l_resource_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;
6292: l_material_tbl AHL_PP_MATERIALS_PVT.req_material_tbl_type;
6293: l_eam_wo_tbl EAM_PROCESS_WO_PUB.eam_wo_tbl_type;
6294: l_eam_wo_relations_tbl EAM_PROCESS_WO_PUB.eam_wo_relations_tbl_type;
6295: l_eam_op_tbl EAM_PROCESS_WO_PUB.eam_op_tbl_type;

Line 6928: l_create_res_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;

6924: l_stg_typ_index VARCHAR2(30);
6925: l_stg_id_index NUMBER;
6926: l_res_id_index NUMBER;
6927: l_stg_workorder_rec PRD_WORKORDER_REC;
6928: l_create_res_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;
6929: l_update_res_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;
6930: l_delete_res_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;
6931: --
6932: BEGIN

Line 6929: l_update_res_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;

6925: l_stg_id_index NUMBER;
6926: l_res_id_index NUMBER;
6927: l_stg_workorder_rec PRD_WORKORDER_REC;
6928: l_create_res_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;
6929: l_update_res_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;
6930: l_delete_res_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;
6931: --
6932: BEGIN
6933:

Line 6930: l_delete_res_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;

6926: l_res_id_index NUMBER;
6927: l_stg_workorder_rec PRD_WORKORDER_REC;
6928: l_create_res_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;
6929: l_update_res_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;
6930: l_delete_res_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;
6931: --
6932: BEGIN
6933:
6934: IF ( G_DEBUG = 'Y' ) THEN

Line 7191: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require

7187: IF ( G_DEBUG = 'Y' ) THEN
7188: AHL_DEBUG_PUB.debug( l_full_name || ' - Invoking Process_resrc_require API for Creating Resource Requirements for Stage Workorder id: ' || l_stg_workorder_rec.workorder_id );
7189: END IF;
7190:
7191: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require
7192: (
7193: p_api_version => 1.0,
7194: p_init_msg_list => FND_API.G_FALSE, -- message initialization is already done in current API.
7195: p_commit => FND_API.G_FALSE,

Line 7232: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require

7228: IF ( G_DEBUG = 'Y' ) THEN
7229: AHL_DEBUG_PUB.debug( l_full_name || ' - Invoking Process_resrc_require API for Updating Resource Requirements for Stage Workorder id: ' || l_stg_workorder_rec.workorder_id );
7230: END IF;
7231:
7232: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require
7233: (
7234: p_api_version => 1.0,
7235: p_init_msg_list => FND_API.G_FALSE,
7236: p_commit => FND_API.G_FALSE,

Line 7273: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require

7269: IF ( G_DEBUG = 'Y' ) THEN
7270: AHL_DEBUG_PUB.debug( l_full_name || ' - Invoking Process_resrc_require API for Removing Resource Requirements for Stage Workorder id: ' || l_stg_workorder_rec.workorder_id );
7271: END IF;
7272:
7273: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require
7274: (
7275: p_api_version => 1.0,
7276: p_init_msg_list => FND_API.G_FALSE,
7277: p_commit => FND_API.G_FALSE,

Line 10936: l_resource_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;

10932: AND relationship_type = 1
10933: );
10934:
10935: l_x_prd_workorder_rec AHL_PRD_WORKORDER_PVT.PRD_WORKORDER_REC;
10936: l_resource_tbl AHL_PP_RESRC_REQUIRE_PVT.resrc_require_tbl_type;
10937: l_material_tbl AHL_PP_MATERIALS_PVT.req_material_tbl_type;
10938: l_prd_workoper_tbl AHL_PRD_OPERATIONS_PVT.prd_operation_tbl;
10939:
10940: l_parent_wo_st_date DATE;