APPS.WMA_DERIVE dependencies on WMA_COMMON

Line 34: * given an itemID, getItem populates the wma_common.Item structure

30: END getNextVal;
31:
32:
33: /**
34: * given an itemID, getItem populates the wma_common.Item structure
35: * with the item information.
36: */
37: FUNCTION getItem (
38: itemID IN NUMBER,

Line 39: orgID IN NUMBER) return wma_common.Item

35: * with the item information.
36: */
37: FUNCTION getItem (
38: itemID IN NUMBER,
39: orgID IN NUMBER) return wma_common.Item
40: IS
41: item wma_common.Item;
42:
43: cursor getItemInfo (itemID NUMBER, orgID NUMBER) IS

Line 41: item wma_common.Item;

37: FUNCTION getItem (
38: itemID IN NUMBER,
39: orgID IN NUMBER) return wma_common.Item
40: IS
41: item wma_common.Item;
42:
43: cursor getItemInfo (itemID NUMBER, orgID NUMBER) IS
44: select msikfv.inventory_item_id,
45: msikfv.concatenated_segments,

Line 85: * wma_common.Item structure with the item information. Calling this

81:
82:
83: /**
84: * given an itemID and a locatorID, getItem populates the
85: * wma_common.Item structure with the item information. Calling this
86: * version of getItem fills in the projectID and taskID fields of
87: * wma_common.Item
88: */
89: FUNCTION getItem (

Line 87: * wma_common.Item

83: /**
84: * given an itemID and a locatorID, getItem populates the
85: * wma_common.Item structure with the item information. Calling this
86: * version of getItem fills in the projectID and taskID fields of
87: * wma_common.Item
88: */
89: FUNCTION getItem (
90: itemID IN NUMBER,
91: orgID IN NUMBER,

Line 92: locatorID IN NUMBER) return wma_common.Item

88: */
89: FUNCTION getItem (
90: itemID IN NUMBER,
91: orgID IN NUMBER,
92: locatorID IN NUMBER) return wma_common.Item
93: IS
94: item wma_common.Item;
95:
96: cursor getItemInfo (orgID NUMBER, locatorID NUMBER) IS

Line 94: item wma_common.Item;

90: itemID IN NUMBER,
91: orgID IN NUMBER,
92: locatorID IN NUMBER) return wma_common.Item
93: IS
94: item wma_common.Item;
95:
96: cursor getItemInfo (orgID NUMBER, locatorID NUMBER) IS
97: select mil.project_id,
98: mil.task_id

Line 121: * getJob will fill out the structure wma_common.Job given the

117: END getItem;
118:
119:
120: /**
121: * getJob will fill out the structure wma_common.Job given the
122: * wipEntityID. Note that the given wipEntityID should be connected
123: * to a discrete job instead of a repetitive schedule.
124: *
125: * HISTORY:

Line 129: Function getJob(wipEntityID NUMBER) return wma_common.Job IS

125: * HISTORY:
126: * 30-DEC-2004 spondalu Bug 4093569: eAM-WMS Integration enhancements: Relaxed
127: * entity_type condition to include eAM jobs.
128: */
129: Function getJob(wipEntityID NUMBER) return wma_common.Job IS
130: jobInfo wma_common.Job;
131:
132: cursor theJob (wipEntityID NUMBER) IS
133: select wdj.wip_entity_id,

Line 130: jobInfo wma_common.Job;

126: * 30-DEC-2004 spondalu Bug 4093569: eAM-WMS Integration enhancements: Relaxed
127: * entity_type condition to include eAM jobs.
128: */
129: Function getJob(wipEntityID NUMBER) return wma_common.Job IS
130: jobInfo wma_common.Job;
131:
132: cursor theJob (wipEntityID NUMBER) IS
133: select wdj.wip_entity_id,
134: wdj.organization_id,

Line 181: environment IN OUT NOCOPY wma_common.Environment)

177: * derive the rest of the structure as possible depending on the
178: * information available to it.
179: */
180: PROCEDURE deriveEnvironment (
181: environment IN OUT NOCOPY wma_common.Environment)
182: IS
183: userName varchar2(100);
184: orgCode varchar2(4);
185: