DBA Data[Home] [Help]

APPS.HZ_AIA_CUSTOM_PKG dependencies on HZ_ORG_CUST_BO_TBL

Line 289: x_org_cust_objs OUT NOCOPY HZ_ORG_CUST_BO_TBL

285:
286: PROCEDURE get_related_org_cust_objs(
287: p_batch_id IN NUMBER,
288: p_merge_to_party_id IN NUMBER,
289: x_org_cust_objs OUT NOCOPY HZ_ORG_CUST_BO_TBL
290: ) IS
291: CURSOR get_related_org_cust(l_batch_id NUMBER) IS
292: SELECT distinct cr.cust_account_id, r2.object_id
293: from HZ_MERGE_BATCH mb, HZ_MERGE_PARTIES mp, HZ_MERGE_PARTY_HISTORY mph,

Line 318: x_org_cust_objs := HZ_ORG_CUST_BO_TBL();

314: l_msg_data VARCHAR2(2000);
315: l_msg_count NUMBER;
316: l_debug_prefix VARCHAR2(30);
317: BEGIN
318: x_org_cust_objs := HZ_ORG_CUST_BO_TBL();
319: i := 1;
320: OPEN get_related_org_cust(p_batch_id);
321: LOOP
322: FETCH get_related_org_cust INTO l_ca_id, l_org_id;

Line 1025: x_org_cust_objs OUT NOCOPY HZ_ORG_CUST_BO_TBL,

1021: p_from_org_id IN NUMBER,
1022: p_to_org_id IN NUMBER,
1023: p_from_acct_id IN NUMBER,
1024: p_to_acct_id IN NUMBER,
1025: x_org_cust_objs OUT NOCOPY HZ_ORG_CUST_BO_TBL,
1026: x_return_status OUT NOCOPY VARCHAR2,
1027: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
1028: ) IS
1029: l_debug_prefix VARCHAR2(30) := '';

Line 1050: x_org_cust_objs := HZ_ORG_CUST_BO_TBL();

1046: p_prefix=>l_debug_prefix,
1047: p_msg_level=>fnd_log.level_procedure);
1048: END IF;
1049:
1050: x_org_cust_objs := HZ_ORG_CUST_BO_TBL();
1051:
1052: FOR i IN 1..2 LOOP
1053: -- If same from to account and same from to org
1054: -- quit the 2nd loop