APPS.XTR_REPLICATE_BANK_ACCOUNTS_P dependencies on XTR_PARTY_INFO

Line 14: * p_xtr_party_info_rec Record type of XTR_PARTY_INFO.

10: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
11: *
12: * ARGUMENTS
13: * IN:
14: * p_xtr_party_info_rec Record type of XTR_PARTY_INFO.
15: * This record type contains the Bank/Bank Branch
16: * related information about the bank attached with
17: * Bank Account.
18: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS

Line 57: from xtr_party_info

53:
54: CURSOR c_branch_name
55: IS
56: select full_name
57: from xtr_party_info
58: where party_code = p_xtr_bank_account_rec.bank_code;
59:
60: l_bank_branch_name xtr_party_info.full_name%TYPE;
61:

Line 60: l_bank_branch_name xtr_party_info.full_name%TYPE;

56: select full_name
57: from xtr_party_info
58: where party_code = p_xtr_bank_account_rec.bank_code;
59:
60: l_bank_branch_name xtr_party_info.full_name%TYPE;
61:
62: BEGIN
63:
64: x_msg_count := NULL;

Line 69: -- Verifies if the party_code in xtr_party_info is not same as the bank_code in xtr_bank_accounts

65: FND_MSG_PUB.Initialize; -- Initializes the message list that stores the errors
66:
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68: --
69: -- Verifies if the party_code in xtr_party_info is not same as the bank_code in xtr_bank_accounts
70: IF ((NOT XTR_REPLICATE_BANK_BRANCHES_P.CHK_BANK_BRANCH(p_xtr_bank_account_rec.bank_branch_id))
71: ) THEN -- The Bank does not exist or not authorized in XTR
72:
73: OPEN c_branch_name;

Line 439: l_le_id XTR_PARTY_INFO.legal_entity_id%TYPE;

435:
436: l_cc_id VARCHAR2(2);
437: l_pm_authorized XTR_BANK_ACCOUNTS.PRICING_MODEL%TYPE;
438: l_valid_company VARCHAR2(2);
439: l_le_id XTR_PARTY_INFO.legal_entity_id%TYPE;
440: l_default_acct VARCHAR2(2);
441: l_chk_default XTR_BANK_ACCOUNTS.CE_BANK_ACCOUNT_ID%TYPE; -- Added Bug 4764437
442:
443: -- Enter the procedure variables here. As shown below

Line 948: * p_ce_bank_account_id This is the CE_BANK_ACCOUNT_ID in XTR_PARTY_INFO.

944: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
945: *
946: * ARGUMENTS
947: * IN:
948: * p_ce_bank_account_id This is the CE_BANK_ACCOUNT_ID in XTR_PARTY_INFO.
949: * CE will pass this parameter. This will tell us
950: * which Bank Account is attached with the interest
951: * schedule being updated.
952: * p_interest_rounding This is the ROUNDING_TYPE in XTR_BANK_ACCOUNTS.