DBA Data[Home] [Help]

APPS.AHL_VWP_TASK_CST_PR_PVT dependencies on AHL_VWP_PRICE_PVT

Line 2087: 'Before calling ahl vwp price pvt.Get Task Estimated Price'

2083: fnd_log.string
2084: (
2085: fnd_log.level_procedure,
2086: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2087: 'Before calling ahl vwp price pvt.Get Task Estimated Price'
2088: );
2089:
2090: END IF;
2091:

Line 2147: ahl_vwp_price_pvt.Get_Task_Estimated_Price (

2143:
2144: RAISE FND_API.G_EXC_ERROR;
2145: END IF;
2146:
2147: ahl_vwp_price_pvt.Get_Task_Estimated_Price (
2148: p_visit_task_id => l_cost_price_rec.visit_task_id,
2149: p_route_id => l_route_id,
2150: p_price_list_id => l_cost_price_rec.price_list_id,
2151: p_customer_id => l_cost_price_rec.customer_id,

Line 2164: 'After calling ahl vwp price pvt.Get Task Estimated Price, Return Status : '|| l_return_status

2160: fnd_log.string
2161: (
2162: fnd_log.level_procedure,
2163: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
2164: 'After calling ahl vwp price pvt.Get Task Estimated Price, Return Status : '|| l_return_status
2165: );
2166: END IF;
2167:
2168: -- Check return status.

Line 2209: 'Before calling ahl vwp price pvt.Get Job Estimated Price'

2205: fnd_log.string
2206: (
2207: fnd_log.level_procedure,
2208: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2209: 'Before calling ahl vwp price pvt.Get Job Estimated Price'
2210: );
2211:
2212: END IF;
2213:

Line 2236: ahl_vwp_price_pvt.Get_Job_Estimated_Price (

2232: );
2233:
2234: END IF;
2235:
2236: ahl_vwp_price_pvt.Get_Job_Estimated_Price (
2237: p_visit_task_id => l_cost_price_rec.visit_task_id,
2238: p_price_list_id => l_cost_price_rec.price_list_id,
2239: p_customer_id => l_cost_price_rec.customer_id,
2240: p_currency_code => l_cost_price_rec.currency,

Line 2249: 'After calling ahl vwp price pvt.Get Job Estimated Price, Return Status : '|| l_return_status

2245: fnd_log.string
2246: (
2247: fnd_log.level_procedure,
2248: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
2249: 'After calling ahl vwp price pvt.Get Job Estimated Price, Return Status : '|| l_return_status
2250: );
2251: END IF;
2252:
2253: -- Check return status.

Line 2272: -- Call ahl_vwp_price_pvt.get_task_actual_price

2268: ' Derieved value from Job Estimated Price, Estimated Price: ' || l_estimated_price
2269: );
2270: END IF;
2271:
2272: -- Call ahl_vwp_price_pvt.get_task_actual_price
2273: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2274: fnd_log.string
2275: (
2276: fnd_log.level_procedure,

Line 2278: 'Before calling ahl vwp price pvt.Get Job Actual Price'

2274: fnd_log.string
2275: (
2276: fnd_log.level_procedure,
2277: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
2278: 'Before calling ahl vwp price pvt.Get Job Actual Price'
2279: );
2280:
2281: END IF;
2282:

Line 2305: ahl_vwp_price_pvt.Get_job_Actual_Price (

2301: );
2302:
2303: END IF;
2304:
2305: ahl_vwp_price_pvt.Get_job_Actual_Price (
2306: p_visit_task_id => l_cost_price_rec.visit_task_id,
2307: p_price_list_id => l_cost_price_rec.price_list_id,
2308: p_customer_id => l_cost_price_rec.customer_id,
2309: p_currency_code => l_cost_price_rec.currency,

Line 3382: AHL_VWP_PRICE_PVT.get_items_without_price

3378: );
3379: END IF;
3380:
3381:
3382: AHL_VWP_PRICE_PVT.get_items_without_price
3383: (
3384: p_item_tbl =>l_item_tbl,
3385: p_price_list_id =>l_cost_price_rec.price_list_id,
3386: p_customer_id =>l_cost_price_rec.customer_id,

Line 3546: AHL_VWP_PRICE_PVT.Check_Item_for_Resource_Trans

3542:
3543: If p_job_status_code<>'17'
3544: then
3545:
3546: AHL_VWP_PRICE_PVT.Check_Item_for_Resource_Trans
3547: (
3548: p_visit_task_id =>p_visit_task_id,
3549: x_item_tbl =>l_item_tbl1,
3550: x_return_status =>l_return_status

Line 3563: AHL_VWP_PRICE_PVT.Check_Item_for_Materials_Trans

3559: );
3560:
3561: END IF;
3562:
3563: AHL_VWP_PRICE_PVT.Check_Item_for_Materials_Trans
3564: (
3565: p_visit_task_id =>p_visit_task_id,
3566: x_item_tbl =>l_item_tbl2,
3567: x_return_status =>l_return_status

Line 3745: AHL_VWP_PRICE_PVT.check_item_for_rt_res_req

3741: open c_mr_route_csr (l_task_rec.mr_route_id);
3742: fetch c_mr_route_csr into l_mr_route_rec;
3743: close c_mr_route_csr;
3744:
3745: AHL_VWP_PRICE_PVT.check_item_for_rt_res_req
3746: (
3747: p_visit_task_id =>p_visit_task_id,
3748: p_route_id =>l_mr_route_Rec.route_id,
3749: p_organization_id =>l_task_rec.organization_id,

Line 3766: AHL_VWP_PRICE_PVT.Check_Item_for_Rt_Mat_Req

3762: );
3763:
3764: END IF;
3765:
3766: AHL_VWP_PRICE_PVT.Check_Item_for_Rt_Mat_Req
3767: (
3768: p_visit_task_id =>p_visit_task_id,
3769: p_route_id =>l_mr_route_rec.route_id,
3770: p_effective_date =>p_task_start_time,

Line 3796: AHL_VWP_PRICE_PVT.check_item_for_prod_res_req

3792:
3793:
3794: Else
3795:
3796: AHL_VWP_PRICE_PVT.check_item_for_prod_res_req
3797: (
3798: p_visit_task_id =>p_visit_task_id,
3799: x_item_tbl =>l_item_tbl_res,
3800: x_return_status =>l_return_status

Line 3813: AHL_VWP_PRICE_PVT.check_item_for_prod_mat_req

3809: );
3810:
3811: END IF;
3812:
3813: AHL_VWP_PRICE_PVT.check_item_for_prod_mat_req
3814: (
3815: p_visit_task_id =>p_visit_task_id,
3816: x_item_tbl =>l_item_tbl_mat,
3817: x_return_status =>l_return_status

Line 3847: AHL_VWP_PRICE_PVT.Check_Item_for_Resource_Trans

3843: );
3844:
3845: END IF;
3846:
3847: AHL_VWP_PRICE_PVT.Check_Item_for_Resource_Trans
3848: (
3849: p_visit_task_id =>p_visit_task_id,
3850: x_item_tbl =>l_item_tbl_res,
3851: x_return_status =>l_return_status

Line 3864: AHL_VWP_PRICE_PVT.Check_Item_for_Materials_Trans

3860: );
3861:
3862: END IF;
3863:
3864: AHL_VWP_PRICE_PVT.Check_Item_for_Materials_Trans
3865: (
3866: p_visit_task_id =>p_visit_task_id,
3867: x_item_tbl =>l_item_tbl_mat,
3868: x_return_status =>l_return_status