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 1395: FROM PO_ACTION_HISTORY

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

Line 1450: FROM PO_ACTION_HISTORY

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

Line 1470: FROM PO_ACTION_HISTORY

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

Line 1609: l_note po_action_history.note%type;

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

Line 1705: l_note po_action_history.note%type;

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

Line 2590: po_action_history ph

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

Line 2612: FROM PO_ACTION_HISTORY

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

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

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

Line 2829: l_note po_action_history.note%type;

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

Line 2909: UPDATE PO_ACTION_HISTORY

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

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

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

Line 2975: l_note po_action_history.note%type;

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

Line 3003: FROM PO_ACTION_HISTORY

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

Line 3032: INSERT INTO PO_ACTION_HISTORY

3028: END IF;
3029:
3030:
3031:
3032: INSERT INTO PO_ACTION_HISTORY
3033: (object_id,
3034: object_type_code,
3035: object_sub_type_code,
3036: 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 3127: FROM PO_ACTION_HISTORY

3123: program_date,
3124: program_id,
3125: last_update_date,
3126: employee_id
3127: FROM PO_ACTION_HISTORY
3128: WHERE object_type_code = 'WC'
3129: AND object_id = l_shipment_header_id
3130: AND sequence_num = l_sequence_num;
3131:

Line 3179: from po_action_history

3175:
3176:
3177: select max(sequence_num)
3178: into l_sequence_num
3179: from po_action_history
3180: where object_type_code ='WC'
3181: and object_id = l_shipment_header_id;
3182:
3183:

Line 3554: l_note po_action_history.note%type;

3550: l_locked_doc BOOLEAN := FALSE;
3551: l_shipment_header_id number;
3552: l_progress varchar2(300);
3553: l_api_name varchar2(50) := ' update_approval_status';
3554: l_note po_action_history.note%type;
3555: begin
3556: l_progress := 'POS_WCAPPROVE_PVT.update_approval_status: 01.';
3557: IF (g_asn_debug = 'Y') THEN
3558: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 4723: UPDATE PO_ACTION_HISTORY

4719: l_api_name,'Enter in Upd_ActionHistory_Submit '
4720: || l_progress);
4721: END IF;
4722:
4723: UPDATE PO_ACTION_HISTORY
4724: set object_id = p_object_id,
4725: object_type_code = p_object_type_code,
4726: sequence_num = p_sequence_num,
4727: last_update_date = sysdate,