APPS.PO_FORWARD_SV1 dependencies on PO_ACTION_HISTORY

Line 78: x_db_sequence_num PO_ACTION_HISTORY.sequence_num%TYPE := NULL;

74: x_login_id IN NUMBER,
75: x_approval_group_id IN NUMBER)
76: IS
77: x_progress VARCHAR2(3) := '';
78: x_db_sequence_num PO_ACTION_HISTORY.sequence_num%TYPE := NULL;
79:
80: BEGIN
81:
82: x_db_sequence_num := x_sequence_num;

Line 92: FROM PO_ACTION_HISTORY

88: x_progress := '010';
89:
90: SELECT MAX(sequence_num)
91: INTO x_db_sequence_num
92: FROM PO_ACTION_HISTORY
93: WHERE object_id = x_object_id
94: AND object_type_code = x_object_type_code;
95:
96: x_progress := '020';

Line 118: INSERT INTO PO_ACTION_HISTORY

114: x_progress := '100';
115:
116: --dbms_output.put_line('Before insert');
117:
118: INSERT INTO PO_ACTION_HISTORY
119: (object_id,
120: object_type_code,
121: object_sub_type_code,
122: sequence_num,

Line 266: INSERT INTO PO_ACTION_HISTORY

262:
263: x_progress := '020';
264: --dbms_output.put_line('Before Insert');
265:
266: INSERT INTO PO_ACTION_HISTORY
267: (object_id,
268: object_type_code,
269: object_sub_type_code,
270: sequence_num,

Line 309: FROM PO_ACTION_HISTORY

305: sysdate,
306: approval_path_id,
307: x_offline_code,
308: sysdate
309: FROM PO_ACTION_HISTORY
310: WHERE employee_id = x_old_employee_id
311: AND action_code IS NULL;
312:
313: --dbms_output.put_line('After Insert');

Line 396: UPDATE PO_ACTION_HISTORY

392: WHERE FND.USER_ID = NVL(x_user_id, fnd_global.user_id)
393: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID;
394: end if;
395:
396: UPDATE PO_ACTION_HISTORY
397: SET last_update_date = sysdate,
398: last_updated_by = x_user_id,
399: last_update_login = x_login_id,
400: employee_id = NVL(x_employee_id, employee_id),

Line 467: UPDATE PO_ACTION_HISTORY

463:
464: x_progress := '020';
465: --dbms_output.put_line('Before Update');
466:
467: UPDATE PO_ACTION_HISTORY
468: SET last_update_date = sysdate,
469: last_updated_by = x_user_id,
470: last_update_login = x_login_id,
471: action_date = sysdate,

Line 501: FROM po_action_history

497: PROCEDURE lock_row (x_rowid VARCHAR2,
498: x_last_update_date DATE) IS
499: CURSOR C IS
500: SELECT *
501: FROM po_action_history
502: WHERE rowid = x_rowid
503: FOR UPDATE of sequence_num NOWAIT;
504: Recinfo C%ROWTYPE;
505: