DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_MAIN dependencies on PA_ADW_COLLECT_DIMENSIONS

Line 63: pa_adw_collect_dimensions.get_dim_status

59: x_err_code := pa_adw_collect_main.initialize;
60:
61: -- get the dimension statuses
62:
63: pa_adw_collect_dimensions.get_dim_status
64: ('DM_PROJECT',
65: dim_project,
66: x_err_stage,
67: x_err_stack,

Line 70: pa_adw_collect_dimensions.get_dim_status

66: x_err_stage,
67: x_err_stack,
68: x_err_code);
69:
70: pa_adw_collect_dimensions.get_dim_status
71: ('DM_RESOURCE',
72: dim_resource,
73: x_err_stage,
74: x_err_stack,

Line 77: pa_adw_collect_dimensions.get_dim_status

73: x_err_stage,
74: x_err_stack,
75: x_err_code);
76:
77: pa_adw_collect_dimensions.get_dim_status
78: ('DM_PROJECT_ORG',
79: dim_project_org,
80: x_err_stage,
81: x_err_stack,

Line 84: pa_adw_collect_dimensions.get_dim_status

80: x_err_stage,
81: x_err_stack,
82: x_err_code);
83:
84: pa_adw_collect_dimensions.get_dim_status
85: ('DM_EXP_ORG',
86: dim_exp_org,
87: x_err_stage,
88: x_err_stack,

Line 91: pa_adw_collect_dimensions.get_dim_status

87: x_err_stage,
88: x_err_stack,
89: x_err_code);
90:
91: pa_adw_collect_dimensions.get_dim_status
92: ('DM_SRVC_TYPE',
93: dim_srvc_type,
94: x_err_stage,
95: x_err_stack,

Line 98: pa_adw_collect_dimensions.get_dim_status

94: x_err_stage,
95: x_err_stack,
96: x_err_code);
97:
98: pa_adw_collect_dimensions.get_dim_status
99: ('DM_TIME',
100: dim_time,
101: x_err_stage,
102: x_err_stack,

Line 105: pa_adw_collect_dimensions.get_dim_status

101: x_err_stage,
102: x_err_stack,
103: x_err_code);
104:
105: pa_adw_collect_dimensions.get_dim_status
106: ('DM_BGT_TYPE',
107: dim_bgt_type,
108: x_err_stage,
109: x_err_stack,

Line 112: pa_adw_collect_dimensions.get_dim_status

108: x_err_stage,
109: x_err_stack,
110: x_err_code);
111:
112: pa_adw_collect_dimensions.get_dim_status
113: ('DM_EXP_TYPE',
114: dim_exp_type,
115: x_err_stage,
116: x_err_stack,

Line 119: pa_adw_collect_dimensions.get_dim_status

115: x_err_stage,
116: x_err_stack,
117: x_err_code);
118:
119: pa_adw_collect_dimensions.get_dim_status
120: ('DM_OPERATING_UNIT',
121: dim_operating_unit,
122: x_err_stage,
123: x_err_stack,

Line 586: pa_adw_collect_dimensions.get_dim_tasks (x_err_stage, x_err_stack, x_err_code);

582: OR x_dimension_table IS NULL ) THEN
583:
584: IF (dim_project = 'E') THEN
585: -- Collect Tasks
586: pa_adw_collect_dimensions.get_dim_tasks (x_err_stage, x_err_stack, x_err_code);
587: END IF;
588:
589: END IF;
590: IF ( x_dimension_table = 'PROJECTS'

Line 595: pa_adw_collect_dimensions.get_dim_projects (x_err_stage, x_err_stack, x_err_code);

591: OR x_dimension_table IS NULL ) THEN
592:
593: IF (dim_project = 'E') THEN
594: -- Collect Projects
595: pa_adw_collect_dimensions.get_dim_projects (x_err_stage, x_err_stack, x_err_code);
596: END IF;
597:
598: END IF;
599: IF ( x_dimension_table = 'PROJECT_TYPES'

Line 604: pa_adw_collect_dimensions.get_dim_project_types (x_err_stage, x_err_stack, x_err_code);

600: OR x_dimension_table IS NULL ) THEN
601:
602: IF (dim_project = 'E') THEN
603: -- Collect Project Types
604: pa_adw_collect_dimensions.get_dim_project_types (x_err_stage, x_err_stack, x_err_code);
605: END IF;
606:
607: END IF;
608: IF ( x_dimension_table = 'EXPENDITURE_TYPES'

Line 613: pa_adw_collect_dimensions.get_dim_expenditure_types (x_err_stage, x_err_stack, x_err_code);

609: OR x_dimension_table IS NULL ) THEN
610:
611: IF (dim_exp_type = 'E') THEN
612: -- Collect Project Types
613: pa_adw_collect_dimensions.get_dim_expenditure_types (x_err_stage, x_err_stack, x_err_code);
614: END IF;
615:
616: END IF;
617: IF ( x_dimension_table = 'PROJECT_CLASSES'

Line 622: pa_adw_collect_dimensions.get_dim_project_classes (x_err_stage, x_err_stack, x_err_code);

618: OR x_dimension_table IS NULL ) THEN
619:
620: IF (dim_project = 'E') THEN
621: -- Collect Project Classes
622: pa_adw_collect_dimensions.get_dim_project_classes (x_err_stage, x_err_stack, x_err_code);
623: END IF;
624:
625: END IF;
626: IF ( x_dimension_table = 'CLASS_CATEGORIES'

Line 631: pa_adw_collect_dimensions.get_dim_class_categories (x_err_stage, x_err_stack, x_err_code);

627: OR x_dimension_table IS NULL ) THEN
628:
629: IF (dim_project = 'E') THEN
630: -- Collect Class Categories
631: pa_adw_collect_dimensions.get_dim_class_categories (x_err_stage, x_err_stack, x_err_code);
632: END IF;
633:
634: END IF;
635: IF ( x_dimension_table = 'CLASS_CODES'

Line 640: pa_adw_collect_dimensions.get_dim_class_codes (x_err_stage, x_err_stack, x_err_code);

636: OR x_dimension_table IS NULL ) THEN
637:
638: IF (dim_project = 'E') THEN
639: -- Collect Class Codes
640: pa_adw_collect_dimensions.get_dim_class_codes (x_err_stage, x_err_stack, x_err_code);
641: END IF;
642:
643: END IF;
644: IF ( x_dimension_table = 'RESOURCES'

Line 649: pa_adw_collect_dimensions.get_dim_resources (x_err_stage, x_err_stack, x_err_code);

645: OR x_dimension_table IS NULL ) THEN
646:
647: IF (dim_resource = 'E') THEN
648: -- Collect Resources
649: pa_adw_collect_dimensions.get_dim_resources (x_err_stage, x_err_stack, x_err_code);
650: END IF;
651:
652: END IF;
653: IF ( x_dimension_table = 'RESOURCE_LISTS'

Line 658: pa_adw_collect_dimensions.get_dim_resource_lists (x_err_stage, x_err_stack, x_err_code);

654: OR x_dimension_table IS NULL ) THEN
655:
656: IF (dim_resource = 'E') THEN
657: -- Collect Resource Lists
658: pa_adw_collect_dimensions.get_dim_resource_lists (x_err_stage, x_err_stack, x_err_code);
659: END IF;
660:
661: END IF;
662: IF ( x_dimension_table = 'BUDGET_TYPES'

Line 667: pa_adw_collect_dimensions.get_dim_budget_types (x_err_stage, x_err_stack, x_err_code);

663: OR x_dimension_table IS NULL ) THEN
664:
665: IF (dim_bgt_type = 'E') THEN
666: -- Collect Budget Types
667: pa_adw_collect_dimensions.get_dim_budget_types (x_err_stage, x_err_stack, x_err_code);
668: END IF;
669:
670: END IF;
671: IF ( x_dimension_table = 'PERIODS'

Line 676: pa_adw_collect_dimensions.get_dim_periods (x_err_stage, x_err_stack, x_err_code);

672: OR x_dimension_table IS NULL ) THEN
673:
674: IF (dim_time = 'E') THEN
675: -- Collect Periods
676: pa_adw_collect_dimensions.get_dim_periods (x_err_stage, x_err_stack, x_err_code);
677: END IF;
678:
679: END IF;
680: IF ( x_dimension_table = 'SERVICE_TYPES'

Line 685: pa_adw_collect_dimensions.get_dim_service_types (x_err_stage, x_err_stack, x_err_code);

681: OR x_dimension_table IS NULL ) THEN
682:
683: IF (dim_srvc_type = 'E') THEN
684: -- Collect Service Types
685: pa_adw_collect_dimensions.get_dim_service_types (x_err_stage, x_err_stack, x_err_code);
686: END IF;
687:
688: END IF;
689: IF ( x_dimension_table = 'ORGANIZATIONS'

Line 695: pa_adw_collect_dimensions.get_dim_organizations (x_err_stage, x_err_stack, x_err_code);

691:
692: IF (dim_project_org = 'E' OR dim_exp_org = 'E'
693: OR dim_operating_unit = 'E' ) THEN
694: -- Collect Organizations
695: pa_adw_collect_dimensions.get_dim_organizations (x_err_stage, x_err_stack, x_err_code);
696: END IF;
697:
698: END IF;
699:

Line 841: pa_adw_collect_dimensions.get_dim_tasks (x_err_stage, x_err_stack, x_err_code);

837: x_err_code);
838:
839: IF (dim_project = 'E') THEN
840: -- Collect Tasks
841: pa_adw_collect_dimensions.get_dim_tasks (x_err_stage, x_err_stack, x_err_code);
842: END IF;
843:
844: IF (dim_project = 'E') THEN
845: -- Collect Projects

