APPS.FUN_NET_ARAP_PKG dependencies on GL_PERIOD_STATUSES

Line 2527: x_closing_status gl_period_statuses.closing_status%TYPE;

2523: x_return_msg OUT NOCOPY VARCHAR2)
2524:
2525: IS
2526: l_ledger_id gl_ledgers.ledger_id%TYPE;
2527: x_closing_status gl_period_statuses.closing_status%TYPE;
2528: x_period_year gl_period_statuses.period_year%TYPE;
2529: x_period_num gl_period_statuses.period_num%TYPE;
2530: x_period_type gl_period_statuses.period_type%TYPE;
2531: l_path varchar2(200);

Line 2528: x_period_year gl_period_statuses.period_year%TYPE;

2524:
2525: IS
2526: l_ledger_id gl_ledgers.ledger_id%TYPE;
2527: x_closing_status gl_period_statuses.closing_status%TYPE;
2528: x_period_year gl_period_statuses.period_year%TYPE;
2529: x_period_num gl_period_statuses.period_num%TYPE;
2530: x_period_type gl_period_statuses.period_type%TYPE;
2531: l_path varchar2(200);
2532:

Line 2529: x_period_num gl_period_statuses.period_num%TYPE;

2525: IS
2526: l_ledger_id gl_ledgers.ledger_id%TYPE;
2527: x_closing_status gl_period_statuses.closing_status%TYPE;
2528: x_period_year gl_period_statuses.period_year%TYPE;
2529: x_period_num gl_period_statuses.period_num%TYPE;
2530: x_period_type gl_period_statuses.period_type%TYPE;
2531: l_path varchar2(200);
2532:
2533: BEGIN

Line 2530: x_period_type gl_period_statuses.period_type%TYPE;

2526: l_ledger_id gl_ledgers.ledger_id%TYPE;
2527: x_closing_status gl_period_statuses.closing_status%TYPE;
2528: x_period_year gl_period_statuses.period_year%TYPE;
2529: x_period_num gl_period_statuses.period_num%TYPE;
2530: x_period_type gl_period_statuses.period_type%TYPE;
2531: l_path varchar2(200);
2532:
2533: BEGIN
2534:

Line 2545: GL_PERIOD_STATUSES_PKG.get_period_by_date(

2541: INTO l_ledger_id
2542: FROM hr_operating_units
2543: WHERE organization_id = g_batch_details.org_id;
2544:
2545: GL_PERIOD_STATUSES_PKG.get_period_by_date(
2546: x_appln_id,
2547: l_ledger_id,
2548: nvl(g_batch_details.gl_date,g_batch_details.settlement_date),
2549: x_period_name,

Line 3968: l_period_name gl_period_statuses.period_name%TYPE;

3964: batch_status_flag BOOLEAN;
3965: l_msg_data VARCHAR2(1000);
3966: l_msg_count NUMBER;
3967: -- txnCur txnCurType;
3968: l_period_name gl_period_statuses.period_name%TYPE;
3969: txnTable txnTblType;
3970: l_path VARCHAR2(100);
3971: VALIDATE_AR_TXN_FAIL EXCEPTION;
3972: l_request_id NUMBER;