APPS.FUN_NET_ARAP_PKG dependencies on GL_PERIOD_STATUSES

Line 3217: x_closing_status gl_period_statuses.closing_status%TYPE;

3213: x_return_status OUT NOCOPY VARCHAR2,
3214: x_return_msg OUT NOCOPY VARCHAR2)
3215: IS
3216: l_ledger_id gl_ledgers.ledger_id%TYPE;
3217: x_closing_status gl_period_statuses.closing_status%TYPE;
3218: x_period_year gl_period_statuses.period_year%TYPE;
3219: x_period_num gl_period_statuses.period_num%TYPE;
3220: x_period_type gl_period_statuses.period_type%TYPE;
3221: l_path varchar2(200);

Line 3218: x_period_year gl_period_statuses.period_year%TYPE;

3214: x_return_msg OUT NOCOPY VARCHAR2)
3215: IS
3216: l_ledger_id gl_ledgers.ledger_id%TYPE;
3217: x_closing_status gl_period_statuses.closing_status%TYPE;
3218: x_period_year gl_period_statuses.period_year%TYPE;
3219: x_period_num gl_period_statuses.period_num%TYPE;
3220: x_period_type gl_period_statuses.period_type%TYPE;
3221: l_path varchar2(200);
3222: BEGIN

Line 3219: x_period_num gl_period_statuses.period_num%TYPE;

3215: IS
3216: l_ledger_id gl_ledgers.ledger_id%TYPE;
3217: x_closing_status gl_period_statuses.closing_status%TYPE;
3218: x_period_year gl_period_statuses.period_year%TYPE;
3219: x_period_num gl_period_statuses.period_num%TYPE;
3220: x_period_type gl_period_statuses.period_type%TYPE;
3221: l_path varchar2(200);
3222: BEGIN
3223: l_path := g_path||'validate_settlement_period';

Line 3220: x_period_type gl_period_statuses.period_type%TYPE;

3216: l_ledger_id gl_ledgers.ledger_id%TYPE;
3217: x_closing_status gl_period_statuses.closing_status%TYPE;
3218: x_period_year gl_period_statuses.period_year%TYPE;
3219: x_period_num gl_period_statuses.period_num%TYPE;
3220: x_period_type gl_period_statuses.period_type%TYPE;
3221: l_path varchar2(200);
3222: BEGIN
3223: l_path := g_path||'validate_settlement_period';
3224: /* Check if GL Period is open*/

Line 3230: GL_PERIOD_STATUSES_PKG.get_period_by_date(

3226: SELECT set_of_books_id
3227: INTO l_ledger_id
3228: FROM hr_operating_units
3229: WHERE organization_id = g_batch_details.org_id;
3230: GL_PERIOD_STATUSES_PKG.get_period_by_date(
3231: x_appln_id,
3232: l_ledger_id,
3233: nvl(g_batch_details.gl_date,g_batch_details.settlement_date),
3234: x_period_name,

Line 4624: l_period_name gl_period_statuses.period_name%TYPE;

4620: batch_status_flag BOOLEAN;
4621: l_msg_data VARCHAR2(1000);
4622: l_msg_count NUMBER;
4623: -- txnCur txnCurType;
4624: l_period_name gl_period_statuses.period_name%TYPE;
4625: txnTable txnTblType;
4626: l_path VARCHAR2(100);
4627: VALIDATE_AR_TXN_FAIL EXCEPTION;
4628: l_request_id NUMBER;