APPS.ARI_DB_UTILITIES dependencies on ARI_UTILITIES

Line 897: -- Procedure is wrapper function to various ari_utilities calls.

893: END calc_aging_buckets;
894: --
895:
896:
897: -- Procedure is wrapper function to various ari_utilities calls.
898: -- The call is implemented as one call in order to limit the number
899: -- of times the DB tier is called.
900: PROCEDURE get_site_info(p_customer_id IN NUMBER,
901: p_addr_id IN NUMBER DEFAULT NULL,

Line 911: -- Bug 15876881 -Removed call to ari_utilities.get_contact(p_customer_id, p_addr_id, p_site_use);

907: IS
908: BEGIN
909:
910: p_contact_name := NULL;
911: -- Bug 15876881 -Removed call to ari_utilities.get_contact(p_customer_id, p_addr_id, p_site_use);
912: p_contact_phone := NULL;
913: -- Bug 15876881 -Removed call to ari_utilities.get_phone(p_customer_id, p_addr_id, 'ALL', p_site_use);
914:
915: -- If p_addr is null then the function is being called for "All Locations" entry.

Line 913: -- Bug 15876881 -Removed call to ari_utilities.get_phone(p_customer_id, p_addr_id, 'ALL', p_site_use);

909:
910: p_contact_name := NULL;
911: -- Bug 15876881 -Removed call to ari_utilities.get_contact(p_customer_id, p_addr_id, p_site_use);
912: p_contact_phone := NULL;
913: -- Bug 15876881 -Removed call to ari_utilities.get_phone(p_customer_id, p_addr_id, 'ALL', p_site_use);
914:
915: -- If p_addr is null then the function is being called for "All Locations" entry.
916: IF p_addr_id IS NULL
917: THEN

Line 921: p_site_uses := ari_utilities.get_site_uses( p_addr_id );

917: THEN
918: p_site_uses := NULL;
919: p_bill_to_site_use_id := NULL;
920: ELSE
921: p_site_uses := ari_utilities.get_site_uses( p_addr_id );
922: p_bill_to_site_use_id := ari_utilities.get_bill_to_site_use_id( p_addr_id );
923: END IF ;
924:
925: EXCEPTION

Line 922: p_bill_to_site_use_id := ari_utilities.get_bill_to_site_use_id( p_addr_id );

918: p_site_uses := NULL;
919: p_bill_to_site_use_id := NULL;
920: ELSE
921: p_site_uses := ari_utilities.get_site_uses( p_addr_id );
922: p_bill_to_site_use_id := ari_utilities.get_bill_to_site_use_id( p_addr_id );
923: END IF ;
924:
925: EXCEPTION
926: WHEN OTHERS THEN