DBA Data[Home] [Help]

APPS.OE_PC_VTMPLT_COLS_PKG dependencies on OE_PC_VTMPLTS

Line 68: UPDATE oe_pc_vtmplts

64: RAISE NO_DATA_FOUND;
65: end if;
66: CLOSE CROWID;
67:
68: UPDATE oe_pc_vtmplts
69: SET
70: last_updated_by = x_last_updated_by
71: ,last_update_date = x_last_update_date
72: ,last_update_login = x_last_update_login

Line 159: UPDATE oe_pc_vtmplts

155: ,last_update_date = x_last_update_date
156: ,last_update_login = x_last_update_login
157: WHERE rowid = x_rowid;
158:
159: UPDATE oe_pc_vtmplts
160: SET
161: last_updated_by = x_last_updated_by
162: ,last_update_date = x_last_update_date
163: ,last_update_login = x_last_update_login

Line 175: ----start bug# 10189253,10362212 , we need to update the master table oe_pc_vtmplts

171: x_rowid in varchar2
172: )
173: Is
174: Begin
175: ----start bug# 10189253,10362212 , we need to update the master table oe_pc_vtmplts
176: UPDATE oe_pc_vtmplts
177: SET
178: last_updated_by = FND_GLOBAL.USER_ID
179: ,last_update_date = sysdate

Line 176: UPDATE oe_pc_vtmplts

172: )
173: Is
174: Begin
175: ----start bug# 10189253,10362212 , we need to update the master table oe_pc_vtmplts
176: UPDATE oe_pc_vtmplts
177: SET
178: last_updated_by = FND_GLOBAL.USER_ID
179: ,last_update_date = sysdate
180: ,last_update_login = FND_GLOBAL.LOGIN_ID