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: x_period_name OUT NOCOPY VARCHAR2,
333: x_return_status OUT NOCOPY VARCHAR2,
334: x_return_msg OUT NOCOPY VARCHAR2)
335:

Line 342: FROM fun_net_batches_all

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

Line 351: l_org_id fun_net_batches_all.org_id%TYPE;

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

Line 352: l_gl_date fun_net_batches_all.gl_date%TYPE;

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

Line 353: l_settlement_date fun_net_batches_all.settlement_date%TYPE;

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