DBA Data[Home] [Help]

APPS.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on GL_PERIODS

Line 13: g_period_name GL_PERIODS.PERIOD_NAME%TYPE;

9: g_chart_of_accounts_id GL_LEDGERS.chart_of_accounts_id%TYPE;
10: g_accounting_type VARCHAR2(30); --represents 'Centralized' or 'Decentralized'
11: g_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;
12: g_establishment_id XLE_ETB_PROFILES.ESTABLISHMENT_ID%TYPE;
13: g_period_name GL_PERIODS.PERIOD_NAME%TYPE;
14: g_start_date GL_PERIODS.START_DATE%TYPE;
15: g_end_date GL_PERIODS.END_DATE%TYPE;
16: g_adj_start_date GL_PERIODS.START_DATE%TYPE;
17: g_adj_end_date GL_PERIODS.END_DATE%TYPE;

Line 14: g_start_date GL_PERIODS.START_DATE%TYPE;

10: g_accounting_type VARCHAR2(30); --represents 'Centralized' or 'Decentralized'
11: g_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;
12: g_establishment_id XLE_ETB_PROFILES.ESTABLISHMENT_ID%TYPE;
13: g_period_name GL_PERIODS.PERIOD_NAME%TYPE;
14: g_start_date GL_PERIODS.START_DATE%TYPE;
15: g_end_date GL_PERIODS.END_DATE%TYPE;
16: g_adj_start_date GL_PERIODS.START_DATE%TYPE;
17: g_adj_end_date GL_PERIODS.END_DATE%TYPE;
18: g_special_situation_indicator VARCHAR2(30);

Line 15: g_end_date GL_PERIODS.END_DATE%TYPE;

11: g_legal_entity_id XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE;
12: g_establishment_id XLE_ETB_PROFILES.ESTABLISHMENT_ID%TYPE;
13: g_period_name GL_PERIODS.PERIOD_NAME%TYPE;
14: g_start_date GL_PERIODS.START_DATE%TYPE;
15: g_end_date GL_PERIODS.END_DATE%TYPE;
16: g_adj_start_date GL_PERIODS.START_DATE%TYPE;
17: g_adj_end_date GL_PERIODS.END_DATE%TYPE;
18: g_special_situation_indicator VARCHAR2(30);
19: g_bookkeeping_type VARCHAR2(3);

Line 16: g_adj_start_date GL_PERIODS.START_DATE%TYPE;

12: g_establishment_id XLE_ETB_PROFILES.ESTABLISHMENT_ID%TYPE;
13: g_period_name GL_PERIODS.PERIOD_NAME%TYPE;
14: g_start_date GL_PERIODS.START_DATE%TYPE;
15: g_end_date GL_PERIODS.END_DATE%TYPE;
16: g_adj_start_date GL_PERIODS.START_DATE%TYPE;
17: g_adj_end_date GL_PERIODS.END_DATE%TYPE;
18: g_special_situation_indicator VARCHAR2(30);
19: g_bookkeeping_type VARCHAR2(3);
20: g_participant_type JL_BR_SPED_PARTIC_CODES.PARTICIPANT_TYPE%TYPE;

Line 17: g_adj_end_date GL_PERIODS.END_DATE%TYPE;

13: g_period_name GL_PERIODS.PERIOD_NAME%TYPE;
14: g_start_date GL_PERIODS.START_DATE%TYPE;
15: g_end_date GL_PERIODS.END_DATE%TYPE;
16: g_adj_start_date GL_PERIODS.START_DATE%TYPE;
17: g_adj_end_date GL_PERIODS.END_DATE%TYPE;
18: g_special_situation_indicator VARCHAR2(30);
19: g_bookkeeping_type VARCHAR2(3);
20: g_participant_type JL_BR_SPED_PARTIC_CODES.PARTICIPANT_TYPE%TYPE;
21: g_accounting_segment_type VARCHAR2(30);

Line 65: g_adjustment_period_name GL_PERIODS.PERIOD_NAME%TYPE;

61: g_account_qualifier_position NUMBER;
62: g_sped_qualifier_position NUMBER;
63: g_exclusion_qualifier_position NUMBER; --variable to capture SPED Exclusion qualifier position. added as part of new enhancement.
64: g_closing_period_flag VARCHAR2(1);
65: g_adjustment_period_name GL_PERIODS.PERIOD_NAME%TYPE;
66: g_adjustment_period_start_date GL_PERIODS.START_DATE%TYPE;
67: g_adjustment_period_end_date GL_PERIODS.END_DATE%TYPE;
68:
69: --Globals for Conc Prg variables

Line 66: g_adjustment_period_start_date GL_PERIODS.START_DATE%TYPE;

62: g_sped_qualifier_position NUMBER;
63: g_exclusion_qualifier_position NUMBER; --variable to capture SPED Exclusion qualifier position. added as part of new enhancement.
64: g_closing_period_flag VARCHAR2(1);
65: g_adjustment_period_name GL_PERIODS.PERIOD_NAME%TYPE;
66: g_adjustment_period_start_date GL_PERIODS.START_DATE%TYPE;
67: g_adjustment_period_end_date GL_PERIODS.END_DATE%TYPE;
68:
69: --Globals for Conc Prg variables
70:

Line 67: g_adjustment_period_end_date GL_PERIODS.END_DATE%TYPE;

63: g_exclusion_qualifier_position NUMBER; --variable to capture SPED Exclusion qualifier position. added as part of new enhancement.
64: g_closing_period_flag VARCHAR2(1);
65: g_adjustment_period_name GL_PERIODS.PERIOD_NAME%TYPE;
66: g_adjustment_period_start_date GL_PERIODS.START_DATE%TYPE;
67: g_adjustment_period_end_date GL_PERIODS.END_DATE%TYPE;
68:
69: --Globals for Conc Prg variables
70:
71: g_concurrent_request_id NUMBER;