278: ,sysdate
279: ,null
280: ,1
281: ,'N'
282: from fem_dim_attributes_b A, fem_dim_attr_versions_b V
283: where A.attribute_Varchar_label = 'RECON_LEAF_NODE_FLAG'
284: and A.attribute_id = V.attribute_id
285: and A.dimension_id = 1
286: and V.default_version_flag = 'Y';
318: ,sysdate
319: ,null
320: ,1
321: ,'N'
322: from fem_dim_attributes_b A, fem_dim_attr_versions_b V
323: where A.attribute_Varchar_label = 'ADJ_PERIOD_FLAG'
324: and A.attribute_id = V.attribute_id
325: and A.dimension_id = 1
326: and V.default_version_flag = 'Y';
357: ,sysdate
358: ,null
359: ,1
360: ,'N'
361: from fem_dim_attributes_b A, fem_dim_attr_versions_b V
362: where A.attribute_Varchar_label = 'GL_ORIGIN_FLAG'
363: and A.attribute_id = V.attribute_id
364: and A.dimension_id = 1
365: and V.default_version_flag = 'Y';
396: ,sysdate
397: ,null
398: ,1
399: ,'N'
400: from fem_dim_attributes_b A, fem_dim_attr_versions_b V
401: where A.attribute_Varchar_label = 'CUR_PERIOD_FLAG'
402: and A.attribute_id = V.attribute_id
403: and A.dimension_id = 1
404: and V.default_version_flag = 'Y';
435: ,sysdate
436: ,null
437: ,1
438: ,'N'
439: from fem_dim_attributes_b A, fem_dim_attr_versions_b V
440: where A.attribute_Varchar_label = 'ACCOUNTING_YEAR'
441: and A.attribute_id = V.attribute_id
442: and A.dimension_id = 1
443: and V.default_version_flag = 'Y';
474: ,sysdate
475: ,null
476: ,1
477: ,'N'
478: from fem_dim_attributes_b A, fem_dim_attr_versions_b V
479: where A.attribute_Varchar_label = 'CAL_PERIOD_START_DATE'
480: and A.attribute_id = V.attribute_id
481: and A.dimension_id = 1
482: and V.default_version_flag = 'Y';
513: ,sysdate
514: ,null
515: ,1
516: ,'N'
517: from fem_dim_attributes_b A, fem_dim_attr_versions_b V
518: where A.attribute_Varchar_label = 'CAL_PERIOD_END_DATE'
519: and A.attribute_id = V.attribute_id
520: and A.dimension_id = 1
521: and V.default_version_flag = 'Y';
552: ,sysdate
553: ,null
554: ,1
555: ,'N'
556: from fem_dim_attributes_b A, fem_dim_attr_versions_b V
557: where A.attribute_Varchar_label = 'GL_PERIOD_NUM'
558: and A.attribute_id = V.attribute_id
559: and A.dimension_id = 1
560: and V.default_version_flag = 'Y';
591: ,sysdate
592: ,null
593: ,1
594: ,'N'
595: from fem_dim_attributes_b A, fem_dim_attr_versions_b V
596: where A.attribute_Varchar_label = 'SOURCE_SYSTEM_CODE'
597: and A.attribute_id = V.attribute_id
598: and A.dimension_id = 1
599: and V.default_version_flag = 'Y';
630: ,sysdate
631: ,null
632: ,1
633: ,'N'
634: from fem_dim_attributes_b A, fem_dim_attr_versions_b V
635: where A.attribute_Varchar_label = 'CAL_PERIOD_PREFIX'
636: and A.attribute_id = V.attribute_id
637: and A.dimension_id = 1
638: and V.default_version_flag = 'Y';
886: WHERE dimension_varchar_label = 'BUDGET';
887:
888: SELECT count(*)
889: INTO v_count
890: FROM fem_dim_attributes_b
891: WHERE dimension_id = v_dim_id
892: AND attribute_varchar_label IN ('BUDGET_LEDGER','BUDGET_LEDGER',
893: 'BUDGET_FIRST_PERIOD','BUDGET_LAST_PERIOD','BUDGET_LATEST_OPEN_YEAR')
894: AND default_assignment IS NULL;
900: IF v_ledger_id IS NULL THEN
901: -- First find attrib and version id for CAL_PERIOD_HIER_OBJ_DEF_ID attrib
902: SELECT a.attribute_id, v.version_id
903: INTO v_cal_hier_attribute_id, v_cal_hier_version_id
904: FROM fem_dim_attributes_b a, fem_dim_attr_versions_b v
905: WHERE a.attribute_varchar_label = 'CAL_PERIOD_HIER_OBJ_DEF_ID'
906: AND v.attribute_id = a.attribute_id
907: AND v.default_version_flag = 'Y'
908: AND a.dimension_id =
931: AND attribute_id = v_cal_hier_attribute_id
932: AND version_id = v_cal_hier_version_id);
933: END IF;
934:
935: UPDATE fem_dim_attributes_b
936: SET default_assignment = to_char(v_ledger_id)
937: WHERE dimension_id = v_dim_id
938: AND attribute_varchar_label = 'BUDGET_LEDGER';
939:
958: AND attribute_id = v_cal_hier_attribute_id
959: AND version_id = v_cal_hier_version_id)));
960: END IF;
961:
962: UPDATE fem_dim_attributes_b
963: SET default_assignment = to_char(v_cal_period_id)
964: WHERE dimension_id = v_dim_id
965: AND attribute_varchar_label IN ('BUDGET_FIRST_PERIOD','BUDGET_LAST_PERIOD');
966: -- Update default assignment for the BUDGET_LATEST_OPEN_YEAR as the
967: -- accounting year of the BUDGET_LAST_PERIOD.
968: IF v_accounting_year IS NULL THEN
969: SELECT C.number_assign_value
970: INTO v_accounting_year
971: FROM fem_cal_periods_attr C, fem_dim_attributes_b A, fem_dim_attr_versions_b V
972: WHERE C.cal_period_id = v_cal_period_id
973: AND A.attribute_varchar_label = 'ACCOUNTING_YEAR'
974: AND C.attribute_id = V.attribute_id
975: AND C.version_id = V.version_id
980: FROM fem_dimensions_b
981: WHERE dimension_varchar_label = 'CAL_PERIOD');
982: END IF;
983:
984: UPDATE fem_dim_attributes_b
985: SET default_assignment = to_char(v_accounting_year)
986: WHERE dimension_id = v_dim_id
987: AND attribute_varchar_label = 'BUDGET_LATEST_OPEN_YEAR';
988: END IF;
1137: END; -- Bug 3695254
1138: ******************************************************/
1139:
1140:
1141: -- Bug#5201184 Update fem_dim_attributes_b.default_assignment
1142: -- For the BUSINESS_RELATIONSHIP attribute
1143: BEGIN
1144:
1145: SELECT bus_rel_id
1153: WHERE dimension_varchar_label = 'CUSTOMER';
1154:
1155: SELECT attribute_id
1156: INTO v_bus_rel_attr_id
1157: FROM fem_dim_attributes_b
1158: WHERE dimension_id = v_customer_dim_id
1159: AND attribute_varchar_label = 'BUSINESS_RELATIONSHIP';
1160:
1161: UPDATE fem_dim_attributes_b
1157: FROM fem_dim_attributes_b
1158: WHERE dimension_id = v_customer_dim_id
1159: AND attribute_varchar_label = 'BUSINESS_RELATIONSHIP';
1160:
1161: UPDATE fem_dim_attributes_b
1162: SET default_assignment = v_bus_rel_mbr_id
1163: WHERE attribute_id = v_bus_rel_attr_id
1164: AND default_assignment IS NULL;
1165: