APPS.OE_BULK_CACHE dependencies on OE_BULK_ORDER_PVT

Line 332: -- Set the Global OE_BULK_ORDER_PVT.G_CC_REQUIRED if the cc rule exists

328: and nvl(rl.end_date_active(+),sysdate);
329:
330: END IF;
331:
332: -- Set the Global OE_BULK_ORDER_PVT.G_CC_REQUIRED if the cc rule exists
333: -- for one of the Order Types in a batch
334:
335: IF G_ORDER_TYPE_TBL(p_key).entry_credit_check_rule_id IS NOT NULL
336: THEN

Line 337: IF OE_BULK_ORDER_PVT.G_CC_REQUIRED = 'N' THEN

333: -- for one of the Order Types in a batch
334:
335: IF G_ORDER_TYPE_TBL(p_key).entry_credit_check_rule_id IS NOT NULL
336: THEN
337: IF OE_BULK_ORDER_PVT.G_CC_REQUIRED = 'N' THEN
338: OE_BULK_ORDER_PVT.G_CC_REQUIRED := 'Y';
339: END IF;
340:
341: -- Set the Global OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED if any one

Line 338: OE_BULK_ORDER_PVT.G_CC_REQUIRED := 'Y';

334:
335: IF G_ORDER_TYPE_TBL(p_key).entry_credit_check_rule_id IS NOT NULL
336: THEN
337: IF OE_BULK_ORDER_PVT.G_CC_REQUIRED = 'N' THEN
338: OE_BULK_ORDER_PVT.G_CC_REQUIRED := 'Y';
339: END IF;
340:
341: -- Set the Global OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED if any one
342: -- order in a batch requires real time credit checking. If this flag

Line 341: -- Set the Global OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED if any one

337: IF OE_BULK_ORDER_PVT.G_CC_REQUIRED = 'N' THEN
338: OE_BULK_ORDER_PVT.G_CC_REQUIRED := 'Y';
339: END IF;
340:
341: -- Set the Global OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED if any one
342: -- order in a batch requires real time credit checking. If this flag
343: -- is set then orders will get inserted with booked_flag = 'N' to allow
344: -- Real Time CC to happen order by order.
345:

Line 349: IF OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED = 'N' THEN

345:
346: IF ( G_ORDER_TYPE_TBL(p_key).quick_cr_check_flag IS NULL OR
347: G_ORDER_TYPE_TBL(p_key).quick_cr_check_flag = 'N')
348: THEN
349: IF OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED = 'N' THEN
350: OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED := 'Y';
351: END IF;
352: END IF;
353: END IF;

Line 350: OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED := 'Y';

346: IF ( G_ORDER_TYPE_TBL(p_key).quick_cr_check_flag IS NULL OR
347: G_ORDER_TYPE_TBL(p_key).quick_cr_check_flag = 'N')
348: THEN
349: IF OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED = 'N' THEN
350: OE_BULK_ORDER_PVT.G_REALTIME_CC_REQUIRED := 'Y';
351: END IF;
352: END IF;
353: END IF;
354:

Line 605: l_key2 := OE_BULK_ORDER_PVT.G_ITEM_ORG;

601: RETURN p_key1;
602:
603: END IF;
604:
605: l_key2 := OE_BULK_ORDER_PVT.G_ITEM_ORG;
606:
607: IF p_key1 IS NOT NULL AND
608: NOT G_ITEM_TBL.EXISTS(p_key1) THEN
609:

