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_TASK_CST_PR_PVT dependencies on AHL_VWP_TASK_CST_PR_PVT

Line 1: PACKAGE BODY AHL_VWP_TASK_CST_PR_PVT AS

1: PACKAGE BODY AHL_VWP_TASK_CST_PR_PVT AS
2: /* $Header: AHLVTCPB.pls 120.7 2006/05/24 13:14:53 anraj noship $ */
3: -----------------------------------------------------------
4: -- PACKAGE
5: -- Ahl_VWP_TASK_CST_PR_PVT

Line 5: -- Ahl_VWP_TASK_CST_PR_PVT

1: PACKAGE BODY AHL_VWP_TASK_CST_PR_PVT AS
2: /* $Header: AHLVTCPB.pls 120.7 2006/05/24 13:14:53 anraj noship $ */
3: -----------------------------------------------------------
4: -- PACKAGE
5: -- Ahl_VWP_TASK_CST_PR_PVT
6: --
7: -- PURPOSE
8: -- This package is a Private API to process Estimating Cost and Price
9: -- for a Task It contains specification for pl/sql records and tables

Line 28: G_PKG_NAME CONSTANT VARCHAR(30) := 'AHL_VWP_TASK_CST_PR_PVT';

24:
25: -----------------------------------------------------------
26: -- Declare Constants --
27: -----------------------------------------------------------
28: G_PKG_NAME CONSTANT VARCHAR(30) := 'AHL_VWP_TASK_CST_PR_PVT';
29: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
30: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
31:
32: PROCEDURE GET_OTHER_TASK_ITEMS (

Line 198: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Get_Task_Cost_Details.begin',

194: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
195: fnd_log.string
196: (
197: fnd_log.level_procedure,
198: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Get_Task_Cost_Details.begin',
199: 'At the start of PLSQL procedure'
200: );
201: END IF;
202:

Line 767: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Get_Task_Cost_Details.end',

763: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
764: fnd_log.string
765: (
766: fnd_log.level_procedure,
767: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Get_Task_Cost_Details.end',
768: 'At the end of PLSQL procedure'
769: );
770: END IF;
771: EXCEPTION

Line 926: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Update_Task_Cost_Details.begin',

922: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
923: fnd_log.string
924: (
925: fnd_log.level_procedure,
926: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Update_Task_Cost_Details.begin',
927: 'At the start of PLSQL procedure'
928: );
929:
930: END IF;

Line 1236: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Update_Task_Cost_Details.end',

1232: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1233: fnd_log.string
1234: (
1235: fnd_log.level_procedure,
1236: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Update_Task_Cost_Details.end',
1237: 'At the end of PLSQL procedure'
1238: );
1239: END IF;
1240: EXCEPTION

Line 1347: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Cost.begin',

1343: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1344: fnd_log.string
1345: (
1346: fnd_log.level_procedure,
1347: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Cost.begin',
1348: 'At the start of PLSQL procedure'
1349: );
1350:
1351: END IF;

Line 1531: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Cost.end',

1527: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1528: fnd_log.string
1529: (
1530: fnd_log.level_procedure,
1531: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Cost.end',
1532: 'At the end of PLSQL procedure'
1533: );
1534: END IF;
1535: EXCEPTION

Line 1696: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price.begin',

1692: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1693: fnd_log.string
1694: (
1695: fnd_log.level_procedure,
1696: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price.begin',
1697: 'At the start of PLSQL procedure'
1698: );
1699:
1700: END IF;

Line 1914: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',

1910: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1911: fnd_log.string
1912: (
1913: fnd_log.level_statement,
1914: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',
1915: 'Mr Id : ' || l_cost_price_rec.mr_id
1916: );
1917:
1918: END IF;

Line 1957: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',

1953: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
1954: fnd_log.string
1955: (
1956: fnd_log.level_statement,
1957: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',
1958: 'Derieved value from Estimate Mr price for Summary task, Estimated Price : ' || l_estimated_price
1959: );
1960:
1961: fnd_log.string

Line 1964: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',

1960:
1961: fnd_log.string
1962: (
1963: fnd_log.level_statement,
1964: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',
1965: 'Derieved value from Estimate Mr price for Summary task, Actual Price : ' || l_actual_price
1966: );
1967:
1968: END IF;

Line 2014: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',

2010: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2011: fnd_log.string
2012: (
2013: fnd_log.level_statement,
2014: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',
2015: ' Job Status Code: ' || l_job_status_code
2016: );
2017: fnd_log.string
2018: (

Line 2020: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',

2016: );
2017: fnd_log.string
2018: (
2019: fnd_log.level_statement,
2020: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',
2021: ' Job Status Mean: ' || l_job_status_mean
2022: );
2023: fnd_log.string
2024: (

Line 2051: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',

2047: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2048: fnd_log.string
2049: (
2050: fnd_log.level_statement,
2051: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',
2052: ' For task with Route Id: ' || l_route_id
2053: );
2054: END IF;
2055:

Line 2071: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',

2067: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2068: fnd_log.string
2069: (
2070: fnd_log.level_statement,
2071: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',
2072: ' Derieved task start date: ' || l_cost_price_rec.task_start_date
2073: );
2074:
2075: END IF;

Line 2096: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',

2092: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2093: fnd_log.string
2094: (
2095: fnd_log.level_statement,
2096: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',
2097: ' Before Calling Task Estimated Price, Route Id: ' || l_route_id
2098: );
2099: fnd_log.string
2100: (

Line 2102: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',

2098: );
2099: fnd_log.string
2100: (
2101: fnd_log.level_statement,
2102: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',
2103: ' Before Calling Task Estimated Price, Price List Id: ' || l_cost_price_rec.price_list_id
2104: );
2105:
2106: fnd_log.string

Line 2109: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',

2105:
2106: fnd_log.string
2107: (
2108: fnd_log.level_statement,
2109: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',
2110: ' Before Calling Task Estimated Price, Customer Id: ' || l_cost_price_rec.customer_id
2111: );
2112: fnd_log.string
2113: (

Line 2115: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',

2111: );
2112: fnd_log.string
2113: (
2114: fnd_log.level_statement,
2115: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',
2116: ' Before Calling Task Estimated Price, Currency: ' || l_cost_price_rec.currency
2117: );
2118: fnd_log.string
2119: (

Line 2121: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',

2117: );
2118: fnd_log.string
2119: (
2120: fnd_log.level_statement,
2121: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',
2122: ' Before Calling Task Estimated Price, Task Start Date: ' || l_cost_price_rec.task_start_date
2123: );
2124: fnd_log.string
2125: (

Line 2127: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',

2123: );
2124: fnd_log.string
2125: (
2126: fnd_log.level_statement,
2127: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',
2128: ' Before Calling Task Estimated Price, Organization Id: ' || l_cost_price_rec.organization_id
2129: );
2130:
2131: END IF;

Line 2190: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',

2186: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2187: fnd_log.string
2188: (
2189: fnd_log.level_statement,
2190: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',
2191: ' Derieved Value for Estimated Price: ' || l_cost_price_rec.estimated_price
2192: );
2193: fnd_log.string
2194: (

Line 2196: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',

2192: );
2193: fnd_log.string
2194: (
2195: fnd_log.level_statement,
2196: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',
2197: ' Derieved Value for Actual Price: ' || l_cost_price_rec.actual_price
2198: );
2199: END IF;
2200:

Line 2218: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',

2214: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2215: fnd_log.string
2216: (
2217: fnd_log.level_statement,
2218: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',
2219: ' Before Calling Job Estimated Price, Price List Id: ' || l_cost_price_rec.price_list_id
2220: );
2221: fnd_log.string
2222: (

Line 2224: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',

2220: );
2221: fnd_log.string
2222: (
2223: fnd_log.level_statement,
2224: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',
2225: ' Before Calling Job Estimated Price, Customer Id: ' || l_cost_price_rec.customer_id
2226: );
2227: fnd_log.string
2228: (

Line 2230: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',

2226: );
2227: fnd_log.string
2228: (
2229: fnd_log.level_statement,
2230: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price',
2231: ' Before Calling Job Estimated Price, Currency: ' || l_cost_price_rec.currency
2232: );
2233:
2234: END IF;

Line 2576: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price.end',

2572: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2573: fnd_log.string
2574: (
2575: fnd_log.level_procedure,
2576: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Estimate_Task_Price.end',
2577: 'At the end of PLSQL procedure'
2578: );
2579: END IF;
2580:

Line 2676: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Get_Node_Cost_Details',

2672: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2673: fnd_log.string
2674: (
2675: fnd_log.level_procedure,
2676: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Get_Node_Cost_Details',
2677: 'At the start of procedure Get_Node_Cost_Details_pvt and the values are visit_id:'||l_cost_price_rec.visit_id||' visit task_id'||l_cost_price_rec.visit_task_id||
2678: 'mr_Sesion_id'||l_cost_price_rec.mr_session_id|| ' cost session_id '||l_cost_price_rec.cost_Session_id
2679: );
2680: END IF;

Line 2700: 'AHL_VWP_TASK_CST_PR_PVT.Get_Node_Cost_Details Visit Task Id'||l_cost_price_rec.visit_task_id,

2696: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
2697: fnd_log.string
2698: (
2699: fnd_log.level_statement,
2700: 'AHL_VWP_TASK_CST_PR_PVT.Get_Node_Cost_Details Visit Task Id'||l_cost_price_rec.visit_task_id,
2701: 'Visit ID: ' || l_cost_price_rec.visit_id
2702: );
2703: END IF;
2704:

Line 2798: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Get_Node_Cost_Details',

2794: IF (fnd_log.level_error >= fnd_log.g_current_runtime_level)THEN
2795: fnd_log.string
2796: (
2797: fnd_log.level_error,
2798: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.Get_Node_Cost_Details',
2799: 'Error : visit task id is null'
2800: );
2801:
2802: FND_MESSAGE.Set_Name(G_APP_NAME,'AHL_VWP_CST_INPUT_MISS');

Line 3018: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_TASK_ITEMS_NO_PRICE.begin',

3014: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3015: fnd_log.string
3016: (
3017: fnd_log.level_procedure,
3018: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_TASK_ITEMS_NO_PRICE.begin',
3019: 'At the start of PLSQL procedure'
3020: );
3021:
3022: END IF;

Line 3336: AHL_VWP_TASK_CST_PR_PVT.Get_Unassociated_Items

3332:
3333:
3334: If l_task_rec.task_type_code='UNASSOCIATED'
3335: then
3336: AHL_VWP_TASK_CST_PR_PVT.Get_Unassociated_Items
3337: (
3338: p_api_version =>p_api_version,
3339: p_init_msg_list =>Fnd_Api.G_FALSE,
3340: p_commit =>Fnd_Api.G_FALSE,

Line 3354: AHL_VWP_TASK_CST_PR_PVT.get_other_task_items

3350:
3351: elsif l_task_rec.MR_ID is not Null and (l_task_rec.task_type_code ='PLANNED'
3352: OR l_task_rec.task_type_code ='UNPLANNED')
3353: then
3354: AHL_VWP_TASK_CST_PR_PVT.get_other_task_items
3355: (
3356: p_api_version =>p_api_version,
3357: p_init_msg_list =>Fnd_Api.G_FALSE,
3358: p_commit =>Fnd_Api.G_FALSE,

Line 3460: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_TASK_ITEMS_NO_PRICE.begin',

3456: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3457: fnd_log.string
3458: (
3459: fnd_log.level_procedure,
3460: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_TASK_ITEMS_NO_PRICE.begin',
3461: 'At the end of PLSQL procedure'
3462: );
3463:
3464: END IF;

Line 3535: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_UNASSOCIATED_ITEMS.begin',

3531: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3532: fnd_log.string
3533: (
3534: fnd_log.level_procedure,
3535: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_UNASSOCIATED_ITEMS.begin',
3536: 'At the start of PLSQL procedure'
3537: );
3538:
3539: END IF;

Line 3557: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_UNASSOCIATED_ITEMS.begin',

3553: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3554: fnd_log.string
3555: (
3556: fnd_log.level_statement,
3557: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_UNASSOCIATED_ITEMS.begin',
3558: 'Number of items for resource transactions: ' || l_item_tbl1.count
3559: );
3560:
3561: END IF;

Line 3575: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_UNASSOCIATED_ITEMS.begin',

3571: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3572: fnd_log.string
3573: (
3574: fnd_log.level_statement,
3575: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_UNASSOCIATED_ITEMS.begin',
3576: 'Number of items for materials transactions: ' || l_item_tbl2.count
3577: );
3578:
3579: END IF;

Line 3602: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_UNASSOCIATED_ITEMS.begin',

3598: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3599: fnd_log.string
3600: (
3601: fnd_log.level_statement,
3602: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_UNASSOCIATED_ITEMS.begin',
3603: 'Number of items for material and resource transactions: ' || l_item_tbl.count
3604: );
3605:
3606: END IF;

Line 3619: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_UNASSOCIATED_ITEMS.end',

3615: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3616: fnd_log.string
3617: (
3618: fnd_log.level_statement,
3619: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_UNASSOCIATED_ITEMS.end',
3620: 'At the end of PLSQL procedure'
3621: );
3622:
3623: END IF;

Line 3708: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS.begin',

3704: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
3705: fnd_log.string
3706: (
3707: fnd_log.level_procedure,
3708: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS.begin',
3709: 'At the begining of PLSQL procedure'
3710: );
3711:
3712: END IF;

Line 3760: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS',

3756: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3757: fnd_log.string
3758: (
3759: fnd_log.level_statement,
3760: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS',
3761: 'Number of items for route resource requirements: ' || l_item_tbl_res.count
3762: );
3763:
3764: END IF;

Line 3780: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS',

3776: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3777: fnd_log.string
3778: (
3779: fnd_log.level_statement,
3780: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS',
3781: 'Number of items for route material requirements: ' || l_item_tbl_mat.count
3782: );
3783:
3784: END IF;

Line 3807: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS',

3803: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3804: fnd_log.string
3805: (
3806: fnd_log.level_statement,
3807: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS',
3808: 'Number of items for production resource requirements: ' || l_item_tbl_res.count
3809: );
3810:
3811: END IF;

Line 3824: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS',

3820: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3821: fnd_log.string
3822: (
3823: fnd_log.level_statement,
3824: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS',
3825: 'Number of items for production material requirements: ' || l_item_tbl_mat.count
3826: );
3827:
3828: END IF;

Line 3841: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS',

3837: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3838: fnd_log.string
3839: (
3840: fnd_log.level_statement,
3841: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS',
3842: 'Number of items for production material and resource requirements: ' || l_item_tbl.count
3843: );
3844:
3845: END IF;

Line 3858: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS',

3854: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3855: fnd_log.string
3856: (
3857: fnd_log.level_statement,
3858: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS',
3859: 'Number of items for production resource transactions: ' || l_item_tbl_res.count
3860: );
3861:
3862: END IF;

Line 3875: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS',

3871: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3872: fnd_log.string
3873: (
3874: fnd_log.level_statement,
3875: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS',
3876: 'Number of items for production material transactions: ' || l_item_tbl_mat.count
3877: );
3878:
3879: END IF;

Line 3892: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS',

3888: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3889: fnd_log.string
3890: (
3891: fnd_log.level_statement,
3892: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS',
3893: 'Number of items for production material and resource transactions: ' || l_item_tbl1.count
3894: );
3895:
3896: END IF;

Line 3914: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS',

3910:
3911: fnd_log.string
3912: (
3913: fnd_log.level_statement,
3914: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS',
3915: 'Number of items for all requirements and transactions: ' || l_item_tbl.count
3916: );
3917:
3918: END IF;

Line 3939: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS.end',

3935: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
3936: fnd_log.string
3937: (
3938: fnd_log.level_statement,
3939: 'ahl.plsql.AHL_VWP_TASK_CST_PR_PVT.GET_OTHER_TASK_ITEMS.end',
3940: 'At the end of PLSQL procedure'
3941: );
3942:
3943: END IF;

Line 3978: END AHL_VWP_TASK_CST_PR_PVT;

3974:
3975: END GET_OTHER_TASK_ITEMS;
3976:
3977:
3978: END AHL_VWP_TASK_CST_PR_PVT;