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 95: p_x_mti_seglist IN OUT NOCOPY fnd_flex_ext.SegmentArray,

91: -- Added for FP ER 6447935.
92: -- breakup input locator concatenated segments to populate MTI.
93: PROCEDURE Get_MTL_LocatorSegs (p_concat_segs IN VARCHAR2,
94: p_organization_id IN NUMBER,
95: p_x_mti_seglist IN OUT NOCOPY fnd_flex_ext.SegmentArray,
96: x_return_status OUT NOCOPY VARCHAR2);
97:
98:
99: --Declare any types used by the procedure

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

140: FROM MTL_ITEM_LOCATIONS_KFV MIL_kfv, MTL_ITEM_LOCATIONS MIL
141: WHERE MIL_kfv.INVENTORY_LOCATION_ID = MIL.INVENTORY_LOCATION_ID
142: AND MIL.ORGANIZATION_ID = p_org_Id
143: AND upper(decode(MIL.segment19, null, MIL_kfv.concatenated_segments,
144: INV_PROJECT.GET_LOCSEGS(MIL_kfv.concatenated_segments) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
145: || INV_ProjectLocator_PUB.get_project_number(MIL.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
146: || INV_ProjectLocator_PUB.get_task_number(MIL.segment20))) = upper(p_location_name)
147: AND ((MIL.START_DATE_ACTIVE IS NULL) OR (MIL.START_DATE_ACTIVE <= SYSDATE))
148: AND ((MIL.END_DATE_ACTIVE IS NULL) OR (MIL.END_DATE_ACTIVE >= SYSDATE));

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

141: WHERE MIL_kfv.INVENTORY_LOCATION_ID = MIL.INVENTORY_LOCATION_ID
142: AND MIL.ORGANIZATION_ID = p_org_Id
143: AND upper(decode(MIL.segment19, null, MIL_kfv.concatenated_segments,
144: INV_PROJECT.GET_LOCSEGS(MIL_kfv.concatenated_segments) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
145: || INV_ProjectLocator_PUB.get_project_number(MIL.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
146: || INV_ProjectLocator_PUB.get_task_number(MIL.segment20))) = upper(p_location_name)
147: AND ((MIL.START_DATE_ACTIVE IS NULL) OR (MIL.START_DATE_ACTIVE <= SYSDATE))
148: AND ((MIL.END_DATE_ACTIVE IS NULL) OR (MIL.END_DATE_ACTIVE >= SYSDATE));
149:

Line 3533: l_mti_seglist fnd_flex_ext.SegmentArray;

3529: l_qty NUMBER;
3530: l_reservation_flag VARCHAR2(1);
3531:
3532: -- added to support dynamic locator creation.
3533: l_mti_seglist fnd_flex_ext.SegmentArray;
3534:
3535: l_loop_count NUMBER;
3536:
3537: CURSOR TRX_ACTION_CUR(p_type_Id NUMBER) IS

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

4662: WIP.DEFAULT_PULL_SUPPLY_SUBINV,
4663: WIP.DEFAULT_PULL_SUPPLY_LOCATOR_ID,
4664: --MTL_LOC.CONCATENATED_SEGMENTS LOCATOR
4665: --Fix for bug number 5903275
4666: inv_project.GET_LOCSEGS(WIP.DEFAULT_PULL_SUPPLY_LOCATOR_ID, WIP.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
4667: || INV_ProjectLocator_PUB.get_project_number(MTL_LOC.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
4668: || INV_ProjectLocator_PUB.get_task_number(MTL_LOC.segment20) LOCATOR,
4669: --SYSDATE
4670: (select inv_locator_id from ahl_visits_b where visit_id = vst.visit_id) inv_locator_id

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

4663: WIP.DEFAULT_PULL_SUPPLY_LOCATOR_ID,
4664: --MTL_LOC.CONCATENATED_SEGMENTS LOCATOR
4665: --Fix for bug number 5903275
4666: inv_project.GET_LOCSEGS(WIP.DEFAULT_PULL_SUPPLY_LOCATOR_ID, WIP.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
4667: || INV_ProjectLocator_PUB.get_project_number(MTL_LOC.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
4668: || INV_ProjectLocator_PUB.get_task_number(MTL_LOC.segment20) LOCATOR,
4669: --SYSDATE
4670: (select inv_locator_id from ahl_visits_b where visit_id = vst.visit_id) inv_locator_id
4671: FROM

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

4742: W.DEFAULT_PULL_SUPPLY_SUBINV,
4743: W.DEFAULT_PULL_SUPPLY_LOCATOR_ID,
4744: --D.CONCATENATED_SEGMENTS Locator
4745: -- Fix for bug number 5903275
4746: inv_project.GET_LOCSEGS(W.DEFAULT_PULL_SUPPLY_LOCATOR_ID, W.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
4747: || INV_ProjectLocator_PUB.get_project_number(D.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
4748: || INV_ProjectLocator_PUB.get_task_number(D.segment20) LOCATOR,
4749: --SYSDATE
4750: (select inv_locator_id from ahl_visits_b where visit_id = E.visit_id) inv_locator_id

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

4743: W.DEFAULT_PULL_SUPPLY_LOCATOR_ID,
4744: --D.CONCATENATED_SEGMENTS Locator
4745: -- Fix for bug number 5903275
4746: inv_project.GET_LOCSEGS(W.DEFAULT_PULL_SUPPLY_LOCATOR_ID, W.organization_id) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
4747: || INV_ProjectLocator_PUB.get_project_number(D.segment19) || fnd_flex_ext.get_delimiter('INV', 'MTLL', 101)
4748: || INV_ProjectLocator_PUB.get_task_number(D.segment20) LOCATOR,
4749: --SYSDATE
4750: (select inv_locator_id from ahl_visits_b where visit_id = E.visit_id) inv_locator_id
4751: FROM

Line 5790: p_x_mti_seglist IN OUT NOCOPY fnd_flex_ext.SegmentArray,

5786: -- Added for FP ER 6447935 - dynamic locator support.
5787: -- breakup input locator concatenated segments to populate MTI.
5788: PROCEDURE Get_MTL_LocatorSegs (p_concat_segs IN VARCHAR2,
5789: p_organization_id IN NUMBER,
5790: p_x_mti_seglist IN OUT NOCOPY fnd_flex_ext.SegmentArray,
5791: x_return_status OUT NOCOPY VARCHAR2)
5792:
5793: IS
5794:

Line 5803: l_loc_seglist fnd_flex_ext.SegmentArray;

5799: l_segment_type fnd_flex_key_api.segment_type;
5800: l_delim VARCHAR2(1);
5801:
5802: l_loc_nseg number;
5803: l_loc_seglist fnd_flex_ext.SegmentArray;
5804: l_mti_seglist fnd_flex_ext.SegmentArray;
5805: l_concat_seg_IDs VARCHAR2(4000);
5806:
5807: l_valid_flag BOOLEAN;

Line 5804: l_mti_seglist fnd_flex_ext.SegmentArray;

5800: l_delim VARCHAR2(1);
5801:
5802: l_loc_nseg number;
5803: l_loc_seglist fnd_flex_ext.SegmentArray;
5804: l_mti_seglist fnd_flex_ext.SegmentArray;
5805: l_concat_seg_IDs VARCHAR2(4000);
5806:
5807: l_valid_flag BOOLEAN;
5808:

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

5860: -- get IDs for the concatenated segments as MTI validates IDs.
5861: l_concat_seg_IDs := fnd_flex_keyval.concatenated_ids;
5862:
5863: -- breakup locator concat IDs into segments.
5864: l_loc_nseg := fnd_flex_ext.breakup_segments (l_concat_seg_IDs, l_delim, l_loc_seglist);
5865:
5866: /*
5867: -- validate if enabled segments equal to input locator segments.
5868: -- if not, raise error and return.