APPS.AR_LOCVS_PKG dependencies on AR_LOCVS_PKG

Line 1: PACKAGE BODY AR_LOCVS_PKG AS

1: PACKAGE BODY AR_LOCVS_PKG AS
2: /* $Header: ARLOCVSB.pls 120.5 2005/10/07 11:11:48 mparihar ship $ */
3:
4: -- MOAC
5: -- X_ORG_ID is added as new parameter

Line 165: arp_util_tax.debug(' AR_LOCVS_PKG.insert_row(+) ');

161: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
162: begin
163:
164: IF PG_DEBUG = 'Y' THEN
165: arp_util_tax.debug(' AR_LOCVS_PKG.insert_row(+) ');
166: arp_util_tax.debug(' Before inserting into AR_LOCATION_VALUES_OLD ');
167: END IF;
168:
169: -- MOAC

Line 172: -- which is the case where the ar_locvs_pkg is called from

168:
169: -- MOAC
170: -- need to select org_id
171: -- if x_org_id is null
172: -- which is the case where the ar_locvs_pkg is called from
173: -- store online.
174:
175: -- MOAC
176: -- org_id is added

Line 493: arp_util_tax.debug(' AR_LOCVS_PKG.insert_row(-) ');

489: end if;
490: close c;
491:
492: IF PG_DEBUG = 'Y' THEN
493: arp_util_tax.debug(' AR_LOCVS_PKG.insert_row(-) ');
494: END IF;
495:
496: end INSERT_ROW;
497:

Line 619: arp_util_tax.debug(' AR_LOCVS_PKG.lock_row(+) ');

615: acctinfo c1%rowtype;
616: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
617: begin
618: IF PG_DEBUG = 'Y' THEN
619: arp_util_tax.debug(' AR_LOCVS_PKG.lock_row(+) ');
620: END IF;
621: open c;
622: fetch c into recinfo;
623: if (c%notfound) then

Line 747: arp_util_tax.debug(' AR_LOCVS_PKG.lock_row(-) ');

743: end if;
744: end if; -- c1%notfound
745:
746: IF PG_DEBUG = 'Y' THEN
747: arp_util_tax.debug(' AR_LOCVS_PKG.lock_row(-) ');
748: END IF;
749: return;
750: end LOCK_ROW;
751:

Line 800: arp_util_tax.debug(' AR_LOCVS_PKG.update_row(+) ');

796: ) is
797: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
798: begin
799: IF PG_DEBUG = 'Y' THEN
800: arp_util_tax.debug(' AR_LOCVS_PKG.update_row(+) ');
801: END IF;
802: IF PG_DEBUG = 'Y' THEN
803: arp_util_tax.debug(' Before updating AR_LOCATION_VALUES_OLD ');
804: END IF;

Line 894: arp_util_tax.debug(' AR_LOCVS_PKG.update_row(-) ');

890: raise no_data_found;
891: end if;
892: */
893: IF PG_DEBUG = 'Y' THEN
894: arp_util_tax.debug(' AR_LOCVS_PKG.update_row(-) ');
895: END IF;
896: end UPDATE_ROW;
897:
898: procedure DELETE_ROW (

Line 906: arp_util_tax.debug(' AR_LOCVS_PKG.delete_row(+) ');

902: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
903: begin
904:
905: IF PG_DEBUG = 'Y' THEN
906: arp_util_tax.debug(' AR_LOCVS_PKG.delete_row(+) ');
907: END IF;
908: if X_LOCATION_VALUE_ACCOUNT_ID is not null then
909: IF PG_DEBUG = 'Y' THEN
910: arp_util_tax.debug(' Before deleting AR_LOCATION_ACCOUNTS ');

Line 940: arp_util_tax.debug(' AR_LOCVS_PKG.delete_row(-) ');

936: raise no_data_found;
937: end if;
938:
939: IF PG_DEBUG = 'Y' THEN
940: arp_util_tax.debug(' AR_LOCVS_PKG.delete_row(-) ');
941: END IF;
942: end DELETE_ROW;
943:
944: end AR_LOCVS_PKG;

Line 944: end AR_LOCVS_PKG;

940: arp_util_tax.debug(' AR_LOCVS_PKG.delete_row(-) ');
941: END IF;
942: end DELETE_ROW;
943:
944: end AR_LOCVS_PKG;