APPS.ZX_TCM_PTP_PKG dependencies on ZX_REGISTRATIONS_S

Line 1172: update ZX_REGISTRATIONS set

1168: ELSE
1169: x_return_status := FND_API.G_RET_STS_SUCCESS;
1170:
1171: IF p_le_new_reg_id IS NULL and p_le_old_end_date IS NULL THEN
1172: update ZX_REGISTRATIONS set
1173: effective_to = SYSDATE
1174: where registration_id = l_tax_registrations_rec.registration_id;
1175:
1176: insert into ZX_REGISTRATIONS (

Line 1235: Zx_Registrations_S.nextval,

1231: last_update_date,
1232: last_updated_by,
1233: last_update_login
1234: ) values (
1235: Zx_Registrations_S.nextval,
1236: l_tax_registrations_rec.registration_type_code,
1237: p_le_new_reg_num,
1238: l_tax_registrations_rec.validation_rule,
1239: l_tax_registrations_rec.tax_authority_id,

Line 1295: update ZX_REGISTRATIONS set

1291: fnd_global.conc_login_id);
1292:
1293: ELSE
1294:
1295: update ZX_REGISTRATIONS set
1296: effective_to = p_le_old_end_date
1297: where registration_id = l_tax_registrations_rec.registration_id;
1298:
1299: insert into ZX_REGISTRATIONS (

Line 1358: Zx_Registrations_S.nextval,

1354: last_update_date,
1355: last_updated_by,
1356: last_update_login
1357: ) values (
1358: Zx_Registrations_S.nextval,
1359: l_tax_registrations_rec.registration_type_code,
1360: p_le_new_reg_num,
1361: l_tax_registrations_rec.validation_rule,
1362: l_tax_registrations_rec.tax_authority_id,