DBA Data[Home] [Help]

APPS.ZX_TCM_PTP_PKG dependencies on ZX_REGISTRATIONS

Line 849: l_tax_registration_id ZX_REGISTRATIONS.REGISTRATION_ID%TYPE;

845:
846: l_api_name CONSTANT VARCHAR2(30) := 'CHECK_TAX_REGISTRATIONS';
847: l_api_version CONSTANT NUMBER := 1.0;
848:
849: l_tax_registration_id ZX_REGISTRATIONS.REGISTRATION_ID%TYPE;
850:
851: -- Logging Infra
852: l_procedure_name CONSTANT VARCHAR2(30) := '.CHECK_TAX_REGISTRATIONS';
853: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 858: FROM zx_registrations

854:
855: CURSOR c_get_reg_id
856: IS
857: SELECT registration_id
858: FROM zx_registrations
859: WHERE legal_registration_id = p_le_reg_id;
860:
861: BEGIN
862:

Line 993: l_tax_registrations_rec ZX_REGISTRATIONS%ROWTYPE;

989:
990: l_api_name CONSTANT VARCHAR2(30) := 'SYNC_TAX_REGISTRATIONS';
991: l_api_version CONSTANT NUMBER := 1.0;
992:
993: l_tax_registrations_rec ZX_REGISTRATIONS%ROWTYPE;
994:
995: -- Find a tax registration which is from Legal Registrations
996:
997: CURSOR c_find_reg_num

Line 1052: FROM zx_registrations

1048: attribute13,
1049: attribute14,
1050: attribute15,
1051: attribute_category
1052: FROM zx_registrations
1053: WHERE legal_registration_id = p_le_old_reg_id;
1054:
1055: -- Logging Infra
1056: l_procedure_name CONSTANT VARCHAR2(30) := 'SYNC_TAX_REGISTRATIONS';

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 1176: insert into ZX_REGISTRATIONS (

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 (
1177: registration_id,
1178: registration_type_code,
1179: registration_number,
1180: validation_rule,

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 1299: insert into ZX_REGISTRATIONS (

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 (
1300: registration_id,
1301: registration_type_code,
1302: registration_number,
1303: validation_rule,

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,