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_COMPOSITIONS

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

361:
362: -- Start of Comments --
363: -- Procedure name : Create_Item_Composition
364: -- Type : Private
365: -- Function : Creates Item Composition for Trackable Items in ahl_item_compositions.
366: -- Also creates item-group and Non-Trackable Item association in ahl_comp_details table.
367: -- Pre-reqs :
368: -- Parameters :
369: -- Standard IN Parameters :

Line 413: FROM AHL_ITEM_COMPOSITIONS

409: CURSOR item_composition_dup(p_inventory_item_id IN NUMBER ,
410: p_master_org_id IN NUMBER)
411: IS
412: SELECT 'x'
413: FROM AHL_ITEM_COMPOSITIONS
414: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
415: AND INVENTORY_MASTER_ORG_ID = p_master_org_id;
416: --AND TRUNC(NVL(EFFECTIVE_END_DATE,sysdate)) >= TRUNC(sysdate);
417:

Line 464: Select AHL_ITEM_COMPOSITIONS_S.NEXTVAL

460:
461: CLOSE item_composition_dup;
462:
463:
464: Select AHL_ITEM_COMPOSITIONS_S.NEXTVAL
465: INTO l_item_composition_id
466: FROM DUAL;
467:
468: l_user_id := to_number(fnd_global.USER_ID);

Line 470: INSERT INTO AHL_ITEM_COMPOSITIONS(

466: FROM DUAL;
467:
468: l_user_id := to_number(fnd_global.USER_ID);
469:
470: INSERT INTO AHL_ITEM_COMPOSITIONS(
471: ITEM_COMPOSITION_ID ,
472: INVENTORY_ITEM_ID ,
473: INVENTORY_MASTER_ORG_ID,
474: DRAFT_FLAG ,

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

627:
628: -- Start of Comments --
629: -- Procedure name : Modify_Item_Composition
630: -- Type : Private
631: -- Function : Modifies Item Composition for Trackable Items in ahl_item_compositions.
632: -- Also creates,modifies item-group and Non-Trackable Item association in ahl_comp_details table.
633: -- Pre-reqs :
634: -- Parameters :
635: -- Standard IN Parameters :

Line 710: FROM AHL_ITEM_COMPOSITIONS

706: attribute12 ,
707: attribute13 ,
708: attribute14 ,
709: attribute15
710: FROM AHL_ITEM_COMPOSITIONS
711: WHERE ITEM_COMPOSITION_ID = p_item_composition_id;
712:
713: l_dummy varchar2(1);
714:

Line 776: UPDATE AHL_ITEM_COMPOSITIONS

772: END IF;
773:
774:
775:
776: UPDATE AHL_ITEM_COMPOSITIONS
777: SET
778: APPROVAL_STATUS_CODE = l_item_composition_rec.approval_status_code ,
779: LAST_UPDATE_DATE = sysdate,
780: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),

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

908:
909: -- Start of Comments --
910: -- Procedure name : Delete_Item_Composition
911: -- Type : Private
912: -- Function : Deletes Item Composition for Trackable Items in ahl_item_compositions.
913: -- Also deletes association in ahl_comp_details table.
914: -- Incase of Complete status Item Composition it Expires it.
915: -- Pre-reqs :
916: -- Parameters :

Line 979: FROM AHL_ITEM_COMPOSITIONS

975: attribute12 ,
976: attribute13 ,
977: attribute14 ,
978: attribute15
979: FROM AHL_ITEM_COMPOSITIONS
980: WHERE ITEM_COMPOSITION_ID = p_item_composition_id;
981:
982: CURSOR disposition_exist(p_item_composition_id IN NUMBER)
983: IS

Line 998: FROM AHL_ITEM_COMPOSITIONS

994:
995: CURSOR item_rev_exists(p_item_composition_id IN NUMBER)
996: IS
997: SELECT item_composition_id
998: FROM AHL_ITEM_COMPOSITIONS
999: WHERE link_comp_id = p_item_composition_id;
1000:
1001:
1002: l_dummy varchar2(1);

Line 1094: UPDATE AHL_ITEM_COMPOSITIONS

1090: END IF;
1091:
1092:
1093:
1094: UPDATE AHL_ITEM_COMPOSITIONS
1095: SET
1096: LAST_UPDATE_DATE = sysdate,
1097: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
1098: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID) ,

Line 1112: DELETE FROM AHL_ITEM_COMPOSITIONS

1108:
1109: DELETE FROM AHL_ITEM_COMP_DETAILS
1110: WHERE ITEM_COMPOSITION_ID = p_item_composition_id;
1111:
1112: DELETE FROM AHL_ITEM_COMPOSITIONS
1113: WHERE ITEM_COMPOSITION_ID = p_item_composition_id;
1114:
1115: END IF;
1116:

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

1177:
1178: -- Start of Comments --
1179: -- Procedure name : Reopen_Item_Composition
1180: -- Type : Private
1181: -- Function : Re-Open'ss Item Composition for Trackable Items in ahl_item_compositions.
1182: --
1183: -- Pre-reqs :
1184: -- Parameters :
1185: -- Standard IN Parameters :

Line 1248: FROM AHL_ITEM_COMPOSITIONS

