15: ) IS
16:
17: BEGIN
18:
19: EventName := WF_ENGINE.GetItemAttrText
20: ( ItemType => ItemType
21: , ItemKey => ItemKey
22: , AName => 'ECX_EVENT_NAME' );
23:
50: BEGIN
51: --
52: -- Contract Number is stored in Parameter 1
53: --
54: ContractNum := WF_ENGINE.GetItemAttrText
55: ( ItemType => ItemType
56: , ItemKey => ItemKey
57: , AName => 'ECX_PARAMETER1' );
58:
55: ( ItemType => ItemType
56: , ItemKey => ItemKey
57: , AName => 'ECX_PARAMETER1' );
58:
59: WF_ENGINE.SetItemAttrText
60: ( ItemType => ItemType
61: , ItemKey => ItemKey
62: , AName => 'CONTRACT_NUM'
63: , AValue => ContractNum );
64:
65: --
66: -- Order Number, if any, is stored in Parameter 2
67: --
68: OrderNum := WF_ENGINE.GetItemAttrText
69: ( ItemType => ItemType
70: , ItemKey => ItemKey
71: , AName => 'ECX_PARAMETER2' );
72:
69: ( ItemType => ItemType
70: , ItemKey => ItemKey
71: , AName => 'ECX_PARAMETER2' );
72:
73: WF_ENGINE.SetItemAttrText
74: ( ItemType => ItemType
75: , ItemKey => ItemKey
76: , AName => 'ORDER_NUM'
77: , AValue => OrderNum );
78:
79: --
80: -- Shipment Number is stored in Parameter 3
81: --
82: ShipmentNum := WF_ENGINE.GetItemAttrText
83: ( ItemType => ItemType
84: , ItemKey => ItemKey
85: , AName => 'ECX_PARAMETER3' );
86:
83: ( ItemType => ItemType
84: , ItemKey => ItemKey
85: , AName => 'ECX_PARAMETER3' );
86:
87: WF_ENGINE.SetItemAttrText
88: ( ItemType => ItemType
89: , ItemKey => ItemKey
90: , AName => 'SHIPMENT_NUM'
91: , AValue => ShipmentNum );
92:
93: --
94: -- Requestor is stored in Parameter 3
95: --
96: Requestor := WF_ENGINE.GetItemAttrText
97: ( ItemType => ItemType
98: , ItemKey => ItemKey
99: , AName => 'ECX_PARAMETER5' );
100:
97: ( ItemType => ItemType
98: , ItemKey => ItemKey
99: , AName => 'ECX_PARAMETER5' );
100:
101: WF_ENGINE.SetItemAttrText
102: ( ItemType => ItemType
103: , ItemKey => ItemKey
104: , AName => 'REQUESTOR'
105: , AValue => Requestor );
107: --
108: -- Finally, get Shipping information from the reference column in
109: -- OKE_K_FORM_HEADERS
110: --
111: FormHeaderID := WF_ENGINE.GetItemAttrText
112: ( ItemType => ItemType
113: , ItemKey => ItemKey
114: , AName => 'ECX_DOCUMENT_ID' );
115:
116: OPEN DeliveryInfo ( FormHeaderID );
117: FETCH DeliveryInfo INTO DeliveryName , ShipFromOrg;
118: CLOSE DeliveryInfo;
119:
120: WF_ENGINE.SetItemAttrText
121: ( ItemType => ItemType
122: , ItemKey => ItemKey
123: , AName => 'DELIVERY_NAME'
124: , AValue => DeliveryName );
122: , ItemKey => ItemKey
123: , AName => 'DELIVERY_NAME'
124: , AValue => DeliveryName );
125:
126: WF_ENGINE.SetItemAttrText
127: ( ItemType => ItemType
128: , ItemKey => ItemKey
129: , AName => 'SHIP_FROM_ORG'
130: , AValue => ShipFromOrg );
165: --
166:
167: XmlUrl := wf_oam_util.getviewXMLURL('ECX_EVENT_MESSAGE',ItemType,ItemKey,OutputMimeType);
168:
169: WF_ENGINE.SetItemAttrText
170: ( ItemType => ItemType
171: , ItemKey => ItemKey
172: , AName => 'DOCUMENT_URL'
173: , AValue => XmlUrl
240: BEGIN
241:
242: IF ( FuncMode = 'RUN' ) THEN
243:
244: IF ( WF_ENGINE.GetItemAttrNumber
245: ( ItemType => ItemType
246: , ItemKey => ItemKey
247: , AName => 'ATTACHED_DOCUMENT_ID' ) IS NOT NULL ) THEN
248: ResultOut := 'COMPLETE:';
248: ResultOut := 'COMPLETE:';
249: RETURN;
250: END IF;
251:
252: FormHeaderID := WF_ENGINE.GetItemAttrText
253: ( ItemType => ItemType
254: , ItemKey => ItemKey
255: , AName => 'ECX_DOCUMENT_ID' );
256:
253: ( ItemType => ItemType
254: , ItemKey => ItemKey
255: , AName => 'ECX_DOCUMENT_ID' );
256:
257: FormCreationDate := to_date( WF_ENGINE.GetItemAttrText
258: ( ItemType => ItemType
259: , ItemKey => ItemKey
260: , AName => 'ECX_PARAMETER4' )
261: , 'DDMONRRHH24MISS' );
259: , ItemKey => ItemKey
260: , AName => 'ECX_PARAMETER4' )
261: , 'DDMONRRHH24MISS' );
262:
263: FileName := WF_ENGINE.GetItemAttrText
264: ( ItemType => ItemType
265: , ItemKey => ItemKey
266: , AName => 'DOCUMENT_URL' );
267:
316: , X_MEDIA_ID => MediaID
317: , X_CREATE_DOC => 'Y'
318: );
319:
320: WF_ENGINE.SetItemAttrNumber
321: ( ItemType => ItemType
322: , ItemKey => ItemKey
323: , AName => 'ATTACHED_DOCUMENT_ID'
324: , AValue => frec.attached_document_id