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_REQ_NOTIFICATION dependencies on PO_ACTION_HISTORY

Line 68: seq_num po_action_history_v.sequence_num%TYPE,

64: curr_unit_price po_requisition_lines.currency_unit_price%TYPE);
65:
66: TYPE history_record IS RECORD (
67:
68: seq_num po_action_history_v.sequence_num%TYPE,
69: employee_name po_action_history_v.employee_name%TYPE,
70: action po_action_history_v.action_code_dsp%TYPE,
71: action_date po_action_history_v.action_date%TYPE,
72: note po_action_history_v.note%TYPE,

Line 69: employee_name po_action_history_v.employee_name%TYPE,

65:
66: TYPE history_record IS RECORD (
67:
68: seq_num po_action_history_v.sequence_num%TYPE,
69: employee_name po_action_history_v.employee_name%TYPE,
70: action po_action_history_v.action_code_dsp%TYPE,
71: action_date po_action_history_v.action_date%TYPE,
72: note po_action_history_v.note%TYPE,
73: revision po_action_history_v.object_revision_num%TYPE,

Line 70: action po_action_history_v.action_code_dsp%TYPE,

66: TYPE history_record IS RECORD (
67:
68: seq_num po_action_history_v.sequence_num%TYPE,
69: employee_name po_action_history_v.employee_name%TYPE,
70: action po_action_history_v.action_code_dsp%TYPE,
71: action_date po_action_history_v.action_date%TYPE,
72: note po_action_history_v.note%TYPE,
73: revision po_action_history_v.object_revision_num%TYPE,
74: /* Bug 2788683 start */

Line 71: action_date po_action_history_v.action_date%TYPE,

67:
68: seq_num po_action_history_v.sequence_num%TYPE,
69: employee_name po_action_history_v.employee_name%TYPE,
70: action po_action_history_v.action_code_dsp%TYPE,
71: action_date po_action_history_v.action_date%TYPE,
72: note po_action_history_v.note%TYPE,
73: revision po_action_history_v.object_revision_num%TYPE,
74: /* Bug 2788683 start */
75: employee_id po_action_history_v.employee_id%TYPE,

Line 72: note po_action_history_v.note%TYPE,

68: seq_num po_action_history_v.sequence_num%TYPE,
69: employee_name po_action_history_v.employee_name%TYPE,
70: action po_action_history_v.action_code_dsp%TYPE,
71: action_date po_action_history_v.action_date%TYPE,
72: note po_action_history_v.note%TYPE,
73: revision po_action_history_v.object_revision_num%TYPE,
74: /* Bug 2788683 start */
75: employee_id po_action_history_v.employee_id%TYPE,
76: created_by po_action_history_v.created_by%TYPE,

Line 73: revision po_action_history_v.object_revision_num%TYPE,

69: employee_name po_action_history_v.employee_name%TYPE,
70: action po_action_history_v.action_code_dsp%TYPE,
71: action_date po_action_history_v.action_date%TYPE,
72: note po_action_history_v.note%TYPE,
73: revision po_action_history_v.object_revision_num%TYPE,
74: /* Bug 2788683 start */
75: employee_id po_action_history_v.employee_id%TYPE,
76: created_by po_action_history_v.created_by%TYPE,
77: /* Bug 2788683 end */

Line 75: employee_id po_action_history_v.employee_id%TYPE,

71: action_date po_action_history_v.action_date%TYPE,
72: note po_action_history_v.note%TYPE,
73: revision po_action_history_v.object_revision_num%TYPE,
74: /* Bug 2788683 start */
75: employee_id po_action_history_v.employee_id%TYPE,
76: created_by po_action_history_v.created_by%TYPE,
77: /* Bug 2788683 end */
78: /* Bug 3090563 */
79: action_code po_action_history_v.action_code%TYPE

Line 76: created_by po_action_history_v.created_by%TYPE,

72: note po_action_history_v.note%TYPE,
73: revision po_action_history_v.object_revision_num%TYPE,
74: /* Bug 2788683 start */
75: employee_id po_action_history_v.employee_id%TYPE,
76: created_by po_action_history_v.created_by%TYPE,
77: /* Bug 2788683 end */
78: /* Bug 3090563 */
79: action_code po_action_history_v.action_code%TYPE
80: );

Line 79: action_code po_action_history_v.action_code%TYPE

75: employee_id po_action_history_v.employee_id%TYPE,
76: created_by po_action_history_v.created_by%TYPE,
77: /* Bug 2788683 end */
78: /* Bug 3090563 */
79: action_code po_action_history_v.action_code%TYPE
80: );
81:
82: L_TABLE_STYLE VARCHAR2(100) := ' cellspacing="1" cellpadding="3" border="0" width="100%" ';
83:

Line 219: l_note po_action_history.note%TYPE;

215: l_forwarded_from per_people_f.full_name%TYPE;
216: l_preparer per_people_f.full_name%TYPE;
217: --
218: -- l_note VARCHAR2(480);
219: l_note po_action_history.note%TYPE;
220: --
221: l_document VARCHAR2(32000) := '';
222: l_tax_amt NUMBER;
223:

Line 464: l_note po_action_history.note%TYPE;

460: l_approver per_people_f.full_name%TYPE;
461: l_preparer per_people_f.full_name%TYPE;
462: --
463: -- l_note VARCHAR2(480);
464: l_note po_action_history.note%TYPE;
465: --
466: l_document VARCHAR2(32000) := '';
467: l_tax_amt NUMBER;
468:

Line 734: l_note po_action_history.note%TYPE;

730: l_approver per_people_f.full_name%TYPE;
731: l_preparer per_people_f.full_name%TYPE;
732: --
733: -- l_note VARCHAR2(480);
734: l_note po_action_history.note%TYPE;
735: --
736: l_document VARCHAR2(32000) := '';
737: l_tax_amt NUMBER;
738:

Line 959: l_note po_action_history.note%TYPE;

955: l_rejected_by per_people_f.full_name%TYPE;
956: l_preparer per_people_f.full_name%TYPE;
957: --
958: -- l_note VARCHAR2(480);
959: l_note po_action_history.note%TYPE;
960: --
961: l_document VARCHAR2(32000) := '';
962: l_tax_amt NUMBER;
963:

Line 1888: l_object_type po_action_history.object_type_code%TYPE;

1884: l_item_type wf_items.item_type%TYPE;
1885: l_item_key wf_items.item_key%TYPE;
1886:
1887: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1888: l_object_type po_action_history.object_type_code%TYPE;
1889: l_org_id po_requisition_lines.org_id%TYPE;
1890:
1891: l_document VARCHAR2(32000) := '';
1892: l_document_hist VARCHAR2(32000) := '';

Line 1916: from po_action_history poh,

1912: poh.OBJECT_REVISION_NUM,
1913: poh.employee_id, /* bug 2788683 */
1914: poh.created_by, /* bug 2788683 */
1915: poh.action_code /* bug 3090563 */
1916: from po_action_history poh,
1917: per_all_people_f per, -- Bug 3404451
1918: po_lookup_codes polc
1919: where OBJECT_TYPE_CODE = v_object_type
1920: and nvl(poh.action_code, 'PENDING') = polc.lookup_code

Line 1937: from po_action_history poh,

1933: /* Bug 2788683 end */
1934:
1935: CURSOR count_rows(v_document_id NUMBER, v_object_type VARCHAR2) IS
1936: SELECT count(*)
1937: from po_action_history poh,
1938: per_all_people_f per,
1939: po_lookup_codes polc
1940: where OBJECT_TYPE_CODE = v_object_type
1941: and nvl(poh.action_code, 'PENDING') = polc.lookup_code

Line 2140: l_object_type po_action_history.object_type_code%TYPE;

2136: max_seqno in number,
2137: p_document out NOCOPY varchar2) IS
2138:
2139: l_document_id po_requisition_lines.requisition_header_id%TYPE;
2140: l_object_type po_action_history.object_type_code%TYPE;
2141: l_org_id po_requisition_lines.org_id%TYPE;
2142:
2143: l_document VARCHAR2(32000) := '';
2144: l_sub_document VARCHAR2(32000) := '';

