[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.
202: mtl_default_sets_view mds
203: WHERE pol.po_header_id = poh.po_header_id
204: AND poll.po_line_id = pol.po_line_id
205: AND pod.line_location_id = poll.line_location_id
206: AND poh.type_lookup_code IN ('STANDARD', 'BLANKET', 'PLANNED')
207: AND poh.vendor_id = pov.vendor_id
208: AND ((p_vendor_id IS NOT NULL AND pov.vendor_id = p_vendor_id)
209: OR
210: p_vendor_id IS NULL)
298: ,po_headers_all poh
299: WHERE pol.po_header_id = poh.po_header_id
300: AND poll.po_line_id = pol.po_line_id
301: AND pod.line_location_id = poll.line_location_id
302: AND poh.type_lookup_code IN ('STANDARD', 'BLANKET', 'PLANNED')
303: AND poll.shipment_type <> 'PREPAYMENT'
304: AND (p_closed_pos = 'Y'
305: OR
306: (poll.closed_date IS NULL OR poll.closed_date > l_end_date))
374: ,po_vendors pov
375: WHERE pol.po_header_id = poh.po_header_id
376: AND poll.po_line_id = pol.po_line_id
377: AND pod.line_location_id = poll.line_location_id
378: AND poh.type_lookup_code IN ('STANDARD', 'BLANKET', 'PLANNED')
379: AND poh.vendor_id = pov.vendor_id
380: AND pov.vendor_id = p_vendor_id
381: AND poll.shipment_type <> 'PREPAYMENT'
382: AND (p_closed_pos = 'Y'
450: ,po_vendors pov
451: WHERE pol.po_header_id = poh.po_header_id
452: AND poll.po_line_id = pol.po_line_id
453: AND pod.line_location_id = poll.line_location_id
454: AND poh.type_lookup_code IN ('STANDARD', 'BLANKET', 'PLANNED')
455: AND poh.vendor_id = pov.vendor_id
456: AND ((p_vendor_from IS NOT NULL AND pov.vendor_name >= p_vendor_from)
457: OR
458: p_vendor_from IS NULL)
531: ,mtl_default_sets_view mds
532: WHERE pol.po_header_id = poh.po_header_id
533: AND poll.po_line_id = pol.po_line_id
534: AND pod.line_location_id = poll.line_location_id
535: AND poh.type_lookup_code IN ('STANDARD', 'BLANKET', 'PLANNED')
536: AND pol.category_id = mca.category_id
537: AND mca.category_id = p_category_id
538: AND mds.structure_id = mca.structure_id
539: AND mds.functional_area_id = 2
610: ,mtl_default_sets_view mds
611: WHERE pol.po_header_id = poh.po_header_id
612: AND poll.po_line_id = pol.po_line_id
613: AND pod.line_location_id = poll.line_location_id
614: AND poh.type_lookup_code IN ('STANDARD', 'BLANKET', 'PLANNED')
615: AND pol.category_id = mca.category_id
616: AND (p_category_from IS NULL
617: OR
618: (mca.concatenated_segments >= p_category_from AND p_category_from IS NOT NULL))
683: l_acr_cur_conv_date_tbl ACR_CUR_CONV_DATE_TBL_TYPE;
684: l_ctr NUMBER;
685: l_use VARCHAR2(30);
686: BEGIN
687: -- Standard Start of API savepoint
688: SAVEPOINT Create_PerEndAccruals_PVT;
689:
690: l_stmt_num := 0;
691:
703: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_online_accruals = '|| p_online_accruals);
704: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,l_module,' p_calling_api = '|| p_calling_api);
705: END IF;
706:
707: -- Standard call to check for call compatibility
708: IF NOT FND_API.Compatible_API_Call ( l_api_version,
709: p_api_version,
710: l_api_name,
711: G_PKG_NAME )
1312: ( p_count => x_msg_count,
1313: p_data => x_msg_data
1314: );
1315:
1316: -- Standard check of p_commit.
1317: IF FND_API.To_Boolean( p_commit ) THEN
1318: COMMIT WORK;
1319: END IF;
1320:
1471: 'Match Option = ' || x_accrual_rec.match_option
1472: );
1473: END IF;
1474:
1475: -- Standard call to check for call compatibility.
1476: IF NOT FND_API.Compatible_API_Call ( l_api_version,
1477: p_api_version,
1478: l_api_name,
1479: G_PKG_NAME )
2024: 'p_end_date = ' || p_end_date
2025: );
2026: END IF;
2027:
2028: -- Standard call to check for call compatibility.
2029: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2030: p_api_version,
2031: l_api_name,
2032: G_PKG_NAME )
2258: 'p_end_date = ' || p_end_date
2259: );
2260: END IF;
2261:
2262: -- Standard call to check for call compatibility.
2263: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2264: p_api_version,
2265: l_api_name,
2266: G_PKG_NAME )
2581: 'p_end_date = ' || p_end_date
2582: );
2583: END IF;
2584:
2585: -- Standard call to check for call compatibility.
2586: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2587: p_api_version,
2588: l_api_name,
2589: G_PKG_NAME )