DBA Data[Home] [Help]

APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on STANDARD

Line 94: -- Standard start of API savepoint

90: 'At the start of PLSQL procedure'
91: );
92: END IF;
93:
94: -- Standard start of API savepoint
95: SAVEPOINT get_visit_cost_details;
96:
97: -- Initialize message list if p_init_msg_list is set to TRUE
98: IF FND_API.To_Boolean( p_init_msg_list) THEN

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

101:
102: -- Initialize API return status to success
103: x_return_status := FND_API.G_RET_STS_SUCCESS;
104:
105: -- Standard call to check for call compatibility.
106: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
107: p_api_version,
108: l_api_name,G_PKG_NAME)
109: THEN

Line 324: -- Standard check of p_commit

320: IF x_msg_count > 0 THEN
321: RAISE FND_API.G_EXC_ERROR;
322: END IF;
323:
324: -- Standard check of p_commit
325: IF FND_API.TO_BOOLEAN(p_commit) THEN
326: COMMIT WORK;
327: END IF;
328:

Line 462: -- Standard start of API savepoint

458: 'At the start of PLSQL procedure'
459: );
460: END IF;
461:
462: -- Standard start of API savepoint
463: SAVEPOINT update_visit_cost_details;
464:
465: -- Initialize message list if p_init_msg_list is set to TRUE
466: IF FND_API.To_Boolean( p_init_msg_list) THEN

Line 813: -- Standard check of p_commit

809: IF x_msg_count > 0 THEN
810: RAISE FND_API.G_EXC_ERROR;
811: END IF;
812:
813: -- Standard check of p_commit
814: IF FND_API.TO_BOOLEAN(p_commit) THEN
815: COMMIT WORK;
816: END IF;
817:

Line 873: -- Standard in/out parameters

869: x_msg_data OUT NOCOPY VARCHAR2)IS
870:
871: -- Local Variables
872:
873: -- Standard in/out parameters
874: l_api_name VARCHAR2(30) := 'ESTIMATE_VISIT_COST ';
875: l_api_version NUMBER := 1.0;
876: l_num_rec NUMBER;
877: l_msg_count NUMBER;

Line 898: -- Standard start of API savepoint

894: 'At the start of PLSQL procedure'
895: );
896: END IF;
897:
898: -- Standard start of API savepoint
899: SAVEPOINT estimate_visit_cost;
900:
901: -- Initialize message list if p_init_msg_list is set to TRUE
902:

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

906:
907: -- Initialize API return status to success
908: x_return_status := FND_API.G_RET_STS_SUCCESS;
909:
910: -- Standard call to check for call compatibility.
911: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
912: p_api_version,
913: l_api_name,G_PKG_NAME)
914: THEN

Line 1039: -- Standard check of p_commit

1035: IF x_msg_count > 0 THEN
1036: RAISE FND_API.G_EXC_ERROR;
1037: END IF;
1038:
1039: -- Standard check of p_commit
1040: IF FND_API.TO_BOOLEAN(p_commit) THEN
1041: COMMIT WORK;
1042: END IF;
1043:

Line 1346: -- Standard in/out parameters

1342: l_z number:=0;
1343: l_flag varchar2(1);
1344: l_visit_task_id AHL_VISIT_TASKS_B.visit_task_id%TYPE;
1345:
1346: -- Standard in/out parameters
1347: l_api_name VARCHAR2(30) := 'ESTIMATE_VISIT_PRICE ';
1348: l_msg_data VARCHAR2(2000);
1349: l_api_version NUMBER := 1.0;
1350: l_num_rec NUMBER;

Line 1433: -- Standard start of API savepoint

1429: 'At the start of PLSQL procedure'
1430: );
1431: END IF;
1432:
1433: -- Standard start of API savepoint
1434: SAVEPOINT estimate_visit_price;
1435:
1436: -- Initialize message list if p_init_msg_list is set to TRUE
1437: IF FND_API.To_Boolean( p_init_msg_list) THEN

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

1440:
1441: -- Initialize API return status to success
1442: x_return_status := FND_API.G_RET_STS_SUCCESS;
1443:
1444: -- Standard call to check for call compatibility.
1445: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
1446: p_api_version,
1447: l_api_name,G_PKG_NAME)
1448: THEN

Line 2056: -- Standard check of p_commit

2052: END IF;
2053:
2054:
2055:
2056: -- Standard check of p_commit
2057:
2058: IF FND_API.TO_BOOLEAN(p_commit) THEN
2059: COMMIT WORK;
2060: END IF;

Line 2172: -- Standard start of API savepoint

2168: 'At the start of PLSQL procedure'
2169: );
2170: END IF;
2171:
2172: -- Standard start of API savepoint
2173:
2174: SAVEPOINT create_price_snapshot;
2175:
2176: -- Initialize message list if p_init_msg_list is set to TRUE

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

2182: -- Initialize API return status to success
2183:
2184: x_return_status := FND_API.G_RET_STS_SUCCESS;
2185:
2186: -- Standard call to check for call compatibility.
2187: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
2188: p_api_version,
2189: l_api_name,G_PKG_NAME)
2190: THEN

Line 2328: -- Standard check of p_commit

2324: IF x_msg_count > 0 THEN
2325: RAISE FND_API.G_EXC_ERROR;
2326: END IF;
2327:
2328: -- Standard check of p_commit
2329: IF FND_API.TO_BOOLEAN(p_commit) THEN
2330: COMMIT WORK;
2331: END IF;
2332:

Line 2453: -- Standard start of API savepoint

2449: 'At the start of PLSQL procedure'
2450: );
2451: END IF;
2452:
2453: -- Standard start of API savepoint
2454: SAVEPOINT create_cost_snapshot;
2455:
2456: -- Initialize message list if p_init_msg_list is set to TRUE
2457: IF FND_API.To_Boolean( p_init_msg_list) THEN

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

2460:
2461: -- Initialize API return status to success
2462: x_return_status := FND_API.G_RET_STS_SUCCESS;
2463:
2464: -- Standard call to check for call compatibility.
2465: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
2466: p_api_version,
2467: l_api_name,G_PKG_NAME)
2468: THEN

Line 2667: -- Standard check of p_commit

2663: IF x_msg_count > 0 THEN
2664: RAISE FND_API.G_EXC_ERROR;
2665: END IF;
2666:
2667: -- Standard check of p_commit
2668: IF FND_API.TO_BOOLEAN(p_commit) THEN
2669: COMMIT WORK;
2670: END IF;
2671: