eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_VISIT_CST_PR_PVT dependencies on STANDARD

Line 112: -- Standard start of API savepoint

108: 'At the start of PLSQL procedure'
109: );
110: END IF;
111:
112: -- Standard start of API savepoint
113: SAVEPOINT get_visit_cost_details;
114:
115: -- Initialize message list if p_init_msg_list is set to TRUE
116: IF FND_API.To_Boolean( p_init_msg_list) THEN

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

119:
120: -- Initialize API return status to success
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122:
123: -- Standard call to check for call compatibility.
124: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
125: p_api_version,
126: l_api_name,G_PKG_NAME)
127: THEN

Line 361: -- Standard check of p_commit

357: IF x_msg_count > 0 THEN
358: RAISE FND_API.G_EXC_ERROR;
359: END IF;
360:
361: -- Standard check of p_commit
362: IF FND_API.TO_BOOLEAN(p_commit) THEN
363: COMMIT WORK;
364: END IF;
365:

Line 509: -- Standard start of API savepoint

505: 'At the start of PLSQL procedure'
506: );
507: END IF;
508:
509: -- Standard start of API savepoint
510: SAVEPOINT update_visit_cost_details;
511:
512: -- Initialize message list if p_init_msg_list is set to TRUE
513: IF FND_API.To_Boolean( p_init_msg_list) THEN

Line 872: -- Standard check of p_commit

868: IF x_msg_count > 0 THEN
869: RAISE FND_API.G_EXC_ERROR;
870: END IF;
871:
872: -- Standard check of p_commit
873: IF FND_API.TO_BOOLEAN(p_commit) THEN
874: COMMIT WORK;
875: END IF;
876:

Line 932: -- Standard in/out parameters

928: x_msg_data OUT NOCOPY VARCHAR2)IS
929:
930: -- Local Variables
931:
932: -- Standard in/out parameters
933: l_api_name VARCHAR2(30) := 'ESTIMATE_VISIT_COST ';
934: l_api_version NUMBER := 1.0;
935: l_num_rec NUMBER;
936: l_msg_count NUMBER;

Line 959: -- Standard start of API savepoint

955: 'At the start of PLSQL procedure'
956: );
957: END IF;
958:
959: -- Standard start of API savepoint
960: SAVEPOINT estimate_visit_cost;
961:
962: -- Initialize message list if p_init_msg_list is set to TRUE
963:

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

967:
968: -- Initialize API return status to success
969: x_return_status := FND_API.G_RET_STS_SUCCESS;
970:
971: -- Standard call to check for call compatibility.
972: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
973: p_api_version,
974: l_api_name,G_PKG_NAME)
975: THEN

Line 1039: --salogan::Added release flag parameter based on the module type BG/Standard CP ER 9299910::01-JUN-2009::BEGIN

1035: 'Before calling ahl vwp proj prod pvt.release visit'
1036: );
1037: END IF;
1038:
1039: --salogan::Added release flag parameter based on the module type BG/Standard CP ER 9299910::01-JUN-2009::BEGIN
1040: IF (p_module_type = l_bg_module_type) THEN
1041: l_bg_release_flag := 'U';
1042: END IF;
1043:

Line 1056: --salogan::Added release flag parameter based on the module type BG/Standard CP ER 9299910::01-JUN-2009::END

1052: x_return_status => l_return_status,
1053: x_msg_count => l_msg_count,
1054: x_msg_data => l_msg_data);
1055:
1056: --salogan::Added release flag parameter based on the module type BG/Standard CP ER 9299910::01-JUN-2009::END
1057:
1058: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1059: fnd_log.string
1060: (

Line 1108: -- Standard check of p_commit

1104: IF x_msg_count > 0 THEN
1105: RAISE FND_API.G_EXC_ERROR;
1106: END IF;
1107:
1108: -- Standard check of p_commit
1109: IF FND_API.TO_BOOLEAN(p_commit) THEN
1110: COMMIT WORK;
1111: END IF;
1112:

Line 1415: -- Standard in/out parameters

1411: l_z number:=0;
1412: l_flag varchar2(1);
1413: l_visit_task_id AHL_VISIT_TASKS_B.visit_task_id%TYPE;
1414:
1415: -- Standard in/out parameters
1416: l_api_name VARCHAR2(30) := 'ESTIMATE_VISIT_PRICE ';
1417: l_msg_data VARCHAR2(2000);
1418: l_api_version NUMBER := 1.0;
1419: l_num_rec NUMBER;

Line 1502: -- Standard start of API savepoint

1498: 'At the start of PLSQL procedure'
1499: );
1500: END IF;
1501:
1502: -- Standard start of API savepoint
1503: SAVEPOINT estimate_visit_price;
1504:
1505: -- Initialize message list if p_init_msg_list is set to TRUE
1506: IF FND_API.To_Boolean( p_init_msg_list) THEN

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

1509:
1510: -- Initialize API return status to success
1511: x_return_status := FND_API.G_RET_STS_SUCCESS;
1512:
1513: -- Standard call to check for call compatibility.
1514: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
1515: p_api_version,
1516: l_api_name,G_PKG_NAME)
1517: THEN

Line 2137: -- Standard check of p_commit

2133: END IF;
2134:
2135:
2136:
2137: -- Standard check of p_commit
2138:
2139: IF FND_API.TO_BOOLEAN(p_commit) THEN
2140: COMMIT WORK;
2141: END IF;

Line 2253: -- Standard start of API savepoint

2249: 'At the start of PLSQL procedure'
2250: );
2251: END IF;
2252:
2253: -- Standard start of API savepoint
2254:
2255: SAVEPOINT create_price_snapshot;
2256:
2257: -- Initialize message list if p_init_msg_list is set to TRUE

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

2263: -- Initialize API return status to success
2264:
2265: x_return_status := FND_API.G_RET_STS_SUCCESS;
2266:
2267: -- Standard call to check for call compatibility.
2268: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
2269: p_api_version,
2270: l_api_name,G_PKG_NAME)
2271: THEN

Line 2409: -- Standard check of p_commit

2405: IF x_msg_count > 0 THEN
2406: RAISE FND_API.G_EXC_ERROR;
2407: END IF;
2408:
2409: -- Standard check of p_commit
2410: IF FND_API.TO_BOOLEAN(p_commit) THEN
2411: COMMIT WORK;
2412: END IF;
2413:

Line 2534: -- Standard start of API savepoint

2530: 'At the start of PLSQL procedure'
2531: );
2532: END IF;
2533:
2534: -- Standard start of API savepoint
2535: SAVEPOINT create_cost_snapshot;
2536:
2537: -- Initialize message list if p_init_msg_list is set to TRUE
2538: IF FND_API.To_Boolean( p_init_msg_list) THEN

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

2541:
2542: -- Initialize API return status to success
2543: x_return_status := FND_API.G_RET_STS_SUCCESS;
2544:
2545: -- Standard call to check for call compatibility.
2546: IF NOT Fnd_Api.COMPATIBLE_API_CALL(l_api_version,
2547: p_api_version,
2548: l_api_name,G_PKG_NAME)
2549: THEN

Line 2748: -- Standard check of p_commit

2744: IF x_msg_count > 0 THEN
2745: RAISE FND_API.G_EXC_ERROR;
2746: END IF;
2747:
2748: -- Standard check of p_commit
2749: IF FND_API.TO_BOOLEAN(p_commit) THEN
2750: COMMIT WORK;
2751: END IF;
2752:

Line 3557: -- Standard IN Parameters :

3553: -- PURPOSE
3554: -- To estimate visit cost for a specific visit as a background process
3555: -- Parameters :
3556:
3557: -- Standard IN Parameters :
3558: -- p_api_version IN NUMBER := 1.0,
3559: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3560: -- p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
3561: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

Line 3563: -- Standard OUT Parameters :

3559: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
3560: -- p_commit IN VARCHAR2 := Fnd_Api.G_FALSE
3561: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
3562: --
3563: -- Standard OUT Parameters :
3564: -- x_return_status OUT VARCHAR2 Required
3565: -- x_msg_count OUT NUMBER Required
3566: -- x_msg_data OUT VARCHAR2 Required
3567:

Line 3590: --Standard/local variables

3586: x_msg_count OUT NOCOPY NUMBER,
3587: x_msg_data OUT NOCOPY VARCHAR2
3588: )
3589: IS
3590: --Standard/local variables
3591: L_API_NAME CONSTANT VARCHAR2(30) := 'bg_estimate_visit_cost';
3592: L_API_VERSION CONSTANT NUMBER := 1.0;
3593: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
3594: l_msg_data VARCHAR2(2000);

Line 3631: -- Standard start of API savepoint

3627: BEGIN
3628: IF (l_log_procedure >= l_log_current_level) THEN
3629: fnd_log.string(l_log_procedure,L_DEBUG_KEY||'.begin','At the start of the PLSQL procedure. Visit id = ' || p_x_cost_price_rec.Visit_id);
3630: END IF;
3631: -- Standard start of API savepoint
3632: SAVEPOINT bg_estimate_visit_cost_pvt;
3633:
3634: -- Initialize message list if p_init_msg_list is set to TRUE
3635: IF FND_API.To_Boolean(p_init_msg_list) THEN

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

3637: END IF;
3638: -- Initialize API return status to success
3639: x_return_status := FND_API.G_RET_STS_SUCCESS;
3640:
3641: -- Standard call to check for call compatibility.
3642: IF NOT FND_API.COMPATIBLE_API_CALL(L_API_VERSION,
3643: p_api_version,
3644: L_API_NAME,G_PKG_NAME) THEN
3645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3817: -- Standard/Local variables section

3813: )
3814: IS
3815:
3816:
3817: -- Standard/Local variables section
3818: l_api_version NUMBER := 1.0;
3819: l_api_name VARCHAR2(30) := 'bg_exec_estimate_visit_cost';
3820: l_msg_count NUMBER;
3821: l_msg_data VARCHAR2(2000);

Line 3829: -- Standard start of API savepoint

3825: l_cost_price_rec AHL_VWP_VISIT_CST_PR_PVT.cost_price_rec_type;
3826:
3827: BEGIN
3828:
3829: -- Standard start of API savepoint
3830: SAVEPOINT bg_exec_estimate_visit_cost;
3831:
3832: -- 1. Initialize error message stack by default
3833: FND_MSG_PUB.Initialize;

Line 3835: -- Standard call to check for call compatibility

3831:
3832: -- 1. Initialize error message stack by default
3833: FND_MSG_PUB.Initialize;
3834:
3835: -- Standard call to check for call compatibility
3836: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3837: retcode := 2;
3838: errbuf := FND_MSG_PUB.Get;
3839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;