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.

APPS.ZPB_METADATA_PKG dependencies on FND_GLOBAL

Line 52: CREATED_BY = FND_GLOBAL.USER_ID,

48: PERS_TABLE_ID = l_dimension_rec.PersTableId,
49: SHAR_CWM_NAME = l_dimension_rec.SharCWMName,
50: SHAR_TABLE_ID = l_dimension_rec.SharTableId,
51: ANNOTATION_DIM = l_dimension_rec.AnnotationDim,
52: CREATED_BY = FND_GLOBAL.USER_ID,
53: CREATION_DATE = sysdate,
54: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
55: LAST_UPDATE_DATE = sysdate,
56: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 54: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

50: SHAR_TABLE_ID = l_dimension_rec.SharTableId,
51: ANNOTATION_DIM = l_dimension_rec.AnnotationDim,
52: CREATED_BY = FND_GLOBAL.USER_ID,
53: CREATION_DATE = sysdate,
54: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
55: LAST_UPDATE_DATE = sysdate,
56: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
57:
58: where dimension_id = l_dimension_rec.DimensionId;

Line 56: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

52: CREATED_BY = FND_GLOBAL.USER_ID,
53: CREATION_DATE = sysdate,
54: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
55: LAST_UPDATE_DATE = sysdate,
56: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
57:
58: where dimension_id = l_dimension_rec.DimensionId;
59:
60:

Line 112: FND_GLOBAL.USER_ID,

108: l_dimension_rec.PersTableId,
109: l_dimension_rec.SharCWMName,
110: l_dimension_rec.SharTableId,
111: l_dimension_rec.AnnotationDim,
112: FND_GLOBAL.USER_ID,
113: sysdate,
114: FND_GLOBAL.USER_ID,
115: sysdate,
116: FND_GLOBAL.LOGIN_ID

Line 114: FND_GLOBAL.USER_ID,

110: l_dimension_rec.SharTableId,
111: l_dimension_rec.AnnotationDim,
112: FND_GLOBAL.USER_ID,
113: sysdate,
114: FND_GLOBAL.USER_ID,
115: sysdate,
116: FND_GLOBAL.LOGIN_ID
117: );
118:

Line 116: FND_GLOBAL.LOGIN_ID

112: FND_GLOBAL.USER_ID,
113: sysdate,
114: FND_GLOBAL.USER_ID,
115: sysdate,
116: FND_GLOBAL.LOGIN_ID
117: );
118:
119: end if;
120:

Line 158: CREATED_BY = FND_GLOBAL.USER_ID,

154: update zpb_tables
155: set
156: AW_NAME = l_table_rec.AwName,
157: TABLE_TYPE = l_table_rec.TableType,
158: CREATED_BY = FND_GLOBAL.USER_ID,
159: CREATION_DATE = sysdate,
160: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
161: LAST_UPDATE_DATE = sysdate,
162: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 160: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

156: AW_NAME = l_table_rec.AwName,
157: TABLE_TYPE = l_table_rec.TableType,
158: CREATED_BY = FND_GLOBAL.USER_ID,
159: CREATION_DATE = sysdate,
160: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
161: LAST_UPDATE_DATE = sysdate,
162: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
163: where table_id = l_table_rec.TableId;
164:

Line 162: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

158: CREATED_BY = FND_GLOBAL.USER_ID,
159: CREATION_DATE = sysdate,
160: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
161: LAST_UPDATE_DATE = sysdate,
162: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
163: where table_id = l_table_rec.TableId;
164:
165: exception
166: when NO_DATA_FOUND then

Line 194: FND_GLOBAL.USER_ID,

190: bus_area_id_num,
191: l_table_rec.TableId,
192: l_table_rec.TableName,
193: l_table_rec.TableType,
194: FND_GLOBAL.USER_ID,
195: sysdate,
196: FND_GLOBAL.USER_ID,
197: sysdate,
198: FND_GLOBAL.LOGIN_ID

Line 196: FND_GLOBAL.USER_ID,

192: l_table_rec.TableName,
193: l_table_rec.TableType,
194: FND_GLOBAL.USER_ID,
195: sysdate,
196: FND_GLOBAL.USER_ID,
197: sysdate,
198: FND_GLOBAL.LOGIN_ID
199: );
200:

Line 198: FND_GLOBAL.LOGIN_ID

194: FND_GLOBAL.USER_ID,
195: sysdate,
196: FND_GLOBAL.USER_ID,
197: sysdate,
198: FND_GLOBAL.LOGIN_ID
199: );
200:
201: end if;
202:

Line 234: CREATED_BY = FND_GLOBAL.USER_ID,

230: AW_NAME = l_col_rec.AwName,
231: COLUMN_NAME = l_col_rec.ColumnName,
232: COLUMN_TYPE = l_col_rec.ColumnType,
233: TABLE_ID = l_col_rec.TableId,
234: CREATED_BY = FND_GLOBAL.USER_ID,
235: CREATION_DATE = sysdate,
236: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
237: LAST_UPDATE_DATE = sysdate,
238: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 236: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

232: COLUMN_TYPE = l_col_rec.ColumnType,
233: TABLE_ID = l_col_rec.TableId,
234: CREATED_BY = FND_GLOBAL.USER_ID,
235: CREATION_DATE = sysdate,
236: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
237: LAST_UPDATE_DATE = sysdate,
238: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
239: where column_id = l_col_rec.ColumnId;
240:

Line 238: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

234: CREATED_BY = FND_GLOBAL.USER_ID,
235: CREATION_DATE = sysdate,
236: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
237: LAST_UPDATE_DATE = sysdate,
238: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
239: where column_id = l_col_rec.ColumnId;
240:
241:
242: exception

Line 266: FND_GLOBAL.USER_ID,

262: l_col_rec.AwName,
263: l_col_rec.ColumnName,
264: l_col_rec.ColumnType,
265: l_col_rec.TableId,
266: FND_GLOBAL.USER_ID,
267: sysdate,
268: FND_GLOBAL.USER_ID,
269: sysdate,
270: FND_GLOBAL.LOGIN_ID

Line 268: FND_GLOBAL.USER_ID,

264: l_col_rec.ColumnType,
265: l_col_rec.TableId,
266: FND_GLOBAL.USER_ID,
267: sysdate,
268: FND_GLOBAL.USER_ID,
269: sysdate,
270: FND_GLOBAL.LOGIN_ID
271: );
272: end;

Line 270: FND_GLOBAL.LOGIN_ID

266: FND_GLOBAL.USER_ID,
267: sysdate,
268: FND_GLOBAL.USER_ID,
269: sysdate,
270: FND_GLOBAL.LOGIN_ID
271: );
272: end;
273:
274: return l_col_rec.ColumnId;

Line 306: CREATED_BY = FND_GLOBAL.USER_ID,

302: DIMENSION_ID = l_level_rec.DimensionId,
303: EPB_ID = l_level_rec.EpbId,
304: SHAR_CWM_NAME = l_level_rec.SharCWMName,
305: PERS_LEVEL_FLAG = l_level_rec.PersLevelFlag,
306: CREATED_BY = FND_GLOBAL.USER_ID,
307: CREATION_DATE = sysdate,
308: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
309: LAST_UPDATE_DATE = sysdate,
310: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 308: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

304: SHAR_CWM_NAME = l_level_rec.SharCWMName,
305: PERS_LEVEL_FLAG = l_level_rec.PersLevelFlag,
306: CREATED_BY = FND_GLOBAL.USER_ID,
307: CREATION_DATE = sysdate,
308: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
309: LAST_UPDATE_DATE = sysdate,
310: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
311: where level_id = l_level_rec.LevelId;
312:

Line 310: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

306: CREATED_BY = FND_GLOBAL.USER_ID,
307: CREATION_DATE = sysdate,
308: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
309: LAST_UPDATE_DATE = sysdate,
310: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
311: where level_id = l_level_rec.LevelId;
312:
313: exception
314: when NO_DATA_FOUND then

Line 339: FND_GLOBAL.USER_ID,

335: l_level_rec.EpbId,
336: l_level_rec.LevelId,
337: l_level_rec.SharCWMName,
338: l_level_rec.PersLevelFlag,
339: FND_GLOBAL.USER_ID,
340: sysdate,
341: FND_GLOBAL.USER_ID,
342: sysdate,
343: FND_GLOBAL.LOGIN_ID

Line 341: FND_GLOBAL.USER_ID,

337: l_level_rec.SharCWMName,
338: l_level_rec.PersLevelFlag,
339: FND_GLOBAL.USER_ID,
340: sysdate,
341: FND_GLOBAL.USER_ID,
342: sysdate,
343: FND_GLOBAL.LOGIN_ID
344: );
345: end;

Line 343: FND_GLOBAL.LOGIN_ID

339: FND_GLOBAL.USER_ID,
340: sysdate,
341: FND_GLOBAL.USER_ID,
342: sysdate,
343: FND_GLOBAL.LOGIN_ID
344: );
345: end;
346:
347: return l_level_rec.LevelId;

Line 377: CREATED_BY = FND_GLOBAL.USER_ID,

373:
374: LEVEL_ORDER = l_hier_level_rec.LevelOrder,
375: PERS_COL_ID = l_hier_level_rec.PersColId,
376: SHAR_COL_ID = l_hier_level_rec.SharColId,
377: CREATED_BY = FND_GLOBAL.USER_ID,
378: CREATION_DATE = sysdate,
379: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
380: LAST_UPDATE_DATE = sysdate,
381: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 379: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

375: PERS_COL_ID = l_hier_level_rec.PersColId,
376: SHAR_COL_ID = l_hier_level_rec.SharColId,
377: CREATED_BY = FND_GLOBAL.USER_ID,
378: CREATION_DATE = sysdate,
379: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
380: LAST_UPDATE_DATE = sysdate,
381: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
382: where relation_id = l_hier_level_rec.RelationId;
383:

Line 381: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

377: CREATED_BY = FND_GLOBAL.USER_ID,
378: CREATION_DATE = sysdate,
379: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
380: LAST_UPDATE_DATE = sysdate,
381: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
382: where relation_id = l_hier_level_rec.RelationId;
383:
384: exception
385: when NO_DATA_FOUND then

Line 410: FND_GLOBAL.USER_ID,

406: l_hier_level_rec.LevelOrder,
407: l_hier_level_rec.PersColId,
408: l_hier_level_rec.RelationId,
409: l_hier_level_rec.SharColId,
410: FND_GLOBAL.USER_ID,
411: sysdate,
412: FND_GLOBAL.USER_ID,
413: sysdate,
414: FND_GLOBAL.LOGIN_ID

Line 412: FND_GLOBAL.USER_ID,

408: l_hier_level_rec.RelationId,
409: l_hier_level_rec.SharColId,
410: FND_GLOBAL.USER_ID,
411: sysdate,
412: FND_GLOBAL.USER_ID,
413: sysdate,
414: FND_GLOBAL.LOGIN_ID
415: );
416:

Line 414: FND_GLOBAL.LOGIN_ID

410: FND_GLOBAL.USER_ID,
411: sysdate,
412: FND_GLOBAL.USER_ID,
413: sysdate,
414: FND_GLOBAL.LOGIN_ID
415: );
416:
417: end;
418:

Line 454: CREATED_BY = FND_GLOBAL.USER_ID,

450: SHAR_CWM_NAME = l_attr_rec.SharCWMName,
451: TYPE = l_attr_rec.Type,
452: PERS_CWM_NAME = l_attr_rec.PersCWMName,
453: FEM_ATTRIBUTE_ID = l_attr_rec.FEMAttrId,
454: CREATED_BY = FND_GLOBAL.USER_ID,
455: CREATION_DATE = sysdate,
456: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
457: LAST_UPDATE_DATE = sysdate,
458: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 456: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

452: PERS_CWM_NAME = l_attr_rec.PersCWMName,
453: FEM_ATTRIBUTE_ID = l_attr_rec.FEMAttrId,
454: CREATED_BY = FND_GLOBAL.USER_ID,
455: CREATION_DATE = sysdate,
456: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
457: LAST_UPDATE_DATE = sysdate,
458: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
459: where attribute_id = l_attr_rec.AttributeId;
460:

Line 458: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

454: CREATED_BY = FND_GLOBAL.USER_ID,
455: CREATION_DATE = sysdate,
456: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
457: LAST_UPDATE_DATE = sysdate,
458: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
459: where attribute_id = l_attr_rec.AttributeId;
460:
461: exception
462: when NO_DATA_FOUND then

Line 494: FND_GLOBAL.USER_ID,

490: l_attr_rec.SharCWMName,
491: l_attr_rec.Type,
492: l_attr_rec.PersCWMName,
493: l_attr_rec.FEMAttrId,
494: FND_GLOBAL.USER_ID,
495: sysdate,
496: FND_GLOBAL.USER_ID,
497: sysdate,
498: FND_GLOBAL.LOGIN_ID

Line 496: FND_GLOBAL.USER_ID,

492: l_attr_rec.PersCWMName,
493: l_attr_rec.FEMAttrId,
494: FND_GLOBAL.USER_ID,
495: sysdate,
496: FND_GLOBAL.USER_ID,
497: sysdate,
498: FND_GLOBAL.LOGIN_ID
499: );
500:

Line 498: FND_GLOBAL.LOGIN_ID

494: FND_GLOBAL.USER_ID,
495: sysdate,
496: FND_GLOBAL.USER_ID,
497: sysdate,
498: FND_GLOBAL.LOGIN_ID
499: );
500:
501: end;
502:

Line 533: CREATED_BY = FND_GLOBAL.USER_ID,

529:
530: update zpb_attr_table_col
531: set
532:
533: CREATED_BY = FND_GLOBAL.USER_ID,
534: CREATION_DATE = sysdate,
535: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
536: LAST_UPDATE_DATE = sysdate,
537: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 535: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

531: set
532:
533: CREATED_BY = FND_GLOBAL.USER_ID,
534: CREATION_DATE = sysdate,
535: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
536: LAST_UPDATE_DATE = sysdate,
537: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
538: where relation_id = l_attr_table_col_rec.RelationId;
539:

Line 537: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

533: CREATED_BY = FND_GLOBAL.USER_ID,
534: CREATION_DATE = sysdate,
535: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
536: LAST_UPDATE_DATE = sysdate,
537: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
538: where relation_id = l_attr_table_col_rec.RelationId;
539:
540: exception
541: when NO_DATA_FOUND then

Line 562: FND_GLOBAL.USER_ID,

558: l_attr_table_col_rec.AttributeId,
559: l_attr_table_col_rec.ColumnId,
560: l_attr_table_col_rec.RelationId,
561: l_attr_table_col_rec.TableId,
562: FND_GLOBAL.USER_ID,
563: sysdate,
564: FND_GLOBAL.USER_ID,
565: sysdate,
566: FND_GLOBAL.LOGIN_ID

Line 564: FND_GLOBAL.USER_ID,

560: l_attr_table_col_rec.RelationId,
561: l_attr_table_col_rec.TableId,
562: FND_GLOBAL.USER_ID,
563: sysdate,
564: FND_GLOBAL.USER_ID,
565: sysdate,
566: FND_GLOBAL.LOGIN_ID
567: );
568:

Line 566: FND_GLOBAL.LOGIN_ID

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

Line 601: CREATED_BY = FND_GLOBAL.USER_ID,

597: update zpb_cube_dims
598: set
599:
600: COLUMN_ID = l_cube_dims_rec.ColumnId,
601: CREATED_BY = FND_GLOBAL.USER_ID,
602: CREATION_DATE = sysdate,
603: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
604: LAST_UPDATE_DATE = sysdate,
605: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 603: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

599:
600: COLUMN_ID = l_cube_dims_rec.ColumnId,
601: CREATED_BY = FND_GLOBAL.USER_ID,
602: CREATION_DATE = sysdate,
603: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
604: LAST_UPDATE_DATE = sysdate,
605: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
606: where relation_id = l_cube_dims_rec.RelationId;
607:

Line 605: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

601: CREATED_BY = FND_GLOBAL.USER_ID,
602: CREATION_DATE = sysdate,
603: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
604: LAST_UPDATE_DATE = sysdate,
605: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
606: where relation_id = l_cube_dims_rec.RelationId;
607:
608: exception
609: when NO_DATA_FOUND then

Line 631: FND_GLOBAL.USER_ID,

627: l_cube_dims_rec.ColumnId,
628: l_cube_dims_rec.CubeId,
629: l_cube_dims_rec.DimensionId,
630: l_cube_dims_rec.RelationId,
631: FND_GLOBAL.USER_ID,
632: sysdate,
633: FND_GLOBAL.USER_ID,
634: sysdate,
635: FND_GLOBAL.LOGIN_ID

Line 633: FND_GLOBAL.USER_ID,

629: l_cube_dims_rec.DimensionId,
630: l_cube_dims_rec.RelationId,
631: FND_GLOBAL.USER_ID,
632: sysdate,
633: FND_GLOBAL.USER_ID,
634: sysdate,
635: FND_GLOBAL.LOGIN_ID
636: );
637:

Line 635: FND_GLOBAL.LOGIN_ID

631: FND_GLOBAL.USER_ID,
632: sysdate,
633: FND_GLOBAL.USER_ID,
634: sysdate,
635: FND_GLOBAL.LOGIN_ID
636: );
637:
638: end;
639:

Line 669: CREATED_BY = FND_GLOBAL.USER_ID,

665: update zpb_cube_hier
666: set
667:
668: COLUMN_ID = l_cube_hier_rec.ColumnId,
669: CREATED_BY = FND_GLOBAL.USER_ID,
670: CREATION_DATE = sysdate,
671: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
672: LAST_UPDATE_DATE = sysdate,
673: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 671: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

667:
668: COLUMN_ID = l_cube_hier_rec.ColumnId,
669: CREATED_BY = FND_GLOBAL.USER_ID,
670: CREATION_DATE = sysdate,
671: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
672: LAST_UPDATE_DATE = sysdate,
673: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
674: where relation_id = l_cube_hier_rec.RelationId;
675:

Line 673: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

669: CREATED_BY = FND_GLOBAL.USER_ID,
670: CREATION_DATE = sysdate,
671: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
672: LAST_UPDATE_DATE = sysdate,
673: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
674: where relation_id = l_cube_hier_rec.RelationId;
675:
676: exception
677: when NO_DATA_FOUND then

Line 698: FND_GLOBAL.USER_ID,

694: l_cube_hier_rec.ColumnId,
695: l_cube_hier_rec.CubeId,
696: l_cube_hier_rec.HierarchyId,
697: l_cube_hier_rec.RelationId,
698: FND_GLOBAL.USER_ID,
699: sysdate,
700: FND_GLOBAL.USER_ID,
701: sysdate,
702: FND_GLOBAL.LOGIN_ID

Line 700: FND_GLOBAL.USER_ID,

696: l_cube_hier_rec.HierarchyId,
697: l_cube_hier_rec.RelationId,
698: FND_GLOBAL.USER_ID,
699: sysdate,
700: FND_GLOBAL.USER_ID,
701: sysdate,
702: FND_GLOBAL.LOGIN_ID
703: );
704:

Line 702: FND_GLOBAL.LOGIN_ID

698: FND_GLOBAL.USER_ID,
699: sysdate,
700: FND_GLOBAL.USER_ID,
701: sysdate,
702: FND_GLOBAL.LOGIN_ID
703: );
704:
705: end;
706:

Line 750: CREATED_BY = FND_GLOBAL.USER_ID,

746: SELECTED_CUR = l_measure_rec.SelectedCur,
747: NAME = l_measure_rec.Name,
748: CURRENCY_REL = l_measure_rec.CurrencyRel,
749: CPR_MEASURE = l_measure_rec.CPRMeasure,
750: CREATED_BY = FND_GLOBAL.USER_ID,
751: CREATION_DATE = sysdate,
752: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
753: LAST_UPDATE_DATE = sysdate,
754: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 752: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

748: CURRENCY_REL = l_measure_rec.CurrencyRel,
749: CPR_MEASURE = l_measure_rec.CPRMeasure,
750: CREATED_BY = FND_GLOBAL.USER_ID,
751: CREATION_DATE = sysdate,
752: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
753: LAST_UPDATE_DATE = sysdate,
754: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
755: where measure_id = l_measure_rec.MeasureId;
756:

Line 754: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

750: CREATED_BY = FND_GLOBAL.USER_ID,
751: CREATION_DATE = sysdate,
752: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
753: LAST_UPDATE_DATE = sysdate,
754: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
755: where measure_id = l_measure_rec.MeasureId;
756:
757: exception
758: when NO_DATA_FOUND then

Line 805: FND_GLOBAL.USER_ID,

801: l_measure_rec.SelectedCur,
802: l_measure_rec.Name,
803: l_measure_rec.CurrencyRel,
804: l_measure_rec.CPRMeasure,
805: FND_GLOBAL.USER_ID,
806: sysdate,
807: FND_GLOBAL.USER_ID,
808: sysdate,
809: FND_GLOBAL.LOGIN_ID

Line 807: FND_GLOBAL.USER_ID,

803: l_measure_rec.CurrencyRel,
804: l_measure_rec.CPRMeasure,
805: FND_GLOBAL.USER_ID,
806: sysdate,
807: FND_GLOBAL.USER_ID,
808: sysdate,
809: FND_GLOBAL.LOGIN_ID
810: );
811: end;

Line 809: FND_GLOBAL.LOGIN_ID

805: FND_GLOBAL.USER_ID,
806: sysdate,
807: FND_GLOBAL.USER_ID,
808: sysdate,
809: FND_GLOBAL.LOGIN_ID
810: );
811: end;
812:
813: return l_measure_rec.MeasureId;

Line 854: FND_GLOBAL.USER_ID,

850: l_attributes_tl_rec.LongName,
851: l_attributes_tl_rec.Name,
852: l_attributes_tl_rec.PluralLongName,
853: l_attributes_tl_rec.PluralName,
854: FND_GLOBAL.USER_ID,
855: sysdate,
856: FND_GLOBAL.USER_ID,
857: sysdate,
858: FND_GLOBAL.LOGIN_ID

Line 856: FND_GLOBAL.USER_ID,

852: l_attributes_tl_rec.PluralLongName,
853: l_attributes_tl_rec.PluralName,
854: FND_GLOBAL.USER_ID,
855: sysdate,
856: FND_GLOBAL.USER_ID,
857: sysdate,
858: FND_GLOBAL.LOGIN_ID
859: );
860:

Line 858: FND_GLOBAL.LOGIN_ID

854: FND_GLOBAL.USER_ID,
855: sysdate,
856: FND_GLOBAL.USER_ID,
857: sysdate,
858: FND_GLOBAL.LOGIN_ID
859: );
860:
861: end insertAttributesTLRecord;
862:

Line 901: FND_GLOBAL.USER_ID,

897: l_dimensions_tl_rec.LongName,
898: l_dimensions_tl_rec.Name,
899: l_dimensions_tl_rec.PluralLongName,
900: l_dimensions_tl_rec.PluralName,
901: FND_GLOBAL.USER_ID,
902: sysdate,
903: FND_GLOBAL.USER_ID,
904: sysdate,
905: FND_GLOBAL.LOGIN_ID

Line 903: FND_GLOBAL.USER_ID,

899: l_dimensions_tl_rec.PluralLongName,
900: l_dimensions_tl_rec.PluralName,
901: FND_GLOBAL.USER_ID,
902: sysdate,
903: FND_GLOBAL.USER_ID,
904: sysdate,
905: FND_GLOBAL.LOGIN_ID
906: );
907:

Line 905: FND_GLOBAL.LOGIN_ID

901: FND_GLOBAL.USER_ID,
902: sysdate,
903: FND_GLOBAL.USER_ID,
904: sysdate,
905: FND_GLOBAL.LOGIN_ID
906: );
907:
908: end insertDimensionsTLRecord;
909:

Line 937: CREATED_BY = FND_GLOBAL.USER_ID,

933: HIER_TYPE = l_hierarchies_rec.HierType,
934: PERS_TABLE_ID = l_hierarchies_rec.PersTableId,
935: SHAR_CWM_NAME = l_hierarchies_rec.SharCWMName,
936: SHAR_TABLE_ID = l_hierarchies_rec.SharTableId,
937: CREATED_BY = FND_GLOBAL.USER_ID,
938: CREATION_DATE = sysdate,
939: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
940: LAST_UPDATE_DATE = sysdate,
941: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 939: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

