98: dummy_num NUMBER;
99: l_req_num po_requisition_headers_all.segment1%TYPE;
100: l_ou_id po_requisition_headers_all.org_id%TYPE;
101: l_line_num po_requisition_lines_all.line_num%TYPE;
102: l_org_id rcv_shipment_headers.organization_id%TYPE;
103: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
104: l_shipment_num rcv_shipment_headers.shipment_num%TYPE;
105: l_count NUMBER := 1;
106: l_execute NUMBER := 0;
99: l_req_num po_requisition_headers_all.segment1%TYPE;
100: l_ou_id po_requisition_headers_all.org_id%TYPE;
101: l_line_num po_requisition_lines_all.line_num%TYPE;
102: l_org_id rcv_shipment_headers.organization_id%TYPE;
103: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
104: l_shipment_num rcv_shipment_headers.shipment_num%TYPE;
105: l_count NUMBER := 1;
106: l_execute NUMBER := 0;
107:
100: l_ou_id po_requisition_headers_all.org_id%TYPE;
101: l_line_num po_requisition_lines_all.line_num%TYPE;
102: l_org_id rcv_shipment_headers.organization_id%TYPE;
103: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
104: l_shipment_num rcv_shipment_headers.shipment_num%TYPE;
105: l_count NUMBER := 1;
106: l_execute NUMBER := 0;
107:
108: BEGIN
131: begin
132:
133: select shipment_num
134: into l_shipment_num
135: from rcv_shipment_headers rsh
136: where receipt_num = l_receipt_num
137: and ship_to_org_id = l_org_id
138: and rsh.receipt_source_code = 'INTERNAL ORDER';
139:
148:
149: begin
150: select receipt_num
151: into l_receipt_num
152: from rcv_shipment_headers rsh
153: where shipment_num = l_shipment_num
154: and ship_to_org_id = l_org_id
155: and rsh.receipt_source_code = 'INTERNAL ORDER';
156:
239: SELECT Count(*)
240: INTO l_count
241: FROM po_requisition_headers_all prh,
242: po_requisition_lines_all prl,
243: rcv_shipment_headers rsh,
244: rcv_shipment_lines rsl
245: WHERE prh.segment1 = l_req_num
246: AND prh.org_id = l_ou_id
247: AND prh.requisition_header_id = prl.requisition_header_id
268: SELECT Count(*)
269: INTO l_count
270: FROM po_requisition_headers_all prh,
271: po_requisition_lines_all prl,
272: rcv_shipment_headers rsh,
273: rcv_shipment_lines rsl
274: WHERE prh.segment1 = l_req_num
275: AND prh.org_id = l_ou_id
276: AND prh.requisition_header_id = prl.requisition_header_id
313: IF (l_receipt_num is NOT NULL AND l_shipment_num is NOT NULL AND l_org_id is NOT NULL ) THEN
314:
315: SELECT Count(*)
316: INTO l_count
317: FROM rcv_shipment_headers rsh,
318: rcv_shipment_lines rsl
319: WHERE rsh.shipment_num = l_shipment_num
320: AND rsh.receipt_num = l_receipt_num
321: AND rsh.ship_to_org_id = l_org_id
353: IF (l_receipt_num is NOT NULL AND l_org_id is NOT NULL) THEN
354:
355: SELECT Count(*)
356: INTO l_count
357: FROM rcv_shipment_headers rsh,
358: rcv_shipment_lines rsl
359: WHERE rsh.receipt_num = l_receipt_num
360: AND rsh.ship_to_org_id = l_org_id
361: AND rsh.receipt_source_code = 'INTERNAL ORDER';
372: IF (l_shipment_num is NOT NULL AND l_org_id is NOT NULL ) THEN
373:
374: SELECT Count(*)
375: INTO l_count
376: FROM rcv_shipment_headers rsh,
377: rcv_shipment_lines rsl
378: WHERE rsh.shipment_num = l_shipment_num
379: AND rsh.ship_to_org_id = l_org_id
380: AND rsh.receipt_source_code = 'INTERNAL ORDER';
465: '||'
466:
561: JTF_DIAGNOSTIC_COREAPI.BRPrint;
562:
563: JTF_DIAGNOSTIC_COREAPI.insert_html('
562:
563: JTF_DIAGNOSTIC_COREAPI.insert_html('