DBA Data[Home] [Help]

APPS.AHL_RM_ROUTE_PUB dependencies on AHL_RM_ROUTE_PVT

Line 21: p_x_route_rec IN OUT NOCOPY AHL_RM_ROUTE_PVT.route_rec_type,

17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2,
20: -- procedure params
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,

Line 74: 'Before calling the private API AHL_RM_ROUTE_PVT.process_route.....'

70: fnd_log.string
71: (
72: fnd_log.level_statement,
73: l_debug_module ,
74: 'Before calling the private API AHL_RM_ROUTE_PVT.process_route.....'
75: );
76:
77: END IF;
78:

Line 83: AHL_RM_ROUTE_PVT.process_route

79: -- PRITHWI: discuss with Shailaja whether to default to 'C' or to throw error if there is no Defaul
80: IF p_x_route_rec.DML_OPERATION = 'C'
81: THEN
82:
83: AHL_RM_ROUTE_PVT.process_route
84: (
85: p_api_version => 1.0,
86: p_init_msg_list => FND_API.G_FALSE,
87: p_commit => FND_API.G_FALSE,

Line 97: -- to raise errors from AHL_RM_ROUTE_PVT.process_ROUTE

93: x_msg_data => x_msg_data,
94: p_x_route_rec => p_x_route_rec
95: );
96:
97: -- to raise errors from AHL_RM_ROUTE_PVT.process_ROUTE
98: x_msg_count := FND_MSG_PUB.count_msg;
99:
100: IF x_msg_count > 0 THEN
101: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 455: p_x_route_rec IN OUT NOCOPY AHL_RM_ROUTE_PVT.route_rec_type,

451: x_return_status OUT NOCOPY VARCHAR2,
452: x_msg_count OUT NOCOPY NUMBER,
453: x_msg_data OUT NOCOPY VARCHAR2,
454: -- procedure params
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

Line 538: p_route_rec IN AHL_RM_ROUTE_PVT.route_rec_type,

534: x_return_status OUT NOCOPY VARCHAR2,
535: x_msg_count OUT NOCOPY NUMBER,
536: x_msg_data OUT NOCOPY VARCHAR2,
537: -- procedure params
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,

Line 550: l_route_rec AHL_RM_ROUTE_PVT.route_rec_type;

546: l_api_name CONSTANT VARCHAR2(30) := 'MODIFY_ROUTE';
547: l_api_version CONSTANT NUMBER := 2.0;
548: l_debug_module CONSTANT VARCHAR2(60) := 'ahl.plsql.'||g_pkg_name||'.'||l_api_name;
549: l_route_id NUMBER;
550: l_route_rec AHL_RM_ROUTE_PVT.route_rec_type;
551: l_x_rt_oper_cost_rec AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_cost_rec_type;
552:
553: BEGIN
554:

Line 594: 'Before calling the private API AHL_RM_ROUTE_PVT.process_route.....'

590: fnd_log.string
591: (
592: fnd_log.level_statement,
593: l_debug_module ,
594: 'Before calling the private API AHL_RM_ROUTE_PVT.process_route.....'
595: );
596:
597: END IF;
598:

Line 641: AHL_RM_ROUTE_PVT.process_route

637: -- no check on OBJ VER NO as PVT already does it.
638: IF p_route_rec.DML_OPERATION = 'U'
639: THEN
640: l_route_rec := p_route_rec ;
641: AHL_RM_ROUTE_PVT.process_route
642: (
643: p_api_version => 1.0,
644: p_init_msg_list => FND_API.G_FALSE,
645: p_commit => FND_API.G_FALSE,

Line 654: -- to raise errors from AHL_RM_ROUTE_PVT.process_route

650: x_msg_count => x_msg_count,
651: x_msg_data => x_msg_data,
652: p_x_route_rec => l_route_rec
653: );
654: -- to raise errors from AHL_RM_ROUTE_PVT.process_route
655: x_msg_count := FND_MSG_PUB.count_msg;
656:
657: IF x_msg_count > 0 THEN
658: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 976: p_route_rec IN AHL_RM_ROUTE_PVT.route_rec_type,

972: x_return_status OUT NOCOPY VARCHAR2,
973: x_msg_count OUT NOCOPY NUMBER,
974: x_msg_data OUT NOCOPY VARCHAR2,
975: -- procedure params
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

Line 1112: 'Before calling the private API AHL_RM_ROUTE_PVT.delete_route.....'

1108: fnd_log.string
1109: (
1110: fnd_log.level_statement,
1111: l_debug_module ,
1112: 'Before calling the private API AHL_RM_ROUTE_PVT.delete_route.....'
1113: );
1114:
1115: END IF;
1116:

Line 1154: AHL_RM_ROUTE_PVT.delete_route

1150:
1151: END IF;
1152:
1153:
1154: AHL_RM_ROUTE_PVT.delete_route
1155: (
1156: p_api_version => 1.0,
1157: p_init_msg_list => FND_API.G_FALSE,
1158: p_commit => FND_API.G_FALSE,

Line 1168: -- to raise errors from AHL_RM_ROUTE_PVT.process_route

1164: x_msg_data => x_msg_data,
1165: p_route_id => l_route_id,
1166: p_object_version_number => p_route_object_version
1167: );
1168: -- to raise errors from AHL_RM_ROUTE_PVT.process_route
1169: x_msg_count := FND_MSG_PUB.count_msg;
1170:
1171: IF x_msg_count > 0 THEN
1172: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1579: AHL_RM_ROUTE_PVT.create_route_revision

1575: );
1576: END IF;
1577:
1578: -- Call the corresponding private API
1579: AHL_RM_ROUTE_PVT.create_route_revision
1580: (
1581: p_api_version => 1.0,
1582: p_init_msg_list => FND_API.G_FALSE,
1583: p_commit => FND_API.G_FALSE,