APPS.ZX_TCM_PTP_PKG dependencies on ZX_REGISTRATIONS

Line 974: l_tax_registration_id ZX_REGISTRATIONS.REGISTRATION_ID%TYPE;

970:
971: l_api_name CONSTANT VARCHAR2(30) := 'CHECK_TAX_REGISTRATIONS';
972: l_api_version CONSTANT NUMBER := 1.0;
973:
974: l_tax_registration_id ZX_REGISTRATIONS.REGISTRATION_ID%TYPE;
975:
976: -- Logging Infra
977: l_procedure_name CONSTANT VARCHAR2(30) := '.CHECK_TAX_REGISTRATIONS';
978: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 983: FROM zx_registrations

979:
980: CURSOR c_get_reg_id
981: IS
982: SELECT registration_id
983: FROM zx_registrations
984: WHERE legal_registration_id = p_le_reg_id;
985:
986: BEGIN
987:

Line 1122: l_tax_registrations_rec ZX_REGISTRATIONS%ROWTYPE;

1118:
1119: l_api_name CONSTANT VARCHAR2(30) := 'SYNC_TAX_REGISTRATIONS';
1120: l_api_version CONSTANT NUMBER := 1.0;
1121:
1122: l_tax_registrations_rec ZX_REGISTRATIONS%ROWTYPE;
1123:
1124: -- Find a tax registration which is from Legal Registrations
1125:
1126: CURSOR c_find_reg_num

Line 1181: FROM zx_registrations

1177: attribute13,
1178: attribute14,
1179: attribute15,
1180: attribute_category
1181: FROM zx_registrations
1182: WHERE legal_registration_id = p_le_old_reg_id;
1183:
1184: -- Logging Infra
1185: l_procedure_name CONSTANT VARCHAR2(30) := 'SYNC_TAX_REGISTRATIONS';

Line 1305: update ZX_REGISTRATIONS set

1301: ELSE
1302: x_return_status := FND_API.G_RET_STS_SUCCESS;
1303:
1304: IF p_le_new_reg_id IS NULL and p_le_old_end_date IS NULL THEN
1305: update ZX_REGISTRATIONS set
1306: effective_to = SYSDATE
1307: where registration_id = l_tax_registrations_rec.registration_id;
1308:
1309: insert into ZX_REGISTRATIONS (

Line 1309: insert into ZX_REGISTRATIONS (

1305: update ZX_REGISTRATIONS set
1306: effective_to = SYSDATE
1307: where registration_id = l_tax_registrations_rec.registration_id;
1308:
1309: insert into ZX_REGISTRATIONS (
1310: registration_id,
1311: registration_type_code,
1312: registration_number,
1313: validation_rule,

Line 1368: Zx_Registrations_S.nextval,

1364: last_update_date,
1365: last_updated_by,
1366: last_update_login
1367: ) values (
1368: Zx_Registrations_S.nextval,
1369: l_tax_registrations_rec.registration_type_code,
1370: p_le_new_reg_num,
1371: l_tax_registrations_rec.validation_rule,
1372: l_tax_registrations_rec.tax_authority_id,

Line 1428: update ZX_REGISTRATIONS set

1424: fnd_global.conc_login_id);
1425:
1426: ELSE
1427:
1428: update ZX_REGISTRATIONS set
1429: effective_to = p_le_old_end_date
1430: where registration_id = l_tax_registrations_rec.registration_id;
1431:
1432: insert into ZX_REGISTRATIONS (

Line 1432: insert into ZX_REGISTRATIONS (

1428: update ZX_REGISTRATIONS set
1429: effective_to = p_le_old_end_date
1430: where registration_id = l_tax_registrations_rec.registration_id;
1431:
1432: insert into ZX_REGISTRATIONS (
1433: registration_id,
1434: registration_type_code,
1435: registration_number,
1436: validation_rule,

Line 1491: Zx_Registrations_S.nextval,

1487: last_update_date,
1488: last_updated_by,
1489: last_update_login
1490: ) values (
1491: Zx_Registrations_S.nextval,
1492: l_tax_registrations_rec.registration_type_code,
1493: p_le_new_reg_num,
1494: l_tax_registrations_rec.validation_rule,
1495: l_tax_registrations_rec.tax_authority_id,