APPS.PON_REMINDER_NOTIFICATION_PKG dependencies on PON_AUCTION_PKG

Line 623: PON_AUCTION_PKG.set_session_language(null, l_language_code);

619: l_user_name := p_supplier_role_name;
620:
621: -- set the db session language
622: PON_PROFILE_UTIL_PKG.get_wf_language(l_user_name, l_language_code);
623: PON_AUCTION_PKG.set_session_language(null, l_language_code);
624:
625: --------------------------------
626: --get the user time zone based on the p_supplier_role_name
627:

Line 628: l_user_timezone := PON_AUCTION_PKG.get_time_zone(l_user_name);

624:
625: --------------------------------
626: --get the user time zone based on the p_supplier_role_name
627:
628: l_user_timezone := PON_AUCTION_PKG.get_time_zone(l_user_name);
629: l_server_timezone := PON_AUCTION_PKG.get_oex_time_zone;
630:
631:
632: IF (PON_OEX_TIMEZONE_PKG.valid_zone(l_user_timezone) = 1) THEN

Line 629: l_server_timezone := PON_AUCTION_PKG.get_oex_time_zone;

625: --------------------------------
626: --get the user time zone based on the p_supplier_role_name
627:
628: l_user_timezone := PON_AUCTION_PKG.get_time_zone(l_user_name);
629: l_server_timezone := PON_AUCTION_PKG.get_oex_time_zone;
630:
631:
632: IF (PON_OEX_TIMEZONE_PKG.valid_zone(l_user_timezone) = 1) THEN
633: BEGIN

Line 651: l_user_timezone_desc := PON_AUCTION_PKG.get_timezone_description(l_user_timezone, l_language_code);

647: l_reminder_date_tz := p_reminder_date;
648: END;
649: END IF;
650:
651: l_user_timezone_desc := PON_AUCTION_PKG.get_timezone_description(l_user_timezone, l_language_code);
652:
653:
654: wf_engine.createProcess(itemtype => PON_SEND_NOTIF,
655: itemkey => p_item_key,