DBA Data[Home] [Help]

APPS.PON_REMINDER_NOTIFICATION_PKG dependencies on DBMS_RANDOM

Line 465: ||'_' ||to_char(sysdate, 'JSSSSS')||dbms_random.value;

461:
462:
463: --create the item key for the workflow
464: p_item_key := p_wf_item_key||'_'||l_TP_contact_id_table(i)||'_'||p_auction_header_id
465: ||'_' ||to_char(sysdate, 'JSSSSS')||dbms_random.value;
466:
467: IF(g_debug_enabled = 'Y') then
468: x_progress := ++l_progress || l_api_name || ' : starting workflow process'
469: || 'auction header id' || p_auction_header_id;

Line 518: ||p_auction_header_id||'_' ||to_char(sysdate, 'JSSSSS')||dbms_random.value;

514: RAISE;
515: END;
516:
517: p_item_key := p_wf_item_key||'_'||p_add_con_role_name||'_'
518: ||p_auction_header_id||'_' ||to_char(sysdate, 'JSSSSS')||dbms_random.value;
519:
520:
521: IF(g_debug_enabled = 'Y') then
522: x_progress := ++l_progress || l_api_name || ' : starting workflow process'