eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_REPLICATE_BANK_ACCOUNTS_P dependencies on XTR_BANK_ACCOUNTS

Line 18: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS

14: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
15: *
16: * ARGUMENTS
17: * IN:
18: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS
19: * This record type contains the Bank Account
20: * related information.
21: * p_action_flag Indicates wether Bank account information needs
22: * to be inserted or updated.

Line 46: (p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,

42: */
43:
44:
45: PROCEDURE REPLICATE_BANK_ACCOUNTS
46: (p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,
47: p_action_flag IN VARCHAR2,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,
50: x_msg_data OUT NOCOPY VARCHAR2

Line 55: (p_account_number IN XTR_BANK_ACCOUNTS.account_number%TYPE,

51: );
52:
53:
54: PROCEDURE REPLICATE_BANK_ACCOUNTS
55: (p_account_number IN XTR_BANK_ACCOUNTS.account_number%TYPE,
56: p_authorised IN XTR_BANK_ACCOUNTS.authorised%TYPE,
57: p_party_code IN XTR_BANK_ACCOUNTS.party_code%TYPE,
58: p_party_type IN XTR_BANK_ACCOUNTS.party_type%TYPE,
59: p_bank_code IN XTR_BANK_ACCOUNTS.bank_code%TYPE,

Line 56: p_authorised IN XTR_BANK_ACCOUNTS.authorised%TYPE,

52:
53:
54: PROCEDURE REPLICATE_BANK_ACCOUNTS
55: (p_account_number IN XTR_BANK_ACCOUNTS.account_number%TYPE,
56: p_authorised IN XTR_BANK_ACCOUNTS.authorised%TYPE,
57: p_party_code IN XTR_BANK_ACCOUNTS.party_code%TYPE,
58: p_party_type IN XTR_BANK_ACCOUNTS.party_type%TYPE,
59: p_bank_code IN XTR_BANK_ACCOUNTS.bank_code%TYPE,
60: p_currency IN XTR_BANK_ACCOUNTS.currency%TYPE,

Line 57: p_party_code IN XTR_BANK_ACCOUNTS.party_code%TYPE,

53:
54: PROCEDURE REPLICATE_BANK_ACCOUNTS
55: (p_account_number IN XTR_BANK_ACCOUNTS.account_number%TYPE,
56: p_authorised IN XTR_BANK_ACCOUNTS.authorised%TYPE,
57: p_party_code IN XTR_BANK_ACCOUNTS.party_code%TYPE,
58: p_party_type IN XTR_BANK_ACCOUNTS.party_type%TYPE,
59: p_bank_code IN XTR_BANK_ACCOUNTS.bank_code%TYPE,
60: p_currency IN XTR_BANK_ACCOUNTS.currency%TYPE,
61: p_bank_short_code IN XTR_BANK_ACCOUNTS.bank_short_code%TYPE,

Line 58: p_party_type IN XTR_BANK_ACCOUNTS.party_type%TYPE,

54: PROCEDURE REPLICATE_BANK_ACCOUNTS
55: (p_account_number IN XTR_BANK_ACCOUNTS.account_number%TYPE,
56: p_authorised IN XTR_BANK_ACCOUNTS.authorised%TYPE,
57: p_party_code IN XTR_BANK_ACCOUNTS.party_code%TYPE,
58: p_party_type IN XTR_BANK_ACCOUNTS.party_type%TYPE,
59: p_bank_code IN XTR_BANK_ACCOUNTS.bank_code%TYPE,
60: p_currency IN XTR_BANK_ACCOUNTS.currency%TYPE,
61: p_bank_short_code IN XTR_BANK_ACCOUNTS.bank_short_code%TYPE,
62: p_default_acct IN XTR_BANK_ACCOUNTS.default_acct%TYPE,

Line 59: p_bank_code IN XTR_BANK_ACCOUNTS.bank_code%TYPE,

55: (p_account_number IN XTR_BANK_ACCOUNTS.account_number%TYPE,
56: p_authorised IN XTR_BANK_ACCOUNTS.authorised%TYPE,
57: p_party_code IN XTR_BANK_ACCOUNTS.party_code%TYPE,
58: p_party_type IN XTR_BANK_ACCOUNTS.party_type%TYPE,
59: p_bank_code IN XTR_BANK_ACCOUNTS.bank_code%TYPE,
60: p_currency IN XTR_BANK_ACCOUNTS.currency%TYPE,
61: p_bank_short_code IN XTR_BANK_ACCOUNTS.bank_short_code%TYPE,
62: p_default_acct IN XTR_BANK_ACCOUNTS.default_acct%TYPE,
63: p_eft_script_name IN XTR_BANK_ACCOUNTS.eft_script_name%TYPE,

Line 60: p_currency IN XTR_BANK_ACCOUNTS.currency%TYPE,

56: p_authorised IN XTR_BANK_ACCOUNTS.authorised%TYPE,
57: p_party_code IN XTR_BANK_ACCOUNTS.party_code%TYPE,
58: p_party_type IN XTR_BANK_ACCOUNTS.party_type%TYPE,
59: p_bank_code IN XTR_BANK_ACCOUNTS.bank_code%TYPE,
60: p_currency IN XTR_BANK_ACCOUNTS.currency%TYPE,
61: p_bank_short_code IN XTR_BANK_ACCOUNTS.bank_short_code%TYPE,
62: p_default_acct IN XTR_BANK_ACCOUNTS.default_acct%TYPE,
63: p_eft_script_name IN XTR_BANK_ACCOUNTS.eft_script_name%TYPE,
64: p_code_combination_id IN XTR_BANK_ACCOUNTS.code_combination_id%TYPE,

Line 61: p_bank_short_code IN XTR_BANK_ACCOUNTS.bank_short_code%TYPE,

57: p_party_code IN XTR_BANK_ACCOUNTS.party_code%TYPE,
58: p_party_type IN XTR_BANK_ACCOUNTS.party_type%TYPE,
59: p_bank_code IN XTR_BANK_ACCOUNTS.bank_code%TYPE,
60: p_currency IN XTR_BANK_ACCOUNTS.currency%TYPE,
61: p_bank_short_code IN XTR_BANK_ACCOUNTS.bank_short_code%TYPE,
62: p_default_acct IN XTR_BANK_ACCOUNTS.default_acct%TYPE,
63: p_eft_script_name IN XTR_BANK_ACCOUNTS.eft_script_name%TYPE,
64: p_code_combination_id IN XTR_BANK_ACCOUNTS.code_combination_id%TYPE,
65: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.interest_calculation_basis%TYPE,

Line 62: p_default_acct IN XTR_BANK_ACCOUNTS.default_acct%TYPE,

58: p_party_type IN XTR_BANK_ACCOUNTS.party_type%TYPE,
59: p_bank_code IN XTR_BANK_ACCOUNTS.bank_code%TYPE,
60: p_currency IN XTR_BANK_ACCOUNTS.currency%TYPE,
61: p_bank_short_code IN XTR_BANK_ACCOUNTS.bank_short_code%TYPE,
62: p_default_acct IN XTR_BANK_ACCOUNTS.default_acct%TYPE,
63: p_eft_script_name IN XTR_BANK_ACCOUNTS.eft_script_name%TYPE,
64: p_code_combination_id IN XTR_BANK_ACCOUNTS.code_combination_id%TYPE,
65: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.interest_calculation_basis%TYPE,
66: p_location IN XTR_BANK_ACCOUNTS.location%TYPE,

Line 63: p_eft_script_name IN XTR_BANK_ACCOUNTS.eft_script_name%TYPE,

59: p_bank_code IN XTR_BANK_ACCOUNTS.bank_code%TYPE,
60: p_currency IN XTR_BANK_ACCOUNTS.currency%TYPE,
61: p_bank_short_code IN XTR_BANK_ACCOUNTS.bank_short_code%TYPE,
62: p_default_acct IN XTR_BANK_ACCOUNTS.default_acct%TYPE,
63: p_eft_script_name IN XTR_BANK_ACCOUNTS.eft_script_name%TYPE,
64: p_code_combination_id IN XTR_BANK_ACCOUNTS.code_combination_id%TYPE,
65: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.interest_calculation_basis%TYPE,
66: p_location IN XTR_BANK_ACCOUNTS.location%TYPE,
67: p_portfolio_code IN XTR_BANK_ACCOUNTS.portfolio_code%TYPE,

Line 64: p_code_combination_id IN XTR_BANK_ACCOUNTS.code_combination_id%TYPE,

60: p_currency IN XTR_BANK_ACCOUNTS.currency%TYPE,
61: p_bank_short_code IN XTR_BANK_ACCOUNTS.bank_short_code%TYPE,
62: p_default_acct IN XTR_BANK_ACCOUNTS.default_acct%TYPE,
63: p_eft_script_name IN XTR_BANK_ACCOUNTS.eft_script_name%TYPE,
64: p_code_combination_id IN XTR_BANK_ACCOUNTS.code_combination_id%TYPE,
65: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.interest_calculation_basis%TYPE,
66: p_location IN XTR_BANK_ACCOUNTS.location%TYPE,
67: p_portfolio_code IN XTR_BANK_ACCOUNTS.portfolio_code%TYPE,
68: p_primary_settlement_method IN XTR_BANK_ACCOUNTS.primary_settlement_method%TYPE,

Line 65: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.interest_calculation_basis%TYPE,

61: p_bank_short_code IN XTR_BANK_ACCOUNTS.bank_short_code%TYPE,
62: p_default_acct IN XTR_BANK_ACCOUNTS.default_acct%TYPE,
63: p_eft_script_name IN XTR_BANK_ACCOUNTS.eft_script_name%TYPE,
64: p_code_combination_id IN XTR_BANK_ACCOUNTS.code_combination_id%TYPE,
65: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.interest_calculation_basis%TYPE,
66: p_location IN XTR_BANK_ACCOUNTS.location%TYPE,
67: p_portfolio_code IN XTR_BANK_ACCOUNTS.portfolio_code%TYPE,
68: p_primary_settlement_method IN XTR_BANK_ACCOUNTS.primary_settlement_method%TYPE,
69: p_street IN XTR_BANK_ACCOUNTS.street%TYPE,

Line 66: p_location IN XTR_BANK_ACCOUNTS.location%TYPE,

62: p_default_acct IN XTR_BANK_ACCOUNTS.default_acct%TYPE,
63: p_eft_script_name IN XTR_BANK_ACCOUNTS.eft_script_name%TYPE,
64: p_code_combination_id IN XTR_BANK_ACCOUNTS.code_combination_id%TYPE,
65: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.interest_calculation_basis%TYPE,
66: p_location IN XTR_BANK_ACCOUNTS.location%TYPE,
67: p_portfolio_code IN XTR_BANK_ACCOUNTS.portfolio_code%TYPE,
68: p_primary_settlement_method IN XTR_BANK_ACCOUNTS.primary_settlement_method%TYPE,
69: p_street IN XTR_BANK_ACCOUNTS.street%TYPE,
70: p_year_calc_type IN XTR_BANK_ACCOUNTS.year_calc_type%TYPE,

Line 67: p_portfolio_code IN XTR_BANK_ACCOUNTS.portfolio_code%TYPE,

63: p_eft_script_name IN XTR_BANK_ACCOUNTS.eft_script_name%TYPE,
64: p_code_combination_id IN XTR_BANK_ACCOUNTS.code_combination_id%TYPE,
65: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.interest_calculation_basis%TYPE,
66: p_location IN XTR_BANK_ACCOUNTS.location%TYPE,
67: p_portfolio_code IN XTR_BANK_ACCOUNTS.portfolio_code%TYPE,
68: p_primary_settlement_method IN XTR_BANK_ACCOUNTS.primary_settlement_method%TYPE,
69: p_street IN XTR_BANK_ACCOUNTS.street%TYPE,
70: p_year_calc_type IN XTR_BANK_ACCOUNTS.year_calc_type%TYPE,
71: p_swift_id IN XTR_BANK_ACCOUNTS.swift_id%TYPE,

Line 68: p_primary_settlement_method IN XTR_BANK_ACCOUNTS.primary_settlement_method%TYPE,

64: p_code_combination_id IN XTR_BANK_ACCOUNTS.code_combination_id%TYPE,
65: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.interest_calculation_basis%TYPE,
66: p_location IN XTR_BANK_ACCOUNTS.location%TYPE,
67: p_portfolio_code IN XTR_BANK_ACCOUNTS.portfolio_code%TYPE,
68: p_primary_settlement_method IN XTR_BANK_ACCOUNTS.primary_settlement_method%TYPE,
69: p_street IN XTR_BANK_ACCOUNTS.street%TYPE,
70: p_year_calc_type IN XTR_BANK_ACCOUNTS.year_calc_type%TYPE,
71: p_swift_id IN XTR_BANK_ACCOUNTS.swift_id%TYPE,
72: p_attribute_category IN XTR_BANK_ACCOUNTS.attribute_category%TYPE,

Line 69: p_street IN XTR_BANK_ACCOUNTS.street%TYPE,

65: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.interest_calculation_basis%TYPE,
66: p_location IN XTR_BANK_ACCOUNTS.location%TYPE,
67: p_portfolio_code IN XTR_BANK_ACCOUNTS.portfolio_code%TYPE,
68: p_primary_settlement_method IN XTR_BANK_ACCOUNTS.primary_settlement_method%TYPE,
69: p_street IN XTR_BANK_ACCOUNTS.street%TYPE,
70: p_year_calc_type IN XTR_BANK_ACCOUNTS.year_calc_type%TYPE,
71: p_swift_id IN XTR_BANK_ACCOUNTS.swift_id%TYPE,
72: p_attribute_category IN XTR_BANK_ACCOUNTS.attribute_category%TYPE,
73: p_attribute1 IN XTR_BANK_ACCOUNTS.attribute1%TYPE,

Line 70: p_year_calc_type IN XTR_BANK_ACCOUNTS.year_calc_type%TYPE,

66: p_location IN XTR_BANK_ACCOUNTS.location%TYPE,
67: p_portfolio_code IN XTR_BANK_ACCOUNTS.portfolio_code%TYPE,
68: p_primary_settlement_method IN XTR_BANK_ACCOUNTS.primary_settlement_method%TYPE,
69: p_street IN XTR_BANK_ACCOUNTS.street%TYPE,
70: p_year_calc_type IN XTR_BANK_ACCOUNTS.year_calc_type%TYPE,
71: p_swift_id IN XTR_BANK_ACCOUNTS.swift_id%TYPE,
72: p_attribute_category IN XTR_BANK_ACCOUNTS.attribute_category%TYPE,
73: p_attribute1 IN XTR_BANK_ACCOUNTS.attribute1%TYPE,
74: p_attribute2 IN XTR_BANK_ACCOUNTS.attribute2%TYPE,

Line 71: p_swift_id IN XTR_BANK_ACCOUNTS.swift_id%TYPE,

67: p_portfolio_code IN XTR_BANK_ACCOUNTS.portfolio_code%TYPE,
68: p_primary_settlement_method IN XTR_BANK_ACCOUNTS.primary_settlement_method%TYPE,
69: p_street IN XTR_BANK_ACCOUNTS.street%TYPE,
70: p_year_calc_type IN XTR_BANK_ACCOUNTS.year_calc_type%TYPE,
71: p_swift_id IN XTR_BANK_ACCOUNTS.swift_id%TYPE,
72: p_attribute_category IN XTR_BANK_ACCOUNTS.attribute_category%TYPE,
73: p_attribute1 IN XTR_BANK_ACCOUNTS.attribute1%TYPE,
74: p_attribute2 IN XTR_BANK_ACCOUNTS.attribute2%TYPE,
75: p_attribute3 IN XTR_BANK_ACCOUNTS.attribute3%TYPE,

Line 72: p_attribute_category IN XTR_BANK_ACCOUNTS.attribute_category%TYPE,

68: p_primary_settlement_method IN XTR_BANK_ACCOUNTS.primary_settlement_method%TYPE,
69: p_street IN XTR_BANK_ACCOUNTS.street%TYPE,
70: p_year_calc_type IN XTR_BANK_ACCOUNTS.year_calc_type%TYPE,
71: p_swift_id IN XTR_BANK_ACCOUNTS.swift_id%TYPE,
72: p_attribute_category IN XTR_BANK_ACCOUNTS.attribute_category%TYPE,
73: p_attribute1 IN XTR_BANK_ACCOUNTS.attribute1%TYPE,
74: p_attribute2 IN XTR_BANK_ACCOUNTS.attribute2%TYPE,
75: p_attribute3 IN XTR_BANK_ACCOUNTS.attribute3%TYPE,
76: p_attribute4 IN XTR_BANK_ACCOUNTS.attribute4%TYPE,

Line 73: p_attribute1 IN XTR_BANK_ACCOUNTS.attribute1%TYPE,

69: p_street IN XTR_BANK_ACCOUNTS.street%TYPE,
70: p_year_calc_type IN XTR_BANK_ACCOUNTS.year_calc_type%TYPE,
71: p_swift_id IN XTR_BANK_ACCOUNTS.swift_id%TYPE,
72: p_attribute_category IN XTR_BANK_ACCOUNTS.attribute_category%TYPE,
73: p_attribute1 IN XTR_BANK_ACCOUNTS.attribute1%TYPE,
74: p_attribute2 IN XTR_BANK_ACCOUNTS.attribute2%TYPE,
75: p_attribute3 IN XTR_BANK_ACCOUNTS.attribute3%TYPE,
76: p_attribute4 IN XTR_BANK_ACCOUNTS.attribute4%TYPE,
77: p_attribute5 IN XTR_BANK_ACCOUNTS.attribute5%TYPE,

Line 74: p_attribute2 IN XTR_BANK_ACCOUNTS.attribute2%TYPE,

70: p_year_calc_type IN XTR_BANK_ACCOUNTS.year_calc_type%TYPE,
71: p_swift_id IN XTR_BANK_ACCOUNTS.swift_id%TYPE,
72: p_attribute_category IN XTR_BANK_ACCOUNTS.attribute_category%TYPE,
73: p_attribute1 IN XTR_BANK_ACCOUNTS.attribute1%TYPE,
74: p_attribute2 IN XTR_BANK_ACCOUNTS.attribute2%TYPE,
75: p_attribute3 IN XTR_BANK_ACCOUNTS.attribute3%TYPE,
76: p_attribute4 IN XTR_BANK_ACCOUNTS.attribute4%TYPE,
77: p_attribute5 IN XTR_BANK_ACCOUNTS.attribute5%TYPE,
78: p_attribute6 IN XTR_BANK_ACCOUNTS.attribute6%TYPE,

Line 75: p_attribute3 IN XTR_BANK_ACCOUNTS.attribute3%TYPE,

71: p_swift_id IN XTR_BANK_ACCOUNTS.swift_id%TYPE,
72: p_attribute_category IN XTR_BANK_ACCOUNTS.attribute_category%TYPE,
73: p_attribute1 IN XTR_BANK_ACCOUNTS.attribute1%TYPE,
74: p_attribute2 IN XTR_BANK_ACCOUNTS.attribute2%TYPE,
75: p_attribute3 IN XTR_BANK_ACCOUNTS.attribute3%TYPE,
76: p_attribute4 IN XTR_BANK_ACCOUNTS.attribute4%TYPE,
77: p_attribute5 IN XTR_BANK_ACCOUNTS.attribute5%TYPE,
78: p_attribute6 IN XTR_BANK_ACCOUNTS.attribute6%TYPE,
79: p_attribute7 IN XTR_BANK_ACCOUNTS.attribute7%TYPE,

Line 76: p_attribute4 IN XTR_BANK_ACCOUNTS.attribute4%TYPE,

72: p_attribute_category IN XTR_BANK_ACCOUNTS.attribute_category%TYPE,
73: p_attribute1 IN XTR_BANK_ACCOUNTS.attribute1%TYPE,
74: p_attribute2 IN XTR_BANK_ACCOUNTS.attribute2%TYPE,
75: p_attribute3 IN XTR_BANK_ACCOUNTS.attribute3%TYPE,
76: p_attribute4 IN XTR_BANK_ACCOUNTS.attribute4%TYPE,
77: p_attribute5 IN XTR_BANK_ACCOUNTS.attribute5%TYPE,
78: p_attribute6 IN XTR_BANK_ACCOUNTS.attribute6%TYPE,
79: p_attribute7 IN XTR_BANK_ACCOUNTS.attribute7%TYPE,
80: p_attribute8 IN XTR_BANK_ACCOUNTS.attribute8%TYPE,

Line 77: p_attribute5 IN XTR_BANK_ACCOUNTS.attribute5%TYPE,

73: p_attribute1 IN XTR_BANK_ACCOUNTS.attribute1%TYPE,
74: p_attribute2 IN XTR_BANK_ACCOUNTS.attribute2%TYPE,
75: p_attribute3 IN XTR_BANK_ACCOUNTS.attribute3%TYPE,
76: p_attribute4 IN XTR_BANK_ACCOUNTS.attribute4%TYPE,
77: p_attribute5 IN XTR_BANK_ACCOUNTS.attribute5%TYPE,
78: p_attribute6 IN XTR_BANK_ACCOUNTS.attribute6%TYPE,
79: p_attribute7 IN XTR_BANK_ACCOUNTS.attribute7%TYPE,
80: p_attribute8 IN XTR_BANK_ACCOUNTS.attribute8%TYPE,
81: p_attribute9 IN XTR_BANK_ACCOUNTS.attribute9%TYPE,

Line 78: p_attribute6 IN XTR_BANK_ACCOUNTS.attribute6%TYPE,

74: p_attribute2 IN XTR_BANK_ACCOUNTS.attribute2%TYPE,
75: p_attribute3 IN XTR_BANK_ACCOUNTS.attribute3%TYPE,
76: p_attribute4 IN XTR_BANK_ACCOUNTS.attribute4%TYPE,
77: p_attribute5 IN XTR_BANK_ACCOUNTS.attribute5%TYPE,
78: p_attribute6 IN XTR_BANK_ACCOUNTS.attribute6%TYPE,
79: p_attribute7 IN XTR_BANK_ACCOUNTS.attribute7%TYPE,
80: p_attribute8 IN XTR_BANK_ACCOUNTS.attribute8%TYPE,
81: p_attribute9 IN XTR_BANK_ACCOUNTS.attribute9%TYPE,
82: p_attribute10 IN XTR_BANK_ACCOUNTS.attribute10%TYPE,

Line 79: p_attribute7 IN XTR_BANK_ACCOUNTS.attribute7%TYPE,

75: p_attribute3 IN XTR_BANK_ACCOUNTS.attribute3%TYPE,
76: p_attribute4 IN XTR_BANK_ACCOUNTS.attribute4%TYPE,
77: p_attribute5 IN XTR_BANK_ACCOUNTS.attribute5%TYPE,
78: p_attribute6 IN XTR_BANK_ACCOUNTS.attribute6%TYPE,
79: p_attribute7 IN XTR_BANK_ACCOUNTS.attribute7%TYPE,
80: p_attribute8 IN XTR_BANK_ACCOUNTS.attribute8%TYPE,
81: p_attribute9 IN XTR_BANK_ACCOUNTS.attribute9%TYPE,
82: p_attribute10 IN XTR_BANK_ACCOUNTS.attribute10%TYPE,
83: p_attribute11 IN XTR_BANK_ACCOUNTS.attribute11%TYPE,

Line 80: p_attribute8 IN XTR_BANK_ACCOUNTS.attribute8%TYPE,

76: p_attribute4 IN XTR_BANK_ACCOUNTS.attribute4%TYPE,
77: p_attribute5 IN XTR_BANK_ACCOUNTS.attribute5%TYPE,
78: p_attribute6 IN XTR_BANK_ACCOUNTS.attribute6%TYPE,
79: p_attribute7 IN XTR_BANK_ACCOUNTS.attribute7%TYPE,
80: p_attribute8 IN XTR_BANK_ACCOUNTS.attribute8%TYPE,
81: p_attribute9 IN XTR_BANK_ACCOUNTS.attribute9%TYPE,
82: p_attribute10 IN XTR_BANK_ACCOUNTS.attribute10%TYPE,
83: p_attribute11 IN XTR_BANK_ACCOUNTS.attribute11%TYPE,
84: p_attribute12 IN XTR_BANK_ACCOUNTS.attribute12%TYPE,

Line 81: p_attribute9 IN XTR_BANK_ACCOUNTS.attribute9%TYPE,

77: p_attribute5 IN XTR_BANK_ACCOUNTS.attribute5%TYPE,
78: p_attribute6 IN XTR_BANK_ACCOUNTS.attribute6%TYPE,
79: p_attribute7 IN XTR_BANK_ACCOUNTS.attribute7%TYPE,
80: p_attribute8 IN XTR_BANK_ACCOUNTS.attribute8%TYPE,
81: p_attribute9 IN XTR_BANK_ACCOUNTS.attribute9%TYPE,
82: p_attribute10 IN XTR_BANK_ACCOUNTS.attribute10%TYPE,
83: p_attribute11 IN XTR_BANK_ACCOUNTS.attribute11%TYPE,
84: p_attribute12 IN XTR_BANK_ACCOUNTS.attribute12%TYPE,
85: p_attribute13 IN XTR_BANK_ACCOUNTS.attribute13%TYPE,

Line 82: p_attribute10 IN XTR_BANK_ACCOUNTS.attribute10%TYPE,

78: p_attribute6 IN XTR_BANK_ACCOUNTS.attribute6%TYPE,
79: p_attribute7 IN XTR_BANK_ACCOUNTS.attribute7%TYPE,
80: p_attribute8 IN XTR_BANK_ACCOUNTS.attribute8%TYPE,
81: p_attribute9 IN XTR_BANK_ACCOUNTS.attribute9%TYPE,
82: p_attribute10 IN XTR_BANK_ACCOUNTS.attribute10%TYPE,
83: p_attribute11 IN XTR_BANK_ACCOUNTS.attribute11%TYPE,
84: p_attribute12 IN XTR_BANK_ACCOUNTS.attribute12%TYPE,
85: p_attribute13 IN XTR_BANK_ACCOUNTS.attribute13%TYPE,
86: p_attribute14 IN XTR_BANK_ACCOUNTS.attribute14%TYPE,

Line 83: p_attribute11 IN XTR_BANK_ACCOUNTS.attribute11%TYPE,

79: p_attribute7 IN XTR_BANK_ACCOUNTS.attribute7%TYPE,
80: p_attribute8 IN XTR_BANK_ACCOUNTS.attribute8%TYPE,
81: p_attribute9 IN XTR_BANK_ACCOUNTS.attribute9%TYPE,
82: p_attribute10 IN XTR_BANK_ACCOUNTS.attribute10%TYPE,
83: p_attribute11 IN XTR_BANK_ACCOUNTS.attribute11%TYPE,
84: p_attribute12 IN XTR_BANK_ACCOUNTS.attribute12%TYPE,
85: p_attribute13 IN XTR_BANK_ACCOUNTS.attribute13%TYPE,
86: p_attribute14 IN XTR_BANK_ACCOUNTS.attribute14%TYPE,
87: p_attribute15 IN XTR_BANK_ACCOUNTS.attribute15%TYPE,

Line 84: p_attribute12 IN XTR_BANK_ACCOUNTS.attribute12%TYPE,

80: p_attribute8 IN XTR_BANK_ACCOUNTS.attribute8%TYPE,
81: p_attribute9 IN XTR_BANK_ACCOUNTS.attribute9%TYPE,
82: p_attribute10 IN XTR_BANK_ACCOUNTS.attribute10%TYPE,
83: p_attribute11 IN XTR_BANK_ACCOUNTS.attribute11%TYPE,
84: p_attribute12 IN XTR_BANK_ACCOUNTS.attribute12%TYPE,
85: p_attribute13 IN XTR_BANK_ACCOUNTS.attribute13%TYPE,
86: p_attribute14 IN XTR_BANK_ACCOUNTS.attribute14%TYPE,
87: p_attribute15 IN XTR_BANK_ACCOUNTS.attribute15%TYPE,
88: p_pricing_model IN XTR_BANK_ACCOUNTS.pricing_model%TYPE,

Line 85: p_attribute13 IN XTR_BANK_ACCOUNTS.attribute13%TYPE,

81: p_attribute9 IN XTR_BANK_ACCOUNTS.attribute9%TYPE,
82: p_attribute10 IN XTR_BANK_ACCOUNTS.attribute10%TYPE,
83: p_attribute11 IN XTR_BANK_ACCOUNTS.attribute11%TYPE,
84: p_attribute12 IN XTR_BANK_ACCOUNTS.attribute12%TYPE,
85: p_attribute13 IN XTR_BANK_ACCOUNTS.attribute13%TYPE,
86: p_attribute14 IN XTR_BANK_ACCOUNTS.attribute14%TYPE,
87: p_attribute15 IN XTR_BANK_ACCOUNTS.attribute15%TYPE,
88: p_pricing_model IN XTR_BANK_ACCOUNTS.pricing_model%TYPE,
89: p_legal_account_name IN XTR_BANK_ACCOUNTS.legal_account_name%TYPE,

Line 86: p_attribute14 IN XTR_BANK_ACCOUNTS.attribute14%TYPE,

82: p_attribute10 IN XTR_BANK_ACCOUNTS.attribute10%TYPE,
83: p_attribute11 IN XTR_BANK_ACCOUNTS.attribute11%TYPE,
84: p_attribute12 IN XTR_BANK_ACCOUNTS.attribute12%TYPE,
85: p_attribute13 IN XTR_BANK_ACCOUNTS.attribute13%TYPE,
86: p_attribute14 IN XTR_BANK_ACCOUNTS.attribute14%TYPE,
87: p_attribute15 IN XTR_BANK_ACCOUNTS.attribute15%TYPE,
88: p_pricing_model IN XTR_BANK_ACCOUNTS.pricing_model%TYPE,
89: p_legal_account_name IN XTR_BANK_ACCOUNTS.legal_account_name%TYPE,
90: p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,

Line 87: p_attribute15 IN XTR_BANK_ACCOUNTS.attribute15%TYPE,

83: p_attribute11 IN XTR_BANK_ACCOUNTS.attribute11%TYPE,
84: p_attribute12 IN XTR_BANK_ACCOUNTS.attribute12%TYPE,
85: p_attribute13 IN XTR_BANK_ACCOUNTS.attribute13%TYPE,
86: p_attribute14 IN XTR_BANK_ACCOUNTS.attribute14%TYPE,
87: p_attribute15 IN XTR_BANK_ACCOUNTS.attribute15%TYPE,
88: p_pricing_model IN XTR_BANK_ACCOUNTS.pricing_model%TYPE,
89: p_legal_account_name IN XTR_BANK_ACCOUNTS.legal_account_name%TYPE,
90: p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,
91: p_bank_branch_id IN XTR_BANK_ACCOUNTS.bank_branch_id%TYPE,

Line 88: p_pricing_model IN XTR_BANK_ACCOUNTS.pricing_model%TYPE,

84: p_attribute12 IN XTR_BANK_ACCOUNTS.attribute12%TYPE,
85: p_attribute13 IN XTR_BANK_ACCOUNTS.attribute13%TYPE,
86: p_attribute14 IN XTR_BANK_ACCOUNTS.attribute14%TYPE,
87: p_attribute15 IN XTR_BANK_ACCOUNTS.attribute15%TYPE,
88: p_pricing_model IN XTR_BANK_ACCOUNTS.pricing_model%TYPE,
89: p_legal_account_name IN XTR_BANK_ACCOUNTS.legal_account_name%TYPE,
90: p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,
91: p_bank_branch_id IN XTR_BANK_ACCOUNTS.bank_branch_id%TYPE,
92: p_bank_acct_use_id IN XTR_BANK_ACCOUNTS.bank_acct_use_id%TYPE,

Line 89: p_legal_account_name IN XTR_BANK_ACCOUNTS.legal_account_name%TYPE,

85: p_attribute13 IN XTR_BANK_ACCOUNTS.attribute13%TYPE,
86: p_attribute14 IN XTR_BANK_ACCOUNTS.attribute14%TYPE,
87: p_attribute15 IN XTR_BANK_ACCOUNTS.attribute15%TYPE,
88: p_pricing_model IN XTR_BANK_ACCOUNTS.pricing_model%TYPE,
89: p_legal_account_name IN XTR_BANK_ACCOUNTS.legal_account_name%TYPE,
90: p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,
91: p_bank_branch_id IN XTR_BANK_ACCOUNTS.bank_branch_id%TYPE,
92: p_bank_acct_use_id IN XTR_BANK_ACCOUNTS.bank_acct_use_id%TYPE,
93: p_action_flag IN VARCHAR2,

Line 90: p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,

86: p_attribute14 IN XTR_BANK_ACCOUNTS.attribute14%TYPE,
87: p_attribute15 IN XTR_BANK_ACCOUNTS.attribute15%TYPE,
88: p_pricing_model IN XTR_BANK_ACCOUNTS.pricing_model%TYPE,
89: p_legal_account_name IN XTR_BANK_ACCOUNTS.legal_account_name%TYPE,
90: p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,
91: p_bank_branch_id IN XTR_BANK_ACCOUNTS.bank_branch_id%TYPE,
92: p_bank_acct_use_id IN XTR_BANK_ACCOUNTS.bank_acct_use_id%TYPE,
93: p_action_flag IN VARCHAR2,
94: x_return_status OUT NOCOPY VARCHAR2,

Line 91: p_bank_branch_id IN XTR_BANK_ACCOUNTS.bank_branch_id%TYPE,

87: p_attribute15 IN XTR_BANK_ACCOUNTS.attribute15%TYPE,
88: p_pricing_model IN XTR_BANK_ACCOUNTS.pricing_model%TYPE,
89: p_legal_account_name IN XTR_BANK_ACCOUNTS.legal_account_name%TYPE,
90: p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,
91: p_bank_branch_id IN XTR_BANK_ACCOUNTS.bank_branch_id%TYPE,
92: p_bank_acct_use_id IN XTR_BANK_ACCOUNTS.bank_acct_use_id%TYPE,
93: p_action_flag IN VARCHAR2,
94: x_return_status OUT NOCOPY VARCHAR2,
95: x_msg_count OUT NOCOPY NUMBER,

Line 92: p_bank_acct_use_id IN XTR_BANK_ACCOUNTS.bank_acct_use_id%TYPE,

88: p_pricing_model IN XTR_BANK_ACCOUNTS.pricing_model%TYPE,
89: p_legal_account_name IN XTR_BANK_ACCOUNTS.legal_account_name%TYPE,
90: p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,
91: p_bank_branch_id IN XTR_BANK_ACCOUNTS.bank_branch_id%TYPE,
92: p_bank_acct_use_id IN XTR_BANK_ACCOUNTS.bank_acct_use_id%TYPE,
93: p_action_flag IN VARCHAR2,
94: x_return_status OUT NOCOPY VARCHAR2,
95: x_msg_count OUT NOCOPY NUMBER,
96: x_msg_data OUT NOCOPY VARCHAR2,

Line 97: p_iban_number IN XTR_BANK_ACCOUNTS.iban%TYPE -- ER 6391546

93: p_action_flag IN VARCHAR2,
94: x_return_status OUT NOCOPY VARCHAR2,
95: x_msg_count OUT NOCOPY NUMBER,
96: x_msg_data OUT NOCOPY VARCHAR2,
97: p_iban_number IN XTR_BANK_ACCOUNTS.iban%TYPE -- ER 6391546
98: );
99:
100: /**
101: * PROCEDURE insert_bank_accounts

Line 112: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS

108: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
109: *
110: * ARGUMENTS
111: * IN:
112: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS
113: * This record type contains the Bank Account
114: * related information.
115: * IN/OUT:
116: *

Line 131: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,

127: * 05-19-2005 Bhargav Adireddy o Created.
128: *
129: */
130: PROCEDURE INSERT_BANK_ACCOUNTS
131: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,
132: x_return_status OUT NOCOPY VARCHAR2
133: );
134:
135: /**

Line 148: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS

144: *
145: * ARGUMENTS
146: * IN:
147: *
148: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS
149: * This record type contains the Bank Account
150: * related information.
151: * IN/OUT:
152: *

Line 168: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,

164: *
165: */
166:
167: PROCEDURE UPDATE_BANK_ACCOUNTS
168: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,
169: x_return_status OUT NOCOPY VARCHAR2
170: );
171:
172:

Line 177: * it is inserted/updated into XTR_BANK_ACCOUNTS. This procedure will

173: /**
174: * PROCEDURE validate_bank_accounts
175: *
176: * This procedure is used to validate the Bank account related data before
177: * it is inserted/updated into XTR_BANK_ACCOUNTS. This procedure will
178: * perform the required validations and puts the corresponding error
179: * messages into list
180: *
181: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 185: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS

181: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
182: *
183: * ARGUMENTS
184: * IN:
185: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS
186: * This record type contains the Bank Account
187: * related information.
188: * IN/OUT:
189: *

Line 206: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,

202: */
203:
204:
205: PROCEDURE VALIDATE_BANK_ACCOUNTS
206: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,
207: x_return_status IN OUT NOCOPY VARCHAR2
208: );
209:
210: /**

Line 214: * This procedure will insert/update XTR_BANK_ACCOUNTS table with the

210: /**
211: * PROCEDURE modify_bank_accounts
212: *
213: * DESCRIPTION
214: * This procedure will insert/update XTR_BANK_ACCOUNTS table with the
215: * Bank account data passed form CE. It will insert if p_action_flag = 'I'
216: * and update if p_action_flag = 'U'
217: *
218: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 222: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS

218: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
219: *
220: * ARGUMENTS
221: * IN:
222: * p_xtr_bank_account_rec Record type of XTR_BANK_ACCOUNTS
223: * This record type contains the Bank Account
224: * p_action_flag Indicates wether Bank account information needs
225: * to be inserted or updated.
226: * 'I' - Insert,'U' - Update related information.

Line 245: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,

241: */
242:
243:
244: PROCEDURE MODIFY_BANK_ACCOUNTS
245: ( p_xtr_bank_account_rec IN XTR_BANK_ACCOUNTS%ROWTYPE,
246: p_action_flag IN VARCHAR2,
247: x_return_status IN OUT NOCOPY VARCHAR2
248: );
249: /**

Line 297: * p_interest_rounding This is the ROUNDING_TYPE in XTR_BANK_ACCOUNTS.

293: * p_ce_bank_account_id This is the CE_BANK_ACCOUNT_ID in XTR_PARTY_INFO.
294: * CE will pass this parameter. This will tell us
295: * which Bank Account is attached with the interest
296: * schedule being updated.
297: * p_interest_rounding This is the ROUNDING_TYPE in XTR_BANK_ACCOUNTS.
298: * CE will pass this parameter. This will tell us
299: * what is the updated interest rounding.
300: * p_interest_includes This is the DAY_COUNT_TYPE in XTR_BANK_ACCOUNTS.
301: * CE will pass this parameter. This will tell us

Line 300: * p_interest_includes This is the DAY_COUNT_TYPE in XTR_BANK_ACCOUNTS.

296: * schedule being updated.
297: * p_interest_rounding This is the ROUNDING_TYPE in XTR_BANK_ACCOUNTS.
298: * CE will pass this parameter. This will tell us
299: * what is the updated interest rounding.
300: * p_interest_includes This is the DAY_COUNT_TYPE in XTR_BANK_ACCOUNTS.
301: * CE will pass this parameter. This will tell us
302: * what is the updated Interest Includes.
303: * p_interest_calculation
304: * _basis This is the BASIS in XTR_BANK_ACCOUNTS.

Line 304: * _basis This is the BASIS in XTR_BANK_ACCOUNTS.

300: * p_interest_includes This is the DAY_COUNT_TYPE in XTR_BANK_ACCOUNTS.
301: * CE will pass this parameter. This will tell us
302: * what is the updated Interest Includes.
303: * p_interest_calculation
304: * _basis This is the BASIS in XTR_BANK_ACCOUNTS.
305: * CE will pass this parameter. This will tell us
306: * what is the updated BASIS.
307: * p_day_count_basis This is the DAY_COUNT_BASIS in XTR_BANK_ACCOUNTS.
308: * CE will pass this parameter. This will tell us

Line 307: * p_day_count_basis This is the DAY_COUNT_BASIS in XTR_BANK_ACCOUNTS.

303: * p_interest_calculation
304: * _basis This is the BASIS in XTR_BANK_ACCOUNTS.
305: * CE will pass this parameter. This will tell us
306: * what is the updated BASIS.
307: * p_day_count_basis This is the DAY_COUNT_BASIS in XTR_BANK_ACCOUNTS.
308: * CE will pass this parameter. This will tell us
309: * what is the updated day count basis.
310: * IN/OUT:
311: *

Line 332: ( p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,--Chnage this to bank_account_id

328: */
329:
330:
331: PROCEDURE REPLICATE_INTEREST_SCHEDULES
332: ( p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,--Chnage this to bank_account_id
333: p_interest_rounding IN XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE,
334: p_interest_includes IN XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE,
335: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE,
336: p_day_count_basis IN XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE,

Line 333: p_interest_rounding IN XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE,

329:
330:
331: PROCEDURE REPLICATE_INTEREST_SCHEDULES
332: ( p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,--Chnage this to bank_account_id
333: p_interest_rounding IN XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE,
334: p_interest_includes IN XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE,
335: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE,
336: p_day_count_basis IN XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE,
337: x_return_status OUT NOCOPY VARCHAR2,

Line 334: p_interest_includes IN XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE,

330:
331: PROCEDURE REPLICATE_INTEREST_SCHEDULES
332: ( p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,--Chnage this to bank_account_id
333: p_interest_rounding IN XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE,
334: p_interest_includes IN XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE,
335: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE,
336: p_day_count_basis IN XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE,
337: x_return_status OUT NOCOPY VARCHAR2,
338: x_msg_count OUT NOCOPY NUMBER,

Line 335: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE,

331: PROCEDURE REPLICATE_INTEREST_SCHEDULES
332: ( p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,--Chnage this to bank_account_id
333: p_interest_rounding IN XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE,
334: p_interest_includes IN XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE,
335: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE,
336: p_day_count_basis IN XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE,
337: x_return_status OUT NOCOPY VARCHAR2,
338: x_msg_count OUT NOCOPY NUMBER,
339: x_msg_data OUT NOCOPY VARCHAR2

Line 336: p_day_count_basis IN XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE,

332: ( p_ce_bank_account_id IN XTR_BANK_ACCOUNTS.ce_bank_account_id%TYPE,--Chnage this to bank_account_id
333: p_interest_rounding IN XTR_BANK_ACCOUNTS.ROUNDING_TYPE%TYPE,
334: p_interest_includes IN XTR_BANK_ACCOUNTS.DAY_COUNT_TYPE%TYPE,
335: p_interest_calculation_basis IN XTR_BANK_ACCOUNTS.INTEREST_CALCULATION_BASIS%TYPE,
336: p_day_count_basis IN XTR_BANK_ACCOUNTS.YEAR_CALC_TYPE%TYPE,
337: x_return_status OUT NOCOPY VARCHAR2,
338: x_msg_count OUT NOCOPY NUMBER,
339: x_msg_data OUT NOCOPY VARCHAR2
340: );