eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_AE_JOURNAL_ENTRY_PKG dependencies on XLA_AE_LINE_ACS

Line 157: | xla_ae_line_acs, if analytical criteria |

153: | 23-Sep-2008 Vijaya.G 7377888 Changes in AdjustMPALine procedure for |
154: | MPA Accounting |
155: | 03-Oct-2008 KARAMAKR 7382288 insert analytical criteria for |
156: | invoice cancellation event in |
157: | xla_ae_line_acs, if analytical criteria |
158: | for invoice validation event exists. |
159: | 31-Oct-2008 VGOPISET 7230462 Changes in GetLineNumber and AdjustMPALine|
160: | to stamp the correct Parent_AE_Line_Num for |
161: | complete MPA Accounting |

Line 3912: (p_msg => 'SQL - Insert into xla_ae_line_acs'

3908:
3909: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3910:
3911: trace
3912: (p_msg => 'SQL - Insert into xla_ae_line_acs'
3913: ,p_level => C_LEVEL_STATEMENT
3914: ,p_module => l_log_module);
3915:
3916: trace

Line 3957: (p_msg => '# line analytical criteria inserted into xla_ae_line_acs = '||l_rowcount

3953: l_rowcount := SQL%ROWCOUNT;
3954:
3955: IF (C_LEVEL_EVENT >= g_log_level) THEN
3956: trace
3957: (p_msg => '# line analytical criteria inserted into xla_ae_line_acs = '||l_rowcount
3958: ,p_level => C_LEVEL_EVENT
3959: ,p_module => l_log_module);
3960: END IF;
3961:

Line 4036: (p_msg => 'SQL - Insert into xla_ae_line_acs'

4032:
4033: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4034:
4035: trace
4036: (p_msg => 'SQL - Insert into xla_ae_line_acs'
4037: ,p_level => C_LEVEL_STATEMENT
4038: ,p_module => l_log_module);
4039:
4040: END IF;

Line 4044: INTO xla_ae_line_acs (

4040: END IF;
4041:
4042: INSERT ALL
4043: WHEN anc_id_1 IS NOT NULL and anc_id_1 not like 'DUMMY_ANC_%' THEN -- Bug 8691573
4044: INTO xla_ae_line_acs (
4045: ae_header_id , ae_line_num , object_version_number
4046: , analytical_criterion_code
4047: , analytical_criterion_type_code
4048: , amb_context_code

Line 4084: INTO xla_ae_line_acs (

4080: ,LENGTHB(anc_id_1))
4081: )
4082:
4083: WHEN anc_id_2 IS NOT NULL THEN
4084: INTO xla_ae_line_acs (
4085: ae_header_id , ae_line_num , object_version_number
4086: , analytical_criterion_code
4087: , analytical_criterion_type_code
4088: , amb_context_code

Line 4124: INTO xla_ae_line_acs (

4120: ,LENGTHB(anc_id_2))
4121: )
4122:
4123: WHEN anc_id_3 IS NOT NULL THEN
4124: INTO xla_ae_line_acs (
4125: ae_header_id , ae_line_num , object_version_number
4126: , analytical_criterion_code
4127: , analytical_criterion_type_code
4128: , amb_context_code

Line 4164: INTO xla_ae_line_acs (

4160: ,LENGTHB(anc_id_3))
4161: )
4162:
4163: WHEN anc_id_4 IS NOT NULL THEN
4164: INTO xla_ae_line_acs (
4165: ae_header_id , ae_line_num , object_version_number
4166: , analytical_criterion_code
4167: , analytical_criterion_type_code
4168: , amb_context_code

Line 4204: INTO xla_ae_line_acs (

4200: ,LENGTHB(anc_id_4))
4201: )
4202:
4203: WHEN anc_id_5 IS NOT NULL THEN
4204: INTO xla_ae_line_acs (
4205: ae_header_id , ae_line_num , object_version_number
4206: , analytical_criterion_code
4207: , analytical_criterion_type_code
4208: , amb_context_code

Line 4244: INTO xla_ae_line_acs (

4240: ,LENGTHB(anc_id_5))
4241: )
4242:
4243: WHEN anc_id_6 IS NOT NULL THEN
4244: INTO xla_ae_line_acs (
4245: ae_header_id , ae_line_num , object_version_number
4246: , analytical_criterion_code
4247: , analytical_criterion_type_code
4248: , amb_context_code

Line 4284: INTO xla_ae_line_acs (

4280: ,LENGTHB(anc_id_6))
4281: )
4282:
4283: WHEN anc_id_7 IS NOT NULL THEN
4284: INTO xla_ae_line_acs (
4285: ae_header_id , ae_line_num , object_version_number
4286: , analytical_criterion_code
4287: , analytical_criterion_type_code
4288: , amb_context_code

Line 4324: INTO xla_ae_line_acs (

4320: ,LENGTHB(anc_id_7))
4321: )
4322:
4323: WHEN anc_id_8 IS NOT NULL THEN
4324: INTO xla_ae_line_acs (
4325: ae_header_id , ae_line_num , object_version_number
4326: , analytical_criterion_code
4327: , analytical_criterion_type_code
4328: , amb_context_code

Line 4364: INTO xla_ae_line_acs (

4360: ,LENGTHB(anc_id_8))
4361: )
4362:
4363: WHEN anc_id_9 IS NOT NULL THEN
4364: INTO xla_ae_line_acs (
4365: ae_header_id , ae_line_num , object_version_number
4366: , analytical_criterion_code
4367: , analytical_criterion_type_code
4368: , amb_context_code

Line 4404: INTO xla_ae_line_acs (

4400: ,LENGTHB(anc_id_9))
4401: )
4402:
4403: WHEN anc_id_10 IS NOT NULL THEN
4404: INTO xla_ae_line_acs (
4405: ae_header_id , ae_line_num , object_version_number
4406: , analytical_criterion_code
4407: , analytical_criterion_type_code
4408: , amb_context_code

Line 4476: (p_msg => '# line analytical criteria inserted into xla_ae_line_acs = '||l_rowcount

4472: l_rowcount := SQL%ROWCOUNT;
4473:
4474: IF (C_LEVEL_EVENT >= g_log_level) THEN
4475: trace
4476: (p_msg => '# line analytical criteria inserted into xla_ae_line_acs = '||l_rowcount
4477: ,p_level => C_LEVEL_EVENT
4478: ,p_module => l_log_module);
4479: END IF;
4480:

Line 4555: (p_msg => 'SQL - Insert into xla_ae_line_acs'

4551:
4552: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4553:
4554: trace
4555: (p_msg => 'SQL - Insert into xla_ae_line_acs'
4556: ,p_level => C_LEVEL_STATEMENT
4557: ,p_module => l_log_module);
4558:
4559: END IF;

Line 4563: INTO xla_ae_line_acs (

4559: END IF;
4560:
4561: INSERT ALL
4562: WHEN anc_id_1 IS NOT NULL and anc_id_1 not like 'DUMMY_ANC_%' THEN --Bug 8691573
4563: INTO xla_ae_line_acs (
4564: ae_header_id , ae_line_num , object_version_number
4565: , analytical_criterion_code
4566: , analytical_criterion_type_code
4567: , amb_context_code

Line 4603: INTO xla_ae_line_acs (

4599: ,LENGTHB(anc_id_1))
4600: )
4601:
4602: WHEN anc_id_2 IS NOT NULL THEN
4603: INTO xla_ae_line_acs (
4604: ae_header_id , ae_line_num , object_version_number
4605: , analytical_criterion_code
4606: , analytical_criterion_type_code
4607: , amb_context_code

Line 4643: INTO xla_ae_line_acs (

4639: ,LENGTHB(anc_id_2))
4640: )
4641:
4642: WHEN anc_id_3 IS NOT NULL THEN
4643: INTO xla_ae_line_acs (
4644: ae_header_id , ae_line_num , object_version_number
4645: , analytical_criterion_code
4646: , analytical_criterion_type_code
4647: , amb_context_code

Line 4683: INTO xla_ae_line_acs (

4679: ,LENGTHB(anc_id_3))
4680: )
4681:
4682: WHEN anc_id_4 IS NOT NULL THEN
4683: INTO xla_ae_line_acs (
4684: ae_header_id , ae_line_num , object_version_number
4685: , analytical_criterion_code
4686: , analytical_criterion_type_code
4687: , amb_context_code

Line 4723: INTO xla_ae_line_acs (

4719: ,LENGTHB(anc_id_4))
4720: )
4721:
4722: WHEN anc_id_5 IS NOT NULL THEN
4723: INTO xla_ae_line_acs (
4724: ae_header_id , ae_line_num , object_version_number
4725: , analytical_criterion_code
4726: , analytical_criterion_type_code
4727: , amb_context_code

Line 4763: INTO xla_ae_line_acs (

4759: ,LENGTHB(anc_id_5))
4760: )
4761:
4762: WHEN anc_id_6 IS NOT NULL THEN
4763: INTO xla_ae_line_acs (
4764: ae_header_id , ae_line_num , object_version_number
4765: , analytical_criterion_code
4766: , analytical_criterion_type_code
4767: , amb_context_code

Line 4803: INTO xla_ae_line_acs (

4799: ,LENGTHB(anc_id_6))
4800: )
4801:
4802: WHEN anc_id_7 IS NOT NULL THEN
4803: INTO xla_ae_line_acs (
4804: ae_header_id , ae_line_num , object_version_number
4805: , analytical_criterion_code
4806: , analytical_criterion_type_code
4807: , amb_context_code

Line 4843: INTO xla_ae_line_acs (

4839: ,LENGTHB(anc_id_7))
4840: )
4841:
4842: WHEN anc_id_8 IS NOT NULL THEN
4843: INTO xla_ae_line_acs (
4844: ae_header_id , ae_line_num , object_version_number
4845: , analytical_criterion_code
4846: , analytical_criterion_type_code
4847: , amb_context_code

Line 4883: INTO xla_ae_line_acs (

4879: ,LENGTHB(anc_id_8))
4880: )
4881:
4882: WHEN anc_id_9 IS NOT NULL THEN
4883: INTO xla_ae_line_acs (
4884: ae_header_id , ae_line_num , object_version_number
4885: , analytical_criterion_code
4886: , analytical_criterion_type_code
4887: , amb_context_code

Line 4923: INTO xla_ae_line_acs (

4919: ,LENGTHB(anc_id_9))
4920: )
4921:
4922: WHEN anc_id_10 IS NOT NULL THEN
4923: INTO xla_ae_line_acs (
4924: ae_header_id , ae_line_num , object_version_number
4925: , analytical_criterion_code
4926: , analytical_criterion_type_code
4927: , amb_context_code

Line 4963: INTO xla_ae_line_acs (

4959: ,LENGTHB(anc_id_10))
4960: )
4961:
4962: WHEN anc_id_11 IS NOT NULL THEN
4963: INTO xla_ae_line_acs (
4964: ae_header_id , ae_line_num , object_version_number
4965: , analytical_criterion_code
4966: , analytical_criterion_type_code
4967: , amb_context_code

Line 5003: INTO xla_ae_line_acs (

4999: ,LENGTHB(anc_id_11))
5000: )
5001:
5002: WHEN anc_id_12 IS NOT NULL THEN
5003: INTO xla_ae_line_acs (
5004: ae_header_id , ae_line_num , object_version_number
5005: , analytical_criterion_code
5006: , analytical_criterion_type_code
5007: , amb_context_code

Line 5043: INTO xla_ae_line_acs (

5039: ,LENGTHB(anc_id_12))
5040: )
5041:
5042: WHEN anc_id_13 IS NOT NULL THEN
5043: INTO xla_ae_line_acs (
5044: ae_header_id , ae_line_num , object_version_number
5045: , analytical_criterion_code
5046: , analytical_criterion_type_code
5047: , amb_context_code

Line 5083: INTO xla_ae_line_acs (

5079: ,LENGTHB(anc_id_13))
5080: )
5081:
5082: WHEN anc_id_14 IS NOT NULL THEN
5083: INTO xla_ae_line_acs (
5084: ae_header_id , ae_line_num , object_version_number
5085: , analytical_criterion_code
5086: , analytical_criterion_type_code
5087: , amb_context_code

Line 5123: INTO xla_ae_line_acs (

5119: ,LENGTHB(anc_id_14))
5120: )
5121:
5122: WHEN anc_id_15 IS NOT NULL THEN
5123: INTO xla_ae_line_acs (
5124: ae_header_id , ae_line_num , object_version_number
5125: , analytical_criterion_code
5126: , analytical_criterion_type_code
5127: , amb_context_code

Line 5163: INTO xla_ae_line_acs (

5159: ,LENGTHB(anc_id_15))
5160: )
5161:
5162: WHEN anc_id_16 IS NOT NULL THEN
5163: INTO xla_ae_line_acs (
5164: ae_header_id , ae_line_num , object_version_number
5165: , analytical_criterion_code
5166: , analytical_criterion_type_code
5167: , amb_context_code

Line 5203: INTO xla_ae_line_acs (

5199: ,LENGTHB(anc_id_16))
5200: )
5201:
5202: WHEN anc_id_17 IS NOT NULL THEN
5203: INTO xla_ae_line_acs (
5204: ae_header_id , ae_line_num , object_version_number
5205: , analytical_criterion_code
5206: , analytical_criterion_type_code
5207: , amb_context_code

Line 5243: INTO xla_ae_line_acs (

5239: ,LENGTHB(anc_id_17))
5240: )
5241:
5242: WHEN anc_id_18 IS NOT NULL THEN
5243: INTO xla_ae_line_acs (
5244: ae_header_id , ae_line_num , object_version_number
5245: , analytical_criterion_code
5246: , analytical_criterion_type_code
5247: , amb_context_code

Line 5283: INTO xla_ae_line_acs (

5279: ,LENGTHB(anc_id_18))
5280: )
5281:
5282: WHEN anc_id_19 IS NOT NULL THEN
5283: INTO xla_ae_line_acs (
5284: ae_header_id , ae_line_num , object_version_number
5285: , analytical_criterion_code
5286: , analytical_criterion_type_code
5287: , amb_context_code

Line 5323: INTO xla_ae_line_acs (

5319: ,LENGTHB(anc_id_19))
5320: )
5321:
5322: WHEN anc_id_20 IS NOT NULL THEN
5323: INTO xla_ae_line_acs (
5324: ae_header_id , ae_line_num , object_version_number
5325: , analytical_criterion_code
5326: , analytical_criterion_type_code
5327: , amb_context_code

Line 5363: INTO xla_ae_line_acs (

5359: ,LENGTHB(anc_id_20))
5360: )
5361:
5362: WHEN anc_id_21 IS NOT NULL THEN
5363: INTO xla_ae_line_acs (
5364: ae_header_id , ae_line_num , object_version_number
5365: , analytical_criterion_code
5366: , analytical_criterion_type_code
5367: , amb_context_code

Line 5403: INTO xla_ae_line_acs (

5399: ,LENGTHB(anc_id_21))
5400: )
5401:
5402: WHEN anc_id_22 IS NOT NULL THEN
5403: INTO xla_ae_line_acs (
5404: ae_header_id , ae_line_num , object_version_number
5405: , analytical_criterion_code
5406: , analytical_criterion_type_code
5407: , amb_context_code

Line 5443: INTO xla_ae_line_acs (

5439: ,LENGTHB(anc_id_22))
5440: )
5441:
5442: WHEN anc_id_23 IS NOT NULL THEN
5443: INTO xla_ae_line_acs (
5444: ae_header_id , ae_line_num , object_version_number
5445: , analytical_criterion_code
5446: , analytical_criterion_type_code
5447: , amb_context_code

Line 5483: INTO xla_ae_line_acs (

5479: ,LENGTHB(anc_id_23))
5480: )
5481:
5482: WHEN anc_id_24 IS NOT NULL THEN
5483: INTO xla_ae_line_acs (
5484: ae_header_id , ae_line_num , object_version_number
5485: , analytical_criterion_code
5486: , analytical_criterion_type_code
5487: , amb_context_code

Line 5523: INTO xla_ae_line_acs (

5519: ,LENGTHB(anc_id_24))
5520: )
5521:
5522: WHEN anc_id_25 IS NOT NULL THEN
5523: INTO xla_ae_line_acs (
5524: ae_header_id , ae_line_num , object_version_number
5525: , analytical_criterion_code
5526: , analytical_criterion_type_code
5527: , amb_context_code

Line 5563: INTO xla_ae_line_acs (

5559: ,LENGTHB(anc_id_25))
5560: )
5561:
5562: WHEN anc_id_26 IS NOT NULL THEN
5563: INTO xla_ae_line_acs (
5564: ae_header_id , ae_line_num , object_version_number
5565: , analytical_criterion_code
5566: , analytical_criterion_type_code
5567: , amb_context_code

Line 5603: INTO xla_ae_line_acs (

5599: ,LENGTHB(anc_id_26))
5600: )
5601:
5602: WHEN anc_id_27 IS NOT NULL THEN
5603: INTO xla_ae_line_acs (
5604: ae_header_id , ae_line_num , object_version_number
5605: , analytical_criterion_code
5606: , analytical_criterion_type_code
5607: , amb_context_code

Line 5643: INTO xla_ae_line_acs (

5639: ,LENGTHB(anc_id_27))
5640: )
5641:
5642: WHEN anc_id_28 IS NOT NULL THEN
5643: INTO xla_ae_line_acs (
5644: ae_header_id , ae_line_num , object_version_number
5645: , analytical_criterion_code
5646: , analytical_criterion_type_code
5647: , amb_context_code

Line 5683: INTO xla_ae_line_acs (

5679: ,LENGTHB(anc_id_28))
5680: )
5681:
5682: WHEN anc_id_29 IS NOT NULL THEN
5683: INTO xla_ae_line_acs (
5684: ae_header_id , ae_line_num , object_version_number
5685: , analytical_criterion_code
5686: , analytical_criterion_type_code
5687: , amb_context_code

Line 5723: INTO xla_ae_line_acs (

5719: ,LENGTHB(anc_id_29))
5720: )
5721:
5722: WHEN anc_id_30 IS NOT NULL THEN
5723: INTO xla_ae_line_acs (
5724: ae_header_id , ae_line_num , object_version_number
5725: , analytical_criterion_code
5726: , analytical_criterion_type_code
5727: , amb_context_code

Line 5763: INTO xla_ae_line_acs (

5759: ,LENGTHB(anc_id_30))
5760: )
5761:
5762: WHEN anc_id_31 IS NOT NULL THEN
5763: INTO xla_ae_line_acs (
5764: ae_header_id , ae_line_num , object_version_number
5765: , analytical_criterion_code
5766: , analytical_criterion_type_code
5767: , amb_context_code

Line 5803: INTO xla_ae_line_acs (

5799: ,LENGTHB(anc_id_31))
5800: )
5801:
5802: WHEN anc_id_32 IS NOT NULL THEN
5803: INTO xla_ae_line_acs (
5804: ae_header_id , ae_line_num , object_version_number
5805: , analytical_criterion_code
5806: , analytical_criterion_type_code
5807: , amb_context_code

Line 5843: INTO xla_ae_line_acs (

5839: ,LENGTHB(anc_id_32))
5840: )
5841:
5842: WHEN anc_id_33 IS NOT NULL THEN
5843: INTO xla_ae_line_acs (
5844: ae_header_id , ae_line_num , object_version_number
5845: , analytical_criterion_code
5846: , analytical_criterion_type_code
5847: , amb_context_code

Line 5883: INTO xla_ae_line_acs (

5879: ,LENGTHB(anc_id_33))
5880: )
5881:
5882: WHEN anc_id_34 IS NOT NULL THEN
5883: INTO xla_ae_line_acs (
5884: ae_header_id , ae_line_num , object_version_number
5885: , analytical_criterion_code
5886: , analytical_criterion_type_code
5887: , amb_context_code

Line 5923: INTO xla_ae_line_acs (

5919: ,LENGTHB(anc_id_34))
5920: )
5921:
5922: WHEN anc_id_35 IS NOT NULL THEN
5923: INTO xla_ae_line_acs (
5924: ae_header_id , ae_line_num , object_version_number
5925: , analytical_criterion_code
5926: , analytical_criterion_type_code
5927: , amb_context_code

Line 5963: INTO xla_ae_line_acs (

5959: ,LENGTHB(anc_id_35))
5960: )
5961:
5962: WHEN anc_id_36 IS NOT NULL THEN
5963: INTO xla_ae_line_acs (
5964: ae_header_id , ae_line_num , object_version_number
5965: , analytical_criterion_code
5966: , analytical_criterion_type_code
5967: , amb_context_code

Line 6003: INTO xla_ae_line_acs (

5999: ,LENGTHB(anc_id_36))
6000: )
6001:
6002: WHEN anc_id_37 IS NOT NULL THEN
6003: INTO xla_ae_line_acs (
6004: ae_header_id , ae_line_num , object_version_number
6005: , analytical_criterion_code
6006: , analytical_criterion_type_code
6007: , amb_context_code

Line 6043: INTO xla_ae_line_acs (

6039: ,LENGTHB(anc_id_37))
6040: )
6041:
6042: WHEN anc_id_38 IS NOT NULL THEN
6043: INTO xla_ae_line_acs (
6044: ae_header_id , ae_line_num , object_version_number
6045: , analytical_criterion_code
6046: , analytical_criterion_type_code
6047: , amb_context_code

Line 6083: INTO xla_ae_line_acs (

6079: ,LENGTHB(anc_id_38))
6080: )
6081:
6082: WHEN anc_id_39 IS NOT NULL THEN
6083: INTO xla_ae_line_acs (
6084: ae_header_id , ae_line_num , object_version_number
6085: , analytical_criterion_code
6086: , analytical_criterion_type_code
6087: , amb_context_code

Line 6123: INTO xla_ae_line_acs (

6119: ,LENGTHB(anc_id_39))
6120: )
6121:
6122: WHEN anc_id_40 IS NOT NULL THEN
6123: INTO xla_ae_line_acs (
6124: ae_header_id , ae_line_num , object_version_number
6125: , analytical_criterion_code
6126: , analytical_criterion_type_code
6127: , amb_context_code

Line 6163: INTO xla_ae_line_acs (

6159: ,LENGTHB(anc_id_40))
6160: )
6161:
6162: WHEN anc_id_41 IS NOT NULL THEN
6163: INTO xla_ae_line_acs (
6164: ae_header_id , ae_line_num , object_version_number
6165: , analytical_criterion_code
6166: , analytical_criterion_type_code
6167: , amb_context_code

Line 6203: INTO xla_ae_line_acs (

6199: ,LENGTHB(anc_id_41))
6200: )
6201:
6202: WHEN anc_id_42 IS NOT NULL THEN
6203: INTO xla_ae_line_acs (
6204: ae_header_id , ae_line_num , object_version_number
6205: , analytical_criterion_code
6206: , analytical_criterion_type_code
6207: , amb_context_code

Line 6243: INTO xla_ae_line_acs (

6239: ,LENGTHB(anc_id_42))
6240: )
6241:
6242: WHEN anc_id_43 IS NOT NULL THEN
6243: INTO xla_ae_line_acs (
6244: ae_header_id , ae_line_num , object_version_number
6245: , analytical_criterion_code
6246: , analytical_criterion_type_code
6247: , amb_context_code

Line 6283: INTO xla_ae_line_acs (

6279: ,LENGTHB(anc_id_43))
6280: )
6281:
6282: WHEN anc_id_44 IS NOT NULL THEN
6283: INTO xla_ae_line_acs (
6284: ae_header_id , ae_line_num , object_version_number
6285: , analytical_criterion_code
6286: , analytical_criterion_type_code
6287: , amb_context_code

Line 6323: INTO xla_ae_line_acs (

6319: ,LENGTHB(anc_id_44))
6320: )
6321:
6322: WHEN anc_id_45 IS NOT NULL THEN
6323: INTO xla_ae_line_acs (
6324: ae_header_id , ae_line_num , object_version_number
6325: , analytical_criterion_code
6326: , analytical_criterion_type_code
6327: , amb_context_code

Line 6363: INTO xla_ae_line_acs (

6359: ,LENGTHB(anc_id_45))
6360: )
6361:
6362: WHEN anc_id_46 IS NOT NULL THEN
6363: INTO xla_ae_line_acs (
6364: ae_header_id , ae_line_num , object_version_number
6365: , analytical_criterion_code
6366: , analytical_criterion_type_code
6367: , amb_context_code

Line 6403: INTO xla_ae_line_acs (

6399: ,LENGTHB(anc_id_46))
6400: )
6401:
6402: WHEN anc_id_47 IS NOT NULL THEN
6403: INTO xla_ae_line_acs (
6404: ae_header_id , ae_line_num , object_version_number
6405: , analytical_criterion_code
6406: , analytical_criterion_type_code
6407: , amb_context_code

Line 6443: INTO xla_ae_line_acs (

6439: ,LENGTHB(anc_id_47))
6440: )
6441:
6442: WHEN anc_id_48 IS NOT NULL THEN
6443: INTO xla_ae_line_acs (
6444: ae_header_id , ae_line_num , object_version_number
6445: , analytical_criterion_code
6446: , analytical_criterion_type_code
6447: , amb_context_code

Line 6483: INTO xla_ae_line_acs (

6479: ,LENGTHB(anc_id_48))
6480: )
6481:
6482: WHEN anc_id_49 IS NOT NULL THEN
6483: INTO xla_ae_line_acs (
6484: ae_header_id , ae_line_num , object_version_number
6485: , analytical_criterion_code
6486: , analytical_criterion_type_code
6487: , amb_context_code

Line 6523: INTO xla_ae_line_acs (

6519: ,LENGTHB(anc_id_49))
6520: )
6521:
6522: WHEN anc_id_50 IS NOT NULL THEN
6523: INTO xla_ae_line_acs (
6524: ae_header_id , ae_line_num , object_version_number
6525: , analytical_criterion_code
6526: , analytical_criterion_type_code
6527: , amb_context_code

Line 6676: (p_msg => '# line analytical criteria inserted into xla_ae_line_acs = '||l_rowcount

6672: l_rowcount := SQL%ROWCOUNT;
6673:
6674: IF (C_LEVEL_EVENT >= g_log_level) THEN
6675: trace
6676: (p_msg => '# line analytical criteria inserted into xla_ae_line_acs = '||l_rowcount
6677: ,p_level => C_LEVEL_EVENT
6678: ,p_module => l_log_module);
6679: END IF;
6680:

Line 6755: (p_msg => 'SQL - Insert into xla_ae_line_acs'

6751:
6752: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6753:
6754: trace
6755: (p_msg => 'SQL - Insert into xla_ae_line_acs'
6756: ,p_level => C_LEVEL_STATEMENT
6757: ,p_module => l_log_module);
6758:
6759: END IF;

Line 6763: INTO xla_ae_line_acs (

6759: END IF;
6760:
6761: INSERT ALL
6762: WHEN anc_id_1 IS NOT NULL and anc_id_1 not like 'DUMMY_ANC_%' THEN --Bug 8691573
6763: INTO xla_ae_line_acs (
6764: ae_header_id , ae_line_num , object_version_number
6765: , analytical_criterion_code
6766: , analytical_criterion_type_code
6767: , amb_context_code

Line 6803: INTO xla_ae_line_acs (

6799: ,LENGTHB(anc_id_1))
6800: )
6801:
6802: WHEN anc_id_2 IS NOT NULL THEN
6803: INTO xla_ae_line_acs (
6804: ae_header_id , ae_line_num , object_version_number
6805: , analytical_criterion_code
6806: , analytical_criterion_type_code
6807: , amb_context_code

Line 6843: INTO xla_ae_line_acs (

6839: ,LENGTHB(anc_id_2))
6840: )
6841:
6842: WHEN anc_id_3 IS NOT NULL THEN
6843: INTO xla_ae_line_acs (
6844: ae_header_id , ae_line_num , object_version_number
6845: , analytical_criterion_code
6846: , analytical_criterion_type_code
6847: , amb_context_code

Line 6883: INTO xla_ae_line_acs (

6879: ,LENGTHB(anc_id_3))
6880: )
6881:
6882: WHEN anc_id_4 IS NOT NULL THEN
6883: INTO xla_ae_line_acs (
6884: ae_header_id , ae_line_num , object_version_number
6885: , analytical_criterion_code
6886: , analytical_criterion_type_code
6887: , amb_context_code

Line 6923: INTO xla_ae_line_acs (

6919: ,LENGTHB(anc_id_4))
6920: )
6921:
6922: WHEN anc_id_5 IS NOT NULL THEN
6923: INTO xla_ae_line_acs (
6924: ae_header_id , ae_line_num , object_version_number
6925: , analytical_criterion_code
6926: , analytical_criterion_type_code
6927: , amb_context_code

Line 6963: INTO xla_ae_line_acs (

6959: ,LENGTHB(anc_id_5))
6960: )
6961:
6962: WHEN anc_id_6 IS NOT NULL THEN
6963: INTO xla_ae_line_acs (
6964: ae_header_id , ae_line_num , object_version_number
6965: , analytical_criterion_code
6966: , analytical_criterion_type_code
6967: , amb_context_code

Line 7003: INTO xla_ae_line_acs (

6999: ,LENGTHB(anc_id_6))
7000: )
7001:
7002: WHEN anc_id_7 IS NOT NULL THEN
7003: INTO xla_ae_line_acs (
7004: ae_header_id , ae_line_num , object_version_number
7005: , analytical_criterion_code
7006: , analytical_criterion_type_code
7007: , amb_context_code

Line 7043: INTO xla_ae_line_acs (

7039: ,LENGTHB(anc_id_7))
7040: )
7041:
7042: WHEN anc_id_8 IS NOT NULL THEN
7043: INTO xla_ae_line_acs (
7044: ae_header_id , ae_line_num , object_version_number
7045: , analytical_criterion_code
7046: , analytical_criterion_type_code
7047: , amb_context_code

Line 7083: INTO xla_ae_line_acs (

7079: ,LENGTHB(anc_id_8))
7080: )
7081:
7082: WHEN anc_id_9 IS NOT NULL THEN
7083: INTO xla_ae_line_acs (
7084: ae_header_id , ae_line_num , object_version_number
7085: , analytical_criterion_code
7086: , analytical_criterion_type_code
7087: , amb_context_code

Line 7123: INTO xla_ae_line_acs (

7119: ,LENGTHB(anc_id_9))
7120: )
7121:
7122: WHEN anc_id_10 IS NOT NULL THEN
7123: INTO xla_ae_line_acs (
7124: ae_header_id , ae_line_num , object_version_number
7125: , analytical_criterion_code
7126: , analytical_criterion_type_code
7127: , amb_context_code

Line 7163: INTO xla_ae_line_acs (

7159: ,LENGTHB(anc_id_10))
7160: )
7161:
7162: WHEN anc_id_11 IS NOT NULL THEN
7163: INTO xla_ae_line_acs (
7164: ae_header_id , ae_line_num , object_version_number
7165: , analytical_criterion_code
7166: , analytical_criterion_type_code
7167: , amb_context_code

Line 7203: INTO xla_ae_line_acs (

7199: ,LENGTHB(anc_id_11))
7200: )
7201:
7202: WHEN anc_id_12 IS NOT NULL THEN
7203: INTO xla_ae_line_acs (
7204: ae_header_id , ae_line_num , object_version_number
7205: , analytical_criterion_code
7206: , analytical_criterion_type_code
7207: , amb_context_code

Line 7243: INTO xla_ae_line_acs (

7239: ,LENGTHB(anc_id_12))
7240: )
7241:
7242: WHEN anc_id_13 IS NOT NULL THEN
7243: INTO xla_ae_line_acs (
7244: ae_header_id , ae_line_num , object_version_number
7245: , analytical_criterion_code
7246: , analytical_criterion_type_code
7247: , amb_context_code

Line 7283: INTO xla_ae_line_acs (

7279: ,LENGTHB(anc_id_13))
7280: )
7281:
7282: WHEN anc_id_14 IS NOT NULL THEN
7283: INTO xla_ae_line_acs (
7284: ae_header_id , ae_line_num , object_version_number
7285: , analytical_criterion_code
7286: , analytical_criterion_type_code
7287: , amb_context_code

Line 7323: INTO xla_ae_line_acs (

7319: ,LENGTHB(anc_id_14))
7320: )
7321:
7322: WHEN anc_id_15 IS NOT NULL THEN
7323: INTO xla_ae_line_acs (
7324: ae_header_id , ae_line_num , object_version_number
7325: , analytical_criterion_code
7326: , analytical_criterion_type_code
7327: , amb_context_code

Line 7363: INTO xla_ae_line_acs (

7359: ,LENGTHB(anc_id_15))
7360: )
7361:
7362: WHEN anc_id_16 IS NOT NULL THEN
7363: INTO xla_ae_line_acs (
7364: ae_header_id , ae_line_num , object_version_number
7365: , analytical_criterion_code
7366: , analytical_criterion_type_code
7367: , amb_context_code

Line 7403: INTO xla_ae_line_acs (

7399: ,LENGTHB(anc_id_16))
7400: )
7401:
7402: WHEN anc_id_17 IS NOT NULL THEN
7403: INTO xla_ae_line_acs (
7404: ae_header_id , ae_line_num , object_version_number
7405: , analytical_criterion_code
7406: , analytical_criterion_type_code
7407: , amb_context_code

Line 7443: INTO xla_ae_line_acs (

7439: ,LENGTHB(anc_id_17))
7440: )
7441:
7442: WHEN anc_id_18 IS NOT NULL THEN
7443: INTO xla_ae_line_acs (
7444: ae_header_id , ae_line_num , object_version_number
7445: , analytical_criterion_code
7446: , analytical_criterion_type_code
7447: , amb_context_code

Line 7483: INTO xla_ae_line_acs (

7479: ,LENGTHB(anc_id_18))
7480: )
7481:
7482: WHEN anc_id_19 IS NOT NULL THEN
7483: INTO xla_ae_line_acs (
7484: ae_header_id , ae_line_num , object_version_number
7485: , analytical_criterion_code
7486: , analytical_criterion_type_code
7487: , amb_context_code

Line 7523: INTO xla_ae_line_acs (

7519: ,LENGTHB(anc_id_19))
7520: )
7521:
7522: WHEN anc_id_20 IS NOT NULL THEN
7523: INTO xla_ae_line_acs (
7524: ae_header_id , ae_line_num , object_version_number
7525: , analytical_criterion_code
7526: , analytical_criterion_type_code
7527: , amb_context_code

Line 7563: INTO xla_ae_line_acs (

7559: ,LENGTHB(anc_id_20))
7560: )
7561:
7562: WHEN anc_id_21 IS NOT NULL THEN
7563: INTO xla_ae_line_acs (
7564: ae_header_id , ae_line_num , object_version_number
7565: , analytical_criterion_code
7566: , analytical_criterion_type_code
7567: , amb_context_code

Line 7603: INTO xla_ae_line_acs (

7599: ,LENGTHB(anc_id_21))
7600: )
7601:
7602: WHEN anc_id_22 IS NOT NULL THEN
7603: INTO xla_ae_line_acs (
7604: ae_header_id , ae_line_num , object_version_number
7605: , analytical_criterion_code
7606: , analytical_criterion_type_code
7607: , amb_context_code

Line 7643: INTO xla_ae_line_acs (

7639: ,LENGTHB(anc_id_22))
7640: )
7641:
7642: WHEN anc_id_23 IS NOT NULL THEN
7643: INTO xla_ae_line_acs (
7644: ae_header_id , ae_line_num , object_version_number
7645: , analytical_criterion_code
7646: , analytical_criterion_type_code
7647: , amb_context_code

Line 7683: INTO xla_ae_line_acs (

7679: ,LENGTHB(anc_id_23))
7680: )
7681:
7682: WHEN anc_id_24 IS NOT NULL THEN
7683: INTO xla_ae_line_acs (
7684: ae_header_id , ae_line_num , object_version_number
7685: , analytical_criterion_code
7686: , analytical_criterion_type_code
7687: , amb_context_code

Line 7723: INTO xla_ae_line_acs (

7719: ,LENGTHB(anc_id_24))
7720: )
7721:
7722: WHEN anc_id_25 IS NOT NULL THEN
7723: INTO xla_ae_line_acs (
7724: ae_header_id , ae_line_num , object_version_number
7725: , analytical_criterion_code
7726: , analytical_criterion_type_code
7727: , amb_context_code

Line 7763: INTO xla_ae_line_acs (

7759: ,LENGTHB(anc_id_25))
7760: )
7761:
7762: WHEN anc_id_26 IS NOT NULL THEN
7763: INTO xla_ae_line_acs (
7764: ae_header_id , ae_line_num , object_version_number
7765: , analytical_criterion_code
7766: , analytical_criterion_type_code
7767: , amb_context_code

Line 7803: INTO xla_ae_line_acs (

7799: ,LENGTHB(anc_id_26))
7800: )
7801:
7802: WHEN anc_id_27 IS NOT NULL THEN
7803: INTO xla_ae_line_acs (
7804: ae_header_id , ae_line_num , object_version_number
7805: , analytical_criterion_code
7806: , analytical_criterion_type_code
7807: , amb_context_code

Line 7843: INTO xla_ae_line_acs (

7839: ,LENGTHB(anc_id_27))
7840: )
7841:
7842: WHEN anc_id_28 IS NOT NULL THEN
7843: INTO xla_ae_line_acs (
7844: ae_header_id , ae_line_num , object_version_number
7845: , analytical_criterion_code
7846: , analytical_criterion_type_code
7847: , amb_context_code

Line 7883: INTO xla_ae_line_acs (

7879: ,LENGTHB(anc_id_28))
7880: )
7881:
7882: WHEN anc_id_29 IS NOT NULL THEN
7883: INTO xla_ae_line_acs (
7884: ae_header_id , ae_line_num , object_version_number
7885: , analytical_criterion_code
7886: , analytical_criterion_type_code
7887: , amb_context_code

Line 7923: INTO xla_ae_line_acs (

7919: ,LENGTHB(anc_id_29))
7920: )
7921:
7922: WHEN anc_id_30 IS NOT NULL THEN
7923: INTO xla_ae_line_acs (
7924: ae_header_id , ae_line_num , object_version_number
7925: , analytical_criterion_code
7926: , analytical_criterion_type_code
7927: , amb_context_code

Line 7963: INTO xla_ae_line_acs (

7959: ,LENGTHB(anc_id_30))
7960: )
7961:
7962: WHEN anc_id_31 IS NOT NULL THEN
7963: INTO xla_ae_line_acs (
7964: ae_header_id , ae_line_num , object_version_number
7965: , analytical_criterion_code
7966: , analytical_criterion_type_code
7967: , amb_context_code

Line 8003: INTO xla_ae_line_acs (

7999: ,LENGTHB(anc_id_31))
8000: )
8001:
8002: WHEN anc_id_32 IS NOT NULL THEN
8003: INTO xla_ae_line_acs (
8004: ae_header_id , ae_line_num , object_version_number
8005: , analytical_criterion_code
8006: , analytical_criterion_type_code
8007: , amb_context_code

Line 8043: INTO xla_ae_line_acs (

8039: ,LENGTHB(anc_id_32))
8040: )
8041:
8042: WHEN anc_id_33 IS NOT NULL THEN
8043: INTO xla_ae_line_acs (
8044: ae_header_id , ae_line_num , object_version_number
8045: , analytical_criterion_code
8046: , analytical_criterion_type_code
8047: , amb_context_code

Line 8083: INTO xla_ae_line_acs (

8079: ,LENGTHB(anc_id_33))
8080: )
8081:
8082: WHEN anc_id_34 IS NOT NULL THEN
8083: INTO xla_ae_line_acs (
8084: ae_header_id , ae_line_num , object_version_number
8085: , analytical_criterion_code
8086: , analytical_criterion_type_code
8087: , amb_context_code

Line 8123: INTO xla_ae_line_acs (

8119: ,LENGTHB(anc_id_34))
8120: )
8121:
8122: WHEN anc_id_35 IS NOT NULL THEN
8123: INTO xla_ae_line_acs (
8124: ae_header_id , ae_line_num , object_version_number
8125: , analytical_criterion_code
8126: , analytical_criterion_type_code
8127: , amb_context_code

Line 8163: INTO xla_ae_line_acs (

8159: ,LENGTHB(anc_id_35))
8160: )
8161:
8162: WHEN anc_id_36 IS NOT NULL THEN
8163: INTO xla_ae_line_acs (
8164: ae_header_id , ae_line_num , object_version_number
8165: , analytical_criterion_code
8166: , analytical_criterion_type_code
8167: , amb_context_code

Line 8203: INTO xla_ae_line_acs (

8199: ,LENGTHB(anc_id_36))
8200: )
8201:
8202: WHEN anc_id_37 IS NOT NULL THEN
8203: INTO xla_ae_line_acs (
8204: ae_header_id , ae_line_num , object_version_number
8205: , analytical_criterion_code
8206: , analytical_criterion_type_code
8207: , amb_context_code

Line 8243: INTO xla_ae_line_acs (

8239: ,LENGTHB(anc_id_37))
8240: )
8241:
8242: WHEN anc_id_38 IS NOT NULL THEN
8243: INTO xla_ae_line_acs (
8244: ae_header_id , ae_line_num , object_version_number
8245: , analytical_criterion_code
8246: , analytical_criterion_type_code
8247: , amb_context_code

Line 8283: INTO xla_ae_line_acs (

8279: ,LENGTHB(anc_id_38))
8280: )
8281:
8282: WHEN anc_id_39 IS NOT NULL THEN
8283: INTO xla_ae_line_acs (
8284: ae_header_id , ae_line_num , object_version_number
8285: , analytical_criterion_code
8286: , analytical_criterion_type_code
8287: , amb_context_code

Line 8323: INTO xla_ae_line_acs (

8319: ,LENGTHB(anc_id_39))
8320: )
8321:
8322: WHEN anc_id_40 IS NOT NULL THEN
8323: INTO xla_ae_line_acs (
8324: ae_header_id , ae_line_num , object_version_number
8325: , analytical_criterion_code
8326: , analytical_criterion_type_code
8327: , amb_context_code

Line 8363: INTO xla_ae_line_acs (

8359: ,LENGTHB(anc_id_40))
8360: )
8361:
8362: WHEN anc_id_41 IS NOT NULL THEN
8363: INTO xla_ae_line_acs (
8364: ae_header_id , ae_line_num , object_version_number
8365: , analytical_criterion_code
8366: , analytical_criterion_type_code
8367: , amb_context_code

Line 8403: INTO xla_ae_line_acs (

8399: ,LENGTHB(anc_id_41))
8400: )
8401:
8402: WHEN anc_id_42 IS NOT NULL THEN
8403: INTO xla_ae_line_acs (
8404: ae_header_id , ae_line_num , object_version_number
8405: , analytical_criterion_code
8406: , analytical_criterion_type_code
8407: , amb_context_code

Line 8443: INTO xla_ae_line_acs (

8439: ,LENGTHB(anc_id_42))
8440: )
8441:
8442: WHEN anc_id_43 IS NOT NULL THEN
8443: INTO xla_ae_line_acs (
8444: ae_header_id , ae_line_num , object_version_number
8445: , analytical_criterion_code
8446: , analytical_criterion_type_code
8447: , amb_context_code

Line 8483: INTO xla_ae_line_acs (

8479: ,LENGTHB(anc_id_43))
8480: )
8481:
8482: WHEN anc_id_44 IS NOT NULL THEN
8483: INTO xla_ae_line_acs (
8484: ae_header_id , ae_line_num , object_version_number
8485: , analytical_criterion_code
8486: , analytical_criterion_type_code
8487: , amb_context_code

Line 8523: INTO xla_ae_line_acs (

8519: ,LENGTHB(anc_id_44))
8520: )
8521:
8522: WHEN anc_id_45 IS NOT NULL THEN
8523: INTO xla_ae_line_acs (
8524: ae_header_id , ae_line_num , object_version_number
8525: , analytical_criterion_code
8526: , analytical_criterion_type_code
8527: , amb_context_code

Line 8563: INTO xla_ae_line_acs (

8559: ,LENGTHB(anc_id_45))
8560: )
8561:
8562: WHEN anc_id_46 IS NOT NULL THEN
8563: INTO xla_ae_line_acs (
8564: ae_header_id , ae_line_num , object_version_number
8565: , analytical_criterion_code
8566: , analytical_criterion_type_code
8567: , amb_context_code

Line 8603: INTO xla_ae_line_acs (

8599: ,LENGTHB(anc_id_46))
8600: )
8601:
8602: WHEN anc_id_47 IS NOT NULL THEN
8603: INTO xla_ae_line_acs (
8604: ae_header_id , ae_line_num , object_version_number
8605: , analytical_criterion_code
8606: , analytical_criterion_type_code
8607: , amb_context_code

Line 8643: INTO xla_ae_line_acs (

8639: ,LENGTHB(anc_id_47))
8640: )
8641:
8642: WHEN anc_id_48 IS NOT NULL THEN
8643: INTO xla_ae_line_acs (
8644: ae_header_id , ae_line_num , object_version_number
8645: , analytical_criterion_code
8646: , analytical_criterion_type_code
8647: , amb_context_code

Line 8683: INTO xla_ae_line_acs (

8679: ,LENGTHB(anc_id_48))
8680: )
8681:
8682: WHEN anc_id_49 IS NOT NULL THEN
8683: INTO xla_ae_line_acs (
8684: ae_header_id , ae_line_num , object_version_number
8685: , analytical_criterion_code
8686: , analytical_criterion_type_code
8687: , amb_context_code

Line 8723: INTO xla_ae_line_acs (

8719: ,LENGTHB(anc_id_49))
8720: )
8721:
8722: WHEN anc_id_50 IS NOT NULL THEN
8723: INTO xla_ae_line_acs (
8724: ae_header_id , ae_line_num , object_version_number
8725: , analytical_criterion_code
8726: , analytical_criterion_type_code
8727: , amb_context_code

Line 8763: INTO xla_ae_line_acs (

8759: ,LENGTHB(anc_id_50))
8760: )
8761:
8762: WHEN anc_id_51 IS NOT NULL THEN
8763: INTO xla_ae_line_acs (
8764: ae_header_id , ae_line_num , object_version_number
8765: , analytical_criterion_code
8766: , analytical_criterion_type_code
8767: , amb_context_code

Line 8803: INTO xla_ae_line_acs (

8799: ,LENGTHB(anc_id_51))
8800: )
8801:
8802: WHEN anc_id_52 IS NOT NULL THEN
8803: INTO xla_ae_line_acs (
8804: ae_header_id , ae_line_num , object_version_number
8805: , analytical_criterion_code
8806: , analytical_criterion_type_code
8807: , amb_context_code

Line 8843: INTO xla_ae_line_acs (

8839: ,LENGTHB(anc_id_52))
8840: )
8841:
8842: WHEN anc_id_53 IS NOT NULL THEN
8843: INTO xla_ae_line_acs (
8844: ae_header_id , ae_line_num , object_version_number
8845: , analytical_criterion_code
8846: , analytical_criterion_type_code
8847: , amb_context_code

Line 8883: INTO xla_ae_line_acs (

8879: ,LENGTHB(anc_id_53))
8880: )
8881:
8882: WHEN anc_id_54 IS NOT NULL THEN
8883: INTO xla_ae_line_acs (
8884: ae_header_id , ae_line_num , object_version_number
8885: , analytical_criterion_code
8886: , analytical_criterion_type_code
8887: , amb_context_code

Line 8923: INTO xla_ae_line_acs (

8919: ,LENGTHB(anc_id_54))
8920: )
8921:
8922: WHEN anc_id_55 IS NOT NULL THEN
8923: INTO xla_ae_line_acs (
8924: ae_header_id , ae_line_num , object_version_number
8925: , analytical_criterion_code
8926: , analytical_criterion_type_code
8927: , amb_context_code

Line 8963: INTO xla_ae_line_acs (

8959: ,LENGTHB(anc_id_55))
8960: )
8961:
8962: WHEN anc_id_56 IS NOT NULL THEN
8963: INTO xla_ae_line_acs (
8964: ae_header_id , ae_line_num , object_version_number
8965: , analytical_criterion_code
8966: , analytical_criterion_type_code
8967: , amb_context_code

Line 9003: INTO xla_ae_line_acs (

8999: ,LENGTHB(anc_id_56))
9000: )
9001:
9002: WHEN anc_id_57 IS NOT NULL THEN
9003: INTO xla_ae_line_acs (
9004: ae_header_id , ae_line_num , object_version_number
9005: , analytical_criterion_code
9006: , analytical_criterion_type_code
9007: , amb_context_code

Line 9043: INTO xla_ae_line_acs (

9039: ,LENGTHB(anc_id_57))
9040: )
9041:
9042: WHEN anc_id_58 IS NOT NULL THEN
9043: INTO xla_ae_line_acs (
9044: ae_header_id , ae_line_num , object_version_number
9045: , analytical_criterion_code
9046: , analytical_criterion_type_code
9047: , amb_context_code

Line 9083: INTO xla_ae_line_acs (

9079: ,LENGTHB(anc_id_58))
9080: )
9081:
9082: WHEN anc_id_59 IS NOT NULL THEN
9083: INTO xla_ae_line_acs (
9084: ae_header_id , ae_line_num , object_version_number
9085: , analytical_criterion_code
9086: , analytical_criterion_type_code
9087: , amb_context_code

Line 9123: INTO xla_ae_line_acs (

9119: ,LENGTHB(anc_id_59))
9120: )
9121:
9122: WHEN anc_id_60 IS NOT NULL THEN
9123: INTO xla_ae_line_acs (
9124: ae_header_id , ae_line_num , object_version_number
9125: , analytical_criterion_code
9126: , analytical_criterion_type_code
9127: , amb_context_code

Line 9163: INTO xla_ae_line_acs (

9159: ,LENGTHB(anc_id_60))
9160: )
9161:
9162: WHEN anc_id_61 IS NOT NULL THEN
9163: INTO xla_ae_line_acs (
9164: ae_header_id , ae_line_num , object_version_number
9165: , analytical_criterion_code
9166: , analytical_criterion_type_code
9167: , amb_context_code

Line 9203: INTO xla_ae_line_acs (

9199: ,LENGTHB(anc_id_61))
9200: )
9201:
9202: WHEN anc_id_62 IS NOT NULL THEN
9203: INTO xla_ae_line_acs (
9204: ae_header_id , ae_line_num , object_version_number
9205: , analytical_criterion_code
9206: , analytical_criterion_type_code
9207: , amb_context_code

Line 9243: INTO xla_ae_line_acs (

9239: ,LENGTHB(anc_id_62))
9240: )
9241:
9242: WHEN anc_id_63 IS NOT NULL THEN
9243: INTO xla_ae_line_acs (
9244: ae_header_id , ae_line_num , object_version_number
9245: , analytical_criterion_code
9246: , analytical_criterion_type_code
9247: , amb_context_code

Line 9283: INTO xla_ae_line_acs (

9279: ,LENGTHB(anc_id_63))
9280: )
9281:
9282: WHEN anc_id_64 IS NOT NULL THEN
9283: INTO xla_ae_line_acs (
9284: ae_header_id , ae_line_num , object_version_number
9285: , analytical_criterion_code
9286: , analytical_criterion_type_code
9287: , amb_context_code

Line 9323: INTO xla_ae_line_acs (

9319: ,LENGTHB(anc_id_64))
9320: )
9321:
9322: WHEN anc_id_65 IS NOT NULL THEN
9323: INTO xla_ae_line_acs (
9324: ae_header_id , ae_line_num , object_version_number
9325: , analytical_criterion_code
9326: , analytical_criterion_type_code
9327: , amb_context_code

Line 9363: INTO xla_ae_line_acs (

9359: ,LENGTHB(anc_id_65))
9360: )
9361:
9362: WHEN anc_id_66 IS NOT NULL THEN
9363: INTO xla_ae_line_acs (
9364: ae_header_id , ae_line_num , object_version_number
9365: , analytical_criterion_code
9366: , analytical_criterion_type_code
9367: , amb_context_code

Line 9403: INTO xla_ae_line_acs (

9399: ,LENGTHB(anc_id_66))
9400: )
9401:
9402: WHEN anc_id_67 IS NOT NULL THEN
9403: INTO xla_ae_line_acs (
9404: ae_header_id , ae_line_num , object_version_number
9405: , analytical_criterion_code
9406: , analytical_criterion_type_code
9407: , amb_context_code

Line 9443: INTO xla_ae_line_acs (

9439: ,LENGTHB(anc_id_67))
9440: )
9441:
9442: WHEN anc_id_68 IS NOT NULL THEN
9443: INTO xla_ae_line_acs (
9444: ae_header_id , ae_line_num , object_version_number
9445: , analytical_criterion_code
9446: , analytical_criterion_type_code
9447: , amb_context_code

Line 9483: INTO xla_ae_line_acs (

9479: ,LENGTHB(anc_id_68))
9480: )
9481:
9482: WHEN anc_id_69 IS NOT NULL THEN
9483: INTO xla_ae_line_acs (
9484: ae_header_id , ae_line_num , object_version_number
9485: , analytical_criterion_code
9486: , analytical_criterion_type_code
9487: , amb_context_code

Line 9523: INTO xla_ae_line_acs (

9519: ,LENGTHB(anc_id_69))
9520: )
9521:
9522: WHEN anc_id_70 IS NOT NULL THEN
9523: INTO xla_ae_line_acs (
9524: ae_header_id , ae_line_num , object_version_number
9525: , analytical_criterion_code
9526: , analytical_criterion_type_code
9527: , amb_context_code

Line 9563: INTO xla_ae_line_acs (

9559: ,LENGTHB(anc_id_70))
9560: )
9561:
9562: WHEN anc_id_71 IS NOT NULL THEN
9563: INTO xla_ae_line_acs (
9564: ae_header_id , ae_line_num , object_version_number
9565: , analytical_criterion_code
9566: , analytical_criterion_type_code
9567: , amb_context_code

Line 9603: INTO xla_ae_line_acs (

9599: ,LENGTHB(anc_id_71))
9600: )
9601:
9602: WHEN anc_id_72 IS NOT NULL THEN
9603: INTO xla_ae_line_acs (
9604: ae_header_id , ae_line_num , object_version_number
9605: , analytical_criterion_code
9606: , analytical_criterion_type_code
9607: , amb_context_code

Line 9643: INTO xla_ae_line_acs (

9639: ,LENGTHB(anc_id_72))
9640: )
9641:
9642: WHEN anc_id_73 IS NOT NULL THEN
9643: INTO xla_ae_line_acs (
9644: ae_header_id , ae_line_num , object_version_number
9645: , analytical_criterion_code
9646: , analytical_criterion_type_code
9647: , amb_context_code

Line 9683: INTO xla_ae_line_acs (

9679: ,LENGTHB(anc_id_73))
9680: )
9681:
9682: WHEN anc_id_74 IS NOT NULL THEN
9683: INTO xla_ae_line_acs (
9684: ae_header_id , ae_line_num , object_version_number
9685: , analytical_criterion_code
9686: , analytical_criterion_type_code
9687: , amb_context_code

Line 9723: INTO xla_ae_line_acs (

9719: ,LENGTHB(anc_id_74))
9720: )
9721:
9722: WHEN anc_id_75 IS NOT NULL THEN
9723: INTO xla_ae_line_acs (
9724: ae_header_id , ae_line_num , object_version_number
9725: , analytical_criterion_code
9726: , analytical_criterion_type_code
9727: , amb_context_code

Line 9763: INTO xla_ae_line_acs (

9759: ,LENGTHB(anc_id_75))
9760: )
9761:
9762: WHEN anc_id_76 IS NOT NULL THEN
9763: INTO xla_ae_line_acs (
9764: ae_header_id , ae_line_num , object_version_number
9765: , analytical_criterion_code
9766: , analytical_criterion_type_code
9767: , amb_context_code

Line 9803: INTO xla_ae_line_acs (

9799: ,LENGTHB(anc_id_76))
9800: )
9801:
9802: WHEN anc_id_77 IS NOT NULL THEN
9803: INTO xla_ae_line_acs (
9804: ae_header_id , ae_line_num , object_version_number
9805: , analytical_criterion_code
9806: , analytical_criterion_type_code
9807: , amb_context_code

Line 9843: INTO xla_ae_line_acs (

9839: ,LENGTHB(anc_id_77))
9840: )
9841:
9842: WHEN anc_id_78 IS NOT NULL THEN
9843: INTO xla_ae_line_acs (
9844: ae_header_id , ae_line_num , object_version_number
9845: , analytical_criterion_code
9846: , analytical_criterion_type_code
9847: , amb_context_code

Line 9883: INTO xla_ae_line_acs (

9879: ,LENGTHB(anc_id_78))
9880: )
9881:
9882: WHEN anc_id_79 IS NOT NULL THEN
9883: INTO xla_ae_line_acs (
9884: ae_header_id , ae_line_num , object_version_number
9885: , analytical_criterion_code
9886: , analytical_criterion_type_code
9887: , amb_context_code

Line 9923: INTO xla_ae_line_acs (

9919: ,LENGTHB(anc_id_79))
9920: )
9921:
9922: WHEN anc_id_80 IS NOT NULL THEN
9923: INTO xla_ae_line_acs (
9924: ae_header_id , ae_line_num , object_version_number
9925: , analytical_criterion_code
9926: , analytical_criterion_type_code
9927: , amb_context_code

Line 9963: INTO xla_ae_line_acs (

9959: ,LENGTHB(anc_id_80))
9960: )
9961:
9962: WHEN anc_id_81 IS NOT NULL THEN
9963: INTO xla_ae_line_acs (
9964: ae_header_id , ae_line_num , object_version_number
9965: , analytical_criterion_code
9966: , analytical_criterion_type_code
9967: , amb_context_code

Line 10003: INTO xla_ae_line_acs (

9999: ,LENGTHB(anc_id_81))
10000: )
10001:
10002: WHEN anc_id_82 IS NOT NULL THEN
10003: INTO xla_ae_line_acs (
10004: ae_header_id , ae_line_num , object_version_number
10005: , analytical_criterion_code
10006: , analytical_criterion_type_code
10007: , amb_context_code

Line 10043: INTO xla_ae_line_acs (

10039: ,LENGTHB(anc_id_82))
10040: )
10041:
10042: WHEN anc_id_83 IS NOT NULL THEN
10043: INTO xla_ae_line_acs (
10044: ae_header_id , ae_line_num , object_version_number
10045: , analytical_criterion_code
10046: , analytical_criterion_type_code
10047: , amb_context_code

Line 10083: INTO xla_ae_line_acs (

10079: ,LENGTHB(anc_id_83))
10080: )
10081:
10082: WHEN anc_id_84 IS NOT NULL THEN
10083: INTO xla_ae_line_acs (
10084: ae_header_id , ae_line_num , object_version_number
10085: , analytical_criterion_code
10086: , analytical_criterion_type_code
10087: , amb_context_code

Line 10123: INTO xla_ae_line_acs (

10119: ,LENGTHB(anc_id_84))
10120: )
10121:
10122: WHEN anc_id_85 IS NOT NULL THEN
10123: INTO xla_ae_line_acs (
10124: ae_header_id , ae_line_num , object_version_number
10125: , analytical_criterion_code
10126: , analytical_criterion_type_code
10127: , amb_context_code

Line 10163: INTO xla_ae_line_acs (

10159: ,LENGTHB(anc_id_85))
10160: )
10161:
10162: WHEN anc_id_86 IS NOT NULL THEN
10163: INTO xla_ae_line_acs (
10164: ae_header_id , ae_line_num , object_version_number
10165: , analytical_criterion_code
10166: , analytical_criterion_type_code
10167: , amb_context_code

Line 10203: INTO xla_ae_line_acs (

10199: ,LENGTHB(anc_id_86))
10200: )
10201:
10202: WHEN anc_id_87 IS NOT NULL THEN
10203: INTO xla_ae_line_acs (
10204: ae_header_id , ae_line_num , object_version_number
10205: , analytical_criterion_code
10206: , analytical_criterion_type_code
10207: , amb_context_code

Line 10243: INTO xla_ae_line_acs (

10239: ,LENGTHB(anc_id_87))
10240: )
10241:
10242: WHEN anc_id_88 IS NOT NULL THEN
10243: INTO xla_ae_line_acs (
10244: ae_header_id , ae_line_num , object_version_number
10245: , analytical_criterion_code
10246: , analytical_criterion_type_code
10247: , amb_context_code

Line 10283: INTO xla_ae_line_acs (

10279: ,LENGTHB(anc_id_88))
10280: )
10281:
10282: WHEN anc_id_89 IS NOT NULL THEN
10283: INTO xla_ae_line_acs (
10284: ae_header_id , ae_line_num , object_version_number
10285: , analytical_criterion_code
10286: , analytical_criterion_type_code
10287: , amb_context_code

Line 10323: INTO xla_ae_line_acs (

10319: ,LENGTHB(anc_id_89))
10320: )
10321:
10322: WHEN anc_id_90 IS NOT NULL THEN
10323: INTO xla_ae_line_acs (
10324: ae_header_id , ae_line_num , object_version_number
10325: , analytical_criterion_code
10326: , analytical_criterion_type_code
10327: , amb_context_code

Line 10363: INTO xla_ae_line_acs (

10359: ,LENGTHB(anc_id_90))
10360: )
10361:
10362: WHEN anc_id_91 IS NOT NULL THEN
10363: INTO xla_ae_line_acs (
10364: ae_header_id , ae_line_num , object_version_number
10365: , analytical_criterion_code
10366: , analytical_criterion_type_code
10367: , amb_context_code

Line 10403: INTO xla_ae_line_acs (

10399: ,LENGTHB(anc_id_91))
10400: )
10401:
10402: WHEN anc_id_92 IS NOT NULL THEN
10403: INTO xla_ae_line_acs (
10404: ae_header_id , ae_line_num , object_version_number
10405: , analytical_criterion_code
10406: , analytical_criterion_type_code
10407: , amb_context_code

Line 10443: INTO xla_ae_line_acs (

10439: ,LENGTHB(anc_id_92))
10440: )
10441:
10442: WHEN anc_id_93 IS NOT NULL THEN
10443: INTO xla_ae_line_acs (
10444: ae_header_id , ae_line_num , object_version_number
10445: , analytical_criterion_code
10446: , analytical_criterion_type_code
10447: , amb_context_code

Line 10483: INTO xla_ae_line_acs (

10479: ,LENGTHB(anc_id_93))
10480: )
10481:
10482: WHEN anc_id_94 IS NOT NULL THEN
10483: INTO xla_ae_line_acs (
10484: ae_header_id , ae_line_num , object_version_number
10485: , analytical_criterion_code
10486: , analytical_criterion_type_code
10487: , amb_context_code

Line 10523: INTO xla_ae_line_acs (

10519: ,LENGTHB(anc_id_94))
10520: )
10521:
10522: WHEN anc_id_95 IS NOT NULL THEN
10523: INTO xla_ae_line_acs (
10524: ae_header_id , ae_line_num , object_version_number
10525: , analytical_criterion_code
10526: , analytical_criterion_type_code
10527: , amb_context_code

Line 10563: INTO xla_ae_line_acs (

10559: ,LENGTHB(anc_id_95))
10560: )
10561:
10562: WHEN anc_id_96 IS NOT NULL THEN
10563: INTO xla_ae_line_acs (
10564: ae_header_id , ae_line_num , object_version_number
10565: , analytical_criterion_code
10566: , analytical_criterion_type_code
10567: , amb_context_code

Line 10603: INTO xla_ae_line_acs (

10599: ,LENGTHB(anc_id_96))
10600: )
10601:
10602: WHEN anc_id_97 IS NOT NULL THEN
10603: INTO xla_ae_line_acs (
10604: ae_header_id , ae_line_num , object_version_number
10605: , analytical_criterion_code
10606: , analytical_criterion_type_code
10607: , amb_context_code

Line 10643: INTO xla_ae_line_acs (

10639: ,LENGTHB(anc_id_97))
10640: )
10641:
10642: WHEN anc_id_98 IS NOT NULL THEN
10643: INTO xla_ae_line_acs (
10644: ae_header_id , ae_line_num , object_version_number
10645: , analytical_criterion_code
10646: , analytical_criterion_type_code
10647: , amb_context_code

Line 10683: INTO xla_ae_line_acs (

10679: ,LENGTHB(anc_id_98))
10680: )
10681:
10682: WHEN anc_id_99 IS NOT NULL THEN
10683: INTO xla_ae_line_acs (
10684: ae_header_id , ae_line_num , object_version_number
10685: , analytical_criterion_code
10686: , analytical_criterion_type_code
10687: , amb_context_code

Line 10723: INTO xla_ae_line_acs (

10719: ,LENGTHB(anc_id_99))
10720: )
10721:
10722: WHEN anc_id_100 IS NOT NULL THEN
10723: INTO xla_ae_line_acs (
10724: ae_header_id , ae_line_num , object_version_number
10725: , analytical_criterion_code
10726: , analytical_criterion_type_code
10727: , amb_context_code

Line 10976: (p_msg => '# line analytical criteria inserted into xla_ae_line_acs = '||l_rowcount

10972: l_rowcount := SQL%ROWCOUNT;
10973:
10974: IF (C_LEVEL_EVENT >= g_log_level) THEN
10975: trace
10976: (p_msg => '# line analytical criteria inserted into xla_ae_line_acs = '||l_rowcount
10977: ,p_level => C_LEVEL_EVENT
10978: ,p_module => l_log_module);
10979: END IF;
10980:

Line 19953: | into xla_ae_line_acs table if analytical criteria exists for |

19949:
19950: /*======================================================================+
19951: | PRIVATE PROCEDURE : Insert_ANC_Inv_Canc |
19952: | Bug# 7382288:Insert analytical criteria for invoice cancellation |
19953: | into xla_ae_line_acs table if analytical criteria exists for |
19954: | invoice validation event. |
19955: +======================================================================*/
19956: procedure Insert_ANC_Inv_Canc
19957: is

Line 19978: insert into xla_ae_line_acs (

19974: l_rowcount := 0;
19975: l_array_base_ledgers := xla_accounting_cache_pkg.GetLedgers;
19976:
19977: for i in 1..l_array_base_ledgers.count loop
19978: insert into xla_ae_line_acs (
19979: ae_header_id,
19980: ae_line_num,
19981: analytical_criterion_code,
19982: analytical_criterion_type_code,

Line 20002: from xla_ae_line_acs la,

19998: la.ac2,
19999: la.ac3,
20000: la.ac4,
20001: la.ac5
20002: from xla_ae_line_acs la,
20003: xla_ae_lines_gt gt
20004: where la.ae_header_id=gt.ref_ae_header_id
20005: and gt.ref_ae_header_id<> gt.ae_header_id
20006: and la.ae_line_num = gt.ref_ae_line_num

Line 20032: (p_msg => '# line analytical criteria inserted in xla_ae_line_acs for invoice cancellation = '||l_rowcount

20028: l_rowcount := SQL%ROWCOUNT;
20029:
20030: IF (C_LEVEL_EVENT >= g_log_level) THEN
20031: trace
20032: (p_msg => '# line analytical criteria inserted in xla_ae_line_acs for invoice cancellation = '||l_rowcount
20033: ,p_level => C_LEVEL_EVENT
20034: ,p_module => l_log_module);
20035: END IF;
20036: