DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on PON_ACTION_HISTORY

Line 2841: x_cancel_reason PON_ACTION_HISTORY.ACTION_NOTE%TYPE := '';

2837: x_new_close_changed_date date;
2838: x_new_auction_preview_date DATE;
2839: x_timezone1_disp VARCHAR2(240);
2840:
2841: x_cancel_reason PON_ACTION_HISTORY.ACTION_NOTE%TYPE := '';
2842: x_cancel_date DATE;
2843: x_new_cancel_date DATE;
2844: x_new_disqualify_date DATE;
2845: x_disqualify_reason varchar2(2000) := '';

Line 4389: x_cancel_reason PON_ACTION_HISTORY.ACTION_NOTE%TYPE := '';

4385: x_itemtype VARCHAR2(7) := 'PONAUCT';
4386: x_itemkey VARCHAR2(30);
4387: x_notification_date DATE;
4388: x_now DATE;
4389: x_cancel_reason PON_ACTION_HISTORY.ACTION_NOTE%TYPE := '';
4390: x_cancel_date PON_AUCTION_HEADERS_ALL.CANCEL_DATE%TYPE;
4391: x_current_activity VARCHAR2(30);
4392:
4393:

Line 4429: from pon_action_history

4425: --
4426: BEGIN
4427: select action_note
4428: into x_cancel_reason
4429: from pon_action_history
4430: where object_id = p_auction_header_id
4431: and object_type_code = 'PON_AUCTION'
4432: and action_type = 'CANCEL';
4433: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 5098: x_cancel_reason PON_ACTION_HISTORY.ACTION_NOTE%TYPE;

5094: actid in number,
5095: uncmode in varchar2,
5096: resultout out NOCOPY varchar2) IS
5097:
5098: x_cancel_reason PON_ACTION_HISTORY.ACTION_NOTE%TYPE;
5099:
5100: BEGIN
5101:
5102: x_cancel_reason := wf_engine.GetItemAttrText (itemtype => itemtype,