APPS.ARI_DB_UTILITIES dependencies on ARI_UTILITIES

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

885: END calc_aging_buckets;
886: --
887:
888:
889: -- Procedure is wrapper function to various ari_utilities calls.
890: -- The call is implemented as one call in order to limit the number
891: -- of times the DB tier is called.
892: PROCEDURE get_site_info(p_customer_id IN NUMBER,
893: p_addr_id IN NUMBER DEFAULT NULL,

Line 902: p_contact_name := ari_utilities.get_contact(p_customer_id, p_addr_id, p_site_use);

898: p_bill_to_site_use_id OUT NOCOPY VARCHAR)
899: IS
900: BEGIN
901:
902: p_contact_name := ari_utilities.get_contact(p_customer_id, p_addr_id, p_site_use);
903: p_contact_phone := ari_utilities.get_phone(p_customer_id, p_addr_id, 'ALL', p_site_use);
904:
905: -- If p_addr is null then the function is being called for "All Locations" entry.
906: IF p_addr_id IS NULL

Line 903: p_contact_phone := ari_utilities.get_phone(p_customer_id, p_addr_id, 'ALL', p_site_use);

899: IS
900: BEGIN
901:
902: p_contact_name := ari_utilities.get_contact(p_customer_id, p_addr_id, p_site_use);
903: p_contact_phone := ari_utilities.get_phone(p_customer_id, p_addr_id, 'ALL', p_site_use);
904:
905: -- If p_addr is null then the function is being called for "All Locations" entry.
906: IF p_addr_id IS NULL
907: THEN

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

907: THEN
908: p_site_uses := NULL;
909: p_bill_to_site_use_id := NULL;
910: ELSE
911: p_site_uses := ari_utilities.get_site_uses( p_addr_id );
912: p_bill_to_site_use_id := ari_utilities.get_bill_to_site_use_id( p_addr_id );
913: END IF ;
914:
915: EXCEPTION

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

908: p_site_uses := NULL;
909: p_bill_to_site_use_id := NULL;
910: ELSE
911: p_site_uses := ari_utilities.get_site_uses( p_addr_id );
912: p_bill_to_site_use_id := ari_utilities.get_bill_to_site_use_id( p_addr_id );
913: END IF ;
914:
915: EXCEPTION
916: WHEN OTHERS THEN