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 RCV_SHIPMENT_HEADERS

Line 182: from rcv_shipment_headers

178: END IF;
179:
180: select shipment_num
181: into l_work_confirmation_number
182: from rcv_shipment_headers
183: where shipment_header_id = p_work_confirmation_id
184: and nvl(asn_type,'STD') = 'WC';
185:
186: IF (g_asn_debug = 'Y') THEN

Line 304: from rcv_shipment_headers

300: l_progress varchar2(300);
301:
302: cursor ship_header_cursor(p_header_id number) is
303: select wf_item_key
304: from rcv_shipment_headers
305: where shipment_header_id = p_header_id;
306:
307: l_api_name varchar2(50) := p_itemkey || ' close_old_notif';
308:

Line 426: from rcv_shipment_headers

422:
423: l_progress := 'POS_WCAPPROVE_PVT.set_startup_values: 02.';
424: select created_by
425: into l_wc_preparer_id
426: from rcv_shipment_headers
427: where shipment_header_id= l_work_confirmation_id;
428:
429:
430: select employee_id

Line 2389: rcv_shipment_headers rsh

2385: select rsl.shipment_line_id ,
2386: nvl(rsl.comments,rsh.comments),
2387: rsl.approval_status
2388: from rcv_shipment_lines rsl,
2389: rcv_shipment_headers rsh
2390: where rsh.shipment_header_id = l_shipment_header_id
2391: and rsh.shipment_header_id= rsl.shipment_header_id;
2392: */
2393:

Line 2590: rcv_shipment_headers rsh,

2586: ph.last_update_date last_update_date,
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;

Line 2902: from rcv_shipment_headers

2898: begin
2899: if (p_action_code = 'APPROVE' OR p_action_code ='REJECT') then
2900: select comments
2901: into l_note
2902: from rcv_shipment_headers
2903: where shipment_header_id=p_object_id;
2904: end if;
2905: exception
2906: when others then

Line 3474: l_approval_status rcv_shipment_headers.approval_status%type := 'REJECTED';

3470: x_resultout out NOCOPY varchar2) IS
3471:
3472: l_progress varchar2(300);
3473: l_api_name varchar2(50) := p_itemkey ||' reject_doc';
3474: l_approval_status rcv_shipment_headers.approval_status%type := 'REJECTED';
3475: l_result varchar2(3);
3476: l_shipment_header_id number;
3477: l_po_header_id number;
3478: l_work_confirmation_number varchar2(30);

Line 3592: l_approval_status rcv_shipment_headers.approval_status%type := 'APPROVED';

3588: x_resultout out NOCOPY varchar2) IS
3589:
3590: l_progress varchar2(300);
3591: l_api_name varchar2(50) := p_itemkey || ' Approve_doc';
3592: l_approval_status rcv_shipment_headers.approval_status%type := 'APPROVED';
3593: l_result varchar2(3);
3594: l_shipment_header_id number;
3595: l_po_header_id number;
3596: l_note varchar2(4000);

Line 3708: from rcv_shipment_headers

3704: x_resultout out NOCOPY varchar2) IS
3705:
3706: cursor lock_rsh(l_shipment_header_id number) is
3707: select null
3708: from rcv_shipment_headers
3709: where shipment_header_id = l_shipment_header_id
3710: for update of shipment_header_id nowait;
3711:
3712: resource_busy_exc EXCEPTION;

Line 3768: update rcv_shipment_headers

3764: return;
3765:
3766: END IF;
3767:
3768: update rcv_shipment_headers
3769: set approval_status = p_approval_status,
3770: comments = nvl(p_note,comments)
3771: where shipment_header_id = p_shipment_header_id;
3772: end if;

Line 3784: update rcv_shipment_headers

3780: update rcv_shipment_lines
3781: set approval_status = p_approval_status
3782: where shipment_header_id=p_shipment_header_id ;
3783:
3784: update rcv_shipment_headers
3785: set comments = nvl(p_note,comments)
3786: where shipment_header_id = p_shipment_header_id;
3787: end if;
3788:

Line 3906: rcv_shipment_headers rsh,

3902: po_line_locations_all pll,
3903: po_lines_all pl,
3904: po_headers_all ph,
3905: rcv_shipment_lines rsl,
3906: rcv_shipment_headers rsh,
3907: po_doc_style_headers pdsh
3908: WHERE
3909: rsh.shipment_header_id = l_shipment_header_id
3910: and rsl.shipment_header_id = rsh.shipment_header_id

Line 4819: update rcv_shipment_headers

4815: debug_log(FND_LOG.LEVEL_STATEMENT,
4816: l_api_name,'l_receipt_num '||l_receipt_num);
4817: END IF;
4818:
4819: update rcv_shipment_headers
4820: set receipt_num= l_receipt_num,
4821: last_update_date = sysdate,
4822: last_updated_by = fnd_global.user_id,
4823: last_update_login = fnd_global.login_id

Line 5009: UPDATE rcv_shipment_headers

5005: debug_log(FND_LOG.LEVEL_STATEMENT,
5006: l_api_name,'p_shipment_header_id ' || p_shipment_header_id);
5007: END IF;
5008:
5009: UPDATE rcv_shipment_headers
5010: SET WF_ITEM_TYPE = p_itemtype,
5011: WF_ITEM_KEY = p_itemkey,
5012: last_updated_by = fnd_global.user_id,
5013: last_update_login = fnd_global.login_id,

Line 5173: from rcv_shipment_headers

5169: BEGIN
5170:
5171: select ship_to_org_id
5172: into l_ship_to_org_id
5173: from rcv_shipment_headers
5174: where shipment_header_id=p_shipment_header_id;
5175:
5176: IF (g_asn_debug = 'Y') THEN
5177: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 5192: FROM rcv_shipment_headers

5188:
5189: LOOP
5190: SELECT COUNT(*)
5191: INTO l_count
5192: FROM rcv_shipment_headers
5193: WHERE receipt_num = x_receipt_num
5194: AND ship_to_org_id = l_ship_to_org_id;
5195:
5196: IF l_count = 0 THEN