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_PARTY_MERGE dependencies on HZ_MERGE_PARTY_HISTORY

Line 155: g_request_id HZ_MERGE_PARTY_HISTORY.request_id%TYPE;

151: p_ext_party OUT NOCOPY VARCHAR2,
152: p_merge_ok OUT NOCOPY VARCHAR2);
153:
154: -------------Global Variables and lists--------------------
155: g_request_id HZ_MERGE_PARTY_HISTORY.request_id%TYPE;
156: g_user_id HZ_MERGE_PARTY_HISTORY.last_updated_by%TYPE;
157: g_created_by HZ_MERGE_PARTY_HISTORY.created_by%TYPE;
158: g_last_update_login HZ_MERGE_PARTY_HISTORY.last_update_login%TYPE;
159: g_creation_date DATE;

Line 156: g_user_id HZ_MERGE_PARTY_HISTORY.last_updated_by%TYPE;

152: p_merge_ok OUT NOCOPY VARCHAR2);
153:
154: -------------Global Variables and lists--------------------
155: g_request_id HZ_MERGE_PARTY_HISTORY.request_id%TYPE;
156: g_user_id HZ_MERGE_PARTY_HISTORY.last_updated_by%TYPE;
157: g_created_by HZ_MERGE_PARTY_HISTORY.created_by%TYPE;
158: g_last_update_login HZ_MERGE_PARTY_HISTORY.last_update_login%TYPE;
159: g_creation_date DATE;
160: g_last_update_date DATE;

Line 157: g_created_by HZ_MERGE_PARTY_HISTORY.created_by%TYPE;

153:
154: -------------Global Variables and lists--------------------
155: g_request_id HZ_MERGE_PARTY_HISTORY.request_id%TYPE;
156: g_user_id HZ_MERGE_PARTY_HISTORY.last_updated_by%TYPE;
157: g_created_by HZ_MERGE_PARTY_HISTORY.created_by%TYPE;
158: g_last_update_login HZ_MERGE_PARTY_HISTORY.last_update_login%TYPE;
159: g_creation_date DATE;
160: g_last_update_date DATE;
161:

Line 158: g_last_update_login HZ_MERGE_PARTY_HISTORY.last_update_login%TYPE;

154: -------------Global Variables and lists--------------------
155: g_request_id HZ_MERGE_PARTY_HISTORY.request_id%TYPE;
156: g_user_id HZ_MERGE_PARTY_HISTORY.last_updated_by%TYPE;
157: g_created_by HZ_MERGE_PARTY_HISTORY.created_by%TYPE;
158: g_last_update_login HZ_MERGE_PARTY_HISTORY.last_update_login%TYPE;
159: g_creation_date DATE;
160: g_last_update_date DATE;
161:
162: g_merge_delete_flag VARCHAR2(1);

Line 2204: FROM HZ_MERGE_PARTY_HISTORY h, HZ_MERGE_DICTIONARY d

2200: x_return_status IN OUT NOCOPY VARCHAR2) IS
2201:
2202: CURSOR c_deleted_records IS
2203: SELECT h.from_entity_id, d.entity_name, d.pk_column_name
2204: FROM HZ_MERGE_PARTY_HISTORY h, HZ_MERGE_DICTIONARY d
2205: WHERE h.merge_dict_id = d.merge_dict_id
2206: AND h.batch_party_id = p_batch_party_id
2207: AND h.request_id = hz_utility_pub.request_id
2208: AND h.operation_type = 'Merge'

Line 2211: l_record_id HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_ID%TYPE;

2207: AND h.request_id = hz_utility_pub.request_id
2208: AND h.operation_type = 'Merge'
2209: ORDER BY h.merge_dict_id desc;
2210:
2211: l_record_id HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_ID%TYPE;
2212: l_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
2213: l_pkcol HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
2214:
2215: rec_delete VARCHAR2(2000);

Line 2582: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,

2578: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2579: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2580: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2581: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2582: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2583: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2584: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
2585: p_op_type IN HZ_MERGE_PARTY_HISTORY.OPERATION_TYPE%TYPE,
2586: p_flush IN VARCHAR2 := 'N') IS

Line 2583: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,

2579: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2580: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2581: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2582: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2583: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2584: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
2585: p_op_type IN HZ_MERGE_PARTY_HISTORY.OPERATION_TYPE%TYPE,
2586: p_flush IN VARCHAR2 := 'N') IS
2587:

Line 2585: p_op_type IN HZ_MERGE_PARTY_HISTORY.OPERATION_TYPE%TYPE,

2581: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2582: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2583: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2584: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
2585: p_op_type IN HZ_MERGE_PARTY_HISTORY.OPERATION_TYPE%TYPE,
2586: p_flush IN VARCHAR2 := 'N') IS
2587:
2588: BEGIN
2589:

Line 2600: INSERT INTO HZ_MERGE_PARTY_HISTORY(

2596:
2597: IF H_Counter = 1000 OR p_flush = 'Y' THEN
2598: FORALL I IN 1..H_Counter
2599: -- Store in the history table
2600: INSERT INTO HZ_MERGE_PARTY_HISTORY(
2601: batch_party_id,
2602: request_id,
2603: from_entity_id,
2604: to_entity_id,

Line 2686: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,

2682: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2683: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2684: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2685: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2686: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2687: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2688: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
2689: p_op_type IN HZ_MERGE_PARTY_LOG.OPERATION_TYPE%TYPE,
2690: p_error IN HZ_MERGE_PARTY_LOG.ERROR_MESSAGES%TYPE

Line 2687: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,

2683: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2684: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2685: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2686: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2687: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2688: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
2689: p_op_type IN HZ_MERGE_PARTY_LOG.OPERATION_TYPE%TYPE,
2690: p_error IN HZ_MERGE_PARTY_LOG.ERROR_MESSAGES%TYPE
2691: DEFAULT NULL,

Line 3155: FROM HZ_MERGE_PARTY_HISTORY mh, HZ_MERGE_DICTIONARY md

3151: ) IS
3152:
3153: CURSOR c_merge_to_rec (cp_merge_from_id NUMBER) IS
3154: SELECT mh.TO_ENTITY_ID, mh.TO_ENTITY_DESC
3155: FROM HZ_MERGE_PARTY_HISTORY mh, HZ_MERGE_DICTIONARY md
3156: WHERE mh.merge_dict_id = md.merge_dict_id
3157: AND md.entity_name = p_entity_name
3158: AND mh.from_entity_id = cp_merge_from_id;
3159:

Line 3163: l_merge_to_desc HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE;

3159:
3160: l_api_name CONSTANT VARCHAR2(30) := 'get_merge_to_record_id';
3161: l_api_version CONSTANT NUMBER := 1.0;
3162: l_merge_to_id NUMBER;
3163: l_merge_to_desc HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE;
3164:
3165: BEGIN
3166:
3167: --Standard call to check for call compatibility.