APPS.POS_WCAPPROVE_PVT dependencies on RCV_SHIPMENT_LINES

Line 202: from rcv_shipment_lines

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,

Line 675: from rcv_shipment_lines

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;

Line 718: from rcv_shipment_lines

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,

Line 783: from rcv_shipment_lines

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

Line 1380: from rcv_shipment_lines

1376:
1377: /*
1378: cursor get_shipment_lines(l_shipment_header_id number) is
1379: select shipment_line_id
1380: from rcv_shipment_lines
1381: where shipment_header_id=l_shipment_header_id;
1382: */
1383:
1384: CURSOR get_action_history IS

Line 1830: from rcv_shipment_lines

1826:
1827:
1828: select count(*)
1829: into l_reject_lines
1830: from rcv_shipment_lines
1831: where shipment_header_id = l_shipment_header_id
1832: and approval_status = 'REJECTED';
1833:
1834: IF (g_asn_debug = 'Y') THEN

Line 2215: from rcv_shipment_lines

2211: l_current_approver.approval_status := ame_util.noResponseStatus;
2212: else /* Can be approved/rejected from iSP UI */
2213: select count(*)
2214: into l_reject_lines
2215: from rcv_shipment_lines
2216: where shipment_header_id = l_shipment_header_id
2217: and approval_status = 'REJECTED';
2218:
2219: If (l_reject_lines > 0) then

Line 2388: from rcv_shipment_lines rsl,

2384: cursor get_shipment_lines(l_shipment_header_id number) is
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: */

Line 3125: from rcv_shipment_lines rsl

3121:
3122: /*
3123: cursor get_shipment_lines(l_shipment_header_id number) is
3124: select rsl.shipment_line_id
3125: from rcv_shipment_lines rsl
3126: where rsl.shipment_header_id = l_shipment_header_id;
3127: */
3128:
3129: CURSOR get_action_history IS

Line 3780: update rcv_shipment_lines

3776: /* If p_level is lines, then it can
3777: * come directly from notificatiion.
3778: * So update the header with the comments.
3779: */
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

Line 3905: rcv_shipment_lines rsl,

3901: --po_distributions_all pod,
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

Line 3953: from rcv_shipment_lines rsl

3949:
3950:
3951: cursor get_shipment_lines(l_shipment_header_id number) is
3952: select rsl.shipment_line_id
3953: from rcv_shipment_lines rsl
3954: where rsl.shipment_header_id = l_shipment_header_id;
3955:
3956:
3957: X_emp_id number;

Line 5146: from rcv_shipment_lines

5142: END IF;
5143:
5144: select max(po_header_id)
5145: into l_po_header_id
5146: from rcv_shipment_lines
5147: where shipment_header_id = p_shipment_header_id;
5148:
5149: return l_po_header_id;
5150: