[Home] [Help]
1686: 'any balances.');
1687: END IF;
1688:
1689: vl_select := 'SELECT COUNT(*)
1690: FROM Gl_Balances glb,Gl_Code_Combinations gcc
1691: WHERE glb.code_combination_id = gcc.code_combination_id
1692: AND gcc.'||vg_bal_segment||' = :fund_value'||
1693: ' AND gcc.'||vg_acct_segment|| ' = :from_acct'||
1694: ' AND gcc.summary_flag = '||''''||'N'||''''||
1873: TYPE t_getbal IS REF CURSOR;
1874: vc_getbal t_getbal;
1875: vl_select VARCHAR2(2000);
1876:
1877: vl_ccid Gl_Code_Combinations.code_combination_id%TYPE;
1878:
1879: TYPE t_ccidtable IS TABLE OF Gl_Code_Combinations.code_combination_id%TYPE
1880: INDEX BY BINARY_INTEGER;
1881: vt_ccid t_ccidtable;
1875: vl_select VARCHAR2(2000);
1876:
1877: vl_ccid Gl_Code_Combinations.code_combination_id%TYPE;
1878:
1879: TYPE t_ccidtable IS TABLE OF Gl_Code_Combinations.code_combination_id%TYPE
1880: INDEX BY BINARY_INTEGER;
1881: vt_ccid t_ccidtable;
1882: i BINARY_INTEGER ;
1883: vl_ccid_cnt NUMBER;
1951:
1952: vl_select := 'SELECT glb.code_combination_id,
1953: NVL(SUM(NVL(begin_balance_dr,0) + NVL(period_net_dr,0)) -
1954: SUM(NVL(begin_balance_cr,0) + NVL(period_net_cr,0)),0)
1955: FROM Gl_Balances glb,Gl_Code_Combinations gcc
1956: WHERE glb.code_combination_id = gcc.code_combination_id
1957: AND gcc.'||vg_bal_segment|| ' = :fund_value'||
1958: ' AND gcc.'||vg_acct_segment|| ' = :child_acct'||
1959: ' AND gcc.summary_flag = '||''''||'N'||''''||
2225: vl_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
2226: vl_remaining_bal NUMBER;
2227: vl_drcr_flag VARCHAR2(1);
2228: vl_read_flag VARCHAR2(1);
2229: vl_ccid Gl_Code_Combinations.code_combination_id%TYPE;
2230: vl_processing_type Fv_Ye_Seq_Bal_Temp.processing_type%TYPE;
2231: vl_acct_combi VARCHAR2(2000);
2232: vl_delimeter VARCHAR2(1);
2233: v_cross_val_msg VARCHAR2(2000);
2310: RAISE e_invalid;
2311: ELSE
2312: vl_ccid := NULL;
2313: l_ccid_select := 'SELECT code_combination_id
2314: FROM gl_code_combinations gcc
2315: WHERE gcc.chart_of_accounts_id = :coa_id ';
2316: FOR flex_rec IN flex_cursor (vg_coa_id) LOOP
2317: l_ccid_select := l_ccid_select ||
2318: ' and gcc.'||
2885:
2886: -- Build the select statement to get the distribution details
2887: vl_dist_select := 'SELECT po.distribution_id,
2888: po.requisition_line_id, ph.segment1
2889: FROM Po_Req_Distributions_All po, gl_code_combinations gcc,
2890: Po_Requisition_Lines_All pl, Po_Requisition_Headers_All ph
2891: WHERE po.gl_closed_date IS NULL
2892: AND gcc.code_combination_id = po.code_combination_id
2893: AND gcc.chart_of_accounts_id = :coa