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 1915: from po_action_history poh,

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

Line 2101: l_object_type po_action_history.object_type_code%TYPE;

2097: max_seqno in number,
2098: p_document out NOCOPY varchar2) IS
2099:
2100: l_document_id po_requisition_lines.requisition_header_id%TYPE;
2101: l_object_type po_action_history.object_type_code%TYPE;
2102: l_org_id po_requisition_lines.org_id%TYPE;
2103:
2104: l_document VARCHAR2(32000) := '';
2105: l_sub_document VARCHAR2(32000) := '';

Line 2266: l_object_type po_action_history.object_type_code%TYPE;

2262: l_item_type wf_items.item_type%TYPE;
2263: l_item_key wf_items.item_key%TYPE;
2264:
2265: l_document_id po_requisition_lines.requisition_header_id%TYPE;
2266: l_object_type po_action_history.object_type_code%TYPE;
2267: l_org_id po_requisition_lines.org_id%TYPE;
2268:
2269: l_document VARCHAR2(32000) := '';
2270:

Line 2287: from po_action_history poh,

2283: poh.NOTE,
2284: poh.OBJECT_REVISION_NUM,
2285: poh.employee_id, /* bug 2788683 */
2286: poh.created_by /* bug 2788683 */
2287: from po_action_history poh,
2288: per_all_people_f per, -- Bug 3404451
2289: po_lookup_codes polc
2290: where OBJECT_TYPE_CODE = v_object_type
2291: and poh.action_code = polc.lookup_code

Line 2306: from po_action_history poh,

2302: poh.NOTE,
2303: poh.OBJECT_REVISION_NUM,
2304: poh.employee_id, /* bug 2788683 */
2305: poh.created_by /* bug 2788683 */
2306: from po_action_history poh,
2307: per_all_people_f per -- Bug 3404451
2308: where OBJECT_TYPE_CODE = v_object_type
2309: and poh.action_code is null
2310: and per.person_id(+) = poh.employee_id /* bug 2788683 */

Line 2462: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;

2458: pragma AUTONOMOUS_TRANSACTION;
2459:
2460: l_progress VARCHAR2(100) := '000';
2461:
2462: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
2463: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2464: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2465: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2466: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;

Line 2463: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;

2459:
2460: l_progress VARCHAR2(100) := '000';
2461:
2462: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
2463: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2464: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2465: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2466: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2467: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;

Line 2464: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;

2460: l_progress VARCHAR2(100) := '000';
2461:
2462: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
2463: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2464: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2465: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2466: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2467: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2468: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;

Line 2465: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;

2461:
2462: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
2463: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2464: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2465: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2466: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2467: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2468: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2469: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;

Line 2466: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;

2462: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
2463: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2464: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2465: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2466: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2467: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2468: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2469: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
2470: l_approval_group_id PO_ACTION_HISTORY.APPROVAL_GROUP_ID%TYPE;

Line 2467: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;

2463: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
2464: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2465: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2466: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2467: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2468: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2469: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
2470: l_approval_group_id PO_ACTION_HISTORY.APPROVAL_GROUP_ID%TYPE;
2471:

Line 2468: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;

2464: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
2465: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2466: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2467: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2468: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2469: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
2470: l_approval_group_id PO_ACTION_HISTORY.APPROVAL_GROUP_ID%TYPE;
2471:
2472: begin

Line 2469: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;

2465: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
2466: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2467: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2468: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2469: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
2470: l_approval_group_id PO_ACTION_HISTORY.APPROVAL_GROUP_ID%TYPE;
2471:
2472: begin
2473:

Line 2470: l_approval_group_id PO_ACTION_HISTORY.APPROVAL_GROUP_ID%TYPE;

2466: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
2467: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
2468: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
2469: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
2470: l_approval_group_id PO_ACTION_HISTORY.APPROVAL_GROUP_ID%TYPE;
2471:
2472: begin
2473:
2474: SELECT max(sequence_num)

Line 2476: FROM PO_ACTION_HISTORY

2472: begin
2473:
2474: SELECT max(sequence_num)
2475: INTO l_sequence_num
2476: FROM PO_ACTION_HISTORY
2477: WHERE object_type_code = 'REQUISITION'
2478: AND object_id = p_req_header_id;
2479:
2480: -- a person can be in more than one approval groups

Line 2488: FROM PO_ACTION_HISTORY

2484: program_application_id, program_date, program_id
2485: INTO l_object_sub_type_code,
2486: l_object_revision_num, l_approval_path_id, l_request_id,
2487: l_program_application_id, l_program_date, l_program_id
2488: FROM PO_ACTION_HISTORY
2489: WHERE object_type_code = 'REQUISITION'
2490: AND object_id = p_req_header_id
2491: AND employee_id = p_current_id
2492: AND action_code IS NULL

Line 2498: FROM PO_ACTION_HISTORY

2494:
2495: begin
2496: SELECT distinct approval_group_id
2497: INTO l_approval_group_id
2498: FROM PO_ACTION_HISTORY
2499: WHERE object_type_code = 'REQUISITION'
2500: AND object_id = p_req_header_id
2501: AND employee_id = p_recipient_id;
2502:

Line 2518: UPDATE PO_ACTION_HISTORY

2514: -- After he takes action with one of the notifications, only ONE record in
2515: -- action_history table should be updated.
2516:
2517:
2518: UPDATE PO_ACTION_HISTORY
2519: SET last_update_date = sysdate,
2520: last_updated_by = fnd_global.user_id,
2521: last_update_login = fnd_global.login_id ,
2522: action_date = sysdate,

Line 2578: l_action po_action_history.action_code%TYPE;

2574: l_forwardTo varchar2(240);
2575: l_result varchar2(100);
2576: l_forward_to_username_response varchar2(240) :='';
2577: l_req_header_id po_requisition_headers.requisition_header_id%TYPE;
2578: l_action po_action_history.action_code%TYPE;
2579: l_new_recipient_id wf_roles.orig_system_id%TYPE;
2580: l_current_recipient_id wf_roles.orig_system_id%TYPE;
2581: l_origsys wf_roles.orig_system%TYPE;
2582: l_is_ame_approval varchar2(10);