APPS.PO_CHANGEORDERWF_PVT dependencies on PO_ACTION_HISTORY

Line 296: l_action_code po_action_history.action_code%type;

292: p_path_id number) is
293:
294: pragma AUTONOMOUS_TRANSACTION;
295:
296: l_action_code po_action_history.action_code%type;
297: l_revision_num number := NULL;
298: l_hist_count number := NULL;
299: l_sequence_num number := NULL;
300: l_approval_path_id number;

Line 304: from po_action_history

300: l_approval_path_id number;
301:
302: CURSOR action_hist_cursor(doc_id number , doc_type varchar2) is
303: select max(sequence_num)
304: from po_action_history
305: where object_id= doc_id and
306: object_type_code = doc_type;
307:
308: CURSOR action_hist_code_cursor (doc_id number , doc_type varchar2, seq_num number) is

Line 310: from po_action_history

306: object_type_code = doc_type;
307:
308: CURSOR action_hist_code_cursor (doc_id number , doc_type varchar2, seq_num number) is
309: select action_code
310: from po_action_history
311: where object_id = doc_id and
312: object_type_code = doc_type and
313: sequence_num = seq_num;
314:

Line 373: INSERT into PO_ACTION_HISTORY

369: IF ((l_sequence_num = 0)
370: OR
371: (l_sequence_num > 0 and l_action_code is NOT NULL)) THEN
372: x_progress := '007';
373: INSERT into PO_ACTION_HISTORY
374: (object_id,
375: object_type_code,
376: object_sub_type_code,
377: sequence_num,

Line 420: UPDATE PO_ACTION_HISTORY

416:
417: ELSE
418: l_sequence_num := l_sequence_num - 1;
419: x_progress := '009';
420: UPDATE PO_ACTION_HISTORY
421: set object_id = p_doc_id,
422: object_type_code = p_doc_type,
423: object_sub_type_code = p_doc_subtype,
424: sequence_num = l_sequence_num,