eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.ZPB_BUSAREA_MAINT dependencies on FND_GLOBAL

Line 78: FND_GLOBAL.USER_ID,

74: (p_version_id,
75: p_logical_dim_id, -- "Consistent Dimension"
76: p_attribute_id,
77: sysdate,
78: FND_GLOBAL.USER_ID,
79: FND_GLOBAL.LOGIN_ID,
80: sysdate,
81: FND_GLOBAL.USER_ID);
82:

Line 79: FND_GLOBAL.LOGIN_ID,

75: p_logical_dim_id, -- "Consistent Dimension"
76: p_attribute_id,
77: sysdate,
78: FND_GLOBAL.USER_ID,
79: FND_GLOBAL.LOGIN_ID,
80: sysdate,
81: FND_GLOBAL.USER_ID);
82:
83: end ADD_ATTRIBUTE;

Line 81: FND_GLOBAL.USER_ID);

77: sysdate,
78: FND_GLOBAL.USER_ID,
79: FND_GLOBAL.LOGIN_ID,
80: sysdate,
81: FND_GLOBAL.USER_ID);
82:
83: end ADD_ATTRIBUTE;
84:
85: -------------------------------------------------------------------------

Line 123: FND_GLOBAL.USER_ID,

119: p_value,
120: p_value_set_id,
121: p_operation,
122: sysdate,
123: FND_GLOBAL.USER_ID,
124: FND_GLOBAL.LOGIN_ID,
125: sysdate,
126: FND_GLOBAL.USER_ID);
127: end ADD_CONDITION;

Line 124: FND_GLOBAL.LOGIN_ID,

120: p_value_set_id,
121: p_operation,
122: sysdate,
123: FND_GLOBAL.USER_ID,
124: FND_GLOBAL.LOGIN_ID,
125: sysdate,
126: FND_GLOBAL.USER_ID);
127: end ADD_CONDITION;
128:

Line 126: FND_GLOBAL.USER_ID);

122: sysdate,
123: FND_GLOBAL.USER_ID,
124: FND_GLOBAL.LOGIN_ID,
125: sysdate,
126: FND_GLOBAL.USER_ID);
127: end ADD_CONDITION;
128:
129: -------------------------------------------------------------------------
130: -- ADD_DATASET - Adds a dataset to the Business Area version

Line 151: FND_GLOBAL.USER_ID,

147: values
148: (p_version_id,
149: p_dataset_id,
150: sysdate,
151: FND_GLOBAL.USER_ID,
152: FND_GLOBAL.LOGIN_ID,
153: sysdate,
154: FND_GLOBAL.USER_ID);
155: end ADD_DATASET;

Line 152: FND_GLOBAL.LOGIN_ID,

148: (p_version_id,
149: p_dataset_id,
150: sysdate,
151: FND_GLOBAL.USER_ID,
152: FND_GLOBAL.LOGIN_ID,
153: sysdate,
154: FND_GLOBAL.USER_ID);
155: end ADD_DATASET;
156:

Line 154: FND_GLOBAL.USER_ID);

150: sysdate,
151: FND_GLOBAL.USER_ID,
152: FND_GLOBAL.LOGIN_ID,
153: sysdate,
154: FND_GLOBAL.USER_ID);
155: end ADD_DATASET;
156:
157: -------------------------------------------------------------------------
158: -- ADD_DIMENSION - Adds a dimension to the Business Area version

Line 215: FND_GLOBAL.USER_ID));

211: where VERSION_ID = p_version_id;
212: exception
213: when no_data_found then
214: l_ledger := to_number(FND_PROFILE.VALUE_SPECIFIC('FEM_LEDGER',
215: FND_GLOBAL.USER_ID));
216: end;
217:
218: select VALUE_SET_REQUIRED_FLAG,
219: decode(DIMENSION_TYPE_CODE, 'LINE', 'Y', 'N')

Line 363: FND_GLOBAL.USER_ID,

359: l_is_line,
360: 'N',
361: 'N',
362: sysdate,
363: FND_GLOBAL.USER_ID,
364: FND_GLOBAL.LOGIN_ID,
365: sysdate,
366: FND_GLOBAL.USER_ID);
367:

Line 364: FND_GLOBAL.LOGIN_ID,

360: 'N',
361: 'N',
362: sysdate,
363: FND_GLOBAL.USER_ID,
364: FND_GLOBAL.LOGIN_ID,
365: sysdate,
366: FND_GLOBAL.USER_ID);
367:
368: if (p_dimension_id <> 7) then

Line 366: FND_GLOBAL.USER_ID);

362: sysdate,
363: FND_GLOBAL.USER_ID,
364: FND_GLOBAL.LOGIN_ID,
365: sysdate,
366: FND_GLOBAL.USER_ID);
367:
368: if (p_dimension_id <> 7) then
369: l_count := 0;
370: for l_dim_hier in c_dim_hier_curs loop

Line 430: FND_GLOBAL.USER_ID,

426: 'N',
427: 'Y',
428: 'Y',
429: sysdate,
430: FND_GLOBAL.USER_ID,
431: FND_GLOBAL.LOGIN_ID,
432: sysdate,
433: FND_GLOBAL.USER_ID);
434:

Line 431: FND_GLOBAL.LOGIN_ID,

427: 'Y',
428: 'Y',
429: sysdate,
430: FND_GLOBAL.USER_ID,
431: FND_GLOBAL.LOGIN_ID,
432: sysdate,
433: FND_GLOBAL.USER_ID);
434:
435: -- "Consistent Dimension"

Line 433: FND_GLOBAL.USER_ID);

429: sysdate,
430: FND_GLOBAL.USER_ID,
431: FND_GLOBAL.LOGIN_ID,
432: sysdate,
433: FND_GLOBAL.USER_ID);
434:
435: -- "Consistent Dimension"
436: Begin
437: select MULTI_TOP_FLAG, DIMENSION_ID

Line 524: FND_GLOBAL.USER_ID,

520: p_member_id,
521: p_member_vset,
522: p_hier_version,
523: sysdate,
524: FND_GLOBAL.USER_ID,
525: FND_GLOBAL.LOGIN_ID,
526: sysdate,
527: FND_GLOBAL.USER_ID);
528:

Line 525: FND_GLOBAL.LOGIN_ID,

521: p_member_vset,
522: p_hier_version,
523: sysdate,
524: FND_GLOBAL.USER_ID,
525: FND_GLOBAL.LOGIN_ID,
526: sysdate,
527: FND_GLOBAL.USER_ID);
528:
529: end ADD_HIERARCHY_MEMBER;

Line 527: FND_GLOBAL.USER_ID);

523: sysdate,
524: FND_GLOBAL.USER_ID,
525: FND_GLOBAL.LOGIN_ID,
526: sysdate,
527: FND_GLOBAL.USER_ID);
528:
529: end ADD_HIERARCHY_MEMBER;
530:
531: -------------------------------------------------------------------------

Line 563: FND_GLOBAL.USER_ID,

559: p_hierarchy_id,
560: p_hier_vers_id,
561: 'Y',
562: sysdate,
563: FND_GLOBAL.USER_ID,
564: FND_GLOBAL.LOGIN_ID,
565: sysdate,
566: FND_GLOBAL.USER_ID);
567:

Line 564: FND_GLOBAL.LOGIN_ID,

560: p_hier_vers_id,
561: 'Y',
562: sysdate,
563: FND_GLOBAL.USER_ID,
564: FND_GLOBAL.LOGIN_ID,
565: sysdate,
566: FND_GLOBAL.USER_ID);
567:
568: end ADD_HIERARCHY_VERSION;

Line 566: FND_GLOBAL.USER_ID);

562: sysdate,
563: FND_GLOBAL.USER_ID,
564: FND_GLOBAL.LOGIN_ID,
565: sysdate,
566: FND_GLOBAL.USER_ID);
567:
568: end ADD_HIERARCHY_VERSION;
569:
570: -------------------------------------------------------------------------

Line 592: FND_GLOBAL.USER_ID,

588: values
589: (p_version_id,
590: p_ledger_id,
591: sysdate,
592: FND_GLOBAL.USER_ID,
593: FND_GLOBAL.LOGIN_ID,
594: sysdate,
595: FND_GLOBAL.USER_ID);
596: end ADD_LEDGER;

Line 593: FND_GLOBAL.LOGIN_ID,

589: (p_version_id,
590: p_ledger_id,
591: sysdate,
592: FND_GLOBAL.USER_ID,
593: FND_GLOBAL.LOGIN_ID,
594: sysdate,
595: FND_GLOBAL.USER_ID);
596: end ADD_LEDGER;
597:

Line 595: FND_GLOBAL.USER_ID);

591: sysdate,
592: FND_GLOBAL.USER_ID,
593: FND_GLOBAL.LOGIN_ID,
594: sysdate,
595: FND_GLOBAL.USER_ID);
596: end ADD_LEDGER;
597:
598: -------------------------------------------------------------------------
599: -- ADD_LEVEL - Adds a level to the Business Area version

Line 628: FND_GLOBAL.USER_ID,

624: p_logical_dim_id, -- "Consistent Dimension"
625: p_level_id,
626: p_hierarchy_id,
627: sysdate,
628: FND_GLOBAL.USER_ID,
629: FND_GLOBAL.LOGIN_ID,
630: sysdate,
631: FND_GLOBAL.USER_ID);
632: end ADD_LEVEL;

Line 629: FND_GLOBAL.LOGIN_ID,

625: p_level_id,
626: p_hierarchy_id,
627: sysdate,
628: FND_GLOBAL.USER_ID,
629: FND_GLOBAL.LOGIN_ID,
630: sysdate,
631: FND_GLOBAL.USER_ID);
632: end ADD_LEVEL;
633:

Line 631: FND_GLOBAL.USER_ID);

627: sysdate,
628: FND_GLOBAL.USER_ID,
629: FND_GLOBAL.LOGIN_ID,
630: sysdate,
631: FND_GLOBAL.USER_ID);
632: end ADD_LEVEL;
633:
634: -------------------------------------------------------------------------
635: -- CHANGE_HIER_VERS_INCL - Should be called anytime the user changes

Line 691: FND_GLOBAL.LOGIN_ID,

687: p_logical_dim_id, -- "Consistent Dimension"
688: p_hierarchy_id,
689: each_vers.OBJECT_DEFINITION_ID,
690: 'Y',
691: FND_GLOBAL.LOGIN_ID,
692: sysdate,
693: FND_GLOBAL.USER_ID,
694: sysdate,
695: FND_GLOBAL.USER_ID);

Line 693: FND_GLOBAL.USER_ID,

689: each_vers.OBJECT_DEFINITION_ID,
690: 'Y',
691: FND_GLOBAL.LOGIN_ID,
692: sysdate,
693: FND_GLOBAL.USER_ID,
694: sysdate,
695: FND_GLOBAL.USER_ID);
696: l_count := l_count+1;
697: exit when (l_count > l_number);

Line 695: FND_GLOBAL.USER_ID);

691: FND_GLOBAL.LOGIN_ID,
692: sysdate,
693: FND_GLOBAL.USER_ID,
694: sysdate,
695: FND_GLOBAL.USER_ID);
696: l_count := l_count+1;
697: exit when (l_count > l_number);
698: end loop;
699: end if;

Line 748: l_user_id := FND_GLOBAL.USER_ID;

744: return NUMBER is
745: l_business_area_id ZPB_BUSINESS_AREAS.BUSINESS_AREA_ID%type;
746: l_user_id FND_USER.USER_ID%type;
747: begin
748: l_user_id := FND_GLOBAL.USER_ID;
749:
750: select ZPB_BUSINESS_AREAS_SEQ.nextval into l_business_area_id from dual;
751:
752: insert into ZPB_BUSINESS_AREAS

Line 768: FND_GLOBAL.USER_ID,

764: l_user_id,
765: 'ZPBDATA'||l_business_area_id,
766: 'ZPBANNOT'||l_business_area_id,
767: sysdate,
768: FND_GLOBAL.USER_ID,
769: FND_GLOBAL.LOGIN_ID,
770: sysdate,
771: FND_GLOBAL.USER_ID);
772:

Line 769: FND_GLOBAL.LOGIN_ID,

765: 'ZPBDATA'||l_business_area_id,
766: 'ZPBANNOT'||l_business_area_id,
767: sysdate,
768: FND_GLOBAL.USER_ID,
769: FND_GLOBAL.LOGIN_ID,
770: sysdate,
771: FND_GLOBAL.USER_ID);
772:
773: insert into ZPB_BUSAREA_USERS

Line 771: FND_GLOBAL.USER_ID);

767: sysdate,
768: FND_GLOBAL.USER_ID,
769: FND_GLOBAL.LOGIN_ID,
770: sysdate,
771: FND_GLOBAL.USER_ID);
772:
773: insert into ZPB_BUSAREA_USERS
774: (BUSINESS_AREA_ID,
775: USER_ID,

Line 785: FND_GLOBAL.USER_ID,

781: values
782: (l_business_area_id,
783: l_user_id,
784: sysdate,
785: FND_GLOBAL.USER_ID,
786: FND_GLOBAL.LOGIN_ID,
787: sysdate,
788: FND_GLOBAL.USER_ID);
789:

Line 786: FND_GLOBAL.LOGIN_ID,

782: (l_business_area_id,
783: l_user_id,
784: sysdate,
785: FND_GLOBAL.USER_ID,
786: FND_GLOBAL.LOGIN_ID,
787: sysdate,
788: FND_GLOBAL.USER_ID);
789:
790: return l_business_area_id;

Line 788: FND_GLOBAL.USER_ID);

784: sysdate,
785: FND_GLOBAL.USER_ID,
786: FND_GLOBAL.LOGIN_ID,
787: sysdate,
788: FND_GLOBAL.USER_ID);
789:
790: return l_business_area_id;
791: end CREATE_BUSINESS_AREA;
792:

Line 869: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

865: DESCRIPTION = l_version_desc,
866: CURRENCY_ENABLED = l_version_curr,
867: INTERCOMPANY_ENABLED = l_version_inter,
868: FUNC_DIM_SET_OBJ_DEF_ID= l_ver_fdr_obj_def_id, -- "Consistent Dimension"
869: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
870: LAST_UPDATE_DATE = sysdate,
871: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
872: where BUSINESS_AREA_ID = p_business_area_id
873: and VERSION_TYPE = p_version_type;

Line 871: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

867: INTERCOMPANY_ENABLED = l_version_inter,
868: FUNC_DIM_SET_OBJ_DEF_ID= l_ver_fdr_obj_def_id, -- "Consistent Dimension"
869: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
870: LAST_UPDATE_DATE = sysdate,
871: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
872: where BUSINESS_AREA_ID = p_business_area_id
873: and VERSION_TYPE = p_version_type;
874:
875: else

Line 902: FND_GLOBAL.USER_ID,

898: l_version_curr,
899: l_version_inter,
900: l_ver_fdr_obj_def_id, -- "Consistent Dimension"
901: sysdate,
902: FND_GLOBAL.USER_ID,
903: FND_GLOBAL.LOGIN_ID,
904: sysdate,
905: FND_GLOBAL.USER_ID);
906: end if;

Line 903: FND_GLOBAL.LOGIN_ID,

899: l_version_inter,
900: l_ver_fdr_obj_def_id, -- "Consistent Dimension"
901: sysdate,
902: FND_GLOBAL.USER_ID,
903: FND_GLOBAL.LOGIN_ID,
904: sysdate,
905: FND_GLOBAL.USER_ID);
906: end if;
907:

Line 905: FND_GLOBAL.USER_ID);

901: sysdate,
902: FND_GLOBAL.USER_ID,
903: FND_GLOBAL.LOGIN_ID,
904: sysdate,
905: FND_GLOBAL.USER_ID);
906: end if;
907:
908: return l_version_id;
909: end CREATE_EMPTY_VERSION;

Line 1010: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

1006: INTERCOMPANY_ENABLED = l_version_inter,
1007: FUNC_DIM_SET_OBJ_DEF_ID = l_ver_fdr_obj_def_id, -- "Consistent Dimension"
1008: LINE_HIERARCHY_NAME = l_version_line_name,
1009: LINE_HIERARCHY_DESC = l_version_line_desc,
1010: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1011: LAST_UPDATE_DATE = sysdate,
1012: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
1013: where VERSION_ID = l_to_version_id;
1014:

Line 1012: LAST_UPDATED_BY = FND_GLOBAL.USER_ID

1008: LINE_HIERARCHY_NAME = l_version_line_name,
1009: LINE_HIERARCHY_DESC = l_version_line_desc,
1010: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1011: LAST_UPDATE_DATE = sysdate,
1012: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
1013: where VERSION_ID = l_to_version_id;
1014:
1015: insert into ZPB_BUSAREA_DIMENSIONS
1016: (VERSION_ID,

Line 1046: FND_GLOBAL.USER_ID,

1042: LINE_HIERARCHY,
1043: CONDITIONS_INCL_ANC,
1044: CONDITIONS_INCL_DESC,
1045: sysdate,
1046: FND_GLOBAL.USER_ID,
1047: FND_GLOBAL.LOGIN_ID,
1048: sysdate,
1049: FND_GLOBAL.USER_ID
1050: from ZPB_BUSAREA_DIMENSIONS

Line 1047: FND_GLOBAL.LOGIN_ID,

1043: CONDITIONS_INCL_ANC,
1044: CONDITIONS_INCL_DESC,
1045: sysdate,
1046: FND_GLOBAL.USER_ID,
1047: FND_GLOBAL.LOGIN_ID,
1048: sysdate,
1049: FND_GLOBAL.USER_ID
1050: from ZPB_BUSAREA_DIMENSIONS
1051: where VERSION_ID = l_from_version_id;

Line 1049: FND_GLOBAL.USER_ID

1045: sysdate,
1046: FND_GLOBAL.USER_ID,
1047: FND_GLOBAL.LOGIN_ID,
1048: sysdate,
1049: FND_GLOBAL.USER_ID
1050: from ZPB_BUSAREA_DIMENSIONS
1051: where VERSION_ID = l_from_version_id;
1052:
1053: insert into ZPB_BUSAREA_HIERARCHIES

Line 1074: FND_GLOBAL.USER_ID,

1070: NUMBER_OF_VERSIONS,
1071: INCLUDE_ALL_TOP_MEMBERS,
1072: INCLUDE_ALL_LEVELS,
1073: sysdate,
1074: FND_GLOBAL.USER_ID,
1075: FND_GLOBAL.LOGIN_ID,
1076: sysdate,
1077: FND_GLOBAL.USER_ID
1078: from ZPB_BUSAREA_HIERARCHIES

Line 1075: FND_GLOBAL.LOGIN_ID,

1071: INCLUDE_ALL_TOP_MEMBERS,
1072: INCLUDE_ALL_LEVELS,
1073: sysdate,
1074: FND_GLOBAL.USER_ID,
1075: FND_GLOBAL.LOGIN_ID,
1076: sysdate,
1077: FND_GLOBAL.USER_ID
1078: from ZPB_BUSAREA_HIERARCHIES
1079: where VERSION_ID = l_from_version_id;

Line 1077: FND_GLOBAL.USER_ID

1073: sysdate,
1074: FND_GLOBAL.USER_ID,
1075: FND_GLOBAL.LOGIN_ID,
1076: sysdate,
1077: FND_GLOBAL.USER_ID
1078: from ZPB_BUSAREA_HIERARCHIES
1079: where VERSION_ID = l_from_version_id;
1080:
1081: insert into ZPB_BUSAREA_HIER_MEMBERS

Line 1100: FND_GLOBAL.USER_ID,

1096: MEMBER_ID,
1097: VALUE_SET_ID,
1098: HIER_VERSION_ID,
1099: sysdate,
1100: FND_GLOBAL.USER_ID,
1101: FND_GLOBAL.LOGIN_ID,
1102: sysdate,
1103: FND_GLOBAL.USER_ID
1104: from ZPB_BUSAREA_HIER_MEMBERS

Line 1101: FND_GLOBAL.LOGIN_ID,

1097: VALUE_SET_ID,
1098: HIER_VERSION_ID,
1099: sysdate,
1100: FND_GLOBAL.USER_ID,
1101: FND_GLOBAL.LOGIN_ID,
1102: sysdate,
1103: FND_GLOBAL.USER_ID
1104: from ZPB_BUSAREA_HIER_MEMBERS
1105: where VERSION_ID = l_from_version_id;

Line 1103: FND_GLOBAL.USER_ID

1099: sysdate,
1100: FND_GLOBAL.USER_ID,
1101: FND_GLOBAL.LOGIN_ID,
1102: sysdate,
1103: FND_GLOBAL.USER_ID
1104: from ZPB_BUSAREA_HIER_MEMBERS
1105: where VERSION_ID = l_from_version_id;
1106:
1107: insert into ZPB_BUSAREA_HIER_VERSIONS

Line 1124: FND_GLOBAL.USER_ID,

1120: HIERARCHY_ID,
1121: HIER_VERSION_ID,
1122: INCLUDE_ALL_TOP_MEMBERS,
1123: sysdate,
1124: FND_GLOBAL.USER_ID,
1125: FND_GLOBAL.LOGIN_ID,
1126: sysdate,
1127: FND_GLOBAL.USER_ID
1128: from ZPB_BUSAREA_HIER_VERSIONS

Line 1125: FND_GLOBAL.LOGIN_ID,

1121: HIER_VERSION_ID,
1122: INCLUDE_ALL_TOP_MEMBERS,
1123: sysdate,
1124: FND_GLOBAL.USER_ID,
1125: FND_GLOBAL.LOGIN_ID,
1126: sysdate,
1127: FND_GLOBAL.USER_ID
1128: from ZPB_BUSAREA_HIER_VERSIONS
1129: where VERSION_ID = l_from_version_id;

Line 1127: FND_GLOBAL.USER_ID

1123: sysdate,
1124: FND_GLOBAL.USER_ID,
1125: FND_GLOBAL.LOGIN_ID,
1126: sysdate,
1127: FND_GLOBAL.USER_ID
1128: from ZPB_BUSAREA_HIER_VERSIONS
1129: where VERSION_ID = l_from_version_id;
1130:
1131: insert into ZPB_BUSAREA_LEVELS

Line 1146: FND_GLOBAL.USER_ID,

1142: LOGICAL_DIM_ID,-- "Consistent Dimension"
1143: HIERARCHY_ID,
1144: LEVEL_ID,
1145: sysdate,
1146: FND_GLOBAL.USER_ID,
1147: FND_GLOBAL.LOGIN_ID,
1148: sysdate,
1149: FND_GLOBAL.USER_ID
1150: from ZPB_BUSAREA_LEVELS

Line 1147: FND_GLOBAL.LOGIN_ID,

1143: HIERARCHY_ID,
1144: LEVEL_ID,
1145: sysdate,
1146: FND_GLOBAL.USER_ID,
1147: FND_GLOBAL.LOGIN_ID,
1148: sysdate,
1149: FND_GLOBAL.USER_ID
1150: from ZPB_BUSAREA_LEVELS
1151: where VERSION_ID = l_from_version_id;

Line 1149: FND_GLOBAL.USER_ID

1145: sysdate,
1146: FND_GLOBAL.USER_ID,
1147: FND_GLOBAL.LOGIN_ID,
1148: sysdate,
1149: FND_GLOBAL.USER_ID
1150: from ZPB_BUSAREA_LEVELS
1151: where VERSION_ID = l_from_version_id;
1152:
1153: insert into ZPB_BUSAREA_ATTRIBUTES

Line 1166: FND_GLOBAL.USER_ID,

1162: select l_to_version_id,
1163: LOGICAL_DIM_ID,-- "Consistent Dimension"
1164: ATTRIBUTE_ID,
1165: sysdate,
1166: FND_GLOBAL.USER_ID,
1167: FND_GLOBAL.LOGIN_ID,
1168: sysdate,
1169: FND_GLOBAL.USER_ID
1170: from ZPB_BUSAREA_ATTRIBUTES

Line 1167: FND_GLOBAL.LOGIN_ID,

1163: LOGICAL_DIM_ID,-- "Consistent Dimension"
1164: ATTRIBUTE_ID,
1165: sysdate,
1166: FND_GLOBAL.USER_ID,
1167: FND_GLOBAL.LOGIN_ID,
1168: sysdate,
1169: FND_GLOBAL.USER_ID
1170: from ZPB_BUSAREA_ATTRIBUTES
1171: where VERSION_ID = l_from_version_id;

Line 1169: FND_GLOBAL.USER_ID

1165: sysdate,
1166: FND_GLOBAL.USER_ID,
1167: FND_GLOBAL.LOGIN_ID,
1168: sysdate,
1169: FND_GLOBAL.USER_ID
1170: from ZPB_BUSAREA_ATTRIBUTES
1171: where VERSION_ID = l_from_version_id;
1172:
1173: insert into ZPB_BUSAREA_CONDITIONS

Line 1192: FND_GLOBAL.USER_ID,

1188: VALUE,
1189: VALUE_SET_ID,
1190: OPERATION,
1191: sysdate,
1192: FND_GLOBAL.USER_ID,
1193: FND_GLOBAL.LOGIN_ID,
1194: sysdate,
1195: FND_GLOBAL.USER_ID
1196: from ZPB_BUSAREA_CONDITIONS

Line 1193: FND_GLOBAL.LOGIN_ID,

1189: VALUE_SET_ID,
1190: OPERATION,
1191: sysdate,
1192: FND_GLOBAL.USER_ID,
1193: FND_GLOBAL.LOGIN_ID,
1194: sysdate,
1195: FND_GLOBAL.USER_ID
1196: from ZPB_BUSAREA_CONDITIONS
1197: where VERSION_ID = l_from_version_id;

Line 1195: FND_GLOBAL.USER_ID

1191: sysdate,
1192: FND_GLOBAL.USER_ID,
1193: FND_GLOBAL.LOGIN_ID,
1194: sysdate,
1195: FND_GLOBAL.USER_ID
1196: from ZPB_BUSAREA_CONDITIONS
1197: where VERSION_ID = l_from_version_id;
1198:
1199: insert into ZPB_BUSAREA_DATASETS

Line 1210: FND_GLOBAL.USER_ID,

1206: LAST_UPDATED_BY)
1207: select l_to_version_id,
1208: DATASET_ID,
1209: sysdate,
1210: FND_GLOBAL.USER_ID,
1211: FND_GLOBAL.LOGIN_ID,
1212: sysdate,
1213: FND_GLOBAL.USER_ID
1214: from ZPB_BUSAREA_DATASETS

Line 1211: FND_GLOBAL.LOGIN_ID,

1207: select l_to_version_id,
1208: DATASET_ID,
1209: sysdate,
1210: FND_GLOBAL.USER_ID,
1211: FND_GLOBAL.LOGIN_ID,
1212: sysdate,
1213: FND_GLOBAL.USER_ID
1214: from ZPB_BUSAREA_DATASETS
1215: where VERSION_ID = l_from_version_id;

Line 1213: FND_GLOBAL.USER_ID

1209: sysdate,
1210: FND_GLOBAL.USER_ID,
1211: FND_GLOBAL.LOGIN_ID,
1212: sysdate,
1213: FND_GLOBAL.USER_ID
1214: from ZPB_BUSAREA_DATASETS
1215: where VERSION_ID = l_from_version_id;
1216:
1217: insert into ZPB_BUSAREA_LEDGERS

Line 1228: FND_GLOBAL.USER_ID,

1224: LAST_UPDATED_BY)
1225: select l_to_version_id,
1226: LEDGER_ID,
1227: sysdate,
1228: FND_GLOBAL.USER_ID,
1229: FND_GLOBAL.LOGIN_ID,
1230: sysdate,
1231: FND_GLOBAL.USER_ID
1232: from ZPB_BUSAREA_LEDGERS

Line 1229: FND_GLOBAL.LOGIN_ID,

1225: select l_to_version_id,
1226: LEDGER_ID,
1227: sysdate,
1228: FND_GLOBAL.USER_ID,
1229: FND_GLOBAL.LOGIN_ID,
1230: sysdate,
1231: FND_GLOBAL.USER_ID
1232: from ZPB_BUSAREA_LEDGERS
1233: where VERSION_ID = l_from_version_id;

Line 1231: FND_GLOBAL.USER_ID

1227: sysdate,
1228: FND_GLOBAL.USER_ID,
1229: FND_GLOBAL.LOGIN_ID,
1230: sysdate,
1231: FND_GLOBAL.USER_ID
1232: from ZPB_BUSAREA_LEDGERS
1233: where VERSION_ID = l_from_version_id;
1234:
1235: if (p_to_version_type = 'P') then

Line 1238: PUBLISHED_BY = FND_GLOBAL.USER_ID

1234:
1235: if (p_to_version_type = 'P') then
1236: update ZPB_BUSINESS_AREAS
1237: set PUBLISH_DATE = sysdate,
1238: PUBLISHED_BY = FND_GLOBAL.USER_ID
1239: where BUSINESS_AREA_ID = p_to_busarea_id;
1240: elsif (p_to_version_type = 'R') then
1241: update ZPB_BUSINESS_AREAS
1242: set REFRESH_DATE = sysdate,

Line 1243: REFRESHED_BY = FND_GLOBAL.USER_ID

1239: where BUSINESS_AREA_ID = p_to_busarea_id;
1240: elsif (p_to_version_type = 'R') then
1241: update ZPB_BUSINESS_AREAS
1242: set REFRESH_DATE = sysdate,
1243: REFRESHED_BY = FND_GLOBAL.USER_ID
1244: where BUSINESS_AREA_ID = p_to_busarea_id;
1245: end if;
1246:
1247: return l_to_version_id;

Line 1375: P_USER_ID => FND_GLOBAL.USER_ID,

1371:
1372: if (l_snapshot_id is not null) then
1373: FEM_FOLDERS_UTL_PKG.ASSIGN_USER_TO_FOLDER
1374: (P_API_VERSION => 1.0,
1375: P_USER_ID => FND_GLOBAL.USER_ID,
1376: P_FOLDER_ID => 1100,
1377: P_WRITE_FLAG => 'Y',
1378: X_MSG_COUNT => l_msg_count,
1379: X_MSG_DATA => ERRBUF,

Line 1552: p_business_area_id, FND_GLOBAL.USER_ID);

1548: end;
1549:
1550: if (l_folder_count > 0) then
1551: zpb_bism.delete_bism_folder_wo_security('oracle/apps/zpb/BusArea' ||
1552: p_business_area_id, FND_GLOBAL.USER_ID);
1553: end if;
1554:
1555: end DELETE_BUSINESS_AREA;
1556:

Line 1568: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1564: is
1565: begin
1566: update ZPB_USERS
1567: set LAST_BUSAREA_LOGIN = 'N',
1568: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1569: LAST_UPDATE_DATE = sysdate
1570: where USER_ID = FND_GLOBAL.USER_ID
1571: and BUSINESS_AREA_ID <> p_business_area_id;
1572:

Line 1570: where USER_ID = FND_GLOBAL.USER_ID

1566: update ZPB_USERS
1567: set LAST_BUSAREA_LOGIN = 'N',
1568: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1569: LAST_UPDATE_DATE = sysdate
1570: where USER_ID = FND_GLOBAL.USER_ID
1571: and BUSINESS_AREA_ID <> p_business_area_id;
1572:
1573: update ZPB_USERS
1574: set LAST_BUSAREA_LOGIN = 'Y',

Line 1576: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1572:
1573: update ZPB_USERS
1574: set LAST_BUSAREA_LOGIN = 'Y',
1575: LAST_LOGIN_DATE = sysdate,
1576: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1577: LAST_UPDATE_DATE = sysdate,
1578: SHADOW_ID = FND_GLOBAL.USER_ID
1579: where USER_ID = FND_GLOBAL.USER_ID
1580: and BUSINESS_AREA_ID = p_business_area_id;

Line 1578: SHADOW_ID = FND_GLOBAL.USER_ID

1574: set LAST_BUSAREA_LOGIN = 'Y',
1575: LAST_LOGIN_DATE = sysdate,
1576: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1577: LAST_UPDATE_DATE = sysdate,
1578: SHADOW_ID = FND_GLOBAL.USER_ID
1579: where USER_ID = FND_GLOBAL.USER_ID
1580: and BUSINESS_AREA_ID = p_business_area_id;
1581: end LOGIN;
1582:

Line 1579: where USER_ID = FND_GLOBAL.USER_ID

1575: LAST_LOGIN_DATE = sysdate,
1576: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1577: LAST_UPDATE_DATE = sysdate,
1578: SHADOW_ID = FND_GLOBAL.USER_ID
1579: where USER_ID = FND_GLOBAL.USER_ID
1580: and BUSINESS_AREA_ID = p_business_area_id;
1581: end LOGIN;
1582:
1583: -------------------------------------------------------------------------

Line 1916: FND_GLOBAL.USER_ID,

1912: values
1913: (p_business_area_id,
1914: p_user_id,
1915: sysdate,
1916: FND_GLOBAL.USER_ID,
1917: FND_GLOBAL.LOGIN_ID,
1918: sysdate,
1919: FND_GLOBAL.USER_ID);
1920:

Line 1917: FND_GLOBAL.LOGIN_ID,

1913: (p_business_area_id,
1914: p_user_id,
1915: sysdate,
1916: FND_GLOBAL.USER_ID,
1917: FND_GLOBAL.LOGIN_ID,
1918: sysdate,
1919: FND_GLOBAL.USER_ID);
1920:
1921: end ADD_USER;

Line 1919: FND_GLOBAL.USER_ID);

1915: sysdate,
1916: FND_GLOBAL.USER_ID,
1917: FND_GLOBAL.LOGIN_ID,
1918: sysdate,
1919: FND_GLOBAL.USER_ID);
1920:
1921: end ADD_USER;
1922:
1923: -------------------------------------------------------------------------