APPS.ZX_TCM_EXT_SERVICES_PUB dependencies on ZX_REGISTRATIONS

Line 1352: P_Effective_Date IN zx_registrations.effective_from%Type,

1348: **************************************************************************/
1349: FUNCTION Get_Default_Tax_Reg
1350: (P_Party_ID IN zx_party_tax_profile.party_id%Type,
1351: P_Party_Type IN zx_party_tax_profile.party_type_code%Type,
1352: P_Effective_Date IN zx_registrations.effective_from%Type,
1353: x_return_status OUT NOCOPY VARCHAR2
1354: )
1355: RETURN Varchar2
1356: IS

Line 1360: l_effective_date zx_registrations.effective_from%Type;

1356: IS
1357: -- Logging Infra
1358: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Default_Tax_Reg';
1359: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1360: l_effective_date zx_registrations.effective_from%Type;
1361: --p_error_buffer varchar2(200);
1362:
1363: Cursor Default_Reg IS
1364: Select NVL(reg.registration_number, PTP.rep_registration_number) registration_number

Line 1365: From zx_registrations reg

1361: --p_error_buffer varchar2(200);
1362:
1363: Cursor Default_Reg IS
1364: Select NVL(reg.registration_number, PTP.rep_registration_number) registration_number
1365: From zx_registrations reg
1366: ,zx_party_tax_profile ptp
1367: Where ptp.party_id = p_party_id
1368: AND ptp.party_type_code = p_party_type
1369: AND ptp.party_tax_profile_id = reg.party_tax_profile_id

Line 1491: p_registration_num IN ZX_REGISTRATIONS.Registration_Number%type,

1487:
1488: FUNCTION get_le_from_tax_registration
1489: (
1490: x_return_status OUT NOCOPY VARCHAR2,
1491: p_registration_num IN ZX_REGISTRATIONS.Registration_Number%type,
1492: p_effective_date IN ZX_REGISTRATIONS.effective_from%type,
1493: p_country IN ZX_PARTY_TAX_PROFILE.Country_code%type
1494: ) RETURN Number IS
1495: l_legal_entity_id NUMBER;

Line 1492: p_effective_date IN ZX_REGISTRATIONS.effective_from%type,

1488: FUNCTION get_le_from_tax_registration
1489: (
1490: x_return_status OUT NOCOPY VARCHAR2,
1491: p_registration_num IN ZX_REGISTRATIONS.Registration_Number%type,
1492: p_effective_date IN ZX_REGISTRATIONS.effective_from%type,
1493: p_country IN ZX_PARTY_TAX_PROFILE.Country_code%type
1494: ) RETURN Number IS
1495: l_legal_entity_id NUMBER;
1496: BEGIN

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

1496: BEGIN
1497: IF p_registration_num IS NOT NULL THEN
1498: SELECT distinct xle.legal_entity_id
1499: INTO l_legal_entity_id
1500: from zx_registrations tr, zx_party_tax_profile ptp, xle_etb_profiles xle
1501: where tr.registration_number = p_registration_num
1502: and tr.party_tax_profile_id = ptp.party_tax_profile_id
1503: and ptp.party_type_code = 'LEGAL_ESTABLISHMENT'
1504: and ptp.party_id = xle.party_id;