APPS.AR_MCC_MERGE dependencies on RA_CUSTOMER_MERGES

Line 110: -- RA_CUSTOMER_MERGES

106: -- process_mode IN VARCHAR2 Process mode of the called
107: -- program
108: -- COMMENT : This procedure deletes the records from the table
109: -- HZ_CREDIT_USAGES for the corresponding customer Ids in
110: -- RA_CUSTOMER_MERGES
111: --=========================================================================
112: PROCEDURE Customer_Merge
113: ( req_id IN NUMBER
114: ,set_number IN NUMBER

Line 129: RA_CUSTOMER_MERGES

125: CURSOR customer_account_dup_cur IS
126: SELECT
127: DISTINCT duplicate_id
128: FROM
129: RA_CUSTOMER_MERGES
130: WHERE process_flag = 'N'
131: AND request_id = req_id
132: AND set_number = set_number;
133:

Line 136: CURSOR customer_merge_header_cur(c_duplicate_id ra_customer_merges.duplicate_id%TYPE)

132: AND set_number = set_number;
133:
134: -- Cursor to get the customer merge header id for the customer account
135: -- that is being merged
136: CURSOR customer_merge_header_cur(c_duplicate_id ra_customer_merges.duplicate_id%TYPE)
137: IS
138: SELECT
139: customer_merge_header_id
140: FROM

Line 141: RA_CUSTOMER_MERGES

137: IS
138: SELECT
139: customer_merge_header_id
140: FROM
141: RA_CUSTOMER_MERGES
142: WHERE duplicate_id = c_duplicate_id;
143:
144:
145: -- cursor to lock the rows in hz_credit_usages

Line 155: FROM RA_CUSTOMER_MERGES

151: (SELECT cust_acct_profile_amt_id
152: FROM HZ_CUST_PROFILE_AMTS
153: WHERE cust_account_id IN
154: (SELECT DISTINCT duplicate_id
155: FROM RA_CUSTOMER_MERGES
156: WHERE process_flag = 'N'
157: AND request_id = req_id
158: AND set_number = set_number))
159: FOR UPDATE OF credit_usage_id NOWAIT;

Line 193: l_duplicate_id RA_CUSTOMER_MERGES.duplicate_id%TYPE;

189:
190: --=================
191: -- LOCAL VARIABLES
192: --================
193: l_duplicate_id RA_CUSTOMER_MERGES.duplicate_id%TYPE;
194: l_customer_merge_header_id RA_CUSTOMER_MERGES.customer_merge_header_id%TYPE;
195: l_total_count NUMBER;
196: -- variable to store the account merge profile option value
197: l_audit_acct_merge_flag VARCHAR2(3) := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');

Line 194: l_customer_merge_header_id RA_CUSTOMER_MERGES.customer_merge_header_id%TYPE;

190: --=================
191: -- LOCAL VARIABLES
192: --================
193: l_duplicate_id RA_CUSTOMER_MERGES.duplicate_id%TYPE;
194: l_customer_merge_header_id RA_CUSTOMER_MERGES.customer_merge_header_id%TYPE;
195: l_total_count NUMBER;
196: -- variable to store the account merge profile option value
197: l_audit_acct_merge_flag VARCHAR2(3) := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
198: -- Delete flag