DBA Data[Home] [Help]

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 460: p_x_route_material_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type,

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

Line 722: AHL_RM_MATERIAL_AS_PVT.process_material_req

718: --Attach Material Requirements
719: IF p_x_route_material_tbl.count > 0 THEN
720:
721:
722: AHL_RM_MATERIAL_AS_PVT.process_material_req
723: (
724: p_api_version => 1.0,
725: p_init_msg_list => FND_API.G_FALSE,
726: p_commit => FND_API.G_FALSE,

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

733: p_x_material_req_tbl => p_x_route_material_tbl,
734: p_object_id => l_route_id,
735: p_association_type => 'ROUTE'
736: );
737: -- to raise errors from AHL_RM_MATERIAL_AS_PVT.process_material_req
738: x_msg_count := FND_MSG_PUB.count_msg;
739:
740: IF x_msg_count > 0 THEN
741: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

791: p_x_route_operation_tbl => p_x_route_operation_tbl,
792: p_route_id => l_route_id
793: );
794:
795: -- to raise errors from AHL_RM_MATERIAL_AS_PVT.process_material_req
796: x_msg_count := FND_MSG_PUB.count_msg;
797:
798: IF x_msg_count > 0 THEN
799: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1092: p_x_route_efct_rec IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.route_efct_rec_type,

1088: -- procedure params
1089: p_route_id IN NUMBER,
1090: p_route_number IN VARCHAR2,
1091: p_route_revision IN NUMBER,
1092: p_x_route_efct_rec IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.route_efct_rec_type,
1093: p_x_route_efct_mat_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
1094: )
1095: IS
1096: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_ROUTE_DISPOSITION';

Line 1093: p_x_route_efct_mat_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type

1089: p_route_id IN NUMBER,
1090: p_route_number IN VARCHAR2,
1091: p_route_revision IN NUMBER,
1092: p_x_route_efct_rec IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.route_efct_rec_type,
1093: p_x_route_efct_mat_tbl IN OUT NOCOPY AHL_RM_MATERIAL_AS_PVT.material_req_tbl_type
1094: )
1095: IS
1096: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_ROUTE_DISPOSITION';
1097: l_api_version CONSTANT NUMBER := 1.0;

Line 1099: l_x_route_efct_tbl AHL_RM_MATERIAL_AS_PVT.route_efct_tbl_type;

1095: IS
1096: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_ROUTE_DISPOSITION';
1097: l_api_version CONSTANT NUMBER := 1.0;
1098: l_debug_module CONSTANT VARCHAR2(60) := 'ahl.plsql.'||g_pkg_name||'.'||l_api_name;
1099: l_x_route_efct_tbl AHL_RM_MATERIAL_AS_PVT.route_efct_tbl_type;
1100: l_route_id NUMBER;
1101: BEGIN
1102:
1103: -- Initialize API return status to success

Line 1178: AHL_RM_MATERIAL_AS_PVT.process_route_efcts

1174: l_x_route_efct_tbl(1) := p_x_route_efct_rec;
1175: --Call the private API to create/modify effecvtivity header.
1176:
1177:
1178: AHL_RM_MATERIAL_AS_PVT.process_route_efcts
1179: (
1180: p_api_version => 1.0,
1181: p_init_msg_list => FND_API.G_FALSE,
1182: p_commit => FND_API.G_FALSE,

Line 1211: AHL_RM_MATERIAL_AS_PVT.process_material_req

1207:
1208: END IF;
1209:
1210: --Call the private API to create/modify effectivity details for the header above.
1211: AHL_RM_MATERIAL_AS_PVT.process_material_req
1212: (
1213: p_api_version => 1.0,
1214: p_init_msg_list => FND_API.G_FALSE,
1215: p_commit => FND_API.G_FALSE,