DBA Data[Home] [Help]

APPS.AHL_RM_ROUTE_PUB dependencies on STANDARD

Line 9: -- standard IN params

5:
6:
7: PROCEDURE Create_Route
8: (
9: -- standard IN params
10: p_api_version IN NUMBER,
11: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
12: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
13: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 16: -- standard OUT params

12: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
13: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
14: p_default IN VARCHAR2 :=FND_API.G_FALSE,
15: p_module_type IN VARCHAR2 :=NULL,
16: -- standard OUT params
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2,
20: -- procedure params

Line 39: -- Standard Start of API savepoint

35:
36: -- Initialize API return status to success
37: x_return_status := FND_API.G_RET_STS_SUCCESS;
38:
39: -- Standard Start of API savepoint
40: SAVEPOINT create_route_pub;
41:
42: -- Standard call to check for call compatibility.
43: IF NOT FND_API.compatible_api_call

Line 42: -- Standard call to check for call compatibility.

38:
39: -- Standard Start of API savepoint
40: SAVEPOINT create_route_pub;
41:
42: -- Standard call to check for call compatibility.
43: IF NOT FND_API.compatible_api_call
44: (
45: l_api_version,
46: p_api_version,

Line 237: l_x_rt_oper_cost_rec.STANDARD_RATE_FLAG := p_x_route_resource_tbl(i).STANDARD_RATE_FLAG;

233: l_x_rt_oper_cost_rec.SCHEDULED_TYPE_ID := p_x_route_resource_tbl(i).SCHEDULED_TYPE_ID;
234: l_x_rt_oper_cost_rec.SCHEDULED_TYPE := p_x_route_resource_tbl(i).SCHEDULED_TYPE;
235: l_x_rt_oper_cost_rec.AUTOCHARGE_TYPE_ID := p_x_route_resource_tbl(i).AUTOCHARGE_TYPE_ID;
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: (

Line 238: l_x_rt_oper_cost_rec.STANDARD_RATE := p_x_route_resource_tbl(i).STANDARD_RATE;

234: l_x_rt_oper_cost_rec.SCHEDULED_TYPE := p_x_route_resource_tbl(i).SCHEDULED_TYPE;
235: l_x_rt_oper_cost_rec.AUTOCHARGE_TYPE_ID := p_x_route_resource_tbl(i).AUTOCHARGE_TYPE_ID;
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,

Line 403: -- Standard check of p_commit

399: END IF;
400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401: END IF;
402:
403: -- Standard check of p_commit
404: IF FND_API.To_Boolean(p_commit) THEN
405: COMMIT WORK;
406: END IF;
407:

Line 443: -- standard IN params

439: -- Overloaded procedure retained for backaward compatibility (pre 12.0.4).
440: -- This procedure will call the above procedure with api_version = 2.
441: PROCEDURE Create_Route
442: (
443: -- standard IN params
444: p_api_version IN NUMBER,
445: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
446: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
447: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 450: -- standard OUT params

446: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
447: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
448: p_default IN VARCHAR2 :=FND_API.G_FALSE,
449: p_module_type IN VARCHAR2 :=NULL,
450: -- standard OUT params
451: x_return_status OUT NOCOPY VARCHAR2,
452: x_msg_count OUT NOCOPY NUMBER,
453: x_msg_data OUT NOCOPY VARCHAR2,
454: -- procedure params

Line 473: -- Standard call to check for call compatibility.

469:
470: -- Initialize API return status to success
471: x_return_status := FND_API.G_RET_STS_SUCCESS;
472:
473: -- Standard call to check for call compatibility.
474: IF NOT FND_API.compatible_api_call
475: (
476: l_api_version,
477: p_api_version,

Line 526: -- standard IN params

522:
523:
524: PROCEDURE Modify_Route
525: (
526: -- standard IN params
527: p_api_version IN NUMBER,
528: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
529: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
530: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 533: -- standard OUT params

529: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
530: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
531: p_default IN VARCHAR2 :=FND_API.G_FALSE,
532: p_module_type IN VARCHAR2 :=NULL,
533: -- standard OUT params
534: x_return_status OUT NOCOPY VARCHAR2,
535: x_msg_count OUT NOCOPY NUMBER,
536: x_msg_data OUT NOCOPY VARCHAR2,
537: -- procedure params

Line 558: -- Standard Start of API savepoint

554:
555: -- Initialize API return status to success
556: x_return_status := FND_API.G_RET_STS_SUCCESS;
557:
558: -- Standard Start of API savepoint
559: SAVEPOINT modify_route_pub;
560:
561: -- Standard call to check for call compatibility.
562: IF NOT FND_API.compatible_api_call

Line 561: -- Standard call to check for call compatibility.

557:
558: -- Standard Start of API savepoint
559: SAVEPOINT modify_route_pub;
560:
561: -- Standard call to check for call compatibility.
562: IF NOT FND_API.compatible_api_call
563: (
564: l_api_version,
565: p_api_version,

Line 775: l_x_rt_oper_cost_rec.STANDARD_RATE_FLAG := p_x_route_resource_tbl(i).STANDARD_RATE_FLAG;

771: l_x_rt_oper_cost_rec.SCHEDULED_TYPE_ID := p_x_route_resource_tbl(i).SCHEDULED_TYPE_ID;
772: l_x_rt_oper_cost_rec.SCHEDULED_TYPE := p_x_route_resource_tbl(i).SCHEDULED_TYPE;
773: l_x_rt_oper_cost_rec.AUTOCHARGE_TYPE_ID := p_x_route_resource_tbl(i).AUTOCHARGE_TYPE_ID;
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: (

Line 776: l_x_rt_oper_cost_rec.STANDARD_RATE := p_x_route_resource_tbl(i).STANDARD_RATE;

772: l_x_rt_oper_cost_rec.SCHEDULED_TYPE := p_x_route_resource_tbl(i).SCHEDULED_TYPE;
773: l_x_rt_oper_cost_rec.AUTOCHARGE_TYPE_ID := p_x_route_resource_tbl(i).AUTOCHARGE_TYPE_ID;
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,

Line 923: -- Standard check of p_commit

919: END IF;
920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
921: END IF;
922:
923: -- Standard check of p_commit
924: IF FND_API.To_Boolean(p_commit) THEN
925: COMMIT WORK;
926: END IF;
927:

Line 964: -- standard IN params

960: -- Overloaded procedure retained for backaward compatibility (pre 12.0.4).
961: -- This procedure will call the above procedure with api_version = 2.
962: PROCEDURE Modify_Route
963: (
964: -- standard IN params
965: p_api_version IN NUMBER,
966: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
967: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
968: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 971: -- standard OUT params

967: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
968: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
969: p_default IN VARCHAR2 :=FND_API.G_FALSE,
970: p_module_type IN VARCHAR2 :=NULL,
971: -- standard OUT params
972: x_return_status OUT NOCOPY VARCHAR2,
973: x_msg_count OUT NOCOPY NUMBER,
974: x_msg_data OUT NOCOPY VARCHAR2,
975: -- procedure params

Line 994: -- Standard call to check for call compatibility.

990:
991: -- Initialize API return status to success
992: x_return_status := FND_API.G_RET_STS_SUCCESS;
993:
994: -- Standard call to check for call compatibility.
995: IF NOT FND_API.compatible_api_call
996: (
997: l_api_version,
998: p_api_version,

Line 1048: -- standard IN params

1044:
1045:
1046: PROCEDURE Delete_Route
1047: (
1048: -- standard IN params
1049: p_api_version IN NUMBER,
1050: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1051: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1052: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 1055: -- standard OUT params

1051: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1052: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1053: p_default IN VARCHAR2 :=FND_API.G_FALSE,
1054: p_module_type IN VARCHAR2 :=NULL,
1055: -- standard OUT params
1056: x_return_status OUT NOCOPY VARCHAR2,
1057: x_msg_count OUT NOCOPY NUMBER,
1058: x_msg_data OUT NOCOPY VARCHAR2,
1059: -- procedure params

Line 1075: -- Standard Start of API savepoint

1071:
1072: -- Initialize API return status to success
1073: x_return_status := FND_API.G_RET_STS_SUCCESS;
1074:
1075: -- Standard Start of API savepoint
1076: -- Changed STHILAK bug # 10139384
1077: -- SAVEPOINT delete_operation_pub;
1078: SAVEPOINT delete_route_pub;
1079:

Line 1080: -- Standard call to check for call compatibility.

1076: -- Changed STHILAK bug # 10139384
1077: -- SAVEPOINT delete_operation_pub;
1078: SAVEPOINT delete_route_pub;
1079:
1080: -- Standard call to check for call compatibility.
1081: IF NOT FND_API.compatible_api_call
1082: (
1083: l_api_version,
1084: p_api_version,

Line 1209: -- Standard check of p_commit

1205: END IF;
1206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1207: END IF;
1208:
1209: -- Standard check of p_commit
1210: IF FND_API.To_Boolean(p_commit) THEN
1211: COMMIT WORK;
1212: END IF;
1213:

Line 1250: -- standard IN params

1246:
1247:
1248: PROCEDURE Process_Route_Dispositions
1249: (
1250: -- standard IN params
1251: p_api_version IN NUMBER,
1252: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
1253: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1254: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 1257: -- standard OUT params

1253: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
1254: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
1255: p_default IN VARCHAR2 :=FND_API.G_FALSE,
1256: p_module_type IN VARCHAR2 :=NULL,
1257: -- standard OUT params
1258: x_return_status OUT NOCOPY VARCHAR2,
1259: x_msg_count OUT NOCOPY NUMBER,
1260: x_msg_data OUT NOCOPY VARCHAR2,
1261: -- procedure params

Line 1279: -- Standard Start of API savepoint

1275:
1276: -- Initialize API return status to success
1277: x_return_status := FND_API.G_RET_STS_SUCCESS;
1278:
1279: -- Standard Start of API savepoint
1280: SAVEPOINT route_disp_pub;
1281:
1282: -- Standard call to check for call compatibility.
1283: IF NOT FND_API.compatible_api_call

Line 1282: -- Standard call to check for call compatibility.

1278:
1279: -- Standard Start of API savepoint
1280: SAVEPOINT route_disp_pub;
1281:
1282: -- Standard call to check for call compatibility.
1283: IF NOT FND_API.compatible_api_call
1284: (
1285: l_api_version,
1286: p_api_version,

Line 1444: -- Standard check of p_commit

1440: END IF;
1441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1442: END IF;
1443:
1444: -- Standard check of p_commit
1445: IF FND_API.To_Boolean(p_commit) THEN
1446: COMMIT WORK;
1447: END IF;
1448:

Line 1513: -- Standard Start of API savepoint

1509:
1510: -- Initialize API return status to success
1511: x_return_status := FND_API.G_RET_STS_SUCCESS;
1512:
1513: -- Standard Start of API savepoint
1514: SAVEPOINT create_route_revision_pub;
1515:
1516: -- Standard call to check for call compatibility.
1517: IF NOT FND_API.compatible_api_call

Line 1516: -- Standard call to check for call compatibility.

1512:
1513: -- Standard Start of API savepoint
1514: SAVEPOINT create_route_revision_pub;
1515:
1516: -- Standard call to check for call compatibility.
1517: IF NOT FND_API.compatible_api_call
1518: (
1519: l_api_version,
1520: p_api_version,

Line 1627: -- Standard check of p_commit

1623: END IF;
1624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1625: END IF;
1626:
1627: -- Standard check of p_commit
1628: IF FND_API.To_Boolean(p_commit) THEN
1629: COMMIT WORK;
1630: END IF;
1631:

Line 1697: -- Standard Start of API savepoint

1693:
1694: -- Initialize API return status to success
1695: x_return_status := FND_API.G_RET_STS_SUCCESS;
1696:
1697: -- Standard Start of API savepoint
1698: SAVEPOINT initiate_route_approval_pub;
1699:
1700: -- Standard call to check for call compatibility.
1701: IF NOT FND_API.compatible_api_call

Line 1700: -- Standard call to check for call compatibility.

1696:
1697: -- Standard Start of API savepoint
1698: SAVEPOINT initiate_route_approval_pub;
1699:
1700: -- Standard call to check for call compatibility.
1701: IF NOT FND_API.compatible_api_call
1702: (
1703: l_api_version,
1704: p_api_version,

Line 1811: -- Standard check of p_commit

1807: END IF;
1808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1809: END IF;
1810:
1811: -- Standard check of p_commit
1812: IF FND_API.To_Boolean(p_commit) THEN
1813: COMMIT WORK;
1814: END IF;
1815:

Line 1874: -- Standard Start of API savepoint

1870:
1871: -- Initialize API return status to success
1872: x_return_status := FND_API.G_RET_STS_SUCCESS;
1873:
1874: -- Standard Start of API savepoint
1875: SAVEPOINT process_route_operation_as_pub;
1876:
1877: -- Standard call to check for call compatibility.
1878: IF NOT FND_API.compatible_api_call

Line 1877: -- Standard call to check for call compatibility.

1873:
1874: -- Standard Start of API savepoint
1875: SAVEPOINT process_route_operation_as_pub;
1876:
1877: -- Standard call to check for call compatibility.
1878: IF NOT FND_API.compatible_api_call
1879: (
1880: l_api_version,
1881: p_api_version,

Line 1986: -- Standard check of p_commit

1982: END IF;
1983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1984: END IF;
1985:
1986: -- Standard check of p_commit
1987: IF FND_API.To_Boolean(p_commit) THEN
1988: COMMIT WORK;
1989: END IF;
1990:

Line 2027: -- standard IN params

2023:
2024:
2025: PROCEDURE Process_Route_Alt_Resources
2026: (
2027: -- standard IN params
2028: p_api_version IN NUMBER,
2029: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
2030: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2031: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,

Line 2034: -- standard OUT params

2030: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
2031: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL,
2032: p_default IN VARCHAR2 :=FND_API.G_FALSE,
2033: p_module_type IN VARCHAR2 :=NULL,
2034: -- standard OUT params
2035: x_return_status OUT NOCOPY VARCHAR2,
2036: x_msg_count OUT NOCOPY NUMBER,
2037: x_msg_data OUT NOCOPY VARCHAR2,
2038: -- procedure params

Line 2083: -- Standard Start of API savepoint

2079:
2080: -- Initialize API return status to success
2081: x_return_status := FND_API.G_RET_STS_SUCCESS;
2082:
2083: -- Standard Start of API savepoint
2084: SAVEPOINT Process_Alt_Resources;
2085:
2086: -- Standard call to check for call compatibility.
2087: IF NOT FND_API.compatible_api_call

Line 2086: -- Standard call to check for call compatibility.

2082:
2083: -- Standard Start of API savepoint
2084: SAVEPOINT Process_Alt_Resources;
2085:
2086: -- Standard call to check for call compatibility.
2087: IF NOT FND_API.compatible_api_call
2088: (
2089: l_api_version,
2090: p_api_version,

Line 2248: -- Standard check of p_commit

2244: END IF;
2245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2246: END IF;
2247:
2248: -- Standard check of p_commit
2249: IF FND_API.To_Boolean(p_commit) THEN
2250: COMMIT WORK;
2251: END IF;
2252: