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_BRANCHES_P dependencies on XTR_PARTY_INFO

Line 18: * p_xtr_party_info_rec Record type of XTR_PARTY_INFO.

14: *
15: * ARGUMENTS
16: * IN:
17: *
18: * p_xtr_party_info_rec Record type of XTR_PARTY_INFO.
19: * This record type contains the Bank/Bank Branch
20: * related information about the bank attached with
21: * Bank Account.
22: * IN/OUT:

Line 43: ( p_xtr_party_info_rec IN XTR_PARTY_INFO%ROWTYPE,

39: *
40: */
41:
42: PROCEDURE UPDATE_BANK_BRANCHES
43: ( p_xtr_party_info_rec IN XTR_PARTY_INFO%ROWTYPE,
44: p_update_type IN NUMBER,
45: x_return_status OUT NOCOPY VARCHAR2,
46: x_msg_count OUT NOCOPY NUMBER,
47: x_msg_data OUT NOCOPY VARCHAR2

Line 53: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,

49:
50:
51: /* This procedure is written so that CE can pass the individual parameters instead of ROW TYPE */
52: PROCEDURE UPDATE_BANK_BRANCHES
53: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
54: p_short_name IN XTR_PARTY_INFO.short_name%TYPE,
55: p_full_name IN XTR_PARTY_INFO.full_name%TYPE,
56: p_swift_id IN XTR_PARTY_INFO.swift_id%TYPE,
57: x_return_status OUT NOCOPY VARCHAR2,

Line 54: p_short_name IN XTR_PARTY_INFO.short_name%TYPE,

50:
51: /* This procedure is written so that CE can pass the individual parameters instead of ROW TYPE */
52: PROCEDURE UPDATE_BANK_BRANCHES
53: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
54: p_short_name IN XTR_PARTY_INFO.short_name%TYPE,
55: p_full_name IN XTR_PARTY_INFO.full_name%TYPE,
56: p_swift_id IN XTR_PARTY_INFO.swift_id%TYPE,
57: x_return_status OUT NOCOPY VARCHAR2,
58: x_msg_count OUT NOCOPY NUMBER,

Line 55: p_full_name IN XTR_PARTY_INFO.full_name%TYPE,

51: /* This procedure is written so that CE can pass the individual parameters instead of ROW TYPE */
52: PROCEDURE UPDATE_BANK_BRANCHES
53: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
54: p_short_name IN XTR_PARTY_INFO.short_name%TYPE,
55: p_full_name IN XTR_PARTY_INFO.full_name%TYPE,
56: p_swift_id IN XTR_PARTY_INFO.swift_id%TYPE,
57: x_return_status OUT NOCOPY VARCHAR2,
58: x_msg_count OUT NOCOPY NUMBER,
59: x_msg_data OUT NOCOPY VARCHAR2

Line 56: p_swift_id IN XTR_PARTY_INFO.swift_id%TYPE,

52: PROCEDURE UPDATE_BANK_BRANCHES
53: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
54: p_short_name IN XTR_PARTY_INFO.short_name%TYPE,
55: p_full_name IN XTR_PARTY_INFO.full_name%TYPE,
56: p_swift_id IN XTR_PARTY_INFO.swift_id%TYPE,
57: x_return_status OUT NOCOPY VARCHAR2,
58: x_msg_count OUT NOCOPY NUMBER,
59: x_msg_data OUT NOCOPY VARCHAR2
60: );

Line 65: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,

61:
62:
63: /* This procedure is written so that CE can pass the individual parameters instead of ROW TYPE */
64: PROCEDURE UPDATE_BANK_BRANCHES
65: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
66: p_address_2 IN XTR_PARTY_INFO.address_2%TYPE,
67: p_address_3 IN XTR_PARTY_INFO.address_3%TYPE,
68: p_address_4 IN XTR_PARTY_INFO.address_4%TYPE,
69: p_address_5 IN XTR_PARTY_INFO.address_5%TYPE,

Line 66: p_address_2 IN XTR_PARTY_INFO.address_2%TYPE,

62:
63: /* This procedure is written so that CE can pass the individual parameters instead of ROW TYPE */
64: PROCEDURE UPDATE_BANK_BRANCHES
65: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
66: p_address_2 IN XTR_PARTY_INFO.address_2%TYPE,
67: p_address_3 IN XTR_PARTY_INFO.address_3%TYPE,
68: p_address_4 IN XTR_PARTY_INFO.address_4%TYPE,
69: p_address_5 IN XTR_PARTY_INFO.address_5%TYPE,
70: p_country_code IN XTR_PARTY_INFO.country_code%TYPE,

Line 67: p_address_3 IN XTR_PARTY_INFO.address_3%TYPE,

63: /* This procedure is written so that CE can pass the individual parameters instead of ROW TYPE */
64: PROCEDURE UPDATE_BANK_BRANCHES
65: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
66: p_address_2 IN XTR_PARTY_INFO.address_2%TYPE,
67: p_address_3 IN XTR_PARTY_INFO.address_3%TYPE,
68: p_address_4 IN XTR_PARTY_INFO.address_4%TYPE,
69: p_address_5 IN XTR_PARTY_INFO.address_5%TYPE,
70: p_country_code IN XTR_PARTY_INFO.country_code%TYPE,
71: p_state_code IN XTR_PARTY_INFO.state_code%TYPE,

Line 68: p_address_4 IN XTR_PARTY_INFO.address_4%TYPE,

64: PROCEDURE UPDATE_BANK_BRANCHES
65: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
66: p_address_2 IN XTR_PARTY_INFO.address_2%TYPE,
67: p_address_3 IN XTR_PARTY_INFO.address_3%TYPE,
68: p_address_4 IN XTR_PARTY_INFO.address_4%TYPE,
69: p_address_5 IN XTR_PARTY_INFO.address_5%TYPE,
70: p_country_code IN XTR_PARTY_INFO.country_code%TYPE,
71: p_state_code IN XTR_PARTY_INFO.state_code%TYPE,
72: x_return_status OUT NOCOPY VARCHAR2,

Line 69: p_address_5 IN XTR_PARTY_INFO.address_5%TYPE,

65: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
66: p_address_2 IN XTR_PARTY_INFO.address_2%TYPE,
67: p_address_3 IN XTR_PARTY_INFO.address_3%TYPE,
68: p_address_4 IN XTR_PARTY_INFO.address_4%TYPE,
69: p_address_5 IN XTR_PARTY_INFO.address_5%TYPE,
70: p_country_code IN XTR_PARTY_INFO.country_code%TYPE,
71: p_state_code IN XTR_PARTY_INFO.state_code%TYPE,
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_msg_count OUT NOCOPY NUMBER,

Line 70: p_country_code IN XTR_PARTY_INFO.country_code%TYPE,

66: p_address_2 IN XTR_PARTY_INFO.address_2%TYPE,
67: p_address_3 IN XTR_PARTY_INFO.address_3%TYPE,
68: p_address_4 IN XTR_PARTY_INFO.address_4%TYPE,
69: p_address_5 IN XTR_PARTY_INFO.address_5%TYPE,
70: p_country_code IN XTR_PARTY_INFO.country_code%TYPE,
71: p_state_code IN XTR_PARTY_INFO.state_code%TYPE,
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_msg_count OUT NOCOPY NUMBER,
74: x_msg_data OUT NOCOPY VARCHAR2

Line 71: p_state_code IN XTR_PARTY_INFO.state_code%TYPE,

67: p_address_3 IN XTR_PARTY_INFO.address_3%TYPE,
68: p_address_4 IN XTR_PARTY_INFO.address_4%TYPE,
69: p_address_5 IN XTR_PARTY_INFO.address_5%TYPE,
70: p_country_code IN XTR_PARTY_INFO.country_code%TYPE,
71: p_state_code IN XTR_PARTY_INFO.state_code%TYPE,
72: x_return_status OUT NOCOPY VARCHAR2,
73: x_msg_count OUT NOCOPY NUMBER,
74: x_msg_data OUT NOCOPY VARCHAR2
75: );

