DBA Data[Home] [Help]

APPS.FUN_NET_APPROVAL_WF dependencies on WF_ENGINE

Line 94: l_batch_id := WF_ENGINE.GetItemAttrNumber(p_item_type, p_item_key, 'BATCH_ID');

90: l_batch_currency fun_net_batches_all.batch_currency%TYPE;
91: l_path varchar2(100);
92: BEGIN
93: l_path := g_path || 'Initialize';
94: l_batch_id := WF_ENGINE.GetItemAttrNumber(p_item_type, p_item_key, 'BATCH_ID');
95: fun_net_util.Log_String(g_state_level,l_path,'Batch Id :'||l_batch_id);
96:
97: OPEN c_get_batch_details(l_batch_id);
98: FETCH c_get_batch_details INTO l_batch_number,

Line 107: WF_ENGINE.SetItemAttrNumber(p_item_type, p_item_key, 'BATCH_NUMBER',l_batch_number);

103: l_agreement_id,
104: l_batch_currency;
105: CLOSE c_get_batch_details;
106: fun_net_util.Log_String(g_state_level,l_path,'Setting WF Attributes');
107: WF_ENGINE.SetItemAttrNumber(p_item_type, p_item_key, 'BATCH_NUMBER',l_batch_number);
108: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'BATCH_NAME',l_batch_name);
109: WF_ENGINE.SetItemAttrDate(p_item_type, p_item_key, 'RESPONSE_DATE',l_response_date);
110: WF_ENGINE.SetItemAttrNumber(p_item_type, p_item_key, 'NETTING_AMOUNT',l_netting_amount);
111: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'BATCH_CURRENCY',l_batch_currency);

Line 108: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'BATCH_NAME',l_batch_name);

104: l_batch_currency;
105: CLOSE c_get_batch_details;
106: fun_net_util.Log_String(g_state_level,l_path,'Setting WF Attributes');
107: WF_ENGINE.SetItemAttrNumber(p_item_type, p_item_key, 'BATCH_NUMBER',l_batch_number);
108: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'BATCH_NAME',l_batch_name);
109: WF_ENGINE.SetItemAttrDate(p_item_type, p_item_key, 'RESPONSE_DATE',l_response_date);
110: WF_ENGINE.SetItemAttrNumber(p_item_type, p_item_key, 'NETTING_AMOUNT',l_netting_amount);
111: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'BATCH_CURRENCY',l_batch_currency);
112: fun_net_util.Log_String(g_state_level,l_path,'After Setting WF Attributes');

Line 109: WF_ENGINE.SetItemAttrDate(p_item_type, p_item_key, 'RESPONSE_DATE',l_response_date);

105: CLOSE c_get_batch_details;
106: fun_net_util.Log_String(g_state_level,l_path,'Setting WF Attributes');
107: WF_ENGINE.SetItemAttrNumber(p_item_type, p_item_key, 'BATCH_NUMBER',l_batch_number);
108: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'BATCH_NAME',l_batch_name);
109: WF_ENGINE.SetItemAttrDate(p_item_type, p_item_key, 'RESPONSE_DATE',l_response_date);
110: WF_ENGINE.SetItemAttrNumber(p_item_type, p_item_key, 'NETTING_AMOUNT',l_netting_amount);
111: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'BATCH_CURRENCY',l_batch_currency);
112: fun_net_util.Log_String(g_state_level,l_path,'After Setting WF Attributes');
113:

Line 110: WF_ENGINE.SetItemAttrNumber(p_item_type, p_item_key, 'NETTING_AMOUNT',l_netting_amount);

106: fun_net_util.Log_String(g_state_level,l_path,'Setting WF Attributes');
107: WF_ENGINE.SetItemAttrNumber(p_item_type, p_item_key, 'BATCH_NUMBER',l_batch_number);
108: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'BATCH_NAME',l_batch_name);
109: WF_ENGINE.SetItemAttrDate(p_item_type, p_item_key, 'RESPONSE_DATE',l_response_date);
110: WF_ENGINE.SetItemAttrNumber(p_item_type, p_item_key, 'NETTING_AMOUNT',l_netting_amount);
111: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'BATCH_CURRENCY',l_batch_currency);
112: fun_net_util.Log_String(g_state_level,l_path,'After Setting WF Attributes');
113:
114: OPEN c_get_preparer_id(l_created_by);

Line 111: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'BATCH_CURRENCY',l_batch_currency);

