DBA Data[Home] [Help]

APPS.PODUS dependencies on PO_ACTION_HISTORY

Line 31: from po_action_history

27: l_offline_code varchar2(10);
28: begin
29: select max(sequence_num) + 1
30: into l_sequence_number
31: from po_action_history
32: where object_type_code= 'REQUISITION'
33: and object_id = p_requisition_header_id;
34: --
35: --

Line 36: INSERT into PO_ACTION_HISTORY

32: where object_type_code= 'REQUISITION'
33: and object_id = p_requisition_header_id;
34: --
35: --
36: INSERT into PO_ACTION_HISTORY
37: (object_id,
38: object_type_code,
39: object_sub_type_code,
40: sequence_num,

Line 88: UPDATE po_action_history

84: p_note in varchar2 ) is
85: --
86: begin
87: --
88: UPDATE po_action_history
89: SET action_code = p_action,
90: action_date = sysdate,
91: note = p_note,
92: last_updated_by = fnd_global.user_id,