1244: attribute12 ,
1245: attribute13 ,
1246: attribute14 ,
1247: attribute15
1248: FROM AHL_ITEM_COMPOSITIONS
1249: WHERE ITEM_COMPOSITION_ID = p_item_composition_id;
1250:
1251: /*
1252: CURSOR item_composition_exists(p_inv_item_id IN NUMBER,

Line 1256: FROM AHL_ITEM_COMPOSITIONS

1252: CURSOR item_composition_exists(p_inv_item_id IN NUMBER,
1253: p_inv_master_org_id IN NUMBER)
1254: IS
1255: SELECT 'x'
1256: FROM AHL_ITEM_COMPOSITIONS
1257: WHERE inventory_item_id = p_inv_item_id
1258: AND inventory_master_org_id = p_inv_master_org_id
1259: AND TRUNC(NVL(EFFECTIVE_END_DATE,sysdate)) >= TRUNC(sysdate);
1260: */

Line 1335: UPDATE AHL_ITEM_COMPOSITIONS

1331: END IF;
1332:
1333:
1334:
1335: UPDATE AHL_ITEM_COMPOSITIONS
1336: SET
1337: LAST_UPDATE_DATE = sysdate,
1338: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
1339: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID) ,

Line 1754: Update ahl_item_compositions

1750: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1751: 'ahl.plsql.'||G_PKG_NAME||'.Initiate_Item_Comp_Approval', 'Updating Item group');
1752: END IF;
1753:
1754: Update ahl_item_compositions
1755: Set APPROVAL_STATUS_CODE=l_upd_status,
1756: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1
1757: Where ITEM_COMPOSITION_ID = p_Item_Composition_id
1758: and OBJECT_VERSION_NUMBER=p_object_Version_number;

Line 1939: from ahl_item_compositions

1935: inventory_item_id,
1936: inventory_master_org_id,
1937: effective_end_date,
1938: object_version_number
1939: from ahl_item_compositions
1940: Where item_composition_id = c_item_comp_id;
1941:
1942: l_item_comp_det get_item_comp_det%rowtype;
1943:

Line 1948: from ahl_item_compositions

1944:
1945: cursor get_revision_info(c_item_comp_id in Number)
1946: is
1947: Select 'x'
1948: from ahl_item_compositions
1949: where link_comp_id = c_item_comp_id;
1950:
1951: l_dummy VARCHAR2(1);
1952: l_msg_count Number;

Line 2035: Select AHL_ITEM_COMPOSITIONS_S.NEXTVAL

2031: l_last_update_login := to_number(fnd_global.LOGIN_ID);
2032: l_created_by := to_number(fnd_global.user_id);
2033:
2034:
2035: Select AHL_ITEM_COMPOSITIONS_S.NEXTVAL
2036: INTO l_item_composition_id
2037: FROM DUAL;
2038:
2039:

Line 2040: INSERT INTO AHL_ITEM_COMPOSITIONS(

2036: INTO l_item_composition_id
2037: FROM DUAL;
2038:
2039:
2040: INSERT INTO AHL_ITEM_COMPOSITIONS(
2041: ITEM_COMPOSITION_ID ,
2042: INVENTORY_ITEM_ID ,
2043: INVENTORY_MASTER_ORG_ID,
2044: DRAFT_FLAG ,

Line 2102: FROM ahl_item_compositions

2098: attribute12 ,
2099: attribute13 ,
2100: attribute14 ,
2101: attribute15
2102: FROM ahl_item_compositions
2103: WHERE item_composition_id = p_Item_comp_id
2104: AND object_version_number = p_object_version_number
2105: AND effective_end_date is null;
2106:

Line 2188: UPDATE ahl_item_compositions

2184: AND effective_end_date is null;
2185:
2186: END IF;
2187:
2188: UPDATE ahl_item_compositions
2189: SET DRAFT_FLAG = 'Y',
2190: LAST_UPDATE_DATE = sysdate,
2191: LAST_UPDATED_BY = to_number(fnd_global.USER_ID),
2192: LAST_UPDATE_LOGIN =to_number(fnd_global.LOGIN_ID),

Line 2342: from ahl_item_compositions

2338: attribute14,
2339: attribute15
2340: -- manisaga added the following code for DFF implemenataion on 19-Feb-2010 -- End
2341:
2342: from ahl_item_compositions
2343: Where item_composition_id = c_item_comp_id;
2344:
2345: l_item_comp_det get_item_comp_det%rowType;
2346:

Line 2459: update ahl_item_compositions

2455: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'link_comp_id is null');
2456: END IF;
2457:
2458:
2459: update ahl_item_compositions
2460: set approval_status_code=l_status,
2461: object_version_number = object_version_number+1
2462: where item_composition_id=l_item_comp_det.item_composition_id
2463: and object_version_number = l_item_comp_det.object_version_number;

Line 2598: Update ahl_item_compositions

2594: Where item_composition_id=l_item_comp_det.item_composition_id
2595: and link_comp_detl_id is null;
2596:
2597:
2598: Update ahl_item_compositions
2599: Set last_update_date =sysdate,
2600: last_updated_by = to_number(fnd_global.user_id),
2601: last_update_login = to_number(fnd_global.login_id),
2602: object_version_number =object_version_number+1 ,

Line 2627: Delete from ahl_item_compositions

2623:
2624: Delete from ahl_item_comp_details
2625: where item_composition_id = l_item_comp_det.item_composition_id;
2626:
2627: Delete from ahl_item_compositions
2628: Where item_composition_id=l_item_comp_det.item_composition_id;
2629:
2630:
2631: End if;

Line 2645: update ahl_item_compositions

2641: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
2642: 'ahl.plsql.ahl_mc_itemgroup_pvt.Approve_Item_Composiiton', 'Approval Rejected');
2643: END IF;
2644:
2645: update ahl_item_compositions
2646: set approval_status_code=l_status,
2647: object_version_number = object_version_number+1
2648: where item_composition_id=l_item_comp_det.item_composition_id
2649: and object_version_number = l_item_comp_det.object_version_number;