DBA Data[Home] [Help]

APPS.FUN_NET_CONC_PROG_PKG dependencies on FND_DATE

Line 240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Settlement Date : '|| fnd_date.canonical_to_date(p_settlement_date));

236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Generate Netting Batch Date: '||to_char(sysdate,'DD-MON-YYYY HH:MM'));
237: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Operating Unit : '||l_org_name);
239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Agreement Name : '||l_agreement_name);
240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Settlement Date : '|| fnd_date.canonical_to_date(p_settlement_date));
241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Response Date : '|| fnd_date.canonical_to_date(p_response_date));
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Name : '||p_batch_name);
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transaction Due Date : '||p_transaction_due_date);
244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' GL Date : '|| fnd_date.canonical_to_date(p_gl_date));

Line 241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Response Date : '|| fnd_date.canonical_to_date(p_response_date));

237: FND_FILE.NEW_LINE(FND_FILE.OUTPUT,2 );
238: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Operating Unit : '||l_org_name);
239: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Agreement Name : '||l_agreement_name);
240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Settlement Date : '|| fnd_date.canonical_to_date(p_settlement_date));
241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Response Date : '|| fnd_date.canonical_to_date(p_response_date));
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Name : '||p_batch_name);
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transaction Due Date : '||p_transaction_due_date);
244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' GL Date : '|| fnd_date.canonical_to_date(p_gl_date));
245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Exchange Rate Type : '||p_exchange_rate_type);

Line 244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' GL Date : '|| fnd_date.canonical_to_date(p_gl_date));

240: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Settlement Date : '|| fnd_date.canonical_to_date(p_settlement_date));
241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Response Date : '|| fnd_date.canonical_to_date(p_response_date));
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Batch Name : '||p_batch_name);
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Transaction Due Date : '||p_transaction_due_date);
244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' GL Date : '|| fnd_date.canonical_to_date(p_gl_date));
245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Exchange Rate Type : '||p_exchange_rate_type);
246:
247: IF p_exchange_rate_type = 'User' THEN
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ' Exchange Rate : '||p_exchange_rate);

Line 267: l_transaction_due_date := to_char(fnd_date.canonical_to_date(p_settlement_date));

263: l_transaction_due_date := p_transaction_due_date;
264:
265: IF nvl(l_allow_disc_flag, 'N') = 'Y' THEN
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:

Line 322: fnd_date.canonical_to_date(p_settlement_date),

318: l_batch_id,
319: p_review_netting_batch_flag,
320: 'CREATED',
321: l_transaction_due_date,
322: fnd_date.canonical_to_date(p_settlement_date),
323: fnd_date.canonical_to_date(p_response_date),
324: p_exchange_rate_type,
325: p_exchange_rate,
326: fnd_date.canonical_to_date(p_gl_date),

Line 323: fnd_date.canonical_to_date(p_response_date),

319: p_review_netting_batch_flag,
320: 'CREATED',
321: l_transaction_due_date,
322: fnd_date.canonical_to_date(p_settlement_date),
323: fnd_date.canonical_to_date(p_response_date),
324: p_exchange_rate_type,
325: p_exchange_rate,
326: fnd_date.canonical_to_date(p_gl_date),
327: p_org_id,

Line 326: fnd_date.canonical_to_date(p_gl_date),

322: fnd_date.canonical_to_date(p_settlement_date),
323: fnd_date.canonical_to_date(p_response_date),
324: p_exchange_rate_type,
325: p_exchange_rate,
326: fnd_date.canonical_to_date(p_gl_date),
327: p_org_id,
328: sysdate,
329: fnd_global.user_id,
330: sysdate,