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 348: x_closing_status gl_period_statuses.closing_status%TYPE;

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

Line 349: x_period_year gl_period_statuses.period_year%TYPE;

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

Line 350: x_period_num gl_period_statuses.period_num%TYPE;

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

Line 351: x_period_type gl_period_statuses.period_type%TYPE;

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

Line 378: GL_PERIOD_STATUSES_PKG.get_period_by_date(

374: FROM hr_operating_units
375: WHERE organization_id = g_batch_details.org_id; */
376: fun_net_util.Log_String(g_state_level,l_path,'Ledger_id :'||l_ledger_id);
377: -- Bug: 8509936.
378: GL_PERIOD_STATUSES_PKG.get_period_by_date(
379: x_appln_id,
380: l_ledger_id,
381: --nvl(l_gl_date,l_settlement_date),
382: trunc(p_reversal_date), -- Bug # 9196412

Line 420: l_period_name gl_period_statuses.period_name%TYPE;

416: WHERE batch_id = p_batch_id;
417:
418: l_return_status VARCHAR2(1);
419: l_return_msg VARCHAR2(1000);
420: l_period_name gl_period_statuses.period_name%TYPE;
421: l_num_cancelled NUMBER;
422: l_num_not_cancelled NUMBER;
423: l_msg_count NUMBER;
424: l_msg_data VARCHAR2(1000);

Line 511: l_period_name GL_PERIOD_STATUSES.period_name%TYPE;

507: PROCEDURE reverse_ar_receipts(
508: p_batch_id IN fun_net_batches.batch_id%TYPE,
509: x_return_status OUT NOCOPY VARCHAR2)
510: IS
511: l_period_name GL_PERIOD_STATUSES.period_name%TYPE;
512:
513: CURSOR ar_txn_cur(p_batch_id IN NUMBER) IS
514: SELECT DISTINCT txn.cash_receipt_id,
515: cr.receipt_number,