DBA Data[Home] [Help]

APPS.ZX_TAX_CONTENT_UPLOAD dependencies on ZX_CONTENT_SOURCES

Line 5301: FROM ZX_CONTENT_SOURCES

5297: b_ptp_id NUMBER,
5298: b_regime_code VARCHAR2
5299: ) IS
5300: SELECT NVL(VERSION_LOADED,'0')
5301: FROM ZX_CONTENT_SOURCES
5302: WHERE PROVIDER_ID = b_ptp_id
5303: AND STANDARD_REGIME_CODE = b_regime_code;
5304:
5305: l_migrated_tax_regime_flag VARCHAR2(1);

Line 5685: UPDATE ZX_CONTENT_SOURCES

5681: END IF;
5682: l_file_start := l_position + 1;
5683: END LOOP;
5684:
5685: UPDATE ZX_CONTENT_SOURCES
5686: SET PROVIDER_REGIME_CODE = p_tax_regime_code,
5687: PROVIDER_REGIME_NAME = l_tax_regime_name,
5688: LANGUAGE = USERENV('LANG'),
5689: COUNTRY_CODE = l_country_code,

Line 5701: INSERT INTO ZX_CONTENT_SOURCES

5697: AND STANDARD_REGIME_CODE = p_tax_regime_code;
5698:
5699: IF (SQL%ROWCOUNT = 0)
5700: THEN
5701: INSERT INTO ZX_CONTENT_SOURCES
5702: (
5703: PROVIDER_ID,
5704: PROVIDER_REGIME_CODE,
5705: PROVIDER_REGIME_NAME,