APPS.FII_AR_ACCOUNT_MERGE_PKG dependencies on FII_CUST_ACCOUNTS

Line 456: -- This procedure maintains FII_Cust_Accounts after an Account Merge.

452:
453:
454:
455: -- ******************************************************************
456: -- This procedure maintains FII_Cust_Accounts after an Account Merge.
457: -- ******************************************************************
458:
459: PROCEDURE MERGE_CUSTOMER_ACCOUNTS (req_id NUMBER,
460: set_num NUMBER,

Line 467: TYPE Cust_Account_ID_Type IS TABLE OF FII_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE

463: TYPE Merge_Header_ID_Type IS
464: TABLE OF RA_CUSTOMER_MERGES.CUSTOMER_MERGE_HEADER_ID%TYPE
465: INDEX BY BINARY_INTEGER;
466:
467: TYPE Cust_Account_ID_Type IS TABLE OF FII_CUST_ACCOUNTS.CUST_ACCOUNT_ID%TYPE
468: INDEX BY BINARY_INTEGER;
469:
470: TYPE Party_ID_Type IS TABLE OF HZ_PARTIES.PARTY_ID%TYPE
471: INDEX BY BINARY_INTEGER;

Line 473: TYPE PARTY_ID_LIST_TYPE IS TABLE OF FII_CUST_ACCOUNTS.PARENT_PARTY_ID%TYPE

469:
470: TYPE Party_ID_Type IS TABLE OF HZ_PARTIES.PARTY_ID%TYPE
471: INDEX BY BINARY_INTEGER;
472:
473: TYPE PARTY_ID_LIST_TYPE IS TABLE OF FII_CUST_ACCOUNTS.PARENT_PARTY_ID%TYPE
474: INDEX BY BINARY_INTEGER;
475:
476: Merge_Header_ID_List Merge_Header_ID_Type;
477: Cust_Account_ID_List Cust_Account_ID_Type;

Line 489: FROM FII_Cust_Accounts CA,

485: SELECT M.Customer_Merge_Header_ID,
486: CA.Cust_Account_ID,
487: CA.Account_Owner_Party_ID,
488: CA.Parent_Party_ID
489: FROM FII_Cust_Accounts CA,
490: RA_Customer_Merges M
491: WHERE CA.Cust_Account_ID = M.Duplicate_ID
492: AND M.Process_Flag = 'N'
493: AND M.Request_ID = Req_ID

Line 503: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FII_CUST_ACCOUNTS',FALSE);

499:
500: IF Process_Mode <> 'LOCK' THEN --Process_Mode = 'UPDATE'
501:
502: ARP_MESSAGE.SET_NAME('FII','FII_DELETING_TABLE');
503: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FII_CUST_ACCOUNTS',FALSE);
504: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
505:
506: OPEN Account_Merge_Records;
507: LOOP

Line 544: 'FII_CUST_ACCOUNTS',

540: LAST_UPDATE_DATE,
541: LAST_UPDATED_BY)
542: VALUES (
543: HZ_Customer_Merge_Log_S.nextval,
544: 'FII_CUST_ACCOUNTS',
545: Merge_Header_ID_List(i),
546: Cust_Account_ID_List(i),
547: Account_Owner_Party_ID_List(i),
548: Parent_Party_ID_List(i),

Line 562: DELETE FROM FII_Cust_Accounts

558: HZ_Utility_Pub.LAST_UPDATED_BY);
559: END IF;
560:
561: FORALL i in 1..Merge_Header_ID_List.Count
562: DELETE FROM FII_Cust_Accounts
563: WHERE Cust_Account_ID = Cust_Account_ID_List(i)
564: AND Account_Owner_Party_ID = Account_Owner_Party_ID_List(i)
565: AND Parent_Party_ID = Parent_Party_ID_List(i);
566: