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.

[Home] [Help]

APPS.AHL_MC_ITEM_COMP_PVT dependencies on AHL_ITEM_COMP_DETAILS

Line 214: FROM AHL_ITEM_COMP_DETAILS

210: CURSOR item_group_exists(p_item_group_id IN NUMBER,
211: p_item_composition_id IN NUMBER)
212: IS
213: SELECT 'x'
214: FROM AHL_ITEM_COMP_DETAILS
215: WHERE ITEM_GROUP_ID = p_item_group_id
216: AND ITEM_COMPOSITION_ID= p_item_composition_id
217: AND EFFECTIVE_END_DATE is null;
218:

Line 224: FROM AHL_ITEM_COMP_DETAILS

220: p_inventory_master_org_id IN NUMBER,
221: p_item_composition_id IN NUMBER)
222: IS
223: SELECT 'x'
224: FROM AHL_ITEM_COMP_DETAILS
225: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
226: AND INVENTORY_MASTER_ORG_ID = p_inventory_master_org_id
227: AND ITEM_COMPOSITION_ID= p_item_composition_id
228: AND EFFECTIVE_END_DATE is null;

Line 235: FROM AHL_ITEM_COMP_DETAILS

231: CURSOR get_item_comp_det( p_item_composition_id IN NUMBER,
232: p_item_comp_detail_id IN NUMBER)
233: IS
234: SELECT 'x'
235: FROM AHL_ITEM_COMP_DETAILS
236: WHERE item_comp_detail_id = p_item_comp_detail_id
237: AND item_composition_id= p_item_composition_id;
238:
239:

Line 1093: DELETE FROM AHL_ITEM_COMP_DETAILS

1089:
1090: ELSIF l_item_composition_rec.approval_status_code IN ('DRAFT','APPROVAL_REJECTED') THEN
1091:
1092:
1093: DELETE FROM AHL_ITEM_COMP_DETAILS
1094: WHERE ITEM_COMPOSITION_ID = p_item_composition_id;
1095:
1096: DELETE FROM AHL_ITEM_COMPOSITIONS
1097: WHERE ITEM_COMPOSITION_ID = p_item_composition_id;

Line 1401: SELECT AHL_ITEM_COMP_DETAILS_S.NEXTVAL

1397: l_user_id NUMBER;
1398:
1399: BEGIN
1400:
1401: SELECT AHL_ITEM_COMP_DETAILS_S.NEXTVAL
1402: INTO l_item_comp_detail_id
1403: FROM DUAL;
1404:
1405: l_user_id := to_number(fnd_global.USER_ID);

