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.POS_WCAPPROVE_PVT dependencies on PO_ACTION_HISTORY

Line 761: /* Insert a submit action row in po_action_history to signal the

757: raise;
758: end Get_WC_Attributes;
759:
760:
761: /* Insert a submit action row in po_action_history to signal the
762: * submisinon of the document for Approval. Also insert an
763: * additional row with a NULL ACTION_CODE to simulate a
764: * forward-to. We need to do this for each shipment line in this
765: * document.

Line 777: l_action_code po_action_history.object_type_code%type;

773: l_shipment_header_id number;
774: l_shipment_line_id number;
775: l_wc_preparer_id number;
776: l_sequence_num number;
777: l_action_code po_action_history.object_type_code%type;
778: l_api_name varchar2(50) := p_itemkey || ' ins_actionhist_submit';
779:
780: /*
781: cursor get_shipment_lines(l_shipment_header_id number) is

Line 789: from po_action_history

785: */
786:
787: cursor action_hist_cursor (l_shipment_header_id number) is
788: select max(sequence_num)
789: from po_action_history
790: where object_id=l_shipment_header_id
791: and object_type_code = 'WC';
792:
793: cursor action_hist_code_cursor(l_shipment_header_id number,l_seq_num number) is

Line 795: from po_action_history

791: and object_type_code = 'WC';
792:
793: cursor action_hist_code_cursor(l_shipment_header_id number,l_seq_num number) is
794: select action_code
795: from po_action_history
796: where object_id = l_shipment_header_id
797: and object_type_code='WC'
798: and sequence_num = l_seq_num;
799: BEGIN

Line 1396: FROM PO_ACTION_HISTORY

1392: program_date,
1393: program_id,
1394: last_update_date,
1395: employee_id
1396: FROM PO_ACTION_HISTORY
1397: WHERE object_type_code = 'WC'
1398: AND object_id = l_shipment_header_id
1399: AND sequence_num = l_sequence_num;
1400:

Line 1451: FROM PO_ACTION_HISTORY

1447: l_progress := 'POS_WCAPPROVE_PVT.Insert_Action_History: 04.';
1448:
1449: SELECT count(*)
1450: INTO l_count
1451: FROM PO_ACTION_HISTORY
1452: WHERE object_type_code = 'WC'
1453: AND object_id = l_shipment_header_id
1454: AND action_code IS NULL;
1455:

Line 1471: FROM PO_ACTION_HISTORY

1467: ELSE --}{
1468:
1469: SELECT max(sequence_num)
1470: INTO l_sequence_num
1471: FROM PO_ACTION_HISTORY
1472: WHERE object_type_code = 'WC'
1473: AND object_id = l_shipment_header_id;
1474:
1475: IF (g_asn_debug = 'Y') THEN

Line 1610: l_note po_action_history.note%type;

1606: x_resultout out NOCOPY varchar2) is
1607: l_progress varchar2(200);
1608: l_shipment_header_id number;
1609: l_api_name varchar2(50) := p_itemkey || ' Approve_shipment_lines';
1610: l_note po_action_history.note%type;
1611: l_result varchar2(3);
1612:
1613: l_notification_id number;
1614: CURSOR c_group_id (p_itemtype VARCHAR2,

Line 1706: l_note po_action_history.note%type;

1702: x_resultout out NOCOPY varchar2) is
1703: l_progress varchar2(200);
1704: l_shipment_header_id number;
1705: l_api_name varchar2(50) := p_itemkey || ' Reject_shipment_lines';
1706: l_note po_action_history.note%type;
1707: l_result varchar2(3);
1708:
1709: l_notification_id number;
1710: CURSOR c_group_id (p_itemtype VARCHAR2,

Line 2591: po_action_history ph

2587: ph.object_id object_id,
2588: ph.employee_id employee_id
2589: FROM
2590: rcv_shipment_headers rsh,
2591: po_action_history ph
2592: WHERE rsh.shipment_header_id = ph.object_id
2593: and rsh.shipment_header_id=p_shipment_header_id
2594: and ph.sequence_num = l_sequence_num;
2595:

Line 2613: FROM PO_ACTION_HISTORY

2609:
2610:
2611: SELECT max(sequence_num)
2612: INTO l_sequence_num
2613: FROM PO_ACTION_HISTORY
2614: WHERE object_type_code = 'WC'
2615: AND object_id = p_shipment_header_id;
2616:
2617: OPEN get_action_history(l_sequence_num);

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

2695:
2696:
2697:
2698: /*
2699: ** insert a new NULL row into PO_ACTION_HISTORY for
2700: ** the new approver
2701: */
2702:
2703:

Line 2830: l_note po_action_history.note%type;

2826: l_progress VARCHAR2(250) := '';
2827: l_employee_id NUMBER ;
2828: invalid_action exception;
2829: l_api_name varchar2(50) := ' UpdatePOActionHistory';
2830: l_note po_action_history.note%type;
2831:
2832: BEGIN
2833: l_progress := 'POS_WCAPPROVE_PVT.UpdatePOActionHistory: 01.';
2834: IF (g_asn_debug = 'Y') THEN

Line 2910: UPDATE PO_ACTION_HISTORY

2906: when others then
2907: l_note := null;
2908: end;
2909:
2910: UPDATE PO_ACTION_HISTORY
2911: SET last_update_date = sysdate,
2912: last_updated_by = p_user_id,
2913: last_update_login = p_login_id,
2914: employee_id = p_employee_id,

Line 2974: l_sequence_num PO_ACTION_HISTORY.sequence_num%TYPE := NULL;

2970: p_login_id IN NUMBER)
2971: IS
2972: -- pragma AUTONOMOUS_TRANSACTION;
2973: l_progress VARCHAR2(240) ;
2974: l_sequence_num PO_ACTION_HISTORY.sequence_num%TYPE := NULL;
2975: l_api_name varchar2(50) := ' InsertPOActionHistory';
2976: l_note po_action_history.note%type;
2977:
2978: BEGIN

Line 2976: l_note po_action_history.note%type;

2972: -- pragma AUTONOMOUS_TRANSACTION;
2973: l_progress VARCHAR2(240) ;
2974: l_sequence_num PO_ACTION_HISTORY.sequence_num%TYPE := NULL;
2975: l_api_name varchar2(50) := ' InsertPOActionHistory';
2976: l_note po_action_history.note%type;
2977:
2978: BEGIN
2979:
2980:

Line 3004: FROM PO_ACTION_HISTORY

3000: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 02.';
3001:
3002: SELECT MAX(sequence_num)
3003: INTO l_sequence_num
3004: FROM PO_ACTION_HISTORY
3005: WHERE object_id = p_object_id
3006: AND object_type_code = p_object_type_code;
3007:
3008: l_progress := 'POS_WCAPPROVE_PVT.InsertPOActionHistory: 03.';

Line 3033: INSERT INTO PO_ACTION_HISTORY

3029: END IF;
3030:
3031:
3032:
3033: INSERT INTO PO_ACTION_HISTORY
3034: (object_id,
3035: object_type_code,
3036: object_sub_type_code,
3037: sequence_num,

Line 3101: l_action po_action_history.action_code%TYPE;

3097: l_notification_id number;
3098: l_forwardTo varchar2(240);
3099: l_result varchar2(100);
3100: l_forward_to_username_response varchar2(240) :='';
3101: l_action po_action_history.action_code%TYPE;
3102: l_new_recipient_id wf_roles.orig_system_id%TYPE;
3103: l_origsys wf_roles.orig_system%TYPE;
3104: l_shipment_line_id number;
3105: l_shipment_header_id number;

Line 3141: FROM PO_ACTION_HISTORY

3137: program_date,
3138: program_id,
3139: last_update_date,
3140: employee_id
3141: FROM PO_ACTION_HISTORY
3142: WHERE object_type_code = 'WC'
3143: AND object_id = l_shipment_header_id
3144: AND sequence_num = l_sequence_num;
3145:

Line 3181: from po_action_history

3177: l_progress := 'POS_WCAPPROVE_PVT.post_approval_notif: 02.';
3178:
3179: select max(sequence_num)
3180: into l_sequence_num
3181: from po_action_history
3182: where object_type_code ='WC'
3183: and object_id = l_shipment_header_id;
3184:
3185: OPEN get_action_history;

Line 3719: l_note po_action_history.note%type;

3715: l_locked_doc BOOLEAN := FALSE;
3716: l_shipment_header_id number;
3717: l_progress varchar2(300);
3718: l_api_name varchar2(50) := ' update_approval_status';
3719: l_note po_action_history.note%type;
3720: begin
3721: l_progress := 'POS_WCAPPROVE_PVT.update_approval_status: 01.';
3722: IF (g_asn_debug = 'Y') THEN
3723: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 5050: UPDATE PO_ACTION_HISTORY

5046: l_api_name,'Enter in Upd_ActionHistory_Submit '
5047: || l_progress);
5048: END IF;
5049:
5050: UPDATE PO_ACTION_HISTORY
5051: set object_id = p_object_id,
5052: object_type_code = p_object_type_code,
5053: sequence_num = p_sequence_num,
5054: last_update_date = sysdate,