eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_BULK_TAX_UTIL dependencies on OE_BULK_CACHE

Line 637: l_order_type_cache_key := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(l_header_index));

633: --OE_Bulk_Order_PVT.G_LINE_REC.tax_calculation_flag(l_index) = 'Y'))
634: --bug7685103
635: THEN
636:
637: l_order_type_cache_key := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(l_header_index));
638:
639: IF l_debug_level > 0 THEN
640: oe_debug_pub.add( 'tax calculation event: ' || OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event);
641: oe_debug_pub.add( 'booked_flag: ' || nvl(OE_Bulk_Order_PVT.G_HEADER_REC.booked_flag(l_header_index), 'N'));

Line 640: oe_debug_pub.add( 'tax calculation event: ' || OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event);

636:
637: l_order_type_cache_key := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(l_header_index));
638:
639: IF l_debug_level > 0 THEN
640: oe_debug_pub.add( 'tax calculation event: ' || OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event);
641: oe_debug_pub.add( 'booked_flag: ' || nvl(OE_Bulk_Order_PVT.G_HEADER_REC.booked_flag(l_header_index), 'N'));
642: END IF;
643:
644: IF ((nvl(OE_Bulk_Order_PVT.G_HEADER_REC.booked_flag(l_header_index), 'N') = 'N' AND

Line 645: OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event = 'BOOKING')

641: oe_debug_pub.add( 'booked_flag: ' || nvl(OE_Bulk_Order_PVT.G_HEADER_REC.booked_flag(l_header_index), 'N'));
642: END IF;
643:
644: IF ((nvl(OE_Bulk_Order_PVT.G_HEADER_REC.booked_flag(l_header_index), 'N') = 'N' AND
645: OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event = 'BOOKING')
646: OR
647: (OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event NOT IN ('ENTERING', 'BOOKING')))
648: THEN
649: IF l_debug_level > 0 THEN

Line 647: (OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event NOT IN ('ENTERING', 'BOOKING')))

643:
644: IF ((nvl(OE_Bulk_Order_PVT.G_HEADER_REC.booked_flag(l_header_index), 'N') = 'N' AND
645: OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event = 'BOOKING')
646: OR
647: (OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event NOT IN ('ENTERING', 'BOOKING')))
648: THEN
649: IF l_debug_level > 0 THEN
650: oe_debug_pub.add( 'tax calculation event not set to ENTERING or BOOKING...OR....event is set to BOOKING but order is not booked. skipping header with header id: '|| l_header_id);
651: END IF;

Line 744: l_tax_code_cache_key := OE_Bulk_Cache.load_tax_attributes(OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index), OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index));

740: END IF;
741:
742: -- bug7685103 to avoid NO_DATA_FOUND exception
743: IF OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index) IS NOT NULL THEN
744: l_tax_code_cache_key := OE_Bulk_Cache.load_tax_attributes(OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index), OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index));
745:
746: IF l_debug_level > 0 THEN
747: oe_debug_pub.add('tax inclusive flag from cache:' || OE_BULK_CACHE.G_TAX_ATTRIBUTES_TBL(l_tax_code_cache_key).amount_includes_tax_flag);
748: END IF;

Line 747: oe_debug_pub.add('tax inclusive flag from cache:' || OE_BULK_CACHE.G_TAX_ATTRIBUTES_TBL(l_tax_code_cache_key).amount_includes_tax_flag);

743: IF OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index) IS NOT NULL THEN
744: l_tax_code_cache_key := OE_Bulk_Cache.load_tax_attributes(OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index), OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index));
745:
746: IF l_debug_level > 0 THEN
747: oe_debug_pub.add('tax inclusive flag from cache:' || OE_BULK_CACHE.G_TAX_ATTRIBUTES_TBL(l_tax_code_cache_key).amount_includes_tax_flag);
748: END IF;
749:
750: END IF;
751:

Line 756: l_salesrep_cache_key := OE_BULK_CACHE.Load_Salesrep(OE_Bulk_Order_PVT.G_LINE_REC.salesrep_id(l_index));

752:
753:
754: BEGIN
755:
756: l_salesrep_cache_key := OE_BULK_CACHE.Load_Salesrep(OE_Bulk_Order_PVT.G_LINE_REC.salesrep_id(l_index));
757: l_person_id := OE_BULK_CACHE.G_SALESREP_TBL(l_salesrep_cache_key).person_id;
758:
759: IF l_debug_level > 0 THEN
760: oe_debug_pub.add( 'Before Calling load_person: ' || l_person_id);

Line 757: l_person_id := OE_BULK_CACHE.G_SALESREP_TBL(l_salesrep_cache_key).person_id;

753:
754: BEGIN
755:
756: l_salesrep_cache_key := OE_BULK_CACHE.Load_Salesrep(OE_Bulk_Order_PVT.G_LINE_REC.salesrep_id(l_index));
757: l_person_id := OE_BULK_CACHE.G_SALESREP_TBL(l_salesrep_cache_key).person_id;
758:
759: IF l_debug_level > 0 THEN
760: oe_debug_pub.add( 'Before Calling load_person: ' || l_person_id);
761: oe_debug_pub.add( ' l_index :'|| l_index);

Line 765: l_asgn_org_id := OE_BULK_CACHE.Load_Person(l_person_id, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index));

761: oe_debug_pub.add( ' l_index :'|| l_index);
762: oe_debug_pub.add( ' Tax Date :'|| OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index));
763: END IF;
764:
765: l_asgn_org_id := OE_BULK_CACHE.Load_Person(l_person_id, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index));
766:
767: EXCEPTION
768: When others then
769: l_load_person_failed := true;

Line 779: l_asgn_org_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).ORGANIZATION_ID; -- the cache key is l_person_id only

775: IF l_load_person_failed THEN
776: l_asgn_org_id := null;
777: l_poo_location_id := NULL;
778: ELSE
779: l_asgn_org_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).ORGANIZATION_ID; -- the cache key is l_person_id only
780: l_poo_location_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).LOCATION_ID;
781: END IF;
782:
783: -- Legal Entity

Line 780: l_poo_location_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).LOCATION_ID;

776: l_asgn_org_id := null;
777: l_poo_location_id := NULL;
778: ELSE
779: l_asgn_org_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).ORGANIZATION_ID; -- the cache key is l_person_id only
780: l_poo_location_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).LOCATION_ID;
781: END IF;
782:
783: -- Legal Entity
784: oe_debug_pub.add( ' Ship from org id :'|| OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(l_index));

Line 807: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(l_index));

803: THEN
804: IF l_debug_level > 0 THEN
805: oe_debug_pub.add( 'retrieving ship_to info');
806: END IF;
807: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(l_index));
808: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
809: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
810: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
811: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;

Line 808: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;

804: IF l_debug_level > 0 THEN
805: oe_debug_pub.add( 'retrieving ship_to info');
806: END IF;
807: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(l_index));
808: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
809: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
810: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
811: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
812: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;

Line 809: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;

805: oe_debug_pub.add( 'retrieving ship_to info');
806: END IF;
807: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(l_index));
808: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
809: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
810: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
811: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
812: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
813: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;

Line 810: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;

806: END IF;
807: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(l_index));
808: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
809: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
810: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
811: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
812: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
813: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
814: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;

Line 811: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;

807: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(l_index));
808: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
809: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
810: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
811: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
812: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
813: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
814: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
815: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;

Line 812: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;

808: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
809: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
810: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
811: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
812: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
813: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
814: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
815: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
816: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;

Line 813: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;

809: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
810: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
811: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
812: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
813: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
814: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
815: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
816: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
817: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;

Line 814: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;

810: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
811: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
812: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
813: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
814: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
815: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
816: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
817: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
818: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;

Line 815: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;

811: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
812: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
813: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
814: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
815: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
816: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
817: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
818: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
819: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;

Line 816: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;

812: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
813: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
814: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
815: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
816: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
817: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
818: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
819: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
820: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;

Line 817: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;

813: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
814: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
815: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
816: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
817: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
818: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
819: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
820: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;
821: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;

Line 818: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;

814: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
815: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
816: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
817: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
818: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
819: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
820: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;
821: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;
822: END IF; -- end of if ship_to_org_id IS NOT NULL

Line 819: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;

815: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
816: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
817: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
818: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
819: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
820: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;
821: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;
822: END IF; -- end of if ship_to_org_id IS NOT NULL
823: oe_debug_pub.add( 'Ship to cache key :'|| l_ship_to_cache_key);

Line 820: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;

816: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
817: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
818: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
819: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
820: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;
821: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;
822: END IF; -- end of if ship_to_org_id IS NOT NULL
823: oe_debug_pub.add( 'Ship to cache key :'|| l_ship_to_cache_key);
824: oe_debug_pub.add( ' l_ship_party_id :'|| l_ship_party_id);

Line 821: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;

817: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
818: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
819: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
820: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;
821: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;
822: END IF; -- end of if ship_to_org_id IS NOT NULL
823: oe_debug_pub.add( 'Ship to cache key :'|| l_ship_to_cache_key);
824: oe_debug_pub.add( ' l_ship_party_id :'|| l_ship_party_id);
825: oe_debug_pub.add( ' l_ship_location_id :'|| l_ship_location_id);

Line 841: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index));

837: THEN
838: IF l_debug_level > 0 THEN
839: oe_debug_pub.add( 'retrieving bill_to info');
840: END IF;
841: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index));
842: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
843: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
844: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
845: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;

Line 842: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;

838: IF l_debug_level > 0 THEN
839: oe_debug_pub.add( 'retrieving bill_to info');
840: END IF;
841: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index));
842: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
843: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
844: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
845: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
846: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;

Line 843: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;

839: oe_debug_pub.add( 'retrieving bill_to info');
840: END IF;
841: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index));
842: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
843: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
844: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
845: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
846: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
847: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;

Line 844: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;

840: END IF;
841: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index));
842: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
843: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
844: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
845: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
846: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
847: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
848: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;

Line 845: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;

841: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(l_index));
842: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
843: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
844: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
845: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
846: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
847: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
848: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
849: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;

Line 846: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;

842: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
843: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
844: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
845: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
846: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
847: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
848: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
849: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
850: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;

Line 847: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;

843: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
844: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
845: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
846: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
847: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
848: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
849: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
850: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
851: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;

Line 848: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;

844: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
845: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
846: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
847: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
848: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
849: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
850: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
851: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
852: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;

Line 849: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;

845: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
846: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
847: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
848: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
849: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
850: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
851: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
852: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
853: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;

Line 850: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;

846: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
847: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
848: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
849: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
850: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
851: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
852: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
853: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
854: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;

Line 851: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;

847: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
848: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
849: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
850: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
851: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
852: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
853: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
854: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
855: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;

Line 852: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;

848: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
849: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
850: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
851: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
852: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
853: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
854: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
855: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;
856: END IF; --end of if invoice_to_org_id IS NOT NULL

Line 853: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;

849: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
850: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
851: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
852: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
853: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
854: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
855: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;
856: END IF; --end of if invoice_to_org_id IS NOT NULL
857:

Line 854: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;

850: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
851: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
852: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
853: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
854: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
855: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;
856: END IF; --end of if invoice_to_org_id IS NOT NULL
857:
858:

Line 855: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;

851: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
852: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
853: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
854: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
855: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;
856: END IF; --end of if invoice_to_org_id IS NOT NULL
857:
858:
859: l_legal_entity_id := get_le_id(p_order_type_id => OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(l_header_index)

Line 1761: l_order_type_cache_key := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(p_header_index));

1757: IF l_debug_level > 0 THEN
1758: oe_debug_pub.add( 'order was booked');
1759: END IF;
1760:
1761: l_order_type_cache_key := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(p_header_index));
1762: IF OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event IN ('ENTERING', 'BOOKING') THEN
1763:
1764: OE_BULK_MSG_PUB.Set_Msg_Context
1765: ( p_entity_code => 'HEADER'

Line 1762: IF OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event IN ('ENTERING', 'BOOKING') THEN

1758: oe_debug_pub.add( 'order was booked');
1759: END IF;
1760:
1761: l_order_type_cache_key := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(p_header_index));
1762: IF OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event IN ('ENTERING', 'BOOKING') THEN
1763:
1764: OE_BULK_MSG_PUB.Set_Msg_Context
1765: ( p_entity_code => 'HEADER'
1766: ,p_entity_id => OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index)