APPS.PO_CHANGEORDERWF_PVT dependencies on PO_ACTION_HISTORY

Line 318: l_action_code po_action_history.action_code%type;

314: p_path_id number) is
315:
316: pragma AUTONOMOUS_TRANSACTION;
317:
318: l_action_code po_action_history.action_code%type;
319: l_revision_num number := NULL;
320: l_hist_count number := NULL;
321: l_sequence_num number := NULL;
322: l_approval_path_id number;

Line 326: from po_action_history

322: l_approval_path_id number;
323:
324: CURSOR action_hist_cursor(doc_id number , doc_type varchar2) is
325: select max(sequence_num)
326: from po_action_history
327: where object_id= doc_id and
328: object_type_code = doc_type;
329:
330: CURSOR action_hist_code_cursor (doc_id number , doc_type varchar2, seq_num number) is

Line 332: from po_action_history

328: object_type_code = doc_type;
329:
330: CURSOR action_hist_code_cursor (doc_id number , doc_type varchar2, seq_num number) is
331: select action_code
332: from po_action_history
333: where object_id = doc_id and
334: object_type_code = doc_type and
335: sequence_num = seq_num;
336:

Line 395: INSERT into PO_ACTION_HISTORY

391: IF ((l_sequence_num = 0)
392: OR
393: (l_sequence_num > 0 and l_action_code is NOT NULL)) THEN
394: x_progress := '007';
395: INSERT into PO_ACTION_HISTORY
396: (object_id,
397: object_type_code,
398: object_sub_type_code,
399: sequence_num,

Line 442: UPDATE PO_ACTION_HISTORY

438:
439: ELSE
440: l_sequence_num := l_sequence_num - 1;
441: x_progress := '009';
442: UPDATE PO_ACTION_HISTORY
443: set object_id = p_doc_id,
444: object_type_code = p_doc_type,
445: object_sub_type_code = p_doc_subtype,
446: sequence_num = l_sequence_num,

Line 8704: l_action po_action_history.action_code%TYPE;

8700: l_notification_id number;
8701: l_forwardTo varchar2(240);
8702: l_result varchar2(100);
8703: l_forward_to_username_response varchar2(240) :='';
8704: l_action po_action_history.action_code%TYPE;
8705: l_new_recipient_id wf_roles.orig_system_id%TYPE;
8706: l_current_recipient_id wf_roles.orig_system_id%TYPE;
8707: l_origsys wf_roles.orig_system%TYPE;
8708: