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_PRD_MTLTXN_PVT dependencies on FND_FLEX_EXT

Line 155: INV_PROJECT.GET_LOCSEGS(MIL_kfv.concatenated_segments) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)

151: FROM MTL_ITEM_LOCATIONS_KFV MIL_kfv, MTL_ITEM_LOCATIONS MIL
152: WHERE MIL_kfv.INVENTORY_LOCATION_ID = MIL.INVENTORY_LOCATION_ID
153: AND MIL.ORGANIZATION_ID = p_org_Id
154: AND decode(MIL.segment19, null, MIL_kfv.concatenated_segments,
155: INV_PROJECT.GET_LOCSEGS(MIL_kfv.concatenated_segments) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
156: || INV_ProjectLocator_PUB.get_project_number(MIL.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
157: || INV_ProjectLocator_PUB.get_task_number(MIL.segment20)) = p_location_name
158: AND ((MIL.START_DATE_ACTIVE IS NULL) OR (MIL.START_DATE_ACTIVE <= SYSDATE))
159: AND ((MIL.END_DATE_ACTIVE IS NULL) OR (MIL.END_DATE_ACTIVE >= SYSDATE));

Line 156: || INV_ProjectLocator_PUB.get_project_number(MIL.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)

152: WHERE MIL_kfv.INVENTORY_LOCATION_ID = MIL.INVENTORY_LOCATION_ID
153: AND MIL.ORGANIZATION_ID = p_org_Id
154: AND decode(MIL.segment19, null, MIL_kfv.concatenated_segments,
155: INV_PROJECT.GET_LOCSEGS(MIL_kfv.concatenated_segments) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
156: || INV_ProjectLocator_PUB.get_project_number(MIL.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
157: || INV_ProjectLocator_PUB.get_task_number(MIL.segment20)) = p_location_name
158: AND ((MIL.START_DATE_ACTIVE IS NULL) OR (MIL.START_DATE_ACTIVE <= SYSDATE))
159: AND ((MIL.END_DATE_ACTIVE IS NULL) OR (MIL.END_DATE_ACTIVE >= SYSDATE));
160:

Line 4113: l_mti_seglist fnd_flex_ext.SegmentArray;

4109: l_qty NUMBER;
4110: l_reservation_flag VARCHAR2(1);
4111:
4112: -- added to support dynamic locator creation.
4113: l_mti_seglist fnd_flex_ext.SegmentArray;
4114:
4115: l_loop_count NUMBER;
4116:
4117: CURSOR TRX_ACTION_CUR(p_type_Id NUMBER) IS

Line 6020: inv_project.GET_LOCSEGS(WP.DEFAULT_PULL_SUPPLY_LOCATOR_ID, WP.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)

6016: WP.DEFAULT_PULL_SUPPLY_SUBINV,
6017: WP.DEFAULT_PULL_SUPPLY_LOCATOR_ID,
6018: --MTL_LOC.CONCATENATED_SEGMENTS LOCATOR
6019: --Fix for bug number 5903275
6020: inv_project.GET_LOCSEGS(WP.DEFAULT_PULL_SUPPLY_LOCATOR_ID, WP.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
6021: || INV_ProjectLocator_PUB.get_project_number(MTL_LOC.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
6022: || INV_ProjectLocator_PUB.get_task_number(MTL_LOC.segment20) LOCATOR,
6023: --SYSDATE
6024: (select inv_locator_id from ahl_visits_b where visit_id = vst.visit_id) inv_locator_id,

Line 6021: || INV_ProjectLocator_PUB.get_project_number(MTL_LOC.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)

6017: WP.DEFAULT_PULL_SUPPLY_LOCATOR_ID,
6018: --MTL_LOC.CONCATENATED_SEGMENTS LOCATOR
6019: --Fix for bug number 5903275
6020: inv_project.GET_LOCSEGS(WP.DEFAULT_PULL_SUPPLY_LOCATOR_ID, WP.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
6021: || INV_ProjectLocator_PUB.get_project_number(MTL_LOC.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
6022: || INV_ProjectLocator_PUB.get_task_number(MTL_LOC.segment20) LOCATOR,
6023: --SYSDATE
6024: (select inv_locator_id from ahl_visits_b where visit_id = vst.visit_id) inv_locator_id,
6025: (Select csi.instance_number from csi_item_instances csi where csi.instance_id = TXNS.INSTANCE_ID) instance_number

Line 6102: inv_project.GET_LOCSEGS(W.DEFAULT_PULL_SUPPLY_LOCATOR_ID, W.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)

6098: W.DEFAULT_PULL_SUPPLY_SUBINV,
6099: W.DEFAULT_PULL_SUPPLY_LOCATOR_ID,
6100: --D.CONCATENATED_SEGMENTS Locator
6101: -- Fix for bug number 5903275
6102: inv_project.GET_LOCSEGS(W.DEFAULT_PULL_SUPPLY_LOCATOR_ID, W.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
6103: || INV_ProjectLocator_PUB.get_project_number(D.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
6104: || INV_ProjectLocator_PUB.get_task_number(D.segment20) LOCATOR,
6105: --SYSDATE
6106: (select inv_locator_id from ahl_visits_b where visit_id = E.visit_id) inv_locator_id,

Line 6103: || INV_ProjectLocator_PUB.get_project_number(D.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)

6099: W.DEFAULT_PULL_SUPPLY_LOCATOR_ID,
6100: --D.CONCATENATED_SEGMENTS Locator
6101: -- Fix for bug number 5903275
6102: inv_project.GET_LOCSEGS(W.DEFAULT_PULL_SUPPLY_LOCATOR_ID, W.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
6103: || INV_ProjectLocator_PUB.get_project_number(D.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
6104: || INV_ProjectLocator_PUB.get_task_number(D.segment20) LOCATOR,
6105: --SYSDATE
6106: (select inv_locator_id from ahl_visits_b where visit_id = E.visit_id) inv_locator_id,
6107: (Select csi.instance_number from csi_item_instances csi where csi.instance_id = A.INSTANCE_ID) instance_number

Line 7535: p_x_mti_seglist IN OUT NOCOPY fnd_flex_ext.SegmentArray,

7531: -- Added for FP ER 6447935 - dynamic locator support.
7532: -- breakup input locator concatenated segments to populate MTI.
7533: PROCEDURE Get_MTL_LocatorSegs (p_concat_segs IN VARCHAR2,
7534: p_organization_id IN NUMBER,
7535: p_x_mti_seglist IN OUT NOCOPY fnd_flex_ext.SegmentArray,
7536: x_return_status OUT NOCOPY VARCHAR2)
7537:
7538: IS
7539:

Line 7548: l_loc_seglist fnd_flex_ext.SegmentArray;

7544: l_segment_type fnd_flex_key_api.segment_type;
7545: l_delim VARCHAR2(1);
7546:
7547: l_loc_nseg number;
7548: l_loc_seglist fnd_flex_ext.SegmentArray;
7549: l_mti_seglist fnd_flex_ext.SegmentArray;
7550: l_concat_seg_IDs VARCHAR2(4000);
7551:
7552: l_valid_flag BOOLEAN;

Line 7549: l_mti_seglist fnd_flex_ext.SegmentArray;

7545: l_delim VARCHAR2(1);
7546:
7547: l_loc_nseg number;
7548: l_loc_seglist fnd_flex_ext.SegmentArray;
7549: l_mti_seglist fnd_flex_ext.SegmentArray;
7550: l_concat_seg_IDs VARCHAR2(4000);
7551:
7552: l_valid_flag BOOLEAN;
7553:

Line 7609: l_loc_nseg := fnd_flex_ext.breakup_segments (l_concat_seg_IDs, l_delim, l_loc_seglist);

7605: -- get IDs for the concatenated segments as MTI validates IDs.
7606: l_concat_seg_IDs := fnd_flex_keyval.concatenated_ids;
7607:
7608: -- breakup locator concat IDs into segments.
7609: l_loc_nseg := fnd_flex_ext.breakup_segments (l_concat_seg_IDs, l_delim, l_loc_seglist);
7610:
7611: /*
7612: -- validate if enabled segments equal to input locator segments.
7613: -- if not, raise error and return.