APPS.FV_GTAS_TRX_REGISTER dependencies on GL_PERIOD_STATUSES

Line 32: g_from_period_name Gl_Period_Statuses.period_name%TYPE;

28: g_treasury_symbol_id Fv_Treasury_Symbols.treasury_symbol_id%TYPE;
29: g_period_year Gl_Balances.period_year%TYPE;
30: g_period_num_low Gl_Balances.period_num%TYPE;
31: g_period_num_high Gl_Balances.period_num%TYPE;
32: g_from_period_name Gl_Period_Statuses.period_name%TYPE;
33: g_to_period_name Gl_Period_Statuses.period_name%TYPE;
34: g_cohort_seg_name FV_FACTS_FEDERAL_ACCOUNTS.cohort_segment_name%TYPE;
35: g_bal_segment_name VARCHAR2(25);
36: g_acct_segment_name VARCHAR2(25);

Line 33: g_to_period_name Gl_Period_Statuses.period_name%TYPE;

29: g_period_year Gl_Balances.period_year%TYPE;
30: g_period_num_low Gl_Balances.period_num%TYPE;
31: g_period_num_high Gl_Balances.period_num%TYPE;
32: g_from_period_name Gl_Period_Statuses.period_name%TYPE;
33: g_to_period_name Gl_Period_Statuses.period_name%TYPE;
34: g_cohort_seg_name FV_FACTS_FEDERAL_ACCOUNTS.cohort_segment_name%TYPE;
35: g_bal_segment_name VARCHAR2(25);
36: g_acct_segment_name VARCHAR2(25);
37: g_reimb_agree_seg_name VARCHAR2(25);

Line 43: g_start_date Gl_Period_Statuses.start_date%TYPE;

39: g_adjustment_flag VARCHAR2(1);
40: g_coa_id Gl_Code_Combinations.chart_of_accounts_id%TYPE;
41: g_apps_id Fnd_Id_Flex_Structures.application_id%TYPE;
42: g_id_flex_code Fnd_Id_Flex_Structures.id_flex_code%TYPE;
43: g_start_date Gl_Period_Statuses.start_date%TYPE;
44: g_end_date Gl_Period_Statuses.end_date%TYPE;
45: g_source VARCHAR2(25);
46: g_category VARCHAR2(25);
47: g_attributes_found VARCHAR2(1);

Line 44: g_end_date Gl_Period_Statuses.end_date%TYPE;

40: g_coa_id Gl_Code_Combinations.chart_of_accounts_id%TYPE;
41: g_apps_id Fnd_Id_Flex_Structures.application_id%TYPE;
42: g_id_flex_code Fnd_Id_Flex_Structures.id_flex_code%TYPE;
43: g_start_date Gl_Period_Statuses.start_date%TYPE;
44: g_end_date Gl_Period_Statuses.end_date%TYPE;
45: g_source VARCHAR2(25);
46: g_category VARCHAR2(25);
47: g_attributes_found VARCHAR2(1);
48: g_req_date_seg VARCHAR2(15) := NULL;

Line 899: FROM gl_period_statuses

895:
896: BEGIN -- From Period Start Date
897: SELECT start_date
898: INTO g_start_date
899: FROM gl_period_statuses
900: WHERE ledger_id = g_set_of_books_id
901: AND application_id = 101
902: AND period_year = g_period_year
903: AND period_name = p_period_from;

Line 927: FROM gl_period_statuses

923:
924: BEGIN -- To Period End Date
925: SELECT end_date
926: INTO g_end_date
927: FROM gl_period_statuses
928: WHERE ledger_id = g_set_of_books_id
929: AND application_id = 101
930: AND period_year = g_period_year
931: AND period_name = p_period_to;

Line 979: FROM gl_period_statuses

975: -- Select Period Information for Beginning Period
976: BEGIN
977: SELECT MIN(period_num)
978: INTO g_period_num_low
979: FROM gl_period_statuses
980: WHERE period_name = g_from_period_name
981: AND application_id = 101
982: AND ledger_id = g_set_of_books_id
983: AND period_year = g_period_year;

Line 996: 'min(period_num) from gl_period_statuses '||

992: WHEN OTHERS THEN
993: g_error_code := SQLCODE ;
994: g_error_buf := SQLERRM ||
995: 'PROCESS PERIOD INFO - Error when getting '||
996: 'min(period_num) from gl_period_statuses '||
997: 'for From Period Name '|| g_from_period_name;
998: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);
999: RETURN;
1000: END;

Line 1005: FROM gl_period_statuses

1001:
1002: BEGIN
1003: SELECT max(period_num)
1004: INTO g_period_num_high
1005: FROM gl_period_statuses
1006: WHERE period_name = g_to_period_name
1007: AND application_id = 101
1008: AND ledger_id = g_set_of_books_id
1009: AND period_year = g_period_year;

Line 1022: 'max(period_num) from gl_period_statuses for '||

1018: WHEN OTHERS THEN
1019: g_error_code := SQLCODE ;
1020: g_error_buf := SQLERRM ||
1021: 'PROCESS PERIOD INFO - Error when getting '||
1022: 'max(period_num) from gl_period_statuses for '||
1023: 'To Period Name '|| g_to_period_name;
1024: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module,g_error_buf);
1025: RETURN;
1026: END;

Line 1788: FROM gl_period_statuses

1784: WHERE gjl.ledger_id = :sob_id
1785: AND gjl.status = :status
1786: AND gjl.period_name IN
1787: (SELECT period_name
1788: FROM gl_period_statuses
1789: WHERE application_id = 101
1790: AND ledger_id = :sob_id
1791: AND period_num BETWEEN :period_num_low
1792: AND :period_num_high

Line 1872: FROM gl_period_statuses

1868: WHERE gjl.ledger_id = :sob_id
1869: AND gjl.status = :status
1870: AND gjl.period_name IN
1871: (SELECT period_name
1872: FROM gl_period_statuses
1873: WHERE application_id = 101
1874: AND ledger_id = :sob_id
1875: AND period_num BETWEEN :period_num_low
1876: AND :period_num_high