APPS.HZ_TRANSFORMATIONS_PKG dependencies on HZ_TRANSFORMATIONS_B

Line 37: INSERT INTO HZ_TRANSFORMATIONS_B(

33: END IF;
34:
35: WHILE l_success = 'N' LOOP
36: BEGIN
37: INSERT INTO HZ_TRANSFORMATIONS_B(
38: transformation_id,
39: procedure_name,
40: object_version_number,
41: created_by,

Line 59: IF INSTRB( SQLERRM, 'HZ_TRANSFORMATIONS_B_U1' ) <> 0 THEN

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

Line 70: FROM HZ_TRANSFORMATIONS_B

66: SELECT HZ_TRANSFORMATIONS_S.nextval
67: into x_transformation_id FROM sys.dual;
68: BEGIN
69: SELECT 'Y' INTO l_dummy
70: FROM HZ_TRANSFORMATIONS_B
71: WHERE TRANSFORMATION_ID = X_TRANSFORMATION_ID;
72: l_count := 1;
73: EXCEPTION WHEN NO_DATA_FOUND THEN
74: l_count := 0;

Line 135: UPDATE HZ_TRANSFORMATIONS_B set

131: fnd_message.set_name('AR', 'HZ_DQM_INVALID_TRANS_PROC');
132: fnd_message.set_token('PROC',x_procedure_name);
133: app_exception.raise_exception;
134: end if;
135: UPDATE HZ_TRANSFORMATIONS_B set
136: procedure_name = decode(x_procedure_name,null,procedure_name,fnd_api.g_miss_char,NULL,x_procedure_name),
137: object_version_number = p_object_version_number,
138: last_updated_by = hz_utility_v2pub.last_updated_by,
139: last_update_login = hz_utility_v2pub.last_update_login,

Line 171: delete from HZ_TRANSFORMATIONS_B

167: x_transformation_id in NUMBER
168: )
169: IS
170: BEGIN
171: delete from HZ_TRANSFORMATIONS_B
172: where transformation_id = x_transformation_id ;
173:
174: if (sql%notfound) then
175: raise no_data_found;

Line 196: from HZ_TRANSFORMATIONS_B

192: from HZ_TRANSFORMATIONS_TL
193: where transformation_id = x_transformation_id
194: and language = userenv('lang');
195: cursor c1 is select object_version_number
196: from HZ_TRANSFORMATIONS_B
197: where transformation_id = x_transformation_id
198: for update of transformation_id nowait;
199:
200: cursor c2 is select object_version_number

Line 246: from HZ_TRANSFORMATIONS_B B

242: BEGIN
243: delete from HZ_TRANSFORMATIONS_TL T
244: where not exists
245: (select NULL
246: from HZ_TRANSFORMATIONS_B B
247: where B.transformation_id = T.transformation_id
248: );
249:
250: update HZ_TRANSFORMATIONS_TL T set (

Line 344: from HZ_TRANSFORMATIONS_B

340:
341: BEGIN
342: select LAST_UPDATED_BY, LAST_UPDATE_DATE
343: into l_db_luby, l_db_ludate
344: from HZ_TRANSFORMATIONS_B
345: where transformation_id = x_transformation_id ;
346:
347: -- Update record, honoring customization mode.
348: -- Record should be updated only if: