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.OKL_ACC_GEN_WF_PVT dependencies on WF_ENGINE

Line 44: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,

40: );
41:
42: -- Populate the required attributes for bug 4157521
43:
44: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,
45: itemkey => l_ItemKey,
46: aname => 'PRODUCT_ID',
47: avalue => p_acc_gen_wf_sources_rec.product_id);
48:

Line 49: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,

45: itemkey => l_ItemKey,
46: aname => 'PRODUCT_ID',
47: avalue => p_acc_gen_wf_sources_rec.product_id);
48:
49: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,
50: itemkey => l_ItemKey,
51: aname => 'TRANSACTION_TYPE_ID',
52: avalue => p_acc_gen_wf_sources_rec.transaction_type_id);
53:

Line 54: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,

50: itemkey => l_ItemKey,
51: aname => 'TRANSACTION_TYPE_ID',
52: avalue => p_acc_gen_wf_sources_rec.transaction_type_id);
53:
54: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,
55: itemkey => l_ItemKey,
56: aname => 'STREAM_TYPE_ID',
57: avalue => p_acc_gen_wf_sources_rec.stream_type_id);
58:

Line 59: wf_engine.SetItemAttrText(itemtype => l_ItemType,

55: itemkey => l_ItemKey,
56: aname => 'STREAM_TYPE_ID',
57: avalue => p_acc_gen_wf_sources_rec.stream_type_id);
58:
59: wf_engine.SetItemAttrText(itemtype => l_ItemType,
60: itemkey => l_ItemKey,
61: aname => 'FACTORING_SYND_FLAG',
62: avalue => p_acc_gen_wf_sources_rec.factoring_synd_flag);
63:

Line 64: wf_engine.SetItemAttrText(itemtype => l_ItemType,

60: itemkey => l_ItemKey,
61: aname => 'FACTORING_SYND_FLAG',
62: avalue => p_acc_gen_wf_sources_rec.factoring_synd_flag);
63:
64: wf_engine.SetItemAttrText(itemtype => l_ItemType,
65: itemkey => l_ItemKey,
66: aname => 'SYNDICATION_CODE',
67: avalue => p_acc_gen_wf_sources_rec.syndication_code);
68:

Line 69: wf_engine.SetItemAttrText(itemtype => l_ItemType,

65: itemkey => l_ItemKey,
66: aname => 'SYNDICATION_CODE',
67: avalue => p_acc_gen_wf_sources_rec.syndication_code);
68:
69: wf_engine.SetItemAttrText(itemtype => l_ItemType,
70: itemkey => l_ItemKey,
71: aname => 'FACTORING_CODE',
72: avalue => p_acc_gen_wf_sources_rec.factoring_code);
73:

Line 74: wf_engine.SetItemAttrText(itemtype => l_ItemType,

70: itemkey => l_ItemKey,
71: aname => 'FACTORING_CODE',
72: avalue => p_acc_gen_wf_sources_rec.factoring_code);
73:
74: wf_engine.SetItemAttrText(itemtype => l_ItemType,
75: itemkey => l_ItemKey,
76: aname => 'INVESTOR_CODE',
77: avalue => p_acc_gen_wf_sources_rec.investor_code);
78:

Line 79: wf_engine.SetItemAttrText(itemtype => l_ItemType,

75: itemkey => l_ItemKey,
76: aname => 'INVESTOR_CODE',
77: avalue => p_acc_gen_wf_sources_rec.investor_code);
78:
79: wf_engine.SetItemAttrText(itemtype => l_ItemType,
80: itemkey => l_ItemKey,
81: aname => 'MEMO_YN',
82: avalue => p_acc_gen_wf_sources_rec.memo_yn);
83:

Line 84: wf_engine.SetItemAttrText(itemtype => l_ItemType,

80: itemkey => l_ItemKey,
81: aname => 'MEMO_YN',
82: avalue => p_acc_gen_wf_sources_rec.memo_yn);
83:
84: wf_engine.SetItemAttrText(itemtype => l_ItemType,
85: itemkey => l_ItemKey,
86: aname => 'REV_REC_FLAG',
87: avalue => p_acc_gen_wf_sources_rec.rev_rec_flag);
88:

Line 89: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,

85: itemkey => l_ItemKey,
86: aname => 'REV_REC_FLAG',
87: avalue => p_acc_gen_wf_sources_rec.rev_rec_flag);
88:
89: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,
90: itemkey => l_ItemKey,
91: aname => 'SOURCE_ID',
92: avalue => p_acc_gen_wf_sources_rec.source_id);
93:

