APPS.UMX_REG_SERVICES_PKG dependencies on UMX_REG_SERVICES_B

Line 27: cursor C is select ROWID from UMX_REG_SERVICES_B

23: X_LAST_UPDATED_BY in NUMBER,
24: X_LAST_UPDATE_LOGIN in NUMBER,
25: X_WF_BUS_LOGIC_EVENT_GUID in RAW
26: ) is
27: cursor C is select ROWID from UMX_REG_SERVICES_B
28: where REG_SERVICE_CODE = X_REG_SERVICE_CODE
29: ;
30: begin
31:

Line 33: insert into UMX_REG_SERVICES_B (

29: ;
30: begin
31:
32:
33: insert into UMX_REG_SERVICES_B (
34: REG_SERVICE_CODE,
35: REG_SERVICE_TYPE,
36: WF_NOTIFICATION_EVENT_GUID,
37: EMAIL_VERIFICATION_FLAG,

Line 148: from UMX_REG_SERVICES_B

144: REG_FUNCTION_ID,
145: AME_APPLICATION_ID,
146: AME_TRANSACTION_TYPE_ID,
147: WF_BUS_LOGIC_EVENT_GUID
148: from UMX_REG_SERVICES_B
149: where REG_SERVICE_CODE = X_REG_SERVICE_CODE
150: for update of REG_SERVICE_CODE nowait;
151: recinfo c%rowtype;
152:

Line 236: update UMX_REG_SERVICES_B set

232: X_LAST_UPDATE_LOGIN in NUMBER,
233: X_WF_BUS_LOGIC_EVENT_GUID in RAW
234: ) is
235: begin
236: update UMX_REG_SERVICES_B set
237: REG_SERVICE_TYPE = X_REG_SERVICE_TYPE,
238: WF_NOTIFICATION_EVENT_GUID = X_WF_NOTIFICATION_EVENT_GUID,
239: EMAIL_VERIFICATION_FLAG = X_EMAIL_VERIFICATION_FLAG,
240: APPLICATION_ID = X_APPLICATION_ID,

Line 285: delete from UMX_REG_SERVICES_B

281: if (sql%notfound) then
282: raise no_data_found;
283: end if;
284:
285: delete from UMX_REG_SERVICES_B
286: where REG_SERVICE_CODE = X_REG_SERVICE_CODE;
287:
288: if (sql%notfound) then
289: raise no_data_found;

Line 299: from UMX_REG_SERVICES_B B

295: begin
296: delete from UMX_REG_SERVICES_TL T
297: where not exists
298: (select NULL
299: from UMX_REG_SERVICES_B B
300: where B.REG_SERVICE_CODE = T.REG_SERVICE_CODE
301: );
302:
303: update UMX_REG_SERVICES_TL T set (

Line 542: from umx_reg_services_b

538:
539: --db last update date and updated by for this regsvc code
540: select last_updated_by, last_update_date
541: into db_luby, db_ludate
542: from umx_reg_services_b
543: where reg_service_code = X_REG_SERVICE_CODE;
544: -- test if this is a update and if it fails then create a new entry
545: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
546: db_ludate, X_CUSTOM_MODE)) then