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.MSD_TRANSLATE_LEVEL_VALUES dependencies on FND_GLOBAL

Line 429: FND_GLOBAL.USER_ID || ', ' ||

425: 'attribute4, ' ||
426: 'attribute5, ' ||
427: v_sql_stmt1 || --jarorad
428: 'sysdate, ' ||
429: FND_GLOBAL.USER_ID || ', ' ||
430: 'sysdate, ' ||
431: FND_GLOBAL.USER_ID || ' ' ||
432: 'from ' ||
433: p_source_table ;

Line 431: FND_GLOBAL.USER_ID || ' ' ||

427: v_sql_stmt1 || --jarorad
428: 'sysdate, ' ||
429: FND_GLOBAL.USER_ID || ', ' ||
430: 'sysdate, ' ||
431: FND_GLOBAL.USER_ID || ' ' ||
432: 'from ' ||
433: p_source_table ;
434:
435: /* Following filter causes a performance hit. We'll colect duplicates

Line 470: FND_GLOBAL.USER_ID || ', ' ||

466: p_level_value_pk_column||', ' ||
467: p_parent_level_id || ', ' ||
468: p_parent_value_pk_column ||', ' ||
469: 'sysdate, ' ||
470: FND_GLOBAL.USER_ID || ', ' ||
471: 'sysdate, ' ||
472: FND_GLOBAL.USER_ID || ' ' ||
473: 'from ' ||
474: p_source_table ;

Line 472: FND_GLOBAL.USER_ID || ' ' ||

468: p_parent_value_pk_column ||', ' ||
469: 'sysdate, ' ||
470: FND_GLOBAL.USER_ID || ', ' ||
471: 'sysdate, ' ||
472: FND_GLOBAL.USER_ID || ' ' ||
473: 'from ' ||
474: p_source_table ;
475:
476: ins(v_sql_stmt);

Line 712: sysdate, FND_GLOBAL.USER_ID,

708: VALUES( p_instance_id, p_level_id, a_level_value(j),
709: a_sr_level_pk(j), MSD_COMMON_UTILITIES.get_level_pk(),
710: a_level_value_desc(j),
711: 'I', p_seq_num, p_seq_num,
712: sysdate, FND_GLOBAL.USER_ID,
713: sysdate, FND_GLOBAL.USER_ID,
714: FND_GLOBAL.LOGIN_ID, a_attribute1(j), a_attribute2(j),
715: a_attribute3(j), a_attribute4(j), a_attribute5(j),
716: a_system_attribute1(j), a_system_attribute2(j), --jarorad

Line 713: sysdate, FND_GLOBAL.USER_ID,

709: a_sr_level_pk(j), MSD_COMMON_UTILITIES.get_level_pk(),
710: a_level_value_desc(j),
711: 'I', p_seq_num, p_seq_num,
712: sysdate, FND_GLOBAL.USER_ID,
713: sysdate, FND_GLOBAL.USER_ID,
714: FND_GLOBAL.LOGIN_ID, a_attribute1(j), a_attribute2(j),
715: a_attribute3(j), a_attribute4(j), a_attribute5(j),
716: a_system_attribute1(j), a_system_attribute2(j), --jarorad
717: a_dp_enabled_flag(j) ); --jarorad

Line 714: FND_GLOBAL.LOGIN_ID, a_attribute1(j), a_attribute2(j),

710: a_level_value_desc(j),
711: 'I', p_seq_num, p_seq_num,
712: sysdate, FND_GLOBAL.USER_ID,
713: sysdate, FND_GLOBAL.USER_ID,
714: FND_GLOBAL.LOGIN_ID, a_attribute1(j), a_attribute2(j),
715: a_attribute3(j), a_attribute4(j), a_attribute5(j),
716: a_system_attribute1(j), a_system_attribute2(j), --jarorad
717: a_dp_enabled_flag(j) ); --jarorad
718: END IF;

Line 819: sysdate, FND_GLOBAL.USER_ID, sysdate,

815: last_updated_by, last_update_login)
816: VALUES(p_instance_id, p_level_id,
817: a_sr_level_pk(j), a_level_pk(j),
818: a_crn(j) , p_seq_num,
819: sysdate, FND_GLOBAL.USER_ID, sysdate,
820: FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);
821:
822: /* VM - To be implemented
823: 1. We should mark data deleted from msd_cs_Data for deleted level

Line 820: FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);

816: VALUES(p_instance_id, p_level_id,
817: a_sr_level_pk(j), a_level_pk(j),
818: a_crn(j) , p_seq_num,
819: sysdate, FND_GLOBAL.USER_ID, sysdate,
820: FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);
821:
822: /* VM - To be implemented
823: 1. We should mark data deleted from msd_cs_Data for deleted level
824: values

Line 921: sysdate, FND_GLOBAL.USER_ID,

917: creation_date, created_by, last_update_login,
918: created_by_refresh_num, last_refresh_num, action_code)
919: VALUES(p_instance_id, p_level_id, a_sr_level_pk(i),
920: p_parent_level_id, a_sr_parent_level_pk(i),
921: sysdate, FND_GLOBAL.USER_ID,
922: sysdate,FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID,
923: p_seq_num, p_seq_num, 'I');
924: END IF;
925: END IF; /* End of New Association */