Line 94: wf_engine.SetItemAttrText(itemtype => l_ItemType,

90: itemkey => l_ItemKey,
91: aname => 'SOURCE_ID',
92: avalue => p_acc_gen_wf_sources_rec.source_id);
93:
94: wf_engine.SetItemAttrText(itemtype => l_ItemType,
95: itemkey => l_ItemKey,
96: aname => 'SOURCE_TABLE',
97: avalue => p_acc_gen_wf_sources_rec.source_table);
98:

Line 99: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,

95: itemkey => l_ItemKey,
96: aname => 'SOURCE_TABLE',
97: avalue => p_acc_gen_wf_sources_rec.source_table);
98:
99: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,
100: itemkey => l_ItemKey,
101: aname => 'CONTRACT_ID',
102: avalue => p_acc_gen_wf_sources_rec.contract_id);
103:

Line 104: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,

100: itemkey => l_ItemKey,
101: aname => 'CONTRACT_ID',
102: avalue => p_acc_gen_wf_sources_rec.contract_id);
103:
104: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,
105: itemkey => l_ItemKey,
106: aname => 'CONTRACT_LINE_ID',
107: avalue => p_acc_gen_wf_sources_rec.contract_line_id);
108:

Line 109: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,

105: itemkey => l_ItemKey,
106: aname => 'CONTRACT_LINE_ID',
107: avalue => p_acc_gen_wf_sources_rec.contract_line_id);
108:
109: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,
110: itemkey => l_ItemKey,
111: aname => 'TEMPLATE_LINE_ID',
112: avalue => p_ae_tmpt_line_id);
113:

Line 114: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,

110: itemkey => l_ItemKey,
111: aname => 'TEMPLATE_LINE_ID',
112: avalue => p_ae_tmpt_line_id);
113:
114: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,
115: itemkey => l_ItemKey,
116: aname => 'CHART_OF_ACCOUNTS_ID',
117: avalue => l_chart_of_accounts_id);
118:

Line 119: wf_engine.SetItemAttrText(itemtype => l_ItemType,

115: itemkey => l_ItemKey,
116: aname => 'CHART_OF_ACCOUNTS_ID',
117: avalue => l_chart_of_accounts_id);
118:
119: wf_engine.SetItemAttrText(itemtype => l_ItemType,
120: itemkey => l_ItemKey,
121: aname => 'ACCOUNT_GENERATOR_RULE',
122: avalue => p_ae_line_type);
123:

Line 124: wf_engine.SetItemAttrDate(itemtype => l_ItemType,

120: itemkey => l_ItemKey,
121: aname => 'ACCOUNT_GENERATOR_RULE',
122: avalue => p_ae_line_type);
123:
124: wf_engine.SetItemAttrDate(itemtype => l_ItemType,
125: itemkey => l_ItemKey,
126: aname => 'ACCOUNTING_DATE',
127: avalue => p_acc_gen_wf_sources_rec.accounting_date);
128:

Line 134: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,

130: IF p_primary_key_tbl.COUNT > 0 THEN
131: FOR i IN p_primary_key_tbl.FIRST .. p_primary_key_tbl.LAST LOOP
132:
133: IF p_primary_key_tbl(i).source_table = 'AP_VENDOR_SITES_V' THEN
134: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,
135: itemkey => l_ItemKey,
136: aname => 'VENDOR_SITE_ID',
137: avalue => TRIM(p_primary_key_tbl(i).primary_key_column));
138:

Line 140: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,

136: aname => 'VENDOR_SITE_ID',
137: avalue => TRIM(p_primary_key_tbl(i).primary_key_column));
138:
139: ELSIF p_primary_key_tbl(i).source_table = 'AR_SITE_USES_V' THEN
140: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,
141: itemkey => l_ItemKey,
142: aname => 'SITE_USE_ID',
143: avalue => TRIM(p_primary_key_tbl(i).primary_key_column));
144:

Line 146: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,

142: aname => 'SITE_USE_ID',
143: avalue => TRIM(p_primary_key_tbl(i).primary_key_column));
144:
145: ELSIF p_primary_key_tbl(i).source_table = 'FA_CATEGORY_BOOKS' THEN
146: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,
147: itemkey => l_ItemKey,
148: aname => 'ASSET_CATEGORY_ID',
149: avalue => TRIM(SUBSTR(p_primary_key_tbl(i).primary_key_column, 1, 50)));
150:

