[Home] [Help]
36: g_acct_segment_name VARCHAR2(25);
37: g_reimb_agree_seg_name VARCHAR2(25);
38: g_acc_value_set_id NUMBER;
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;
533: l_prg_val FV_FACTS_PRC_DTL.PROGRAM_VALUE%TYPE;
534: Begin
535:
536: Select_Stmt := 'SELECT ' || p_Segment_Name ||
537: ' from gl_code_combinations
538: where code_combination_id=' || p_Ccid;
539: log(l_module, 'Select_Stmt:'||Select_Stmt);
540:
541: EXECUTE IMMEDIATE Select_Stmt INTO l_prg_val;
1391: FROM fv_pya_fiscalyear_segment
1392: Where Set_Of_Books_Id = g_set_of_books_id;
1393:
1394: Select_Stmt := 'SELECT ' || l_cohort_seg_name ||'
1395: from gl_code_combinations
1396: where code_combination_id=' || g_ccid;
1397: Vl_Cursor := Dbms_Sql.Open_Cursor ;
1398: Dbms_Sql.Parse(vl_cursor,Select_Stmt, Dbms_Sql.V7);
1399: Dbms_Sql.Define_Column(vl_cursor,1,'VARCHAR2',150);
1777: l_tr_dept_id_col || l_tr_main_acct_col ||
1778: ' FROM gl_je_lines gjl,
1779: gl_je_headers gjh,
1780: gl_je_batches gjb,
1781: gl_code_combinations gcc,
1782: fv_fund_parameters ffp,
1783: fv_treasury_symbols fts
1784: WHERE gjl.ledger_id = :sob_id
1785: AND gjl.status = :status
1857: l_tr_dept_id_col || l_tr_main_acct_col ||
1858: ' FROM gl_je_lines gjl,
1859: gl_je_headers gjh,
1860: gl_je_batches gjb,
1861: gl_code_combinations gcc,
1862: fv_fund_parameters ffp,
1863: fv_treasury_symbols fts,
1864: xla_ae_lines xal,
1865: xla_ae_headers xah,
4430: l_fund_select := 'SELECT ''X'', fts.fund_group_code,
4431: fts.department_id, ' ||
4432: 'fts.bureau_id, ' ||
4433: 'glc.' || g_bal_segment_name || ' ' ||
4434: 'FROM gl_code_combinations glc,
4435: fv_fund_parameters ffp, ' ||
4436: 'fv_treasury_symbols fts ' ||
4437: 'WHERE glc.code_combination_id = :ccid
4438: AND glc.chart_of_accounts_id = :coa_id
4473: --l_bal_fetch Integer;
4474: l_exec_ret Integer;
4475: BEGIN
4476: l_bal_select := 'SELECT glc.' || g_bal_segment_name || ' '
4477: ||'FROM gl_code_combinations glc '
4478: ||'WHERE glc.code_combination_id = ' || to_char(p_ccid);
4479: BEGIN
4480: EXECUTE IMMEDIATE l_bal_select INTO p_bal_segment;
4481: EXCEPTION
5924:
5925: l_acct_select := 'SELECT SUBSTR(ffv.compiled_value_attributes,5,1)
5926: FROM xla_ae_headers xh,
5927: xla_ae_lines xl,
5928: gl_code_combinations gcc,
5929: fnd_flex_values ffv
5930: WHERE xh.event_id = '||sla_event.event_id||
5931: ' AND xh.ae_header_id = xl.ae_header_id
5932: AND gcc.code_combination_id = xl.code_combination_id