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_RM_ROUTE_PUB dependencies on AHL_RM_MATERIAL_AS_PVT

Line 25: p_x_route_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type,

21: p_x_route_rec IN OUT NOCOPY AHL_RM_ROUTE_PVT.route_rec_type,
22: p_x_route_doc_tbl IN OUT NOCOPY AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl,
23: p_x_route_operation_tbl IN OUT NOCOPY AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type,
24: p_x_route_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,
25: p_x_route_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type,
26: p_x_route_panel_tbl IN OUT NOCOPY AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type
27: )
28: IS
29: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ROUTE';

Line 276: AHL_RM_MATERIAL_AS_PVT.process_material_req

272: p_x_route_material_tbl(i).DML_OPERATION := 'C';
273:
274: END LOOP;
275:
276: AHL_RM_MATERIAL_AS_PVT.process_material_req
277: (
278: p_api_version => 1.0,
279: p_init_msg_list => FND_API.G_FALSE,
280: p_commit => FND_API.G_FALSE,

Line 291: -- to raise errors from AHL_RM_MATERIAL_AS_PVT.process_material_req

287: p_x_material_req_tbl => p_x_route_material_tbl,
288: p_object_id => p_x_route_rec.ROUTE_ID,
289: p_association_type => 'ROUTE'
290: );
291: -- to raise errors from AHL_RM_MATERIAL_AS_PVT.process_material_req
292: x_msg_count := FND_MSG_PUB.count_msg;
293:
294: IF x_msg_count > 0 THEN
295: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 361: -- to raise errors from AHL_RM_MATERIAL_AS_PVT.process_material_req

357: p_x_route_operation_tbl => p_x_route_operation_tbl,
358: p_route_id => p_x_route_rec.ROUTE_ID
359: );
360:
361: -- to raise errors from AHL_RM_MATERIAL_AS_PVT.process_material_req
362: x_msg_count := FND_MSG_PUB.count_msg;
363:
364: IF x_msg_count > 0 THEN
365: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 459: p_x_route_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type

455: p_x_route_rec IN OUT NOCOPY AHL_RM_ROUTE_PVT.route_rec_type,
456: p_x_route_doc_tbl IN OUT NOCOPY AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl,
457: p_x_route_operation_tbl IN OUT NOCOPY AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type,
458: p_x_route_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,
459: p_x_route_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
460: )
461: IS
462:
463: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ROUTE';

Line 542: p_x_route_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type,

538: p_route_rec IN AHL_RM_ROUTE_PVT.route_rec_type,
539: p_x_route_doc_tbl IN OUT NOCOPY AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl,
540: p_x_route_operation_tbl IN OUT NOCOPY AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type,
541: p_x_route_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,
542: p_x_route_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type,
543: p_x_route_panel_tbl IN OUT NOCOPY AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type
544: )
545: IS
546: l_api_name CONSTANT VARCHAR2(30) := 'MODIFY_ROUTE';

Line 808: AHL_RM_MATERIAL_AS_PVT.process_material_req

804: --Attach Material Requirements
805: IF p_x_route_material_tbl.count > 0 THEN
806:
807:
808: AHL_RM_MATERIAL_AS_PVT.process_material_req
809: (
810: p_api_version => 1.0,
811: p_init_msg_list => FND_API.G_FALSE,
812: p_commit => FND_API.G_FALSE,

Line 823: -- to raise errors from AHL_RM_MATERIAL_AS_PVT.process_material_req

819: p_x_material_req_tbl => p_x_route_material_tbl,
820: p_object_id => l_route_id,
821: p_association_type => 'ROUTE'
822: );
823: -- to raise errors from AHL_RM_MATERIAL_AS_PVT.process_material_req
824: x_msg_count := FND_MSG_PUB.count_msg;
825:
826: IF x_msg_count > 0 THEN
827: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 881: -- to raise errors from AHL_RM_MATERIAL_AS_PVT.process_material_req

877: p_x_route_operation_tbl => p_x_route_operation_tbl,
878: p_route_id => l_route_id
879: );
880:
881: -- to raise errors from AHL_RM_MATERIAL_AS_PVT.process_material_req
882: x_msg_count := FND_MSG_PUB.count_msg;
883:
884: IF x_msg_count > 0 THEN
885: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 980: p_x_route_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type

976: p_route_rec IN AHL_RM_ROUTE_PVT.route_rec_type,
977: p_x_route_doc_tbl IN OUT NOCOPY AHL_RM_ASSO_DOCASO_PVT.doc_association_tbl,
978: p_x_route_operation_tbl IN OUT NOCOPY AHL_RM_OP_ROUTE_AS_PVT.route_operation_tbl_type,
979: p_x_route_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,
980: p_x_route_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
981: )
982: IS
983:
984: l_api_name CONSTANT VARCHAR2(30) := 'MODIFY_ROUTE';

Line 1265: p_x_route_efct_rec IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.route_efct_rec_type,

1261: -- procedure params
1262: p_route_id IN NUMBER,
1263: p_route_number IN VARCHAR2,
1264: p_route_revision IN NUMBER,
1265: p_x_route_efct_rec IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.route_efct_rec_type,
1266: p_x_route_efct_mat_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
1267: )
1268: IS
1269: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_ROUTE_DISPOSITION';

Line 1266: p_x_route_efct_mat_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type

1262: p_route_id IN NUMBER,
1263: p_route_number IN VARCHAR2,
1264: p_route_revision IN NUMBER,
1265: p_x_route_efct_rec IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.route_efct_rec_type,
1266: p_x_route_efct_mat_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
1267: )
1268: IS
1269: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_ROUTE_DISPOSITION';
1270: l_api_version CONSTANT NUMBER := 1.0;

Line 1272: l_x_route_efct_tbl AHL_RM_MATERIAL_AS_PVT.route_efct_tbl_type;

1268: IS
1269: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_ROUTE_DISPOSITION';
1270: l_api_version CONSTANT NUMBER := 1.0;
1271: l_debug_module CONSTANT VARCHAR2(60) := 'ahl.plsql.'||g_pkg_name||'.'||l_api_name;
1272: l_x_route_efct_tbl AHL_RM_MATERIAL_AS_PVT.route_efct_tbl_type;
1273: l_route_id NUMBER;
1274: BEGIN
1275:
1276: -- Initialize API return status to success

Line 1350: AHL_RM_MATERIAL_AS_PVT.process_route_efcts

1346:
1347: l_x_route_efct_tbl(1) := p_x_route_efct_rec;
1348: --Call the private API to create/modify effecvtivity header.
1349:
1350: AHL_RM_MATERIAL_AS_PVT.process_route_efcts
1351: (
1352: p_api_version => 1.0,
1353: p_init_msg_list => FND_API.G_FALSE,
1354: p_commit => FND_API.G_FALSE,

Line 1395: AHL_RM_MATERIAL_AS_PVT.process_material_req

1391: l_debug_module ,
1392: 'Route eff. has material req. records'
1393: );
1394: END IF;
1395: AHL_RM_MATERIAL_AS_PVT.process_material_req
1396: (
1397: p_api_version => 1.0,
1398: p_init_msg_list => FND_API.G_FALSE,
1399: p_commit => FND_API.G_FALSE,