APPS.WMS_LABEL_FORMATS_PKG dependencies on WMS_LABEL_FORMATS

Line 1: package body WMS_LABEL_FORMATS_PKG as

1: package body WMS_LABEL_FORMATS_PKG as
2: /* $Header: WMSLBFMB.pls 120.2 2005/06/22 09:25:52 appldev ship $ */
3:
4: TRACE_LEVEL CONSTANT NUMBER := 2;
5: TRACE_PROMPT CONSTANT VARCHAR2(10) := 'LB_FORMATS';

Line 40: cursor C is select ROWID from WMS_LABEL_FORMATS

36: X_ATTRIBUTE13 in VARCHAR2,
37: X_ATTRIBUTE14 in VARCHAR2,
38: X_ATTRIBUTE15 in VARCHAR2
39: ) is
40: cursor C is select ROWID from WMS_LABEL_FORMATS
41: where LABEL_FORMAT_ID = X_LABEL_FORMAT_ID
42: ;
43: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
44: begin

Line 45: insert into WMS_LABEL_FORMATS (

41: where LABEL_FORMAT_ID = X_LABEL_FORMAT_ID
42: ;
43: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
44: begin
45: insert into WMS_LABEL_FORMATS (
46: LABEL_FORMAT_ID,
47: LABEL_FORMAT_NAME ,
48: FORMAT_DESCRIPTION,
49: DOCUMENT_ID ,

Line 176: from WMS_LABEL_FORMATS

172: ATTRIBUTE12,
173: ATTRIBUTE13,
174: ATTRIBUTE14,
175: ATTRIBUTE15
176: from WMS_LABEL_FORMATS
177: where LABEL_FORMAT_ID = X_LABEL_FORMAT_ID
178: for update of LABEL_FORMAT_ID nowait;
179: recinfo c%rowtype;
180:

Line 283: update WMS_LABEL_FORMATS

279: begin
280: IF (l_debug = 1) THEN
281: INV_LOG_UTIL.trace(' X_LABEL_FORMAT_ID: '||X_LABEL_FORMAT_ID , TRACE_PROMPT, TRACE_LEVEL);
282: END IF;
283: update WMS_LABEL_FORMATS
284: set DOCUMENT_ID = X_DOCUMENT_ID,
285: LABEL_FORMAT_NAME = X_LABEL_FORMAT_NAME,
286: FORMAT_DESCRIPTION = X_FORMAT_DESCRIPTION,
287: DEFAULT_FORMAT_FLAG = X_DEFAULT_FORMAT_FLAG,

Line 323: delete from WMS_LABEL_FORMATS

319: X_LABEL_FORMAT_ID in NUMBER
320: ) is
321: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
322: begin
323: delete from WMS_LABEL_FORMATS
324: where LABEL_FORMAT_ID = X_LABEL_FORMAT_ID;
325:
326: if (sql%notfound) then
327: raise no_data_found;

Line 402: wms_label_formats_pkg.update_row

398: INV_LOG_UTIL.trace(' load_row():l_label_format_id : '||l_label_format_id , TRACE_PROMPT, TRACE_LEVEL);
399: END IF;
400:
401: l_msg := 'LOAD_ROW(): ' ||l_label_format_id;
402: wms_label_formats_pkg.update_row
403: (
404: x_label_format_id => l_label_format_id
405: ,x_label_format_name => x_label_format_name
406: ,x_format_description => x_format_description

Line 438: wms_label_formats_pkg.insert_row

434: ,x_attribute15 => x_attribute15
435: );
436: EXCEPTION
437: WHEN no_data_found THEN
438: wms_label_formats_pkg.insert_row
439: (
440: x_rowid => l_row_id
441: , x_label_format_id => l_label_format_id
442: ,x_label_format_name => x_label_format_name

Line 475: end WMS_LABEL_FORMATS_PKG;

471: ,x_attribute15 => x_attribute15
472: );
473: END;
474: END load_row;
475: end WMS_LABEL_FORMATS_PKG;