APPS.WMS_LABEL_FIELD_VARIABLES_PKG dependencies on WMS_LABEL_FIELD_VARIABLES

Line 1: package body WMS_LABEL_FIELD_VARIABLES_PKG as

1: package body WMS_LABEL_FIELD_VARIABLES_PKG as
2: /* $Header: WMSLBFVB.pls 120.2 2005/06/22 09:17:48 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2, -- NOCOPY added as a part of Bug# 4380449
5: X_LABEL_FORMAT_ID in NUMBER,

Line 35: cursor C is select ROWID from WMS_LABEL_FIELD_VARIABLES

31: X_ATTRIBUTE13 in VARCHAR2,
32: X_ATTRIBUTE14 in VARCHAR2,
33: X_ATTRIBUTE15 in VARCHAR2
34: ) is
35: cursor C is select ROWID from WMS_LABEL_FIELD_VARIABLES
36: where LABEL_FORMAT_ID = X_LABEL_FORMAT_ID
37: AND LABEL_FIELD_ID = X_LABEL_FIELD_ID
38: ;
39: begin

Line 40: insert into WMS_LABEL_FIELD_VARIABLES (

36: where LABEL_FORMAT_ID = X_LABEL_FORMAT_ID
37: AND LABEL_FIELD_ID = X_LABEL_FIELD_ID
38: ;
39: begin
40: insert into WMS_LABEL_FIELD_VARIABLES (
41: LABEL_FORMAT_ID,
42: LABEL_FIELD_ID,
43: FIELD_VARIABLE_NAME,
44: FIELD_VARIABLE_DESCRIPTION,

Line 162: from WMS_LABEL_FIELD_VARIABLES

158: ATTRIBUTE12,
159: ATTRIBUTE13,
160: ATTRIBUTE14,
161: ATTRIBUTE15
162: from WMS_LABEL_FIELD_VARIABLES
163: where LABEL_FORMAT_ID = X_LABEL_FORMAT_ID
164: AND LABEL_FIELD_ID = X_LABEL_FIELD_ID
165: for update of LABEL_FORMAT_ID nowait;
166: recinfo c%rowtype;

Line 255: update WMS_LABEL_FIELD_VARIABLES

251: X_ATTRIBUTE14 in VARCHAR2,
252: X_ATTRIBUTE15 in VARCHAR2
253: ) is
254: begin
255: update WMS_LABEL_FIELD_VARIABLES
256: set FIELD_VARIABLE_NAME = X_FIELD_VARIABLE_NAME,
257: FIELD_VARIABLE_DESCRIPTION = X_FIELD_VARIABLE_DESCRIPTION,
258: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
259: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 292: delete from WMS_LABEL_FIELD_VARIABLES

288: procedure DELETE_ROW (
289: X_ROWID IN VARCHAR2
290: ) is
291: begin
292: delete from WMS_LABEL_FIELD_VARIABLES
293: where ROWID = X_ROWID;
294:
295: if (sql%notfound) then
296: raise no_data_found;

Line 358: wms_label_field_variables_pkg.update_row

354: SELECT Sysdate INTO l_sysdate FROM dual;
355: l_label_format_id := fnd_number.canonical_to_number(x_label_format_id);
356: l_label_field_id := fnd_number.canonical_to_number(x_label_field_id);
357:
358: wms_label_field_variables_pkg.update_row
359: (
360: x_label_format_id => l_label_format_id
361: ,x_label_field_id => l_label_field_id
362: ,x_field_variable_name => x_field_variable_name

Line 392: wms_label_field_variables_pkg.insert_row

388: ,x_attribute15 => x_attribute15
389: );
390: EXCEPTION
391: WHEN no_data_found THEN
392: wms_label_field_variables_pkg.insert_row
393: (
394: x_rowid => l_row_id
395: , x_label_format_id => l_label_format_id
396: ,x_label_field_id => l_label_field_id

Line 427: end WMS_LABEL_FIELD_VARIABLES_PKG;

423: ,x_attribute15 => x_attribute15
424: );
425: END;
426: END load_row;
427: end WMS_LABEL_FIELD_VARIABLES_PKG;