9: --
10: UPDATE po_requisition_headers porh
11: SET porh.authorization_status = p_new_status,
12: porh.last_update_date = sysdate,
13: porh.last_updated_by = fnd_global.user_id,
14: porh.last_update_login = fnd_global.login_id
15: WHERE porh.requisition_header_id = p_requisition_header_id;
16: --
17: end;
10: UPDATE po_requisition_headers porh
11: SET porh.authorization_status = p_new_status,
12: porh.last_update_date = sysdate,
13: porh.last_updated_by = fnd_global.user_id,
14: porh.last_update_login = fnd_global.login_id
15: WHERE porh.requisition_header_id = p_requisition_header_id;
16: --
17: end;
18: --
59: 'REQUISITION',
60: 'PURCHASE',
61: nvl(l_sequence_number,0),
62: sysdate,
63: fnd_global.user_id,
64: sysdate,
65: fnd_global.user_id,
66: p_action,
67: decode(p_action, '',to_date(''), sysdate),
61: nvl(l_sequence_number,0),
62: sysdate,
63: fnd_global.user_id,
64: sysdate,
65: fnd_global.user_id,
66: p_action,
67: decode(p_action, '',to_date(''), sysdate),
68: p_fwd_to_id,
69: p_note,
67: decode(p_action, '',to_date(''), sysdate),
68: p_fwd_to_id,
69: p_note,
70: l_revision_num,
71: fnd_global.login_id,
72: 0,
73: 0,
74: 0,
75: '',
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,
93: last_update_date = sysdate,
94: object_revision_num = null,
95: approval_path_id = null
96: WHERE object_id = p_requisition_header_id