APPS.HZ_UTILITY_V2PUB dependencies on HZ_DNB_REQUEST_LOG

Line 2591: * function that would return a 'Y' if this party_id exist in hz_dnb_request_log

2587: /**
2588: * FUNCTION IS_PARTY_ID_IN_REQUEST_LOG
2589: *
2590: * DESCRIPTION
2591: * function that would return a 'Y' if this party_id exist in hz_dnb_request_log
2592: * return 'N' if not.
2593: * ARGUMENTS
2594: * party_id IN NUMBER
2595: *

Line 2610: from hz_dnb_request_log log, hz_organization_profiles org

2606: /* Bug 3301467 : Comment the cursor code
2607:
2608: CURSOR c IS
2609: select 'N'
2610: from hz_dnb_request_log log, hz_organization_profiles org
2611: where log.party_id= p_party_id
2612: and org.party_id=log.party_id
2613: and org.actual_content_source='DNB'
2614: and org.effective_end_date is NULL

Line 2619: from hz_dnb_request_log log, hz_organization_profiles org

2615: and trunc(org.last_update_date) > trunc(log.last_update_date)
2616: and rownum =1
2617: UNION
2618: select 'Y'
2619: from hz_dnb_request_log log, hz_organization_profiles org
2620: where log.party_id= p_party_id
2621: and org.party_id=log.party_id
2622: and org.actual_content_source='DNB'
2623: and org.effective_end_date is NULL

Line 2631: from hz_dnb_request_log

2627:
2628: BEGIN
2629:
2630: select 'E' into l_exist
2631: from hz_dnb_request_log
2632: where party_id = p_party_id
2633: and rownum = 1;
2634:
2635: if l_exist = 'E' then

Line 2651: (select trunc(max(log.last_update_date)) from hz_dnb_request_log log

2647: where org.party_id = p_party_id
2648: and org.actual_content_source='DNB'
2649: and org.effective_end_date is NULL
2650: and trunc(org.last_update_date) =
2651: (select trunc(max(log.last_update_date)) from hz_dnb_request_log log
2652: where log.party_id = p_party_id);
2653: Exception
2654: when no_data_found then
2655: l_exist := 'N';