APPS.WMS_PARAMETERS_PKG dependencies on WMS_PARAMETERS_B

Line 53: cursor C is select ROWID from WMS_PARAMETERS_B

49: X_LAST_UPDATED_BY in NUMBER,
50: X_LAST_UPDATE_LOGIN in NUMBER,
51: X_USE_FOR_OP_SELECTION_FLAG in VARCHAR2
52: ) is
53: cursor C is select ROWID from WMS_PARAMETERS_B
54: where PARAMETER_ID = X_PARAMETER_ID
55: ;
56: begin
57: insert into WMS_PARAMETERS_B (

Line 57: insert into WMS_PARAMETERS_B (

53: cursor C is select ROWID from WMS_PARAMETERS_B
54: where PARAMETER_ID = X_PARAMETER_ID
55: ;
56: begin
57: insert into WMS_PARAMETERS_B (
58: PARAMETER_ID,
59: OBJECT_ID,
60: DB_OBJECT_REF_TYPE_CODE,
61: DB_OBJECT_ID,

Line 275: from WMS_PARAMETERS_B

271: ATTRIBUTE13,
272: ATTRIBUTE14,
273: ATTRIBUTE15,
274: USE_FOR_OP_SELECTION_FLAG
275: from WMS_PARAMETERS_B
276: where PARAMETER_ID = X_PARAMETER_ID
277: for update of PARAMETER_ID nowait;
278: recinfo c%rowtype;
279:

Line 431: update WMS_PARAMETERS_B set

427: X_LAST_UPDATE_LOGIN in NUMBER,
428: X_USE_FOR_OP_SELECTION_FLAG in VARCHAR2
429: ) is
430: begin
431: update WMS_PARAMETERS_B set
432: OBJECT_ID = X_OBJECT_ID,
433: DB_OBJECT_REF_TYPE_CODE = X_DB_OBJECT_REF_TYPE_CODE,
434: DB_OBJECT_ID = X_DB_OBJECT_ID,
435: DB_OBJECT_REFERENCE_ID = X_DB_OBJECT_REFERENCE_ID,

Line 506: delete from WMS_PARAMETERS_B

502: if (sql%notfound) then
503: raise no_data_found;
504: end if;
505:
506: delete from WMS_PARAMETERS_B
507: where PARAMETER_ID = X_PARAMETER_ID;
508:
509: if (sql%notfound) then
510: raise no_data_found;

Line 520: from WMS_PARAMETERS_B B

516: begin
517: delete from WMS_PARAMETERS_TL T
518: where not exists
519: (select NULL
520: from WMS_PARAMETERS_B B
521: where B.PARAMETER_ID = T.PARAMETER_ID
522: );
523:
524: update WMS_PARAMETERS_TL T set (