DBA Data[Home] [Help]

APPS.FV_FACTS1_GL_PKG dependencies on GL_LEDGERS_PUBLIC_V

Line 11: gbl_currency_code gl_ledgers_public_v.currency_code%TYPE;

7: gbl_acc_segment VARCHAR2(10);
8: gbl_jrnl_attribute VARCHAR2(15);
9: gbl_vend_attribute VARCHAR2(15);
10: gbl_cust_attribute VARCHAR2(15);
11: gbl_currency_code gl_ledgers_public_v.currency_code%TYPE;
12: gbl_period_name gl_period_statuses.period_name%TYPE;
13: gbl_sob_id gl_ledgers_public_v.ledger_id%TYPE;
14: gbl_coa_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
15: gbl_err_code NUMBER := 0;

Line 13: gbl_sob_id gl_ledgers_public_v.ledger_id%TYPE;

9: gbl_vend_attribute VARCHAR2(15);
10: gbl_cust_attribute VARCHAR2(15);
11: gbl_currency_code gl_ledgers_public_v.currency_code%TYPE;
12: gbl_period_name gl_period_statuses.period_name%TYPE;
13: gbl_sob_id gl_ledgers_public_v.ledger_id%TYPE;
14: gbl_coa_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
15: gbl_err_code NUMBER := 0;
16: gbl_err_buff VARCHAR2(250);
17: gbl_period_num_low gl_period_statuses.period_num%TYPE;

Line 14: gbl_coa_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;

10: gbl_cust_attribute VARCHAR2(15);
11: gbl_currency_code gl_ledgers_public_v.currency_code%TYPE;
12: gbl_period_name gl_period_statuses.period_name%TYPE;
13: gbl_sob_id gl_ledgers_public_v.ledger_id%TYPE;
14: gbl_coa_id gl_ledgers_public_v.chart_of_accounts_id%TYPE;
15: gbl_err_code NUMBER := 0;
16: gbl_err_buff VARCHAR2(250);
17: gbl_period_num_low gl_period_statuses.period_num%TYPE;
18: gbl_period_num_high gl_period_statuses.period_num%TYPE;

Line 386: FROM gl_ledgers_public_v

382:
383: l_temp_mesg := 'getting Currency Code/Chart of Accounts Id.';
384: SELECT currency_code, chart_of_accounts_id
385: INTO gbl_currency_code, gbl_coa_id
386: FROM gl_ledgers_public_v
387: WHERE ledger_id = gbl_sob_id;
388:
389:
390: FV_UTILITY.LOG_MESG('Journal Attribute: '||gbl_jrnl_attribute);