Line 80: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,

76:
77:
78: /* This procedure is written so that CE can pass the individual parameters instead of ROW TYPE */
79: PROCEDURE UPDATE_BANK_BRANCHES
80: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
81: p_contact_name IN XTR_PARTY_INFO.contact_name%TYPE,
82: p_email_address IN XTR_PARTY_INFO.email_address%TYPE,
83: p_fax_number IN XTR_PARTY_INFO.fax_number%TYPE,
84: p_phone_number IN XTR_PARTY_INFO.phone_number%TYPE,

Line 81: p_contact_name IN XTR_PARTY_INFO.contact_name%TYPE,

77:
78: /* This procedure is written so that CE can pass the individual parameters instead of ROW TYPE */
79: PROCEDURE UPDATE_BANK_BRANCHES
80: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
81: p_contact_name IN XTR_PARTY_INFO.contact_name%TYPE,
82: p_email_address IN XTR_PARTY_INFO.email_address%TYPE,
83: p_fax_number IN XTR_PARTY_INFO.fax_number%TYPE,
84: p_phone_number IN XTR_PARTY_INFO.phone_number%TYPE,
85: x_return_status OUT NOCOPY VARCHAR2,

Line 82: p_email_address IN XTR_PARTY_INFO.email_address%TYPE,

