DBA Data[Home] [Help]

APPS.PON_REMINDER_NOTIFICATION_PKG dependencies on WF_ITEMS

Line 802: TYPE t_exact_item_key_type is TABLE OF WF_ITEMS.item_key%TYPE;

798: l_exact_item_key VARCHAR2(255);
799:
800: TYPE t_auction_header_id_type IS TABLE OF PON_AUCTION_HEADERS_ALL.auction_header_id%TYPE;
801: TYPE t_wf_item_key_type IS TABLE OF PON_AUCTION_HEADERS_ALL.wf_item_key%TYPE;
802: TYPE t_exact_item_key_type is TABLE OF WF_ITEMS.item_key%TYPE;
803:
804: t_auction_header_id t_auction_header_id_type := t_auction_header_id_type(null);
805: t_wf_item_key t_wf_item_key_type := t_wf_item_key_type(null);
806: t_exact_item_key t_exact_item_key_type := t_exact_item_key_type(null);

Line 851: FROM wf_items

847: BEGIN
848: SELECT item_key
849: BULK COLLECT INTO
850: t_exact_item_key
851: FROM wf_items
852: WHERE item_key LIKE l_item_key_like;
853:
854: EXCEPTION WHEN OTHERS THEN
855: