APPS.HZ_PARTY_MERGE dependencies on HZ_MERGE_PARTY_LOG

Line 1071: -- populate hz_merge_party_log table before executing batch merge procs for team to query

1067: END LOOP;
1068: CLOSE c_pre_merge;
1069:
1070: --bug 4634891
1071: -- populate hz_merge_party_log table before executing batch merge procs for team to query
1072: store_merge_log(null, null, null,null, null,null, null, null, null,null,'Y');
1073:
1074:
1075: OPEN batch_merge_procedures;

Line 2689: p_op_type IN HZ_MERGE_PARTY_LOG.OPERATION_TYPE%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,
2692: p_flush IN VARCHAR2 := 'N') IS
2693: PRAGMA AUTONOMOUS_TRANSACTION;

Line 2690: p_error IN HZ_MERGE_PARTY_LOG.ERROR_MESSAGES%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,
2692: p_flush IN VARCHAR2 := 'N') IS
2693: PRAGMA AUTONOMOUS_TRANSACTION;
2694: BEGIN

Line 2699: INSERT INTO HZ_MERGE_PARTY_LOG(

2695:
2696: IF I_Counter = 1000 OR p_flush = 'Y' THEN
2697: FORALL I IN 1..I_Counter
2698: -- Insert inyo the log table
2699: INSERT INTO HZ_MERGE_PARTY_LOG(
2700: batch_party_id,
2701: request_id,
2702: from_entity_id,
2703: to_entity_id,