APPS.HZ_PARTY_MERGE dependencies on HZ_MERGE_PARTY_LOG

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

1104: END LOOP;
1105: CLOSE c_pre_merge;
1106:
1107: --bug 4634891
1108: -- populate hz_merge_party_log table before executing batch merge procs for team to query
1109: store_merge_log(null, null, null,null, null,null, null, null, null,null,'Y');
1110:
1111:
1112: OPEN batch_merge_procedures;

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

Line 2730: p_error IN HZ_MERGE_PARTY_LOG.ERROR_MESSAGES%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,
2732: p_flush IN VARCHAR2 := 'N') IS
2733: PRAGMA AUTONOMOUS_TRANSACTION;
2734: BEGIN

Line 2739: INSERT INTO HZ_MERGE_PARTY_LOG(

2735:
2736: IF I_Counter = 1000 OR p_flush = 'Y' THEN
2737: FORALL I IN 1..I_Counter
2738: -- Insert inyo the log table
2739: INSERT INTO HZ_MERGE_PARTY_LOG(
2740: batch_party_id,
2741: request_id,
2742: from_entity_id,
2743: to_entity_id,