78: /* This procedure is written so that CE can pass the individual parameters instead of ROW TYPE */
79: PROCEDURE UPDATE_BANK_BRANCHES
80: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
81: p_contact_name IN XTR_PARTY_INFO.contact_name%TYPE,
82: p_email_address IN XTR_PARTY_INFO.email_address%TYPE,
83: p_fax_number IN XTR_PARTY_INFO.fax_number%TYPE,
84: p_phone_number IN XTR_PARTY_INFO.phone_number%TYPE,
85: x_return_status OUT NOCOPY VARCHAR2,
86: x_msg_count OUT NOCOPY NUMBER,

Line 83: p_fax_number IN XTR_PARTY_INFO.fax_number%TYPE,

79: PROCEDURE UPDATE_BANK_BRANCHES
80: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
81: p_contact_name IN XTR_PARTY_INFO.contact_name%TYPE,
82: p_email_address IN XTR_PARTY_INFO.email_address%TYPE,
83: p_fax_number IN XTR_PARTY_INFO.fax_number%TYPE,
84: p_phone_number IN XTR_PARTY_INFO.phone_number%TYPE,
85: x_return_status OUT NOCOPY VARCHAR2,
86: x_msg_count OUT NOCOPY NUMBER,
87: x_msg_data OUT NOCOPY VARCHAR2

Line 84: p_phone_number IN XTR_PARTY_INFO.phone_number%TYPE,

80: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
81: p_contact_name IN XTR_PARTY_INFO.contact_name%TYPE,
82: p_email_address IN XTR_PARTY_INFO.email_address%TYPE,
83: p_fax_number IN XTR_PARTY_INFO.fax_number%TYPE,
84: p_phone_number IN XTR_PARTY_INFO.phone_number%TYPE,
85: x_return_status OUT NOCOPY VARCHAR2,
86: x_msg_count OUT NOCOPY NUMBER,
87: x_msg_data OUT NOCOPY VARCHAR2
88: );

Line 93: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,

89:
90:
91: /* This procedure is written so that CE can pass the individual parameters instead of ROW TYPE */
92: PROCEDURE UPDATE_BANK_BRANCHES
93: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
94: p_address_2 IN XTR_PARTY_INFO.address_2%TYPE,
95: p_address_3 IN XTR_PARTY_INFO.address_3%TYPE,
96: p_address_4 IN XTR_PARTY_INFO.address_4%TYPE,
97: p_address_5 IN XTR_PARTY_INFO.address_5%TYPE,

Line 94: p_address_2 IN XTR_PARTY_INFO.address_2%TYPE,

90:
91: /* This procedure is written so that CE can pass the individual parameters instead of ROW TYPE */
92: PROCEDURE UPDATE_BANK_BRANCHES
93: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
94: p_address_2 IN XTR_PARTY_INFO.address_2%TYPE,
95: p_address_3 IN XTR_PARTY_INFO.address_3%TYPE,
96: p_address_4 IN XTR_PARTY_INFO.address_4%TYPE,
97: p_address_5 IN XTR_PARTY_INFO.address_5%TYPE,
98: p_p_address_1 IN XTR_PARTY_INFO.p_address_1%TYPE,

Line 95: p_address_3 IN XTR_PARTY_INFO.address_3%TYPE,

91: /* This procedure is written so that CE can pass the individual parameters instead of ROW TYPE */
92: PROCEDURE UPDATE_BANK_BRANCHES
93: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
94: p_address_2 IN XTR_PARTY_INFO.address_2%TYPE,
95: p_address_3 IN XTR_PARTY_INFO.address_3%TYPE,
96: p_address_4 IN XTR_PARTY_INFO.address_4%TYPE,
97: p_address_5 IN XTR_PARTY_INFO.address_5%TYPE,
98: p_p_address_1 IN XTR_PARTY_INFO.p_address_1%TYPE,
99: p_p_address_2 IN XTR_PARTY_INFO.p_address_2%TYPE,

Line 96: p_address_4 IN XTR_PARTY_INFO.address_4%TYPE,

92: PROCEDURE UPDATE_BANK_BRANCHES
93: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
94: p_address_2 IN XTR_PARTY_INFO.address_2%TYPE,
95: p_address_3 IN XTR_PARTY_INFO.address_3%TYPE,
96: p_address_4 IN XTR_PARTY_INFO.address_4%TYPE,
97: p_address_5 IN XTR_PARTY_INFO.address_5%TYPE,
98: p_p_address_1 IN XTR_PARTY_INFO.p_address_1%TYPE,
99: p_p_address_2 IN XTR_PARTY_INFO.p_address_2%TYPE,
100: p_p_address_3 IN XTR_PARTY_INFO.p_address_3%TYPE,

Line 97: p_address_5 IN XTR_PARTY_INFO.address_5%TYPE,

93: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.ce_bank_branch_id%TYPE,
94: p_address_2 IN XTR_PARTY_INFO.address_2%TYPE,
95: p_address_3 IN XTR_PARTY_INFO.address_3%TYPE,
96: p_address_4 IN XTR_PARTY_INFO.address_4%TYPE,
97: p_address_5 IN XTR_PARTY_INFO.address_5%TYPE,
98: p_p_address_1 IN XTR_PARTY_INFO.p_address_1%TYPE,
99: p_p_address_2 IN XTR_PARTY_INFO.p_address_2%TYPE,
100: p_p_address_3 IN XTR_PARTY_INFO.p_address_3%TYPE,
101: p_p_address_4 IN XTR_PARTY_INFO.p_address_4%TYPE,

Line 98: p_p_address_1 IN XTR_PARTY_INFO.p_address_1%TYPE,

94: p_address_2 IN XTR_PARTY_INFO.address_2%TYPE,
95: p_address_3 IN XTR_PARTY_INFO.address_3%TYPE,
96: p_address_4 IN XTR_PARTY_INFO.address_4%TYPE,
97: p_address_5 IN XTR_PARTY_INFO.address_5%TYPE,
98: p_p_address_1 IN XTR_PARTY_INFO.p_address_1%TYPE,
99: p_p_address_2 IN XTR_PARTY_INFO.p_address_2%TYPE,
100: p_p_address_3 IN XTR_PARTY_INFO.p_address_3%TYPE,
101: p_p_address_4 IN XTR_PARTY_INFO.p_address_4%TYPE,
102: p_state_code IN XTR_PARTY_INFO.state_code%TYPE,

Line 99: p_p_address_2 IN XTR_PARTY_INFO.p_address_2%TYPE,

95: p_address_3 IN XTR_PARTY_INFO.address_3%TYPE,
96: p_address_4 IN XTR_PARTY_INFO.address_4%TYPE,
97: p_address_5 IN XTR_PARTY_INFO.address_5%TYPE,
98: p_p_address_1 IN XTR_PARTY_INFO.p_address_1%TYPE,
99: p_p_address_2 IN XTR_PARTY_INFO.p_address_2%TYPE,
100: p_p_address_3 IN XTR_PARTY_INFO.p_address_3%TYPE,
101: p_p_address_4 IN XTR_PARTY_INFO.p_address_4%TYPE,
102: p_state_code IN XTR_PARTY_INFO.state_code%TYPE,
103: p_swift_id IN XTR_PARTY_INFO.swift_id%TYPE,

Line 100: p_p_address_3 IN XTR_PARTY_INFO.p_address_3%TYPE,

96: p_address_4 IN XTR_PARTY_INFO.address_4%TYPE,
97: p_address_5 IN XTR_PARTY_INFO.address_5%TYPE,
98: p_p_address_1 IN XTR_PARTY_INFO.p_address_1%TYPE,
99: p_p_address_2 IN XTR_PARTY_INFO.p_address_2%TYPE,
100: p_p_address_3 IN XTR_PARTY_INFO.p_address_3%TYPE,
101: p_p_address_4 IN XTR_PARTY_INFO.p_address_4%TYPE,
102: p_state_code IN XTR_PARTY_INFO.state_code%TYPE,
103: p_swift_id IN XTR_PARTY_INFO.swift_id%TYPE,
104: x_return_status OUT NOCOPY VARCHAR2,

Line 101: p_p_address_4 IN XTR_PARTY_INFO.p_address_4%TYPE,

97: p_address_5 IN XTR_PARTY_INFO.address_5%TYPE,
98: p_p_address_1 IN XTR_PARTY_INFO.p_address_1%TYPE,
99: p_p_address_2 IN XTR_PARTY_INFO.p_address_2%TYPE,
100: p_p_address_3 IN XTR_PARTY_INFO.p_address_3%TYPE,
101: p_p_address_4 IN XTR_PARTY_INFO.p_address_4%TYPE,
102: p_state_code IN XTR_PARTY_INFO.state_code%TYPE,
103: p_swift_id IN XTR_PARTY_INFO.swift_id%TYPE,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,

Line 102: p_state_code IN XTR_PARTY_INFO.state_code%TYPE,

98: p_p_address_1 IN XTR_PARTY_INFO.p_address_1%TYPE,
99: p_p_address_2 IN XTR_PARTY_INFO.p_address_2%TYPE,
100: p_p_address_3 IN XTR_PARTY_INFO.p_address_3%TYPE,
101: p_p_address_4 IN XTR_PARTY_INFO.p_address_4%TYPE,
102: p_state_code IN XTR_PARTY_INFO.state_code%TYPE,
103: p_swift_id IN XTR_PARTY_INFO.swift_id%TYPE,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2

Line 103: p_swift_id IN XTR_PARTY_INFO.swift_id%TYPE,

99: p_p_address_2 IN XTR_PARTY_INFO.p_address_2%TYPE,
100: p_p_address_3 IN XTR_PARTY_INFO.p_address_3%TYPE,
101: p_p_address_4 IN XTR_PARTY_INFO.p_address_4%TYPE,
102: p_state_code IN XTR_PARTY_INFO.state_code%TYPE,
103: p_swift_id IN XTR_PARTY_INFO.swift_id%TYPE,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2
107: );

Line 118: * before it is inserted into XTR_PARTY_INFO. This procedure will perform the

114: * PROCEDURE validate_bank_branch
115: *
116: * DESCRIPTION
117: * This procedure is used to validate the Bank/Bank Branch related data
118: * before it is inserted into XTR_PARTY_INFO. This procedure will perform the
119: * required validations and puts the corresponding error messages into list
120: *
121: *
122: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 126: * p_xtr_party_info_rec Record type of XTR_PARTY_INFO.

122: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
123: *
124: * ARGUMENTS
125: * IN:
126: * p_xtr_party_info_rec Record type of XTR_PARTY_INFO.
127: * This record type contains the Bank/Bank Branch
128: * related information about the bank attached with
129: * Bank Account.
130: * IN/OUT:

Line 147: ( p_xtr_party_info_rec IN XTR_PARTY_INFO%ROWTYPE,

143: *
144: */
145:
146: PROCEDURE VALIDATE_BANK_BRANCH
147: ( p_xtr_party_info_rec IN XTR_PARTY_INFO%ROWTYPE,
148: p_update_type IN NUMBER,
149: x_return_status IN OUT NOCOPY VARCHAR2
150: );
151:

Line 156: * This procedure will update XTR_PARTY_INFO table with the

152: /**
153: * PROCEDURE modify_bank_branch
154: *
155: * DESCRIPTION
156: * This procedure will update XTR_PARTY_INFO table with the
157: * Bank Branch data passed form CE.
158: *
159: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
160: *

Line 163: * p_xtr_party_info_rec Record type of XTR_PARTY_INFO.

159: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
160: *
161: * ARGUMENTS
162: * IN:
163: * p_xtr_party_info_rec Record type of XTR_PARTY_INFO.
164: * This record type contains the Bank/Bank Branch
165: * related information about the bank attached with
166: * Bank Account. related information.
167: * IN/OUT:

Line 185: ( p_xtr_party_info_rec IN XTR_PARTY_INFO%ROWTYPE,

181: */
182:
183:
184: PROCEDURE MODIFY_BANK_BRANCH
185: ( p_xtr_party_info_rec IN XTR_PARTY_INFO%ROWTYPE,
186: p_update_type IN NUMBER,
187: x_return_status IN OUT NOCOPY VARCHAR2
188: );
189:

Line 195: * XTR_PARTY_INFO table with the Bank Branch ID passed form CE. This returns

191: * FUNCTION chk_bank_branch
192: *
193: * DESCRIPTION
194: * This Function will verify if a particular bank_branch_id exists in
195: * XTR_PARTY_INFO table with the Bank Branch ID passed form CE. This returns
196: * a BOOLEAN
197: *
198: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
199: * XTR_REPLICATE_BANK_ACCOUNTS_P.LOG_ERR_MSG()

Line 203: * XTR_PARTY_INFO. CE will pass the Bank Branch

199: * XTR_REPLICATE_BANK_ACCOUNTS_P.LOG_ERR_MSG()
200: * ARGUMENTS
201: * IN:
202: * p_ce_bank_branch_id This is type of CE_BANK_BRANCH_ID present in
203: * XTR_PARTY_INFO. CE will pass the Bank Branch
204: * id for which it is going to create an account.
205: * IN/OUT:
206: *
207: * OUT:

Line 209: * XTR_PARTY_INFO and FALSE if the Bank Branch does not exist in

205: * IN/OUT:
206: *
207: * OUT:
208: * This Function returns a Boolean. TRUE if the Bank Branch exists in
209: * XTR_PARTY_INFO and FALSE if the Bank Branch does not exist in
210: * XTR_PARTY_INFO
211: * NOTES
212: *
213: * MODIFICATION HISTORY

Line 210: * XTR_PARTY_INFO

206: *
207: * OUT:
208: * This Function returns a Boolean. TRUE if the Bank Branch exists in
209: * XTR_PARTY_INFO and FALSE if the Bank Branch does not exist in
210: * XTR_PARTY_INFO
211: * NOTES
212: *
213: * MODIFICATION HISTORY
214: *

Line 220: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.CE_BANK_BRANCH_ID%TYPE)

216: *
217: */
218:
219: FUNCTION CHK_BANK_BRANCH
220: ( p_ce_bank_branch_id IN XTR_PARTY_INFO.CE_BANK_BRANCH_ID%TYPE)
221: RETURN BOOLEAN;
222:
223: END XTR_REPLICATE_BANK_BRANCHES_P; -- Package spec
224: