APPS.FV_PURGED_TREASURY_SYMBOLS dependencies on GL_LEDGERS_PUBLIC_V

Line 22: gbl_set_of_books_id Gl_ledgers_public_v.ledger_id%TYPE;

18: gbl_error_buf Varchar2(200);
19: gbl_account_id gl_code_combinations.chart_of_accounts_id%type;
20: gbl_bal_segment_name varchar2(30);
21: gbl_acc_segment_name varchar2(30);
22: gbl_set_of_books_id Gl_ledgers_public_v.ledger_id%TYPE;
23: gbl_last_upd_date DATE;
24: gbl_last_update_by number(15);
25: gbl_last_update_log number(15);
26: gbl_creation_date date;

Line 37: gbl_period_set_name Gl_Ledgers_public_v.period_set_name%type;

33: gbl_new_established_year number;
34: gbl_request_id Number;
35: gbl_prelim_req_id Number;
36: gbl_period_year gl_periods.period_year%type;
37: gbl_period_set_name Gl_Ledgers_public_v.period_set_name%type;
38: g_module_name VARCHAR2(100) := 'fv.plsql.fv_purged_treasury_symbols.';
39: gbl_cursor_cnt NUMBER := 0;
40: gbl_acct_segment_num NUMBER;
41: gbl_flex_value_set_id NUMBER;

Line 107: p_sob Gl_Ledgers_public_v.ledger_id%TYPE DEFAULT NULL,

103: x_run_mode IN VARCHAR2,
104: v_treasury_symbol IN VARCHAR2 DEFAULT NULL,
105: v_time_frame IN VARCHAR2 DEFAULT NULL ,
106: n_year_established IN NUMBER DEFAULT NULL ,
107: p_sob Gl_Ledgers_public_v.ledger_id%TYPE DEFAULT NULL,
108: d_cancellation_date IN VARCHAR2 DEFAULT NULL ,
109: new_established_year IN NUMBER,
110: p_dummy IN NUMBER,
111: prelim_req_id IN NUMBER DEFAULT NULL) IS

Line 112: v_accounts_id gl_ledgers_public_v.chart_of_accounts_id%type;

108: d_cancellation_date IN VARCHAR2 DEFAULT NULL ,
109: new_established_year IN NUMBER,
110: p_dummy IN NUMBER,
111: prelim_req_id IN NUMBER DEFAULT NULL) IS
112: v_accounts_id gl_ledgers_public_v.chart_of_accounts_id%type;
113: v_application_name fnd_segment_attribute_values.application_column_name%type;
114: n_balance NUMBER;
115: n_cnt NUMBER;
116: l_segment_status BOOLEAN;

Line 148: FROM gl_ledgers_public_v GL

144: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' Inside Main');
145:
146: SELECT chart_of_accounts_id, period_set_name
147: INTO gbl_account_id , gbl_period_set_name
148: FROM gl_ledgers_public_v GL
149: WHERE gl.ledger_id = gbl_set_of_books_id ;
150:
151: /*--------------------------------------------------+
152: To get segment Name