Line 710: /* IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG = 'Y' THEN

706: AND kfv.ORGANIZATION_ID = l_key2;
707:
708: -- INVCONV start remove opm
709:
710: /* IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG = 'Y' THEN
711:
712: IF l_debug_level > 0 THEN
713: oe_debug_pub.add( 'PROCESS INSTALLED' ) ;
714: END IF;

Line 759: -- invconv IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG <> 'Y' THEN -- OPM HVOP added for error to test

755: IF l_debug_level > 0 THEN
756: oe_debug_pub.add( 'QUERYING BASED ON SHIP_FROM_ORG' , 3 ) ;
757: END IF;
758:
759: -- invconv IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG <> 'Y' THEN -- OPM HVOP added for error to test
760:
761: SELECT shippable_item_flag
762: ,organization_id
763: ,primary_uom_code

Line 852: /*IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG = 'Y' -- INVCONV take out

848: END IF;
849: G_ITEM_TBL.DELETE(p_key1);
850: END IF;
851:
852: /*IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG = 'Y' -- INVCONV take out
853: AND INV_GMI_RSV_BRANCH.Is_Org_Process_Org(p_key2) THEN
854: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
855: OE_BULK_MSG_PUB.add('Y','ERROR');
856: RAISE NO_DATA_FOUND;

Line 1011: p_org_id_in => OE_BULK_ORDER_PVT.G_ITEM_ORG,

1007: AND b.site_use_code='SHIP_TO';
1008:
1009: Get_Address
1010: (p_address_type_in => 'CUSTOMER',
1011: p_org_id_in => OE_BULK_ORDER_PVT.G_ITEM_ORG,
1012: p_address_id_in => G_SHIP_TO_TBL(MOD(p_key,G_BINARY_LIMIT)).address_id,
1013: p_tp_location_code_in => NULL,
1014: p_tp_translator_code_in => NULL,
1015: l_addr1 => G_SHIP_TO_TBL(MOD(p_key,G_BINARY_LIMIT)).address1,

Line 1487: p_org_id_in => OE_BULK_ORDER_PVT.G_ITEM_ORG,

1483: <>
1484:
1485: Get_Address
1486: (p_address_type_in => 'CUSTOMER',
1487: p_org_id_in => OE_BULK_ORDER_PVT.G_ITEM_ORG,
1488: p_address_id_in => G_SOLD_TO_SITE_TBL(MOD(p_key,G_BINARY_LIMIT)).address_id,
1489: p_tp_location_code_in => NULL,
1490: p_tp_translator_code_in => NULL,
1491: l_addr1 => G_SOLD_TO_SITE_TBL(MOD(p_key,G_BINARY_LIMIT)).address1,

Line 1640: p_org_id_in => OE_BULK_ORDER_PVT.G_ITEM_ORG,

1636: AND b.site_use_code='BILL_TO';
1637:
1638: Get_Address
1639: (p_address_type_in => 'CUSTOMER',
1640: p_org_id_in => OE_BULK_ORDER_PVT.G_ITEM_ORG,
1641: p_address_id_in => G_INVOICE_TO_TBL(MOD(p_key,G_BINARY_LIMIT)).address_id,
1642: p_tp_location_code_in => NULL,
1643: p_tp_translator_code_in => NULL,
1644: l_addr1 => G_INVOICE_TO_TBL(MOD(p_key,G_BINARY_LIMIT)).address1,

Line 1788: p_org_id_in => OE_BULK_ORDER_PVT.G_ITEM_ORG,

1784: AND b.site_use_code='SOLD_TO';
1785:
1786: Get_Address
1787: (p_address_type_in => 'CUSTOMER',
1788: p_org_id_in => OE_BULK_ORDER_PVT.G_ITEM_ORG,
1789: p_address_id_in => G_SOLD_TO_SITE_TBL(MOD(p_key,G_BINARY_LIMIT)).address_id,
1790: p_tp_location_code_in => NULL,
1791: p_tp_translator_code_in => NULL,
1792: l_addr1 => G_SOLD_TO_SITE_TBL(MOD(p_key,G_BINARY_LIMIT)).address1,

Line 1959: p_org_id_in => OE_BULK_ORDER_PVT.G_ITEM_ORG,

1955: END;
1956:
1957: Get_Address(
1958: p_address_type_in => 'HR_LOCATION',
1959: p_org_id_in => OE_BULK_ORDER_PVT.G_ITEM_ORG,
1960: p_address_id_in => l_addr_id,
1961: p_tp_location_code_in => NULL,
1962: p_tp_translator_code_in => NULL,
1963: l_addr1 => l_addr1,

Line 2223: AND V.SET_OF_BOOKS_ID = OE_BULK_ORDER_PVT.G_SOB_ID;

2219: BETWEEN trunc(V.START_DATE)
2220: AND NVL(trunc(V.END_DATE),trunc(p_tax_date))
2221: AND V.TAX_CLASS = 'O'
2222: AND NVL(V.ENABLED_FLAG,'Y') = 'Y'
2223: AND V.SET_OF_BOOKS_ID = OE_BULK_ORDER_PVT.G_SOB_ID;
2224:
2225: RETURN 1;
2226:
2227: END Load_Tax_Attributes;