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 630: l_salesrep_cache_key := OE_BULK_CACHE.Load_Salesrep(OE_Bulk_Order_PVT.G_LINE_REC.salesrep_id(Entity_info_tbl(i).line_index));

626: l_header_index := Entity_info_tbl(i).header_index;
627: l_header_id := Entity_info_tbl(i).trx_id;
628: l_line_id := Entity_info_tbl(i).trx_line_id;
629: l_level := 'L';
630: l_salesrep_cache_key := OE_BULK_CACHE.Load_Salesrep(OE_Bulk_Order_PVT.G_LINE_REC.salesrep_id(Entity_info_tbl(i).line_index));
631: elsif Entity_info_tbl(i).trx_level_type = 'FREIGHT CHARGE' AND Entity_info_tbl(i).line_id IS NOT NULL THEN
632: oe_debug_pub.add( 'Processing Line charge for line : ' ||Entity_info_tbl(i).line_id);
633: oe_debug_pub.add( 'Processing charge: ' ||Entity_info_tbl(i).trx_line_id);
634: l_header_index := Entity_info_tbl(i).header_index;

Line 639: l_salesrep_cache_key := OE_BULK_CACHE.Load_Salesrep(OE_Bulk_Order_PVT.G_LINE_REC.salesrep_id(Entity_info_tbl(i).line_index));

635: l_header_id := Entity_info_tbl(i).trx_id;
636: l_line_id := Entity_info_tbl(i).line_id;
637: l_charge_id := Entity_info_tbl(i).trx_line_id;
638: l_level := 'LC';
639: l_salesrep_cache_key := OE_BULK_CACHE.Load_Salesrep(OE_Bulk_Order_PVT.G_LINE_REC.salesrep_id(Entity_info_tbl(i).line_index));
640: elsif Entity_info_tbl(i).trx_level_type = 'FREIGHT CHARGE' AND Entity_info_tbl(i).line_id IS NULL THEN
641: oe_debug_pub.add( 'Processing Header charge for Header : ' ||Entity_info_tbl(i).trx_id);
642: oe_debug_pub.add( 'Processing charge: ' ||Entity_info_tbl(i).trx_line_id);
643: l_header_index := Entity_info_tbl(i).header_index;

Line 648: l_salesrep_cache_key := OE_BULK_CACHE.Load_Salesrep(OE_Bulk_Order_PVT.G_HEADER_REC.salesrep_id(Entity_info_tbl(i).header_index));

644: l_header_id := Entity_info_tbl(i).trx_id;
645: l_line_id := NULL;
646: l_charge_id := Entity_info_tbl(i).trx_line_id;
647: l_level := 'HC';
648: l_salesrep_cache_key := OE_BULK_CACHE.Load_Salesrep(OE_Bulk_Order_PVT.G_HEADER_REC.salesrep_id(Entity_info_tbl(i).header_index));
649: END IF;
650: zx_global_structures_pkg.init_trx_line_dist_tbl(i);
651: IF NVL(OE_Bulk_Order_PVT.G_HEADER_REC.lock_control(l_header_index),0) = -99 THEN
652: IF l_debug_level > 0 THEN

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

672: IF l_level = 'L' THEN
673:
674: oe_debug_pub.add( 'Loading Line details in ZX global package');
675: BEGIN
676: l_person_id := OE_BULK_CACHE.G_SALESREP_TBL(l_salesrep_cache_key).person_id;
677: IF l_debug_level > 0 THEN
678: oe_debug_pub.add( 'Before Calling load_person: ' || l_person_id);
679: END IF;
680: l_asgn_org_id := OE_BULK_CACHE.Load_Person(l_person_id, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(Entity_info_tbl(i).line_index));

Line 680: l_asgn_org_id := OE_BULK_CACHE.Load_Person(l_person_id, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(Entity_info_tbl(i).line_index));

676: l_person_id := OE_BULK_CACHE.G_SALESREP_TBL(l_salesrep_cache_key).person_id;
677: IF l_debug_level > 0 THEN
678: oe_debug_pub.add( 'Before Calling load_person: ' || l_person_id);
679: END IF;
680: l_asgn_org_id := OE_BULK_CACHE.Load_Person(l_person_id, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(Entity_info_tbl(i).line_index));
681: EXCEPTION
682: WHEN OTHERS THEN
683: l_load_person_failed := true;
684: IF l_debug_level > 0 THEN

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

688: IF l_load_person_failed THEN
689: l_asgn_org_id := NULL;
690: l_poo_location_id := NULL;
691: ELSE
692: l_asgn_org_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).ORGANIZATION_ID; -- the cache key is l_person_id only
693: l_poo_location_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).LOCATION_ID;
694: END IF;
695: IF OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
696: IF l_debug_level > 0 THEN

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

689: l_asgn_org_id := NULL;
690: l_poo_location_id := NULL;
691: ELSE
692: l_asgn_org_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).ORGANIZATION_ID; -- the cache key is l_person_id only
693: l_poo_location_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).LOCATION_ID;
694: END IF;
695: IF OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
696: IF l_debug_level > 0 THEN
697: oe_debug_pub.add( 'retrieving bill_to info');

Line 701: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));

697: oe_debug_pub.add( 'retrieving bill_to info');
698: oe_debug_pub.add( 'Line index:'||Entity_info_tbl(i).line_index);
699: oe_debug_pub.add( 'Line index invoice to org:'||OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
700: END IF;
701: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
702: oe_debug_pub.add( 'After invoice line chache :'||l_invoice_to_cache_key);
703: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
704: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
705: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;

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

699: oe_debug_pub.add( 'Line index invoice to org:'||OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
700: END IF;
701: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
702: oe_debug_pub.add( 'After invoice line chache :'||l_invoice_to_cache_key);
703: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
704: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
705: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
706: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
707: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;

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

700: END IF;
701: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
702: oe_debug_pub.add( 'After invoice line chache :'||l_invoice_to_cache_key);
703: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
704: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
705: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
706: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
707: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
708: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;

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

701: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
702: oe_debug_pub.add( 'After invoice line chache :'||l_invoice_to_cache_key);
703: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
704: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
705: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
706: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
707: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
708: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
709: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;

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

702: oe_debug_pub.add( 'After invoice line chache :'||l_invoice_to_cache_key);
703: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
704: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
705: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
706: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
707: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
708: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
709: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
710: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;

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

703: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
704: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
705: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
706: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
707: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
708: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
709: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
710: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
711: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;

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

704: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
705: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
706: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
707: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
708: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
709: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
710: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
711: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
712: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;

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

705: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
706: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
707: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
708: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
709: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
710: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
711: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
712: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
713: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;

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

706: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
707: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
708: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
709: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
710: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
711: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
712: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
713: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
714: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;

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

707: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
708: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
709: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
710: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
711: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
712: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
713: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
714: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
715: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;

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

708: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
709: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
710: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
711: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
712: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
713: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
714: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
715: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
716: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;

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

709: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
710: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
711: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
712: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
713: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
714: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
715: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
716: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;
717: oe_debug_pub.add( 'before end if');

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

710: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
711: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
712: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
713: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
714: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
715: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
716: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;
717: oe_debug_pub.add( 'before end if');
718: END IF; --end of if invoice_to_org_id IS NOT NULL

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

711: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
712: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
713: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
714: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
715: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
716: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;
717: oe_debug_pub.add( 'before end if');
718: END IF; --end of if invoice_to_org_id IS NOT NULL
719: l_commitment_id := NVL(OE_Bulk_Order_PVT.G_LINE_REC.commitment_id(Entity_info_tbl(i).line_index),0);

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

712: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
713: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
714: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
715: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
716: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;
717: oe_debug_pub.add( 'before end if');
718: END IF; --end of if invoice_to_org_id IS NOT NULL
719: l_commitment_id := NVL(OE_Bulk_Order_PVT.G_LINE_REC.commitment_id(Entity_info_tbl(i).line_index),0);
720: IF l_commitment_id <> 0 THEN

Line 787: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index));

783: IF OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
784: IF l_debug_level > 0 THEN
785: oe_debug_pub.add( 'retrieving ship_to info');
786: END IF;
787: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index));
788: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
789: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
790: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
791: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;

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

784: IF l_debug_level > 0 THEN
785: oe_debug_pub.add( 'retrieving ship_to info');
786: END IF;
787: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index));
788: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
789: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
790: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
791: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
792: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;

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

785: oe_debug_pub.add( 'retrieving ship_to info');
786: END IF;
787: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index));
788: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
789: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
790: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
791: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
792: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
793: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;

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

786: END IF;
787: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index));
788: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
789: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
790: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
791: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
792: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
793: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
794: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;

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

787: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index));
788: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
789: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
790: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
791: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
792: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
793: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
794: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
795: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;

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

788: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
789: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
790: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
791: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
792: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
793: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
794: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
795: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
796: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;

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

789: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
790: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
791: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
792: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
793: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
794: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
795: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
796: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
797: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;

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

790: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
791: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
792: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
793: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
794: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
795: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
796: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
797: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
798: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;

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

791: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
792: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
793: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
794: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
795: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
796: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
797: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
798: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
799: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;

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

792: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
793: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
794: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
795: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
796: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
797: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
798: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
799: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
800: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;

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

793: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
794: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
795: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
796: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
797: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
798: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
799: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
800: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;
801: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;

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

794: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
795: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
796: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
797: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
798: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
799: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
800: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;
801: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;
802: END IF; -- end of if ship_to_org_id IS NOT NULL

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

795: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
796: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
797: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
798: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
799: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
800: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;
801: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;
802: END IF; -- end of if ship_to_org_id IS NOT NULL
803: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE(i) := 'LINE';

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

796: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
797: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
798: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
799: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
800: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;
801: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;
802: END IF; -- end of if ship_to_org_id IS NOT NULL
803: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE(i) := 'LINE';
804: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(i) := NVL(OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index),l_inventory_org_id);

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

797: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
798: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
799: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
800: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;
801: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;
802: END IF; -- end of if ship_to_org_id IS NOT NULL
803: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LEVEL_TYPE(i) := 'LINE';
804: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(i) := NVL(OE_Bulk_Order_PVT.G_Line_Rec.ship_from_org_id(Entity_info_tbl(i).line_index),l_inventory_org_id);
805: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(i) := OE_Bulk_Order_PVT.G_Line_Rec.ordered_quantity (Entity_info_tbl(i).line_index);

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

838: elsif l_level = 'LC' THEN
839: oe_debug_pub.add( 'Loading Line charge details in ZX global package');
840:
841: BEGIN
842: l_person_id := OE_BULK_CACHE.G_SALESREP_TBL(l_salesrep_cache_key).person_id;
843: IF l_debug_level > 0 THEN
844: oe_debug_pub.add( 'Before Calling load_person: ' || l_person_id);
845: END IF;
846: l_asgn_org_id := OE_BULK_CACHE.Load_Person(l_person_id, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(Entity_info_tbl(i).line_index));

Line 846: l_asgn_org_id := OE_BULK_CACHE.Load_Person(l_person_id, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(Entity_info_tbl(i).line_index));

842: l_person_id := OE_BULK_CACHE.G_SALESREP_TBL(l_salesrep_cache_key).person_id;
843: IF l_debug_level > 0 THEN
844: oe_debug_pub.add( 'Before Calling load_person: ' || l_person_id);
845: END IF;
846: l_asgn_org_id := OE_BULK_CACHE.Load_Person(l_person_id, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(Entity_info_tbl(i).line_index));
847: EXCEPTION
848: WHEN OTHERS THEN
849: l_load_person_failed := true;
850: IF l_debug_level > 0 THEN

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

854: IF l_load_person_failed THEN
855: l_asgn_org_id := NULL;
856: l_poo_location_id := NULL;
857: ELSE
858: l_asgn_org_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).ORGANIZATION_ID; -- the cache key is l_person_id only
859: l_poo_location_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).LOCATION_ID;
860: END IF;
861: IF OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
862: IF l_debug_level > 0 THEN

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

855: l_asgn_org_id := NULL;
856: l_poo_location_id := NULL;
857: ELSE
858: l_asgn_org_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).ORGANIZATION_ID; -- the cache key is l_person_id only
859: l_poo_location_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).LOCATION_ID;
860: END IF;
861: IF OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
862: IF l_debug_level > 0 THEN
863: oe_debug_pub.add( 'retrieving bill_to info');

Line 867: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));

863: oe_debug_pub.add( 'retrieving bill_to info');
864: oe_debug_pub.add( '2Line index:'||Entity_info_tbl(i).line_index);
865: oe_debug_pub.add( '2Line index invoice to org:'||OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
866: END IF;
867: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
868: oe_debug_pub.add( '2After invoice line chache :'||l_invoice_to_cache_key);
869: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
870: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
871: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;

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

865: oe_debug_pub.add( '2Line index invoice to org:'||OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
866: END IF;
867: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
868: oe_debug_pub.add( '2After invoice line chache :'||l_invoice_to_cache_key);
869: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
870: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
871: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
872: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
873: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;

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

866: END IF;
867: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
868: oe_debug_pub.add( '2After invoice line chache :'||l_invoice_to_cache_key);
869: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
870: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
871: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
872: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
873: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
874: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;

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

867: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.invoice_to_org_id(Entity_info_tbl(i).line_index));
868: oe_debug_pub.add( '2After invoice line chache :'||l_invoice_to_cache_key);
869: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
870: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
871: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
872: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
873: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
874: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
875: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;

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

868: oe_debug_pub.add( '2After invoice line chache :'||l_invoice_to_cache_key);
869: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
870: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
871: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
872: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
873: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
874: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
875: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
876: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;

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

869: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
870: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
871: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
872: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
873: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
874: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
875: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
876: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
877: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;

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

870: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
871: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
872: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
873: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
874: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
875: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
876: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
877: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
878: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;

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

871: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
872: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
873: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
874: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
875: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
876: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
877: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
878: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
879: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;

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

872: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
873: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
874: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
875: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
876: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
877: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
878: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
879: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
880: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;

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

873: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
874: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
875: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
876: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
877: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
878: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
879: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
880: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
881: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;

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

874: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
875: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
876: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
877: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
878: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
879: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
880: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
881: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
882: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;

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

875: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
876: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
877: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
878: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
879: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
880: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
881: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
882: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;
883: oe_debug_pub.add( '2 before end if');

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

876: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
877: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
878: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
879: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
880: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
881: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
882: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;
883: oe_debug_pub.add( '2 before end if');
884: END IF; --end of if invoice_to_org_id IS NOT NULL

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

877: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
878: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
879: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
880: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
881: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
882: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;
883: oe_debug_pub.add( '2 before end if');
884: END IF; --end of if invoice_to_org_id IS NOT NULL
885: l_commitment_id := NVL(OE_Bulk_Order_PVT.G_LINE_REC.commitment_id(Entity_info_tbl(i).line_index),0);

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

878: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
879: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
880: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
881: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
882: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;
883: oe_debug_pub.add( '2 before end if');
884: END IF; --end of if invoice_to_org_id IS NOT NULL
885: l_commitment_id := NVL(OE_Bulk_Order_PVT.G_LINE_REC.commitment_id(Entity_info_tbl(i).line_index),0);
886: IF l_commitment_id <> 0 THEN

Line 953: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index));

949: IF OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index) IS NOT NULL THEN
950: IF l_debug_level > 0 THEN
951: oe_debug_pub.add( 'retrieving ship_to info');
952: END IF;
953: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index));
954:
955: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
956: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
957: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;

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

951: oe_debug_pub.add( 'retrieving ship_to info');
952: END IF;
953: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index));
954:
955: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
956: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
957: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
958: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
959: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;

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

952: END IF;
953: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index));
954:
955: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
956: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
957: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
958: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
959: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
960: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;

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

953: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_LINE_REC.ship_to_org_id(Entity_info_tbl(i).line_index));
954:
955: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
956: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
957: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
958: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
959: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
960: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
961: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;

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

954:
955: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
956: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
957: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
958: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
959: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
960: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
961: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
962: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;

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

955: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
956: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
957: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
958: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
959: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
960: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
961: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
962: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
963: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;

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

956: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
957: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
958: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
959: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
960: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
961: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
962: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
963: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
964: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;

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

957: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
958: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
959: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
960: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
961: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
962: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
963: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
964: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
965: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;

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

958: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
959: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
960: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
961: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
962: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
963: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
964: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
965: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
966: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;

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

959: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
960: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
961: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
962: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
963: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
964: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
965: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
966: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
967: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;

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

960: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
961: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
962: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
963: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
964: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
965: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
966: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
967: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;
968: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;

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

961: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
962: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
963: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
964: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
965: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
966: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
967: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;
968: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;
969:

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

962: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
963: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
964: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
965: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
966: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
967: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;
968: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;
969:
970:

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

963: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
964: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
965: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
966: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
967: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;
968: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;
969:
970:
971:

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

964: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
965: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
966: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
967: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;
968: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;
969:
970:
971:
972:

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

1011:
1012: oe_debug_pub.add( 'Loading Header LEVEL charge details');
1013:
1014: BEGIN
1015: l_person_id := OE_BULK_CACHE.G_SALESREP_TBL(l_salesrep_cache_key).person_id;
1016: IF l_debug_level > 0 THEN
1017: oe_debug_pub.add( 'Before Calling load_person: ' || l_person_id);
1018: oe_debug_pub.add( ' l_index :'|| l_index);
1019: oe_debug_pub.add( ' Tax Date :'|| OE_Bulk_Order_PVT.G_LINE_REC.tax_date(i));

Line 1021: l_asgn_org_id := OE_BULK_CACHE.Load_Person(l_person_id, sysdate);

1017: oe_debug_pub.add( 'Before Calling load_person: ' || l_person_id);
1018: oe_debug_pub.add( ' l_index :'|| l_index);
1019: oe_debug_pub.add( ' Tax Date :'|| OE_Bulk_Order_PVT.G_LINE_REC.tax_date(i));
1020: END IF;
1021: l_asgn_org_id := OE_BULK_CACHE.Load_Person(l_person_id, sysdate);
1022: EXCEPTION
1023: WHEN OTHERS THEN
1024: l_load_person_failed := true;
1025: IF l_debug_level > 0 THEN

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

1029: IF l_load_person_failed THEN
1030: l_asgn_org_id := NULL;
1031: l_poo_location_id := NULL;
1032: ELSE
1033: l_asgn_org_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).ORGANIZATION_ID; -- the cache key is l_person_id only
1034: l_poo_location_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).LOCATION_ID;
1035: END IF;
1036: IF OE_Bulk_Order_PVT.G_HEADER_REC.invoice_to_org_id(Entity_info_tbl(i).header_index) IS NOT NULL THEN
1037: IF l_debug_level > 0 THEN

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

1030: l_asgn_org_id := NULL;
1031: l_poo_location_id := NULL;
1032: ELSE
1033: l_asgn_org_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).ORGANIZATION_ID; -- the cache key is l_person_id only
1034: l_poo_location_id := OE_BULK_CACHE.G_PERSON_TBL(l_person_id).LOCATION_ID;
1035: END IF;
1036: IF OE_Bulk_Order_PVT.G_HEADER_REC.invoice_to_org_id(Entity_info_tbl(i).header_index) IS NOT NULL THEN
1037: IF l_debug_level > 0 THEN
1038: oe_debug_pub.add( 'retrieving bill_to info');

Line 1042: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_header_REC.invoice_to_org_id(Entity_info_tbl(i).header_index));

1038: oe_debug_pub.add( 'retrieving bill_to info');
1039: oe_debug_pub.add( '3header index:'||Entity_info_tbl(i).header_index);
1040: oe_debug_pub.add( '3header index invoice to org:'||OE_Bulk_Order_PVT.G_header_REC.invoice_to_org_id(Entity_info_tbl(i).header_index));
1041: END IF;
1042: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_header_REC.invoice_to_org_id(Entity_info_tbl(i).header_index));
1043: oe_debug_pub.add( 'l_invoice_to_cache_key:' ||l_invoice_to_cache_key );
1044: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
1045: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
1046: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;

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

1040: oe_debug_pub.add( '3header index invoice to org:'||OE_Bulk_Order_PVT.G_header_REC.invoice_to_org_id(Entity_info_tbl(i).header_index));
1041: END IF;
1042: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_header_REC.invoice_to_org_id(Entity_info_tbl(i).header_index));
1043: oe_debug_pub.add( 'l_invoice_to_cache_key:' ||l_invoice_to_cache_key );
1044: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
1045: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
1046: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
1047: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
1048: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;

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

1041: END IF;
1042: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_header_REC.invoice_to_org_id(Entity_info_tbl(i).header_index));
1043: oe_debug_pub.add( 'l_invoice_to_cache_key:' ||l_invoice_to_cache_key );
1044: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
1045: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
1046: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
1047: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
1048: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
1049: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;

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

1042: l_invoice_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_header_REC.invoice_to_org_id(Entity_info_tbl(i).header_index));
1043: oe_debug_pub.add( 'l_invoice_to_cache_key:' ||l_invoice_to_cache_key );
1044: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
1045: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
1046: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
1047: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
1048: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
1049: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
1050: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;

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

1043: oe_debug_pub.add( 'l_invoice_to_cache_key:' ||l_invoice_to_cache_key );
1044: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
1045: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
1046: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
1047: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
1048: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
1049: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
1050: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
1051: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;

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

1044: l_bill_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
1045: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
1046: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
1047: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
1048: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
1049: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
1050: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
1051: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
1052: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;

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

1045: l_bill_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).POSTAL_CODE;
1046: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
1047: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
1048: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
1049: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
1050: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
1051: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
1052: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
1053: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;

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

1046: l_bill_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).LOC_ID;
1047: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
1048: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
1049: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
1050: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
1051: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
1052: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
1053: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
1054: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;

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

1047: l_bill_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).STATE;
1048: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
1049: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
1050: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
1051: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
1052: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
1053: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
1054: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
1055: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;

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

1048: l_bill_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCT_SITE_ID;
1049: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
1050: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
1051: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
1052: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
1053: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
1054: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
1055: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
1056: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;

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

1049: l_bill_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).CUST_ACCOUNT_ID;
1050: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
1051: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
1052: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
1053: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
1054: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
1055: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
1056: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
1057: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;

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

1050: l_bill_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCOUNT_NUMBER;
1051: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
1052: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
1053: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
1054: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
1055: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
1056: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
1057: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;
1058: oe_debug_pub.ADD('Before End if');

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

1051: l_bill_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_ID;
1052: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
1053: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
1054: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
1055: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
1056: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
1057: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;
1058: oe_debug_pub.ADD('Before End if');
1059: END IF; --end of if invoice_to_org_id IS NOT NULL

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

1052: l_bill_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_NAME;
1053: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
1054: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
1055: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
1056: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
1057: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;
1058: oe_debug_pub.ADD('Before End if');
1059: END IF; --end of if invoice_to_org_id IS NOT NULL
1060: BEGIN

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

1053: l_bill_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).PARTY_SITE_ID;
1054: l_bill_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_HEADER_LEVEL_FLAG;
1055: l_bill_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
1056: l_bill_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).TAX_ROUNDING_RULE;
1057: l_bill_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_invoice_to_cache_key).ACCT_TAX_ROUNDING_RULE;
1058: oe_debug_pub.ADD('Before End if');
1059: END IF; --end of if invoice_to_org_id IS NOT NULL
1060: BEGIN
1061: SELECT NVL (ot.cust_trx_type_id, 0)

Line 1110: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_HEADER_REC.ship_to_org_id(Entity_info_tbl(i).header_index));

1106: oe_debug_pub.add( ' Ship to Header:'||Entity_info_tbl(i).header_index);
1107: oe_debug_pub.add( ' ship to Line index invoice to org:'||OE_Bulk_Order_PVT.G_HEADER_REC.ship_to_org_id(Entity_info_tbl(i).header_index));
1108:
1109: END IF;
1110: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_HEADER_REC.ship_to_org_id(Entity_info_tbl(i).header_index));
1111: oe_debug_pub.add(' l_ship_to_cache_key:'||l_ship_to_cache_key);
1112: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
1113: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
1114: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;

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

1108:
1109: END IF;
1110: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_HEADER_REC.ship_to_org_id(Entity_info_tbl(i).header_index));
1111: oe_debug_pub.add(' l_ship_to_cache_key:'||l_ship_to_cache_key);
1112: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
1113: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
1114: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
1115: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
1116: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;

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

1109: END IF;
1110: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_HEADER_REC.ship_to_org_id(Entity_info_tbl(i).header_index));
1111: oe_debug_pub.add(' l_ship_to_cache_key:'||l_ship_to_cache_key);
1112: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
1113: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
1114: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
1115: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
1116: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
1117: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;

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

1110: l_ship_to_cache_key := OE_Bulk_Cache.load_loc_info(OE_Bulk_Order_PVT.G_HEADER_REC.ship_to_org_id(Entity_info_tbl(i).header_index));
1111: oe_debug_pub.add(' l_ship_to_cache_key:'||l_ship_to_cache_key);
1112: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
1113: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
1114: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
1115: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
1116: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
1117: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
1118: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;

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

1111: oe_debug_pub.add(' l_ship_to_cache_key:'||l_ship_to_cache_key);
1112: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
1113: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
1114: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
1115: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
1116: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
1117: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
1118: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
1119: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;

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

1112: l_ship_to_cust_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
1113: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
1114: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
1115: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
1116: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
1117: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
1118: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
1119: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
1120: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;

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

1113: l_ship_to_postal_code := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).POSTAL_CODE;
1114: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
1115: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
1116: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
1117: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
1118: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
1119: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
1120: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
1121: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;

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

1114: l_ship_location_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).LOC_ID;
1115: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
1116: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
1117: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
1118: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
1119: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
1120: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
1121: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
1122: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;

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

1115: l_ship_to_state := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).STATE;
1116: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
1117: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
1118: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
1119: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
1120: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
1121: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
1122: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
1123: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;

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

1116: l_ship_to_cust_acct_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCT_SITE_ID;
1117: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
1118: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
1119: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
1120: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
1121: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
1122: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
1123: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
1124: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;

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

1117: l_ship_to_cust_account_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).CUST_ACCOUNT_ID;
1118: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
1119: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
1120: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
1121: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
1122: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
1123: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
1124: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;
1125: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;

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

1118: l_ship_to_account_number := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCOUNT_NUMBER;
1119: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
1120: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
1121: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
1122: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
1123: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
1124: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;
1125: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;
1126: END IF; -- end of if ship_to_org_id IS NOT NULL

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

1119: l_ship_party_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_ID;
1120: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
1121: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
1122: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
1123: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
1124: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;
1125: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;
1126: END IF; -- end of if ship_to_org_id IS NOT NULL
1127: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(i) := NULL;

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

1120: l_ship_to_party_name := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_NAME;
1121: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
1122: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
1123: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
1124: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;
1125: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;
1126: END IF; -- end of if ship_to_org_id IS NOT NULL
1127: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(i) := NULL;
1128: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(i) := NULL;

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

1121: l_ship_party_site_id := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).PARTY_SITE_ID;
1122: l_ship_su_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_HEADER_LEVEL_FLAG;
1123: l_ship_acct_tax_hdr_flag := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_HEADER_LEVEL_FLAG;
1124: l_ship_to_su_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).TAX_ROUNDING_RULE;
1125: l_ship_to_acct_tax_rnd_rule := OE_BULK_CACHE.G_LOC_INFO_TBL(l_ship_to_cache_key).ACCT_TAX_ROUNDING_RULE;
1126: END IF; -- end of if ship_to_org_id IS NOT NULL
1127: zx_global_structures_pkg.trx_line_dist_tbl.PRODUCT_ORG_ID(i) := NULL;
1128: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_QUANTITY(i) := NULL;
1129: zx_global_structures_pkg.trx_line_dist_tbl.TRX_LINE_DESCRIPTION(i) := NULL;

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

1968: IF l_debug_level > 0 THEN
1969: oe_debug_pub.add( 'order was booked');
1970: END IF;
1971:
1972: l_order_type_cache_key := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(p_header_index));
1973: IF OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event IN ('ENTERING', 'BOOKING') THEN
1974:
1975: OE_BULK_MSG_PUB.Set_Msg_Context
1976: ( p_entity_code => 'HEADER'

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

1969: oe_debug_pub.add( 'order was booked');
1970: END IF;
1971:
1972: l_order_type_cache_key := OE_BULK_CACHE.Load_Order_Type(OE_Bulk_Order_PVT.G_HEADER_REC.order_type_id(p_header_index));
1973: IF OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_cache_key).tax_calculation_event IN ('ENTERING', 'BOOKING') THEN
1974:
1975: OE_BULK_MSG_PUB.Set_Msg_Context
1976: ( p_entity_code => 'HEADER'
1977: ,p_entity_id => OE_Bulk_Order_PVT.G_HEADER_REC.header_id(p_header_index)