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_reimb_agree_seg_name VARCHAR2(25);

Line 28: g_start_date Gl_Period_Statuses.start_date%TYPE;

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

Line 29: g_end_date Gl_Period_Statuses.end_date%TYPE;

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

Line 551: FROM gl_period_statuses

547:
548: BEGIN -- From Period Start Date
549: SELECT start_date
550: INTO g_start_date
551: FROM gl_period_statuses
552: WHERE ledger_id = g_set_of_books_id
553: AND application_id = 101
554: AND period_year = g_period_year
555: AND period_name = p_period_from;

Line 580: FROM gl_period_statuses

576: END IF;
577: BEGIN -- To Period End Date
578: SELECT end_date
579: INTO g_end_date
580: FROM gl_period_statuses
581: WHERE ledger_id = g_set_of_books_id
582: AND application_id = 101
583: AND period_year = g_period_year
584: AND period_name = p_period_to;

Line 631: FROM gl_period_statuses

627: -- Select Period Information for Beginning Period
628: BEGIN
629: SELECT MIN(period_num)
630: INTO g_period_num_low
631: FROM gl_period_statuses
632: WHERE period_name = g_from_period_name
633: AND application_id = 101
634: AND ledger_id = g_set_of_books_id
635: AND period_year = g_period_year;

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

644: WHEN OTHERS THEN
645: g_error_code := SQLCODE ;
646: g_error_buf := SQLERRM ||
647: 'PROCESS PERIOD INFO - Error when getting '||
648: 'min(period_num) from gl_period_statuses '||
649: 'for From Period Name '|| g_from_period_name;
650: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,g_error_buf);
651: RETURN;
652: END;

Line 657: FROM gl_period_statuses

653:
654: BEGIN
655: SELECT max(period_num)
656: INTO g_period_num_high
657: FROM gl_period_statuses
658: WHERE period_name = g_to_period_name
659: AND application_id = 101
660: AND ledger_id = g_set_of_books_id
661: AND period_year = g_period_year;

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

670: WHEN OTHERS THEN
671: g_error_code := SQLCODE ;
672: g_error_buf := SQLERRM ||
673: 'PROCESS PERIOD INFO - Error when getting '||
674: 'max(period_num) from gl_period_statuses for '||
675: 'To Period Name '|| g_to_period_name;
676: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_UNEXPECTED, l_module_name,g_error_buf);
677: RETURN;
678: END;

Line 1139: FROM gl_period_statuses

1135: AND gjh.posted_date BETWEEN :from_posted_date AND :to_posted_date
1136: AND gjl.status = :status
1137: AND gjl.period_name IN
1138: (SELECT period_name
1139: FROM gl_period_statuses
1140: WHERE application_id = 101
1141: AND ledger_id = :sob_id
1142: AND period_num BETWEEN :period_num_low
1143: AND :period_num_high

Line 1219: FROM gl_period_statuses

1215: AND gjh.posted_date BETWEEN :from_posted_date AND :to_posted_date
1216: AND gjl.status = :status
1217: AND gjl.period_name IN
1218: (SELECT period_name
1219: FROM gl_period_statuses
1220: WHERE application_id = 101
1221: AND ledger_id = :sob_id
1222: AND period_num BETWEEN :period_num_low
1223: AND :period_num_high