APPS.MSC_SD_RP_MASS_PKG dependencies on MSC_ORP_MASS_UPDATE_COLUMNS_TL

Line 49: insert into MSC_ORP_MASS_UPDATE_COLUMNS_TL (

45: X_LAST_UPDATED_BY,
46: X_LAST_UPDATE_LOGIN
47: );
48:
49: insert into MSC_ORP_MASS_UPDATE_COLUMNS_TL (
50: TABLE_NAME,
51: COLUMN_NAME,
52: FIELD_NAME,
53: CREATED_BY,

Line 75: from MSC_ORP_MASS_UPDATE_COLUMNS_TL T

71: from FND_LANGUAGES L
72: where L.INSTALLED_FLAG in ('I', 'B')
73: and not exists
74: (select NULL
75: from MSC_ORP_MASS_UPDATE_COLUMNS_TL T
76: where T.TABLE_NAME = X_TABLE_NAME
77: AND T.COLUMN_NAME= X_COLUMN_NAME
78: and T.LANGUAGE = L.LANGUAGE_CODE);
79:

Line 108: from MSC_ORP_MASS_UPDATE_COLUMNS_TL

104: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
105:
106: select last_updated_by, last_update_date
107: into db_luby, db_ludate
108: from MSC_ORP_MASS_UPDATE_COLUMNS_TL
109: where TABLE_NAME = X_TABLE_NAME
110: and COLUMN_NAME = X_COLUMN_NAME
111: and language = userenv('LANG');
112:

Line 115: update MSC_ORP_MASS_UPDATE_COLUMNS_TL set

111: and language = userenv('LANG');
112:
113: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
114: db_ludate, X_CUSTOM_MODE)) then
115: update MSC_ORP_MASS_UPDATE_COLUMNS_TL set
116: FIELD_NAME = X_FIELD_NAME,
117: last_update_date = f_ludate,
118: last_updated_by = f_luby,
119: last_update_login = 0,

Line 162: update MSC_ORP_MASS_UPDATE_COLUMNS_TL set

158: if (sql%notfound) then
159: raise no_data_found;
160: end if;
161:
162: update MSC_ORP_MASS_UPDATE_COLUMNS_TL set
163: FIELD_NAME = X_FIELD_NAME,
164: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
165: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
166: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 269: insert into msc_orp_mass_update_columns_tl (

265: procedure ADD_LANGUAGE
266: is
267: begin
268:
269: insert into msc_orp_mass_update_columns_tl (
270: TABLE_NAME ,
271: COLUMN_NAME ,
272: LANGUAGE ,
273: SOURCE_LANG ,

Line 291: from msc_orp_mass_update_columns_tl B, FND_LANGUAGES L

287: B.LAST_UPDATED_BY,
288: B.CREATION_DATE,
289: B.CREATED_BY,
290: B.LAST_UPDATE_LOGIN
291: from msc_orp_mass_update_columns_tl B, FND_LANGUAGES L
292: where L.INSTALLED_FLAG in ('I', 'B')
293: and B.LANGUAGE = userenv('LANG')
294: and not exists
295: (select NULL

Line 296: from msc_orp_mass_update_columns_tl T

292: where L.INSTALLED_FLAG in ('I', 'B')
293: and B.LANGUAGE = userenv('LANG')
294: and not exists
295: (select NULL
296: from msc_orp_mass_update_columns_tl T
297: where T.table_name = B.table_name
298: and T.column_name = B.column_name
299: and T.LANGUAGE = L.LANGUAGE_CODE);
300: end ADD_LANGUAGE;