107: WF_ENGINE.SetItemAttrNumber(p_item_type, p_item_key, 'BATCH_NUMBER',l_batch_number);
108: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'BATCH_NAME',l_batch_name);
109: WF_ENGINE.SetItemAttrDate(p_item_type, p_item_key, 'RESPONSE_DATE',l_response_date);
110: WF_ENGINE.SetItemAttrNumber(p_item_type, p_item_key, 'NETTING_AMOUNT',l_netting_amount);
111: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'BATCH_CURRENCY',l_batch_currency);
112: fun_net_util.Log_String(g_state_level,l_path,'After Setting WF Attributes');
113:
114: OPEN c_get_preparer_id(l_created_by);
115: FETCH c_get_preparer_id INTO l_netting_analyst_id;

Line 126: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'ANALYST_NAME',l_analyst_name);

122: l_analyst_display_name);
123:
124: fun_net_util.Log_String(g_state_level,l_path,'Analyst Name :'||l_analyst_name);
125:
126: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'ANALYST_NAME',l_analyst_name);
127: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'ANALYST_DISP_NAME',l_analyst_display_name);
128:
129: OPEN c_get_approver_name(l_agreement_id);
130: FETCH c_get_approver_name INTO l_approver_name;

Line 127: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'ANALYST_DISP_NAME',l_analyst_display_name);

123:
124: fun_net_util.Log_String(g_state_level,l_path,'Analyst Name :'||l_analyst_name);
125:
126: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'ANALYST_NAME',l_analyst_name);
127: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'ANALYST_DISP_NAME',l_analyst_display_name);
128:
129: OPEN c_get_approver_name(l_agreement_id);
130: FETCH c_get_approver_name INTO l_approver_name;
131: CLOSE c_get_approver_name;

Line 134: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'APPROVER_NAME',l_approver_name);

130: FETCH c_get_approver_name INTO l_approver_name;
131: CLOSE c_get_approver_name;
132: fun_net_util.Log_String(g_state_level,l_path,'Approver Name:'||l_approver_name);
133:
134: WF_ENGINE.SetItemAttrText(p_item_type, p_item_key, 'APPROVER_NAME',l_approver_name);
135:
136: p_result := 'COMPLETE';
137: fun_net_util.Log_String(g_state_level,l_path,'End of Initialization');
138:

Line 161: l_batch_id := WF_ENGINE.GetItemAttrNumber(p_item_type, p_item_key, 'BATCH_ID');

157: BEGIN
158:
159: fun_net_util.Log_String(g_state_level,l_path,'Batch IdIASDASD: '||l_batch_id);
160: l_path := g_path||'Validate_Settle_Batch';
161: l_batch_id := WF_ENGINE.GetItemAttrNumber(p_item_type, p_item_key, 'BATCH_ID');
162: fun_net_util.Log_String(g_state_level,l_path,'Batch Id: '||l_batch_id);
163:
164:
165: -- Set the Multi Org Context

Line 220: l_batch_id := WF_ENGINE.GetItemAttrNumber(p_item_type, p_item_key, 'BATCH_ID');

216: l_path VARCHAR2(100);
217: BEGIN
218: l_path := g_path||'Get_NoResponse_Action';
219: fun_net_util.Log_String(g_state_level,l_path,'Start of Get_NoResponse_Action');
220: l_batch_id := WF_ENGINE.GetItemAttrNumber(p_item_type, p_item_key, 'BATCH_ID');
221: fun_net_util.Log_String(g_state_level,l_path,'Batch ID: '||l_batch_id);
222:
223: OPEN c_get_nonresponse_code(l_batch_id);
224: FETCH c_get_nonresponse_code INTO l_nonresponse_code;

Line 250: l_batch_id := WF_ENGINE.GetItemAttrNumber(p_item_type, p_item_key, 'BATCH_ID');

246: BEGIN
247: l_path := g_path||'Update_Batch_status';
248:
249: fun_net_util.Log_String(g_state_level,l_path,'Begin Update Batch Status');
250: l_batch_id := WF_ENGINE.GetItemAttrNumber(p_item_type, p_item_key, 'BATCH_ID');
251: fun_net_util.Log_String(g_state_level,l_path,'Batch Id: '||l_batch_id);
252:
253: FUN_NET_BATCHES_PKG.Update_Row
254: (x_batch_id => l_batch_id,

Line 276: l_batch_id := WF_ENGINE.GetItemAttrNumber(p_item_type, p_item_key, 'BATCH_ID');

272: BEGIN
273: l_path := g_path||'Update_Batch_status';
274:
275: fun_net_util.Log_String(g_state_level,l_path,'Begin Update Batch Status');
276: l_batch_id := WF_ENGINE.GetItemAttrNumber(p_item_type, p_item_key, 'BATCH_ID');
277: fun_net_util.Log_String(g_state_level,l_path,'Batch Id: '||l_batch_id);
278:
279: FUN_NET_BATCHES_PKG.Update_Row
280: (x_batch_id => l_batch_id,