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.FV_FACTS_TRX_REGISTER dependencies on GL_PERIOD_STATUSES

Line 16: g_from_period_name Gl_Period_Statuses.period_name%TYPE;

12: g_treasury_symbol_id Fv_Treasury_Symbols.treasury_symbol_id%TYPE;
13: g_period_year Gl_Balances.period_year%TYPE;
14: g_period_num_low Gl_Balances.period_num%TYPE;
15: g_period_num_high Gl_Balances.period_num%TYPE;
16: g_from_period_name Gl_Period_Statuses.period_name%TYPE;
17: g_to_period_name Gl_Period_Statuses.period_name%TYPE;
18: g_cohort_seg_name FV_FACTS_FEDERAL_ACCOUNTS.cohort_segment_name%TYPE;
19: g_bal_segment_name VARCHAR2(25);
20: g_acct_segment_name VARCHAR2(25);

Line 17: g_to_period_name Gl_Period_Statuses.period_name%TYPE;

13: g_period_year Gl_Balances.period_year%TYPE;
14: g_period_num_low Gl_Balances.period_num%TYPE;
15: g_period_num_high Gl_Balances.period_num%TYPE;
16: g_from_period_name Gl_Period_Statuses.period_name%TYPE;
17: g_to_period_name Gl_Period_Statuses.period_name%TYPE;
18: g_cohort_seg_name FV_FACTS_FEDERAL_ACCOUNTS.cohort_segment_name%TYPE;
19: g_bal_segment_name VARCHAR2(25);
20: g_acct_segment_name VARCHAR2(25);
21: g_acc_value_set_id NUMBER;

Line 27: g_start_date Gl_Period_Statuses.start_date%TYPE;

23: g_coa_id Gl_Code_Combinations.chart_of_accounts_id%TYPE;
24: g_apps_id Fnd_Id_Flex_Structures.application_id%TYPE;
25: g_id_flex_code Fnd_Id_Flex_Structures.id_flex_code%TYPE;
26: g_currency_code Gl_Sets_Of_Books.currency_code%TYPE;
27: g_start_date Gl_Period_Statuses.start_date%TYPE;
28: g_end_date Gl_Period_Statuses.end_date%TYPE;
29: g_source VARCHAR2(25);
30: g_category VARCHAR2(25);
31: g_attributes_found VARCHAR2(1);

Line 28: g_end_date Gl_Period_Statuses.end_date%TYPE;

24: g_apps_id Fnd_Id_Flex_Structures.application_id%TYPE;
25: g_id_flex_code Fnd_Id_Flex_Structures.id_flex_code%TYPE;
26: g_currency_code Gl_Sets_Of_Books.currency_code%TYPE;
27: g_start_date Gl_Period_Statuses.start_date%TYPE;
28: g_end_date Gl_Period_Statuses.end_date%TYPE;
29: g_source VARCHAR2(25);
30: g_category VARCHAR2(25);
31: g_attributes_found VARCHAR2(1);
32: g_req_date_seg VARCHAR2(15) := NULL;

Line 519: FROM gl_period_statuses

515:
516: BEGIN -- From Period Start Date
517: SELECT start_date
518: INTO g_start_date
519: FROM gl_period_statuses
520: WHERE ledger_id = g_set_of_books_id
521: AND application_id = 101
522: AND period_year = g_period_year
523: AND period_name = p_period_from;

Line 548: FROM gl_period_statuses

544: END IF;
545: BEGIN -- To Period End Date
546: SELECT end_date
547: INTO g_end_date
548: FROM gl_period_statuses
549: WHERE ledger_id = g_set_of_books_id
550: AND application_id = 101
551: AND period_year = g_period_year
552: AND period_name = p_period_to;

Line 599: FROM gl_period_statuses

595: -- Select Period Information for Beginning Period
596: BEGIN
597: SELECT MIN(period_num)
598: INTO g_period_num_low
599: FROM gl_period_statuses
600: WHERE period_name = g_from_period_name
601: AND application_id = 101
602: AND ledger_id = g_set_of_books_id
603: AND period_year = g_period_year;

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

612: WHEN OTHERS THEN
613: g_error_code := SQLCODE ;
614: g_error_buf := SQLERRM ||
615: 'PROCESS PERIOD INFO - Error when getting '||
616: 'min(period_num) from gl_period_statuses '||
617: 'for From Period Name '|| g_from_period_name;
618: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,g_error_buf);
619: RETURN;
620: END;

Line 625: FROM gl_period_statuses

621:
622: BEGIN
623: SELECT max(period_num)
624: INTO g_period_num_high
625: FROM gl_period_statuses
626: WHERE period_name = g_to_period_name
627: AND application_id = 101
628: AND ledger_id = g_set_of_books_id
629: AND period_year = g_period_year;

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

638: WHEN OTHERS THEN
639: g_error_code := SQLCODE ;
640: g_error_buf := SQLERRM ||
641: 'PROCESS PERIOD INFO - Error when getting '||
642: 'max(period_num) from gl_period_statuses for '||
643: 'To Period Name '|| g_to_period_name;
644: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,g_error_buf);
645: RETURN;
646: END;

Line 1096: FROM gl_period_statuses

1092: AND gjh.posted_date BETWEEN :from_posted_date AND :to_posted_date
1093: AND gjl.status = :status
1094: AND gjl.period_name IN
1095: (SELECT period_name
1096: FROM gl_period_statuses
1097: WHERE application_id = 101
1098: AND ledger_id = :sob_id
1099: AND period_num BETWEEN :period_num_low
1100: AND :period_num_high

Line 1175: FROM gl_period_statuses

1171: AND gjh.posted_date BETWEEN :from_posted_date AND :to_posted_date
1172: AND gjl.status = :status
1173: AND gjl.period_name IN
1174: (SELECT period_name
1175: FROM gl_period_statuses
1176: WHERE application_id = 101
1177: AND ledger_id = :sob_id
1178: AND period_num BETWEEN :period_num_low
1179: AND :period_num_high