APPS.PO_APPROVAL_LIST_HISTORY_SV dependencies on PO_ACTION_HISTORY

Line 40: FROM PO_ACTION_HISTORY

36: program_date,
37: program_id,
38: last_update_date,
39: employee_id
40: FROM PO_ACTION_HISTORY
41: WHERE object_type_code = 'REQUISITION'
42: AND object_id = x_req_header_id
43: AND sequence_num = x_sequence_num;
44:

Line 52: FROM PO_ACTION_HISTORY

48: BEGIN
49:
50: SELECT count(*)
51: INTO x_count
52: FROM PO_ACTION_HISTORY
53: WHERE object_type_code = 'REQUISITION'
54: AND object_id = x_req_header_id
55: AND action_code IS NULL;
56:

Line 73: FROM PO_ACTION_HISTORY

69: ELSE
70:
71: SELECT max(sequence_num)
72: INTO x_sequence_num
73: FROM PO_ACTION_HISTORY
74: WHERE object_type_code = 'REQUISITION'
75: AND object_id = x_req_header_id;
76:
77: OPEN C;

Line 229: ** PO_ACTION_HISTORY

225: /*
226: ** if we cannot find the responder within our system, either the ntf has not
227: ** been responded yet or the response came from outside.
228: ** Therefore we cannot record the responder in
229: ** PO_ACTION_HISTORY
230: */
231:
232: /* internal name of responder */
233:

Line 318: ** po_action_history for the Requisition if it does not exists.

314: END Update_Action_History;
315:
316: /* Bug# 2684757: kagarwal
317: ** Desc: Added new procedure to insert null action in
318: ** po_action_history for the Requisition if it does not exists.
319: */
320:
321: procedure Reserve_Action_History(x_approval_path_id in number,
322: x_req_header_id in number,

Line 344: FROM PO_ACTION_HISTORY

340: program_date,
341: program_id,
342: last_update_date,
343: employee_id
344: FROM PO_ACTION_HISTORY
345: WHERE object_type_code = 'REQUISITION'
346: AND object_id = x_req_header_id
347: AND sequence_num = x_sequence_num;
348:

Line 357: FROM PO_ACTION_HISTORY

353: l_progress := '010';
354:
355: SELECT max(sequence_num)
356: INTO x_sequence_num
357: FROM PO_ACTION_HISTORY
358: WHERE object_type_code = 'REQUISITION'
359: AND object_id = x_req_header_id;
360:
361: OPEN C;

Line 444: PO_ACTION_HISTORY PH

440: PH.OBJECT_ID object_id
441: FROM
442: PO_DOCUMENT_TYPES PODT,
443: PO_REQUISITION_HEADERS PRH,
444: PO_ACTION_HISTORY PH
445: WHERE PRH.REQUISITION_HEADER_ID = PH.OBJECT_ID AND
446: PODT.DOCUMENT_TYPE_CODE = 'REQUISITION' AND
447: PODT.DOCUMENT_SUBTYPE (+) = PRH.TYPE_LOOKUP_CODE AND
448: PODT.DOCUMENT_TYPE_CODE = PH.OBJECT_TYPE_CODE AND

Line 459: FROM PO_ACTION_HISTORY

455: BEGIN
456:
457: SELECT max(sequence_num)
458: INTO x_sequence_num
459: FROM PO_ACTION_HISTORY
460: WHERE object_type_code = 'REQUISITION'
461: AND object_id = p_req_header_id;
462:
463: -- dbms_output.put_line ('x_sequence_num' || to_char(x_sequence_num));

Line 543: ** insert a new NULL row into PO_ACTION_HISTORY for

539: fnd_global.login_id
540: );
541:
542: /*
543: ** insert a new NULL row into PO_ACTION_HISTORY for
544: ** the new approver
545: */
546:
547: l_progress := '050';

Line 585: UPDATE PO_ACTION_HISTORY

581:
582: /*
583: ** update pending row of action history with approval action
584: */
585: UPDATE PO_ACTION_HISTORY
586: SET last_update_date = sysdate,
587: last_updated_by = fnd_global.user_id, --x_user_id,
588: last_update_login = fnd_global.login_id, --x_login_id,
589: action_date = sysdate,