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.FUN_NET_APPROVAL_WF dependencies on FUN_NET_BATCHES_ALL

Line 58: CURSOR c_get_batch_details(cp_batch_id fun_net_batches_all.batch_id%TYPE) IS

54: p_actid IN NUMBER,
55: p_funmode IN VARCHAR2,
56: p_result OUT NOCOPY VARCHAR2) IS
57:
58: CURSOR c_get_batch_details(cp_batch_id fun_net_batches_all.batch_id%TYPE) IS
59: SELECT batch_number,
60: batch_name,
61: response_date,
62: created_by,

Line 66: FROM fun_net_batches_all

62: created_by,
63: total_netted_amt,
64: agreement_id,
65: batch_currency
66: FROM fun_net_batches_all
67: WHERE batch_id = cp_batch_id;
68:
69: CURSOR c_get_preparer_id(cp_user_id IN fnd_user.user_id%TYPE) IS
70: SELECT employee_id

Line 79: l_batch_id fun_net_batches_all.batch_id%TYPE;

75: SELECT approver_name
76: FROM fun_net_agreements_all
77: WHERE agreement_id = cp_agreement_id;
78:
79: l_batch_id fun_net_batches_all.batch_id%TYPE;
80: l_batch_number fun_net_batches_all.batch_number%TYPE;
81: l_batch_name fun_net_batches_all.batch_name%TYPE;
82: l_response_date fun_net_batches_all.response_date%TYPE;
83: l_created_by fun_net_batches_all.created_by%TYPE;

Line 80: l_batch_number fun_net_batches_all.batch_number%TYPE;

76: FROM fun_net_agreements_all
77: WHERE agreement_id = cp_agreement_id;
78:
79: l_batch_id fun_net_batches_all.batch_id%TYPE;
80: l_batch_number fun_net_batches_all.batch_number%TYPE;
81: l_batch_name fun_net_batches_all.batch_name%TYPE;
82: l_response_date fun_net_batches_all.response_date%TYPE;
83: l_created_by fun_net_batches_all.created_by%TYPE;
84: l_netting_amount fun_net_batches_all.total_netted_amt%TYPE;

Line 81: l_batch_name fun_net_batches_all.batch_name%TYPE;

77: WHERE agreement_id = cp_agreement_id;
78:
79: l_batch_id fun_net_batches_all.batch_id%TYPE;
80: l_batch_number fun_net_batches_all.batch_number%TYPE;
81: l_batch_name fun_net_batches_all.batch_name%TYPE;
82: l_response_date fun_net_batches_all.response_date%TYPE;
83: l_created_by fun_net_batches_all.created_by%TYPE;
84: l_netting_amount fun_net_batches_all.total_netted_amt%TYPE;
85: l_netting_analyst_id fnd_user.user_id%TYPE;

Line 82: l_response_date fun_net_batches_all.response_date%TYPE;

78:
79: l_batch_id fun_net_batches_all.batch_id%TYPE;
80: l_batch_number fun_net_batches_all.batch_number%TYPE;
81: l_batch_name fun_net_batches_all.batch_name%TYPE;
82: l_response_date fun_net_batches_all.response_date%TYPE;
83: l_created_by fun_net_batches_all.created_by%TYPE;
84: l_netting_amount fun_net_batches_all.total_netted_amt%TYPE;
85: l_netting_analyst_id fnd_user.user_id%TYPE;
86: l_analyst_name wf_users.name%type;

Line 83: l_created_by fun_net_batches_all.created_by%TYPE;

79: l_batch_id fun_net_batches_all.batch_id%TYPE;
80: l_batch_number fun_net_batches_all.batch_number%TYPE;
81: l_batch_name fun_net_batches_all.batch_name%TYPE;
82: l_response_date fun_net_batches_all.response_date%TYPE;
83: l_created_by fun_net_batches_all.created_by%TYPE;
84: l_netting_amount fun_net_batches_all.total_netted_amt%TYPE;
85: l_netting_analyst_id fnd_user.user_id%TYPE;
86: l_analyst_name wf_users.name%type;
87: l_analyst_display_name wf_users.display_name%type;

Line 84: l_netting_amount fun_net_batches_all.total_netted_amt%TYPE;

80: l_batch_number fun_net_batches_all.batch_number%TYPE;
81: l_batch_name fun_net_batches_all.batch_name%TYPE;
82: l_response_date fun_net_batches_all.response_date%TYPE;
83: l_created_by fun_net_batches_all.created_by%TYPE;
84: l_netting_amount fun_net_batches_all.total_netted_amt%TYPE;
85: l_netting_analyst_id fnd_user.user_id%TYPE;
86: l_analyst_name wf_users.name%type;
87: l_analyst_display_name wf_users.display_name%type;
88: l_agreement_id fun_net_agreements_all.agreement_id%TYPE;

