DBA Data[Home] [Help]

APPS.ZX_TAX_CONTENT_UPLOAD dependencies on ZX_CONTENT_SOURCES

Line 5800: FROM ZX_CONTENT_SOURCES

5796: b_ptp_id NUMBER,
5797: b_regime_code VARCHAR2
5798: ) IS
5799: SELECT NVL(VERSION_LOADED,'0')
5800: FROM ZX_CONTENT_SOURCES
5801: WHERE PROVIDER_ID = b_ptp_id
5802: AND STANDARD_REGIME_CODE = b_regime_code;
5803:
5804: CURSOR c_chk_ptp_party

Line 6211: UPDATE ZX_CONTENT_SOURCES

6207: END IF;
6208: l_file_start := l_position + 1;
6209: END LOOP;
6210:
6211: UPDATE ZX_CONTENT_SOURCES
6212: SET PROVIDER_REGIME_CODE = p_tax_regime_code,
6213: PROVIDER_REGIME_NAME = l_tax_regime_name,
6214: LANGUAGE = USERENV('LANG'),
6215: COUNTRY_CODE = l_country_code,

Line 6227: INSERT INTO ZX_CONTENT_SOURCES

6223: AND STANDARD_REGIME_CODE = p_tax_regime_code;
6224:
6225: IF (SQL%ROWCOUNT = 0)
6226: THEN
6227: INSERT INTO ZX_CONTENT_SOURCES
6228: (
6229: PROVIDER_ID,
6230: PROVIDER_REGIME_CODE,
6231: PROVIDER_REGIME_NAME,