[Home] [Help]
136: -- PROCEDURE create_bc_transaction_report
137: -- Start of Comments
138: -- Purpose:
139: -- This procedure is invoked when the BC Report is invoked from
140: -- individual Transaction Forms
141: -- has call to build_report_query procedure that builds the SQL query
142: -- End of Comments
143: ------------------------------------------------------------------------------
144: PROCEDURE create_bc_transaction_report(
2909: segment_name_tab := name_type();
2910: segment_low_tab := name_type();
2911: segment_high_tab := name_type();
2912:
2913: -- Select individual segment information for this ledger
2914: FOR a IN c_seg_info(p_para_rec.ledger_id)
2915: LOOP
2916: segment_name_tab.extend;
2917: segment_name_tab(c_seg_info%ROWCOUNT) := a.application_column_name;
2917: segment_name_tab(c_seg_info%ROWCOUNT) := a.application_column_name;
2918: END LOOP;
2919:
2920: SELECT FND_FLEX_APIS.get_segment_delimiter(101, 'GL#', p_para_rec.chart_of_accts_id) INTO l_delimiter
2921: FROM DUAL;
2922: psa_utils.debug_other_string(g_state_level,l_api_name,'CCID Segment Delimiter: ' || l_delimiter);
2923:
2924: -- select ccid low segments
2925: l_length := LENGTH(p_para_rec.ccid_low);
3294:
3295:
3296: -- added for bug #5996038 by ks
3297: select decode(userenv('LANG') ,'US', 32766 , 16332)
3298: into l_amount from dual;
3299:
3300: psa_utils.debug_other_string(g_state_level,l_api_name,'BEGIN of procedure save_xml');
3301:
3302: -- Initialize API return status to success