DBA Data[Home] [Help]

APPS.AHL_RM_ROUTE_PUB dependencies on AHL_RM_RT_OPER_RESOURCE_PVT

Line 24: p_x_route_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,

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,
26: p_x_route_panel_tbl IN OUT NOCOPY AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type
27: )
28: IS

Line 32: l_x_rt_oper_cost_rec AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_cost_rec_type;

28: IS
29: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ROUTE';
30: l_api_version CONSTANT NUMBER := 2.0;
31: l_debug_module CONSTANT VARCHAR2(60) := 'ahl.plsql.'||g_pkg_name||'.'||l_api_name;
32: l_x_rt_oper_cost_rec AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_cost_rec_type;
33:
34: BEGIN
35:
36: -- Initialize API return status to success

Line 200: AHL_RM_RT_OPER_RESOURCE_PVT.process_rt_oper_resource

196: p_x_route_resource_tbl(i).DML_OPERATION := 'C';
197:
198: END LOOP;
199:
200: AHL_RM_RT_OPER_RESOURCE_PVT.process_rt_oper_resource
201: (
202: p_api_version => 1.0,
203: p_init_msg_list => FND_API.G_FALSE,
204: p_commit => FND_API.G_FALSE,

Line 216: -- to raise errors from AHL_RM_RT_OPER_RESOURCE_PVT.process_rt_oper_resource

212: p_association_type_code => 'ROUTE',
213: p_object_id => p_x_route_rec.ROUTE_ID
214: );
215:
216: -- to raise errors from AHL_RM_RT_OPER_RESOURCE_PVT.process_rt_oper_resource
217: x_msg_count := FND_MSG_PUB.count_msg;
218:
219: IF x_msg_count > 0 THEN
220: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 240: AHL_RM_RT_OPER_RESOURCE_PVT.define_cost_parameter

236: l_x_rt_oper_cost_rec.AUTOCHARGE_TYPE := p_x_route_resource_tbl(i).AUTOCHARGE_TYPE;
237: l_x_rt_oper_cost_rec.STANDARD_RATE_FLAG := p_x_route_resource_tbl(i).STANDARD_RATE_FLAG;
238: l_x_rt_oper_cost_rec.STANDARD_RATE := p_x_route_resource_tbl(i).STANDARD_RATE;
239:
240: AHL_RM_RT_OPER_RESOURCE_PVT.define_cost_parameter
241: (
242: p_api_version => 1.0,
243: p_init_msg_list => FND_API.G_FALSE,
244: p_commit => FND_API.G_FALSE,

Line 458: p_x_route_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,

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
460: )
461: IS
462:

Line 541: p_x_route_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,

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,
543: p_x_route_panel_tbl IN OUT NOCOPY AHL_RM_RT_OPER_PANEL_PVT.rt_oper_panel_tbl_type
544: )
545: IS

Line 551: l_x_rt_oper_cost_rec AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_cost_rec_type;

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:
555: -- Initialize API return status to success

Line 734: AHL_RM_RT_OPER_RESOURCE_PVT.process_rt_oper_resource

730:
731: -- Attach Resources
732: IF p_x_route_resource_tbl.count > 0 THEN
733:
734: AHL_RM_RT_OPER_RESOURCE_PVT.process_rt_oper_resource
735: (
736: p_api_version => 1.0,
737: p_init_msg_list => FND_API.G_FALSE,
738: p_commit => FND_API.G_FALSE,

Line 750: -- to raise errors from AHL_RM_RT_OPER_RESOURCE_PVT.process_rt_oper_resource

746: p_association_type_code => 'ROUTE',
747: p_object_id => l_route_id
748: );
749:
750: -- to raise errors from AHL_RM_RT_OPER_RESOURCE_PVT.process_rt_oper_resource
751: x_msg_count := FND_MSG_PUB.count_msg;
752:
753: IF x_msg_count > 0 THEN
754: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 778: AHL_RM_RT_OPER_RESOURCE_PVT.define_cost_parameter

774: l_x_rt_oper_cost_rec.AUTOCHARGE_TYPE := p_x_route_resource_tbl(i).AUTOCHARGE_TYPE;
775: l_x_rt_oper_cost_rec.STANDARD_RATE_FLAG := p_x_route_resource_tbl(i).STANDARD_RATE_FLAG;
776: l_x_rt_oper_cost_rec.STANDARD_RATE := p_x_route_resource_tbl(i).STANDARD_RATE;
777:
778: AHL_RM_RT_OPER_RESOURCE_PVT.define_cost_parameter
779: (
780: p_api_version => 1.0,
781: p_init_msg_list => FND_API.G_FALSE,
782: p_commit => FND_API.G_FALSE,

Line 979: p_x_route_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.rt_oper_resource_tbl_type,

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
981: )
982: IS
983:

Line 2044: p_x_alt_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.alt_resource_tbl_type

2040: p_route_revision IN NUMBER,
2041: p_route_id IN NUMBER,
2042: p_resource_id IN NUMBER,
2043: p_resource_name IN VARCHAR2,
2044: p_x_alt_resource_tbl IN OUT NOCOPY AHL_RM_RT_OPER_RESOURCE_PVT.alt_resource_tbl_type
2045: )
2046: IS
2047:
2048: -- cursor to fetch the resource Id if the resource name is known

Line 2185: 'Before calling Private API AHL_RM_RT_OPER_RESOURCE_PVT.process_alternate_resource'

2181: fnd_log.string
2182: (
2183: fnd_log.level_statement,
2184: l_debug_module ,
2185: 'Before calling Private API AHL_RM_RT_OPER_RESOURCE_PVT.process_alternate_resource'
2186: );
2187: END IF;
2188:
2189: AHL_RM_RT_OPER_RESOURCE_PVT.process_alternate_resource

Line 2189: AHL_RM_RT_OPER_RESOURCE_PVT.process_alternate_resource

2185: 'Before calling Private API AHL_RM_RT_OPER_RESOURCE_PVT.process_alternate_resource'
2186: );
2187: END IF;
2188:
2189: AHL_RM_RT_OPER_RESOURCE_PVT.process_alternate_resource
2190: (
2191: p_api_version => 1.0 ,
2192: p_init_msg_list => p_init_msg_list,
2193: p_commit => p_commit,

Line 2211: 'After calling Private API AHL_RM_RT_OPER_RESOURCE_PVT.process_alternate_resource'

2207: fnd_log.string
2208: (
2209: fnd_log.level_statement,
2210: l_debug_module ,
2211: 'After calling Private API AHL_RM_RT_OPER_RESOURCE_PVT.process_alternate_resource'
2212: );
2213: END IF;
2214:
2215: