1259: l_tax_registrations_rec.bank_branch_id,
1260: l_tax_registrations_rec.bank_account_num,
1261: l_tax_registrations_rec.legal_location_id,
1262: l_tax_registrations_rec.record_type_code,
1263: fnd_global.conc_request_id,
1264: fnd_global.prog_appl_id,
1265: fnd_global.conc_program_id,
1266: fnd_global.conc_login_id,
1267: l_tax_registrations_rec.account_id,
1260: l_tax_registrations_rec.bank_account_num,
1261: l_tax_registrations_rec.legal_location_id,
1262: l_tax_registrations_rec.record_type_code,
1263: fnd_global.conc_request_id,
1264: fnd_global.prog_appl_id,
1265: fnd_global.conc_program_id,
1266: fnd_global.conc_login_id,
1267: l_tax_registrations_rec.account_id,
1268: l_tax_registrations_rec.account_site_id,
1261: l_tax_registrations_rec.legal_location_id,
1262: l_tax_registrations_rec.record_type_code,
1263: fnd_global.conc_request_id,
1264: fnd_global.prog_appl_id,
1265: fnd_global.conc_program_id,
1266: fnd_global.conc_login_id,
1267: l_tax_registrations_rec.account_id,
1268: l_tax_registrations_rec.account_site_id,
1269: --l_tax_registrations_rec.site_use_id,
1262: l_tax_registrations_rec.record_type_code,
1263: fnd_global.conc_request_id,
1264: fnd_global.prog_appl_id,
1265: fnd_global.conc_program_id,
1266: fnd_global.conc_login_id,
1267: l_tax_registrations_rec.account_id,
1268: l_tax_registrations_rec.account_site_id,
1269: --l_tax_registrations_rec.site_use_id,
1270: --l_tax_registrations_rec.geo_type_classification_code,
1284: l_tax_registrations_rec.attribute14,
1285: l_tax_registrations_rec.attribute15,
1286: l_tax_registrations_rec.attribute_category,
1287: SYSDATE + 1,
1288: fnd_global.user_id,
1289: SYSDATE + 1,
1290: fnd_global.user_id,
1291: fnd_global.conc_login_id);
1292:
1286: l_tax_registrations_rec.attribute_category,
1287: SYSDATE + 1,
1288: fnd_global.user_id,
1289: SYSDATE + 1,
1290: fnd_global.user_id,
1291: fnd_global.conc_login_id);
1292:
1293: ELSE
1294:
1287: SYSDATE + 1,
1288: fnd_global.user_id,
1289: SYSDATE + 1,
1290: fnd_global.user_id,
1291: fnd_global.conc_login_id);
1292:
1293: ELSE
1294:
1295: update ZX_REGISTRATIONS set
1382: l_tax_registrations_rec.bank_branch_id,
1383: l_tax_registrations_rec.bank_account_num,
1384: l_tax_registrations_rec.legal_location_id,
1385: l_tax_registrations_rec.record_type_code,
1386: fnd_global.conc_request_id,
1387: fnd_global.prog_appl_id,
1388: fnd_global.conc_program_id,
1389: fnd_global.conc_login_id,
1390: l_tax_registrations_rec.account_id,
1383: l_tax_registrations_rec.bank_account_num,
1384: l_tax_registrations_rec.legal_location_id,
1385: l_tax_registrations_rec.record_type_code,
1386: fnd_global.conc_request_id,
1387: fnd_global.prog_appl_id,
1388: fnd_global.conc_program_id,
1389: fnd_global.conc_login_id,
1390: l_tax_registrations_rec.account_id,
1391: l_tax_registrations_rec.account_site_id,
1384: l_tax_registrations_rec.legal_location_id,
1385: l_tax_registrations_rec.record_type_code,
1386: fnd_global.conc_request_id,
1387: fnd_global.prog_appl_id,
1388: fnd_global.conc_program_id,
1389: fnd_global.conc_login_id,
1390: l_tax_registrations_rec.account_id,
1391: l_tax_registrations_rec.account_site_id,
1392: --l_tax_registrations_rec.site_use_id,
1385: l_tax_registrations_rec.record_type_code,
1386: fnd_global.conc_request_id,
1387: fnd_global.prog_appl_id,
1388: fnd_global.conc_program_id,
1389: fnd_global.conc_login_id,
1390: l_tax_registrations_rec.account_id,
1391: l_tax_registrations_rec.account_site_id,
1392: --l_tax_registrations_rec.site_use_id,
1393: --l_tax_registrations_rec.geo_type_classification_code,
1407: l_tax_registrations_rec.attribute14,
1408: l_tax_registrations_rec.attribute15,
1409: l_tax_registrations_rec.attribute_category,
1410: p_le_old_end_date + 1,
1411: fnd_global.user_id,
1412: p_le_old_end_date + 1,
1413: fnd_global.user_id,
1414: fnd_global.conc_login_id);
1415: END IF;
1409: l_tax_registrations_rec.attribute_category,
1410: p_le_old_end_date + 1,
1411: fnd_global.user_id,
1412: p_le_old_end_date + 1,
1413: fnd_global.user_id,
1414: fnd_global.conc_login_id);
1415: END IF;
1416:
1417: END IF;
1410: p_le_old_end_date + 1,
1411: fnd_global.user_id,
1412: p_le_old_end_date + 1,
1413: fnd_global.user_id,
1414: fnd_global.conc_login_id);
1415: END IF;
1416:
1417: END IF;
1418: