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 GL_PERIOD_STATUSES

Line 347: x_closing_status gl_period_statuses.closing_status%TYPE;

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;
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;

Line 348: x_period_year gl_period_statuses.period_year%TYPE;

344:
345: l_ledger_id gl_ledgers.ledger_id%TYPE;
346: l_ledger_name gl_ledgers.name%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;

Line 349: x_period_num gl_period_statuses.period_num%TYPE;

345: l_ledger_id gl_ledgers.ledger_id%TYPE;
346: l_ledger_name gl_ledgers.name%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;

Line 350: x_period_type gl_period_statuses.period_type%TYPE;

346: l_ledger_name gl_ledgers.name%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:

Line 377: GL_PERIOD_STATUSES_PKG.get_period_by_date(

373: FROM hr_operating_units
374: WHERE organization_id = g_batch_details.org_id; */
375: fun_net_util.Log_String(g_state_level,l_path,'Ledger_id :'||l_ledger_id);
376:
377: GL_PERIOD_STATUSES_PKG.get_period_by_date(
378: x_appln_id,
379: l_ledger_id,
380: nvl(l_gl_date,l_settlement_date),
381: x_period_name,

Line 412: l_period_name gl_period_statuses.period_name%TYPE;

408: AND check_id is not null;
409:
410: l_return_status VARCHAR2(1);
411: l_return_msg VARCHAR2(1000);
412: l_period_name gl_period_statuses.period_name%TYPE;
413: l_num_cancelled NUMBER;
414: l_num_not_cancelled NUMBER;
415: l_msg_count NUMBER;
416: l_msg_data VARCHAR2(1000);

Line 483: l_period_name GL_PERIOD_STATUSES.period_name%TYPE;

479: PROCEDURE reverse_ar_receipts(
480: p_batch_id IN fun_net_batches.batch_id%TYPE,
481: x_return_status OUT NOCOPY VARCHAR2)
482: IS
483: l_period_name GL_PERIOD_STATUSES.period_name%TYPE;
484:
485: CURSOR ar_txn_cur(p_batch_id IN NUMBER) IS
486: SELECT DISTINCT txn.cash_receipt_id,
487: cr.receipt_number,