APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on FND_PROFILE

Line 912: AHL_DEBUG_PUB.debug('Application Usage Profile:' || fnd_profile.value('AHL_APPLN_USAGE'));

908:
909: -- Add debug mesg.
910: IF G_DEBUG = 'Y' THEN
911: AHL_DEBUG_PUB.debug('Begin private API:' || G_PKG_NAME || '.' || 'Process_MRAffected_Units');
912: AHL_DEBUG_PUB.debug('Application Usage Profile:' || fnd_profile.value('AHL_APPLN_USAGE'));
913: END IF;
914:
915: IF (p_concurrent_flag = 'Y') THEN
916: l_commit := FND_API.G_TRUE;

Line 1644: l_date_uom := FND_PROFILE.VALUE('AHL_UMP_MAX_PLANNING_UOM');

1640:
1641: BEGIN
1642:
1643: BEGIN
1644: l_date_uom := FND_PROFILE.VALUE('AHL_UMP_MAX_PLANNING_UOM');
1645: l_value := to_number(FND_PROFILE.VALUE('AHL_UMP_MAX_PLANNING_VALUE'));
1646:
1647: IF (l_date_uom IS NULL) THEN
1648: l_last_day_of_window := SYSDATE;

Line 1645: l_value := to_number(FND_PROFILE.VALUE('AHL_UMP_MAX_PLANNING_VALUE'));

1641: BEGIN
1642:
1643: BEGIN
1644: l_date_uom := FND_PROFILE.VALUE('AHL_UMP_MAX_PLANNING_UOM');
1645: l_value := to_number(FND_PROFILE.VALUE('AHL_UMP_MAX_PLANNING_VALUE'));
1646:
1647: IF (l_date_uom IS NULL) THEN
1648: l_last_day_of_window := SYSDATE;
1649: ELSIF (l_value <= 0 OR l_value IS NULL) THEN

Line 8032: l_appl_usg_code := FND_PROFILE.VALUE('AHL_APPLN_USAGE');

8028: AHL_DEBUG_PUB.debug('Start of assign_unit_effectivity_ids procedure');
8029: END IF;
8030:
8031: -- Application usage code.
8032: l_appl_usg_code := FND_PROFILE.VALUE('AHL_APPLN_USAGE');
8033:
8034: -- For each mr_header_id assign the unit effectivity IDs.
8035: -- note: All mr's are for one item instance only.
8036:

Line 11153: where cs.category_set_id = fnd_profile.value('AHL_BUE_ITEM_CATEGORY_SET')

11149: AND parent_uc_header_id IS NULL
11150: AND exists (select 'x'
11151: from mtl_category_set_valid_cats cs, mtl_item_categories itc,
11152: csi_item_instances cii2
11153: where cs.category_set_id = fnd_profile.value('AHL_BUE_ITEM_CATEGORY_SET')
11154: AND cs.category_set_id = itc.category_set_id
11155: AND cs.category_id = itc.category_id
11156: AND itc.category_id = p_mtl_category_id
11157: AND cii2.instance_id = uc.csi_item_instance_id

Line 11281: where cs.category_set_id = fnd_profile.value('AHL_BUE_ITEM_CATEGORY_SET')

11277: ) valid_inst
11278: WHERE exists (select 'x'
11279: from mtl_category_set_valid_cats cs, mtl_item_categories itc,
11280: csi_item_instances cii2
11281: where cs.category_set_id = fnd_profile.value('AHL_BUE_ITEM_CATEGORY_SET')
11282: AND cs.category_set_id = itc.category_set_id
11283: AND cs.category_id = itc.category_id
11284: AND itc.category_id = p_mtl_category_id
11285: AND cii2.instance_id = valid_inst.instance_id

Line 11895: where cs.category_set_id = fnd_profile.value('AHL_BUE_ITEM_CATEGORY_SET')

11891: ) valid_inst
11892: WHERE exists (select 'x'
11893: from mtl_category_set_valid_cats cs, mtl_item_categories itc,
11894: csi_item_instances cii2
11895: where cs.category_set_id = fnd_profile.value('AHL_BUE_ITEM_CATEGORY_SET')
11896: AND cs.category_set_id = itc.category_set_id
11897: AND cs.category_id = itc.category_id
11898: AND itc.category_id = p_mtl_category_id
11899: AND cii2.instance_id = valid_inst.instance_id