Line 1409: INSERT INTO AHL_ITEM_COMP_DETAILS(

1405: l_user_id := to_number(fnd_global.USER_ID);
1406:
1407: IF p_item_composition_id IS NOT NULL THEN
1408:
1409: INSERT INTO AHL_ITEM_COMP_DETAILS(
1410: ITEM_COMP_DETAIL_ID ,
1411: ITEM_COMPOSITION_ID ,
1412: ITEM_GROUP_ID ,
1413: INVENTORY_ITEM_ID ,

Line 1500: UPDATE AHL_ITEM_COMP_DETAILS

1496: AS
1497:
1498: BEGIN
1499:
1500: UPDATE AHL_ITEM_COMP_DETAILS
1501: SET
1502: ITEM_GROUP_ID =p_x_comp_det_rec.ITEM_GROUP_ID,
1503: INVENTORY_ITEM_ID =p_x_comp_det_rec.INVENTORY_ITEM_ID,
1504: INVENTORY_MASTER_ORG_ID = p_x_comp_det_rec.INVENTORY_MASTER_ORG_ID,

Line 1545: DELETE FROM AHL_ITEM_COMP_DETAILS

1541: AS
1542:
1543: BEGIN
1544:
1545: DELETE FROM AHL_ITEM_COMP_DETAILS
1546: WHERE ITEM_COMP_DETAIL_ID = p_x_comp_det_rec.item_comp_detail_id
1547: AND ITEM_COMPOSITION_ID = p_item_composition_id;
1548:
1549:

Line 1671: from ahl_item_comp_details

1667: x_msg_data =>l_msg_data);
1668:
1669: Select count(*)
1670: into l_count
1671: from ahl_item_comp_details
1672: where item_composition_id = p_Item_Composition_id;
1673:
1674:
1675: IF p_object_Version_number is null or p_object_Version_number=FND_API.G_MISS_NUM

Line 1694: from ahl_item_comp_details

1690:
1691:
1692: select count(*)
1693: into l_count
1694: from ahl_item_comp_details
1695: where item_composition_id = p_Item_Composition_id;
1696:
1697: IF l_count < 1 THEN
1698: FND_MESSAGE.SET_NAME('AHL','AHL_MC_IC_EMPTY');

Line 2100: INSERT INTO AHL_ITEM_COMP_DETAILS(

2096:
2097:
2098: IF p_Item_comp_id IS NOT NULL THEN
2099:
2100: INSERT INTO AHL_ITEM_COMP_DETAILS(
2101: ITEM_COMP_DETAIL_ID ,
2102: ITEM_COMPOSITION_ID ,
2103: ITEM_GROUP_ID ,
2104: INVENTORY_ITEM_ID ,

Line 2134: SELECT AHL_ITEM_COMP_DETAILS_S.NEXTVAL ,

2130: ATTRIBUTE13 ,
2131: ATTRIBUTE14 ,
2132: ATTRIBUTE15 )
2133:
2134: SELECT AHL_ITEM_COMP_DETAILS_S.NEXTVAL ,
2135: l_item_composition_id ,
2136: item_group_id ,
2137: inventory_item_id ,
2138: inventory_master_org_id,

Line 2166: FROM ahl_item_comp_details

2162: attribute12 ,
2163: attribute13 ,
2164: attribute14 ,
2165: attribute15
2166: FROM ahl_item_comp_details
2167: WHERE item_composition_id = p_Item_comp_id
2168: AND effective_end_date is null;
2169:
2170: END IF;

Line 2437: from ahl_item_comp_details

2433: l_uom_code ,
2434: l_quantity ,
2435: l_link_comp_detl_id ,
2436: l_object_version_number
2437: from ahl_item_comp_details
2438: where item_composition_id = l_item_comp_det.item_composition_id
2439: and link_comp_detl_id is not null
2440: and effective_end_date is null;
2441:

Line 2444: update ahl_item_comp_details set

2440: and effective_end_date is null;
2441:
2442:
2443: FORALL I IN 1..l_object_version_number.count
2444: update ahl_item_comp_details set
2445: uom_code =l_uom_code(I),
2446: quantity =l_quantity(I),
2447: last_update_date = sysdate,
2448: last_updated_by = to_number(fnd_global.user_id),

Line 2459: Update ahl_item_comp_details

2455: and NVL(inventory_master_org_id,-3)= NVL(l_inventory_master_org_id(I),-3)
2456: and effective_end_date is null;
2457:
2458:
2459: Update ahl_item_comp_details
2460: Set effective_end_date = sysdate-1,
2461: last_update_date =sysdate,
2462: last_updated_by = to_number(fnd_global.user_id),
2463: last_update_login = to_number(fnd_global.login_id),

Line 2469: from ahl_item_comp_details

2465: Where item_composition_id=l_item_comp_det.link_comp_id
2466: and effective_end_date is null
2467: and ITEM_COMP_DETAIL_ID not in (
2468: Select link_comp_detl_id
2469: from ahl_item_comp_details
2470: where item_composition_id = l_item_comp_det.item_composition_id
2471: and link_comp_detl_id is not null);
2472:
2473:

Line 2474: Update ahl_item_comp_details

2470: where item_composition_id = l_item_comp_det.item_composition_id
2471: and link_comp_detl_id is not null);
2472:
2473:
2474: Update ahl_item_comp_details
2475: Set item_composition_id = l_item_comp_det.link_comp_id,
2476: last_update_date =sysdate,
2477: last_updated_by = to_number(fnd_global.user_id),
2478: last_update_login = to_number(fnd_global.login_id),

Line 2491: Delete from ahl_item_comp_details

2487: last_update_login = to_number(fnd_global.login_id),
2488: object_version_number =object_version_number+1
2489: Where item_composition_id=l_item_comp_det.link_comp_id;
2490:
2491: Delete from ahl_item_comp_details
2492: where item_composition_id = l_item_comp_det.item_composition_id;
2493:
2494: Delete from ahl_item_compositions
2495: Where item_composition_id=l_item_comp_det.item_composition_id;