APPS.MSC_SD_RP_MASS_PKG dependencies on MSC_ORP_MASS_UPDATE_COLUMNS_B

Line 23: insert into MSC_ORP_MASS_UPDATE_COLUMNS_B (

19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21:
22: begin
23: insert into MSC_ORP_MASS_UPDATE_COLUMNS_B (
24: TABLE_NAME,
25: COLUMN_NAME,
26: VALUE_TYPE,
27: OPERATION_LOV_SQL,

Line 146: update MSC_ORP_MASS_UPDATE_COLUMNS_B set

142: ) is
143:
144:
145: begin
146: update MSC_ORP_MASS_UPDATE_COLUMNS_B set
147: OPERATION_LOV_SQL = X_OPERATION_LOV_SQL,
148: VALUE_TYPE = X_VALUE_TYPE,
149: VALUE_LOV_NAME = X_VALUE_LOV_NAME,
150: DEPENDENT_COLUMN = X_DEPENDENT_COLUMN,

Line 201: from MSC_ORP_MASS_UPDATE_COLUMNS_B T

197: db_ludate date; -- entity update date in db
198:
199: cursor EXISTING_ROW is
200: select T.COLUMN_NAME
201: from MSC_ORP_MASS_UPDATE_COLUMNS_B T
202: where T.TABLE_NAME = X_TABLE_NAME
203: AND T.COLUMN_NAME =X_COLUMN_NAME;
204:
205:

Line 236: from MSC_ORP_MASS_UPDATE_COLUMNS_B

232: else
233:
234: select LAST_UPDATED_BY, LAST_UPDATE_DATE
235: into db_luby, db_ludate
236: from MSC_ORP_MASS_UPDATE_COLUMNS_B
237: where TABLE_NAME = x_TABLE_NAME
238: and COLUMN_NAME = X_COLUMN_NAME;
239:
240: