[Home] [Help]
198:
199: l_progress := 'POS_WCAPPROVE_PVT.start_wf_process: 03.';
200: select max(po_header_id)
201: into l_po_header_id
202: from rcv_shipment_lines
203: where shipment_header_id = p_work_confirmation_id;
204:
205: IF (g_asn_debug = 'Y') THEN
206: debug_log(FND_LOG.LEVEL_STATEMENT,
671: select pk1_value
672: from fnd_attached_documents
673: where entity_name='RCV_LINES'
674: and pk1_value in (select shipment_line_id
675: from rcv_shipment_lines
676: where shipment_header_id=l_shipment_header_id);
677:
678: l_shipment_header_id number;
679: l_shipment_line_id number;
714: into l_attach_count
715: from fnd_attached_documents
716: where entity_name =' RCV_LINES'
717: and pk1_value in (select shipment_line_id
718: from rcv_shipment_lines
719: where shipment_header_id=l_shipment_header_id);
720:
721: IF (g_asn_debug = 'Y') THEN
722: debug_log(FND_LOG.LEVEL_STATEMENT,
779:
780: /*
781: cursor get_shipment_lines(l_shipment_header_id number) is
782: select shipment_line_id
783: from rcv_shipment_lines
784: where shipment_header_id=l_shipment_header_id;
785: */
786:
787: cursor action_hist_cursor (l_shipment_header_id number) is
1375:
1376: /*
1377: cursor get_shipment_lines(l_shipment_header_id number) is
1378: select shipment_line_id
1379: from rcv_shipment_lines
1380: where shipment_header_id=l_shipment_header_id;
1381: */
1382:
1383: CURSOR get_action_history IS
1825:
1826:
1827: select count(*)
1828: into l_reject_lines
1829: from rcv_shipment_lines
1830: where shipment_header_id = l_shipment_header_id
1831: and approval_status = 'REJECTED';
1832:
1833: IF (g_asn_debug = 'Y') THEN
2210: l_current_approver.approval_status := ame_util.noResponseStatus;
2211: else /* Can be approved/rejected from iSP UI */
2212: select count(*)
2213: into l_reject_lines
2214: from rcv_shipment_lines
2215: where shipment_header_id = l_shipment_header_id
2216: and approval_status = 'REJECTED';
2217:
2218: If (l_reject_lines > 0) then
2383: cursor get_shipment_lines(l_shipment_header_id number) is
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: */
3107:
3108: /*
3109: cursor get_shipment_lines(l_shipment_header_id number) is
3110: select rsl.shipment_line_id
3111: from rcv_shipment_lines rsl
3112: where rsl.shipment_header_id = l_shipment_header_id;
3113: */
3114:
3115: CURSOR get_action_history IS
3611: /* If p_level is lines, then it can
3612: * come directly from notificatiion.
3613: * So update the header with the comments.
3614: */
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
3733: --po_distributions_all pod,
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
3770: from po_distributions_all pod
3771: where pod.line_location_id = l_line_location_id;
3772: cursor get_shipment_lines(l_shipment_header_id number) is
3773: select rsl.shipment_line_id
3774: from rcv_shipment_lines rsl
3775: where rsl.shipment_header_id = l_shipment_header_id;
3776:
3777:
3778: X_emp_id number;
4815: END IF;
4816:
4817: select max(po_header_id)
4818: into l_po_header_id
4819: from rcv_shipment_lines
4820: where shipment_header_id = p_shipment_header_id;
4821:
4822: return l_po_header_id;
4823: