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_RULES_PVT

Line 44: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.ITEM_TBL_TYPE

40: x_msg_data OUT NOCOPY VARCHAR2,
41: p_visit_task_id IN NUMBER,
42: p_job_status_code IN VARCHAR2,
43: p_task_start_time IN DATE,
44: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.ITEM_TBL_TYPE
45: );
46:
47:
48: PROCEDURE GET_UNASSOCIATED_ITEMS (

Line 59: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.ITEM_TBL_TYPE

55: x_msg_count OUT NOCOPY NUMBER,
56: x_msg_data OUT NOCOPY VARCHAR2,
57: p_visit_task_id IN NUMBER,
58: p_job_status_code IN VARCHAR2,
59: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.ITEM_TBL_TYPE
60: );
61:
62: --
63: -- Start of Comments --

Line 621: ahl_vwp_rules_pvt.check_currency_for_costing

617: 'Before calling ahl vwp cost pvt.check currency for costing '
618: );
619: END IF;
620: -- Get Currency
621: ahl_vwp_rules_pvt.check_currency_for_costing
622: (
623: p_visit_id => l_cost_price_rec.visit_id,
624: x_currency_code => l_cost_price_rec.currency);
625:

Line 1799: ahl_vwp_rules_pvt.check_currency_for_costing

1795: END IF;
1796:
1797: IF l_cost_price_rec.currency IS NULL THEN
1798: -- Get Currency
1799: ahl_vwp_rules_pvt.check_currency_for_costing
1800: (
1801: p_visit_id => l_cost_price_rec.visit_id,
1802: x_currency_code => l_cost_price_rec.currency);
1803: -- error handling

Line 1979: 'Before calling ahl vwp rules pvt.Check Job Status'

1975: fnd_log.string
1976: (
1977: fnd_log.level_procedure,
1978: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
1979: 'Before calling ahl vwp rules pvt.Check Job Status'
1980: );
1981:
1982: END IF;
1983:

Line 1986: ahl_vwp_rules_pvt.Check_Job_Status

1982: END IF;
1983:
1984:
1985: --Check job status
1986: ahl_vwp_rules_pvt.Check_Job_Status
1987: (p_id => l_cost_price_rec.visit_task_id,
1988: p_is_task_flag => 'Y',
1989: x_status_code => l_job_status_code,
1990: x_status_meaning => l_job_status_mean);

Line 1998: 'After calling ahl vwp rules pvt.Check Job Status, Return Status : '|| l_return_status

1994: fnd_log.string
1995: (
1996: fnd_log.level_procedure,
1997: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
1998: 'After calling ahl vwp rules pvt.Check Job Status, Return Status : '|| l_return_status
1999: );
2000: END IF;
2001:
2002: -- error hanling

Line 2318: 'After calling ahl vwp rules pvt.Get Job Actual Price, Return Status : '|| l_return_status

2314: fnd_log.string
2315: (
2316: fnd_log.level_procedure,
2317: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||': End API',
2318: 'After calling ahl vwp rules pvt.Get Job Actual Price, Return Status : '|| l_return_status
2319: );
2320: END IF;
2321:
2322: -- Check return status.

Line 2887: l_item_tbl AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;

2883:
2884: l_job_status_code VARCHAR2(30);
2885: l_job_status_mean VARCHAR2(80);
2886:
2887: l_item_tbl AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
2888: l_x_item_tbl AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
2889:
2890: l_cost_price_tbl AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type;
2891:

Line 2888: l_x_item_tbl AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;

2884: l_job_status_code VARCHAR2(30);
2885: l_job_status_mean VARCHAR2(80);
2886:
2887: l_item_tbl AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
2888: l_x_item_tbl AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
2889:
2890: l_cost_price_tbl AHL_VWP_VISIT_CST_PR_PVT.cost_price_tbl_type;
2891:
2892: l_api_name VARCHAR2(30) := 'GET_TASK_ITEMS_NO_PRICE';

Line 3223: AHL_VWP_RULES_PVT.check_currency_for_costing

3219: -- Populate currency code if not passed
3220: IF(l_cost_price_rec.currency IS NULL OR
3221: l_cost_price_rec.currency = FND_API.G_MISS_CHAR) THEN
3222:
3223: AHL_VWP_RULES_PVT.check_currency_for_costing
3224: (p_visit_id =>l_task_rec.visit_id,
3225: x_currency_code =>l_cost_price_rec.currency
3226: );
3227:

Line 3255: ahl_vwp_rules_pvt.Check_Job_Status

3251: END IF;
3252:
3253:
3254:
3255: ahl_vwp_rules_pvt.Check_Job_Status
3256: (
3257: p_id => l_cost_price_rec.visit_task_id,
3258: p_is_task_flag => 'Y',
3259: x_status_code => l_job_status_code,

Line 3515: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.ITEM_TBL_TYPE

3511: x_msg_count OUT NOCOPY NUMBER,
3512: x_msg_data OUT NOCOPY VARCHAR2,
3513: p_visit_task_id IN NUMBER,
3514: p_job_status_code IN VARCHAR2,
3515: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.ITEM_TBL_TYPE
3516: )
3517: AS
3518: l_api_name VARCHAR2(30):='GET_UNASSOCIATED_ITEMS';
3519: l_api_version NUMBER:= 1.0;

