APPS.ZX_EVNT_OPTIONS_MIGRATE_PKG dependencies on ZX_EVNT_CLS_OPTIONS

Line 29: INSERT INTO ZX_EVNT_CLS_OPTIONS (

25: END IF;
26:
27: x_return_status := FND_API.G_RET_STS_SUCCESS;
28:
29: INSERT INTO ZX_EVNT_CLS_OPTIONS (
30: EVENT_CLASS_OPTIONS_ID,
31: APPLICATION_ID,
32: ENTITY_CODE,
33: EVENT_CLASS_CODE,

Line 69: SELECT ZX_EVNT_CLS_OPTIONS_S.nextval,

65: LAST_UPDATE_DATE,
66: LAST_UPDATED_BY,
67: LAST_UPDATE_LOGIN
68: )
69: SELECT ZX_EVNT_CLS_OPTIONS_S.nextval,
70: mapping.application_id,
71: mapping.entity_code,
72: mapping.event_class_code,
73: 'STCC',

Line 117: FROM ZX_EVNT_CLS_OPTIONS opt

113: -- AND sys.tolerance_id = tol.tolerance_id(+) -- Bug 5232304 --Bug 5117926
114: AND ptp.PARTY_TYPE_CODE ='OU'
115: AND ptp.record_type_code='MIGRATED' -- Bug 6837760
116: AND NOT EXISTS (SELECT 1
117: FROM ZX_EVNT_CLS_OPTIONS opt
118: WHERE opt.FIRST_PTY_ORG_ID = ptp.party_tax_profile_id
119: AND opt.APPLICATION_ID = mapping.application_id
120: AND opt.ENTITY_CODE = mapping.entity_code
121: AND opt.EVENT_CLASS_CODE = mapping.event_class_code

Line 153: INSERT INTO ZX_EVNT_CLS_OPTIONS (

149: END IF;
150:
151: x_return_status := FND_API.G_RET_STS_SUCCESS;
152:
153: INSERT INTO ZX_EVNT_CLS_OPTIONS (
154: EVENT_CLASS_OPTIONS_ID,
155: APPLICATION_ID,
156: ENTITY_CODE,
157: EVENT_CLASS_CODE,

Line 193: SELECT ZX_EVNT_CLS_OPTIONS_S.nextval,

189: LAST_UPDATE_DATE,
190: LAST_UPDATED_BY,
191: LAST_UPDATE_LOGIN
192: )
193: SELECT ZX_EVNT_CLS_OPTIONS_S.nextval,
194: mapping.application_id,
195: mapping.entity_code,
196: mapping.event_class_code,
197: decode(sys.tax_database_view_set,'_V','TAXREGIME','_A','TAXREGIME','STCC'), --Bug 5385949

Line 243: FROM ZX_EVNT_CLS_OPTIONS opt

239: AND decode(l_multi_org_flag,'N',l_org_id,sys.org_id) = ptp.party_id
240: AND ptp.PARTY_TYPE_CODE ='OU'
241: AND ptp.record_type_code='MIGRATED'
242: AND NOT EXISTS (SELECT 1
243: FROM ZX_EVNT_CLS_OPTIONS opt
244: WHERE opt.FIRST_PTY_ORG_ID = ptp.party_tax_profile_id
245: AND opt.APPLICATION_ID = mapping.application_id
246: AND opt.ENTITY_CODE = mapping.entity_code
247: AND opt.EVENT_CLASS_CODE = mapping.event_class_code

Line 280: INSERT INTO ZX_EVNT_CLS_OPTIONS (

276: END IF;
277:
278: x_return_status := FND_API.G_RET_STS_SUCCESS;
279:
280: INSERT INTO ZX_EVNT_CLS_OPTIONS (
281: EVENT_CLASS_OPTIONS_ID,
282: APPLICATION_ID,
283: ENTITY_CODE,
284: EVENT_CLASS_CODE,

Line 319: SELECT ZX_EVNT_CLS_OPTIONS_S.nextval,

315: LAST_UPDATE_DATE,
316: LAST_UPDATED_BY,
317: LAST_UPDATE_LOGIN
318: )
319: SELECT ZX_EVNT_CLS_OPTIONS_S.nextval,
320: mapping.application_id,
321: mapping.entity_code,
322: mapping.event_class_code,
323: 'STCC',

Line 366: FROM ZX_EVNT_CLS_OPTIONS opt

362: AND decode(l_multi_org_flag,'N',l_org_id,syspo.org_id) = decode(l_multi_org_flag,'N',l_org_id,sysap.org_id(+))
363: AND ptp.PARTY_TYPE_CODE ='OU'
364: AND ptp.record_type_code='MIGRATED'
365: AND NOT EXISTS (SELECT 1
366: FROM ZX_EVNT_CLS_OPTIONS opt
367: WHERE opt.FIRST_PTY_ORG_ID = ptp.party_tax_profile_id
368: AND opt.APPLICATION_ID = mapping.application_id
369: AND opt.ENTITY_CODE = mapping.entity_code
370: AND opt.EVENT_CLASS_CODE = mapping.event_class_code