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 2244: FROM HZ_MERGE_PARTY_HISTORY h, HZ_MERGE_DICTIONARY d

2240: x_return_status IN OUT NOCOPY VARCHAR2) IS
2241:
2242: CURSOR c_deleted_records IS
2243: SELECT h.from_entity_id, d.entity_name, d.pk_column_name
2244: FROM HZ_MERGE_PARTY_HISTORY h, HZ_MERGE_DICTIONARY d
2245: WHERE h.merge_dict_id = d.merge_dict_id
2246: AND h.batch_party_id = p_batch_party_id
2247: AND h.request_id = hz_utility_pub.request_id
2248: AND h.operation_type = 'Merge'

Line 2251: l_record_id HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_ID%TYPE;

2247: AND h.request_id = hz_utility_pub.request_id
2248: AND h.operation_type = 'Merge'
2249: ORDER BY h.merge_dict_id desc;
2250:
2251: l_record_id HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_ID%TYPE;
2252: l_entity_name HZ_MERGE_DICTIONARY.ENTITY_NAME%TYPE;
2253: l_pkcol HZ_MERGE_DICTIONARY.PK_COLUMN_NAME%TYPE;
2254:
2255: rec_delete VARCHAR2(2000);

Line 2622: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,

2618: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2619: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2620: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2621: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2622: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2623: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2624: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
2625: p_op_type IN HZ_MERGE_PARTY_HISTORY.OPERATION_TYPE%TYPE,
2626: p_flush IN VARCHAR2 := 'N') IS

Line 2623: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,

2619: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2620: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2621: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2622: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2623: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2624: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
2625: p_op_type IN HZ_MERGE_PARTY_HISTORY.OPERATION_TYPE%TYPE,
2626: p_flush IN VARCHAR2 := 'N') IS
2627:

Line 2625: p_op_type IN HZ_MERGE_PARTY_HISTORY.OPERATION_TYPE%TYPE,

2621: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2622: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2623: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2624: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
2625: p_op_type IN HZ_MERGE_PARTY_HISTORY.OPERATION_TYPE%TYPE,
2626: p_flush IN VARCHAR2 := 'N') IS
2627:
2628: BEGIN
2629:

Line 2640: INSERT INTO HZ_MERGE_PARTY_HISTORY(

2636:
2637: IF H_Counter = 1000 OR p_flush = 'Y' THEN
2638: FORALL I IN 1..H_Counter
2639: -- Store in the history table
2640: INSERT INTO HZ_MERGE_PARTY_HISTORY(
2641: batch_party_id,
2642: request_id,
2643: from_entity_id,
2644: to_entity_id,

Line 2726: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,

2722: p_from_id IN HZ_MERGE_PARTIES.FROM_PARTY_ID%TYPE,
2723: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2724: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2725: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2726: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2727: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2728: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
2729: p_op_type IN HZ_MERGE_PARTY_LOG.OPERATION_TYPE%TYPE,
2730: p_error IN HZ_MERGE_PARTY_LOG.ERROR_MESSAGES%TYPE

Line 2727: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,

2723: p_to_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2724: p_from_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2725: p_to_fk_id IN HZ_MERGE_PARTIES.TO_PARTY_ID%TYPE,
2726: p_from_desc IN HZ_MERGE_PARTY_HISTORY.FROM_ENTITY_DESC%TYPE,
2727: p_to_desc IN HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE,
2728: p_merge_dict_id IN HZ_MERGE_DICTIONARY.MERGE_DICT_ID%TYPE,
2729: p_op_type IN HZ_MERGE_PARTY_LOG.OPERATION_TYPE%TYPE,
2730: p_error IN HZ_MERGE_PARTY_LOG.ERROR_MESSAGES%TYPE
2731: DEFAULT NULL,

Line 3195: FROM HZ_MERGE_PARTY_HISTORY mh, HZ_MERGE_DICTIONARY md

3191: ) IS
3192:
3193: CURSOR c_merge_to_rec (cp_merge_from_id NUMBER) IS
3194: SELECT mh.TO_ENTITY_ID, mh.TO_ENTITY_DESC
3195: FROM HZ_MERGE_PARTY_HISTORY mh, HZ_MERGE_DICTIONARY md
3196: WHERE mh.merge_dict_id = md.merge_dict_id
3197: AND md.entity_name = p_entity_name
3198: AND mh.from_entity_id = cp_merge_from_id;
3199:

Line 3203: l_merge_to_desc HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE;

3199:
3200: l_api_name CONSTANT VARCHAR2(30) := 'get_merge_to_record_id';
3201: l_api_version CONSTANT NUMBER := 1.0;
3202: l_merge_to_id NUMBER;
3203: l_merge_to_desc HZ_MERGE_PARTY_HISTORY.TO_ENTITY_DESC%TYPE;
3204:
3205: BEGIN
3206:
3207: --Standard call to check for call compatibility.