APPS.HZ_TRANS_ATTRIBUTES_PKG dependencies on HZ_TRANS_ATTRIBUTES_B

Line 30: insert into HZ_TRANS_ATTRIBUTES_B (

26: FETCH C2 INTO X_ATTRIBUTE_ID;
27: CLOSE C2;
28: END IF;
29:
30: insert into HZ_TRANS_ATTRIBUTES_B (
31: ATTRIBUTE_ID,
32: ATTRIBUTE_NAME,
33: ENTITY_NAME,
34: CUSTOM_ATTRIBUTE_PROCEDURE,

Line 60: IF INSTRB( SQLERRM, 'HZ_TRANS_ATTRIBUTES_B_U1' ) <> 0 THEN

56: );
57:
58: l_success := 'Y';
59: EXCEPTION WHEN DUP_VAL_ON_INDEX THEN
60: IF INSTRB( SQLERRM, 'HZ_TRANS_ATTRIBUTES_B_U1' ) <> 0 THEN
61: DECLARE
62: l_count NUMBER;
63: l_dummy VARCHAR2(1);
64: BEGIN

Line 71: FROM HZ_TRANS_ATTRIBUTES_B

67: SELECT HZ_TRANS_ATTRIBUTES_s.nextval
68: into X_ATTRIBUTE_ID FROM sys.dual;
69: BEGIN
70: SELECT 'Y' INTO l_dummy
71: FROM HZ_TRANS_ATTRIBUTES_B
72: WHERE ATTRIBUTE_ID = X_ATTRIBUTE_ID;
73: l_count := 1;
74: EXCEPTION WHEN NO_DATA_FOUND THEN
75: l_count := 0;

Line 121: from HZ_TRANS_ATTRIBUTES_B

117: X_OBJECT_VERSION_NUMBER IN number
118: ) is
119: cursor c is select
120: OBJECT_VERSION_NUMBER
121: from HZ_TRANS_ATTRIBUTES_B
122: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
123: for update of ATTRIBUTE_ID nowait;
124: recinfo c%rowtype;
125:

Line 174: from HZ_TRANS_ATTRIBUTES_B

170: X_USER_DEFINED_ATTRIBUTE_NAME IN varchar2
171: ) is
172: cursor c is select
173: OBJECT_VERSION_NUMBER
174: from HZ_TRANS_ATTRIBUTES_B
175: where ATTRIBUTE_ID = X_ATTRIBUTE_ID
176: for update of ATTRIBUTE_ID nowait;
177: recinfo c%rowtype;
178:

Line 257: update HZ_TRANS_ATTRIBUTES_B set

253:
254: IF (X_LAST_UPDATED_BY = 1 AND l_db_upd_by <> 1) THEN
255: -- coming from seed and data modified by user
256: IF (l_db_cus_atr_proc <> X_CUSTOM_ATTRIBUTE_PROCEDURE) THEN
257: update HZ_TRANS_ATTRIBUTES_B set
258: CUSTOM_ATTRIBUTE_PROCEDURE = X_CUSTOM_ATTRIBUTE_PROCEDURE,
259: OBJECT_VERSION_NUMBER = l_object_version_number
260: where ATTRIBUTE_ID = X_ATTRIBUTE_ID;
261:

Line 267: update HZ_TRANS_ATTRIBUTES_B set

263: set staged_flag = 'N'
264: where attribute_id = X_ATTRIBUTE_ID;
265: END IF;
266: ELSE
267: update HZ_TRANS_ATTRIBUTES_B set
268: ENTITY_NAME = X_ENTITY_NAME,
269: CUSTOM_ATTRIBUTE_PROCEDURE = X_CUSTOM_ATTRIBUTE_PROCEDURE,
270: SOURCE_TABLE = X_SOURCE_TABLE,
271: DENORM_FLAG = X_DENORM_FLAG,

Line 308: delete from HZ_TRANS_ATTRIBUTES_B

304: if (sql%notfound) then
305: raise no_data_found;
306: end if;
307:
308: delete from HZ_TRANS_ATTRIBUTES_B
309: where ATTRIBUTE_ID = X_ATTRIBUTE_ID;
310:
311: if (sql%notfound) then
312: raise no_data_found;

Line 322: from HZ_TRANS_ATTRIBUTES_B B

318: begin
319: delete from HZ_TRANS_ATTRIBUTES_TL T
320: where not exists
321: (select NULL
322: from HZ_TRANS_ATTRIBUTES_B B
323: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
324: );
325:
326: update HZ_TRANS_ATTRIBUTES_TL T set (