Line 3525: l_item_tbl1 AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;

3521: l_return_status VARCHAR2(1);
3522: l_msg_count NUMBER;
3523:
3524:
3525: l_item_tbl1 AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3526: l_item_tbl2 AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3527: l_item_tbl AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3528:
3529: BEGIN

Line 3526: l_item_tbl2 AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;

3522: l_msg_count NUMBER;
3523:
3524:
3525: l_item_tbl1 AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3526: l_item_tbl2 AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3527: l_item_tbl AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3528:
3529: BEGIN
3530:

Line 3527: l_item_tbl AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;

3523:
3524:
3525: l_item_tbl1 AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3526: l_item_tbl2 AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3527: l_item_tbl AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3528:
3529: BEGIN
3530:
3531: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

Line 3591: ahl_vwp_rules_pvt.merge_for_unique_items

3587: RAISE FND_API.G_EXC_ERROR;
3588: END IF;
3589: END IF;
3590:
3591: ahl_vwp_rules_pvt.merge_for_unique_items
3592: (
3593: p_item_tbl1 =>l_item_tbl1,
3594: p_item_tbl2 =>l_item_tbl2,
3595: x_item_tbl =>l_item_tbl

Line 3668: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.ITEM_TBL_TYPE

3664: x_msg_data OUT NOCOPY VARCHAR2,
3665: p_visit_task_id IN NUMBER,
3666: p_job_status_code IN VARCHAR2,
3667: p_task_start_time IN DATE,
3668: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.ITEM_TBL_TYPE
3669: )
3670: AS
3671:
3672: Cursor c_task_csr (c_visit_task_id in number)

Line 3689: l_item_tbl_res AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;

3685: where mr_route_id=c_mr_route_id;
3686:
3687: l_mr_route_rec c_mr_route_csr%rowtype;
3688:
3689: l_item_tbl_res AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3690: l_item_tbl_mat AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3691: l_item_tbl1 AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3692: l_item_tbl2 AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3693: l_item_tbl AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;

Line 3690: l_item_tbl_mat AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;

3686:
3687: l_mr_route_rec c_mr_route_csr%rowtype;
3688:
3689: l_item_tbl_res AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3690: l_item_tbl_mat AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3691: l_item_tbl1 AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3692: l_item_tbl2 AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3693: l_item_tbl AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3694:

Line 3691: l_item_tbl1 AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;

3687: l_mr_route_rec c_mr_route_csr%rowtype;
3688:
3689: l_item_tbl_res AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3690: l_item_tbl_mat AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3691: l_item_tbl1 AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3692: l_item_tbl2 AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3693: l_item_tbl AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3694:
3695: l_api_name VARCHAR2(30):='GET_OTHER_TASK_ITEMS';

Line 3692: l_item_tbl2 AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;

3688:
3689: l_item_tbl_res AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3690: l_item_tbl_mat AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3691: l_item_tbl1 AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3692: l_item_tbl2 AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3693: l_item_tbl AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3694:
3695: l_api_name VARCHAR2(30):='GET_OTHER_TASK_ITEMS';
3696: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;

Line 3693: l_item_tbl AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;

3689: l_item_tbl_res AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3690: l_item_tbl_mat AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3691: l_item_tbl1 AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3692: l_item_tbl2 AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3693: l_item_tbl AHL_VWP_RULES_PVT.ITEM_TBL_TYPE;
3694:
3695: l_api_name VARCHAR2(30):='GET_OTHER_TASK_ITEMS';
3696: L_FULL_NAME CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || L_API_NAME;
3697: l_api_version NUMBER:= 1.0;

Line 3786: ahl_vwp_rules_pvt.merge_for_unique_items

3782: );
3783:
3784: END IF;
3785:
3786: ahl_vwp_rules_pvt.merge_for_unique_items
3787: (
3788: p_item_tbl1 =>l_item_tbl_res,
3789: p_item_tbl2 =>l_item_tbl_mat,
3790: x_item_tbl =>l_item_tbl

Line 3830: ahl_vwp_rules_pvt.merge_for_unique_items

3826: );
3827:
3828: END IF;
3829:
3830: ahl_vwp_rules_pvt.merge_for_unique_items
3831: (
3832: p_item_tbl1 =>l_item_tbl_res,
3833: p_item_tbl2 =>l_item_tbl_mat,
3834: x_item_tbl =>l_item_tbl2

Line 3881: ahl_vwp_rules_pvt.merge_for_unique_items

3877: );
3878:
3879: END IF;
3880:
3881: ahl_vwp_rules_pvt.merge_for_unique_items
3882: (
3883: p_item_tbl1 =>l_item_tbl_res,
3884: p_item_tbl2 =>l_item_tbl_mat,
3885: x_item_tbl =>l_item_tbl1

Line 3899: ahl_vwp_rules_pvt.merge_for_unique_items

3895:
3896: END IF;
3897:
3898:
3899: ahl_vwp_rules_pvt.merge_for_unique_items
3900: (
3901: p_item_tbl1 =>l_item_tbl2,
3902: p_item_tbl2 =>l_item_tbl1,
3903: x_item_tbl =>l_item_tbl