935: SHAR_CWM_NAME = l_hierarchies_rec.SharCWMName,
936: SHAR_TABLE_ID = l_hierarchies_rec.SharTableId,
937: CREATED_BY = FND_GLOBAL.USER_ID,
938: CREATION_DATE = sysdate,
939: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
940: LAST_UPDATE_DATE = sysdate,
941: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
942: where hierarchy_id = l_hierarchies_rec.HierarchyId;
943:

Line 941: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

937: CREATED_BY = FND_GLOBAL.USER_ID,
938: CREATION_DATE = sysdate,
939: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
940: LAST_UPDATE_DATE = sysdate,
941: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
942: where hierarchy_id = l_hierarchies_rec.HierarchyId;
943:
944: exception
945: when NO_DATA_FOUND then

Line 975: FND_GLOBAL.USER_ID,

971: l_hierarchies_rec.PersCWMName,
972: l_hierarchies_rec.PersTableId,
973: l_hierarchies_rec.SharCWMName,
974: l_hierarchies_rec.SharTableId,
975: FND_GLOBAL.USER_ID,
976: sysdate,
977: FND_GLOBAL.USER_ID,
978: sysdate,
979: FND_GLOBAL.LOGIN_ID

Line 977: FND_GLOBAL.USER_ID,

973: l_hierarchies_rec.SharCWMName,
974: l_hierarchies_rec.SharTableId,
975: FND_GLOBAL.USER_ID,
976: sysdate,
977: FND_GLOBAL.USER_ID,
978: sysdate,
979: FND_GLOBAL.LOGIN_ID
980: );
981:

Line 979: FND_GLOBAL.LOGIN_ID

975: FND_GLOBAL.USER_ID,
976: sysdate,
977: FND_GLOBAL.USER_ID,
978: sysdate,
979: FND_GLOBAL.LOGIN_ID
980: );
981:
982: end;
983:

Line 1031: FND_GLOBAL.USER_ID,

1027: l_hierarchies_tl_rec.LongName,
1028: l_hierarchies_tl_rec.Name,
1029: l_hierarchies_tl_rec.PluralLongName,
1030: l_hierarchies_tl_rec.PluralName,
1031: FND_GLOBAL.USER_ID,
1032: sysdate,
1033: FND_GLOBAL.USER_ID,
1034: sysdate,
1035: FND_GLOBAL.LOGIN_ID

Line 1033: FND_GLOBAL.USER_ID,

1029: l_hierarchies_tl_rec.PluralLongName,
1030: l_hierarchies_tl_rec.PluralName,
1031: FND_GLOBAL.USER_ID,
1032: sysdate,
1033: FND_GLOBAL.USER_ID,
1034: sysdate,
1035: FND_GLOBAL.LOGIN_ID
1036: );
1037:

Line 1035: FND_GLOBAL.LOGIN_ID

1031: FND_GLOBAL.USER_ID,
1032: sysdate,
1033: FND_GLOBAL.USER_ID,
1034: sysdate,
1035: FND_GLOBAL.LOGIN_ID
1036: );
1037:
1038: else
1039:

Line 1047: CREATED_BY = FND_GLOBAL.USER_ID,

1043: LONG_NAME = l_hierarchies_tl_rec.LongName,
1044: NAME = l_hierarchies_tl_rec.Name,
1045: PLURAL_LONG_NAME = l_hierarchies_tl_rec.PluralLongName,
1046: PLURAL_NAME = l_hierarchies_tl_rec.PluralName,
1047: CREATED_BY = FND_GLOBAL.USER_ID,
1048: CREATION_DATE = sysdate,
1049: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1050: LAST_UPDATE_DATE = sysdate,
1051: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 1049: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1045: PLURAL_LONG_NAME = l_hierarchies_tl_rec.PluralLongName,
1046: PLURAL_NAME = l_hierarchies_tl_rec.PluralName,
1047: CREATED_BY = FND_GLOBAL.USER_ID,
1048: CREATION_DATE = sysdate,
1049: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1050: LAST_UPDATE_DATE = sysdate,
1051: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1052: where hierarchy_id = l_hierarchies_tl_rec.HierarchyId and
1053: language = l_hierarchies_tl_rec.Language;

Line 1051: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1047: CREATED_BY = FND_GLOBAL.USER_ID,
1048: CREATION_DATE = sysdate,
1049: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1050: LAST_UPDATE_DATE = sysdate,
1051: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1052: where hierarchy_id = l_hierarchies_tl_rec.HierarchyId and
1053: language = l_hierarchies_tl_rec.Language;
1054:
1055: end if;

Line 1085: CREATED_BY = FND_GLOBAL.USER_ID,

1081: LONG_NAME = l_levels_tl_rec.LongName,
1082: NAME = l_levels_tl_rec.Name,
1083: PLURAL_LONG_NAME = l_levels_tl_rec.PluralLongName,
1084: PLURAL_NAME = l_levels_tl_rec.PluralName,
1085: CREATED_BY = FND_GLOBAL.USER_ID,
1086: CREATION_DATE = sysdate,
1087: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1088: LAST_UPDATE_DATE = sysdate,
1089: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 1087: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1083: PLURAL_LONG_NAME = l_levels_tl_rec.PluralLongName,
1084: PLURAL_NAME = l_levels_tl_rec.PluralName,
1085: CREATED_BY = FND_GLOBAL.USER_ID,
1086: CREATION_DATE = sysdate,
1087: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1088: LAST_UPDATE_DATE = sysdate,
1089: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1090: where level_id = l_levels_tl_rec.LevelId and
1091: language = l_levels_tl_rec.Language;

Line 1089: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1085: CREATED_BY = FND_GLOBAL.USER_ID,
1086: CREATION_DATE = sysdate,
1087: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1088: LAST_UPDATE_DATE = sysdate,
1089: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1090: where level_id = l_levels_tl_rec.LevelId and
1091: language = l_levels_tl_rec.Language;
1092:
1093: else

Line 1117: FND_GLOBAL.USER_ID,

1113: l_levels_tl_rec.LongName,
1114: l_levels_tl_rec.Name,
1115: l_levels_tl_rec.PluralLongName,
1116: l_levels_tl_rec.PluralName,
1117: FND_GLOBAL.USER_ID,
1118: sysdate,
1119: FND_GLOBAL.USER_ID,
1120: sysdate,
1121: FND_GLOBAL.LOGIN_ID

Line 1119: FND_GLOBAL.USER_ID,

1115: l_levels_tl_rec.PluralLongName,
1116: l_levels_tl_rec.PluralName,
1117: FND_GLOBAL.USER_ID,
1118: sysdate,
1119: FND_GLOBAL.USER_ID,
1120: sysdate,
1121: FND_GLOBAL.LOGIN_ID
1122: );
1123: end if;

Line 1121: FND_GLOBAL.LOGIN_ID

1117: FND_GLOBAL.USER_ID,
1118: sysdate,
1119: FND_GLOBAL.USER_ID,
1120: sysdate,
1121: FND_GLOBAL.LOGIN_ID
1122: );
1123: end if;
1124:
1125: end insertLevelTLRecord;

Line 1203: CREATED_BY = FND_GLOBAL.USER_ID,

1199: set
1200: EPB_ID = l_cube_rec.EpbId,
1201: TABLE_ID = l_cube_rec.TableId,
1202: TYPE = l_cube_rec.Type,
1203: CREATED_BY = FND_GLOBAL.USER_ID,
1204: CREATION_DATE = sysdate,
1205: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1206: LAST_UPDATE_DATE = sysdate,
1207: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 1205: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1201: TABLE_ID = l_cube_rec.TableId,
1202: TYPE = l_cube_rec.Type,
1203: CREATED_BY = FND_GLOBAL.USER_ID,
1204: CREATION_DATE = sysdate,
1205: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1206: LAST_UPDATE_DATE = sysdate,
1207: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1208: where cube_id = l_cube_rec.CubeId;
1209:

Line 1207: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1203: CREATED_BY = FND_GLOBAL.USER_ID,
1204: CREATION_DATE = sysdate,
1205: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1206: LAST_UPDATE_DATE = sysdate,
1207: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1208: where cube_id = l_cube_rec.CubeId;
1209:
1210: exception
1211: when NO_DATA_FOUND then

Line 1243: FND_GLOBAL.USER_ID,

1239: l_cube_rec.EpbId,
1240: l_cube_rec.Name,
1241: l_cube_rec.TableId,
1242: l_cube_rec.Type,
1243: FND_GLOBAL.USER_ID,
1244: sysdate,
1245: FND_GLOBAL.USER_ID,
1246: sysdate,
1247: FND_GLOBAL.LOGIN_ID

Line 1245: FND_GLOBAL.USER_ID,

1241: l_cube_rec.TableId,
1242: l_cube_rec.Type,
1243: FND_GLOBAL.USER_ID,
1244: sysdate,
1245: FND_GLOBAL.USER_ID,
1246: sysdate,
1247: FND_GLOBAL.LOGIN_ID
1248: );
1249:

Line 1247: FND_GLOBAL.LOGIN_ID

1243: FND_GLOBAL.USER_ID,
1244: sysdate,
1245: FND_GLOBAL.USER_ID,
1246: sysdate,
1247: FND_GLOBAL.LOGIN_ID
1248: );
1249:
1250: end if;
1251:

Line 1277: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID);

1273: select scope_id into l_hier_scope_rec.ScopeId
1274: from zpb_hier_scope
1275: where hierarchy_id = l_hier_scope_rec.HierarchyId and
1276: user_id = l_hier_scope_rec.UserId and
1277: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID);
1278:
1279: update zpb_hier_scope
1280: set
1281:

Line 1283: CREATED_BY = FND_GLOBAL.USER_ID,

1279: update zpb_hier_scope
1280: set
1281:
1282: PERS_TABLE_ID = l_hier_scope_rec.PersTableId,
1283: CREATED_BY = FND_GLOBAL.USER_ID,
1284: CREATION_DATE = sysdate,
1285: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1286: LAST_UPDATE_DATE = sysdate,
1287: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 1285: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1281:
1282: PERS_TABLE_ID = l_hier_scope_rec.PersTableId,
1283: CREATED_BY = FND_GLOBAL.USER_ID,
1284: CREATION_DATE = sysdate,
1285: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1286: LAST_UPDATE_DATE = sysdate,
1287: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1288: where scope_id = l_hier_scope_rec.ScopeId;
1289:

Line 1287: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1283: CREATED_BY = FND_GLOBAL.USER_ID,
1284: CREATION_DATE = sysdate,
1285: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1286: LAST_UPDATE_DATE = sysdate,
1287: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1288: where scope_id = l_hier_scope_rec.ScopeId;
1289:
1290: exception
1291: when NO_DATA_FOUND then

Line 1316: nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID),

1312: l_hier_scope_rec.HierarchyId,
1313: l_hier_scope_rec.ScopeId,
1314: l_hier_scope_rec.StartDate,
1315: l_hier_scope_rec.UserId,
1316: nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID),
1317: l_hier_scope_rec.PersTableId,
1318: FND_GLOBAL.USER_ID,
1319: sysdate,
1320: FND_GLOBAL.USER_ID,

Line 1318: FND_GLOBAL.USER_ID,

1314: l_hier_scope_rec.StartDate,
1315: l_hier_scope_rec.UserId,
1316: nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID),
1317: l_hier_scope_rec.PersTableId,
1318: FND_GLOBAL.USER_ID,
1319: sysdate,
1320: FND_GLOBAL.USER_ID,
1321: sysdate,
1322: FND_GLOBAL.LOGIN_ID

Line 1320: FND_GLOBAL.USER_ID,

1316: nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID),
1317: l_hier_scope_rec.PersTableId,
1318: FND_GLOBAL.USER_ID,
1319: sysdate,
1320: FND_GLOBAL.USER_ID,
1321: sysdate,
1322: FND_GLOBAL.LOGIN_ID
1323: );
1324:

Line 1322: FND_GLOBAL.LOGIN_ID

1318: FND_GLOBAL.USER_ID,
1319: sysdate,
1320: FND_GLOBAL.USER_ID,
1321: sysdate,
1322: FND_GLOBAL.LOGIN_ID
1323: );
1324:
1325: end;
1326:

Line 1352: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID);

1348: from zpb_hier_level_scope
1349: where hier_id = l_hier_level_scope_rec.HierId and
1350: level_id = l_hier_level_scope_rec.LevelId and
1351: user_id = l_hier_level_scope_rec.UserId and
1352: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID);
1353:
1354: update zpb_hier_level_scope
1355: set
1356:

Line 1358: CREATED_BY = FND_GLOBAL.USER_ID,

1354: update zpb_hier_level_scope
1355: set
1356:
1357: PERS_COL_ID = l_hier_level_scope_rec.PersColId,
1358: CREATED_BY = FND_GLOBAL.USER_ID,
1359: CREATION_DATE = sysdate,
1360: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1361: LAST_UPDATE_DATE = sysdate,
1362: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 1360: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1356:
1357: PERS_COL_ID = l_hier_level_scope_rec.PersColId,
1358: CREATED_BY = FND_GLOBAL.USER_ID,
1359: CREATION_DATE = sysdate,
1360: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1361: LAST_UPDATE_DATE = sysdate,
1362: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1363: where scope_id = l_hier_level_scope_rec.ScopeId;
1364:

Line 1362: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1358: CREATED_BY = FND_GLOBAL.USER_ID,
1359: CREATION_DATE = sysdate,
1360: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1361: LAST_UPDATE_DATE = sysdate,
1362: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1363: where scope_id = l_hier_level_scope_rec.ScopeId;
1364:
1365: exception
1366: when NO_DATA_FOUND then

Line 1389: nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID),

1385: l_hier_level_scope_rec.LevelId,
1386: l_hier_level_scope_rec.HierId,
1387: l_hier_level_scope_rec.ScopeId,
1388: l_hier_level_scope_rec.UserId,
1389: nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID),
1390: l_hier_level_scope_rec.PersColId,
1391: FND_GLOBAL.USER_ID,
1392: sysdate,
1393: FND_GLOBAL.USER_ID,

Line 1391: FND_GLOBAL.USER_ID,

1387: l_hier_level_scope_rec.ScopeId,
1388: l_hier_level_scope_rec.UserId,
1389: nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID),
1390: l_hier_level_scope_rec.PersColId,
1391: FND_GLOBAL.USER_ID,
1392: sysdate,
1393: FND_GLOBAL.USER_ID,
1394: sysdate,
1395: FND_GLOBAL.LOGIN_ID

Line 1393: FND_GLOBAL.USER_ID,

1389: nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID),
1390: l_hier_level_scope_rec.PersColId,
1391: FND_GLOBAL.USER_ID,
1392: sysdate,
1393: FND_GLOBAL.USER_ID,
1394: sysdate,
1395: FND_GLOBAL.LOGIN_ID
1396: );
1397:

Line 1395: FND_GLOBAL.LOGIN_ID

1391: FND_GLOBAL.USER_ID,
1392: sysdate,
1393: FND_GLOBAL.USER_ID,
1394: sysdate,
1395: FND_GLOBAL.LOGIN_ID
1396: );
1397:
1398: end;
1399:

Line 1425: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID);

1421: select scope_id into l_attribute_scope_rec.ScopeId
1422: from zpb_attribute_scope
1423: where attribute_id = l_attribute_scope_rec.AttributeId and
1424: user_id = l_attribute_scope_rec.UserId and
1425: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID);
1426:
1427: update zpb_attribute_scope
1428: set
1429:

Line 1430: CREATED_BY = FND_GLOBAL.USER_ID,

1426:
1427: update zpb_attribute_scope
1428: set
1429:
1430: CREATED_BY = FND_GLOBAL.USER_ID,
1431: CREATION_DATE = sysdate,
1432: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1433: LAST_UPDATE_DATE = sysdate,
1434: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 1432: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

1428: set
1429:
1430: CREATED_BY = FND_GLOBAL.USER_ID,
1431: CREATION_DATE = sysdate,
1432: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1433: LAST_UPDATE_DATE = sysdate,
1434: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1435: where scope_id = l_attribute_scope_rec.ScopeId;
1436:

Line 1434: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

1430: CREATED_BY = FND_GLOBAL.USER_ID,
1431: CREATION_DATE = sysdate,
1432: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1433: LAST_UPDATE_DATE = sysdate,
1434: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
1435: where scope_id = l_attribute_scope_rec.ScopeId;
1436:
1437: exception
1438: when NO_DATA_FOUND then

Line 1460: nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID),

1456: (
1457: l_attribute_scope_rec.ScopeId,
1458: l_attribute_scope_rec.AttributeId,
1459: l_attribute_scope_rec.UserId,
1460: nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID),
1461: l_attribute_scope_rec.EndDate,
1462: l_attribute_scope_rec.StartDate,
1463: FND_GLOBAL.USER_ID,
1464: sysdate,

Line 1463: FND_GLOBAL.USER_ID,

1459: l_attribute_scope_rec.UserId,
1460: nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID),
1461: l_attribute_scope_rec.EndDate,
1462: l_attribute_scope_rec.StartDate,
1463: FND_GLOBAL.USER_ID,
1464: sysdate,
1465: FND_GLOBAL.USER_ID,
1466: sysdate,
1467: FND_GLOBAL.LOGIN_ID

Line 1465: FND_GLOBAL.USER_ID,

1461: l_attribute_scope_rec.EndDate,
1462: l_attribute_scope_rec.StartDate,
1463: FND_GLOBAL.USER_ID,
1464: sysdate,
1465: FND_GLOBAL.USER_ID,
1466: sysdate,
1467: FND_GLOBAL.LOGIN_ID
1468: );
1469:

Line 1467: FND_GLOBAL.LOGIN_ID

1463: FND_GLOBAL.USER_ID,
1464: sysdate,
1465: FND_GLOBAL.USER_ID,
1466: sysdate,
1467: FND_GLOBAL.LOGIN_ID
1468: );
1469:
1470: end;
1471:

Line 1778: nl varchar2(1) := fnd_global.local_chr(10);

1774: ai number;
1775: aj number;
1776: l_length number;
1777: done boolean;
1778: nl varchar2(1) := fnd_global.local_chr(10);
1779:
1780: l_global_ecm zpb_ecm.global_ecm;
1781: l_dim_data zpb_ecm.dimension_data;
1782: l_range_dim_data zpb_ecm.dimension_data;

Line 3226: nl varchar2(1) := fnd_global.local_chr(10);

3222: hj number;
3223: l_gid boolean;
3224: l_hiers varchar2(1000);
3225: l_hier varchar2(30);
3226: nl varchar2(1) := fnd_global.local_chr(10);
3227: l_dim_ecm zpb_ecm.dimension_ecm;
3228:
3229: -- interface layer table entrieds
3230: m_cube_en zpb_md_records.cubes_entry;

Line 3899: nl varchar2(1) := fnd_global.local_chr(10);

3895: done boolean;
3896: i number;
3897: j number;
3898: entry number;
3899: nl varchar2(1) := fnd_global.local_chr(10);
3900: l_global_ecm zpb_ecm.global_ecm;
3901:
3902: -- measure table entry
3903: m_meas_en zpb_md_records.measures_entry;

Line 4205: nl varchar2(1) := fnd_global.local_chr(10);

4201: l_gid boolean;
4202: l_hiers varchar2(1000);
4203: l_hier varchar2(30);
4204: l_value varchar2(30);
4205: nl varchar2(1) := fnd_global.local_chr(10);
4206: ai number;
4207: aj number;
4208: done boolean;
4209:

Line 4705: nl varchar2(1) := fnd_global.local_chr(10);

4701: l_gid boolean;
4702: l_aw varchar2(30);
4703: l_global_ecm zpb_ecm.global_ecm;
4704: l_dim_ecm zpb_ecm.dimension_ecm;
4705: nl varchar2(1) := fnd_global.local_chr(10);
4706: l_cpr_meas_cube varchar2(64);
4707: l_frmcpr varchar2(16);
4708:
4709: -- md table entries

Line 4767: fnd_global.apps_initialize(p_user_id, p_user_id, fnd_global.RESP_APPL_ID);

4763: -- called at status-sql generation time - need to run full start-up as running
4764: -- on AM connection and shared personal instances may need to be merged
4765: if p_start_up_flag then
4766:
4767: fnd_global.apps_initialize(p_user_id, p_user_id, fnd_global.RESP_APPL_ID);
4768: zpb_security_context.initcontext(p_user_id, p_user_id, sys_context('ZPB_CONTEXT', 'resp_id'),
4769: sys_context('ZPB_CONTEXT', 'session_id'), to_number(p_bus_area_id));
4770:
4771: ZPB_PERSONAL_AW.STARTUP(p_api_version=> 1.0,

Line 4960: nl varchar2(1) := fnd_global.local_chr(10);

4956: l_aw varchar2(30);
4957: l_hiers varchar2(1000);
4958: l_hier varchar2(30);
4959: l_dim varchar2(30);
4960: nl varchar2(1) := fnd_global.local_chr(10);
4961: l_dim_ecm zpb_ecm.dimension_ecm;
4962:
4963: -- md table entries
4964: m_cube_en zpb_md_records.cubes_entry;

Line 5384: nl varchar2(1) := fnd_global.local_chr(10);

5380: lj number;
5381: ai number;
5382: aj number;
5383: l_length number;
5384: nl varchar2(1) := fnd_global.local_chr(10);
5385:
5386: l_global_ecm zpb_ecm.global_ecm;
5387: l_dim_data zpb_ecm.dimension_data;
5388: l_range_dim_data zpb_ecm.dimension_data;

Line 5512: hscope.user_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and

5508: set hscope.pers_table_id = (select pers_table_id
5509: from zpb_hierarchies hier
5510: where hscope.hierarchy_id = hier.hierarchy_id)
5511: where hscope.user_id = l_user_id and
5512: hscope.user_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and
5513: hscope.hierarchy_id in (select hierarchy_id
5514: from zpb_hierarchies hier,
5515: zpb_dimensions dims
5516: where hier.dimension_id = dims.dimension_id and

Line 5643: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and

5639: -- update the zpb_hier_scope entry for this hierarchy to use pesonal personal hierarchy table
5640: update zpb_hier_scope
5641: set pers_table_id = l_pers_column_en.TableId
5642: where user_id = l_user_id and
5643: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and
5644: hierarchy_id = l_hier_scope_en.HierarchyId;
5645:
5646: end if;
5647:

Line 5674: hlevscope.resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and

5670: set hlevscope.pers_col_id = (select pers_col_id from zpb_hier_level hlev
5671: where hlevscope.hier_id = hlev.hier_id and
5672: hlevscope.level_id = hlev.level_id)
5673: where hlevscope.user_id = l_user_id and
5674: hlevscope.resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and
5675: hlevscope.hier_id = l_hier_scope_en.HierarchyId;
5676: end if;
5677:
5678: end if; -- Does this hierarchy have members check

Line 5804: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and

5800: -- delete all scoping entries for this user that have not been updated during the above looping
5801: -- they must have been created previously and are no longer valid
5802: delete zpb_hier_scope
5803: where user_id = l_user_id and
5804: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and
5805: last_update_date < l_start_time and
5806: hierarchy_id in (select hierarchy_id
5807: from zpb_hierarchies hier,
5808: zpb_dimensions dims

Line 5815: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and

5811: dims.dimension_id = l_dimension_id);
5812:
5813: delete zpb_hier_level_scope
5814: where user_id = l_user_id and
5815: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and
5816: last_update_date < l_start_time and
5817: hier_id in (select hierarchy_id
5818: from zpb_hierarchies hier,
5819: zpb_dimensions dims

Line 5826: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and

5822: dims.dimension_id = l_dimension_id);
5823:
5824: delete zpb_attribute_scope
5825: where user_id = l_user_id and
5826: resp_id = nvl(to_number(sys_context('ZPB_CONTEXT', 'resp_id')), FND_GLOBAL.RESP_ID) and
5827: last_update_date < l_start_time and
5828: attribute_id in (select attribute_id
5829: from zpb_attributes attr,
5830: zpb_dimensions dims