eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_WF_PO_NOTIFICATION dependencies on PO_ACTION_HISTORY

Line 13: p_doc_type IN po_action_history.OBJECT_TYPE_CODE%TYPE,

9: p_recipient_id IN NUMBER,
10: p_note IN VARCHAR2,
11: p_po_header_id IN NUMBER,
12: p_current_id IN NUMBER,
13: p_doc_type IN po_action_history.OBJECT_TYPE_CODE%TYPE,
14: p_doc_subtype IN po_action_history.OBJECT_SUB_TYPE_CODE%TYPE,
15: p_approval_path_id IN po_action_history.APPROVAL_PATH_ID%TYPE, --
16: p_draft_id IN NUMBER,
17: p_draft_type IN VARCHAR2); -- PAR Approval

Line 14: p_doc_subtype IN po_action_history.OBJECT_SUB_TYPE_CODE%TYPE,

10: p_note IN VARCHAR2,
11: p_po_header_id IN NUMBER,
12: p_current_id IN NUMBER,
13: p_doc_type IN po_action_history.OBJECT_TYPE_CODE%TYPE,
14: p_doc_subtype IN po_action_history.OBJECT_SUB_TYPE_CODE%TYPE,
15: p_approval_path_id IN po_action_history.APPROVAL_PATH_ID%TYPE, --
16: p_draft_id IN NUMBER,
17: p_draft_type IN VARCHAR2); -- PAR Approval
18:

Line 15: p_approval_path_id IN po_action_history.APPROVAL_PATH_ID%TYPE, --

11: p_po_header_id IN NUMBER,
12: p_current_id IN NUMBER,
13: p_doc_type IN po_action_history.OBJECT_TYPE_CODE%TYPE,
14: p_doc_subtype IN po_action_history.OBJECT_SUB_TYPE_CODE%TYPE,
15: p_approval_path_id IN po_action_history.APPROVAL_PATH_ID%TYPE, --
16: p_draft_id IN NUMBER,
17: p_draft_type IN VARCHAR2); -- PAR Approval
18:
19: PROCEDURE get_po_approve_msg ( document_id in varchar2,

Line 41: l_note po_action_history.note%TYPE;

37: l_forwarded_from per_all_people_f.full_name%TYPE;
38: l_preparer per_all_people_f.full_name%TYPE;
39: --
40: -- l_note VARCHAR2(480); /* < UTF8 FPI - changed from VARCHAR2(240) > */
41: l_note po_action_history.note%TYPE;
42: --
43: l_document VARCHAR2(32000) := '';
44: l_tax_amt NUMBER;
45:

Line 1243: TYPE sequence_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.sequence_num%TYPE;

1239:
1240: -- Declare TABLEs for each column that is selected
1241: -- from history_csr cursor.
1242: --
1243: TYPE sequence_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.sequence_num%TYPE;
1244: TYPE full_name_tbl_type IS TABLE OF PER_ALL_PEOPLE_F.full_name%TYPE;
1245: TYPE displayed_field_tbl_type IS TABLE OF PO_LOOKUP_CODES.displayed_field%TYPE;
1246: TYPE action_date_tbl_type IS TABLE OF PO_ACTION_HISTORY.action_date%TYPE;
1247: TYPE note_tbl_type IS TABLE OF PO_ACTION_HISTORY.note%TYPE;

Line 1246: TYPE action_date_tbl_type IS TABLE OF PO_ACTION_HISTORY.action_date%TYPE;

1242: --
1243: TYPE sequence_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.sequence_num%TYPE;
1244: TYPE full_name_tbl_type IS TABLE OF PER_ALL_PEOPLE_F.full_name%TYPE;
1245: TYPE displayed_field_tbl_type IS TABLE OF PO_LOOKUP_CODES.displayed_field%TYPE;
1246: TYPE action_date_tbl_type IS TABLE OF PO_ACTION_HISTORY.action_date%TYPE;
1247: TYPE note_tbl_type IS TABLE OF PO_ACTION_HISTORY.note%TYPE;
1248: TYPE object_revision_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.object_revision_num%TYPE;
1249: TYPE employee_id_tbl_type IS TABLE OF PO_ACTION_HISTORY.employee_id%TYPE;
1250: TYPE created_by_tbl_type IS TABLE OF PO_ACTION_HISTORY.created_by%TYPE;

Line 1247: TYPE note_tbl_type IS TABLE OF PO_ACTION_HISTORY.note%TYPE;

1243: TYPE sequence_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.sequence_num%TYPE;
1244: TYPE full_name_tbl_type IS TABLE OF PER_ALL_PEOPLE_F.full_name%TYPE;
1245: TYPE displayed_field_tbl_type IS TABLE OF PO_LOOKUP_CODES.displayed_field%TYPE;
1246: TYPE action_date_tbl_type IS TABLE OF PO_ACTION_HISTORY.action_date%TYPE;
1247: TYPE note_tbl_type IS TABLE OF PO_ACTION_HISTORY.note%TYPE;
1248: TYPE object_revision_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.object_revision_num%TYPE;
1249: TYPE employee_id_tbl_type IS TABLE OF PO_ACTION_HISTORY.employee_id%TYPE;
1250: TYPE created_by_tbl_type IS TABLE OF PO_ACTION_HISTORY.created_by%TYPE;
1251:

Line 1248: TYPE object_revision_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.object_revision_num%TYPE;

1244: TYPE full_name_tbl_type IS TABLE OF PER_ALL_PEOPLE_F.full_name%TYPE;
1245: TYPE displayed_field_tbl_type IS TABLE OF PO_LOOKUP_CODES.displayed_field%TYPE;
1246: TYPE action_date_tbl_type IS TABLE OF PO_ACTION_HISTORY.action_date%TYPE;
1247: TYPE note_tbl_type IS TABLE OF PO_ACTION_HISTORY.note%TYPE;
1248: TYPE object_revision_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.object_revision_num%TYPE;
1249: TYPE employee_id_tbl_type IS TABLE OF PO_ACTION_HISTORY.employee_id%TYPE;
1250: TYPE created_by_tbl_type IS TABLE OF PO_ACTION_HISTORY.created_by%TYPE;
1251:
1252: l_sequence_num_tbl sequence_num_tbl_type;

Line 1249: TYPE employee_id_tbl_type IS TABLE OF PO_ACTION_HISTORY.employee_id%TYPE;

1245: TYPE displayed_field_tbl_type IS TABLE OF PO_LOOKUP_CODES.displayed_field%TYPE;
1246: TYPE action_date_tbl_type IS TABLE OF PO_ACTION_HISTORY.action_date%TYPE;
1247: TYPE note_tbl_type IS TABLE OF PO_ACTION_HISTORY.note%TYPE;
1248: TYPE object_revision_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.object_revision_num%TYPE;
1249: TYPE employee_id_tbl_type IS TABLE OF PO_ACTION_HISTORY.employee_id%TYPE;
1250: TYPE created_by_tbl_type IS TABLE OF PO_ACTION_HISTORY.created_by%TYPE;
1251:
1252: l_sequence_num_tbl sequence_num_tbl_type;
1253: l_employee_name_tbl full_name_tbl_type;

Line 1250: TYPE created_by_tbl_type IS TABLE OF PO_ACTION_HISTORY.created_by%TYPE;

1246: TYPE action_date_tbl_type IS TABLE OF PO_ACTION_HISTORY.action_date%TYPE;
1247: TYPE note_tbl_type IS TABLE OF PO_ACTION_HISTORY.note%TYPE;
1248: TYPE object_revision_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.object_revision_num%TYPE;
1249: TYPE employee_id_tbl_type IS TABLE OF PO_ACTION_HISTORY.employee_id%TYPE;
1250: TYPE created_by_tbl_type IS TABLE OF PO_ACTION_HISTORY.created_by%TYPE;
1251:
1252: l_sequence_num_tbl sequence_num_tbl_type;
1253: l_employee_name_tbl full_name_tbl_type;
1254: l_action_tbl displayed_field_tbl_type;

Line 1275: from po_action_history poh,

1271: poh.NOTE,
1272: poh.OBJECT_REVISION_NUM,
1273: poh.employee_id, /* bug 2788683 */
1274: poh.created_by /* bug 2788683 */
1275: from po_action_history poh,
1276: per_all_people_f per, -- Bug 3404451
1277: po_lookup_codes polc
1278: where OBJECT_TYPE_CODE = v_doc_type_code
1279: and poh.object_sub_type_code = v_doc_sub_type_code

Line 1295: from po_action_history poh,

1291: poh.NOTE,
1292: poh.OBJECT_REVISION_NUM,
1293: poh.employee_id, /* bug 2788683 */
1294: poh.created_by /* bug 2788683 */
1295: from po_action_history poh,
1296: per_all_people_f per -- Bug 3404451
1297: where OBJECT_TYPE_CODE = v_doc_type_code
1298: and poh.object_sub_type_code = v_doc_sub_type_code
1299: and poh.action_code is null

Line 1321: l_doc_sub_type_code po_action_history.object_sub_type_code%TYPE; -- CLM Apprvl

1317: l_party_name hz_parties.party_name%TYPE;
1318: /* Bug 2788683 end */
1319: l_supplier po_vendors.vendor_name%TYPE; --
1320: l_draft_id NUMBER;
1321: l_doc_sub_type_code po_action_history.object_sub_type_code%TYPE; -- CLM Apprvl
1322: l_draft_type PO_DRAFTS.DRAFT_TYPE%TYPE; -- PAR Approval
1323:
1324: BEGIN
1325:

Line 1349: -- CLM Apprvl, object sub type code for mods need to recorded as 'MODIFICATION' in po action history

1345: l_doc_type_code := wf_engine.GetItemAttrText (itemtype => l_item_type,
1346: itemkey => l_item_key,
1347: aname => 'DOCUMENT_TYPE');
1348:
1349: -- CLM Apprvl, object sub type code for mods need to recorded as 'MODIFICATION' in po action history
1350: if l_draft_id is not null and l_draft_id <> -1 then
1351: -- pAR Approval
1352: l_draft_type := wf_engine.GetItemAttrText (itemtype => l_item_type,
1353: itemkey => l_item_key,

Line 1404: --CLM Apprvl. for modification documents draft_id is recorded as the object_id of po_action_history.

1400: end if;
1401:
1402: -- Fetch all Action History data into Tables.
1403: --
1404: --CLM Apprvl. for modification documents draft_id is recorded as the object_id of po_action_history.
1405: if l_draft_id is not null and l_draft_id <> -1 then
1406: OPEN history_csr(l_draft_id,l_doc_type_code,l_doc_sub_type_code);
1407: else
1408: OPEN history_csr(l_document_id,l_doc_type_code,l_doc_sub_type_code);

Line 1691: --Added the below variables as part of bug 13951919 fix. Used to log the Delegate action in the PO_ACTION_HISTORY table.

1687: l_nid NUMBER;
1688: l_preserved_ctx VARCHAR2(5);
1689: -- Context setting revamp
1690:
1691: --Added the below variables as part of bug 13951919 fix. Used to log the Delegate action in the PO_ACTION_HISTORY table.
1692: l_po_header_id po_headers_all.po_header_id%TYPE;
1693: l_doc_type po_action_history.OBJECT_TYPE_CODE%TYPE;
1694: l_doc_sub_type po_action_history.OBJECT_SUB_TYPE_CODE%TYPE;
1695: l_action po_action_history.action_code%TYPE;

Line 1693: l_doc_type po_action_history.OBJECT_TYPE_CODE%TYPE;

1689: -- Context setting revamp
1690:
1691: --Added the below variables as part of bug 13951919 fix. Used to log the Delegate action in the PO_ACTION_HISTORY table.
1692: l_po_header_id po_headers_all.po_header_id%TYPE;
1693: l_doc_type po_action_history.OBJECT_TYPE_CODE%TYPE;
1694: l_doc_sub_type po_action_history.OBJECT_SUB_TYPE_CODE%TYPE;
1695: l_action po_action_history.action_code%TYPE;
1696: l_new_recipient_id wf_roles.orig_system_id%TYPE;
1697: l_current_recipient_id wf_roles.orig_system_id%TYPE;

Line 1694: l_doc_sub_type po_action_history.OBJECT_SUB_TYPE_CODE%TYPE;

1690:
1691: --Added the below variables as part of bug 13951919 fix. Used to log the Delegate action in the PO_ACTION_HISTORY table.
1692: l_po_header_id po_headers_all.po_header_id%TYPE;
1693: l_doc_type po_action_history.OBJECT_TYPE_CODE%TYPE;
1694: l_doc_sub_type po_action_history.OBJECT_SUB_TYPE_CODE%TYPE;
1695: l_action po_action_history.action_code%TYPE;
1696: l_new_recipient_id wf_roles.orig_system_id%TYPE;
1697: l_current_recipient_id wf_roles.orig_system_id%TYPE;
1698: l_origsys wf_roles.orig_system%TYPE;

Line 1695: l_action po_action_history.action_code%TYPE;

1691: --Added the below variables as part of bug 13951919 fix. Used to log the Delegate action in the PO_ACTION_HISTORY table.
1692: l_po_header_id po_headers_all.po_header_id%TYPE;
1693: l_doc_type po_action_history.OBJECT_TYPE_CODE%TYPE;
1694: l_doc_sub_type po_action_history.OBJECT_SUB_TYPE_CODE%TYPE;
1695: l_action po_action_history.action_code%TYPE;
1696: l_new_recipient_id wf_roles.orig_system_id%TYPE;
1697: l_current_recipient_id wf_roles.orig_system_id%TYPE;
1698: l_origsys wf_roles.orig_system%TYPE;
1699: l_original_recipient wf_notifications.original_recipient%TYPE;

Line 1711: l_note po_action_history.note%TYPE;

1707: l_error_msg varchar2(500);
1708: l_preparer_id number;
1709: x_CanOwnerApproveFlag varchar2(1);
1710: l_orgid number;
1711: l_note po_action_history.note%TYPE;
1712: l_respond_action_text varchar2(100);
1713: l_is_forward_valid boolean;
1714: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
1715:

Line 1714: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;

1710: l_orgid number;
1711: l_note po_action_history.note%TYPE;
1712: l_respond_action_text varchar2(100);
1713: l_is_forward_valid boolean;
1714: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
1715:
1716: l_draft_id number;
1717: --15859236 start
1718: l_new_recipient_name wf_users.name%type;

Line 2917: -- This procedure updates the po_action_history table based on the approvers response.

2913: -- None
2914: --Locks:
2915: -- None.
2916: --Function:
2917: -- This procedure updates the po_action_history table based on the approvers response.
2918: --Parameters:
2919: --IN:
2920: --p_action_code
2921: --p_recipient_id

Line 2941: p_doc_type IN po_action_history.OBJECT_TYPE_CODE%TYPE,

2937: p_recipient_id IN NUMBER,
2938: p_note IN VARCHAR2,
2939: p_po_header_id IN NUMBER,
2940: p_current_id IN NUMBER,
2941: p_doc_type IN po_action_history.OBJECT_TYPE_CODE%TYPE,
2942: p_doc_subtype IN po_action_history.OBJECT_SUB_TYPE_CODE%TYPE,
2943: p_approval_path_id IN PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE, --
2944: p_draft_id IN NUMBER,
2945: p_draft_type IN VARCHAR2) --PAR Approval

Line 2942: p_doc_subtype IN po_action_history.OBJECT_SUB_TYPE_CODE%TYPE,

2938: p_note IN VARCHAR2,
2939: p_po_header_id IN NUMBER,
2940: p_current_id IN NUMBER,
2941: p_doc_type IN po_action_history.OBJECT_TYPE_CODE%TYPE,
2942: p_doc_subtype IN po_action_history.OBJECT_SUB_TYPE_CODE%TYPE,
2943: p_approval_path_id IN PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE, --
2944: p_draft_id IN NUMBER,
2945: p_draft_type IN VARCHAR2) --PAR Approval
2946: IS

Line 2943: p_approval_path_id IN PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE, --

2939: p_po_header_id IN NUMBER,
2940: p_current_id IN NUMBER,
2941: p_doc_type IN po_action_history.OBJECT_TYPE_CODE%TYPE,
2942: p_doc_subtype IN po_action_history.OBJECT_SUB_TYPE_CODE%TYPE,
2943: p_approval_path_id IN PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE, --
2944: p_draft_id IN NUMBER,
2945: p_draft_type IN VARCHAR2) --PAR Approval
2946: IS
2947: pragma AUTONOMOUS_TRANSACTION;

Line 2951: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;

2947: pragma AUTONOMOUS_TRANSACTION;
2948:
2949: l_progress VARCHAR2(100) := '000';
2950:
2951: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2952: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2953: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2954: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2955: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;

Line 2952: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;

2948:
2949: l_progress VARCHAR2(100) := '000';
2950:
2951: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2952: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2953: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2954: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2955: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2956: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;

Line 2953: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;

2949: l_progress VARCHAR2(100) := '000';
2950:
2951: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2952: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2953: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2954: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2955: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2956: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2957: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;

Line 2954: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;

2950:
2951: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2952: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2953: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2954: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2955: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2956: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2957: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
2958:

Line 2955: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;

2951: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2952: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2953: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2954: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2955: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2956: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2957: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
2958:
2959: l_document_id NUMBER;

Line 2956: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;

2952: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2953: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2954: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2955: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2956: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2957: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
2958:
2959: l_document_id NUMBER;
2960: l_doc_sub_type po_action_history.OBJECT_SUB_TYPE_CODE%TYPE;

Line 2957: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;

2953: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2954: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2955: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2956: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2957: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
2958:
2959: l_document_id NUMBER;
2960: l_doc_sub_type po_action_history.OBJECT_SUB_TYPE_CODE%TYPE;
2961:

Line 2960: l_doc_sub_type po_action_history.OBJECT_SUB_TYPE_CODE%TYPE;

2956: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2957: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
2958:
2959: l_document_id NUMBER;
2960: l_doc_sub_type po_action_history.OBJECT_SUB_TYPE_CODE%TYPE;
2961:
2962: BEGIN
2963:
2964: -- Handling mod approval case.

Line 2981: FROM PO_ACTION_HISTORY

2977:
2978: --Start of code changes:
2979: SELECT max(sequence_num)
2980: INTO l_sequence_num
2981: FROM PO_ACTION_HISTORY
2982: WHERE object_id = l_document_id
2983: AND object_type_code = p_doc_type
2984: AND object_sub_type_code = l_doc_sub_type;
2985:

Line 2999: FROM PO_ACTION_HISTORY

2995: l_request_id,
2996: l_program_application_id,
2997: l_program_date,
2998: l_program_id
2999: FROM PO_ACTION_HISTORY
3000: WHERE object_id = l_document_id
3001: AND object_type_code = p_doc_type
3002: AND object_sub_type_code = l_doc_sub_type
3003: AND employee_id = p_current_id

Line 3011: UPDATE PO_ACTION_HISTORY

3007:
3008: l_progress := '010';
3009:
3010: -- Update action history with the action details
3011: UPDATE PO_ACTION_HISTORY
3012: SET last_update_date = sysdate,
3013: last_updated_by = fnd_global.user_id,
3014: last_update_login = fnd_global.login_id ,
3015: action_date = sysdate,

Line 3029: INSERT INTO PO_ACTION_HISTORY

3025:
3026: l_progress := '020';
3027:
3028: IF p_recipient_id IS NOT NULL THEN --
3029: INSERT INTO PO_ACTION_HISTORY
3030: (object_id,
3031: object_type_code,
3032: object_sub_type_code,
3033: sequence_num,