DBA Data[Home] [Help]

APPS.ZX_DEFAULT_AUTOMATION_PKG dependencies on XLE_FIRSTPARTY_INFORMATION_V

Line 192: l_country_code XLE_FIRSTPARTY_INFORMATION_V.COUNTRY%TYPE;

188: p_taxation_country IN VARCHAR2,
189: p_document_sub_type IN VARCHAR2,
190: x_return_status OUT NOCOPY VARCHAR2 )
191: IS
192: l_country_code XLE_FIRSTPARTY_INFORMATION_V.COUNTRY%TYPE;
193: l_trx_business_category VARCHAR2(240);
194: l_product_category ZX_FC_COUNTRY_DEFAULTS.PRODUCT_CATEG_DEFAULT%TYPE;
195: l_product_fisc_class ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE;
196: l_intended_use ZX_FC_TYPES_B.CLASSIFICATION_TYPE_CODE%TYPE;

Line 1178: l_country_code XLE_FIRSTPARTY_INFORMATION_V.COUNTRY%TYPE;

1174: l_tax_classification_code VARCHAR2(150);
1175: l_effective_from DATE;
1176: l_effective_to DATE;
1177:
1178: l_country_code XLE_FIRSTPARTY_INFORMATION_V.COUNTRY%TYPE;
1179: l_fnd_return BOOLEAN;
1180: l_inv_flag VARCHAR2(30);
1181: l_inv_industry VARCHAR2(30);
1182: l_temp_attribute1 mtl_system_items_b.global_attribute1%TYPE;

Line 1434: l_country_code XLE_FIRSTPARTY_INFORMATION_V.COUNTRY%TYPE;

1430: x_return_status OUT NOCOPY VARCHAR2
1431: )
1432: IS
1433: l_api_name CONSTANT VARCHAR2(30) := 'GET_DEFAULT_COUNTRY_CODE';
1434: l_country_code XLE_FIRSTPARTY_INFORMATION_V.COUNTRY%TYPE;
1435:
1436: BEGIN
1437:
1438: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1482: FROM XLE_FIRSTPARTY_INFORMATION_V le

1478: ELSE
1479:
1480: BEGIN
1481: SELECT le.country INTO l_country_code
1482: FROM XLE_FIRSTPARTY_INFORMATION_V le
1483: WHERE le.legal_entity_id = p_legal_entity_id;
1484: EXCEPTION
1485: WHEN NO_DATA_FOUND THEN
1486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;