Line 151: wf_engine.SetItemAttrText(itemtype => l_ItemType,

147: itemkey => l_ItemKey,
148: aname => 'ASSET_CATEGORY_ID',
149: avalue => TRIM(SUBSTR(p_primary_key_tbl(i).primary_key_column, 1, 50)));
150:
151: wf_engine.SetItemAttrText(itemtype => l_ItemType,
152: itemkey => l_ItemKey,
153: aname => 'BOOK_TYPE_CODE',
154: avalue => TRIM(SUBSTR(p_primary_key_tbl(i).primary_key_column, 51, 100)));
155:

Line 157: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,

153: aname => 'BOOK_TYPE_CODE',
154: avalue => TRIM(SUBSTR(p_primary_key_tbl(i).primary_key_column, 51, 100)));
155:
156: ELSIF p_primary_key_tbl(i).source_table = 'FINANCIALS_SYSTEM_PARAMETERS' THEN
157: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,
158: itemkey => l_ItemKey,
159: aname => 'ORG_ID',
160: avalue => TRIM(p_primary_key_tbl(i).primary_key_column));
161:

Line 163: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,

159: aname => 'ORG_ID',
160: avalue => TRIM(p_primary_key_tbl(i).primary_key_column));
161:
162: ELSIF p_primary_key_tbl(i).source_table = 'JTF_RS_SALESREPS_MO_V' THEN
163: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,
164: itemkey => l_ItemKey,
165: aname => 'SALESREP_ID',
166: avalue => TRIM(p_primary_key_tbl(i).primary_key_column));
167:

Line 169: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,

165: aname => 'SALESREP_ID',
166: avalue => TRIM(p_primary_key_tbl(i).primary_key_column));
167:
168: ELSIF p_primary_key_tbl(i).source_table = 'MTL_SYSTEM_ITEMS_VL' THEN
169: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,
170: itemkey => l_ItemKey,
171: aname => 'INVENTORY_ITEM_ID',
172: avalue => TRIM(SUBSTR(p_primary_key_tbl(i).primary_key_column, 1, 50)));
173:

Line 174: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,

170: itemkey => l_ItemKey,
171: aname => 'INVENTORY_ITEM_ID',
172: avalue => TRIM(SUBSTR(p_primary_key_tbl(i).primary_key_column, 1, 50)));
173:
174: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,
175: itemkey => l_ItemKey,
176: aname => 'INVENTORY_ORG_ID',
177: avalue => TRIM(SUBSTR(p_primary_key_tbl(i).primary_key_column, 51, 100)));
178:

Line 181: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,

177: avalue => TRIM(SUBSTR(p_primary_key_tbl(i).primary_key_column, 51, 100)));
178:
179:
180: ELSIF p_primary_key_tbl(i).source_table = 'RA_CUST_TRX_TYPES' THEN
181: wf_engine.SetItemAttrNumber(itemtype => l_ItemType,
182: itemkey => l_ItemKey,
183: aname => 'CUST_TRX_TYPE_ID',
184: avalue => TRIM(p_primary_key_tbl(i).primary_key_column));
185:

Line 229: l_atl_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TEMPLATE_LINE_ID');

225: WHERE ID = l_atl_id;
226:
227: BEGIN
228:
229: l_atl_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'TEMPLATE_LINE_ID');
230:
231: OPEN atl_ccid_csr (l_atl_id);
232: FETCH atl_ccid_csr INTO l_template_line_ccid;
233: CLOSE atl_ccid_csr;

Line 235: wf_engine.SetItemAttrNumber(itemtype => itemtype,

231: OPEN atl_ccid_csr (l_atl_id);
232: FETCH atl_ccid_csr INTO l_template_line_ccid;
233: CLOSE atl_ccid_csr;
234:
235: wf_engine.SetItemAttrNumber(itemtype => itemtype,
236: itemkey => itemkey,
237: aname => 'TEMPLATE_LINE_CCID',
238: avalue => l_template_line_ccid);
239:

Line 245: l_account_type := wf_engine.GetItemAttrText(itemtype,itemkey,'ACCOUNT_TYPE');

241: /* User puts the required logic over here
242: Eg
243:
244: IF (funcmode = 'RUN') THEN
245: l_account_type := wf_engine.GetItemAttrText(itemtype,itemkey,'ACCOUNT_TYPE');
246: IF (h_account_type = 'LEASE_RECEIVABLES') THEN
247: result := 'COMPLETE:' || 'LEASE_RECEIVABLES_ACCOUNT';
248: RETURN;
249: END IF;