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_MC_ITEM_COMP_PVT dependencies on AHL_ITEM_COMPOSITIONS

Line 356: -- Function : Creates Item Composition for Trackable Items in ahl_item_compositions.

352:
353: -- Start of Comments --
354: -- Procedure name : Create_Item_Composition
355: -- Type : Private
356: -- Function : Creates Item Composition for Trackable Items in ahl_item_compositions.
357: -- Also creates item-group and Non-Trackable Item association in ahl_comp_details table.
358: -- Pre-reqs :
359: -- Parameters :
360: -- Standard IN Parameters :

Line 404: FROM AHL_ITEM_COMPOSITIONS

400: CURSOR item_composition_dup(p_inventory_item_id IN NUMBER ,
401: p_master_org_id IN NUMBER)
402: IS
403: SELECT 'x'
404: FROM AHL_ITEM_COMPOSITIONS
405: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
406: AND INVENTORY_MASTER_ORG_ID = p_master_org_id;
407: --AND TRUNC(NVL(EFFECTIVE_END_DATE,sysdate)) >= TRUNC(sysdate);
408:

Line 455: Select AHL_ITEM_COMPOSITIONS_S.NEXTVAL

451:
452: CLOSE item_composition_dup;
453:
454:
455: Select AHL_ITEM_COMPOSITIONS_S.NEXTVAL
456: INTO l_item_composition_id
457: FROM DUAL;
458:
459: l_user_id := to_number(fnd_global.USER_ID);

Line 461: INSERT INTO AHL_ITEM_COMPOSITIONS(

457: FROM DUAL;
458:
459: l_user_id := to_number(fnd_global.USER_ID);
460:
461: INSERT INTO AHL_ITEM_COMPOSITIONS(
462: ITEM_COMPOSITION_ID ,
463: INVENTORY_ITEM_ID ,
464: INVENTORY_MASTER_ORG_ID,
465: DRAFT_FLAG ,

Line 622: -- Function : Modifies Item Composition for Trackable Items in ahl_item_compositions.

618:
619: -- Start of Comments --
620: -- Procedure name : Modify_Item_Composition
621: -- Type : Private
622: -- Function : Modifies Item Composition for Trackable Items in ahl_item_compositions.
623: -- Also creates,modifies item-group and Non-Trackable Item association in ahl_comp_details table.
624: -- Pre-reqs :
625: -- Parameters :
626: -- Standard IN Parameters :

Line 699: FROM AHL_ITEM_COMPOSITIONS

695: attribute12 ,
696: attribute13 ,
697: attribute14 ,
698: attribute15
699: FROM AHL_ITEM_COMPOSITIONS
700: WHERE ITEM_COMPOSITION_ID = p_item_composition_id;
701:
702: l_dummy varchar2(1);
703:

Line 760: UPDATE AHL_ITEM_COMPOSITIONS

756: END IF;
757:
758:
759:
760: UPDATE AHL_ITEM_COMPOSITIONS
761: SET
762: APPROVAL_STATUS_CODE = l_item_composition_rec.approval_status_code ,
763: LAST_UPDATE_DATE = sysdate,
764: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),

Line 896: -- Function : Deletes Item Composition for Trackable Items in ahl_item_compositions.

892:
893: -- Start of Comments --
894: -- Procedure name : Delete_Item_Composition
895: -- Type : Private
896: -- Function : Deletes Item Composition for Trackable Items in ahl_item_compositions.
897: -- Also deletes association in ahl_comp_details table.
898: -- Incase of Complete status Item Composition it Expires it.
899: -- Pre-reqs :
900: -- Parameters :

Line 963: FROM AHL_ITEM_COMPOSITIONS

959: attribute12 ,
960: attribute13 ,
961: attribute14 ,
962: attribute15
963: FROM AHL_ITEM_COMPOSITIONS
964: WHERE ITEM_COMPOSITION_ID = p_item_composition_id;
965:
966: CURSOR disposition_exist(p_item_composition_id IN NUMBER)
967: IS

Line 982: FROM AHL_ITEM_COMPOSITIONS

978:
979: CURSOR item_rev_exists(p_item_composition_id IN NUMBER)
980: IS
981: SELECT item_composition_id
982: FROM AHL_ITEM_COMPOSITIONS
983: WHERE link_comp_id = p_item_composition_id;
984:
985:
986: l_dummy varchar2(1);

Line 1078: UPDATE AHL_ITEM_COMPOSITIONS

1074: END IF;
1075:
1076:
1077:
1078: UPDATE AHL_ITEM_COMPOSITIONS
1079: SET
1080: LAST_UPDATE_DATE = sysdate,
1081: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
1082: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID) ,

Line 1096: DELETE FROM AHL_ITEM_COMPOSITIONS

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;
1098:
1099: END IF;
1100:

Line 1165: -- Function : Re-Open'ss Item Composition for Trackable Items in ahl_item_compositions.

1161:
1162: -- Start of Comments --
1163: -- Procedure name : Reopen_Item_Composition
1164: -- Type : Private
1165: -- Function : Re-Open'ss Item Composition for Trackable Items in ahl_item_compositions.
1166: --
1167: -- Pre-reqs :
1168: -- Parameters :
1169: -- Standard IN Parameters :

Line 1232: FROM AHL_ITEM_COMPOSITIONS

1228: attribute12 ,
1229: attribute13 ,
1230: attribute14 ,
1231: attribute15
1232: FROM AHL_ITEM_COMPOSITIONS
1233: WHERE ITEM_COMPOSITION_ID = p_item_composition_id;
1234:
1235: /*
1236: CURSOR item_composition_exists(p_inv_item_id IN NUMBER,

Line 1240: FROM AHL_ITEM_COMPOSITIONS

1236: CURSOR item_composition_exists(p_inv_item_id IN NUMBER,
1237: p_inv_master_org_id IN NUMBER)
1238: IS
1239: SELECT 'x'
1240: FROM AHL_ITEM_COMPOSITIONS
1241: WHERE inventory_item_id = p_inv_item_id
1242: AND inventory_master_org_id = p_inv_master_org_id
1243: AND TRUNC(NVL(EFFECTIVE_END_DATE,sysdate)) >= TRUNC(sysdate);
1244: */

Line 1319: UPDATE AHL_ITEM_COMPOSITIONS

1315: END IF;
1316:
1317:
1318:
1319: UPDATE AHL_ITEM_COMPOSITIONS
1320: SET
1321: LAST_UPDATE_DATE = sysdate,
1322: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
1323: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID) ,

Line 1738: Update ahl_item_compositions

1734: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1735: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Updating Item group');
1736: END IF;
1737:
1738: Update ahl_item_compositions
1739: Set APPROVAL_STATUS_CODE=l_upd_status,
1740: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
1741: Where ITEM_COMPOSITION_ID = p_Item_Composition_id
1742: and OBJECT_VERSION_NUMBER=p_object_Version_number;

Line 1923: from ahl_item_compositions

1919: inventory_item_id,
1920: inventory_master_org_id,
1921: effective_end_date,
1922: object_version_number
1923: from ahl_item_compositions
1924: Where item_composition_id = c_item_comp_id;
1925:
1926: l_item_comp_det get_item_comp_det%rowtype;
1927:

Line 1932: from ahl_item_compositions

1928:
1929: cursor get_revision_info(c_item_comp_id in Number)
1930: is
1931: Select 'x'
1932: from ahl_item_compositions
1933: where link_comp_id = c_item_comp_id;
1934:
1935: l_dummy VARCHAR2(1);
1936: l_msg_count Number;

Line 2019: Select AHL_ITEM_COMPOSITIONS_S.NEXTVAL

2015: l_last_update_login := to_number(fnd_global.LOGIN_ID);
2016: l_created_by := to_number(fnd_global.user_id);
2017:
2018:
2019: Select AHL_ITEM_COMPOSITIONS_S.NEXTVAL
2020: INTO l_item_composition_id
2021: FROM DUAL;
2022:
2023:

Line 2024: INSERT INTO AHL_ITEM_COMPOSITIONS(

2020: INTO l_item_composition_id
2021: FROM DUAL;
2022:
2023:
2024: INSERT INTO AHL_ITEM_COMPOSITIONS(
2025: ITEM_COMPOSITION_ID ,
2026: INVENTORY_ITEM_ID ,
2027: INVENTORY_MASTER_ORG_ID,
2028: DRAFT_FLAG ,

Line 2086: FROM ahl_item_compositions

2082: attribute12 ,
2083: attribute13 ,
2084: attribute14 ,
2085: attribute15
2086: FROM ahl_item_compositions
2087: WHERE item_composition_id = p_Item_comp_id
2088: AND object_version_number = p_object_version_number
2089: AND effective_end_date is null;
2090:

Line 2172: UPDATE ahl_item_compositions

2168: AND effective_end_date is null;
2169:
2170: END IF;
2171:
2172: UPDATE ahl_item_compositions
2173: SET DRAFT_FLAG = 'Y',
2174: LAST_UPDATE_DATE = sysdate,
2175: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
2176: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID),

Line 2307: from ahl_item_compositions

2303: inventory_item_id,
2304: inventory_master_org_id,
2305: effective_end_date,
2306: object_version_number
2307: from ahl_item_compositions
2308: Where item_composition_id = c_item_comp_id;
2309:
2310: l_item_comp_det get_item_comp_det%rowType;
2311:

Line 2402: update ahl_item_compositions

2398: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'link_comp_id is null');
2399: END IF;
2400:
2401:
2402: update ahl_item_compositions
2403: set approval_status_code=l_status,
2404: object_version_number = object_version_number+1
2405: where item_composition_id=l_item_comp_det.item_composition_id
2406: and object_version_number = l_item_comp_det.object_version_number;

Line 2484: Update ahl_item_compositions

2480: Where item_composition_id=l_item_comp_det.item_composition_id
2481: and link_comp_detl_id is null;
2482:
2483:
2484: Update ahl_item_compositions
2485: Set last_update_date =sysdate,
2486: last_updated_by = to_number(fnd_global.user_id),
2487: last_update_login = to_number(fnd_global.login_id),
2488: object_version_number =object_version_number+1

Line 2494: Delete from ahl_item_compositions

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;
2496:
2497:
2498: End if;

Line 2512: update ahl_item_compositions

2508: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2509: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Approval Rejected');
2510: END IF;
2511:
2512: update ahl_item_compositions
2513: set approval_status_code=l_status,
2514: object_version_number = object_version_number+1
2515: where item_composition_id=l_item_comp_det.item_composition_id
2516: and object_version_number = l_item_comp_det.object_version_number;