Line 846: pa_adw_collect_dimensions.get_dim_projects (x_err_stage, x_err_stack, x_err_code);

842: END IF;
843:
844: IF (dim_project = 'E') THEN
845: -- Collect Projects
846: pa_adw_collect_dimensions.get_dim_projects (x_err_stage, x_err_stack, x_err_code);
847: END IF;
848:
849: IF (dim_project = 'E') THEN
850: -- Collect Project Types

Line 851: pa_adw_collect_dimensions.get_dim_project_types (x_err_stage, x_err_stack, x_err_code);

847: END IF;
848:
849: IF (dim_project = 'E') THEN
850: -- Collect Project Types
851: pa_adw_collect_dimensions.get_dim_project_types (x_err_stage, x_err_stack, x_err_code);
852: END IF;
853:
854: IF (dim_exp_type = 'E') THEN
855: -- Collect Project Types

Line 856: pa_adw_collect_dimensions.get_dim_expenditure_types (x_err_stage, x_err_stack, x_err_code);

852: END IF;
853:
854: IF (dim_exp_type = 'E') THEN
855: -- Collect Project Types
856: pa_adw_collect_dimensions.get_dim_expenditure_types (x_err_stage, x_err_stack, x_err_code);
857: END IF;
858:
859: IF (dim_project = 'E') THEN
860: -- Collect Project Classes

Line 861: pa_adw_collect_dimensions.get_dim_project_classes (x_err_stage, x_err_stack, x_err_code);

857: END IF;
858:
859: IF (dim_project = 'E') THEN
860: -- Collect Project Classes
861: pa_adw_collect_dimensions.get_dim_project_classes (x_err_stage, x_err_stack, x_err_code);
862: END IF;
863:
864: IF (dim_project = 'E') THEN
865: -- Collect Class Categories

Line 866: pa_adw_collect_dimensions.get_dim_class_categories (x_err_stage, x_err_stack, x_err_code);

862: END IF;
863:
864: IF (dim_project = 'E') THEN
865: -- Collect Class Categories
866: pa_adw_collect_dimensions.get_dim_class_categories (x_err_stage, x_err_stack, x_err_code);
867: END IF;
868:
869: IF (dim_project = 'E') THEN
870: -- Collect Class Codes

Line 871: pa_adw_collect_dimensions.get_dim_class_codes (x_err_stage, x_err_stack, x_err_code);

867: END IF;
868:
869: IF (dim_project = 'E') THEN
870: -- Collect Class Codes
871: pa_adw_collect_dimensions.get_dim_class_codes (x_err_stage, x_err_stack, x_err_code);
872: END IF;
873:
874: IF (dim_resource = 'E') THEN
875: -- Collect Resources

Line 876: pa_adw_collect_dimensions.get_dim_resources (x_err_stage, x_err_stack, x_err_code);

872: END IF;
873:
874: IF (dim_resource = 'E') THEN
875: -- Collect Resources
876: pa_adw_collect_dimensions.get_dim_resources (x_err_stage, x_err_stack, x_err_code);
877: END IF;
878:
879: IF (dim_resource = 'E') THEN
880: -- Collect Resource Lists

Line 881: pa_adw_collect_dimensions.get_dim_resource_lists (x_err_stage, x_err_stack, x_err_code);

877: END IF;
878:
879: IF (dim_resource = 'E') THEN
880: -- Collect Resource Lists
881: pa_adw_collect_dimensions.get_dim_resource_lists (x_err_stage, x_err_stack, x_err_code);
882: END IF;
883:
884: IF (dim_bgt_type = 'E') THEN
885: -- Collect Budget Types

Line 886: pa_adw_collect_dimensions.get_dim_budget_types (x_err_stage, x_err_stack, x_err_code);

882: END IF;
883:
884: IF (dim_bgt_type = 'E') THEN
885: -- Collect Budget Types
886: pa_adw_collect_dimensions.get_dim_budget_types (x_err_stage, x_err_stack, x_err_code);
887: END IF;
888:
889: IF (dim_time = 'E') THEN
890: -- Collect Periods

Line 891: pa_adw_collect_dimensions.get_dim_periods (x_err_stage, x_err_stack, x_err_code);

887: END IF;
888:
889: IF (dim_time = 'E') THEN
890: -- Collect Periods
891: pa_adw_collect_dimensions.get_dim_periods (x_err_stage, x_err_stack, x_err_code);
892: END IF;
893:
894: IF (dim_srvc_type = 'E') THEN
895: -- Collect Service Types

Line 896: pa_adw_collect_dimensions.get_dim_service_types (x_err_stage, x_err_stack, x_err_code);

892: END IF;
893:
894: IF (dim_srvc_type = 'E') THEN
895: -- Collect Service Types
896: pa_adw_collect_dimensions.get_dim_service_types (x_err_stage, x_err_stack, x_err_code);
897: END IF;
898:
899: IF (dim_project_org = 'E' OR dim_exp_org = 'E'
900: OR dim_operating_unit = 'E' ) THEN

Line 902: pa_adw_collect_dimensions.get_dim_organizations (x_err_stage, x_err_stack, x_err_code);

898:
899: IF (dim_project_org = 'E' OR dim_exp_org = 'E'
900: OR dim_operating_unit = 'E' ) THEN
901: -- Collect Organizations
902: pa_adw_collect_dimensions.get_dim_organizations (x_err_stage, x_err_stack, x_err_code);
903: END IF;
904:
905: -- Collect Custom Dimensions
906: