DBA Data[Home] [Help]

APPS.GCS_AGGREGATION_DYN_BUILD_PKG dependencies on GCS_DYNAMIC_UTIL_PKG

Line 397: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

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,

Line 420: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

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),

Line 465: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

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;

Line 524: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

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,

Line 566: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

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),

Line 626: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

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;

Line 650: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

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 (

Line 718: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

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,

Line 741: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

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: '

Line 766: line_num := GCS_DYNAMIC_UTIL_PKG.Build_Comma_List(

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,

Line 814: ad_ddl.create_plsql_object(GCS_DYNAMIC_UTIL_PKG.g_applsys_username,

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