DBA Data[Home] [Help]

APPS.ZX_DEFAULT_AUTOMATION_PKG dependencies on XLE_FIRSTPARTY_INFORMATION_V

Line 383: l_country_code XLE_FIRSTPARTY_INFORMATION_V.COUNTRY%TYPE;

379: p_taxation_country IN VARCHAR2,
380: p_document_sub_type IN VARCHAR2,
381: x_return_status OUT NOCOPY VARCHAR2 )
382: IS
383: l_country_code XLE_FIRSTPARTY_INFORMATION_V.COUNTRY%TYPE;
384: l_trx_business_category VARCHAR2(240);
385: l_product_category ZX_FC_COUNTRY_DEFAULTS.PRODUCT_CATEG_DEFAULT%TYPE;
386: l_product_fisc_class ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE;
387: l_intended_use ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE;

Line 1386: l_country_code XLE_FIRSTPARTY_INFORMATION_V.COUNTRY%TYPE;

1382: l_tax_classification_code VARCHAR2(150);
1383: l_effective_from DATE;
1384: l_effective_to DATE;
1385:
1386: l_country_code XLE_FIRSTPARTY_INFORMATION_V.COUNTRY%TYPE;
1387: l_fnd_return BOOLEAN;
1388: l_inv_flag VARCHAR2(30);
1389: l_inv_industry VARCHAR2(30);
1390: l_temp_attribute1 mtl_system_items_b.global_attribute1%TYPE;

Line 1642: l_country_code XLE_FIRSTPARTY_INFORMATION_V.COUNTRY%TYPE;

1638: x_return_status OUT NOCOPY VARCHAR2
1639: )
1640: IS
1641: l_api_name CONSTANT VARCHAR2(30) := 'GET_DEFAULT_COUNTRY_CODE';
1642: l_country_code XLE_FIRSTPARTY_INFORMATION_V.COUNTRY%TYPE;
1643:
1644: BEGIN
1645:
1646: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1690: FROM XLE_FIRSTPARTY_INFORMATION_V le

1686: ELSE
1687:
1688: BEGIN
1689: SELECT le.country INTO l_country_code
1690: FROM XLE_FIRSTPARTY_INFORMATION_V le
1691: WHERE le.legal_entity_id = p_legal_entity_id;
1692: EXCEPTION
1693: WHEN NO_DATA_FOUND THEN
1694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;