eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_MERGE_DICTIONARY_PKG dependencies on HZ_MERGE_DICTIONARY

Line 1: PACKAGE BODY HZ_MERGE_DICTIONARY_PKG as

1: PACKAGE BODY HZ_MERGE_DICTIONARY_PKG as
2: /* $Header: ARHMDTBB.pls 120.10 2006/04/26 09:37:26 vsegu noship $ */
3: -- Start of Comments
4: -- Package name : HZ_MERGE_DICTIONARY_PKG
5: -- Purpose :

Line 4: -- Package name : HZ_MERGE_DICTIONARY_PKG

1: PACKAGE BODY HZ_MERGE_DICTIONARY_PKG as
2: /* $Header: ARHMDTBB.pls 120.10 2006/04/26 09:37:26 vsegu noship $ */
3: -- Start of Comments
4: -- Package name : HZ_MERGE_DICTIONARY_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'HZ_MERGE_DICTIONARY_PKG';

6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(30):= 'HZ_MERGE_DICTIONARY_PKG';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'arhtdtbb.pls';
12: ----------------------------------
13: --Declaration of private procedures and functions
14: ----------------------------------

Line 35: FROM HZ_MERGE_DICTIONARY

31: and rownum = 1;
32:
33: CURSOR c_bulk IS
34: SELECT BULK_FLAG, PK_COLUMN_NAME
35: FROM HZ_MERGE_DICTIONARY
36: WHERE ENTITY_NAME = p_parent_entity;
37:
38: l_exist VARCHAR2(10);
39:

Line 242: SELECT MERGE_DICT_ID FROM HZ_MERGE_DICTIONARY WHERE MERGE_DICT_ID=cp_md_id;

238: p_LAST_UPDATED_BY NUMBER)
239:
240: IS
241: CURSOR C1(cp_md_id NUMBER) IS
242: SELECT MERGE_DICT_ID FROM HZ_MERGE_DICTIONARY WHERE MERGE_DICT_ID=cp_md_id;
243:
244: CURSOR C2 IS SELECT HZ_MERGE_DICTIONARY_S.nextval FROM sys.dual;
245:
246: CURSOR C3 IS SELECT 10*(1+trunc(nvl(max(SEQUENCE_NO), 0)/10))

Line 244: CURSOR C2 IS SELECT HZ_MERGE_DICTIONARY_S.nextval FROM sys.dual;

240: IS
241: CURSOR C1(cp_md_id NUMBER) IS
242: SELECT MERGE_DICT_ID FROM HZ_MERGE_DICTIONARY WHERE MERGE_DICT_ID=cp_md_id;
243:
244: CURSOR C2 IS SELECT HZ_MERGE_DICTIONARY_S.nextval FROM sys.dual;
245:
246: CURSOR C3 IS SELECT 10*(1+trunc(nvl(max(SEQUENCE_NO), 0)/10))
247: FROM HZ_MERGE_DICTIONARY
248: WHERE PARENT_ENTITY_NAME = p_PARENT_ENTITY_NAME;

Line 247: FROM HZ_MERGE_DICTIONARY

243:
244: CURSOR C2 IS SELECT HZ_MERGE_DICTIONARY_S.nextval FROM sys.dual;
245:
246: CURSOR C3 IS SELECT 10*(1+trunc(nvl(max(SEQUENCE_NO), 0)/10))
247: FROM HZ_MERGE_DICTIONARY
248: WHERE PARENT_ENTITY_NAME = p_PARENT_ENTITY_NAME;
249:
250: l_temp NUMBER;
251: BEGIN

Line 279: INSERT INTO HZ_MERGE_DICTIONARY(

275: else
276: px_SEQUENCE_NO := 1;
277: End if;
278: End If;
279: INSERT INTO HZ_MERGE_DICTIONARY(
280: MERGE_DICT_ID,
281: RULE_SET_NAME,
282: ENTITY_NAME,
283: PARENT_ENTITY_NAME,

Line 351: FROM HZ_MERGE_DICTIONARY

347:
348: IS
349: CURSOR C1 IS
350: SELECT nvl(PARENT_ENTITY_NAME, 'NONAME')
351: FROM HZ_MERGE_DICTIONARY
352: WHERE MERGE_DICT_ID = p_MERGE_DICT_ID;
353:
354: CURSOR C3 IS SELECT 10*(1+trunc(nvl(max(SEQUENCE_NO), 0)/10))
355: FROM HZ_MERGE_DICTIONARY

Line 355: FROM HZ_MERGE_DICTIONARY

351: FROM HZ_MERGE_DICTIONARY
352: WHERE MERGE_DICT_ID = p_MERGE_DICT_ID;
353:
354: CURSOR C3 IS SELECT 10*(1+trunc(nvl(max(SEQUENCE_NO), 0)/10))
355: FROM HZ_MERGE_DICTIONARY
356: WHERE PARENT_ENTITY_NAME = p_PARENT_ENTITY_NAME;
357:
358: l_old_parent_ent_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
359: BEGIN

Line 358: l_old_parent_ent_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;

354: CURSOR C3 IS SELECT 10*(1+trunc(nvl(max(SEQUENCE_NO), 0)/10))
355: FROM HZ_MERGE_DICTIONARY
356: WHERE PARENT_ENTITY_NAME = p_PARENT_ENTITY_NAME;
357:
358: l_old_parent_ent_name HZ_MERGE_DICTIONARY.PARENT_ENTITY_NAME%TYPE;
359: BEGIN
360: OPEN C1;
361: FETCH C1 INTO l_old_parent_ent_name;
362: CLOSE C1;

Line 370: Update HZ_MERGE_DICTIONARY

366: FETCH C3 INTO px_sequence_no;
367: CLOSE C3;
368: END IF;
369:
370: Update HZ_MERGE_DICTIONARY
371: SET
372: RULE_SET_NAME = decode( p_RULE_SET_NAME, FND_API.G_MISS_CHAR, RULE_SET_NAME, p_RULE_SET_NAME),
373: ENTITY_NAME = decode( p_ENTITY_NAME, FND_API.G_MISS_CHAR, ENTITY_NAME, p_ENTITY_NAME),
374: PARENT_ENTITY_NAME = decode( p_PARENT_ENTITY_NAME, FND_API.G_MISS_CHAR, PARENT_ENTITY_NAME, p_PARENT_ENTITY_NAME),

Line 408: DELETE FROM HZ_MERGE_DICTIONARY hmd

404: IS
405: BEGIN
406:
407: BEGIN
408: DELETE FROM HZ_MERGE_DICTIONARY hmd
409: where parent_entity_name in ( select entity_name
410: from HZ_MERGE_DICTIONARY hmd1
411: where hmd1.merge_dict_id=p_MERGE_DICT_ID);
412: EXCEPTION

Line 410: from HZ_MERGE_DICTIONARY hmd1

406:
407: BEGIN
408: DELETE FROM HZ_MERGE_DICTIONARY hmd
409: where parent_entity_name in ( select entity_name
410: from HZ_MERGE_DICTIONARY hmd1
411: where hmd1.merge_dict_id=p_MERGE_DICT_ID);
412: EXCEPTION
413: WHEN NO_DATA_FOUND THEN
414: NULL;

Line 417: DELETE FROM HZ_MERGE_DICTIONARY

413: WHEN NO_DATA_FOUND THEN
414: NULL;
415: END;
416:
417: DELETE FROM HZ_MERGE_DICTIONARY
418: WHERE MERGE_DICT_ID = p_MERGE_DICT_ID;
419:
420:
421: If (SQL%NOTFOUND) then

Line 452: FROM HZ_MERGE_DICTIONARY

448:
449: IS
450: CURSOR C IS
451: SELECT *
452: FROM HZ_MERGE_DICTIONARY
453: WHERE MERGE_DICT_ID = p_MERGE_DICT_ID
454: FOR UPDATE of MERGE_DICT_ID NOWAIT;
455: Recinfo C%ROWTYPE;
456: BEGIN

Line 535: End HZ_MERGE_DICTIONARY_PKG;

531: APP_EXCEPTION.RAISE_EXCEPTION;
532: End If;
533: END Lock_Row;
534:
535: End HZ_MERGE_DICTIONARY_PKG;