Line 922: sysdate,FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID,

918: created_by_refresh_num, last_refresh_num, action_code)
919: VALUES(p_instance_id, p_level_id, a_sr_level_pk(i),
920: p_parent_level_id, a_sr_parent_level_pk(i),
921: sysdate, FND_GLOBAL.USER_ID,
922: sysdate,FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID,
923: p_seq_num, p_seq_num, 'I');
924: END IF;
925: END IF; /* End of New Association */
926:

Line 1088: 'sysdate, ' || FND_GLOBAL.USER_ID || ', ' ||

1084: p_parent_value_column || ', ' ||
1085: p_parent_value_pk_column ||', ' ||
1086: p_parent_level_id || ', ' ||
1087: 'parent_desc_alias' ||', ' ||
1088: 'sysdate, ' || FND_GLOBAL.USER_ID || ', ' ||
1089: 'sysdate, ' || FND_GLOBAL.USER_ID || ' ' ||
1090: 'FROM ' ||
1091: '(select distinct ' || p_parent_value_column || ', ' ||
1092: p_parent_value_pk_column || ', ' ||

Line 1089: 'sysdate, ' || FND_GLOBAL.USER_ID || ' ' ||

1085: p_parent_value_pk_column ||', ' ||
1086: p_parent_level_id || ', ' ||
1087: 'parent_desc_alias' ||', ' ||
1088: 'sysdate, ' || FND_GLOBAL.USER_ID || ', ' ||
1089: 'sysdate, ' || FND_GLOBAL.USER_ID || ' ' ||
1090: 'FROM ' ||
1091: '(select distinct ' || p_parent_value_column || ', ' ||
1092: p_parent_value_pk_column || ', ' ||
1093: p_parent_level_id || ', '||

Line 1195: FND_GLOBAL.USER_ID || ', ' ||

1191: 'base_uom, ' ||
1192: 'item_type_id, ' ||
1193: 'forecast_type_id, ' ||
1194: 'sysdate, ' ||
1195: FND_GLOBAL.USER_ID || ', ' ||
1196: 'sysdate, ' ||
1197: FND_GLOBAL.USER_ID || ', ' ||
1198: FND_GLOBAL.USER_ID || ' ' ||
1199: 'FROM ' ||

Line 1197: FND_GLOBAL.USER_ID || ', ' ||

1193: 'forecast_type_id, ' ||
1194: 'sysdate, ' ||
1195: FND_GLOBAL.USER_ID || ', ' ||
1196: 'sysdate, ' ||
1197: FND_GLOBAL.USER_ID || ', ' ||
1198: FND_GLOBAL.USER_ID || ' ' ||
1199: 'FROM ' ||
1200: ' msd_sr_item_list_price_v' || x_dblink ||
1201: ' where sr_item_pk in (select to_number(decode(ltrim(sr_level_pk, ''.0123456789''),' ||

Line 1198: FND_GLOBAL.USER_ID || ' ' ||

1194: 'sysdate, ' ||
1195: FND_GLOBAL.USER_ID || ', ' ||
1196: 'sysdate, ' ||
1197: FND_GLOBAL.USER_ID || ', ' ||
1198: FND_GLOBAL.USER_ID || ' ' ||
1199: 'FROM ' ||
1200: ' msd_sr_item_list_price_v' || x_dblink ||
1201: ' where sr_item_pk in (select to_number(decode(ltrim(sr_level_pk, ''.0123456789''),' ||
1202: ' null, sr_level_pk, null)) ' ||

Line 1265: sysdate, FND_GLOBAL.USER_ID, sysdate,

1261: INSERT INTO msd_deleted_item_list_price(instance, sr_item_pk, created_by_refresh_num,
1262: creation_date, created_by, last_update_date,
1263: last_updated_by, last_update_login)
1264: VALUES(p_instance_id, a_sr_item_pk(j), p_seq_num,
1265: sysdate, FND_GLOBAL.USER_ID, sysdate,
1266: FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);
1267: */
1268: END IF;
1269:

Line 1266: FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);

1262: creation_date, created_by, last_update_date,
1263: last_updated_by, last_update_login)
1264: VALUES(p_instance_id, a_sr_item_pk(j), p_seq_num,
1265: sysdate, FND_GLOBAL.USER_ID, sysdate,
1266: FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID);
1267: */
1268: END IF;
1269:
1270: EXCEPTION

Line 1342: sysdate, FND_GLOBAL.USER_ID,

1338: rec_st_rows.avg_discount, rec_st_rows.base_uom,
1339: rec_st_rows.sr_item_pk, rec_st_rows.item_type_id,
1340: rec_st_rows.forecast_type_id,
1341: 'I', p_seq_num, p_seq_num,
1342: sysdate, FND_GLOBAL.USER_ID,
1343: sysdate, FND_GLOBAL.USER_ID,
1344: FND_GLOBAL.LOGIN_ID);
1345:
1346: ELSE

Line 1343: sysdate, FND_GLOBAL.USER_ID,

1339: rec_st_rows.sr_item_pk, rec_st_rows.item_type_id,
1340: rec_st_rows.forecast_type_id,
1341: 'I', p_seq_num, p_seq_num,
1342: sysdate, FND_GLOBAL.USER_ID,
1343: sysdate, FND_GLOBAL.USER_ID,
1344: FND_GLOBAL.LOGIN_ID);
1345:
1346: ELSE
1347:

Line 1344: FND_GLOBAL.LOGIN_ID);

1340: rec_st_rows.forecast_type_id,
1341: 'I', p_seq_num, p_seq_num,
1342: sysdate, FND_GLOBAL.USER_ID,
1343: sysdate, FND_GLOBAL.USER_ID,
1344: FND_GLOBAL.LOGIN_ID);
1345:
1346: ELSE
1347:
1348: /* If this row exists in the fact then check row has been

Line 1517: fnd_global.user_id,

1513: a.sr_org_pk,
1514: a.calendar_type,
1515: a.calendar_code,
1516: sysdate,
1517: fnd_global.user_id,
1518: sysdate,
1519: fnd_global.user_id
1520: from
1521: (select distinct

Line 1519: fnd_global.user_id

1515: a.calendar_code,
1516: sysdate,
1517: fnd_global.user_id,
1518: sysdate,
1519: fnd_global.user_id
1520: from
1521: (select distinct
1522: instance,
1523: sr_org_pk,

Line 1543: fnd_global.user_id || ', ' ||

1539: ' mod.organization_id' || ', ' ||
1540: '''' || p_man_cal_type || '''' || ', ' ||
1541: ' mod.calendar_code' || ', ' ||
1542: ' sysdate' || ', ' ||
1543: fnd_global.user_id || ', ' ||
1544: ' sysdate' || ', ' ||
1545: fnd_global.user_id || ' ' ||
1546: ' From MSD_ORGANIZATION_DEFINITIONS' || x_dblink || ' MOD';
1547: v_stmt := v_stmt || ' where exists (select 1 from msd_app_instance_orgs' || x_dblink || ' maio where MOD.organization_id = MAIO.organization_id)';

Line 1545: fnd_global.user_id || ' ' ||

1541: ' mod.calendar_code' || ', ' ||
1542: ' sysdate' || ', ' ||
1543: fnd_global.user_id || ', ' ||
1544: ' sysdate' || ', ' ||
1545: fnd_global.user_id || ' ' ||
1546: ' From MSD_ORGANIZATION_DEFINITIONS' || x_dblink || ' MOD';
1547: v_stmt := v_stmt || ' where exists (select 1 from msd_app_instance_orgs' || x_dblink || ' maio where MOD.organization_id = MAIO.organization_id)';
1548:
1549: execute immediate v_stmt;

Line 1673: fnd_global.user_id,

1669: a.sr_level_pk,
1670: a.org_level_id,
1671: a.org_sr_level_pk,
1672: sysdate,
1673: fnd_global.user_id,
1674: sysdate,
1675: fnd_global.user_id
1676: from
1677: (select distinct

Line 1675: fnd_global.user_id

1671: a.org_sr_level_pk,
1672: sysdate,
1673: fnd_global.user_id,
1674: sysdate,
1675: fnd_global.user_id
1676: from
1677: (select distinct
1678: instance,
1679: level_id,

Line 1703: fnd_global.user_id || ', ' ||

1699: ' src.level_value_pk ' || ', ' ||
1700: ' src.org_level_id ' || ', ' ||
1701: ' src.org_level_value_pk ' || ', ' ||
1702: ' sysdate ' || ', ' ||
1703: fnd_global.user_id || ', ' ||
1704: ' sysdate ' || ', ' ||
1705: fnd_global.user_id || ' ' ||
1706: ' From ' || p_org_relationship_view || x_dblink || ' src';
1707:

Line 1705: fnd_global.user_id || ' ' ||

1701: ' src.org_level_value_pk ' || ', ' ||
1702: ' sysdate ' || ', ' ||
1703: fnd_global.user_id || ', ' ||
1704: ' sysdate ' || ', ' ||
1705: fnd_global.user_id || ' ' ||
1706: ' From ' || p_org_relationship_view || x_dblink || ' src';
1707:
1708: execute immediate v_stmt;
1709:

Line 1764: fnd_global.user_id,

1760: null,
1761: null,
1762: p_seq_num,
1763: sysdate,
1764: fnd_global.user_id,
1765: sysdate,
1766: fnd_global.user_id
1767: );
1768:

Line 1766: fnd_global.user_id

1762: p_seq_num,
1763: sysdate,
1764: fnd_global.user_id,
1765: sysdate,
1766: fnd_global.user_id
1767: );
1768:
1769: END;
1770: