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.

[Home] [Help]

APPS.FUN_NET_CONC_PROG_PKG dependencies on FUN_NET_BATCHES_ALL

Line 7: p_batch_id IN fun_net_batches_all.batch_id%TYPE) IS

3:
4: PROCEDURE Create_Net_Batch(
5: errbuf OUT NOCOPY VARCHAR2,
6: retcode OUT NOCOPY VARCHAR2,
7: p_batch_id IN fun_net_batches_all.batch_id%TYPE) IS
8:
9: l_return_status VARCHAR2(1);
10: l_msg_count NUMBER;
11: l_msg_data VARCHAR2(2000);

Line 39: p_batch_id IN fun_net_batches_all.batch_id%TYPE) IS

35:
36: PROCEDURE Submit_Net_Batch(
37: errbuf OUT NOCOPY VARCHAR2,
38: retcode OUT NOCOPY VARCHAR2,
39: p_batch_id IN fun_net_batches_all.batch_id%TYPE) IS
40:
41: l_return_status VARCHAR2(1);
42: l_msg_count NUMBER;
43: l_msg_data VARCHAR2(2000);

Line 81: p_batch_id IN fun_net_batches_all.batch_id%TYPE) IS

77:
78: PROCEDURE Settle_Net_Batch(
79: errbuf OUT NOCOPY VARCHAR2,
80: retcode OUT NOCOPY VARCHAR2,
81: p_batch_id IN fun_net_batches_all.batch_id%TYPE) IS
82:
83: l_return_status VARCHAR2(1);
84: l_msg_count NUMBER;
85: l_msg_data VARCHAR2(2000);

Line 125: p_batch_id IN fun_net_batches_all.batch_id%TYPE) IS

121:
122: PROCEDURE Reverse_Net_Batch(
123: errbuf OUT NOCOPY VARCHAR2,
124: retcode OUT NOCOPY VARCHAR2,
125: p_batch_id IN fun_net_batches_all.batch_id%TYPE) IS
126:
127: l_return_status VARCHAR2(1);
128: l_msg_count NUMBER;
129: l_msg_data VARCHAR2(2000);

Line 169: p_org_id IN fun_net_batches_all.org_id%TYPE,

165:
166: PROCEDURE Generate_Net_Batch(
167: errbuf OUT NOCOPY VARCHAR2,
168: retcode OUT NOCOPY VARCHAR2,
169: p_org_id IN fun_net_batches_all.org_id%TYPE,
170: p_agreement_id IN fun_net_batches_all.AGREEMENT_ID%TYPE,
171: p_dummy1 IN VARCHAR2,
172: p_batch_name IN fun_net_batches_all.batch_name%TYPE,
173: p_settlement_date IN VARCHAR2,

Line 170: p_agreement_id IN fun_net_batches_all.AGREEMENT_ID%TYPE,

166: PROCEDURE Generate_Net_Batch(
167: errbuf OUT NOCOPY VARCHAR2,
168: retcode OUT NOCOPY VARCHAR2,
169: p_org_id IN fun_net_batches_all.org_id%TYPE,
170: p_agreement_id IN fun_net_batches_all.AGREEMENT_ID%TYPE,
171: p_dummy1 IN VARCHAR2,
172: p_batch_name IN fun_net_batches_all.batch_name%TYPE,
173: p_settlement_date IN VARCHAR2,
174: p_response_date IN VARCHAR2,

Line 172: p_batch_name IN fun_net_batches_all.batch_name%TYPE,

168: retcode OUT NOCOPY VARCHAR2,
169: p_org_id IN fun_net_batches_all.org_id%TYPE,
170: p_agreement_id IN fun_net_batches_all.AGREEMENT_ID%TYPE,
171: p_dummy1 IN VARCHAR2,
172: p_batch_name IN fun_net_batches_all.batch_name%TYPE,
173: p_settlement_date IN VARCHAR2,
174: p_response_date IN VARCHAR2,
175: p_transaction_due_date IN VARCHAR2,
176: p_gl_date IN VARCHAR2,

Line 177: p_exchange_rate_type IN fun_net_batches_all.exchange_rate_type%TYPE,

173: p_settlement_date IN VARCHAR2,
174: p_response_date IN VARCHAR2,
175: p_transaction_due_date IN VARCHAR2,
176: p_gl_date IN VARCHAR2,
177: p_exchange_rate_type IN fun_net_batches_all.exchange_rate_type%TYPE,
178: p_dummy2 IN VARCHAR2,
179: p_exchange_rate IN VARCHAR2,
180: p_review_netting_batch_flag IN fun_net_batches_all.REVIEW_NETTING_BATCH_FLAG%TYPE) IS
181:

Line 180: p_review_netting_batch_flag IN fun_net_batches_all.REVIEW_NETTING_BATCH_FLAG%TYPE) IS

176: p_gl_date IN VARCHAR2,
177: p_exchange_rate_type IN fun_net_batches_all.exchange_rate_type%TYPE,
178: p_dummy2 IN VARCHAR2,
179: p_exchange_rate IN VARCHAR2,
180: p_review_netting_batch_flag IN fun_net_batches_all.REVIEW_NETTING_BATCH_FLAG%TYPE) IS
181:
182: CURSOR c_batch(p_batch_id NUMBER) IS
183: SELECT B.BATCH_NUMBER, B.BATCH_NAME, A.AGREEMENT_NAME, B.BATCH_CURRENCY, B.BATCH_STATUS_CODE
184: FROM FUN_NET_BATCHES_ALL B, FUN_NET_AGREEMENTS_ALL A

Line 184: FROM FUN_NET_BATCHES_ALL B, FUN_NET_AGREEMENTS_ALL A

180: p_review_netting_batch_flag IN fun_net_batches_all.REVIEW_NETTING_BATCH_FLAG%TYPE) IS
181:
182: CURSOR c_batch(p_batch_id NUMBER) IS
183: SELECT B.BATCH_NUMBER, B.BATCH_NAME, A.AGREEMENT_NAME, B.BATCH_CURRENCY, B.BATCH_STATUS_CODE
184: FROM FUN_NET_BATCHES_ALL B, FUN_NET_AGREEMENTS_ALL A
185: WHERE B.AGREEMENT_ID = A.AGREEMENT_ID
186: AND B.BATCH_NAME = nvl(p_batch_name, p_batch_id||'')
187: AND B.BATCH_ID >= p_batch_id;
188:

Line 198: l_batch_currency fun_net_batches_all.batch_currency%TYPE;

194: l_allow_disc_flag fun_net_agreements_all.ALLOW_DISC_FLAG%TYPE;
195: l_transaction_due_date VARCHAR2(30);
196: l_agreement_name fun_net_agreements_all.agreement_name%TYPE;
197: l_org_name hr_operating_units.name%TYPE;
198: l_batch_currency fun_net_batches_all.batch_currency%TYPE;
199: l_batch_name fun_net_batches_all.batch_name%TYPE;
200: l_batch_status fun_net_batches_all.batch_status_code%TYPE;
201:
202: BEGIN

Line 199: l_batch_name fun_net_batches_all.batch_name%TYPE;

195: l_transaction_due_date VARCHAR2(30);
196: l_agreement_name fun_net_agreements_all.agreement_name%TYPE;
197: l_org_name hr_operating_units.name%TYPE;
198: l_batch_currency fun_net_batches_all.batch_currency%TYPE;
199: l_batch_name fun_net_batches_all.batch_name%TYPE;
200: l_batch_status fun_net_batches_all.batch_status_code%TYPE;
201:
202: BEGIN
203: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch','Begin');

Line 200: l_batch_status fun_net_batches_all.batch_status_code%TYPE;

196: l_agreement_name fun_net_agreements_all.agreement_name%TYPE;
197: l_org_name hr_operating_units.name%TYPE;
198: l_batch_currency fun_net_batches_all.batch_currency%TYPE;
199: l_batch_name fun_net_batches_all.batch_name%TYPE;
200: l_batch_status fun_net_batches_all.batch_status_code%TYPE;
201:
202: BEGIN
203: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch','Begin');
204:

Line 270: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'INSERT INTO FUN_NET_BATCHES_ALL');

266:
267: l_transaction_due_date := to_char(fnd_date.canonical_to_date(p_settlement_date));
268: END IF;
269:
270: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'INSERT INTO FUN_NET_BATCHES_ALL');
271:
272: INSERT INTO FUN_NET_BATCHES_ALL
273: (batch_id,
274: object_version_number,

Line 272: INSERT INTO FUN_NET_BATCHES_ALL

268: END IF;
269:
270: fun_net_util.log_string(1,'fun_net_conc_prog_pkg.Generate_Netting_Batch', 'INSERT INTO FUN_NET_BATCHES_ALL');
271:
272: INSERT INTO FUN_NET_BATCHES_ALL
273: (batch_id,
274: object_version_number,
275: agreement_id,
276: batch_name,