2407: ,p_module => l_log_module);
2408: END IF;
2409:
2410: --
2411: -- declare the standard header variables
2412: --
2413: l_one_var := NULL;
2414: l_HdrVariables := l_one_var ;
2415:
2623: ,p_module => l_log_module);
2624:
2625: END IF;
2626: --
2627: -- declare the standard line variables
2628: --
2629: l_one_var := NULL;
2630: l_LineVariables := l_one_var ;
2631: --
2748: --
2749: l_one_var := ' , l_array_extract_line_num ';
2750: l_LineVariables := l_one_var ;
2751: --
2752: -- Fetch standard line variables
2753: --
2754: IF p_array_l_source_index.COUNT > 0 THEN
2755: --
2756: FOR Idx IN p_array_l_source_index.FIRST .. p_array_l_source_index.LAST LOOP
3242: --| |
3243: --| PRIVATE function |
3244: --| |
3245: --| Generate the declaration of the header Cursor : The Extract of |
3246: --| standard and MLS header sources from the Header Extract Object |
3247: --| |
3248: --| |
3249: --+==========================================================================+
3250: --
3310: l_hdr_tabs := NULL;
3311:
3312: IF l_h_count > 0 THEN
3313: --
3314: -- get standard header tables/views
3315: --
3316: GetUsedExtractObject
3317: (p_array_table_index => p_array_h_table_index
3318: ,p_array_parent_table_index => p_array_parent_table_index
3327: ,p_array_populated_flag => p_array_populated_flag
3328: ,p_array_ref_obj_flag => p_array_ref_obj_flag);
3329:
3330: --
3331: -- extract standard sources
3332: --
3333: l_hdr_sources :=
3334: l_hdr_sources ||
3335: GenerateExtractColumns
3629: --| |
3630: --| PRIVATE function |
3631: --| |
3632: --| Generate the declaration of the Line Cursor : The Extract of |
3633: --| standard BC and MLS line sources from the Header Extract Object |
3634: --| |
3635: --| |
3636: --+==========================================================================+
3637: --
3719:
3720: -- l_line_sources := ' , $tab$.LINE_NUMBER ';
3721:
3722: --
3723: -- get list of standard line table
3724: --
3725: IF l_l_count > 0 THEN
3726: GetUsedExtractObject
3727: (p_array_table_index => p_array_l_table_index
4138: END IF;
4139:
4140: l_HdrTypes := NULL;
4141: --
4142: -- structure of standard header sources
4143: --
4144: IF p_array_h_source_index. COUNT > 0 THEN
4145: FOR Idx IN p_array_h_source_index.FIRST .. p_array_h_source_index.LAST LOOP
4146: IF p_array_h_source_index.EXISTS(Idx) THEN
4221: ,p_module => l_log_module);
4222: END IF;
4223:
4224: --
4225: -- declare the standard header variables
4226: --
4227: l_one_var := NULL;
4228: l_HdrStrings := l_one_var ;
4229:
4407: --
4408: --
4409: IF l_h_count > 0 THEN
4410: --
4411: -- get standard header tables/views
4412: --
4413: --
4414: GetUsedExtractObject( p_array_table_index => p_array_h_table_index
4415: ,p_array_parent_table_index => p_array_parent_table_index
4602: --
4603: --
4604: IF l_h_count > 0 THEN
4605: --
4606: -- get standard header tables/views
4607: --
4608: --
4609: GetUsedExtractObject( p_array_table_index => p_array_h_table_index
4610: ,p_array_parent_table_index => p_array_parent_table_index
4942: l_first_mls_tab := NULL;
4943: --
4944:
4945: --
4946: -- get list of standard line table
4947: --
4948: IF l_l_count > 0 THEN
4949: --
4950: GetUsedExtractObject( p_array_table_index => p_array_l_table_index
5138: l_first_tab := NULL;
5139: l_first_mls_tab := NULL;
5140: --
5141: --
5142: -- get list of standard line table
5143: --
5144: IF l_l_count > 0 THEN
5145: --
5146: GetUsedExtractObject( p_array_table_index => p_array_l_table_index