APPS.PON_AUCTION_PKG dependencies on PON_ACTION_HISTORY

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

1253:
1254: -- choli update for emd
1255: PROCEDURE email_emd_admins(p_auction_header_id IN NUMBER) IS
1256:
1257: x_cancel_reason PON_ACTION_HISTORY.ACTION_NOTE%TYPE := '';
1258: x_cancel_date PON_AUCTION_HEADERS_ALL.CANCEL_DATE%TYPE;
1259: x_event_title PON_AUCTION_HEADERS_ALL.Event_Title%TYPE;
1260: x_start_date PON_AUCTION_HEADERS_ALL.PUBLISH_DATE%TYPE;
1261: x_emd_admin_name fnd_user.user_name%TYPE;

Line 1286: from pon_action_history

1282: END IF;
1283: BEGIN
1284: select action_note
1285: into x_cancel_reason
1286: from pon_action_history
1287: where object_id = p_auction_header_id
1288: and object_type_code = 'PON_AUCTION'
1289: and action_type = 'CANCEL' and rownum=1;
1290: EXCEPTION

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

3347: x_new_close_changed_date date;
3348: x_new_auction_preview_date DATE;
3349: x_timezone1_disp VARCHAR2(240);
3350:
3351: x_cancel_reason PON_ACTION_HISTORY.ACTION_NOTE%TYPE := '';
3352: x_cancel_date DATE;
3353: x_new_cancel_date DATE;
3354: x_new_disqualify_date DATE;
3355: x_disqualify_reason varchar2(2000) := '';

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

4980: x_itemtype VARCHAR2(7) := 'PONAUCT';
4981: x_itemkey VARCHAR2(30);
4982: x_notification_date DATE;
4983: x_now DATE;
4984: x_cancel_reason PON_ACTION_HISTORY.ACTION_NOTE%TYPE := '';
4985: x_cancel_date PON_AUCTION_HEADERS_ALL.CANCEL_DATE%TYPE;
4986: x_current_activity VARCHAR2(30);
4987:
4988:

Line 5024: from pon_action_history

5020: --
5021: BEGIN
5022: select action_note
5023: into x_cancel_reason
5024: from pon_action_history
5025: where object_id = p_auction_header_id
5026: and object_type_code = 'PON_AUCTION'
5027: and action_type = 'CANCEL';
5028: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 5694: x_cancel_reason PON_ACTION_HISTORY.ACTION_NOTE%TYPE;

5690: actid in number,
5691: uncmode in varchar2,
5692: resultout out NOCOPY varchar2) IS
5693:
5694: x_cancel_reason PON_ACTION_HISTORY.ACTION_NOTE%TYPE;
5695:
5696: BEGIN
5697:
5698: x_cancel_reason := wf_engine.GetItemAttrText (itemtype => itemtype,