APPS.ZX_TCM_EXT_SERVICES_PUB dependencies on ZX_REGISTRATIONS

Line 1395: P_Effective_Date IN zx_registrations.effective_from%Type,

1391: **************************************************************************/
1392: FUNCTION Get_Default_Tax_Reg
1393: (P_Party_ID IN zx_party_tax_profile.party_id%Type,
1394: P_Party_Type IN zx_party_tax_profile.party_type_code%Type,
1395: P_Effective_Date IN zx_registrations.effective_from%Type,
1396: x_return_status OUT NOCOPY VARCHAR2
1397: )
1398: RETURN Varchar2
1399: IS

Line 1403: l_effective_date zx_registrations.effective_from%Type;

1399: IS
1400: -- Logging Infra
1401: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Default_Tax_Reg';
1402: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1403: l_effective_date zx_registrations.effective_from%Type;
1404: --p_error_buffer varchar2(200);
1405:
1406: Cursor Default_Reg IS
1407: Select NVL(reg.registration_number, PTP.rep_registration_number) registration_number

Line 1408: From zx_registrations reg

1404: --p_error_buffer varchar2(200);
1405:
1406: Cursor Default_Reg IS
1407: Select NVL(reg.registration_number, PTP.rep_registration_number) registration_number
1408: From zx_registrations reg
1409: ,zx_party_tax_profile ptp
1410: Where ptp.party_id = p_party_id
1411: AND ptp.party_type_code = p_party_type
1412: AND ptp.party_tax_profile_id = reg.party_tax_profile_id

Line 1534: p_registration_num IN ZX_REGISTRATIONS.Registration_Number%type,

1530:
1531: FUNCTION get_le_from_tax_registration
1532: (
1533: x_return_status OUT NOCOPY VARCHAR2,
1534: p_registration_num IN ZX_REGISTRATIONS.Registration_Number%type,
1535: p_effective_date IN ZX_REGISTRATIONS.effective_from%type,
1536: p_country IN ZX_PARTY_TAX_PROFILE.Country_code%type
1537: ) RETURN Number IS
1538: l_legal_entity_id NUMBER;

Line 1535: p_effective_date IN ZX_REGISTRATIONS.effective_from%type,

1531: FUNCTION get_le_from_tax_registration
1532: (
1533: x_return_status OUT NOCOPY VARCHAR2,
1534: p_registration_num IN ZX_REGISTRATIONS.Registration_Number%type,
1535: p_effective_date IN ZX_REGISTRATIONS.effective_from%type,
1536: p_country IN ZX_PARTY_TAX_PROFILE.Country_code%type
1537: ) RETURN Number IS
1538: l_legal_entity_id NUMBER;
1539: BEGIN

Line 1544: from zx_registrations tr, zx_party_tax_profile ptp, xle_etb_profiles xle

1540: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1541: IF p_registration_num IS NOT NULL THEN
1542: SELECT distinct xle.legal_entity_id
1543: INTO l_legal_entity_id
1544: from zx_registrations tr, zx_party_tax_profile ptp, xle_etb_profiles xle
1545: where tr.registration_number = p_registration_num
1546: and tr.party_tax_profile_id = ptp.party_tax_profile_id
1547: and ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
1548: and ptp.party_id = xle.party_id;