[Home] [Help]
123: END log;
124:
125: PROCEDURE get_acct_merge_obj(
126: p_customer_merge_header_id IN NUMBER,
127: x_account_merge_obj OUT NOCOPY CRMINTEG_HZ_MERGE_OBJ
128: ) IS
129: CURSOR account_merge_details(l_customer_merge_header_id NUMBER) IS
130: SELECT CRMINTEG_HZ_MERGE_OBJ(
131: decode(mh.customer_type, 'CUSTOMER_ORG', 'ORGANIZATION', 'CUSTOMER_PERSON', 'PERSON'),-- party_type
126: p_customer_merge_header_id IN NUMBER,
127: x_account_merge_obj OUT NOCOPY CRMINTEG_HZ_MERGE_OBJ
128: ) IS
129: CURSOR account_merge_details(l_customer_merge_header_id NUMBER) IS
130: SELECT CRMINTEG_HZ_MERGE_OBJ(
131: decode(mh.customer_type, 'CUSTOMER_ORG', 'ORGANIZATION', 'CUSTOMER_PERSON', 'PERSON'),-- party_type
132: mh.duplicate_id, -- from cust_acct_id
133: ca.party_id, -- from party_id
134: null, -- from common_obj_id
381:
382: PROCEDURE get_party_merge_objs(
383: p_batch_id IN NUMBER,
384: p_merge_to_party_id IN NUMBER,
385: x_party_merge_objs OUT NOCOPY CRMINTEG_HZ_MERGE_OBJ_TBL
386: ) IS
387: CURSOR get_merge_type IS
388: SELECT party_type
389: FROM HZ_PARTIES
399: and p.party_id = mph.to_parent_entity_id
400: and md.entity_name = 'HZ_CUST_ACCOUNTS';
401:
402: CURSOR get_merge_detail(l_batch_id NUMBER, l_party_type VARCHAR2, l_fpid NUMBER, l_fcaid NUMBER, l_tpid NUMBER) IS
403: SELECT CRMINTEG_HZ_MERGE_OBJ(
404: l_party_type, -- party_type
405: l_fcaid, -- from cust_acct_id
406: l_fpid, -- from party_id
407: null, -- from common_obj_id
458: ) AS CRMINTEG_HZ_MRGDTIL_OBJ_TBL ))
459: from dual;
460:
461: CURSOR get_person_merge_detail(l_batch_id NUMBER, l_party_type VARCHAR2) IS
462: SELECT CRMINTEG_HZ_MERGE_OBJ(
463: l_party_type, -- party_type
464: null, -- from cust_acct_id
465: null, -- from party_id
466: null, -- from common_obj_id
504: l_from_ca_id NUMBER;
505: l_to_party_id NUMBER;
506: i NUMBER;
507: BEGIN
508: x_party_merge_objs := CRMINTEG_HZ_MERGE_OBJ_TBL();
509:
510: OPEN get_merge_type;
511: FETCH get_merge_type INTO l_party_type;
512: CLOSE get_merge_type;