APPS.HZ_MERGE_PARTIES_PUB dependencies on HZ_MERGE_PARTIES

Line 1: PACKAGE BODY HZ_MERGE_PARTIES_PUB AS

1: PACKAGE BODY HZ_MERGE_PARTIES_PUB AS
2: /*$Header: ARHMRGPB.pls 120.9 2005/12/06 06:25:41 ansingha noship $ */
3:
4: ----------------------------------
5: -- declaration of global variables

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'HZ_MERGE_PARTIES_PUB';

4: ----------------------------------
5: -- declaration of global variables
6: ----------------------------------
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'HZ_MERGE_PARTIES_PUB';
9:
10: ------------------------------------
11: -- declaration of private procedures
12: ------------------------------------

Line 95: HZ_MERGE_PARTIES_PUB.validate_merge_party(

91:
92: x_batch_party_id := NULL;
93:
94: -- validate the merge_batch _rec record
95: HZ_MERGE_PARTIES_PUB.validate_merge_party(
96: 'C' ,
97: p_batch_id,
98: p_merge_type,
99: p_from_party_id,

Line 116: HZ_MERGE_PARTIES_PKG.INSERT_ROW(

112:
113:
114:
115: -- call table-handler to insert the record
116: HZ_MERGE_PARTIES_PKG.INSERT_ROW(
117: px_BATCH_PARTY_ID => x_batch_party_id,
118: p_batch_id => p_batch_id,
119: p_merge_type => p_merge_type,
120: p_from_party_id => p_from_party_id,

Line 205: HZ_MERGE_PARTIES_PKG.Insert_Row(

201: l_from_reln_party_id IS NOT NULL THEN
202:
203: l_batch_party_id := null;
204:
205: HZ_MERGE_PARTIES_PKG.Insert_Row(
206: l_batch_party_id,
207: cp_BATCH_ID,
208: 'PARTY_MERGE',
209: l_from_reln_party_id,

Line 242: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE := NULL;

238: PROCEDURE check_party_hq( cp_batch_id IN NUMBER,
239: cp_from_party_id IN NUMBER,
240: cp_to_party_id IN NUMBER) IS
241:
242: l_batch_party_id HZ_MERGE_PARTIES.BATCH_PARTY_ID%TYPE := NULL;
243: l_dummy_count NUMBER := 0;
244:
245: CURSOR c_check_from_party( cp_batch_id IN NUMBER ,cp_from_party_id IN NUMBER, cp_to_party_id IN NUMBER ) IS
246: SELECT batch_party_id

Line 247: FROM HZ_MERGE_PARTIES

243: l_dummy_count NUMBER := 0;
244:
245: CURSOR c_check_from_party( cp_batch_id IN NUMBER ,cp_from_party_id IN NUMBER, cp_to_party_id IN NUMBER ) IS
246: SELECT batch_party_id
247: FROM HZ_MERGE_PARTIES
248: WHERE (from_party_id = cp_from_party_id OR
249: to_party_id = cp_to_party_id OR
250: from_party_id = cp_to_party_id OR
251: to_party_id = cp_from_party_id)

Line 468: END HZ_MERGE_PARTIES_PUB;

464: p_count => x_msg_count,
465: p_data => x_msg_data);
466:
467: END create_merge_party;
468: END HZ_MERGE_PARTIES_PUB;