Line 2325: l_object_type po_action_history.object_type_code%TYPE;

2321: l_item_type wf_items.item_type%TYPE;
2322: l_item_key wf_items.item_key%TYPE;
2323:
2324: l_document_id po_requisition_lines.requisition_header_id%TYPE;
2325: l_object_type po_action_history.object_type_code%TYPE;
2326: l_org_id po_requisition_lines.org_id%TYPE;
2327:
2328: l_document VARCHAR2(32000) := '';
2329:

Line 2346: from po_action_history poh,

2342: poh.NOTE,
2343: poh.OBJECT_REVISION_NUM,
2344: poh.employee_id, /* bug 2788683 */
2345: poh.created_by /* bug 2788683 */
2346: from po_action_history poh,
2347: per_all_people_f per, -- Bug 3404451
2348: po_lookup_codes polc
2349: where OBJECT_TYPE_CODE = v_object_type
2350: and poh.action_code = polc.lookup_code

Line 2365: from po_action_history poh,

2361: poh.NOTE,
2362: poh.OBJECT_REVISION_NUM,
2363: poh.employee_id, /* bug 2788683 */
2364: poh.created_by /* bug 2788683 */
2365: from po_action_history poh,
2366: per_all_people_f per -- Bug 3404451
2367: where OBJECT_TYPE_CODE = v_object_type
2368: and poh.action_code is null
2369: and per.person_id(+) = poh.employee_id /* bug 2788683 */

Line 2516: p_doc_type IN po_action_history.OBJECT_TYPE_CODE%TYPE)

2512: p_recipient_id IN NUMBER,
2513: p_note IN VARCHAR2,
2514: p_req_header_id IN NUMBER,
2515: p_current_id IN NUMBER,
2516: p_doc_type IN po_action_history.OBJECT_TYPE_CODE%TYPE)
2517: IS
2518: pragma AUTONOMOUS_TRANSACTION;
2519:
2520: l_progress VARCHAR2(100) := '000';

Line 2522: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;

2518: pragma AUTONOMOUS_TRANSACTION;
2519:
2520: l_progress VARCHAR2(100) := '000';
2521:
2522: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
2523: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2524: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2525: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2526: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;

Line 2523: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;

2519:
2520: l_progress VARCHAR2(100) := '000';
2521:
2522: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
2523: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2524: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2525: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2526: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2527: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;

Line 2524: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;

2520: l_progress VARCHAR2(100) := '000';
2521:
2522: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
2523: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2524: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2525: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2526: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2527: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2528: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;

Line 2525: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;

2521:
2522: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
2523: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2524: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2525: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2526: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2527: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2528: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2529: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;

Line 2526: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;

2522: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
2523: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2524: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2525: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2526: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2527: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2528: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2529: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
2530: l_approval_group_id PO_ACTION_HISTORY.APPROVAL_GROUP_ID%TYPE;

Line 2527: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;

2523: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2524: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2525: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2526: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2527: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2528: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2529: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
2530: l_approval_group_id PO_ACTION_HISTORY.APPROVAL_GROUP_ID%TYPE;
2531:

Line 2528: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;

2524: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2525: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2526: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2527: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2528: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2529: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
2530: l_approval_group_id PO_ACTION_HISTORY.APPROVAL_GROUP_ID%TYPE;
2531:
2532: begin

Line 2529: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;

2525: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2526: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2527: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2528: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2529: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
2530: l_approval_group_id PO_ACTION_HISTORY.APPROVAL_GROUP_ID%TYPE;
2531:
2532: begin
2533:

Line 2530: l_approval_group_id PO_ACTION_HISTORY.APPROVAL_GROUP_ID%TYPE;

2526: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2527: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2528: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2529: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
2530: l_approval_group_id PO_ACTION_HISTORY.APPROVAL_GROUP_ID%TYPE;
2531:
2532: begin
2533:
2534: SELECT max(sequence_num)

Line 2536: FROM PO_ACTION_HISTORY

2532: begin
2533:
2534: SELECT max(sequence_num)
2535: INTO l_sequence_num
2536: FROM PO_ACTION_HISTORY
2537: WHERE object_type_code = p_doc_type
2538: AND object_id = p_req_header_id;
2539:
2540: -- a person can be in more than one approval groups

Line 2551: FROM PO_ACTION_HISTORY

2547: program_application_id, program_date, program_id
2548: INTO l_object_sub_type_code,
2549: l_object_revision_num, l_approval_path_id, l_request_id,
2550: l_program_application_id, l_program_date, l_program_id
2551: FROM PO_ACTION_HISTORY
2552: WHERE object_type_code = p_doc_type
2553: AND object_id = p_req_header_id
2554: AND employee_id = p_current_id
2555: AND action_code IS NULL

Line 2565: FROM PO_ACTION_HISTORY

2561: program_application_id, program_date, program_id
2562: INTO l_object_sub_type_code,
2563: l_object_revision_num, l_approval_path_id, l_request_id,
2564: l_program_application_id, l_program_date, l_program_id
2565: FROM PO_ACTION_HISTORY
2566: WHERE object_type_code = p_doc_type
2567: AND object_id = p_req_header_id
2568: AND employee_id = p_current_id
2569: AND rownum=1;

Line 2575: FROM PO_ACTION_HISTORY

2571:
2572: begin
2573: SELECT distinct approval_group_id
2574: INTO l_approval_group_id
2575: FROM PO_ACTION_HISTORY
2576: WHERE object_type_code = p_doc_type
2577: AND object_id = p_req_header_id
2578: AND employee_id = p_recipient_id;
2579:

Line 2595: UPDATE PO_ACTION_HISTORY

2591: -- After he takes action with one of the notifications, only ONE record in
2592: -- action_history table should be updated.
2593:
2594:
2595: UPDATE PO_ACTION_HISTORY
2596: SET last_update_date = sysdate,
2597: last_updated_by = fnd_global.user_id,
2598: last_update_login = fnd_global.login_id ,
2599: action_date = sysdate,

Line 2655: l_action po_action_history.action_code%TYPE;

2651: l_forwardTo varchar2(240);
2652: l_result varchar2(100);
2653: l_forward_to_username_response varchar2(240) :='';
2654: l_req_header_id po_requisition_headers.requisition_header_id%TYPE;
2655: l_action po_action_history.action_code%TYPE;
2656: l_new_recipient_id wf_roles.orig_system_id%TYPE;
2657: l_current_recipient_id wf_roles.orig_system_id%TYPE;
2658: l_origsys wf_roles.orig_system%TYPE;
2659: l_is_ame_approval varchar2(10);

Line 2675: l_doc_type po_action_history.OBJECT_TYPE_CODE%TYPE;

2671: l_preparer_appl_id NUMBER;
2672: l_progress VARCHAR2(1000);
2673: l_preserved_ctx VARCHAR2(5);
2674: -- Context setting revamp
2675: l_doc_type po_action_history.OBJECT_TYPE_CODE%TYPE;
2676:
2677: --Bug 11664961
2678: l_original_recipient wf_notifications.original_recipient%TYPE;
2679: l_current_recipient_role wf_notifications.recipient_role%TYPE;