[Home] [Help]
144:
145: ------------------------------------------------------------------------
146: -- Distribution Level Cursor
147: -- The following conditions must be satisfied:
148: -- 1. Shipment must be on a STANDARD, BLANKET, or PLANNED PO header.
149: -- 2. If a vendor is specified, then the purchase order must be for
150: -- that vendor.
151: -- 3. If an item category has been specified, then the PO line must be
152: -- for that item category.
203: WHERE pol.po_header_id = poh.po_header_id
204: AND poh.pcard_id IS NULL
205: AND poll.po_line_id = pol.po_line_id
206: AND pod.line_location_id = poll.line_location_id
207: AND poh.type_lookup_code IN ('STANDARD', 'BLANKET', 'PLANNED')
208: AND poh.vendor_id = pov.vendor_id
209: AND ((p_vendor_id IS NOT NULL AND pov.vendor_id = p_vendor_id)
210: OR
211: p_vendor_id IS NULL)
302: WHERE pol.po_header_id = poh.po_header_id
303: AND poh.pcard_id IS NULL
304: AND poll.po_line_id = pol.po_line_id
305: AND pod.line_location_id = poll.line_location_id
306: AND poh.type_lookup_code IN ('STANDARD', 'BLANKET', 'PLANNED')
307: AND poll.shipment_type <> 'PREPAYMENT'
308: AND (p_closed_pos = 'Y'
309: OR
310: (poll.shipment_closed_date IS NULL OR poll.shipment_closed_date > l_end_date))
381: WHERE pol.po_header_id = poh.po_header_id
382: AND poh.pcard_id IS NULL
383: AND poll.po_line_id = pol.po_line_id
384: AND pod.line_location_id = poll.line_location_id
385: AND poh.type_lookup_code IN ('STANDARD', 'BLANKET', 'PLANNED')
386: AND poh.vendor_id = pov.vendor_id
387: AND pov.vendor_id = p_vendor_id
388: AND poll.shipment_type <> 'PREPAYMENT'
389: AND (p_closed_pos = 'Y'
460: WHERE pol.po_header_id = poh.po_header_id
461: AND poh.pcard_id IS NULL
462: AND poll.po_line_id = pol.po_line_id
463: AND pod.line_location_id = poll.line_location_id
464: AND poh.type_lookup_code IN ('STANDARD', 'BLANKET', 'PLANNED')
465: AND poh.vendor_id = pov.vendor_id
466: AND ((p_vendor_from IS NOT NULL AND pov.vendor_name >= p_vendor_from)
467: OR
468: p_vendor_from IS NULL)
544: WHERE pol.po_header_id = poh.po_header_id
545: AND poh.pcard_id IS NULL
546: AND poll.po_line_id = pol.po_line_id
547: AND pod.line_location_id = poll.line_location_id
548: AND poh.type_lookup_code IN ('STANDARD', 'BLANKET', 'PLANNED')
549: AND pol.category_id = mca.category_id
550: AND mca.category_id = p_category_id
551: AND mds.structure_id = mca.structure_id
552: AND mds.functional_area_id = 2
626: WHERE pol.po_header_id = poh.po_header_id
627: AND poh.pcard_id IS NULL
628: AND poll.po_line_id = pol.po_line_id
629: AND pod.line_location_id = poll.line_location_id
630: AND poh.type_lookup_code IN ('STANDARD', 'BLANKET', 'PLANNED')
631: AND pol.category_id = mca.category_id
632: AND (p_category_from IS NULL
633: OR
634: (mca.concatenated_segments >= p_category_from AND p_category_from IS NOT NULL))
701: l_acr_cur_conv_date_tbl ACR_CUR_CONV_DATE_TBL_TYPE;
702: l_ctr NUMBER;
703: l_use VARCHAR2(30);
704: BEGIN
705: -- Standard Start of API savepoint
706: SAVEPOINT Create_PerEndAccruals_PVT;
707:
708: l_stmt_num := 0;
709:
721: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_online_accruals = '|| p_online_accruals);
722: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_calling_api = '|| p_calling_api);
723: END IF;
724:
725: -- Standard call to check for call compatibility
726: IF NOT FND_API.Compatible_API_Call ( l_api_version,
727: p_api_version,
728: l_api_name,
729: G_PKG_NAME )
1330: ( p_count => x_msg_count,
1331: p_data => x_msg_data
1332: );
1333:
1334: -- Standard check of p_commit.
1335: IF FND_API.To_Boolean( p_commit ) THEN
1336: COMMIT WORK;
1337: END IF;
1338:
1490: 'Match Option = ' || x_accrual_rec.match_option
1491: );
1492: END IF;
1493:
1494: -- Standard call to check for call compatibility.
1495: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1496: p_api_version,
1497: l_api_name,
1498: G_PKG_NAME )
2129: 'p_end_date = ' || p_end_date
2130: );
2131: END IF;
2132:
2133: -- Standard call to check for call compatibility.
2134: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2135: p_api_version,
2136: l_api_name,
2137: G_PKG_NAME )
2368: 'p_end_date = ' || p_end_date
2369: );
2370: END IF;
2371:
2372: -- Standard call to check for call compatibility.
2373: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2374: p_api_version,
2375: l_api_name,
2376: G_PKG_NAME )
2691: 'p_end_date = ' || p_end_date
2692: );
2693: END IF;
2694:
2695: -- Standard call to check for call compatibility.
2696: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2697: p_api_version,
2698: l_api_name,
2699: G_PKG_NAME )