48: X_flex_num,
49: 'FAFLEXWF'
50: );
51:
52: wf_engine.SetItemAttrNumber
53: (itemtype => itemtype,
54: itemkey => itemkey,
55: aname => 'CHART_OF_ACCOUNTS_ID',
56: avalue => X_flex_num);
54: itemkey => itemkey,
55: aname => 'CHART_OF_ACCOUNTS_ID',
56: avalue => X_flex_num);
57:
58: wf_engine.SetItemAttrText
59: (itemtype => itemtype,
60: itemkey => itemkey,
61: aname => 'BOOK_TYPE_CODE',
62: avalue => X_book_type_code);
60: itemkey => itemkey,
61: aname => 'BOOK_TYPE_CODE',
62: avalue => X_book_type_code);
63:
64: wf_engine.SetItemAttrNumber
65: (itemtype => itemtype,
66: itemkey => itemkey,
67: aname => 'DEFAULT_CCID',
68: avalue => X_default_ccid);
68: avalue => X_default_ccid);
69:
70: BEGIN
71:
72: wf_engine.SetItemAttrDate
73: (itemtype => itemtype,
74: itemkey => itemkey,
75: aname => 'VALIDATION_DATE',
76: avalue => X_validation_date);
77:
78: EXCEPTION
79: when others then
80: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then
81: wf_engine.AddItemAttr(itemtype,itemkey,'VALIDATION_DATE');
82: wf_engine.SetItemAttrDate
83: (itemtype => itemtype,
84: itemkey => itemkey,
85: aname => 'VALIDATION_DATE',
78: EXCEPTION
79: when others then
80: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then
81: wf_engine.AddItemAttr(itemtype,itemkey,'VALIDATION_DATE');
82: wf_engine.SetItemAttrDate
83: (itemtype => itemtype,
84: itemkey => itemkey,
85: aname => 'VALIDATION_DATE',
86: avalue => X_validation_date);
92:
93:
94: -- Initialize the workflow item attributes
95:
96: wf_engine.SetItemAttrText
97: (itemtype => itemtype,
98: itemkey => itemkey,
99: aname => 'ACCOUNT_TYPE',
100: avalue => X_flex_account_type);
98: itemkey => itemkey,
99: aname => 'ACCOUNT_TYPE',
100: avalue => X_flex_account_type);
101:
102: wf_engine.SetItemAttrNumber
103: (itemtype => itemtype,
104: itemkey => itemkey,
105: aname => 'DISTRIBUTION_CCID',
106: avalue => X_dist_ccid );
104: itemkey => itemkey,
105: aname => 'DISTRIBUTION_CCID',
106: avalue => X_dist_ccid );
107:
108: wf_engine.SetItemAttrText
109: (itemtype => itemtype,
110: itemkey => itemkey,
111: aname => 'ACCT_SEG_VAL',
112: avalue => X_acct_segval);
110: itemkey => itemkey,
111: aname => 'ACCT_SEG_VAL',
112: avalue => X_acct_segval);
113:
114: wf_engine.SetItemAttrNumber
115: (itemtype => itemtype,
116: itemkey => itemkey,
117: aname => 'ACCOUNT_CCID',
118: avalue => X_account_ccid);
116: itemkey => itemkey,
117: aname => 'ACCOUNT_CCID',
118: avalue => X_account_ccid);
119:
120: wf_engine.SetItemAttrNumber
121: (itemtype => itemtype,
122: itemkey => itemkey,
123: aname => 'DISTRIBUTION_ID',
124: avalue => X_distribution_id);
229:
230: BEGIN <
231:
232: IF (funcmode = 'RUN') THEN
233: h_book_type_code := wf_engine.GetItemAttrText(itemtype,itemkey,'BOOK_TYPE_CODE');
234: SELECT book_class
235: INTO h_book_class
236: FROM fa_book_controls
237: WHERE book_type_code = h_book_type_code;
263: h_account_type VARCHAR2(30);
264:
265: BEGIN <
266: IF (funcmode = 'RUN') THEN
267: h_account_type := wf_engine.GetItemAttrText(itemtype,itemkey,'ACCOUNT_TYPE');
268: result := 'COMPLETE:' || h_account_type;
269: RETURN;
270: ELSIF (funcmode = 'CANCEL') THEN
271: result := 'COMPLETE:';
292: h_account_type VARCHAR2(30);
293:
294: BEGIN <
295: IF (funcmode = 'RUN') THEN
296: h_account_type := wf_engine.GetItemAttrText(itemtype,itemkey,'ACCOUNT_TYPE');
297: IF (h_account_type in ('ASSET_COST','ASSET_CLEARING',
298: 'CIP_CLEARING','CIP_COST',
299: 'DEPRN_RSV','REV_AMORT','REV_RSV',
300: 'BONUS_DEPRN_RSV','BONUS_DEPRN_EXP')) THEN
333: h_book_type VARCHAR2(30);
334:
335: BEGIN <
336: IF (funcmode = 'RUN') THEN
337: h_book_type := wf_engine.GetItemAttrText(itemtype,itemkey,'BOOK_TYPE_CODE');
338: result := 'COMPLETE:' || h_book_type;
339: RETURN;
340: ELSIF (funcmode = 'CANCEL') THEN
341: result := 'COMPLETE:';