Line 90: l_batch_currency fun_net_batches_all.batch_currency%TYPE;

86: l_analyst_name wf_users.name%type;
87: l_analyst_display_name wf_users.display_name%type;
88: l_agreement_id fun_net_agreements_all.agreement_id%TYPE;
89: l_approver_name fun_net_agreements_all.approver_name%TYPE;
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');

Line 150: l_batch_id fun_net_batches_all.batch_id%TYPE;

146: p_actid IN NUMBER,
147: p_funmode IN VARCHAR2,
148: p_result OUT NOCOPY VARCHAR2) IS
149:
150: l_batch_id fun_net_batches_all.batch_id%TYPE;
151: l_return_status VARCHAR2(1);
152: l_msg_count NUMBER;
153: l_msg_data VARCHAR2(2000);
154: l_path VARCHAR2(100);

Line 169: FROM FUN_NET_BATCHES_ALL

165: -- Set the Multi Org Context
166:
167: SELECT ORG_ID
168: INTO L_ORG_ID
169: FROM FUN_NET_BATCHES_ALL
170: WHERE BATCH_ID = L_BATCH_ID;
171:
172:
173: mo_global.set_policy_context('S',l_org_id);

Line 188: select batch_status_code into l_status from fun_net_batches_all

184: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
185: fun_net_util.Log_String(g_state_level,l_path,'Settle batch SUCCESS');
186: p_result := 'COMPLETE:Y';
187: ELSE
188: select batch_status_code into l_status from fun_net_batches_all
189: where batch_id=l_batch_id;
190: IF l_status='ERROR' THEN
191: fun_net_util.Log_String(g_state_level,l_path,'Setting batch FAILURE');
192: p_result := 'COMPLETE:N';

Line 207: CURSOR c_get_nonresponse_code(cp_batch_id fun_net_batches_all.batch_id%TYPE) IS

203: p_actid IN NUMBER,
204: p_funmode IN VARCHAR2,
205: p_result OUT NOCOPY VARCHAR2) IS
206:
207: CURSOR c_get_nonresponse_code(cp_batch_id fun_net_batches_all.batch_id%TYPE) IS
208: SELECT a.non_response_action_code
209: FROM fun_net_agreements_all a
210: WHERE a.agreement_id = (SELECT b.agreement_id
211: FROM fun_net_batches_all b

Line 211: FROM fun_net_batches_all b

207: CURSOR c_get_nonresponse_code(cp_batch_id fun_net_batches_all.batch_id%TYPE) IS
208: SELECT a.non_response_action_code
209: FROM fun_net_agreements_all a
210: WHERE a.agreement_id = (SELECT b.agreement_id
211: FROM fun_net_batches_all b
212: WHERE b.batch_id = cp_batch_id);
213:
214: l_batch_id fun_net_batches_all.batch_id%TYPE;
215: l_nonresponse_code fun_net_agreements_all.non_response_action_code%TYPE;

Line 214: l_batch_id fun_net_batches_all.batch_id%TYPE;

210: WHERE a.agreement_id = (SELECT b.agreement_id
211: FROM fun_net_batches_all b
212: WHERE b.batch_id = cp_batch_id);
213:
214: l_batch_id fun_net_batches_all.batch_id%TYPE;
215: l_nonresponse_code fun_net_agreements_all.non_response_action_code%TYPE;
216: l_path VARCHAR2(100);
217: BEGIN
218: l_path := g_path||'Get_NoResponse_Action';

Line 243: l_batch_id fun_net_batches_all.batch_id%TYPE;

239: p_actid IN NUMBER,
240: p_funmode IN VARCHAR2,
241: p_result OUT NOCOPY VARCHAR2) IS
242:
243: l_batch_id fun_net_batches_all.batch_id%TYPE;
244: l_return_status VARCHAR2(1);
245: l_path VARCHAR2(100);
246: BEGIN
247: l_path := g_path||'Update_Batch_status';

Line 269: l_batch_id fun_net_batches_all.batch_id%TYPE;

265: p_actid IN NUMBER,
266: p_funmode IN VARCHAR2,
267: p_result OUT NOCOPY VARCHAR2) IS
268:
269: l_batch_id fun_net_batches_all.batch_id%TYPE;
270: l_return_status VARCHAR2(1);
271: l_path VARCHAR2(100);
272: BEGIN
273: l_path := g_path||'Update_Batch_status';