APPS.AR_LOCVS_PKG dependencies on FND_PROFILE

Line 161: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

157: organization_id_tab num_tab;
158: -- MOAC: X_ORG_ID is passed from UI.
159: -- X_ORG_ID NUMBER;
160:
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(+) ');

Line 616: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

612: WHERE LOCATION_VALUE_ACCOUNT_ID = X_LOCATION_VALUE_ACCOUNT_ID
613: FOR UPDATE OF LOCATION_VALUE_ACCOUNT_ID NOWAIT;
614:
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;

Line 797: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

793: X_PROGRAM_APPLICATION_ID in NUMBER,
794: X_PROGRAM_ID in NUMBER,
795: X_PROGRAM_UPDATE_DATE in DATE
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;

Line 902: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

898: procedure DELETE_ROW (
899: X_LOCATION_SEGMENT_ID in NUMBER,
900: X_LOCATION_VALUE_ACCOUNT_ID in NUMBER
901: ) is
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(+) ');