393: curr_pos := curr_pos + g_line_size;
394: line_num := line_num + 1;
395: END LOOP;
396:
397: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
398: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
399:
400: body_block :=
401: ' xtd_balance_e, ytd_balance_e,
416: curr_pos := curr_pos + g_line_size;
417: line_num := line_num + 1;
418: END LOOP;
419:
420: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
421: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
422:
423: body_block :=
424: ' sum(xtd_balance_e), sum(ytd_balance_e),
461: curr_pos := curr_pos + g_line_size;
462: line_num := line_num + 1;
463: END LOOP;
464:
465: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
466: ' fb.', GCS_UTILITY_PKG.g_nl, '', line_num);
467:
468: body_block :=
469: ' fb.line_item_id;
520: curr_pos := curr_pos + g_line_size;
521: line_num := line_num + 1;
522: END LOOP;
523:
524: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
525: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
526:
527: body_block :=
528: ' xtd_balance_e, ytd_balance_e,
562: line_num := line_num + 1;
563: END LOOP;
564:
565: -- optional active dimensions
566: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
567: ' fb.', GCS_UTILITY_PKG.g_nl, '', line_num);
568:
569: body_block :=
570: ' sum(xtd_balance_e), sum(ytd_balance_e),
622: line_num := line_num + 1;
623: END LOOP;
624:
625: -- optional active dimensions
626: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
627: ' fb.', GCS_UTILITY_PKG.g_nl, '', line_num);
628:
629: body_block :=
630: ' fb.line_item_id;
646: line_num := line_num + 1;
647: END LOOP;
648:
649: -- optional active dimensions
650: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
651: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
652:
653: body_block :=
654: ' line_item_id, company_cost_center_org_id) IN (
714: line_num := line_num + 1;
715: END LOOP;
716:
717: -- optional active dimensions
718: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
719: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
720:
721: body_block :=
722: ' xtd_balance_e, ytd_balance_e,
737: line_num := line_num + 1;
738: END LOOP;
739:
740: -- optional active dimensions
741: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
742: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
743:
744: body_block :=
745: '
762: line_num := line_num + 1;
763: END LOOP;
764:
765: -- optional active dimensions
766: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(
767: ' ', GCS_UTILITY_PKG.g_nl, '', line_num);
768:
769: body_block :=
770: ' company_cost_center_org_id,
810: curr_pos := curr_pos + g_line_size;
811: line_num := line_num + 1;
812: END LOOP;
813:
814: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,
815: 'GCS', 'GCS_AGGREGATION_DYNAMIC_PKG',
816: 1, line_num - 1, 'FALSE', comp_err);
817:
818: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN