APPS.HZ_TRANS_FUNCTIONS_PKG dependencies on HZ_TRANS_FUNCTIONS_B

Line 38: insert into HZ_TRANS_FUNCTIONS_B (

34: FETCH C2 INTO X_FUNCTION_ID;
35: CLOSE C2;
36: END IF;
37:
38: insert into HZ_TRANS_FUNCTIONS_B (
39: STAGED_ATTRIBUTE_TABLE,
40: STAGED_ATTRIBUTE_COLUMN,
41: STAGED_FLAG,
42: FUNCTION_ID,

Line 74: IF INSTRB( SQLERRM, 'HZ_TRANS_FUNCTIONS_B_U1' ) <> 0 THEN

70: );
71:
72: l_success := 'Y';
73: EXCEPTION WHEN DUP_VAL_ON_INDEX THEN
74: IF INSTRB( SQLERRM, 'HZ_TRANS_FUNCTIONS_B_U1' ) <> 0 THEN
75: DECLARE
76: l_count NUMBER;
77: l_dummy VARCHAR2(1);
78: BEGIN

Line 85: FROM HZ_TRANS_FUNCTIONS_B

81: SELECT HZ_TRANS_FUNCTIONS_s.nextval
82: into X_FUNCTION_ID FROM sys.dual;
83: BEGIN
84: SELECT 'Y' INTO l_dummy
85: FROM HZ_TRANS_FUNCTIONS_B
86: WHERE FUNCTION_ID = X_FUNCTION_ID;
87: l_count := 1;
88: EXCEPTION WHEN NO_DATA_FOUND THEN
89: l_count := 0;

Line 138: from HZ_TRANS_FUNCTIONS_B

134: X_OBJECT_VERSION_NUMBER IN NUMBER
135: ) is
136: cursor c is select
137: OBJECT_VERSION_NUMBER
138: from HZ_TRANS_FUNCTIONS_B
139: where FUNCTION_ID = X_FUNCTION_ID
140: for update of FUNCTION_ID nowait;
141: recinfo c%rowtype;
142:

Line 191: from HZ_TRANS_FUNCTIONS_B

187:
188: ) is
189: cursor c is select
190: OBJECT_VERSION_NUMBER
191: from HZ_TRANS_FUNCTIONS_B
192: where FUNCTION_ID = X_FUNCTION_ID
193: for update of FUNCTION_ID nowait;
194: recinfo c%rowtype;
195:

Line 290: update HZ_TRANS_FUNCTIONS_B set

286:
287: IF (X_LAST_UPDATED_BY = 1 AND l_db_upd_by <> 1) THEN
288: -- coming from seed and data modified by user
289: IF (X_PROCEDURE_NAME <>l_db_proc_name) THEN
290: update HZ_TRANS_FUNCTIONS_B set
291: PROCEDURE_NAME = X_PROCEDURE_NAME,
292: STAGED_FLAG = 'N',
293: OBJECT_VERSION_NUMBER = l_object_version_number
294: where FUNCTION_ID = X_FUNCTION_ID;

Line 316: update HZ_TRANS_FUNCTIONS_B set

312: --L_STAGED_ATTRIBUTE_COLUMN := X_STAGED_ATTRIBUTE_COLUMN;
313: ELSE
314: L_STAGED_ATTRIBUTE_COLUMN := l_db_stg_atr_col;
315: END IF;
316: update HZ_TRANS_FUNCTIONS_B set
317: STAGED_ATTRIBUTE_TABLE = X_STAGED_ATTRIBUTE_TABLE,
318: STAGED_ATTRIBUTE_COLUMN = L_STAGED_ATTRIBUTE_COLUMN,
319: ATTRIBUTE_ID = X_ATTRIBUTE_ID,
320: PROCEDURE_NAME = X_PROCEDURE_NAME,

Line 356: delete from HZ_TRANS_FUNCTIONS_B

352: if (sql%notfound) then
353: raise no_data_found;
354: end if;
355:
356: delete from HZ_TRANS_FUNCTIONS_B
357: where FUNCTION_ID = X_FUNCTION_ID;
358:
359: if (sql%notfound) then
360: raise no_data_found;

Line 370: from HZ_TRANS_FUNCTIONS_B B

366: begin
367: delete from HZ_TRANS_FUNCTIONS_TL T
368: where not exists
369: (select NULL
370: from HZ_TRANS_FUNCTIONS_B B
371: where B.FUNCTION_ID = T.FUNCTION_ID
372: );
373:
374: update HZ_TRANS_FUNCTIONS_TL T set (