APPS.HZ_UTILITY_V2PUB dependencies on HZ_DNB_REQUEST_LOG

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

2571: /**
2572: * FUNCTION IS_PARTY_ID_IN_REQUEST_LOG
2573: *
2574: * DESCRIPTION
2575: * function that would return a 'Y' if this party_id exist in hz_dnb_request_log
2576: * return 'N' if not.
2577: * ARGUMENTS
2578: * party_id IN NUMBER
2579: *

Line 2594: from hz_dnb_request_log log, hz_organization_profiles org

2590: /* Bug 3301467 : Comment the cursor code
2591:
2592: CURSOR c IS
2593: select 'N'
2594: from hz_dnb_request_log log, hz_organization_profiles org
2595: where log.party_id= p_party_id
2596: and org.party_id=log.party_id
2597: and org.actual_content_source='DNB'
2598: and org.effective_end_date is NULL

Line 2603: from hz_dnb_request_log log, hz_organization_profiles org

2599: and trunc(org.last_update_date) > trunc(log.last_update_date)
2600: and rownum =1
2601: UNION
2602: select 'Y'
2603: from hz_dnb_request_log log, hz_organization_profiles org
2604: where log.party_id= p_party_id
2605: and org.party_id=log.party_id
2606: and org.actual_content_source='DNB'
2607: and org.effective_end_date is NULL

Line 2615: from hz_dnb_request_log

2611:
2612: BEGIN
2613:
2614: select 'E' into l_exist
2615: from hz_dnb_request_log
2616: where party_id = p_party_id
2617: and rownum = 1;
2618:
2619: if l_exist = 'E' then

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

2631: where org.party_id = p_party_id
2632: and org.actual_content_source='DNB'
2633: and org.effective_end_date is NULL
2634: and trunc(org.last_update_date) =
2635: (select trunc(max(log.last_update_date)) from hz_dnb_request_log log
2636: where log.party_id = p_party_id);
2637: Exception
2638: when no_data_found then
2639: l_exist := 'N';