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 2388: rcv_shipment_headers rsh

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

Line 2589: rcv_shipment_headers rsh,

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

Line 2901: from rcv_shipment_headers

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

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

3307: x_resultout out NOCOPY varchar2) IS
3308:
3309: l_progress varchar2(300);
3310: l_api_name varchar2(50) := p_itemkey ||' reject_doc';
3311: l_approval_status rcv_shipment_headers.approval_status%type := 'REJECTED';
3312: l_result varchar2(3);
3313: l_shipment_header_id number;
3314: l_po_header_id number;
3315: l_work_confirmation_number varchar2(30);

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

3424: x_resultout out NOCOPY varchar2) IS
3425:
3426: l_progress varchar2(300);
3427: l_api_name varchar2(50) := p_itemkey || ' Approve_doc';
3428: l_approval_status rcv_shipment_headers.approval_status%type := 'APPROVED';
3429: l_result varchar2(3);
3430: l_shipment_header_id number;
3431: l_po_header_id number;
3432: l_note varchar2(4000);

Line 3543: from rcv_shipment_headers

3539: x_resultout out NOCOPY varchar2) IS
3540:
3541: cursor lock_rsh(l_shipment_header_id number) is
3542: select null
3543: from rcv_shipment_headers
3544: where shipment_header_id = l_shipment_header_id
3545: for update of shipment_header_id nowait;
3546:
3547: resource_busy_exc EXCEPTION;

Line 3603: update rcv_shipment_headers

3599: return;
3600:
3601: END IF;
3602:
3603: update rcv_shipment_headers
3604: set approval_status = p_approval_status,
3605: comments = nvl(p_note,comments)
3606: where shipment_header_id = p_shipment_header_id;
3607: end if;

Line 3619: update rcv_shipment_headers

3615: update rcv_shipment_lines
3616: set approval_status = p_approval_status
3617: where shipment_header_id=p_shipment_header_id ;
3618:
3619: update rcv_shipment_headers
3620: set comments = nvl(p_note,comments)
3621: where shipment_header_id = p_shipment_header_id;
3622: end if;
3623:

Line 3738: rcv_shipment_headers rsh

3734: po_line_locations_all pll,
3735: po_lines_all pl,
3736: po_headers_all ph,
3737: rcv_shipment_lines rsl,
3738: rcv_shipment_headers rsh
3739: WHERE
3740: rsh.shipment_header_id = l_shipment_header_id
3741: and rsl.shipment_header_id = rsh.shipment_header_id
3742: and rsl.po_header_id = ph.po_header_id

Line 3875: from rcv_shipment_headers

3871: l_ship_to_org_id,
3872: l_ship_to_location_id,
3873: l_expected_receipt_date,
3874: l_shipment_num
3875: from rcv_shipment_headers
3876: where shipment_header_id=l_shipment_header_id;
3877:
3878: IF (g_asn_debug = 'Y') THEN
3879: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 3925: /* Update rcv_shipment_headers with receipt_num */

3921: );
3922:
3923: */
3924:
3925: /* Update rcv_shipment_headers with receipt_num */
3926: /*
3927: */
3928:
3929: IF (g_asn_debug = 'Y') THEN

Line 4496: update rcv_shipment_headers

4492: debug_log(FND_LOG.LEVEL_STATEMENT,
4493: l_api_name,'l_receipt_num '||l_receipt_num);
4494: END IF;
4495:
4496: update rcv_shipment_headers
4497: set receipt_num= l_receipt_num,
4498: last_update_date = sysdate,
4499: last_updated_by = fnd_global.user_id,
4500: last_update_login = fnd_global.login_id

Line 4682: UPDATE rcv_shipment_headers

4678: debug_log(FND_LOG.LEVEL_STATEMENT,
4679: l_api_name,'p_shipment_header_id ' || p_shipment_header_id);
4680: END IF;
4681:
4682: UPDATE rcv_shipment_headers
4683: SET WF_ITEM_TYPE = p_itemtype,
4684: WF_ITEM_KEY = p_itemkey,
4685: last_updated_by = fnd_global.user_id,
4686: last_update_login = fnd_global.login_id,

Line 4846: from rcv_shipment_headers

4842: BEGIN
4843:
4844: select ship_to_org_id
4845: into l_ship_to_org_id
4846: from rcv_shipment_headers
4847: where shipment_header_id=p_shipment_header_id;
4848:
4849: IF (g_asn_debug = 'Y') THEN
4850: debug_log(FND_LOG.LEVEL_STATEMENT,

Line 4865: FROM rcv_shipment_headers

4861:
4862: LOOP
4863: SELECT COUNT(*)
4864: INTO l_count
4865: FROM rcv_shipment_headers
4866: WHERE receipt_num = x_receipt_num
4867: AND ship_to_org_id = l_ship_to_org_id;
4868:
4869: IF l_count = 0 THEN