[Home] [Help]
710: 'HEADER','L','LINE')),
711: 'Y',
712: decode(e.level_code,'H','HEADER_MLS','L','LINE_MLS'))
713: source_level_code
714: FROM xla_event_sources e, xla_sources_b s
715: WHERE e.source_application_id = s.application_id
716: AND e.source_code = s.source_code
717: AND e.source_type_code = s.source_type_code
718: AND e.application_id = p_application_id
3199: AND s.event_class_code = p_event_class_code
3200: AND s.source_application_id = p_application_id
3201: AND s.source_type_code = 'S'
3202: AND NOT EXISTS (SELECT 'x'
3203: FROM xla_event_sources e
3204: WHERE e.application_id = s.application_id
3205: AND e.event_class_code = s.event_class_code
3206: AND e.source_application_id = s.source_application_id
3207: AND e.source_type_code = s.source_type_code
4311: -- Assign sources at header level to the event class
4312: -- for header extract objects that are always populated
4313: -- Added and commented for bug 15938563
4314: /*
4315: INSERT INTO xla_event_sources
4316: (source_code
4317: ,application_id
4318: ,entity_code
4319: ,event_class_code
4348: AND e.entity_code = p_entity_code
4349: AND e.event_class_code = p_event_class_code
4350: AND e.always_populated_flag = 'Y'
4351: AND NOT EXISTS (SELECT 'x'
4352: FROM xla_event_sources s
4353: WHERE s.application_id = p_application_id
4354: AND s.entity_code = p_entity_code
4355: AND s.event_class_code = p_event_class_code
4356: AND s.source_application_id = p_application_id
4357: AND s.source_code = c.column_name));
4358:
4359: -- Assign sources at header level to the event class
4360: -- for header reference objects that are always populated
4361: INSERT INTO xla_event_sources
4362: (source_code
4363: ,application_id
4364: ,entity_code
4365: ,event_class_code
4399: AND r.entity_code = p_entity_code
4400: AND r.event_class_code = p_event_class_code
4401: AND r.always_populated_flag = 'Y'
4402: AND NOT EXISTS (SELECT 'x'
4403: FROM xla_event_sources s
4404: WHERE s.application_id = p_application_id
4405: AND s.entity_code = p_entity_code
4406: AND s.event_class_code = p_event_class_code
4407: AND s.source_application_id = r.reference_object_appl_id
4408: AND s.source_code = c.column_name));
4409:
4410: -- Assign sources at line level to the event class
4411: -- for line extract objects that are always populated
4412: INSERT INTO xla_event_sources
4413: (source_code
4414: ,application_id
4415: ,entity_code
4416: ,event_class_code
4445: AND e.entity_code = p_entity_code
4446: AND e.event_class_code = p_event_class_code
4447: AND e.always_populated_flag = 'Y'
4448: AND NOT EXISTS (SELECT 'x'
4449: FROM xla_event_sources s
4450: WHERE s.application_id = p_application_id
4451: AND s.entity_code = p_entity_code
4452: AND s.event_class_code = p_event_class_code
4453: AND s.source_application_id = p_application_id
4454: AND s.source_code = c.column_name));
4455:
4456: -- Assign sources at line level to the event class
4457: -- for line reference objects that are always populated
4458: INSERT INTO xla_event_sources
4459: (source_code
4460: ,application_id
4461: ,entity_code
4462: ,event_class_code
4496: AND r.entity_code = p_entity_code
4497: AND r.event_class_code = p_event_class_code
4498: AND r.always_populated_flag = 'Y'
4499: AND NOT EXISTS (SELECT 'x'
4500: FROM xla_event_sources s
4501: WHERE s.application_id = p_application_id
4502: AND s.entity_code = p_entity_code
4503: AND s.event_class_code = p_event_class_code
4504: AND s.source_application_id = r.reference_object_appl_id
4505: AND s.source_code = c.column_name));
4506:
4507: -- Assign sources at header level to the event class
4508: -- for header extract objects that are not always populated
4509: INSERT INTO xla_event_sources
4510: (source_code
4511: ,application_id
4512: ,entity_code
4513: ,event_class_code
4542: AND e.entity_code = p_entity_code
4543: AND e.event_class_code = p_event_class_code
4544: AND e.always_populated_flag = 'N'
4545: AND NOT EXISTS (SELECT 'x'
4546: FROM xla_event_sources s
4547: WHERE s.application_id = p_application_id
4548: AND s.entity_code = p_entity_code
4549: AND s.event_class_code = p_event_class_code
4550: AND s.source_application_id = p_application_id
4551: AND s.source_code = c.column_name));
4552:
4553: -- Assign sources at header level to the event class
4554: -- for header reference objects that are not always populated
4555: INSERT INTO xla_event_sources
4556: (source_code
4557: ,application_id
4558: ,entity_code
4559: ,event_class_code
4593: AND r.entity_code = p_entity_code
4594: AND r.event_class_code = p_event_class_code
4595: AND r.always_populated_flag = 'N'
4596: AND NOT EXISTS (SELECT 'x'
4597: FROM xla_event_sources s
4598: WHERE s.application_id = p_application_id
4599: AND s.entity_code = p_entity_code
4600: AND s.event_class_code = p_event_class_code
4601: AND s.source_application_id = r.reference_object_appl_id
4602: AND s.source_code = c.column_name));
4603:
4604: -- Assign sources at line level to the event class
4605: -- for line extract objects that are not always populated
4606: INSERT INTO xla_event_sources
4607: (source_code
4608: ,application_id
4609: ,entity_code
4610: ,event_class_code
4639: AND e.entity_code = p_entity_code
4640: AND e.event_class_code = p_event_class_code
4641: AND e.always_populated_flag = 'N'
4642: AND NOT EXISTS (SELECT 'x'
4643: FROM xla_event_sources s
4644: WHERE s.application_id = p_application_id
4645: AND s.entity_code = p_entity_code
4646: AND s.event_class_code = p_event_class_code
4647: AND s.source_application_id = p_application_id
4648: AND s.source_code = c.column_name));
4649:
4650: -- Assign sources at line level to the event class
4651: -- for line extract objects that are not always populated
4652: INSERT INTO xla_event_sources
4653: (source_code
4654: ,application_id
4655: ,entity_code
4656: ,event_class_code
4690: AND r.entity_code = p_entity_code
4691: AND r.event_class_code = p_event_class_code
4692: AND r.always_populated_flag = 'N'
4693: AND NOT EXISTS (SELECT 'x'
4694: FROM xla_event_sources s
4695: WHERE s.application_id = p_application_id
4696: AND s.entity_code = p_entity_code
4697: AND s.event_class_code = p_event_class_code
4698: AND s.source_application_id = r.reference_object_appl_id
4698: AND s.source_application_id = r.reference_object_appl_id
4699: AND s.source_code = c.column_name)); */
4700: -- Assign sources at header level to the event class
4701: -- for header extract objects that are always populated
4702: INSERT INTO xla_event_sources
4703: (source_code
4704: ,application_id
4705: ,entity_code
4706: ,event_class_code
4737: AND e.entity_code = p_entity_code
4738: AND e.event_class_code = p_event_class_code
4739: AND e.always_populated_flag = 'Y'
4740: AND NOT EXISTS (SELECT 'x'
4741: FROM xla_event_sources s
4742: WHERE s.application_id = p_application_id
4743: AND s.entity_code = p_entity_code
4744: AND s.event_class_code = p_event_class_code
4745: AND s.source_application_id = p_application_id
4771: AND e.entity_code = p_entity_code
4772: AND e.event_class_code = p_event_class_code
4773: AND e.always_populated_flag = 'Y'
4774: AND NOT EXISTS (SELECT 'x'
4775: FROM xla_event_sources s
4776: WHERE s.application_id = p_application_id
4777: AND s.entity_code = p_entity_code
4778: AND s.event_class_code = p_event_class_code
4779: AND s.source_application_id = p_application_id
4780: AND s.source_code = c.column_name));
4781:
4782: -- Assign sources at header level to the event class
4783: -- for header reference objects that are always populated
4784: INSERT INTO xla_event_sources
4785: (source_code
4786: ,application_id
4787: ,entity_code
4788: ,event_class_code
4824: AND r.entity_code = p_entity_code
4825: AND r.event_class_code = p_event_class_code
4826: AND r.always_populated_flag = 'Y'
4827: AND NOT EXISTS (SELECT 'x'
4828: FROM xla_event_sources s
4829: WHERE s.application_id = p_application_id
4830: AND s.entity_code = p_entity_code
4831: AND s.event_class_code = p_event_class_code
4832: AND s.source_application_id = r.reference_object_appl_id
4861: AND r.entity_code = p_entity_code
4862: AND r.event_class_code = p_event_class_code
4863: AND r.always_populated_flag = 'Y'
4864: AND NOT EXISTS (SELECT 'x'
4865: FROM xla_event_sources s
4866: WHERE s.application_id = p_application_id
4867: AND s.entity_code = p_entity_code
4868: AND s.event_class_code = p_event_class_code
4869: AND s.source_application_id = r.reference_object_appl_id
4870: AND s.source_code = c.column_name));
4871:
4872: -- Assign sources at line level to the event class
4873: -- for line extract objects that are always populated
4874: INSERT INTO xla_event_sources
4875: (source_code
4876: ,application_id
4877: ,entity_code
4878: ,event_class_code
4909: AND e.entity_code = p_entity_code
4910: AND e.event_class_code = p_event_class_code
4911: AND e.always_populated_flag = 'Y'
4912: AND NOT EXISTS (SELECT 'x'
4913: FROM xla_event_sources s
4914: WHERE s.application_id = p_application_id
4915: AND s.entity_code = p_entity_code
4916: AND s.event_class_code = p_event_class_code
4917: AND s.source_application_id = p_application_id
4943: AND e.entity_code = p_entity_code
4944: AND e.event_class_code = p_event_class_code
4945: AND e.always_populated_flag = 'Y'
4946: AND NOT EXISTS (SELECT 'x'
4947: FROM xla_event_sources s
4948: WHERE s.application_id = p_application_id
4949: AND s.entity_code = p_entity_code
4950: AND s.event_class_code = p_event_class_code
4951: AND s.source_application_id = p_application_id
4952: AND s.source_code = c.column_name));
4953:
4954: -- Assign sources at line level to the event class
4955: -- for line reference objects that are always populated
4956: INSERT INTO xla_event_sources
4957: (source_code
4958: ,application_id
4959: ,entity_code
4960: ,event_class_code
4996: AND r.entity_code = p_entity_code
4997: AND r.event_class_code = p_event_class_code
4998: AND r.always_populated_flag = 'Y'
4999: AND NOT EXISTS (SELECT 'x'
5000: FROM xla_event_sources s
5001: WHERE s.application_id = p_application_id
5002: AND s.entity_code = p_entity_code
5003: AND s.event_class_code = p_event_class_code
5004: AND s.source_application_id = r.reference_object_appl_id
5034: AND r.entity_code = p_entity_code
5035: AND r.event_class_code = p_event_class_code
5036: AND r.always_populated_flag = 'Y'
5037: AND NOT EXISTS (SELECT 'x'
5038: FROM xla_event_sources s
5039: WHERE s.application_id = p_application_id
5040: AND s.entity_code = p_entity_code
5041: AND s.event_class_code = p_event_class_code
5042: AND s.source_application_id = r.reference_object_appl_id
5043: AND s.source_code = c.column_name));
5044:
5045: -- Assign sources at header level to the event class
5046: -- for header extract objects that are not always populated
5047: INSERT INTO xla_event_sources
5048: (source_code
5049: ,application_id
5050: ,entity_code
5051: ,event_class_code
5082: AND e.entity_code = p_entity_code
5083: AND e.event_class_code = p_event_class_code
5084: AND e.always_populated_flag = 'N'
5085: AND NOT EXISTS (SELECT 'x'
5086: FROM xla_event_sources s
5087: WHERE s.application_id = p_application_id
5088: AND s.entity_code = p_entity_code
5089: AND s.event_class_code = p_event_class_code
5090: AND s.source_application_id = p_application_id
5116: AND e.entity_code = p_entity_code
5117: AND e.event_class_code = p_event_class_code
5118: AND e.always_populated_flag = 'N'
5119: AND NOT EXISTS (SELECT 'x'
5120: FROM xla_event_sources s
5121: WHERE s.application_id = p_application_id
5122: AND s.entity_code = p_entity_code
5123: AND s.event_class_code = p_event_class_code
5124: AND s.source_application_id = p_application_id
5125: AND s.source_code = c.column_name));
5126:
5127: -- Assign sources at header level to the event class
5128: -- for header reference objects that are not always populated
5129: INSERT INTO xla_event_sources
5130: (source_code
5131: ,application_id
5132: ,entity_code
5133: ,event_class_code
5169: AND r.entity_code = p_entity_code
5170: AND r.event_class_code = p_event_class_code
5171: AND r.always_populated_flag = 'N'
5172: AND NOT EXISTS (SELECT 'x'
5173: FROM xla_event_sources s
5174: WHERE s.application_id = p_application_id
5175: AND s.entity_code = p_entity_code
5176: AND s.event_class_code = p_event_class_code
5177: AND s.source_application_id = r.reference_object_appl_id
5208: AND r.entity_code = p_entity_code
5209: AND r.event_class_code = p_event_class_code
5210: AND r.always_populated_flag = 'N'
5211: AND NOT EXISTS (SELECT 'x'
5212: FROM xla_event_sources s
5213: WHERE s.application_id = p_application_id
5214: AND s.entity_code = p_entity_code
5215: AND s.event_class_code = p_event_class_code
5216: AND s.source_application_id = r.reference_object_appl_id
5217: AND s.source_code = c.column_name));
5218:
5219: -- Assign sources at line level to the event class
5220: -- for line extract objects that are not always populated
5221: INSERT INTO xla_event_sources
5222: (source_code
5223: ,application_id
5224: ,entity_code
5225: ,event_class_code
5256: AND e.entity_code = p_entity_code
5257: AND e.event_class_code = p_event_class_code
5258: AND e.always_populated_flag = 'N'
5259: AND NOT EXISTS (SELECT 'x'
5260: FROM xla_event_sources s
5261: WHERE s.application_id = p_application_id
5262: AND s.entity_code = p_entity_code
5263: AND s.event_class_code = p_event_class_code
5264: AND s.source_application_id = p_application_id
5290: AND e.entity_code = p_entity_code
5291: AND e.event_class_code = p_event_class_code
5292: AND e.always_populated_flag = 'N'
5293: AND NOT EXISTS (SELECT 'x'
5294: FROM xla_event_sources s
5295: WHERE s.application_id = p_application_id
5296: AND s.entity_code = p_entity_code
5297: AND s.event_class_code = p_event_class_code
5298: AND s.source_application_id = p_application_id
5299: AND s.source_code = c.column_name));
5300:
5301: -- Assign sources at line level to the event class
5302: -- for line extract objects that are not always populated
5303: INSERT INTO xla_event_sources
5304: (source_code
5305: ,application_id
5306: ,entity_code
5307: ,event_class_code
5343: AND r.entity_code = p_entity_code
5344: AND r.event_class_code = p_event_class_code
5345: AND r.always_populated_flag = 'N'
5346: AND NOT EXISTS (SELECT 'x'
5347: FROM xla_event_sources s
5348: WHERE s.application_id = p_application_id
5349: AND s.entity_code = p_entity_code
5350: AND s.event_class_code = p_event_class_code
5351: AND s.source_application_id = r.reference_object_appl_id
5383: AND r.entity_code = p_entity_code
5384: AND r.event_class_code = p_event_class_code
5385: AND r.always_populated_flag = 'N'
5386: AND NOT EXISTS (SELECT 'x'
5387: FROM xla_event_sources s
5388: WHERE s.application_id = p_application_id
5389: AND s.entity_code = p_entity_code
5390: AND s.event_class_code = p_event_class_code
5391: AND s.source_application_id = r.reference_object_appl_id