16:
17: l_merge_reason_code VARCHAR2(30);
18:
19: BEGIN
20: x_return_status := FND_API.G_RET_STS_SUCCESS;
21:
22: SELECT merge_reason_code
23: INTO l_merge_reason_code
24: FROM hz_merge_batch
48: END IF;
49:
50: EXCEPTION
51: WHEN others THEN
52: x_return_status := FND_API.G_RET_STS_ERROR;
53:
54: END ISC_BOOK_SUM2_F_M;
55:
56: PROCEDURE ISC_BOOK_SUM2_PDUE_F_M (
67:
68: l_merge_reason_code VARCHAR2(30);
69:
70: BEGIN
71: x_return_status := FND_API.G_RET_STS_SUCCESS;
72:
73: SELECT merge_reason_code
74: INTO l_merge_reason_code
75: FROM hz_merge_batch
95: END IF;
96:
97: EXCEPTION
98: WHEN others THEN
99: x_return_status := FND_API.G_RET_STS_ERROR;
100:
101: END ISC_BOOK_SUM2_PDUE_F_M;
102:
103: PROCEDURE ISC_BOOK_SUM2_PDUE2_F_M (
114:
115: l_merge_reason_code VARCHAR2(30);
116:
117: BEGIN
118: x_return_status := FND_API.G_RET_STS_SUCCESS;
119:
120: SELECT merge_reason_code
121: INTO l_merge_reason_code
122: FROM hz_merge_batch
142: END IF;
143:
144: EXCEPTION
145: WHEN others THEN
146: x_return_status := FND_API.G_RET_STS_ERROR;
147:
148: END ISC_BOOK_SUM2_PDUE2_F_M;
149:
150: PROCEDURE ISC_BOOK_SUM2_BKORD_F_M (
161:
162: l_merge_reason_code VARCHAR2(30);
163:
164: BEGIN
165: x_return_status := FND_API.G_RET_STS_SUCCESS;
166:
167: SELECT merge_reason_code
168: INTO l_merge_reason_code
169: FROM hz_merge_batch
189: END IF;
190:
191: EXCEPTION
192: WHEN others THEN
193: x_return_status := FND_API.G_RET_STS_ERROR;
194:
195: END ISC_BOOK_SUM2_BKORD_F_M;
196:
197: