APPS.AR_LOCVS_PKG dependencies on AR_LOCATION_VALUES_OLD

Line 59: cursor C is select ROWID from AR_LOCATION_VALUES_OLD

55: X_PROGRAM_UPDATE_DATE in DATE,
56: X_ORG_ID in NUMBER
57: ) is
58:
59: cursor C is select ROWID from AR_LOCATION_VALUES_OLD
60: where LOCATION_SEGMENT_ID = X_LOCATION_SEGMENT_ID;
61:
62: /*-------------------------------------------------------------------------+
63: | PRIVATE CURSOR |

Line 166: arp_util_tax.debug(' Before inserting into AR_LOCATION_VALUES_OLD ');

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
170: -- need to select org_id

Line 177: insert into AR_LOCATION_VALUES_OLD (

173: -- store online.
174:
175: -- MOAC
176: -- org_id is added
177: insert into AR_LOCATION_VALUES_OLD (
178: LOCATION_SEGMENT_ID,
179: LOCATION_STRUCTURE_ID,
180: LOCATION_SEGMENT_QUALIFIER,
181: LOCATION_SEGMENT_VALUE,

Line 247: arp_util_tax.debug(' After inserting into AR_LOCATION_VALUES_OLD ');

243: X_PROGRAM_UPDATE_DATE,
244: X_ORG_ID
245: );
246: IF PG_DEBUG = 'Y' THEN
247: arp_util_tax.debug(' After inserting into AR_LOCATION_VALUES_OLD ');
248: END IF;
249:
250: /* MOAC
251: Commented out as X_ORG_ID is passed from UI as part of the parameter.

Line 262: into AR_LOCATION_VALUES_OLD

258: /* +----------------------------------------------------------------------------------
259: Insert in AR_LOCATION_ACCOUNTS only if the TAX_ACCOUNT_CCID is not null
260: we could have the segment qualifier without TAX_ACCOUNT in which case no
261: records should be inserted in to this table though we will have to insert
262: into AR_LOCATION_VALUES_OLD
263: +-----------------------------------------------------------------------------------*/
264:
265:
266: if X_TAX_ACCOUNT_CCID is not null then

Line 577: FROM AR_LOCATION_VALUES_OLD

573: REQUEST_ID,
574: PROGRAM_APPLICATION_ID,
575: PROGRAM_ID,
576: PROGRAM_UPDATE_DATE
577: FROM AR_LOCATION_VALUES_OLD
578: WHERE LOCATION_SEGMENT_ID = X_LOCATION_SEGMENT_ID
579: -- MOAC
580: -- LOCATION_SEGMENT_ID is a unique key. No need for client info.
581: -- AND NVL(ORG_ID,NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',

Line 626: arp_util_tax.debug(' No record found for AR_LOCATION_VALUES_OLD ');

622: fetch c into recinfo;
623: if (c%notfound) then
624: close c;
625: IF PG_DEBUG = 'Y' THEN
626: arp_util_tax.debug(' No record found for AR_LOCATION_VALUES_OLD ');
627: END IF;
628: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
629: app_exception.raise_exception;
630: end if;

Line 803: arp_util_tax.debug(' Before updating AR_LOCATION_VALUES_OLD ');

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;
805: /* -- for bug #4561754
806: update AR_LOCATION_VALUES set
807: LOCATION_SEGMENT_ID = X_LOCATION_SEGMENT_ID,

Line 842: arp_util_tax.debug(' After updating AR_LOCATION_VALUES_OLD ');

838: PROGRAM_ID = X_PROGRAM_ID,
839: PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
840: where LOCATION_SEGMENT_ID = X_LOCATION_SEGMENT_ID;
841: IF PG_DEBUG = 'Y' THEN
842: arp_util_tax.debug(' After updating AR_LOCATION_VALUES_OLD ');
843: END IF;
844:
845: if (sql%notfound) then
846: IF PG_DEBUG = 'Y' THEN

Line 847: arp_util_tax.debug('updating AR_LOCATION_VALUES_OLD: No Data Found !! ');

843: END IF;
844:
845: if (sql%notfound) then
846: IF PG_DEBUG = 'Y' THEN
847: arp_util_tax.debug('updating AR_LOCATION_VALUES_OLD: No Data Found !! ');
848: END IF;
849: raise no_data_found;
850: end if;
851: */

Line 926: arp_util_tax.debug(' Before deleting AR_LOCATION_VALUES_OLD ');

922: end if;
923:
924: if X_LOCATION_SEGMENT_ID is not null then
925: IF PG_DEBUG = 'Y' THEN
926: arp_util_tax.debug(' Before deleting AR_LOCATION_VALUES_OLD ');
927: END IF;
928: DELETE FROM AR_LOCATION_VALUES_OLD
929: WHERE LOCATION_SEGMENT_ID = X_LOCATION_SEGMENT_ID;
930: IF PG_DEBUG = 'Y' THEN

Line 928: DELETE FROM AR_LOCATION_VALUES_OLD

924: if X_LOCATION_SEGMENT_ID is not null then
925: IF PG_DEBUG = 'Y' THEN
926: arp_util_tax.debug(' Before deleting AR_LOCATION_VALUES_OLD ');
927: END IF;
928: DELETE FROM AR_LOCATION_VALUES_OLD
929: WHERE LOCATION_SEGMENT_ID = X_LOCATION_SEGMENT_ID;
930: IF PG_DEBUG = 'Y' THEN
931: arp_util_tax.debug(' After deleting AR_LOCATION_VALUES_OLD ');
932: END IF;

Line 931: arp_util_tax.debug(' After deleting AR_LOCATION_VALUES_OLD ');

927: END IF;
928: DELETE FROM AR_LOCATION_VALUES_OLD
929: WHERE LOCATION_SEGMENT_ID = X_LOCATION_SEGMENT_ID;
930: IF PG_DEBUG = 'Y' THEN
931: arp_util_tax.debug(' After deleting AR_LOCATION_VALUES_OLD ');
932: END IF;
933: end if;
934:
935: if (sql%notfound) then