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_PRICE_PVT dependencies on AHL_VWP_RULES_PVT

Line 29: (p_item_tbl IN AHL_VWP_RULES_PVT.Item_Tbl_Type,

25: -- 02-Sep-2003 yazhou Created.
26: --------------------------------------------------------------------
27:
28: PROCEDURE Calculate_Total_Price
29: (p_item_tbl IN AHL_VWP_RULES_PVT.Item_Tbl_Type,
30: p_price_list_id IN NUMBER,
31: p_customer_id IN NUMBER,
32: p_currency_code IN VARCHAR2,
33:

Line 64: l_res_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;

60: -- Define local variables
61: l_x_return_status VARCHAR2(240);
62: l_total_price NUMBER := 0; -- total price
63:
64: l_res_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
65: l_mat_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
66: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
67:
68: i NUMBER := 0; -- table index

Line 65: l_mat_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;

61: l_x_return_status VARCHAR2(240);
62: l_total_price NUMBER := 0; -- total price
63:
64: l_res_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
65: l_mat_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
66: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
67:
68: i NUMBER := 0; -- table index
69: l_api_name CONSTANT VARCHAR2(30) := 'Get_Task_Estimated_Price';

Line 66: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;

62: l_total_price NUMBER := 0; -- total price
63:
64: l_res_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
65: l_mat_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
66: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
67:
68: i NUMBER := 0; -- table index
69: l_api_name CONSTANT VARCHAR2(30) := 'Get_Task_Estimated_Price';
70:

Line 139: AHL_VWP_RULES_PVT.Merge_for_Unique_Items

135: -- Merge the two Item table to get the item table
136: -- that the same task, item and UOM combination appear only once
137:
138:
139: AHL_VWP_RULES_PVT.Merge_for_Unique_Items
140: (p_item_tbl1 =>l_res_item_tbl ,
141: p_item_tbl2 =>l_mat_item_tbl ,
142:
143: x_item_tbl =>l_x_item_tbl

Line 206: l_res_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;

202: -- Define local variables
203: l_x_return_status VARCHAR2(240);
204: l_total_price NUMBER := 0; -- total price
205:
206: l_res_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
207: l_mat_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
208: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
209:
210: i NUMBER := 0; -- table index

Line 207: l_mat_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;

203: l_x_return_status VARCHAR2(240);
204: l_total_price NUMBER := 0; -- total price
205:
206: l_res_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
207: l_mat_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
208: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
209:
210: i NUMBER := 0; -- table index
211: l_api_name CONSTANT VARCHAR2(30) := 'Get_Job_Estimated_Price';

Line 208: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;

204: l_total_price NUMBER := 0; -- total price
205:
206: l_res_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
207: l_mat_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
208: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
209:
210: i NUMBER := 0; -- table index
211: l_api_name CONSTANT VARCHAR2(30) := 'Get_Job_Estimated_Price';
212:

Line 267: AHL_VWP_RULES_PVT.Merge_for_Unique_Items

263:
264: -- Merge the two Item table to get the item table
265: -- that the same task, item and UOM combination appear only once
266:
267: AHL_VWP_RULES_PVT.Merge_for_Unique_Items
268: (p_item_tbl1 =>l_res_item_tbl ,
269: p_item_tbl2 =>l_mat_item_tbl ,
270:
271: x_item_tbl =>l_x_item_tbl

Line 331: l_res_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;

327: -- Define local variables
328: l_x_return_status VARCHAR2(240);
329: l_total_price NUMBER := 0; -- total price
330:
331: l_res_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
332: l_mat_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
333: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
334:
335: i NUMBER := 0; -- table index

Line 332: l_mat_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;

328: l_x_return_status VARCHAR2(240);
329: l_total_price NUMBER := 0; -- total price
330:
331: l_res_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
332: l_mat_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
333: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
334:
335: i NUMBER := 0; -- table index
336: l_api_name CONSTANT VARCHAR2(30) := 'Get_Task_Actual_Price';

Line 333: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;

329: l_total_price NUMBER := 0; -- total price
330:
331: l_res_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
332: l_mat_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
333: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
334:
335: i NUMBER := 0; -- table index
336: l_api_name CONSTANT VARCHAR2(30) := 'Get_Task_Actual_Price';
337:

Line 392: AHL_VWP_RULES_PVT.Merge_for_Unique_Items

388:
389: -- Merge the two Item table to get the item table
390: -- that the same task, item and UOM combination appear only once
391:
392: AHL_VWP_RULES_PVT.Merge_for_Unique_Items
393: (p_item_tbl1 =>l_res_item_tbl ,
394: p_item_tbl2 =>l_mat_item_tbl ,
395:
396: x_item_tbl =>l_x_item_tbl

Line 697: (p_item_tbl IN AHL_VWP_RULES_PVT.Item_Tbl_Type,

693: -- Procedure name : Get_Items_without_Price
694: -- Purpose : To return items which are not set up in price list.
695: --------------------------------------------------------------------
696: PROCEDURE Get_Items_without_Price
697: (p_item_tbl IN AHL_VWP_RULES_PVT.Item_Tbl_Type,
698: p_price_list_id IN NUMBER,
699: p_customer_id IN NUMBER,
700: p_currency_code IN VARCHAR2,
701:

Line 702: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.Item_Tbl_Type,

698: p_price_list_id IN NUMBER,
699: p_customer_id IN NUMBER,
700: p_currency_code IN VARCHAR2,
701:
702: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.Item_Tbl_Type,
703: x_return_status OUT NOCOPY VARCHAR2
704: )
705: IS
706:

Line 709: l_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;

705: IS
706:
707: -- Define local variables
708: l_x_return_status VARCHAR2(240);
709: l_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
710: l_x_item_price NUMBER := 0;
711:
712: i NUMBER :=0; -- loop index
713: j NUMBER :=0; -- loop index

Line 795: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.Item_Tbl_Type,

791: --------------------------------------------------------------------
792: PROCEDURE Check_Item_for_Prod_Mat_Req
793: (p_visit_task_id IN NUMBER,
794:
795: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.Item_Tbl_Type,
796: x_return_status OUT NOCOPY VARCHAR2
797: )
798: IS
799: -- Define local Cursors

Line 849: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;

845:
846:
847: -- Define local variables
848: l_x_return_status VARCHAR2(240);
849: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
850:
851: i NUMBER :=0; -- loop index
852:
853: l_api_name CONSTANT VARCHAR2(30) := 'Check_Item_for_Prod_Mat_Req';

Line 914: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.Item_Tbl_Type,

910: --------------------------------------------------------------------
911: PROCEDURE Check_Item_for_Prod_Res_Req
912: (p_visit_task_id IN NUMBER,
913:
914: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.Item_Tbl_Type,
915: x_return_status OUT NOCOPY VARCHAR2
916: )
917: IS
918: -- Define local Cursors

Line 955: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;

951:
952:
953: -- Define local variables
954: l_x_return_status VARCHAR2(240);
955: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
956:
957: l_x_time_type_flag VARCHAR2(1);
958: i NUMBER :=0; -- loop index
959:

Line 1040: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.Item_Tbl_Type,

1036: (p_visit_task_id IN NUMBER,
1037: p_route_id IN NUMBER,
1038: p_effective_date IN DATE,
1039:
1040: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.Item_Tbl_Type,
1041: x_return_status OUT NOCOPY VARCHAR2
1042: )
1043: IS
1044: -- Define local Cursors

Line 1108: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;

1104: l_oper_material_req_rec get_oper_materials_csr%ROWTYPE;
1105:
1106: -- Define local variables
1107: l_x_return_status VARCHAR2(240);
1108: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
1109:
1110: l_route_mat_found BOOLEAN := FALSE;
1111:
1112: i NUMBER :=0; -- loop index

Line 1236: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.Item_Tbl_Type,

1232: p_route_id IN NUMBER,
1233: p_organization_id IN NUMBER,
1234: p_effective_date IN DATE,
1235:
1236: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.Item_Tbl_Type,
1237: x_return_status OUT NOCOPY VARCHAR2
1238: )
1239: IS
1240: -- Define local Cursors

Line 1355: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;

1351: l_oper_resource_req_rec get_oper_resources_csr%ROWTYPE;
1352:
1353: -- Define local variables
1354: l_x_return_status VARCHAR2(240);
1355: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
1356: l_x_time_type_flag VARCHAR2(1);
1357:
1358: l_rt_resource_id NUMBER;
1359:

Line 1510: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.Item_Tbl_Type,

1506: --------------------------------------------------------------------
1507: PROCEDURE Check_Item_for_Resource_Trans
1508: (p_visit_task_id IN NUMBER,
1509:
1510: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.Item_Tbl_Type,
1511: x_return_status OUT NOCOPY VARCHAR2
1512: )
1513: IS
1514: -- Define local Cursors

Line 1551: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;

1547:
1548:
1549: -- Define local variables
1550: l_x_return_status VARCHAR2(240);
1551: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
1552:
1553: l_x_time_type_flag VARCHAR2(1);
1554: i NUMBER :=0; -- loop index
1555:

Line 1616: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.Item_Tbl_Type,

1612: --------------------------------------------------------------------
1613: PROCEDURE Check_Item_for_Materials_Trans
1614: (p_visit_task_id IN NUMBER,
1615:
1616: x_item_tbl OUT NOCOPY AHL_VWP_RULES_PVT.Item_Tbl_Type,
1617: x_return_status OUT NOCOPY VARCHAR2
1618: )
1619: IS
1620: -- Define local Cursors

Line 1681: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;

1677:
1678:
1679: -- Define local variables
1680: l_x_return_status VARCHAR2(240);
1681: l_x_item_tbl AHL_VWP_RULES_PVT.Item_Tbl_Type;
1682:
1683: i NUMBER :=0; -- loop index
1684:
1685: l_api_name CONSTANT VARCHAR2(30) := 'Check_Item_for_Prod_Mat_Req';

Line 1744: (p_item_tbl IN AHL_VWP_RULES_PVT.Item_Tbl_Type,

1740: -- Procedure name : Calculate_Total_Price
1741: -- Purpose : To return total price of the item table with quantity.
1742: --------------------------------------------------------------------
1743: PROCEDURE Calculate_Total_Price
1744: (p_item_tbl IN AHL_VWP_RULES_PVT.Item_Tbl_Type,
1745: p_price_list_id IN NUMBER,
1746: p_customer_id IN NUMBER,
1747: p_currency_code IN VARCHAR2,
1748: