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_CANCEL_PKG dependencies on FUN_NET_BATCHES_ALL

Line 25: p_batch_id IN fun_net_batches_all.batch_id%TYPE,

21:
22: /* Selects the Batch Status of the given Batch ids */
23:
24: PROCEDURE get_batch_status(
25: p_batch_id IN fun_net_batches_all.batch_id%TYPE,
26: x_return_status OUT NOCOPY VARCHAR2)
27: IS
28: BEGIN
29: x_return_status := FND_API.G_TRUE;

Line 331: p_batch_id IN fun_net_batches_all.batch_id%TYPE,

327: END cancel_net_batch;
328:
329: PROCEDURE Validate_Settlement_Period(
330: x_appln_id IN fnd_application.application_id%TYPE,
331: p_batch_id IN fun_net_batches_all.batch_id%TYPE,
332: p_reversal_date IN DATE, -- Bug # 9196412
333: x_period_name OUT NOCOPY VARCHAR2,
334: x_return_status OUT NOCOPY VARCHAR2,
335: x_return_msg OUT NOCOPY VARCHAR2)

Line 343: FROM fun_net_batches_all

339: CURSOR c_get_batch_details IS
340: SELECT org_id,
341: gl_date,
342: settlement_date
343: FROM fun_net_batches_all
344: WHERE batch_id = p_batch_id;
345:
346: l_ledger_id gl_ledgers.ledger_id%TYPE;
347: l_ledger_name gl_ledgers.name%TYPE;

Line 352: l_org_id fun_net_batches_all.org_id%TYPE;

348: x_closing_status gl_period_statuses.closing_status%TYPE;
349: x_period_year gl_period_statuses.period_year%TYPE;
350: x_period_num gl_period_statuses.period_num%TYPE;
351: x_period_type gl_period_statuses.period_type%TYPE;
352: l_org_id fun_net_batches_all.org_id%TYPE;
353: l_gl_date fun_net_batches_all.gl_date%TYPE;
354: l_settlement_date fun_net_batches_all.settlement_date%TYPE;
355:
356: l_path VARCHAR2(100);

Line 353: l_gl_date fun_net_batches_all.gl_date%TYPE;

349: x_period_year gl_period_statuses.period_year%TYPE;
350: x_period_num gl_period_statuses.period_num%TYPE;
351: x_period_type gl_period_statuses.period_type%TYPE;
352: l_org_id fun_net_batches_all.org_id%TYPE;
353: l_gl_date fun_net_batches_all.gl_date%TYPE;
354: l_settlement_date fun_net_batches_all.settlement_date%TYPE;
355:
356: l_path VARCHAR2(100);
357: BEGIN

Line 354: l_settlement_date fun_net_batches_all.settlement_date%TYPE;

350: x_period_num gl_period_statuses.period_num%TYPE;
351: x_period_type gl_period_statuses.period_type%TYPE;
352: l_org_id fun_net_batches_all.org_id%TYPE;
353: l_gl_date fun_net_batches_all.gl_date%TYPE;
354: l_settlement_date fun_net_batches_all.settlement_date%TYPE;
355:
356: l_path VARCHAR2(100);
357: BEGIN
358: l_path := g_path || 'Validate_Settlement_period';

Line 415: FROM fun_net_batches_all

411:
412: CURSOR c_get_batch_details IS -- Bug # 8904763
413: SELECT gl_date,
414: settlement_date
415: FROM fun_net_batches_all
416: WHERE batch_id = p_batch_id;
417:
418: l_return_status VARCHAR2(1);
419: l_return_msg VARCHAR2(1000);

Line 426: l_gl_date fun_net_batches_all.gl_date%TYPE; -- Bug # 8904763

422: l_num_not_cancelled NUMBER;
423: l_msg_count NUMBER;
424: l_msg_data VARCHAR2(1000);
425: l_path VARCHAR2(100);
426: l_gl_date fun_net_batches_all.gl_date%TYPE; -- Bug # 8904763
427: l_settlement_date fun_net_batches_all.settlement_date%TYPE; -- Bug # 8904763
428: l_reversal_date DATE; -- Bug # 8904763
429:
430: BEGIN

Line 427: l_settlement_date fun_net_batches_all.settlement_date%TYPE; -- Bug # 8904763

423: l_msg_count NUMBER;
424: l_msg_data VARCHAR2(1000);
425: l_path VARCHAR2(100);
426: l_gl_date fun_net_batches_all.gl_date%TYPE; -- Bug # 8904763
427: l_settlement_date fun_net_batches_all.settlement_date%TYPE; -- Bug # 8904763
428: l_reversal_date DATE; -- Bug # 8904763
429:
430: BEGIN
431: l_path := g_path || 'reverse_ap_checks';