[Home] [Help]
327: and nvl(rl.end_date_active(+),sysdate);
328:
329: END IF;
330:
331: -- Set the Global OE_BULK_ORDER_PVT.G_CC_REQUIRED if the cc rule exists
332: -- for one of the Order Types in a batch
333:
334: IF G_ORDER_TYPE_TBL(p_key).entry_credit_check_rule_id IS NOT NULL
335: THEN
332: -- for one of the Order Types in a batch
333:
334: IF G_ORDER_TYPE_TBL(p_key).entry_credit_check_rule_id IS NOT NULL
335: THEN
336: IF OE_BULK_ORDER_PVT.G_CC_REQUIRED = 'N' THEN
337: OE_BULK_ORDER_PVT.G_CC_REQUIRED := 'Y';
338: END IF;
339:
340: -- Set the Global OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED if any one
333:
334: IF G_ORDER_TYPE_TBL(p_key).entry_credit_check_rule_id IS NOT NULL
335: THEN
336: IF OE_BULK_ORDER_PVT.G_CC_REQUIRED = 'N' THEN
337: OE_BULK_ORDER_PVT.G_CC_REQUIRED := 'Y';
338: END IF;
339:
340: -- Set the Global OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED if any one
341: -- order in a batch requires real time credit checking. If this flag
336: IF OE_BULK_ORDER_PVT.G_CC_REQUIRED = 'N' THEN
337: OE_BULK_ORDER_PVT.G_CC_REQUIRED := 'Y';
338: END IF;
339:
340: -- Set the Global OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED if any one
341: -- order in a batch requires real time credit checking. If this flag
342: -- is set then orders will get inserted with booked_flag = 'N' to allow
343: -- Real Time CC to happen order by order.
344:
344:
345: IF ( G_ORDER_TYPE_TBL(p_key).quick_cr_check_flag IS NULL OR
346: G_ORDER_TYPE_TBL(p_key).quick_cr_check_flag = 'N')
347: THEN
348: IF OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED = 'N' THEN
349: OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED := 'Y';
350: END IF;
351: END IF;
352: END IF;
345: IF ( G_ORDER_TYPE_TBL(p_key).quick_cr_check_flag IS NULL OR
346: G_ORDER_TYPE_TBL(p_key).quick_cr_check_flag = 'N')
347: THEN
348: IF OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED = 'N' THEN
349: OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED := 'Y';
350: END IF;
351: END IF;
352: END IF;
353:
600: RETURN p_key1;
601:
602: END IF;
603:
604: l_key2 := OE_BULK_ORDER_PVT.G_ITEM_ORG;
605:
606: IF p_key1 IS NOT NULL AND
607: NOT G_ITEM_TBL.EXISTS(p_key1) THEN
608:
705: AND kfv.ORGANIZATION_ID = l_key2;
706:
707: -- INVCONV start remove opm
708:
709: /* IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG = 'Y' THEN
710:
711: IF l_debug_level > 0 THEN
712: oe_debug_pub.add( 'PROCESS INSTALLED' ) ;
713: END IF;
754: IF l_debug_level > 0 THEN
755: oe_debug_pub.add( 'QUERYING BASED ON SHIP_FROM_ORG' , 3 ) ;
756: END IF;
757:
758: -- invconv IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG <> 'Y' THEN -- OPM HVOP added for error to test
759:
760: SELECT shippable_item_flag
761: ,organization_id
762: ,primary_uom_code
847: END IF;
848: G_ITEM_TBL.DELETE(p_key1);
849: END IF;
850:
851: /*IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG = 'Y' -- INVCONV take out
852: AND INV_GMI_RSV_BRANCH.Is_Org_Process_Org(p_key2) THEN
853: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
854: OE_BULK_MSG_PUB.add('Y','ERROR');
855: RAISE NO_DATA_FOUND;
1006: AND b.site_use_code='SHIP_TO';
1007:
1008: Get_Address
1009: (p_address_type_in => 'CUSTOMER',
1010: p_org_id_in => OE_BULK_ORDER_PVT.G_ITEM_ORG,
1011: p_address_id_in => G_SHIP_TO_TBL(p_key).address_id,
1012: p_tp_location_code_in => NULL,
1013: p_tp_translator_code_in => NULL,
1014: l_addr1 => G_SHIP_TO_TBL(p_key).address1,
1482: <
1483:
1484: Get_Address
1485: (p_address_type_in => 'CUSTOMER',
1486: p_org_id_in => OE_BULK_ORDER_PVT.G_ITEM_ORG,
1487: p_address_id_in => G_SOLD_TO_SITE_TBL(p_key).address_id,
1488: p_tp_location_code_in => NULL,
1489: p_tp_translator_code_in => NULL,
1490: l_addr1 => G_SOLD_TO_SITE_TBL(p_key).address1,
1635: AND b.site_use_code='BILL_TO';
1636:
1637: Get_Address
1638: (p_address_type_in => 'CUSTOMER',
1639: p_org_id_in => OE_BULK_ORDER_PVT.G_ITEM_ORG,
1640: p_address_id_in => G_INVOICE_TO_TBL(p_key).address_id,
1641: p_tp_location_code_in => NULL,
1642: p_tp_translator_code_in => NULL,
1643: l_addr1 => G_INVOICE_TO_TBL(p_key).address1,
1783: AND b.site_use_code='SOLD_TO';
1784:
1785: Get_Address
1786: (p_address_type_in => 'CUSTOMER',
1787: p_org_id_in => OE_BULK_ORDER_PVT.G_ITEM_ORG,
1788: p_address_id_in => G_SOLD_TO_SITE_TBL(p_key).address_id,
1789: p_tp_location_code_in => NULL,
1790: p_tp_translator_code_in => NULL,
1791: l_addr1 => G_SOLD_TO_SITE_TBL(p_key).address1,
1954: END;
1955:
1956: Get_Address(
1957: p_address_type_in => 'HR_LOCATION',
1958: p_org_id_in => OE_BULK_ORDER_PVT.G_ITEM_ORG,
1959: p_address_id_in => l_addr_id,
1960: p_tp_location_code_in => NULL,
1961: p_tp_translator_code_in => NULL,
1962: l_addr1 => l_addr1,
2218: BETWEEN trunc(V.START_DATE)
2219: AND NVL(trunc(V.END_DATE),trunc(p_tax_date))
2220: AND V.TAX_CLASS = 'O'
2221: AND NVL(V.ENABLED_FLAG,'Y') = 'Y'
2222: AND V.SET_OF_BOOKS_ID = OE_BULK_ORDER_PVT.G_SOB_ID;
2223:
2224: RETURN 1;
2225:
2226: END Load_Tax_Attributes;