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.PN_CAD_IMPORT dependencies on PN_ADDRESSES

Line 119: | statements to update pn_addresses_all. Bug #

115: | 4. Changed several messages
116: | 07-AUG-03 Kiran o Populated the Addresses %ROWTYPE variable
117: | before passing it to PNT_LOCATIONS_PKG.
118: | correct_update_row. Removd explicit update
119: | statements to update pn_addresses_all. Bug #
120: | 3079433. Changed 'IF' condition for calling
121: | validate_gross_area in 'COrrect' and 'Update'
122: | mode.
123: | 07-JAN-04 Daniel Thota o Added OUT param l_total_allocated_area_pct

Line 187: v_addr_rec PN_ADDRESSES%ROWTYPE;

183: l_last_update_date DATE;
184: l_location_id NUMBER;
185: l_loc_id NUMBER;
186: v_loc_rec PN_LOCATIONS%ROWTYPE;
187: v_addr_rec PN_ADDRESSES%ROWTYPE;
188: l_act_str_dt DATE;
189: l_pn_locations_rec PN_LOCATIONS_ALL%ROWTYPE;
190: l_pn_addresses_rec PN_ADDRESSES_ALL%ROWTYPE;
191: l_active_start_date DATE;

Line 190: l_pn_addresses_rec PN_ADDRESSES_ALL%ROWTYPE;

186: v_loc_rec PN_LOCATIONS%ROWTYPE;
187: v_addr_rec PN_ADDRESSES%ROWTYPE;
188: l_act_str_dt DATE;
189: l_pn_locations_rec PN_LOCATIONS_ALL%ROWTYPE;
190: l_pn_addresses_rec PN_ADDRESSES_ALL%ROWTYPE;
191: l_active_start_date DATE;
192: l_active_end_date DATE;
193: l_filename VARCHAR2(50) := 'IMPORT_'||to_char(sysdate,'DDMMYYYYHHMMSS');
194: l_org_id NUMBER;

Line 804: from pn_addresses_all

800:
801: BEGIN
802: select *
803: into v_addr_rec
804: from pn_addresses_all
805: where address_id = v_loc_rec.address_id;
806: l_address_id := v_addr_rec.address_id;
807: EXCEPTION
808: WHEN no_data_found THEN

Line 1105: l_pn_addresses_rec.ADDRESS_LINE1 := loc.address_line1;

1101: l_pn_locations_rec.source := loc.source;
1102:
1103: /* populate the address_rec */
1104:
1105: l_pn_addresses_rec.ADDRESS_LINE1 := loc.address_line1;
1106: l_pn_addresses_rec.ADDRESS_LINE2 := loc.address_line2;
1107: l_pn_addresses_rec.ADDRESS_LINE3 := loc.address_line3;
1108: l_pn_addresses_rec.ADDRESS_LINE4 := loc.address_line4;
1109: l_pn_addresses_rec.COUNTY := loc.county;

Line 1106: l_pn_addresses_rec.ADDRESS_LINE2 := loc.address_line2;

1102:
1103: /* populate the address_rec */
1104:
1105: l_pn_addresses_rec.ADDRESS_LINE1 := loc.address_line1;
1106: l_pn_addresses_rec.ADDRESS_LINE2 := loc.address_line2;
1107: l_pn_addresses_rec.ADDRESS_LINE3 := loc.address_line3;
1108: l_pn_addresses_rec.ADDRESS_LINE4 := loc.address_line4;
1109: l_pn_addresses_rec.COUNTY := loc.county;
1110: l_pn_addresses_rec.CITY := loc.city;

Line 1107: l_pn_addresses_rec.ADDRESS_LINE3 := loc.address_line3;

1103: /* populate the address_rec */
1104:
1105: l_pn_addresses_rec.ADDRESS_LINE1 := loc.address_line1;
1106: l_pn_addresses_rec.ADDRESS_LINE2 := loc.address_line2;
1107: l_pn_addresses_rec.ADDRESS_LINE3 := loc.address_line3;
1108: l_pn_addresses_rec.ADDRESS_LINE4 := loc.address_line4;
1109: l_pn_addresses_rec.COUNTY := loc.county;
1110: l_pn_addresses_rec.CITY := loc.city;
1111: l_pn_addresses_rec.STATE := loc.state;

Line 1108: l_pn_addresses_rec.ADDRESS_LINE4 := loc.address_line4;

1104:
1105: l_pn_addresses_rec.ADDRESS_LINE1 := loc.address_line1;
1106: l_pn_addresses_rec.ADDRESS_LINE2 := loc.address_line2;
1107: l_pn_addresses_rec.ADDRESS_LINE3 := loc.address_line3;
1108: l_pn_addresses_rec.ADDRESS_LINE4 := loc.address_line4;
1109: l_pn_addresses_rec.COUNTY := loc.county;
1110: l_pn_addresses_rec.CITY := loc.city;
1111: l_pn_addresses_rec.STATE := loc.state;
1112: l_pn_addresses_rec.PROVINCE := loc.province;

Line 1109: l_pn_addresses_rec.COUNTY := loc.county;

1105: l_pn_addresses_rec.ADDRESS_LINE1 := loc.address_line1;
1106: l_pn_addresses_rec.ADDRESS_LINE2 := loc.address_line2;
1107: l_pn_addresses_rec.ADDRESS_LINE3 := loc.address_line3;
1108: l_pn_addresses_rec.ADDRESS_LINE4 := loc.address_line4;
1109: l_pn_addresses_rec.COUNTY := loc.county;
1110: l_pn_addresses_rec.CITY := loc.city;
1111: l_pn_addresses_rec.STATE := loc.state;
1112: l_pn_addresses_rec.PROVINCE := loc.province;
1113: l_pn_addresses_rec.ZIP_CODE := loc.zip_code;

Line 1110: l_pn_addresses_rec.CITY := loc.city;

1106: l_pn_addresses_rec.ADDRESS_LINE2 := loc.address_line2;
1107: l_pn_addresses_rec.ADDRESS_LINE3 := loc.address_line3;
1108: l_pn_addresses_rec.ADDRESS_LINE4 := loc.address_line4;
1109: l_pn_addresses_rec.COUNTY := loc.county;
1110: l_pn_addresses_rec.CITY := loc.city;
1111: l_pn_addresses_rec.STATE := loc.state;
1112: l_pn_addresses_rec.PROVINCE := loc.province;
1113: l_pn_addresses_rec.ZIP_CODE := loc.zip_code;
1114: l_pn_addresses_rec.COUNTRY := loc.country;

Line 1111: l_pn_addresses_rec.STATE := loc.state;

1107: l_pn_addresses_rec.ADDRESS_LINE3 := loc.address_line3;
1108: l_pn_addresses_rec.ADDRESS_LINE4 := loc.address_line4;
1109: l_pn_addresses_rec.COUNTY := loc.county;
1110: l_pn_addresses_rec.CITY := loc.city;
1111: l_pn_addresses_rec.STATE := loc.state;
1112: l_pn_addresses_rec.PROVINCE := loc.province;
1113: l_pn_addresses_rec.ZIP_CODE := loc.zip_code;
1114: l_pn_addresses_rec.COUNTRY := loc.country;
1115: l_pn_addresses_rec.ADDRESS_STYLE := loc.address_style;

Line 1112: l_pn_addresses_rec.PROVINCE := loc.province;

1108: l_pn_addresses_rec.ADDRESS_LINE4 := loc.address_line4;
1109: l_pn_addresses_rec.COUNTY := loc.county;
1110: l_pn_addresses_rec.CITY := loc.city;
1111: l_pn_addresses_rec.STATE := loc.state;
1112: l_pn_addresses_rec.PROVINCE := loc.province;
1113: l_pn_addresses_rec.ZIP_CODE := loc.zip_code;
1114: l_pn_addresses_rec.COUNTRY := loc.country;
1115: l_pn_addresses_rec.ADDRESS_STYLE := loc.address_style;
1116: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;

Line 1113: l_pn_addresses_rec.ZIP_CODE := loc.zip_code;

1109: l_pn_addresses_rec.COUNTY := loc.county;
1110: l_pn_addresses_rec.CITY := loc.city;
1111: l_pn_addresses_rec.STATE := loc.state;
1112: l_pn_addresses_rec.PROVINCE := loc.province;
1113: l_pn_addresses_rec.ZIP_CODE := loc.zip_code;
1114: l_pn_addresses_rec.COUNTRY := loc.country;
1115: l_pn_addresses_rec.ADDRESS_STYLE := loc.address_style;
1116: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;
1117: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);

Line 1114: l_pn_addresses_rec.COUNTRY := loc.country;

1110: l_pn_addresses_rec.CITY := loc.city;
1111: l_pn_addresses_rec.STATE := loc.state;
1112: l_pn_addresses_rec.PROVINCE := loc.province;
1113: l_pn_addresses_rec.ZIP_CODE := loc.zip_code;
1114: l_pn_addresses_rec.COUNTRY := loc.country;
1115: l_pn_addresses_rec.ADDRESS_STYLE := loc.address_style;
1116: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;
1117: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);
1118: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);

Line 1115: l_pn_addresses_rec.ADDRESS_STYLE := loc.address_style;

1111: l_pn_addresses_rec.STATE := loc.state;
1112: l_pn_addresses_rec.PROVINCE := loc.province;
1113: l_pn_addresses_rec.ZIP_CODE := loc.zip_code;
1114: l_pn_addresses_rec.COUNTRY := loc.country;
1115: l_pn_addresses_rec.ADDRESS_STYLE := loc.address_style;
1116: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;
1117: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);
1118: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1119: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY := loc.addr_attribute_category;

Line 1116: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;

1112: l_pn_addresses_rec.PROVINCE := loc.province;
1113: l_pn_addresses_rec.ZIP_CODE := loc.zip_code;
1114: l_pn_addresses_rec.COUNTRY := loc.country;
1115: l_pn_addresses_rec.ADDRESS_STYLE := loc.address_style;
1116: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;
1117: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);
1118: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1119: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY := loc.addr_attribute_category;
1120: l_pn_addresses_rec.ADDR_ATTRIBUTE1 := loc.addr_attribute1;

Line 1117: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);

1113: l_pn_addresses_rec.ZIP_CODE := loc.zip_code;
1114: l_pn_addresses_rec.COUNTRY := loc.country;
1115: l_pn_addresses_rec.ADDRESS_STYLE := loc.address_style;
1116: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;
1117: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);
1118: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1119: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY := loc.addr_attribute_category;
1120: l_pn_addresses_rec.ADDR_ATTRIBUTE1 := loc.addr_attribute1;
1121: l_pn_addresses_rec.ADDR_ATTRIBUTE2 := loc.addr_attribute2;

Line 1118: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);

1114: l_pn_addresses_rec.COUNTRY := loc.country;
1115: l_pn_addresses_rec.ADDRESS_STYLE := loc.address_style;
1116: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;
1117: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);
1118: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1119: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY := loc.addr_attribute_category;
1120: l_pn_addresses_rec.ADDR_ATTRIBUTE1 := loc.addr_attribute1;
1121: l_pn_addresses_rec.ADDR_ATTRIBUTE2 := loc.addr_attribute2;
1122: l_pn_addresses_rec.ADDR_ATTRIBUTE3 := loc.addr_attribute3;

Line 1119: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY := loc.addr_attribute_category;

1115: l_pn_addresses_rec.ADDRESS_STYLE := loc.address_style;
1116: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;
1117: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);
1118: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1119: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY := loc.addr_attribute_category;
1120: l_pn_addresses_rec.ADDR_ATTRIBUTE1 := loc.addr_attribute1;
1121: l_pn_addresses_rec.ADDR_ATTRIBUTE2 := loc.addr_attribute2;
1122: l_pn_addresses_rec.ADDR_ATTRIBUTE3 := loc.addr_attribute3;
1123: l_pn_addresses_rec.ADDR_ATTRIBUTE4 := loc.addr_attribute4;

Line 1120: l_pn_addresses_rec.ADDR_ATTRIBUTE1 := loc.addr_attribute1;

1116: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;
1117: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);
1118: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1119: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY := loc.addr_attribute_category;
1120: l_pn_addresses_rec.ADDR_ATTRIBUTE1 := loc.addr_attribute1;
1121: l_pn_addresses_rec.ADDR_ATTRIBUTE2 := loc.addr_attribute2;
1122: l_pn_addresses_rec.ADDR_ATTRIBUTE3 := loc.addr_attribute3;
1123: l_pn_addresses_rec.ADDR_ATTRIBUTE4 := loc.addr_attribute4;
1124: l_pn_addresses_rec.ADDR_ATTRIBUTE5 := loc.addr_attribute5;

Line 1121: l_pn_addresses_rec.ADDR_ATTRIBUTE2 := loc.addr_attribute2;

1117: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);
1118: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1119: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY := loc.addr_attribute_category;
1120: l_pn_addresses_rec.ADDR_ATTRIBUTE1 := loc.addr_attribute1;
1121: l_pn_addresses_rec.ADDR_ATTRIBUTE2 := loc.addr_attribute2;
1122: l_pn_addresses_rec.ADDR_ATTRIBUTE3 := loc.addr_attribute3;
1123: l_pn_addresses_rec.ADDR_ATTRIBUTE4 := loc.addr_attribute4;
1124: l_pn_addresses_rec.ADDR_ATTRIBUTE5 := loc.addr_attribute5;
1125: l_pn_addresses_rec.ADDR_ATTRIBUTE6 := loc.addr_attribute6;

Line 1122: l_pn_addresses_rec.ADDR_ATTRIBUTE3 := loc.addr_attribute3;

1118: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1119: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY := loc.addr_attribute_category;
1120: l_pn_addresses_rec.ADDR_ATTRIBUTE1 := loc.addr_attribute1;
1121: l_pn_addresses_rec.ADDR_ATTRIBUTE2 := loc.addr_attribute2;
1122: l_pn_addresses_rec.ADDR_ATTRIBUTE3 := loc.addr_attribute3;
1123: l_pn_addresses_rec.ADDR_ATTRIBUTE4 := loc.addr_attribute4;
1124: l_pn_addresses_rec.ADDR_ATTRIBUTE5 := loc.addr_attribute5;
1125: l_pn_addresses_rec.ADDR_ATTRIBUTE6 := loc.addr_attribute6;
1126: l_pn_addresses_rec.ADDR_ATTRIBUTE7 := loc.addr_attribute7;

Line 1123: l_pn_addresses_rec.ADDR_ATTRIBUTE4 := loc.addr_attribute4;

1119: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY := loc.addr_attribute_category;
1120: l_pn_addresses_rec.ADDR_ATTRIBUTE1 := loc.addr_attribute1;
1121: l_pn_addresses_rec.ADDR_ATTRIBUTE2 := loc.addr_attribute2;
1122: l_pn_addresses_rec.ADDR_ATTRIBUTE3 := loc.addr_attribute3;
1123: l_pn_addresses_rec.ADDR_ATTRIBUTE4 := loc.addr_attribute4;
1124: l_pn_addresses_rec.ADDR_ATTRIBUTE5 := loc.addr_attribute5;
1125: l_pn_addresses_rec.ADDR_ATTRIBUTE6 := loc.addr_attribute6;
1126: l_pn_addresses_rec.ADDR_ATTRIBUTE7 := loc.addr_attribute7;
1127: l_pn_addresses_rec.ADDR_ATTRIBUTE8 := loc.addr_attribute8;

Line 1124: l_pn_addresses_rec.ADDR_ATTRIBUTE5 := loc.addr_attribute5;

1120: l_pn_addresses_rec.ADDR_ATTRIBUTE1 := loc.addr_attribute1;
1121: l_pn_addresses_rec.ADDR_ATTRIBUTE2 := loc.addr_attribute2;
1122: l_pn_addresses_rec.ADDR_ATTRIBUTE3 := loc.addr_attribute3;
1123: l_pn_addresses_rec.ADDR_ATTRIBUTE4 := loc.addr_attribute4;
1124: l_pn_addresses_rec.ADDR_ATTRIBUTE5 := loc.addr_attribute5;
1125: l_pn_addresses_rec.ADDR_ATTRIBUTE6 := loc.addr_attribute6;
1126: l_pn_addresses_rec.ADDR_ATTRIBUTE7 := loc.addr_attribute7;
1127: l_pn_addresses_rec.ADDR_ATTRIBUTE8 := loc.addr_attribute8;
1128: l_pn_addresses_rec.ADDR_ATTRIBUTE9 := loc.addr_attribute9;

Line 1125: l_pn_addresses_rec.ADDR_ATTRIBUTE6 := loc.addr_attribute6;

1121: l_pn_addresses_rec.ADDR_ATTRIBUTE2 := loc.addr_attribute2;
1122: l_pn_addresses_rec.ADDR_ATTRIBUTE3 := loc.addr_attribute3;
1123: l_pn_addresses_rec.ADDR_ATTRIBUTE4 := loc.addr_attribute4;
1124: l_pn_addresses_rec.ADDR_ATTRIBUTE5 := loc.addr_attribute5;
1125: l_pn_addresses_rec.ADDR_ATTRIBUTE6 := loc.addr_attribute6;
1126: l_pn_addresses_rec.ADDR_ATTRIBUTE7 := loc.addr_attribute7;
1127: l_pn_addresses_rec.ADDR_ATTRIBUTE8 := loc.addr_attribute8;
1128: l_pn_addresses_rec.ADDR_ATTRIBUTE9 := loc.addr_attribute9;
1129: l_pn_addresses_rec.ADDR_ATTRIBUTE10 := loc.addr_attribute10;

Line 1126: l_pn_addresses_rec.ADDR_ATTRIBUTE7 := loc.addr_attribute7;

1122: l_pn_addresses_rec.ADDR_ATTRIBUTE3 := loc.addr_attribute3;
1123: l_pn_addresses_rec.ADDR_ATTRIBUTE4 := loc.addr_attribute4;
1124: l_pn_addresses_rec.ADDR_ATTRIBUTE5 := loc.addr_attribute5;
1125: l_pn_addresses_rec.ADDR_ATTRIBUTE6 := loc.addr_attribute6;
1126: l_pn_addresses_rec.ADDR_ATTRIBUTE7 := loc.addr_attribute7;
1127: l_pn_addresses_rec.ADDR_ATTRIBUTE8 := loc.addr_attribute8;
1128: l_pn_addresses_rec.ADDR_ATTRIBUTE9 := loc.addr_attribute9;
1129: l_pn_addresses_rec.ADDR_ATTRIBUTE10 := loc.addr_attribute10;
1130: l_pn_addresses_rec.ADDR_ATTRIBUTE11 := loc.addr_attribute11;

Line 1127: l_pn_addresses_rec.ADDR_ATTRIBUTE8 := loc.addr_attribute8;

1123: l_pn_addresses_rec.ADDR_ATTRIBUTE4 := loc.addr_attribute4;
1124: l_pn_addresses_rec.ADDR_ATTRIBUTE5 := loc.addr_attribute5;
1125: l_pn_addresses_rec.ADDR_ATTRIBUTE6 := loc.addr_attribute6;
1126: l_pn_addresses_rec.ADDR_ATTRIBUTE7 := loc.addr_attribute7;
1127: l_pn_addresses_rec.ADDR_ATTRIBUTE8 := loc.addr_attribute8;
1128: l_pn_addresses_rec.ADDR_ATTRIBUTE9 := loc.addr_attribute9;
1129: l_pn_addresses_rec.ADDR_ATTRIBUTE10 := loc.addr_attribute10;
1130: l_pn_addresses_rec.ADDR_ATTRIBUTE11 := loc.addr_attribute11;
1131: l_pn_addresses_rec.ADDR_ATTRIBUTE12 := loc.addr_attribute12;

Line 1128: l_pn_addresses_rec.ADDR_ATTRIBUTE9 := loc.addr_attribute9;

1124: l_pn_addresses_rec.ADDR_ATTRIBUTE5 := loc.addr_attribute5;
1125: l_pn_addresses_rec.ADDR_ATTRIBUTE6 := loc.addr_attribute6;
1126: l_pn_addresses_rec.ADDR_ATTRIBUTE7 := loc.addr_attribute7;
1127: l_pn_addresses_rec.ADDR_ATTRIBUTE8 := loc.addr_attribute8;
1128: l_pn_addresses_rec.ADDR_ATTRIBUTE9 := loc.addr_attribute9;
1129: l_pn_addresses_rec.ADDR_ATTRIBUTE10 := loc.addr_attribute10;
1130: l_pn_addresses_rec.ADDR_ATTRIBUTE11 := loc.addr_attribute11;
1131: l_pn_addresses_rec.ADDR_ATTRIBUTE12 := loc.addr_attribute12;
1132: l_pn_addresses_rec.ADDR_ATTRIBUTE13 := loc.addr_attribute13;

Line 1129: l_pn_addresses_rec.ADDR_ATTRIBUTE10 := loc.addr_attribute10;

1125: l_pn_addresses_rec.ADDR_ATTRIBUTE6 := loc.addr_attribute6;
1126: l_pn_addresses_rec.ADDR_ATTRIBUTE7 := loc.addr_attribute7;
1127: l_pn_addresses_rec.ADDR_ATTRIBUTE8 := loc.addr_attribute8;
1128: l_pn_addresses_rec.ADDR_ATTRIBUTE9 := loc.addr_attribute9;
1129: l_pn_addresses_rec.ADDR_ATTRIBUTE10 := loc.addr_attribute10;
1130: l_pn_addresses_rec.ADDR_ATTRIBUTE11 := loc.addr_attribute11;
1131: l_pn_addresses_rec.ADDR_ATTRIBUTE12 := loc.addr_attribute12;
1132: l_pn_addresses_rec.ADDR_ATTRIBUTE13 := loc.addr_attribute13;
1133: l_pn_addresses_rec.ADDR_ATTRIBUTE14 := loc.addr_attribute14;

Line 1130: l_pn_addresses_rec.ADDR_ATTRIBUTE11 := loc.addr_attribute11;

1126: l_pn_addresses_rec.ADDR_ATTRIBUTE7 := loc.addr_attribute7;
1127: l_pn_addresses_rec.ADDR_ATTRIBUTE8 := loc.addr_attribute8;
1128: l_pn_addresses_rec.ADDR_ATTRIBUTE9 := loc.addr_attribute9;
1129: l_pn_addresses_rec.ADDR_ATTRIBUTE10 := loc.addr_attribute10;
1130: l_pn_addresses_rec.ADDR_ATTRIBUTE11 := loc.addr_attribute11;
1131: l_pn_addresses_rec.ADDR_ATTRIBUTE12 := loc.addr_attribute12;
1132: l_pn_addresses_rec.ADDR_ATTRIBUTE13 := loc.addr_attribute13;
1133: l_pn_addresses_rec.ADDR_ATTRIBUTE14 := loc.addr_attribute14;
1134: l_pn_addresses_rec.ADDR_ATTRIBUTE15 := loc.addr_attribute15;

Line 1131: l_pn_addresses_rec.ADDR_ATTRIBUTE12 := loc.addr_attribute12;

1127: l_pn_addresses_rec.ADDR_ATTRIBUTE8 := loc.addr_attribute8;
1128: l_pn_addresses_rec.ADDR_ATTRIBUTE9 := loc.addr_attribute9;
1129: l_pn_addresses_rec.ADDR_ATTRIBUTE10 := loc.addr_attribute10;
1130: l_pn_addresses_rec.ADDR_ATTRIBUTE11 := loc.addr_attribute11;
1131: l_pn_addresses_rec.ADDR_ATTRIBUTE12 := loc.addr_attribute12;
1132: l_pn_addresses_rec.ADDR_ATTRIBUTE13 := loc.addr_attribute13;
1133: l_pn_addresses_rec.ADDR_ATTRIBUTE14 := loc.addr_attribute14;
1134: l_pn_addresses_rec.ADDR_ATTRIBUTE15 := loc.addr_attribute15;
1135:

Line 1132: l_pn_addresses_rec.ADDR_ATTRIBUTE13 := loc.addr_attribute13;

1128: l_pn_addresses_rec.ADDR_ATTRIBUTE9 := loc.addr_attribute9;
1129: l_pn_addresses_rec.ADDR_ATTRIBUTE10 := loc.addr_attribute10;
1130: l_pn_addresses_rec.ADDR_ATTRIBUTE11 := loc.addr_attribute11;
1131: l_pn_addresses_rec.ADDR_ATTRIBUTE12 := loc.addr_attribute12;
1132: l_pn_addresses_rec.ADDR_ATTRIBUTE13 := loc.addr_attribute13;
1133: l_pn_addresses_rec.ADDR_ATTRIBUTE14 := loc.addr_attribute14;
1134: l_pn_addresses_rec.ADDR_ATTRIBUTE15 := loc.addr_attribute15;
1135:
1136: put_log( 'U: Just before Correct/Update');

Line 1133: l_pn_addresses_rec.ADDR_ATTRIBUTE14 := loc.addr_attribute14;

1129: l_pn_addresses_rec.ADDR_ATTRIBUTE10 := loc.addr_attribute10;
1130: l_pn_addresses_rec.ADDR_ATTRIBUTE11 := loc.addr_attribute11;
1131: l_pn_addresses_rec.ADDR_ATTRIBUTE12 := loc.addr_attribute12;
1132: l_pn_addresses_rec.ADDR_ATTRIBUTE13 := loc.addr_attribute13;
1133: l_pn_addresses_rec.ADDR_ATTRIBUTE14 := loc.addr_attribute14;
1134: l_pn_addresses_rec.ADDR_ATTRIBUTE15 := loc.addr_attribute15;
1135:
1136: put_log( 'U: Just before Correct/Update');
1137:

Line 1134: l_pn_addresses_rec.ADDR_ATTRIBUTE15 := loc.addr_attribute15;

1130: l_pn_addresses_rec.ADDR_ATTRIBUTE11 := loc.addr_attribute11;
1131: l_pn_addresses_rec.ADDR_ATTRIBUTE12 := loc.addr_attribute12;
1132: l_pn_addresses_rec.ADDR_ATTRIBUTE13 := loc.addr_attribute13;
1133: l_pn_addresses_rec.ADDR_ATTRIBUTE14 := loc.addr_attribute14;
1134: l_pn_addresses_rec.ADDR_ATTRIBUTE15 := loc.addr_attribute15;
1135:
1136: put_log( 'U: Just before Correct/Update');
1137:
1138: --Used trunc() :Bug 6009957

Line 1141: p_pn_addresses_rec => l_pn_addresses_rec,

1137:
1138: --Used trunc() :Bug 6009957
1139: PNT_LOCATIONS_PKG.correct_update_row
1140: ( p_pn_locations_rec => l_pn_locations_rec,
1141: p_pn_addresses_rec => l_pn_addresses_rec,
1142: p_change_mode => nvl(loc.change_mode, 'CORRECT'),
1143: p_as_of_date => loc.change_date,
1144: p_active_start_date_old => trunc(loc.active_start_date),
1145: p_active_end_date_old => trunc(v_loc_rec.active_end_date),

Line 1246: l_pn_addresses_rec.ADDRESS_LINE1 := nvl( loc.address_line1, v_addr_rec.address_line1);

1242: trunc(nvl(loc.new_active_end_date,v_loc_rec.active_end_date)); --Used trunc() :Bug 6009957
1243: l_pn_locations_rec .address_id := nvl(v_loc_rec.address_id,l_Address_id);
1244: l_pn_locations_rec.source := nvl(loc.source,v_loc_rec.source);
1245:
1246: l_pn_addresses_rec.ADDRESS_LINE1 := nvl( loc.address_line1, v_addr_rec.address_line1);
1247: l_pn_addresses_rec.ADDRESS_LINE2 := nvl( loc.address_line2, v_addr_rec.address_line2);
1248: l_pn_addresses_rec.ADDRESS_LINE3 := nvl( loc.address_line3, v_addr_rec.address_line3);
1249: l_pn_addresses_rec.ADDRESS_LINE4 := nvl( loc.address_line4, v_addr_rec.address_line4);
1250: l_pn_addresses_rec.COUNTY := nvl( loc.county, v_addr_rec.county);

Line 1247: l_pn_addresses_rec.ADDRESS_LINE2 := nvl( loc.address_line2, v_addr_rec.address_line2);

1243: l_pn_locations_rec .address_id := nvl(v_loc_rec.address_id,l_Address_id);
1244: l_pn_locations_rec.source := nvl(loc.source,v_loc_rec.source);
1245:
1246: l_pn_addresses_rec.ADDRESS_LINE1 := nvl( loc.address_line1, v_addr_rec.address_line1);
1247: l_pn_addresses_rec.ADDRESS_LINE2 := nvl( loc.address_line2, v_addr_rec.address_line2);
1248: l_pn_addresses_rec.ADDRESS_LINE3 := nvl( loc.address_line3, v_addr_rec.address_line3);
1249: l_pn_addresses_rec.ADDRESS_LINE4 := nvl( loc.address_line4, v_addr_rec.address_line4);
1250: l_pn_addresses_rec.COUNTY := nvl( loc.county, v_addr_rec.county);
1251: l_pn_addresses_rec.CITY := nvl( loc.city, v_addr_rec.city);

Line 1248: l_pn_addresses_rec.ADDRESS_LINE3 := nvl( loc.address_line3, v_addr_rec.address_line3);

1244: l_pn_locations_rec.source := nvl(loc.source,v_loc_rec.source);
1245:
1246: l_pn_addresses_rec.ADDRESS_LINE1 := nvl( loc.address_line1, v_addr_rec.address_line1);
1247: l_pn_addresses_rec.ADDRESS_LINE2 := nvl( loc.address_line2, v_addr_rec.address_line2);
1248: l_pn_addresses_rec.ADDRESS_LINE3 := nvl( loc.address_line3, v_addr_rec.address_line3);
1249: l_pn_addresses_rec.ADDRESS_LINE4 := nvl( loc.address_line4, v_addr_rec.address_line4);
1250: l_pn_addresses_rec.COUNTY := nvl( loc.county, v_addr_rec.county);
1251: l_pn_addresses_rec.CITY := nvl( loc.city, v_addr_rec.city);
1252: l_pn_addresses_rec.STATE := nvl( loc.state, v_addr_rec.state);

Line 1249: l_pn_addresses_rec.ADDRESS_LINE4 := nvl( loc.address_line4, v_addr_rec.address_line4);

1245:
1246: l_pn_addresses_rec.ADDRESS_LINE1 := nvl( loc.address_line1, v_addr_rec.address_line1);
1247: l_pn_addresses_rec.ADDRESS_LINE2 := nvl( loc.address_line2, v_addr_rec.address_line2);
1248: l_pn_addresses_rec.ADDRESS_LINE3 := nvl( loc.address_line3, v_addr_rec.address_line3);
1249: l_pn_addresses_rec.ADDRESS_LINE4 := nvl( loc.address_line4, v_addr_rec.address_line4);
1250: l_pn_addresses_rec.COUNTY := nvl( loc.county, v_addr_rec.county);
1251: l_pn_addresses_rec.CITY := nvl( loc.city, v_addr_rec.city);
1252: l_pn_addresses_rec.STATE := nvl( loc.state, v_addr_rec.state);
1253: l_pn_addresses_rec.PROVINCE := nvl( loc.province, v_addr_rec.province);

Line 1250: l_pn_addresses_rec.COUNTY := nvl( loc.county, v_addr_rec.county);

1246: l_pn_addresses_rec.ADDRESS_LINE1 := nvl( loc.address_line1, v_addr_rec.address_line1);
1247: l_pn_addresses_rec.ADDRESS_LINE2 := nvl( loc.address_line2, v_addr_rec.address_line2);
1248: l_pn_addresses_rec.ADDRESS_LINE3 := nvl( loc.address_line3, v_addr_rec.address_line3);
1249: l_pn_addresses_rec.ADDRESS_LINE4 := nvl( loc.address_line4, v_addr_rec.address_line4);
1250: l_pn_addresses_rec.COUNTY := nvl( loc.county, v_addr_rec.county);
1251: l_pn_addresses_rec.CITY := nvl( loc.city, v_addr_rec.city);
1252: l_pn_addresses_rec.STATE := nvl( loc.state, v_addr_rec.state);
1253: l_pn_addresses_rec.PROVINCE := nvl( loc.province, v_addr_rec.province);
1254: l_pn_addresses_rec.ZIP_CODE := nvl( loc.zip_code, v_addr_rec.zip_code);

Line 1251: l_pn_addresses_rec.CITY := nvl( loc.city, v_addr_rec.city);

1247: l_pn_addresses_rec.ADDRESS_LINE2 := nvl( loc.address_line2, v_addr_rec.address_line2);
1248: l_pn_addresses_rec.ADDRESS_LINE3 := nvl( loc.address_line3, v_addr_rec.address_line3);
1249: l_pn_addresses_rec.ADDRESS_LINE4 := nvl( loc.address_line4, v_addr_rec.address_line4);
1250: l_pn_addresses_rec.COUNTY := nvl( loc.county, v_addr_rec.county);
1251: l_pn_addresses_rec.CITY := nvl( loc.city, v_addr_rec.city);
1252: l_pn_addresses_rec.STATE := nvl( loc.state, v_addr_rec.state);
1253: l_pn_addresses_rec.PROVINCE := nvl( loc.province, v_addr_rec.province);
1254: l_pn_addresses_rec.ZIP_CODE := nvl( loc.zip_code, v_addr_rec.zip_code);
1255: l_pn_addresses_rec.COUNTRY := nvl( loc.country, v_addr_rec.country);

Line 1252: l_pn_addresses_rec.STATE := nvl( loc.state, v_addr_rec.state);

1248: l_pn_addresses_rec.ADDRESS_LINE3 := nvl( loc.address_line3, v_addr_rec.address_line3);
1249: l_pn_addresses_rec.ADDRESS_LINE4 := nvl( loc.address_line4, v_addr_rec.address_line4);
1250: l_pn_addresses_rec.COUNTY := nvl( loc.county, v_addr_rec.county);
1251: l_pn_addresses_rec.CITY := nvl( loc.city, v_addr_rec.city);
1252: l_pn_addresses_rec.STATE := nvl( loc.state, v_addr_rec.state);
1253: l_pn_addresses_rec.PROVINCE := nvl( loc.province, v_addr_rec.province);
1254: l_pn_addresses_rec.ZIP_CODE := nvl( loc.zip_code, v_addr_rec.zip_code);
1255: l_pn_addresses_rec.COUNTRY := nvl( loc.country, v_addr_rec.country);
1256: l_pn_addresses_rec.ADDRESS_STYLE := nvl( loc.address_style, v_addr_rec.address_style);

Line 1253: l_pn_addresses_rec.PROVINCE := nvl( loc.province, v_addr_rec.province);

1249: l_pn_addresses_rec.ADDRESS_LINE4 := nvl( loc.address_line4, v_addr_rec.address_line4);
1250: l_pn_addresses_rec.COUNTY := nvl( loc.county, v_addr_rec.county);
1251: l_pn_addresses_rec.CITY := nvl( loc.city, v_addr_rec.city);
1252: l_pn_addresses_rec.STATE := nvl( loc.state, v_addr_rec.state);
1253: l_pn_addresses_rec.PROVINCE := nvl( loc.province, v_addr_rec.province);
1254: l_pn_addresses_rec.ZIP_CODE := nvl( loc.zip_code, v_addr_rec.zip_code);
1255: l_pn_addresses_rec.COUNTRY := nvl( loc.country, v_addr_rec.country);
1256: l_pn_addresses_rec.ADDRESS_STYLE := nvl( loc.address_style, v_addr_rec.address_style);
1257: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;

Line 1254: l_pn_addresses_rec.ZIP_CODE := nvl( loc.zip_code, v_addr_rec.zip_code);

1250: l_pn_addresses_rec.COUNTY := nvl( loc.county, v_addr_rec.county);
1251: l_pn_addresses_rec.CITY := nvl( loc.city, v_addr_rec.city);
1252: l_pn_addresses_rec.STATE := nvl( loc.state, v_addr_rec.state);
1253: l_pn_addresses_rec.PROVINCE := nvl( loc.province, v_addr_rec.province);
1254: l_pn_addresses_rec.ZIP_CODE := nvl( loc.zip_code, v_addr_rec.zip_code);
1255: l_pn_addresses_rec.COUNTRY := nvl( loc.country, v_addr_rec.country);
1256: l_pn_addresses_rec.ADDRESS_STYLE := nvl( loc.address_style, v_addr_rec.address_style);
1257: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;
1258: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);

Line 1255: l_pn_addresses_rec.COUNTRY := nvl( loc.country, v_addr_rec.country);

1251: l_pn_addresses_rec.CITY := nvl( loc.city, v_addr_rec.city);
1252: l_pn_addresses_rec.STATE := nvl( loc.state, v_addr_rec.state);
1253: l_pn_addresses_rec.PROVINCE := nvl( loc.province, v_addr_rec.province);
1254: l_pn_addresses_rec.ZIP_CODE := nvl( loc.zip_code, v_addr_rec.zip_code);
1255: l_pn_addresses_rec.COUNTRY := nvl( loc.country, v_addr_rec.country);
1256: l_pn_addresses_rec.ADDRESS_STYLE := nvl( loc.address_style, v_addr_rec.address_style);
1257: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;
1258: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);
1259: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);

Line 1256: l_pn_addresses_rec.ADDRESS_STYLE := nvl( loc.address_style, v_addr_rec.address_style);

1252: l_pn_addresses_rec.STATE := nvl( loc.state, v_addr_rec.state);
1253: l_pn_addresses_rec.PROVINCE := nvl( loc.province, v_addr_rec.province);
1254: l_pn_addresses_rec.ZIP_CODE := nvl( loc.zip_code, v_addr_rec.zip_code);
1255: l_pn_addresses_rec.COUNTRY := nvl( loc.country, v_addr_rec.country);
1256: l_pn_addresses_rec.ADDRESS_STYLE := nvl( loc.address_style, v_addr_rec.address_style);
1257: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;
1258: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);
1259: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1260: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY

Line 1257: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;

1253: l_pn_addresses_rec.PROVINCE := nvl( loc.province, v_addr_rec.province);
1254: l_pn_addresses_rec.ZIP_CODE := nvl( loc.zip_code, v_addr_rec.zip_code);
1255: l_pn_addresses_rec.COUNTRY := nvl( loc.country, v_addr_rec.country);
1256: l_pn_addresses_rec.ADDRESS_STYLE := nvl( loc.address_style, v_addr_rec.address_style);
1257: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;
1258: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);
1259: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1260: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY
1261: := nvl(loc.addr_attribute_category,

Line 1258: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);

1254: l_pn_addresses_rec.ZIP_CODE := nvl( loc.zip_code, v_addr_rec.zip_code);
1255: l_pn_addresses_rec.COUNTRY := nvl( loc.country, v_addr_rec.country);
1256: l_pn_addresses_rec.ADDRESS_STYLE := nvl( loc.address_style, v_addr_rec.address_style);
1257: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;
1258: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);
1259: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1260: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY
1261: := nvl(loc.addr_attribute_category,
1262: v_addr_rec.addr_attribute_category);

Line 1259: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);

1255: l_pn_addresses_rec.COUNTRY := nvl( loc.country, v_addr_rec.country);
1256: l_pn_addresses_rec.ADDRESS_STYLE := nvl( loc.address_style, v_addr_rec.address_style);
1257: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;
1258: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);
1259: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1260: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY
1261: := nvl(loc.addr_attribute_category,
1262: v_addr_rec.addr_attribute_category);
1263: l_pn_addresses_rec.ADDR_ATTRIBUTE1 := nvl(loc.addr_attribute1,v_addr_rec.addr_attribute1);

Line 1260: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY

1256: l_pn_addresses_rec.ADDRESS_STYLE := nvl( loc.address_style, v_addr_rec.address_style);
1257: l_pn_addresses_rec.LAST_UPDATE_DATE := sysdate;
1258: l_pn_addresses_rec.LAST_UPDATED_BY := nvl(fnd_profile.value('USER_ID'), 0);
1259: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1260: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY
1261: := nvl(loc.addr_attribute_category,
1262: v_addr_rec.addr_attribute_category);
1263: l_pn_addresses_rec.ADDR_ATTRIBUTE1 := nvl(loc.addr_attribute1,v_addr_rec.addr_attribute1);
1264: l_pn_addresses_rec.ADDR_ATTRIBUTE2 := nvl(loc.addr_attribute2,v_addr_rec.addr_attribute2);

Line 1263: l_pn_addresses_rec.ADDR_ATTRIBUTE1 := nvl(loc.addr_attribute1,v_addr_rec.addr_attribute1);

1259: l_pn_addresses_rec.LAST_UPDATE_LOGIN := nvl(fnd_profile.value('CONC_LOGIN_ID'), 0);
1260: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY
1261: := nvl(loc.addr_attribute_category,
1262: v_addr_rec.addr_attribute_category);
1263: l_pn_addresses_rec.ADDR_ATTRIBUTE1 := nvl(loc.addr_attribute1,v_addr_rec.addr_attribute1);
1264: l_pn_addresses_rec.ADDR_ATTRIBUTE2 := nvl(loc.addr_attribute2,v_addr_rec.addr_attribute2);
1265: l_pn_addresses_rec.ADDR_ATTRIBUTE3 := nvl(loc.addr_attribute3,v_addr_rec.addr_attribute3);
1266: l_pn_addresses_rec.ADDR_ATTRIBUTE4 := nvl(loc.addr_attribute4,v_addr_rec.addr_attribute4);
1267: l_pn_addresses_rec.ADDR_ATTRIBUTE5 := nvl(loc.addr_attribute5,v_addr_rec.addr_attribute5);

Line 1264: l_pn_addresses_rec.ADDR_ATTRIBUTE2 := nvl(loc.addr_attribute2,v_addr_rec.addr_attribute2);

1260: l_pn_addresses_rec.ADDR_ATTRIBUTE_CATEGORY
1261: := nvl(loc.addr_attribute_category,
1262: v_addr_rec.addr_attribute_category);
1263: l_pn_addresses_rec.ADDR_ATTRIBUTE1 := nvl(loc.addr_attribute1,v_addr_rec.addr_attribute1);
1264: l_pn_addresses_rec.ADDR_ATTRIBUTE2 := nvl(loc.addr_attribute2,v_addr_rec.addr_attribute2);
1265: l_pn_addresses_rec.ADDR_ATTRIBUTE3 := nvl(loc.addr_attribute3,v_addr_rec.addr_attribute3);
1266: l_pn_addresses_rec.ADDR_ATTRIBUTE4 := nvl(loc.addr_attribute4,v_addr_rec.addr_attribute4);
1267: l_pn_addresses_rec.ADDR_ATTRIBUTE5 := nvl(loc.addr_attribute5,v_addr_rec.addr_attribute5);
1268: l_pn_addresses_rec.ADDR_ATTRIBUTE6 := nvl(loc.addr_attribute6,v_addr_rec.addr_attribute6);

Line 1265: l_pn_addresses_rec.ADDR_ATTRIBUTE3 := nvl(loc.addr_attribute3,v_addr_rec.addr_attribute3);

1261: := nvl(loc.addr_attribute_category,
1262: v_addr_rec.addr_attribute_category);
1263: l_pn_addresses_rec.ADDR_ATTRIBUTE1 := nvl(loc.addr_attribute1,v_addr_rec.addr_attribute1);
1264: l_pn_addresses_rec.ADDR_ATTRIBUTE2 := nvl(loc.addr_attribute2,v_addr_rec.addr_attribute2);
1265: l_pn_addresses_rec.ADDR_ATTRIBUTE3 := nvl(loc.addr_attribute3,v_addr_rec.addr_attribute3);
1266: l_pn_addresses_rec.ADDR_ATTRIBUTE4 := nvl(loc.addr_attribute4,v_addr_rec.addr_attribute4);
1267: l_pn_addresses_rec.ADDR_ATTRIBUTE5 := nvl(loc.addr_attribute5,v_addr_rec.addr_attribute5);
1268: l_pn_addresses_rec.ADDR_ATTRIBUTE6 := nvl(loc.addr_attribute6,v_addr_rec.addr_attribute6);
1269: l_pn_addresses_rec.ADDR_ATTRIBUTE7 := nvl(loc.addr_attribute7,v_addr_rec.addr_attribute7);

Line 1266: l_pn_addresses_rec.ADDR_ATTRIBUTE4 := nvl(loc.addr_attribute4,v_addr_rec.addr_attribute4);

1262: v_addr_rec.addr_attribute_category);
1263: l_pn_addresses_rec.ADDR_ATTRIBUTE1 := nvl(loc.addr_attribute1,v_addr_rec.addr_attribute1);
1264: l_pn_addresses_rec.ADDR_ATTRIBUTE2 := nvl(loc.addr_attribute2,v_addr_rec.addr_attribute2);
1265: l_pn_addresses_rec.ADDR_ATTRIBUTE3 := nvl(loc.addr_attribute3,v_addr_rec.addr_attribute3);
1266: l_pn_addresses_rec.ADDR_ATTRIBUTE4 := nvl(loc.addr_attribute4,v_addr_rec.addr_attribute4);
1267: l_pn_addresses_rec.ADDR_ATTRIBUTE5 := nvl(loc.addr_attribute5,v_addr_rec.addr_attribute5);
1268: l_pn_addresses_rec.ADDR_ATTRIBUTE6 := nvl(loc.addr_attribute6,v_addr_rec.addr_attribute6);
1269: l_pn_addresses_rec.ADDR_ATTRIBUTE7 := nvl(loc.addr_attribute7,v_addr_rec.addr_attribute7);
1270: l_pn_addresses_rec.ADDR_ATTRIBUTE8 := nvl(loc.addr_attribute8,v_addr_rec.addr_attribute8);

Line 1267: l_pn_addresses_rec.ADDR_ATTRIBUTE5 := nvl(loc.addr_attribute5,v_addr_rec.addr_attribute5);

1263: l_pn_addresses_rec.ADDR_ATTRIBUTE1 := nvl(loc.addr_attribute1,v_addr_rec.addr_attribute1);
1264: l_pn_addresses_rec.ADDR_ATTRIBUTE2 := nvl(loc.addr_attribute2,v_addr_rec.addr_attribute2);
1265: l_pn_addresses_rec.ADDR_ATTRIBUTE3 := nvl(loc.addr_attribute3,v_addr_rec.addr_attribute3);
1266: l_pn_addresses_rec.ADDR_ATTRIBUTE4 := nvl(loc.addr_attribute4,v_addr_rec.addr_attribute4);
1267: l_pn_addresses_rec.ADDR_ATTRIBUTE5 := nvl(loc.addr_attribute5,v_addr_rec.addr_attribute5);
1268: l_pn_addresses_rec.ADDR_ATTRIBUTE6 := nvl(loc.addr_attribute6,v_addr_rec.addr_attribute6);
1269: l_pn_addresses_rec.ADDR_ATTRIBUTE7 := nvl(loc.addr_attribute7,v_addr_rec.addr_attribute7);
1270: l_pn_addresses_rec.ADDR_ATTRIBUTE8 := nvl(loc.addr_attribute8,v_addr_rec.addr_attribute8);
1271: l_pn_addresses_rec.ADDR_ATTRIBUTE9 := nvl(loc.addr_attribute9,v_addr_rec.addr_attribute9);

Line 1268: l_pn_addresses_rec.ADDR_ATTRIBUTE6 := nvl(loc.addr_attribute6,v_addr_rec.addr_attribute6);

1264: l_pn_addresses_rec.ADDR_ATTRIBUTE2 := nvl(loc.addr_attribute2,v_addr_rec.addr_attribute2);
1265: l_pn_addresses_rec.ADDR_ATTRIBUTE3 := nvl(loc.addr_attribute3,v_addr_rec.addr_attribute3);
1266: l_pn_addresses_rec.ADDR_ATTRIBUTE4 := nvl(loc.addr_attribute4,v_addr_rec.addr_attribute4);
1267: l_pn_addresses_rec.ADDR_ATTRIBUTE5 := nvl(loc.addr_attribute5,v_addr_rec.addr_attribute5);
1268: l_pn_addresses_rec.ADDR_ATTRIBUTE6 := nvl(loc.addr_attribute6,v_addr_rec.addr_attribute6);
1269: l_pn_addresses_rec.ADDR_ATTRIBUTE7 := nvl(loc.addr_attribute7,v_addr_rec.addr_attribute7);
1270: l_pn_addresses_rec.ADDR_ATTRIBUTE8 := nvl(loc.addr_attribute8,v_addr_rec.addr_attribute8);
1271: l_pn_addresses_rec.ADDR_ATTRIBUTE9 := nvl(loc.addr_attribute9,v_addr_rec.addr_attribute9);
1272: l_pn_addresses_rec.ADDR_ATTRIBUTE10 := nvl(loc.addr_attribute10,v_addr_rec.addr_attribute10);

Line 1269: l_pn_addresses_rec.ADDR_ATTRIBUTE7 := nvl(loc.addr_attribute7,v_addr_rec.addr_attribute7);

1265: l_pn_addresses_rec.ADDR_ATTRIBUTE3 := nvl(loc.addr_attribute3,v_addr_rec.addr_attribute3);
1266: l_pn_addresses_rec.ADDR_ATTRIBUTE4 := nvl(loc.addr_attribute4,v_addr_rec.addr_attribute4);
1267: l_pn_addresses_rec.ADDR_ATTRIBUTE5 := nvl(loc.addr_attribute5,v_addr_rec.addr_attribute5);
1268: l_pn_addresses_rec.ADDR_ATTRIBUTE6 := nvl(loc.addr_attribute6,v_addr_rec.addr_attribute6);
1269: l_pn_addresses_rec.ADDR_ATTRIBUTE7 := nvl(loc.addr_attribute7,v_addr_rec.addr_attribute7);
1270: l_pn_addresses_rec.ADDR_ATTRIBUTE8 := nvl(loc.addr_attribute8,v_addr_rec.addr_attribute8);
1271: l_pn_addresses_rec.ADDR_ATTRIBUTE9 := nvl(loc.addr_attribute9,v_addr_rec.addr_attribute9);
1272: l_pn_addresses_rec.ADDR_ATTRIBUTE10 := nvl(loc.addr_attribute10,v_addr_rec.addr_attribute10);
1273: l_pn_addresses_rec.ADDR_ATTRIBUTE11 := nvl(loc.addr_attribute11,v_addr_rec.addr_attribute11);

Line 1270: l_pn_addresses_rec.ADDR_ATTRIBUTE8 := nvl(loc.addr_attribute8,v_addr_rec.addr_attribute8);

1266: l_pn_addresses_rec.ADDR_ATTRIBUTE4 := nvl(loc.addr_attribute4,v_addr_rec.addr_attribute4);
1267: l_pn_addresses_rec.ADDR_ATTRIBUTE5 := nvl(loc.addr_attribute5,v_addr_rec.addr_attribute5);
1268: l_pn_addresses_rec.ADDR_ATTRIBUTE6 := nvl(loc.addr_attribute6,v_addr_rec.addr_attribute6);
1269: l_pn_addresses_rec.ADDR_ATTRIBUTE7 := nvl(loc.addr_attribute7,v_addr_rec.addr_attribute7);
1270: l_pn_addresses_rec.ADDR_ATTRIBUTE8 := nvl(loc.addr_attribute8,v_addr_rec.addr_attribute8);
1271: l_pn_addresses_rec.ADDR_ATTRIBUTE9 := nvl(loc.addr_attribute9,v_addr_rec.addr_attribute9);
1272: l_pn_addresses_rec.ADDR_ATTRIBUTE10 := nvl(loc.addr_attribute10,v_addr_rec.addr_attribute10);
1273: l_pn_addresses_rec.ADDR_ATTRIBUTE11 := nvl(loc.addr_attribute11,v_addr_rec.addr_attribute11);
1274: l_pn_addresses_rec.ADDR_ATTRIBUTE12 := nvl(loc.addr_attribute12,v_addr_rec.addr_attribute12);

Line 1271: l_pn_addresses_rec.ADDR_ATTRIBUTE9 := nvl(loc.addr_attribute9,v_addr_rec.addr_attribute9);

1267: l_pn_addresses_rec.ADDR_ATTRIBUTE5 := nvl(loc.addr_attribute5,v_addr_rec.addr_attribute5);
1268: l_pn_addresses_rec.ADDR_ATTRIBUTE6 := nvl(loc.addr_attribute6,v_addr_rec.addr_attribute6);
1269: l_pn_addresses_rec.ADDR_ATTRIBUTE7 := nvl(loc.addr_attribute7,v_addr_rec.addr_attribute7);
1270: l_pn_addresses_rec.ADDR_ATTRIBUTE8 := nvl(loc.addr_attribute8,v_addr_rec.addr_attribute8);
1271: l_pn_addresses_rec.ADDR_ATTRIBUTE9 := nvl(loc.addr_attribute9,v_addr_rec.addr_attribute9);
1272: l_pn_addresses_rec.ADDR_ATTRIBUTE10 := nvl(loc.addr_attribute10,v_addr_rec.addr_attribute10);
1273: l_pn_addresses_rec.ADDR_ATTRIBUTE11 := nvl(loc.addr_attribute11,v_addr_rec.addr_attribute11);
1274: l_pn_addresses_rec.ADDR_ATTRIBUTE12 := nvl(loc.addr_attribute12,v_addr_rec.addr_attribute12);
1275: l_pn_addresses_rec.ADDR_ATTRIBUTE13 := nvl(loc.addr_attribute13,v_addr_rec.addr_attribute13);

Line 1272: l_pn_addresses_rec.ADDR_ATTRIBUTE10 := nvl(loc.addr_attribute10,v_addr_rec.addr_attribute10);

1268: l_pn_addresses_rec.ADDR_ATTRIBUTE6 := nvl(loc.addr_attribute6,v_addr_rec.addr_attribute6);
1269: l_pn_addresses_rec.ADDR_ATTRIBUTE7 := nvl(loc.addr_attribute7,v_addr_rec.addr_attribute7);
1270: l_pn_addresses_rec.ADDR_ATTRIBUTE8 := nvl(loc.addr_attribute8,v_addr_rec.addr_attribute8);
1271: l_pn_addresses_rec.ADDR_ATTRIBUTE9 := nvl(loc.addr_attribute9,v_addr_rec.addr_attribute9);
1272: l_pn_addresses_rec.ADDR_ATTRIBUTE10 := nvl(loc.addr_attribute10,v_addr_rec.addr_attribute10);
1273: l_pn_addresses_rec.ADDR_ATTRIBUTE11 := nvl(loc.addr_attribute11,v_addr_rec.addr_attribute11);
1274: l_pn_addresses_rec.ADDR_ATTRIBUTE12 := nvl(loc.addr_attribute12,v_addr_rec.addr_attribute12);
1275: l_pn_addresses_rec.ADDR_ATTRIBUTE13 := nvl(loc.addr_attribute13,v_addr_rec.addr_attribute13);
1276: l_pn_addresses_rec.ADDR_ATTRIBUTE14 := nvl(loc.addr_attribute14,v_addr_rec.addr_attribute14);

Line 1273: l_pn_addresses_rec.ADDR_ATTRIBUTE11 := nvl(loc.addr_attribute11,v_addr_rec.addr_attribute11);

1269: l_pn_addresses_rec.ADDR_ATTRIBUTE7 := nvl(loc.addr_attribute7,v_addr_rec.addr_attribute7);
1270: l_pn_addresses_rec.ADDR_ATTRIBUTE8 := nvl(loc.addr_attribute8,v_addr_rec.addr_attribute8);
1271: l_pn_addresses_rec.ADDR_ATTRIBUTE9 := nvl(loc.addr_attribute9,v_addr_rec.addr_attribute9);
1272: l_pn_addresses_rec.ADDR_ATTRIBUTE10 := nvl(loc.addr_attribute10,v_addr_rec.addr_attribute10);
1273: l_pn_addresses_rec.ADDR_ATTRIBUTE11 := nvl(loc.addr_attribute11,v_addr_rec.addr_attribute11);
1274: l_pn_addresses_rec.ADDR_ATTRIBUTE12 := nvl(loc.addr_attribute12,v_addr_rec.addr_attribute12);
1275: l_pn_addresses_rec.ADDR_ATTRIBUTE13 := nvl(loc.addr_attribute13,v_addr_rec.addr_attribute13);
1276: l_pn_addresses_rec.ADDR_ATTRIBUTE14 := nvl(loc.addr_attribute14,v_addr_rec.addr_attribute14);
1277: l_pn_addresses_rec.ADDR_ATTRIBUTE15 := nvl(loc.addr_attribute15,v_addr_rec.addr_attribute15);

Line 1274: l_pn_addresses_rec.ADDR_ATTRIBUTE12 := nvl(loc.addr_attribute12,v_addr_rec.addr_attribute12);

1270: l_pn_addresses_rec.ADDR_ATTRIBUTE8 := nvl(loc.addr_attribute8,v_addr_rec.addr_attribute8);
1271: l_pn_addresses_rec.ADDR_ATTRIBUTE9 := nvl(loc.addr_attribute9,v_addr_rec.addr_attribute9);
1272: l_pn_addresses_rec.ADDR_ATTRIBUTE10 := nvl(loc.addr_attribute10,v_addr_rec.addr_attribute10);
1273: l_pn_addresses_rec.ADDR_ATTRIBUTE11 := nvl(loc.addr_attribute11,v_addr_rec.addr_attribute11);
1274: l_pn_addresses_rec.ADDR_ATTRIBUTE12 := nvl(loc.addr_attribute12,v_addr_rec.addr_attribute12);
1275: l_pn_addresses_rec.ADDR_ATTRIBUTE13 := nvl(loc.addr_attribute13,v_addr_rec.addr_attribute13);
1276: l_pn_addresses_rec.ADDR_ATTRIBUTE14 := nvl(loc.addr_attribute14,v_addr_rec.addr_attribute14);
1277: l_pn_addresses_rec.ADDR_ATTRIBUTE15 := nvl(loc.addr_attribute15,v_addr_rec.addr_attribute15);
1278:

Line 1275: l_pn_addresses_rec.ADDR_ATTRIBUTE13 := nvl(loc.addr_attribute13,v_addr_rec.addr_attribute13);

1271: l_pn_addresses_rec.ADDR_ATTRIBUTE9 := nvl(loc.addr_attribute9,v_addr_rec.addr_attribute9);
1272: l_pn_addresses_rec.ADDR_ATTRIBUTE10 := nvl(loc.addr_attribute10,v_addr_rec.addr_attribute10);
1273: l_pn_addresses_rec.ADDR_ATTRIBUTE11 := nvl(loc.addr_attribute11,v_addr_rec.addr_attribute11);
1274: l_pn_addresses_rec.ADDR_ATTRIBUTE12 := nvl(loc.addr_attribute12,v_addr_rec.addr_attribute12);
1275: l_pn_addresses_rec.ADDR_ATTRIBUTE13 := nvl(loc.addr_attribute13,v_addr_rec.addr_attribute13);
1276: l_pn_addresses_rec.ADDR_ATTRIBUTE14 := nvl(loc.addr_attribute14,v_addr_rec.addr_attribute14);
1277: l_pn_addresses_rec.ADDR_ATTRIBUTE15 := nvl(loc.addr_attribute15,v_addr_rec.addr_attribute15);
1278:
1279: -------------------------------------------------------------------

Line 1276: l_pn_addresses_rec.ADDR_ATTRIBUTE14 := nvl(loc.addr_attribute14,v_addr_rec.addr_attribute14);

1272: l_pn_addresses_rec.ADDR_ATTRIBUTE10 := nvl(loc.addr_attribute10,v_addr_rec.addr_attribute10);
1273: l_pn_addresses_rec.ADDR_ATTRIBUTE11 := nvl(loc.addr_attribute11,v_addr_rec.addr_attribute11);
1274: l_pn_addresses_rec.ADDR_ATTRIBUTE12 := nvl(loc.addr_attribute12,v_addr_rec.addr_attribute12);
1275: l_pn_addresses_rec.ADDR_ATTRIBUTE13 := nvl(loc.addr_attribute13,v_addr_rec.addr_attribute13);
1276: l_pn_addresses_rec.ADDR_ATTRIBUTE14 := nvl(loc.addr_attribute14,v_addr_rec.addr_attribute14);
1277: l_pn_addresses_rec.ADDR_ATTRIBUTE15 := nvl(loc.addr_attribute15,v_addr_rec.addr_attribute15);
1278:
1279: -------------------------------------------------------------------
1280: -- Validate Assignable_Area / Common Area is not null for location types 'OFFICE','SECTION'

Line 1277: l_pn_addresses_rec.ADDR_ATTRIBUTE15 := nvl(loc.addr_attribute15,v_addr_rec.addr_attribute15);

1273: l_pn_addresses_rec.ADDR_ATTRIBUTE11 := nvl(loc.addr_attribute11,v_addr_rec.addr_attribute11);
1274: l_pn_addresses_rec.ADDR_ATTRIBUTE12 := nvl(loc.addr_attribute12,v_addr_rec.addr_attribute12);
1275: l_pn_addresses_rec.ADDR_ATTRIBUTE13 := nvl(loc.addr_attribute13,v_addr_rec.addr_attribute13);
1276: l_pn_addresses_rec.ADDR_ATTRIBUTE14 := nvl(loc.addr_attribute14,v_addr_rec.addr_attribute14);
1277: l_pn_addresses_rec.ADDR_ATTRIBUTE15 := nvl(loc.addr_attribute15,v_addr_rec.addr_attribute15);
1278:
1279: -------------------------------------------------------------------
1280: -- Validate Assignable_Area / Common Area is not null for location types 'OFFICE','SECTION'
1281: -------------------------------------------------------------------

Line 1317: p_pn_addresses_rec => l_pn_addresses_rec,

1313:
1314: put_log( 'R: Just before Correct/Update');
1315: PNT_LOCATIONS_PKG.correct_update_row
1316: ( p_pn_locations_rec => l_pn_locations_rec,
1317: p_pn_addresses_rec => l_pn_addresses_rec,
1318: p_change_mode => nvl(loc.change_mode, 'CORRECT'),
1319: p_as_of_date => loc.change_date,
1320: p_active_start_date_old => trunc(loc.active_start_date), --Used trunc() :Bug 6009957
1321: p_active_end_date_old => trunc(v_loc_rec.active_end_date), --Used trunc() :Bug 6009957