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 3637: (p_msg => 'SQL - Insert into xla_ae_line_acs'

3633:
3634: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3635:
3636: trace
3637: (p_msg => 'SQL - Insert into xla_ae_line_acs'
3638: ,p_level => C_LEVEL_STATEMENT
3639: ,p_module => l_log_module);
3640:
3641: trace

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

3678: l_rowcount := SQL%ROWCOUNT;
3679:
3680: IF (C_LEVEL_EVENT >= g_log_level) THEN
3681: trace
3682: (p_msg => '# line analytical criteria inserted into xla_ae_line_acs = '||l_rowcount
3683: ,p_level => C_LEVEL_EVENT
3684: ,p_module => l_log_module);
3685: END IF;
3686:

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

3757:
3758: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3759:
3760: trace
3761: (p_msg => 'SQL - Insert into xla_ae_line_acs'
3762: ,p_level => C_LEVEL_STATEMENT
3763: ,p_module => l_log_module);
3764:
3765: END IF;

Line 3769: INTO xla_ae_line_acs (

3765: END IF;
3766:
3767: INSERT ALL
3768: WHEN anc_id_1 IS NOT NULL THEN
3769: INTO xla_ae_line_acs (
3770: ae_header_id , ae_line_num , object_version_number
3771: , analytical_criterion_code
3772: , analytical_criterion_type_code
3773: , amb_context_code

Line 3809: INTO xla_ae_line_acs (

3805: ,LENGTHB(anc_id_1))
3806: )
3807:
3808: WHEN anc_id_2 IS NOT NULL THEN
3809: INTO xla_ae_line_acs (
3810: ae_header_id , ae_line_num , object_version_number
3811: , analytical_criterion_code
3812: , analytical_criterion_type_code
3813: , amb_context_code

Line 3849: INTO xla_ae_line_acs (

3845: ,LENGTHB(anc_id_2))
3846: )
3847:
3848: WHEN anc_id_3 IS NOT NULL THEN
3849: INTO xla_ae_line_acs (
3850: ae_header_id , ae_line_num , object_version_number
3851: , analytical_criterion_code
3852: , analytical_criterion_type_code
3853: , amb_context_code

Line 3889: INTO xla_ae_line_acs (

3885: ,LENGTHB(anc_id_3))
3886: )
3887:
3888: WHEN anc_id_4 IS NOT NULL THEN
3889: INTO xla_ae_line_acs (
3890: ae_header_id , ae_line_num , object_version_number
3891: , analytical_criterion_code
3892: , analytical_criterion_type_code
3893: , amb_context_code

Line 3929: INTO xla_ae_line_acs (

3925: ,LENGTHB(anc_id_4))
3926: )
3927:
3928: WHEN anc_id_5 IS NOT NULL THEN
3929: INTO xla_ae_line_acs (
3930: ae_header_id , ae_line_num , object_version_number
3931: , analytical_criterion_code
3932: , analytical_criterion_type_code
3933: , amb_context_code

Line 3969: INTO xla_ae_line_acs (

3965: ,LENGTHB(anc_id_5))
3966: )
3967:
3968: WHEN anc_id_6 IS NOT NULL THEN
3969: INTO xla_ae_line_acs (
3970: ae_header_id , ae_line_num , object_version_number
3971: , analytical_criterion_code
3972: , analytical_criterion_type_code
3973: , amb_context_code

Line 4009: INTO xla_ae_line_acs (

4005: ,LENGTHB(anc_id_6))
4006: )
4007:
4008: WHEN anc_id_7 IS NOT NULL THEN
4009: INTO xla_ae_line_acs (
4010: ae_header_id , ae_line_num , object_version_number
4011: , analytical_criterion_code
4012: , analytical_criterion_type_code
4013: , amb_context_code

Line 4049: INTO xla_ae_line_acs (

4045: ,LENGTHB(anc_id_7))
4046: )
4047:
4048: WHEN anc_id_8 IS NOT NULL THEN
4049: INTO xla_ae_line_acs (
4050: ae_header_id , ae_line_num , object_version_number
4051: , analytical_criterion_code
4052: , analytical_criterion_type_code
4053: , amb_context_code

Line 4089: INTO xla_ae_line_acs (

4085: ,LENGTHB(anc_id_8))
4086: )
4087:
4088: WHEN anc_id_9 IS NOT NULL THEN
4089: INTO xla_ae_line_acs (
4090: ae_header_id , ae_line_num , object_version_number
4091: , analytical_criterion_code
4092: , analytical_criterion_type_code
4093: , amb_context_code

Line 4129: INTO xla_ae_line_acs (

4125: ,LENGTHB(anc_id_9))
4126: )
4127:
4128: WHEN anc_id_10 IS NOT NULL THEN
4129: INTO xla_ae_line_acs (
4130: ae_header_id , ae_line_num , object_version_number
4131: , analytical_criterion_code
4132: , analytical_criterion_type_code
4133: , amb_context_code

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

4197: l_rowcount := SQL%ROWCOUNT;
4198:
4199: IF (C_LEVEL_EVENT >= g_log_level) THEN
4200: trace
4201: (p_msg => '# line analytical criteria inserted into xla_ae_line_acs = '||l_rowcount
4202: ,p_level => C_LEVEL_EVENT
4203: ,p_module => l_log_module);
4204: END IF;
4205:

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

4276:
4277: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4278:
4279: trace
4280: (p_msg => 'SQL - Insert into xla_ae_line_acs'
4281: ,p_level => C_LEVEL_STATEMENT
4282: ,p_module => l_log_module);
4283:
4284: END IF;

Line 4288: INTO xla_ae_line_acs (

4284: END IF;
4285:
4286: INSERT ALL
4287: WHEN anc_id_1 IS NOT NULL THEN
4288: INTO xla_ae_line_acs (
4289: ae_header_id , ae_line_num , object_version_number
4290: , analytical_criterion_code
4291: , analytical_criterion_type_code
4292: , amb_context_code

Line 4328: INTO xla_ae_line_acs (

4324: ,LENGTHB(anc_id_1))
4325: )
4326:
4327: WHEN anc_id_2 IS NOT NULL THEN
4328: INTO xla_ae_line_acs (
4329: ae_header_id , ae_line_num , object_version_number
4330: , analytical_criterion_code
4331: , analytical_criterion_type_code
4332: , amb_context_code

Line 4368: INTO xla_ae_line_acs (

4364: ,LENGTHB(anc_id_2))
4365: )
4366:
4367: WHEN anc_id_3 IS NOT NULL THEN
4368: INTO xla_ae_line_acs (
4369: ae_header_id , ae_line_num , object_version_number
4370: , analytical_criterion_code
4371: , analytical_criterion_type_code
4372: , amb_context_code

Line 4408: INTO xla_ae_line_acs (

4404: ,LENGTHB(anc_id_3))
4405: )
4406:
4407: WHEN anc_id_4 IS NOT NULL THEN
4408: INTO xla_ae_line_acs (
4409: ae_header_id , ae_line_num , object_version_number
4410: , analytical_criterion_code
4411: , analytical_criterion_type_code
4412: , amb_context_code

Line 4448: INTO xla_ae_line_acs (

4444: ,LENGTHB(anc_id_4))
4445: )
4446:
4447: WHEN anc_id_5 IS NOT NULL THEN
4448: INTO xla_ae_line_acs (
4449: ae_header_id , ae_line_num , object_version_number
4450: , analytical_criterion_code
4451: , analytical_criterion_type_code
4452: , amb_context_code

Line 4488: INTO xla_ae_line_acs (

4484: ,LENGTHB(anc_id_5))
4485: )
4486:
4487: WHEN anc_id_6 IS NOT NULL THEN
4488: INTO xla_ae_line_acs (
4489: ae_header_id , ae_line_num , object_version_number
4490: , analytical_criterion_code
4491: , analytical_criterion_type_code
4492: , amb_context_code

Line 4528: INTO xla_ae_line_acs (

4524: ,LENGTHB(anc_id_6))
4525: )
4526:
4527: WHEN anc_id_7 IS NOT NULL THEN
4528: INTO xla_ae_line_acs (
4529: ae_header_id , ae_line_num , object_version_number
4530: , analytical_criterion_code
4531: , analytical_criterion_type_code
4532: , amb_context_code

Line 4568: INTO xla_ae_line_acs (

4564: ,LENGTHB(anc_id_7))
4565: )
4566:
4567: WHEN anc_id_8 IS NOT NULL THEN
4568: INTO xla_ae_line_acs (
4569: ae_header_id , ae_line_num , object_version_number
4570: , analytical_criterion_code
4571: , analytical_criterion_type_code
4572: , amb_context_code

Line 4608: INTO xla_ae_line_acs (

4604: ,LENGTHB(anc_id_8))
4605: )
4606:
4607: WHEN anc_id_9 IS NOT NULL THEN
4608: INTO xla_ae_line_acs (
4609: ae_header_id , ae_line_num , object_version_number
4610: , analytical_criterion_code
4611: , analytical_criterion_type_code
4612: , amb_context_code

Line 4648: INTO xla_ae_line_acs (

4644: ,LENGTHB(anc_id_9))
4645: )
4646:
4647: WHEN anc_id_10 IS NOT NULL THEN
4648: INTO xla_ae_line_acs (
4649: ae_header_id , ae_line_num , object_version_number
4650: , analytical_criterion_code
4651: , analytical_criterion_type_code
4652: , amb_context_code

Line 4688: INTO xla_ae_line_acs (

4684: ,LENGTHB(anc_id_10))
4685: )
4686:
4687: WHEN anc_id_11 IS NOT NULL THEN
4688: INTO xla_ae_line_acs (
4689: ae_header_id , ae_line_num , object_version_number
4690: , analytical_criterion_code
4691: , analytical_criterion_type_code
4692: , amb_context_code

Line 4728: INTO xla_ae_line_acs (

4724: ,LENGTHB(anc_id_11))
4725: )
4726:
4727: WHEN anc_id_12 IS NOT NULL THEN
4728: INTO xla_ae_line_acs (
4729: ae_header_id , ae_line_num , object_version_number
4730: , analytical_criterion_code
4731: , analytical_criterion_type_code
4732: , amb_context_code

Line 4768: INTO xla_ae_line_acs (

4764: ,LENGTHB(anc_id_12))
4765: )
4766:
4767: WHEN anc_id_13 IS NOT NULL THEN
4768: INTO xla_ae_line_acs (
4769: ae_header_id , ae_line_num , object_version_number
4770: , analytical_criterion_code
4771: , analytical_criterion_type_code
4772: , amb_context_code

Line 4808: INTO xla_ae_line_acs (

4804: ,LENGTHB(anc_id_13))
4805: )
4806:
4807: WHEN anc_id_14 IS NOT NULL THEN
4808: INTO xla_ae_line_acs (
4809: ae_header_id , ae_line_num , object_version_number
4810: , analytical_criterion_code
4811: , analytical_criterion_type_code
4812: , amb_context_code

Line 4848: INTO xla_ae_line_acs (

4844: ,LENGTHB(anc_id_14))
4845: )
4846:
4847: WHEN anc_id_15 IS NOT NULL THEN
4848: INTO xla_ae_line_acs (
4849: ae_header_id , ae_line_num , object_version_number
4850: , analytical_criterion_code
4851: , analytical_criterion_type_code
4852: , amb_context_code

Line 4888: INTO xla_ae_line_acs (

4884: ,LENGTHB(anc_id_15))
4885: )
4886:
4887: WHEN anc_id_16 IS NOT NULL THEN
4888: INTO xla_ae_line_acs (
4889: ae_header_id , ae_line_num , object_version_number
4890: , analytical_criterion_code
4891: , analytical_criterion_type_code
4892: , amb_context_code

Line 4928: INTO xla_ae_line_acs (

4924: ,LENGTHB(anc_id_16))
4925: )
4926:
4927: WHEN anc_id_17 IS NOT NULL THEN
4928: INTO xla_ae_line_acs (
4929: ae_header_id , ae_line_num , object_version_number
4930: , analytical_criterion_code
4931: , analytical_criterion_type_code
4932: , amb_context_code

Line 4968: INTO xla_ae_line_acs (

4964: ,LENGTHB(anc_id_17))
4965: )
4966:
4967: WHEN anc_id_18 IS NOT NULL THEN
4968: INTO xla_ae_line_acs (
4969: ae_header_id , ae_line_num , object_version_number
4970: , analytical_criterion_code
4971: , analytical_criterion_type_code
4972: , amb_context_code

Line 5008: INTO xla_ae_line_acs (

5004: ,LENGTHB(anc_id_18))
5005: )
5006:
5007: WHEN anc_id_19 IS NOT NULL THEN
5008: INTO xla_ae_line_acs (
5009: ae_header_id , ae_line_num , object_version_number
5010: , analytical_criterion_code
5011: , analytical_criterion_type_code
5012: , amb_context_code

Line 5048: INTO xla_ae_line_acs (

5044: ,LENGTHB(anc_id_19))
5045: )
5046:
5047: WHEN anc_id_20 IS NOT NULL THEN
5048: INTO xla_ae_line_acs (
5049: ae_header_id , ae_line_num , object_version_number
5050: , analytical_criterion_code
5051: , analytical_criterion_type_code
5052: , amb_context_code

Line 5088: INTO xla_ae_line_acs (

5084: ,LENGTHB(anc_id_20))
5085: )
5086:
5087: WHEN anc_id_21 IS NOT NULL THEN
5088: INTO xla_ae_line_acs (
5089: ae_header_id , ae_line_num , object_version_number
5090: , analytical_criterion_code
5091: , analytical_criterion_type_code
5092: , amb_context_code

Line 5128: INTO xla_ae_line_acs (

5124: ,LENGTHB(anc_id_21))
5125: )
5126:
5127: WHEN anc_id_22 IS NOT NULL THEN
5128: INTO xla_ae_line_acs (
5129: ae_header_id , ae_line_num , object_version_number
5130: , analytical_criterion_code
5131: , analytical_criterion_type_code
5132: , amb_context_code

Line 5168: INTO xla_ae_line_acs (

5164: ,LENGTHB(anc_id_22))
5165: )
5166:
5167: WHEN anc_id_23 IS NOT NULL THEN
5168: INTO xla_ae_line_acs (
5169: ae_header_id , ae_line_num , object_version_number
5170: , analytical_criterion_code
5171: , analytical_criterion_type_code
5172: , amb_context_code

Line 5208: INTO xla_ae_line_acs (

5204: ,LENGTHB(anc_id_23))
5205: )
5206:
5207: WHEN anc_id_24 IS NOT NULL THEN
5208: INTO xla_ae_line_acs (
5209: ae_header_id , ae_line_num , object_version_number
5210: , analytical_criterion_code
5211: , analytical_criterion_type_code
5212: , amb_context_code

Line 5248: INTO xla_ae_line_acs (

5244: ,LENGTHB(anc_id_24))
5245: )
5246:
5247: WHEN anc_id_25 IS NOT NULL THEN
5248: INTO xla_ae_line_acs (
5249: ae_header_id , ae_line_num , object_version_number
5250: , analytical_criterion_code
5251: , analytical_criterion_type_code
5252: , amb_context_code

Line 5288: INTO xla_ae_line_acs (

5284: ,LENGTHB(anc_id_25))
5285: )
5286:
5287: WHEN anc_id_26 IS NOT NULL THEN
5288: INTO xla_ae_line_acs (
5289: ae_header_id , ae_line_num , object_version_number
5290: , analytical_criterion_code
5291: , analytical_criterion_type_code
5292: , amb_context_code

Line 5328: INTO xla_ae_line_acs (

5324: ,LENGTHB(anc_id_26))
5325: )
5326:
5327: WHEN anc_id_27 IS NOT NULL THEN
5328: INTO xla_ae_line_acs (
5329: ae_header_id , ae_line_num , object_version_number
5330: , analytical_criterion_code
5331: , analytical_criterion_type_code
5332: , amb_context_code

Line 5368: INTO xla_ae_line_acs (

5364: ,LENGTHB(anc_id_27))
5365: )
5366:
5367: WHEN anc_id_28 IS NOT NULL THEN
5368: INTO xla_ae_line_acs (
5369: ae_header_id , ae_line_num , object_version_number
5370: , analytical_criterion_code
5371: , analytical_criterion_type_code
5372: , amb_context_code

Line 5408: INTO xla_ae_line_acs (

5404: ,LENGTHB(anc_id_28))
5405: )
5406:
5407: WHEN anc_id_29 IS NOT NULL THEN
5408: INTO xla_ae_line_acs (
5409: ae_header_id , ae_line_num , object_version_number
5410: , analytical_criterion_code
5411: , analytical_criterion_type_code
5412: , amb_context_code

Line 5448: INTO xla_ae_line_acs (

5444: ,LENGTHB(anc_id_29))
5445: )
5446:
5447: WHEN anc_id_30 IS NOT NULL THEN
5448: INTO xla_ae_line_acs (
5449: ae_header_id , ae_line_num , object_version_number
5450: , analytical_criterion_code
5451: , analytical_criterion_type_code
5452: , amb_context_code

Line 5488: INTO xla_ae_line_acs (

5484: ,LENGTHB(anc_id_30))
5485: )
5486:
5487: WHEN anc_id_31 IS NOT NULL THEN
5488: INTO xla_ae_line_acs (
5489: ae_header_id , ae_line_num , object_version_number
5490: , analytical_criterion_code
5491: , analytical_criterion_type_code
5492: , amb_context_code

Line 5528: INTO xla_ae_line_acs (

5524: ,LENGTHB(anc_id_31))
5525: )
5526:
5527: WHEN anc_id_32 IS NOT NULL THEN
5528: INTO xla_ae_line_acs (
5529: ae_header_id , ae_line_num , object_version_number
5530: , analytical_criterion_code
5531: , analytical_criterion_type_code
5532: , amb_context_code

Line 5568: INTO xla_ae_line_acs (

5564: ,LENGTHB(anc_id_32))
5565: )
5566:
5567: WHEN anc_id_33 IS NOT NULL THEN
5568: INTO xla_ae_line_acs (
5569: ae_header_id , ae_line_num , object_version_number
5570: , analytical_criterion_code
5571: , analytical_criterion_type_code
5572: , amb_context_code

Line 5608: INTO xla_ae_line_acs (

5604: ,LENGTHB(anc_id_33))
5605: )
5606:
5607: WHEN anc_id_34 IS NOT NULL THEN
5608: INTO xla_ae_line_acs (
5609: ae_header_id , ae_line_num , object_version_number
5610: , analytical_criterion_code
5611: , analytical_criterion_type_code
5612: , amb_context_code

Line 5648: INTO xla_ae_line_acs (

5644: ,LENGTHB(anc_id_34))
5645: )
5646:
5647: WHEN anc_id_35 IS NOT NULL THEN
5648: INTO xla_ae_line_acs (
5649: ae_header_id , ae_line_num , object_version_number
5650: , analytical_criterion_code
5651: , analytical_criterion_type_code
5652: , amb_context_code

Line 5688: INTO xla_ae_line_acs (

5684: ,LENGTHB(anc_id_35))
5685: )
5686:
5687: WHEN anc_id_36 IS NOT NULL THEN
5688: INTO xla_ae_line_acs (
5689: ae_header_id , ae_line_num , object_version_number
5690: , analytical_criterion_code
5691: , analytical_criterion_type_code
5692: , amb_context_code

Line 5728: INTO xla_ae_line_acs (

5724: ,LENGTHB(anc_id_36))
5725: )
5726:
5727: WHEN anc_id_37 IS NOT NULL THEN
5728: INTO xla_ae_line_acs (
5729: ae_header_id , ae_line_num , object_version_number
5730: , analytical_criterion_code
5731: , analytical_criterion_type_code
5732: , amb_context_code

Line 5768: INTO xla_ae_line_acs (

5764: ,LENGTHB(anc_id_37))
5765: )
5766:
5767: WHEN anc_id_38 IS NOT NULL THEN
5768: INTO xla_ae_line_acs (
5769: ae_header_id , ae_line_num , object_version_number
5770: , analytical_criterion_code
5771: , analytical_criterion_type_code
5772: , amb_context_code

Line 5808: INTO xla_ae_line_acs (

5804: ,LENGTHB(anc_id_38))
5805: )
5806:
5807: WHEN anc_id_39 IS NOT NULL THEN
5808: INTO xla_ae_line_acs (
5809: ae_header_id , ae_line_num , object_version_number
5810: , analytical_criterion_code
5811: , analytical_criterion_type_code
5812: , amb_context_code

Line 5848: INTO xla_ae_line_acs (

5844: ,LENGTHB(anc_id_39))
5845: )
5846:
5847: WHEN anc_id_40 IS NOT NULL THEN
5848: INTO xla_ae_line_acs (
5849: ae_header_id , ae_line_num , object_version_number
5850: , analytical_criterion_code
5851: , analytical_criterion_type_code
5852: , amb_context_code

Line 5888: INTO xla_ae_line_acs (

5884: ,LENGTHB(anc_id_40))
5885: )
5886:
5887: WHEN anc_id_41 IS NOT NULL THEN
5888: INTO xla_ae_line_acs (
5889: ae_header_id , ae_line_num , object_version_number
5890: , analytical_criterion_code
5891: , analytical_criterion_type_code
5892: , amb_context_code

Line 5928: INTO xla_ae_line_acs (

5924: ,LENGTHB(anc_id_41))
5925: )
5926:
5927: WHEN anc_id_42 IS NOT NULL THEN
5928: INTO xla_ae_line_acs (
5929: ae_header_id , ae_line_num , object_version_number
5930: , analytical_criterion_code
5931: , analytical_criterion_type_code
5932: , amb_context_code

Line 5968: INTO xla_ae_line_acs (

5964: ,LENGTHB(anc_id_42))
5965: )
5966:
5967: WHEN anc_id_43 IS NOT NULL THEN
5968: INTO xla_ae_line_acs (
5969: ae_header_id , ae_line_num , object_version_number
5970: , analytical_criterion_code
5971: , analytical_criterion_type_code
5972: , amb_context_code

Line 6008: INTO xla_ae_line_acs (

6004: ,LENGTHB(anc_id_43))
6005: )
6006:
6007: WHEN anc_id_44 IS NOT NULL THEN
6008: INTO xla_ae_line_acs (
6009: ae_header_id , ae_line_num , object_version_number
6010: , analytical_criterion_code
6011: , analytical_criterion_type_code
6012: , amb_context_code

Line 6048: INTO xla_ae_line_acs (

6044: ,LENGTHB(anc_id_44))
6045: )
6046:
6047: WHEN anc_id_45 IS NOT NULL THEN
6048: INTO xla_ae_line_acs (
6049: ae_header_id , ae_line_num , object_version_number
6050: , analytical_criterion_code
6051: , analytical_criterion_type_code
6052: , amb_context_code

Line 6088: INTO xla_ae_line_acs (

6084: ,LENGTHB(anc_id_45))
6085: )
6086:
6087: WHEN anc_id_46 IS NOT NULL THEN
6088: INTO xla_ae_line_acs (
6089: ae_header_id , ae_line_num , object_version_number
6090: , analytical_criterion_code
6091: , analytical_criterion_type_code
6092: , amb_context_code

Line 6128: INTO xla_ae_line_acs (

6124: ,LENGTHB(anc_id_46))
6125: )
6126:
6127: WHEN anc_id_47 IS NOT NULL THEN
6128: INTO xla_ae_line_acs (
6129: ae_header_id , ae_line_num , object_version_number
6130: , analytical_criterion_code
6131: , analytical_criterion_type_code
6132: , amb_context_code

Line 6168: INTO xla_ae_line_acs (

6164: ,LENGTHB(anc_id_47))
6165: )
6166:
6167: WHEN anc_id_48 IS NOT NULL THEN
6168: INTO xla_ae_line_acs (
6169: ae_header_id , ae_line_num , object_version_number
6170: , analytical_criterion_code
6171: , analytical_criterion_type_code
6172: , amb_context_code

Line 6208: INTO xla_ae_line_acs (

6204: ,LENGTHB(anc_id_48))
6205: )
6206:
6207: WHEN anc_id_49 IS NOT NULL THEN
6208: INTO xla_ae_line_acs (
6209: ae_header_id , ae_line_num , object_version_number
6210: , analytical_criterion_code
6211: , analytical_criterion_type_code
6212: , amb_context_code

Line 6248: INTO xla_ae_line_acs (

6244: ,LENGTHB(anc_id_49))
6245: )
6246:
6247: WHEN anc_id_50 IS NOT NULL THEN
6248: INTO xla_ae_line_acs (
6249: ae_header_id , ae_line_num , object_version_number
6250: , analytical_criterion_code
6251: , analytical_criterion_type_code
6252: , amb_context_code

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

6397: l_rowcount := SQL%ROWCOUNT;
6398:
6399: IF (C_LEVEL_EVENT >= g_log_level) THEN
6400: trace
6401: (p_msg => '# line analytical criteria inserted into xla_ae_line_acs = '||l_rowcount
6402: ,p_level => C_LEVEL_EVENT
6403: ,p_module => l_log_module);
6404: END IF;
6405:

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

6476:
6477: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6478:
6479: trace
6480: (p_msg => 'SQL - Insert into xla_ae_line_acs'
6481: ,p_level => C_LEVEL_STATEMENT
6482: ,p_module => l_log_module);
6483:
6484: END IF;

Line 6488: INTO xla_ae_line_acs (

6484: END IF;
6485:
6486: INSERT ALL
6487: WHEN anc_id_1 IS NOT NULL THEN
6488: INTO xla_ae_line_acs (
6489: ae_header_id , ae_line_num , object_version_number
6490: , analytical_criterion_code
6491: , analytical_criterion_type_code
6492: , amb_context_code

Line 6528: INTO xla_ae_line_acs (

6524: ,LENGTHB(anc_id_1))
6525: )
6526:
6527: WHEN anc_id_2 IS NOT NULL THEN
6528: INTO xla_ae_line_acs (
6529: ae_header_id , ae_line_num , object_version_number
6530: , analytical_criterion_code
6531: , analytical_criterion_type_code
6532: , amb_context_code

Line 6568: INTO xla_ae_line_acs (

6564: ,LENGTHB(anc_id_2))
6565: )
6566:
6567: WHEN anc_id_3 IS NOT NULL THEN
6568: INTO xla_ae_line_acs (
6569: ae_header_id , ae_line_num , object_version_number
6570: , analytical_criterion_code
6571: , analytical_criterion_type_code
6572: , amb_context_code

Line 6608: INTO xla_ae_line_acs (

6604: ,LENGTHB(anc_id_3))
6605: )
6606:
6607: WHEN anc_id_4 IS NOT NULL THEN
6608: INTO xla_ae_line_acs (
6609: ae_header_id , ae_line_num , object_version_number
6610: , analytical_criterion_code
6611: , analytical_criterion_type_code
6612: , amb_context_code

Line 6648: INTO xla_ae_line_acs (

6644: ,LENGTHB(anc_id_4))
6645: )
6646:
6647: WHEN anc_id_5 IS NOT NULL THEN
6648: INTO xla_ae_line_acs (
6649: ae_header_id , ae_line_num , object_version_number
6650: , analytical_criterion_code
6651: , analytical_criterion_type_code
6652: , amb_context_code

Line 6688: INTO xla_ae_line_acs (

6684: ,LENGTHB(anc_id_5))
6685: )
6686:
6687: WHEN anc_id_6 IS NOT NULL THEN
6688: INTO xla_ae_line_acs (
6689: ae_header_id , ae_line_num , object_version_number
6690: , analytical_criterion_code
6691: , analytical_criterion_type_code
6692: , amb_context_code

Line 6728: INTO xla_ae_line_acs (

6724: ,LENGTHB(anc_id_6))
6725: )
6726:
6727: WHEN anc_id_7 IS NOT NULL THEN
6728: INTO xla_ae_line_acs (
6729: ae_header_id , ae_line_num , object_version_number
6730: , analytical_criterion_code
6731: , analytical_criterion_type_code
6732: , amb_context_code

Line 6768: INTO xla_ae_line_acs (

6764: ,LENGTHB(anc_id_7))
6765: )
6766:
6767: WHEN anc_id_8 IS NOT NULL THEN
6768: INTO xla_ae_line_acs (
6769: ae_header_id , ae_line_num , object_version_number
6770: , analytical_criterion_code
6771: , analytical_criterion_type_code
6772: , amb_context_code

Line 6808: INTO xla_ae_line_acs (

6804: ,LENGTHB(anc_id_8))
6805: )
6806:
6807: WHEN anc_id_9 IS NOT NULL THEN
6808: INTO xla_ae_line_acs (
6809: ae_header_id , ae_line_num , object_version_number
6810: , analytical_criterion_code
6811: , analytical_criterion_type_code
6812: , amb_context_code

Line 6848: INTO xla_ae_line_acs (

6844: ,LENGTHB(anc_id_9))
6845: )
6846:
6847: WHEN anc_id_10 IS NOT NULL THEN
6848: INTO xla_ae_line_acs (
6849: ae_header_id , ae_line_num , object_version_number
6850: , analytical_criterion_code
6851: , analytical_criterion_type_code
6852: , amb_context_code

Line 6888: INTO xla_ae_line_acs (

6884: ,LENGTHB(anc_id_10))
6885: )
6886:
6887: WHEN anc_id_11 IS NOT NULL THEN
6888: INTO xla_ae_line_acs (
6889: ae_header_id , ae_line_num , object_version_number
6890: , analytical_criterion_code
6891: , analytical_criterion_type_code
6892: , amb_context_code

Line 6928: INTO xla_ae_line_acs (

6924: ,LENGTHB(anc_id_11))
6925: )
6926:
6927: WHEN anc_id_12 IS NOT NULL THEN
6928: INTO xla_ae_line_acs (
6929: ae_header_id , ae_line_num , object_version_number
6930: , analytical_criterion_code
6931: , analytical_criterion_type_code
6932: , amb_context_code

Line 6968: INTO xla_ae_line_acs (

6964: ,LENGTHB(anc_id_12))
6965: )
6966:
6967: WHEN anc_id_13 IS NOT NULL THEN
6968: INTO xla_ae_line_acs (
6969: ae_header_id , ae_line_num , object_version_number
6970: , analytical_criterion_code
6971: , analytical_criterion_type_code
6972: , amb_context_code

Line 7008: INTO xla_ae_line_acs (

7004: ,LENGTHB(anc_id_13))
7005: )
7006:
7007: WHEN anc_id_14 IS NOT NULL THEN
7008: INTO xla_ae_line_acs (
7009: ae_header_id , ae_line_num , object_version_number
7010: , analytical_criterion_code
7011: , analytical_criterion_type_code
7012: , amb_context_code

Line 7048: INTO xla_ae_line_acs (

7044: ,LENGTHB(anc_id_14))
7045: )
7046:
7047: WHEN anc_id_15 IS NOT NULL THEN
7048: INTO xla_ae_line_acs (
7049: ae_header_id , ae_line_num , object_version_number
7050: , analytical_criterion_code
7051: , analytical_criterion_type_code
7052: , amb_context_code

Line 7088: INTO xla_ae_line_acs (

7084: ,LENGTHB(anc_id_15))
7085: )
7086:
7087: WHEN anc_id_16 IS NOT NULL THEN
7088: INTO xla_ae_line_acs (
7089: ae_header_id , ae_line_num , object_version_number
7090: , analytical_criterion_code
7091: , analytical_criterion_type_code
7092: , amb_context_code

Line 7128: INTO xla_ae_line_acs (

7124: ,LENGTHB(anc_id_16))
7125: )
7126:
7127: WHEN anc_id_17 IS NOT NULL THEN
7128: INTO xla_ae_line_acs (
7129: ae_header_id , ae_line_num , object_version_number
7130: , analytical_criterion_code
7131: , analytical_criterion_type_code
7132: , amb_context_code

Line 7168: INTO xla_ae_line_acs (

7164: ,LENGTHB(anc_id_17))
7165: )
7166:
7167: WHEN anc_id_18 IS NOT NULL THEN
7168: INTO xla_ae_line_acs (
7169: ae_header_id , ae_line_num , object_version_number
7170: , analytical_criterion_code
7171: , analytical_criterion_type_code
7172: , amb_context_code

Line 7208: INTO xla_ae_line_acs (

7204: ,LENGTHB(anc_id_18))
7205: )
7206:
7207: WHEN anc_id_19 IS NOT NULL THEN
7208: INTO xla_ae_line_acs (
7209: ae_header_id , ae_line_num , object_version_number
7210: , analytical_criterion_code
7211: , analytical_criterion_type_code
7212: , amb_context_code

Line 7248: INTO xla_ae_line_acs (

7244: ,LENGTHB(anc_id_19))
7245: )
7246:
7247: WHEN anc_id_20 IS NOT NULL THEN
7248: INTO xla_ae_line_acs (
7249: ae_header_id , ae_line_num , object_version_number
7250: , analytical_criterion_code
7251: , analytical_criterion_type_code
7252: , amb_context_code

Line 7288: INTO xla_ae_line_acs (

7284: ,LENGTHB(anc_id_20))
7285: )
7286:
7287: WHEN anc_id_21 IS NOT NULL THEN
7288: INTO xla_ae_line_acs (
7289: ae_header_id , ae_line_num , object_version_number
7290: , analytical_criterion_code
7291: , analytical_criterion_type_code
7292: , amb_context_code

Line 7328: INTO xla_ae_line_acs (

7324: ,LENGTHB(anc_id_21))
7325: )
7326:
7327: WHEN anc_id_22 IS NOT NULL THEN
7328: INTO xla_ae_line_acs (
7329: ae_header_id , ae_line_num , object_version_number
7330: , analytical_criterion_code
7331: , analytical_criterion_type_code
7332: , amb_context_code

Line 7368: INTO xla_ae_line_acs (

7364: ,LENGTHB(anc_id_22))
7365: )
7366:
7367: WHEN anc_id_23 IS NOT NULL THEN
7368: INTO xla_ae_line_acs (
7369: ae_header_id , ae_line_num , object_version_number
7370: , analytical_criterion_code
7371: , analytical_criterion_type_code
7372: , amb_context_code

Line 7408: INTO xla_ae_line_acs (

7404: ,LENGTHB(anc_id_23))
7405: )
7406:
7407: WHEN anc_id_24 IS NOT NULL THEN
7408: INTO xla_ae_line_acs (
7409: ae_header_id , ae_line_num , object_version_number
7410: , analytical_criterion_code
7411: , analytical_criterion_type_code
7412: , amb_context_code

Line 7448: INTO xla_ae_line_acs (

7444: ,LENGTHB(anc_id_24))
7445: )
7446:
7447: WHEN anc_id_25 IS NOT NULL THEN
7448: INTO xla_ae_line_acs (
7449: ae_header_id , ae_line_num , object_version_number
7450: , analytical_criterion_code
7451: , analytical_criterion_type_code
7452: , amb_context_code

Line 7488: INTO xla_ae_line_acs (

7484: ,LENGTHB(anc_id_25))
7485: )
7486:
7487: WHEN anc_id_26 IS NOT NULL THEN
7488: INTO xla_ae_line_acs (
7489: ae_header_id , ae_line_num , object_version_number
7490: , analytical_criterion_code
7491: , analytical_criterion_type_code
7492: , amb_context_code

Line 7528: INTO xla_ae_line_acs (

7524: ,LENGTHB(anc_id_26))
7525: )
7526:
7527: WHEN anc_id_27 IS NOT NULL THEN
7528: INTO xla_ae_line_acs (
7529: ae_header_id , ae_line_num , object_version_number
7530: , analytical_criterion_code
7531: , analytical_criterion_type_code
7532: , amb_context_code

Line 7568: INTO xla_ae_line_acs (

7564: ,LENGTHB(anc_id_27))
7565: )
7566:
7567: WHEN anc_id_28 IS NOT NULL THEN
7568: INTO xla_ae_line_acs (
7569: ae_header_id , ae_line_num , object_version_number
7570: , analytical_criterion_code
7571: , analytical_criterion_type_code
7572: , amb_context_code

Line 7608: INTO xla_ae_line_acs (

7604: ,LENGTHB(anc_id_28))
7605: )
7606:
7607: WHEN anc_id_29 IS NOT NULL THEN
7608: INTO xla_ae_line_acs (
7609: ae_header_id , ae_line_num , object_version_number
7610: , analytical_criterion_code
7611: , analytical_criterion_type_code
7612: , amb_context_code

Line 7648: INTO xla_ae_line_acs (

7644: ,LENGTHB(anc_id_29))
7645: )
7646:
7647: WHEN anc_id_30 IS NOT NULL THEN
7648: INTO xla_ae_line_acs (
7649: ae_header_id , ae_line_num , object_version_number
7650: , analytical_criterion_code
7651: , analytical_criterion_type_code
7652: , amb_context_code

Line 7688: INTO xla_ae_line_acs (

7684: ,LENGTHB(anc_id_30))
7685: )
7686:
7687: WHEN anc_id_31 IS NOT NULL THEN
7688: INTO xla_ae_line_acs (
7689: ae_header_id , ae_line_num , object_version_number
7690: , analytical_criterion_code
7691: , analytical_criterion_type_code
7692: , amb_context_code

Line 7728: INTO xla_ae_line_acs (

7724: ,LENGTHB(anc_id_31))
7725: )
7726:
7727: WHEN anc_id_32 IS NOT NULL THEN
7728: INTO xla_ae_line_acs (
7729: ae_header_id , ae_line_num , object_version_number
7730: , analytical_criterion_code
7731: , analytical_criterion_type_code
7732: , amb_context_code

Line 7768: INTO xla_ae_line_acs (

7764: ,LENGTHB(anc_id_32))
7765: )
7766:
7767: WHEN anc_id_33 IS NOT NULL THEN
7768: INTO xla_ae_line_acs (
7769: ae_header_id , ae_line_num , object_version_number
7770: , analytical_criterion_code
7771: , analytical_criterion_type_code
7772: , amb_context_code

Line 7808: INTO xla_ae_line_acs (

7804: ,LENGTHB(anc_id_33))
7805: )
7806:
7807: WHEN anc_id_34 IS NOT NULL THEN
7808: INTO xla_ae_line_acs (
7809: ae_header_id , ae_line_num , object_version_number
7810: , analytical_criterion_code
7811: , analytical_criterion_type_code
7812: , amb_context_code

Line 7848: INTO xla_ae_line_acs (

7844: ,LENGTHB(anc_id_34))
7845: )
7846:
7847: WHEN anc_id_35 IS NOT NULL THEN
7848: INTO xla_ae_line_acs (
7849: ae_header_id , ae_line_num , object_version_number
7850: , analytical_criterion_code
7851: , analytical_criterion_type_code
7852: , amb_context_code

Line 7888: INTO xla_ae_line_acs (

7884: ,LENGTHB(anc_id_35))
7885: )
7886:
7887: WHEN anc_id_36 IS NOT NULL THEN
7888: INTO xla_ae_line_acs (
7889: ae_header_id , ae_line_num , object_version_number
7890: , analytical_criterion_code
7891: , analytical_criterion_type_code
7892: , amb_context_code

Line 7928: INTO xla_ae_line_acs (

7924: ,LENGTHB(anc_id_36))
7925: )
7926:
7927: WHEN anc_id_37 IS NOT NULL THEN
7928: INTO xla_ae_line_acs (
7929: ae_header_id , ae_line_num , object_version_number
7930: , analytical_criterion_code
7931: , analytical_criterion_type_code
7932: , amb_context_code

Line 7968: INTO xla_ae_line_acs (

7964: ,LENGTHB(anc_id_37))
7965: )
7966:
7967: WHEN anc_id_38 IS NOT NULL THEN
7968: INTO xla_ae_line_acs (
7969: ae_header_id , ae_line_num , object_version_number
7970: , analytical_criterion_code
7971: , analytical_criterion_type_code
7972: , amb_context_code

Line 8008: INTO xla_ae_line_acs (

8004: ,LENGTHB(anc_id_38))
8005: )
8006:
8007: WHEN anc_id_39 IS NOT NULL THEN
8008: INTO xla_ae_line_acs (
8009: ae_header_id , ae_line_num , object_version_number
8010: , analytical_criterion_code
8011: , analytical_criterion_type_code
8012: , amb_context_code

Line 8048: INTO xla_ae_line_acs (

8044: ,LENGTHB(anc_id_39))
8045: )
8046:
8047: WHEN anc_id_40 IS NOT NULL THEN
8048: INTO xla_ae_line_acs (
8049: ae_header_id , ae_line_num , object_version_number
8050: , analytical_criterion_code
8051: , analytical_criterion_type_code
8052: , amb_context_code

Line 8088: INTO xla_ae_line_acs (

8084: ,LENGTHB(anc_id_40))
8085: )
8086:
8087: WHEN anc_id_41 IS NOT NULL THEN
8088: INTO xla_ae_line_acs (
8089: ae_header_id , ae_line_num , object_version_number
8090: , analytical_criterion_code
8091: , analytical_criterion_type_code
8092: , amb_context_code

Line 8128: INTO xla_ae_line_acs (

8124: ,LENGTHB(anc_id_41))
8125: )
8126:
8127: WHEN anc_id_42 IS NOT NULL THEN
8128: INTO xla_ae_line_acs (
8129: ae_header_id , ae_line_num , object_version_number
8130: , analytical_criterion_code
8131: , analytical_criterion_type_code
8132: , amb_context_code

Line 8168: INTO xla_ae_line_acs (

8164: ,LENGTHB(anc_id_42))
8165: )
8166:
8167: WHEN anc_id_43 IS NOT NULL THEN
8168: INTO xla_ae_line_acs (
8169: ae_header_id , ae_line_num , object_version_number
8170: , analytical_criterion_code
8171: , analytical_criterion_type_code
8172: , amb_context_code

Line 8208: INTO xla_ae_line_acs (

8204: ,LENGTHB(anc_id_43))
8205: )
8206:
8207: WHEN anc_id_44 IS NOT NULL THEN
8208: INTO xla_ae_line_acs (
8209: ae_header_id , ae_line_num , object_version_number
8210: , analytical_criterion_code
8211: , analytical_criterion_type_code
8212: , amb_context_code

Line 8248: INTO xla_ae_line_acs (

8244: ,LENGTHB(anc_id_44))
8245: )
8246:
8247: WHEN anc_id_45 IS NOT NULL THEN
8248: INTO xla_ae_line_acs (
8249: ae_header_id , ae_line_num , object_version_number
8250: , analytical_criterion_code
8251: , analytical_criterion_type_code
8252: , amb_context_code

Line 8288: INTO xla_ae_line_acs (

8284: ,LENGTHB(anc_id_45))
8285: )
8286:
8287: WHEN anc_id_46 IS NOT NULL THEN
8288: INTO xla_ae_line_acs (
8289: ae_header_id , ae_line_num , object_version_number
8290: , analytical_criterion_code
8291: , analytical_criterion_type_code
8292: , amb_context_code

Line 8328: INTO xla_ae_line_acs (

8324: ,LENGTHB(anc_id_46))
8325: )
8326:
8327: WHEN anc_id_47 IS NOT NULL THEN
8328: INTO xla_ae_line_acs (
8329: ae_header_id , ae_line_num , object_version_number
8330: , analytical_criterion_code
8331: , analytical_criterion_type_code
8332: , amb_context_code

Line 8368: INTO xla_ae_line_acs (

8364: ,LENGTHB(anc_id_47))
8365: )
8366:
8367: WHEN anc_id_48 IS NOT NULL THEN
8368: INTO xla_ae_line_acs (
8369: ae_header_id , ae_line_num , object_version_number
8370: , analytical_criterion_code
8371: , analytical_criterion_type_code
8372: , amb_context_code

Line 8408: INTO xla_ae_line_acs (

8404: ,LENGTHB(anc_id_48))
8405: )
8406:
8407: WHEN anc_id_49 IS NOT NULL THEN
8408: INTO xla_ae_line_acs (
8409: ae_header_id , ae_line_num , object_version_number
8410: , analytical_criterion_code
8411: , analytical_criterion_type_code
8412: , amb_context_code

Line 8448: INTO xla_ae_line_acs (

8444: ,LENGTHB(anc_id_49))
8445: )
8446:
8447: WHEN anc_id_50 IS NOT NULL THEN
8448: INTO xla_ae_line_acs (
8449: ae_header_id , ae_line_num , object_version_number
8450: , analytical_criterion_code
8451: , analytical_criterion_type_code
8452: , amb_context_code

Line 8488: INTO xla_ae_line_acs (

8484: ,LENGTHB(anc_id_50))
8485: )
8486:
8487: WHEN anc_id_51 IS NOT NULL THEN
8488: INTO xla_ae_line_acs (
8489: ae_header_id , ae_line_num , object_version_number
8490: , analytical_criterion_code
8491: , analytical_criterion_type_code
8492: , amb_context_code

Line 8528: INTO xla_ae_line_acs (

8524: ,LENGTHB(anc_id_51))
8525: )
8526:
8527: WHEN anc_id_52 IS NOT NULL THEN
8528: INTO xla_ae_line_acs (
8529: ae_header_id , ae_line_num , object_version_number
8530: , analytical_criterion_code
8531: , analytical_criterion_type_code
8532: , amb_context_code

Line 8568: INTO xla_ae_line_acs (

8564: ,LENGTHB(anc_id_52))
8565: )
8566:
8567: WHEN anc_id_53 IS NOT NULL THEN
8568: INTO xla_ae_line_acs (
8569: ae_header_id , ae_line_num , object_version_number
8570: , analytical_criterion_code
8571: , analytical_criterion_type_code
8572: , amb_context_code

Line 8608: INTO xla_ae_line_acs (

8604: ,LENGTHB(anc_id_53))
8605: )
8606:
8607: WHEN anc_id_54 IS NOT NULL THEN
8608: INTO xla_ae_line_acs (
8609: ae_header_id , ae_line_num , object_version_number
8610: , analytical_criterion_code
8611: , analytical_criterion_type_code
8612: , amb_context_code

Line 8648: INTO xla_ae_line_acs (

8644: ,LENGTHB(anc_id_54))
8645: )
8646:
8647: WHEN anc_id_55 IS NOT NULL THEN
8648: INTO xla_ae_line_acs (
8649: ae_header_id , ae_line_num , object_version_number
8650: , analytical_criterion_code
8651: , analytical_criterion_type_code
8652: , amb_context_code

Line 8688: INTO xla_ae_line_acs (

8684: ,LENGTHB(anc_id_55))
8685: )
8686:
8687: WHEN anc_id_56 IS NOT NULL THEN
8688: INTO xla_ae_line_acs (
8689: ae_header_id , ae_line_num , object_version_number
8690: , analytical_criterion_code
8691: , analytical_criterion_type_code
8692: , amb_context_code

Line 8728: INTO xla_ae_line_acs (

8724: ,LENGTHB(anc_id_56))
8725: )
8726:
8727: WHEN anc_id_57 IS NOT NULL THEN
8728: INTO xla_ae_line_acs (
8729: ae_header_id , ae_line_num , object_version_number
8730: , analytical_criterion_code
8731: , analytical_criterion_type_code
8732: , amb_context_code

Line 8768: INTO xla_ae_line_acs (

8764: ,LENGTHB(anc_id_57))
8765: )
8766:
8767: WHEN anc_id_58 IS NOT NULL THEN
8768: INTO xla_ae_line_acs (
8769: ae_header_id , ae_line_num , object_version_number
8770: , analytical_criterion_code
8771: , analytical_criterion_type_code
8772: , amb_context_code

Line 8808: INTO xla_ae_line_acs (

8804: ,LENGTHB(anc_id_58))
8805: )
8806:
8807: WHEN anc_id_59 IS NOT NULL THEN
8808: INTO xla_ae_line_acs (
8809: ae_header_id , ae_line_num , object_version_number
8810: , analytical_criterion_code
8811: , analytical_criterion_type_code
8812: , amb_context_code

Line 8848: INTO xla_ae_line_acs (

8844: ,LENGTHB(anc_id_59))
8845: )
8846:
8847: WHEN anc_id_60 IS NOT NULL THEN
8848: INTO xla_ae_line_acs (
8849: ae_header_id , ae_line_num , object_version_number
8850: , analytical_criterion_code
8851: , analytical_criterion_type_code
8852: , amb_context_code

Line 8888: INTO xla_ae_line_acs (

8884: ,LENGTHB(anc_id_60))
8885: )
8886:
8887: WHEN anc_id_61 IS NOT NULL THEN
8888: INTO xla_ae_line_acs (
8889: ae_header_id , ae_line_num , object_version_number
8890: , analytical_criterion_code
8891: , analytical_criterion_type_code
8892: , amb_context_code

Line 8928: INTO xla_ae_line_acs (

8924: ,LENGTHB(anc_id_61))
8925: )
8926:
8927: WHEN anc_id_62 IS NOT NULL THEN
8928: INTO xla_ae_line_acs (
8929: ae_header_id , ae_line_num , object_version_number
8930: , analytical_criterion_code
8931: , analytical_criterion_type_code
8932: , amb_context_code

Line 8968: INTO xla_ae_line_acs (

8964: ,LENGTHB(anc_id_62))
8965: )
8966:
8967: WHEN anc_id_63 IS NOT NULL THEN
8968: INTO xla_ae_line_acs (
8969: ae_header_id , ae_line_num , object_version_number
8970: , analytical_criterion_code
8971: , analytical_criterion_type_code
8972: , amb_context_code

Line 9008: INTO xla_ae_line_acs (

9004: ,LENGTHB(anc_id_63))
9005: )
9006:
9007: WHEN anc_id_64 IS NOT NULL THEN
9008: INTO xla_ae_line_acs (
9009: ae_header_id , ae_line_num , object_version_number
9010: , analytical_criterion_code
9011: , analytical_criterion_type_code
9012: , amb_context_code

Line 9048: INTO xla_ae_line_acs (

9044: ,LENGTHB(anc_id_64))
9045: )
9046:
9047: WHEN anc_id_65 IS NOT NULL THEN
9048: INTO xla_ae_line_acs (
9049: ae_header_id , ae_line_num , object_version_number
9050: , analytical_criterion_code
9051: , analytical_criterion_type_code
9052: , amb_context_code

Line 9088: INTO xla_ae_line_acs (

9084: ,LENGTHB(anc_id_65))
9085: )
9086:
9087: WHEN anc_id_66 IS NOT NULL THEN
9088: INTO xla_ae_line_acs (
9089: ae_header_id , ae_line_num , object_version_number
9090: , analytical_criterion_code
9091: , analytical_criterion_type_code
9092: , amb_context_code

Line 9128: INTO xla_ae_line_acs (

9124: ,LENGTHB(anc_id_66))
9125: )
9126:
9127: WHEN anc_id_67 IS NOT NULL THEN
9128: INTO xla_ae_line_acs (
9129: ae_header_id , ae_line_num , object_version_number
9130: , analytical_criterion_code
9131: , analytical_criterion_type_code
9132: , amb_context_code

Line 9168: INTO xla_ae_line_acs (

9164: ,LENGTHB(anc_id_67))
9165: )
9166:
9167: WHEN anc_id_68 IS NOT NULL THEN
9168: INTO xla_ae_line_acs (
9169: ae_header_id , ae_line_num , object_version_number
9170: , analytical_criterion_code
9171: , analytical_criterion_type_code
9172: , amb_context_code

Line 9208: INTO xla_ae_line_acs (

9204: ,LENGTHB(anc_id_68))
9205: )
9206:
9207: WHEN anc_id_69 IS NOT NULL THEN
9208: INTO xla_ae_line_acs (
9209: ae_header_id , ae_line_num , object_version_number
9210: , analytical_criterion_code
9211: , analytical_criterion_type_code
9212: , amb_context_code

Line 9248: INTO xla_ae_line_acs (

9244: ,LENGTHB(anc_id_69))
9245: )
9246:
9247: WHEN anc_id_70 IS NOT NULL THEN
9248: INTO xla_ae_line_acs (
9249: ae_header_id , ae_line_num , object_version_number
9250: , analytical_criterion_code
9251: , analytical_criterion_type_code
9252: , amb_context_code

Line 9288: INTO xla_ae_line_acs (

9284: ,LENGTHB(anc_id_70))
9285: )
9286:
9287: WHEN anc_id_71 IS NOT NULL THEN
9288: INTO xla_ae_line_acs (
9289: ae_header_id , ae_line_num , object_version_number
9290: , analytical_criterion_code
9291: , analytical_criterion_type_code
9292: , amb_context_code

Line 9328: INTO xla_ae_line_acs (

9324: ,LENGTHB(anc_id_71))
9325: )
9326:
9327: WHEN anc_id_72 IS NOT NULL THEN
9328: INTO xla_ae_line_acs (
9329: ae_header_id , ae_line_num , object_version_number
9330: , analytical_criterion_code
9331: , analytical_criterion_type_code
9332: , amb_context_code

Line 9368: INTO xla_ae_line_acs (

9364: ,LENGTHB(anc_id_72))
9365: )
9366:
9367: WHEN anc_id_73 IS NOT NULL THEN
9368: INTO xla_ae_line_acs (
9369: ae_header_id , ae_line_num , object_version_number
9370: , analytical_criterion_code
9371: , analytical_criterion_type_code
9372: , amb_context_code

Line 9408: INTO xla_ae_line_acs (

9404: ,LENGTHB(anc_id_73))
9405: )
9406:
9407: WHEN anc_id_74 IS NOT NULL THEN
9408: INTO xla_ae_line_acs (
9409: ae_header_id , ae_line_num , object_version_number
9410: , analytical_criterion_code
9411: , analytical_criterion_type_code
9412: , amb_context_code

Line 9448: INTO xla_ae_line_acs (

9444: ,LENGTHB(anc_id_74))
9445: )
9446:
9447: WHEN anc_id_75 IS NOT NULL THEN
9448: INTO xla_ae_line_acs (
9449: ae_header_id , ae_line_num , object_version_number
9450: , analytical_criterion_code
9451: , analytical_criterion_type_code
9452: , amb_context_code

Line 9488: INTO xla_ae_line_acs (

9484: ,LENGTHB(anc_id_75))
9485: )
9486:
9487: WHEN anc_id_76 IS NOT NULL THEN
9488: INTO xla_ae_line_acs (
9489: ae_header_id , ae_line_num , object_version_number
9490: , analytical_criterion_code
9491: , analytical_criterion_type_code
9492: , amb_context_code

Line 9528: INTO xla_ae_line_acs (

9524: ,LENGTHB(anc_id_76))
9525: )
9526:
9527: WHEN anc_id_77 IS NOT NULL THEN
9528: INTO xla_ae_line_acs (
9529: ae_header_id , ae_line_num , object_version_number
9530: , analytical_criterion_code
9531: , analytical_criterion_type_code
9532: , amb_context_code

Line 9568: INTO xla_ae_line_acs (

9564: ,LENGTHB(anc_id_77))
9565: )
9566:
9567: WHEN anc_id_78 IS NOT NULL THEN
9568: INTO xla_ae_line_acs (
9569: ae_header_id , ae_line_num , object_version_number
9570: , analytical_criterion_code
9571: , analytical_criterion_type_code
9572: , amb_context_code

Line 9608: INTO xla_ae_line_acs (

9604: ,LENGTHB(anc_id_78))
9605: )
9606:
9607: WHEN anc_id_79 IS NOT NULL THEN
9608: INTO xla_ae_line_acs (
9609: ae_header_id , ae_line_num , object_version_number
9610: , analytical_criterion_code
9611: , analytical_criterion_type_code
9612: , amb_context_code

Line 9648: INTO xla_ae_line_acs (

9644: ,LENGTHB(anc_id_79))
9645: )
9646:
9647: WHEN anc_id_80 IS NOT NULL THEN
9648: INTO xla_ae_line_acs (
9649: ae_header_id , ae_line_num , object_version_number
9650: , analytical_criterion_code
9651: , analytical_criterion_type_code
9652: , amb_context_code

Line 9688: INTO xla_ae_line_acs (

9684: ,LENGTHB(anc_id_80))
9685: )
9686:
9687: WHEN anc_id_81 IS NOT NULL THEN
9688: INTO xla_ae_line_acs (
9689: ae_header_id , ae_line_num , object_version_number
9690: , analytical_criterion_code
9691: , analytical_criterion_type_code
9692: , amb_context_code

Line 9728: INTO xla_ae_line_acs (

9724: ,LENGTHB(anc_id_81))
9725: )
9726:
9727: WHEN anc_id_82 IS NOT NULL THEN
9728: INTO xla_ae_line_acs (
9729: ae_header_id , ae_line_num , object_version_number
9730: , analytical_criterion_code
9731: , analytical_criterion_type_code
9732: , amb_context_code

Line 9768: INTO xla_ae_line_acs (

9764: ,LENGTHB(anc_id_82))
9765: )
9766:
9767: WHEN anc_id_83 IS NOT NULL THEN
9768: INTO xla_ae_line_acs (
9769: ae_header_id , ae_line_num , object_version_number
9770: , analytical_criterion_code
9771: , analytical_criterion_type_code
9772: , amb_context_code

Line 9808: INTO xla_ae_line_acs (

9804: ,LENGTHB(anc_id_83))
9805: )
9806:
9807: WHEN anc_id_84 IS NOT NULL THEN
9808: INTO xla_ae_line_acs (
9809: ae_header_id , ae_line_num , object_version_number
9810: , analytical_criterion_code
9811: , analytical_criterion_type_code
9812: , amb_context_code

Line 9848: INTO xla_ae_line_acs (

9844: ,LENGTHB(anc_id_84))
9845: )
9846:
9847: WHEN anc_id_85 IS NOT NULL THEN
9848: INTO xla_ae_line_acs (
9849: ae_header_id , ae_line_num , object_version_number
9850: , analytical_criterion_code
9851: , analytical_criterion_type_code
9852: , amb_context_code

Line 9888: INTO xla_ae_line_acs (

9884: ,LENGTHB(anc_id_85))
9885: )
9886:
9887: WHEN anc_id_86 IS NOT NULL THEN
9888: INTO xla_ae_line_acs (
9889: ae_header_id , ae_line_num , object_version_number
9890: , analytical_criterion_code
9891: , analytical_criterion_type_code
9892: , amb_context_code

Line 9928: INTO xla_ae_line_acs (

9924: ,LENGTHB(anc_id_86))
9925: )
9926:
9927: WHEN anc_id_87 IS NOT NULL THEN
9928: INTO xla_ae_line_acs (
9929: ae_header_id , ae_line_num , object_version_number
9930: , analytical_criterion_code
9931: , analytical_criterion_type_code
9932: , amb_context_code

Line 9968: INTO xla_ae_line_acs (

9964: ,LENGTHB(anc_id_87))
9965: )
9966:
9967: WHEN anc_id_88 IS NOT NULL THEN
9968: INTO xla_ae_line_acs (
9969: ae_header_id , ae_line_num , object_version_number
9970: , analytical_criterion_code
9971: , analytical_criterion_type_code
9972: , amb_context_code

Line 10008: INTO xla_ae_line_acs (

10004: ,LENGTHB(anc_id_88))
10005: )
10006:
10007: WHEN anc_id_89 IS NOT NULL THEN
10008: INTO xla_ae_line_acs (
10009: ae_header_id , ae_line_num , object_version_number
10010: , analytical_criterion_code
10011: , analytical_criterion_type_code
10012: , amb_context_code

Line 10048: INTO xla_ae_line_acs (

10044: ,LENGTHB(anc_id_89))
10045: )
10046:
10047: WHEN anc_id_90 IS NOT NULL THEN
10048: INTO xla_ae_line_acs (
10049: ae_header_id , ae_line_num , object_version_number
10050: , analytical_criterion_code
10051: , analytical_criterion_type_code
10052: , amb_context_code

Line 10088: INTO xla_ae_line_acs (

10084: ,LENGTHB(anc_id_90))
10085: )
10086:
10087: WHEN anc_id_91 IS NOT NULL THEN
10088: INTO xla_ae_line_acs (
10089: ae_header_id , ae_line_num , object_version_number
10090: , analytical_criterion_code
10091: , analytical_criterion_type_code
10092: , amb_context_code

Line 10128: INTO xla_ae_line_acs (

10124: ,LENGTHB(anc_id_91))
10125: )
10126:
10127: WHEN anc_id_92 IS NOT NULL THEN
10128: INTO xla_ae_line_acs (
10129: ae_header_id , ae_line_num , object_version_number
10130: , analytical_criterion_code
10131: , analytical_criterion_type_code
10132: , amb_context_code

Line 10168: INTO xla_ae_line_acs (

10164: ,LENGTHB(anc_id_92))
10165: )
10166:
10167: WHEN anc_id_93 IS NOT NULL THEN
10168: INTO xla_ae_line_acs (
10169: ae_header_id , ae_line_num , object_version_number
10170: , analytical_criterion_code
10171: , analytical_criterion_type_code
10172: , amb_context_code

Line 10208: INTO xla_ae_line_acs (

10204: ,LENGTHB(anc_id_93))
10205: )
10206:
10207: WHEN anc_id_94 IS NOT NULL THEN
10208: INTO xla_ae_line_acs (
10209: ae_header_id , ae_line_num , object_version_number
10210: , analytical_criterion_code
10211: , analytical_criterion_type_code
10212: , amb_context_code

Line 10248: INTO xla_ae_line_acs (

10244: ,LENGTHB(anc_id_94))
10245: )
10246:
10247: WHEN anc_id_95 IS NOT NULL THEN
10248: INTO xla_ae_line_acs (
10249: ae_header_id , ae_line_num , object_version_number
10250: , analytical_criterion_code
10251: , analytical_criterion_type_code
10252: , amb_context_code

Line 10288: INTO xla_ae_line_acs (

10284: ,LENGTHB(anc_id_95))
10285: )
10286:
10287: WHEN anc_id_96 IS NOT NULL THEN
10288: INTO xla_ae_line_acs (
10289: ae_header_id , ae_line_num , object_version_number
10290: , analytical_criterion_code
10291: , analytical_criterion_type_code
10292: , amb_context_code

Line 10328: INTO xla_ae_line_acs (

10324: ,LENGTHB(anc_id_96))
10325: )
10326:
10327: WHEN anc_id_97 IS NOT NULL THEN
10328: INTO xla_ae_line_acs (
10329: ae_header_id , ae_line_num , object_version_number
10330: , analytical_criterion_code
10331: , analytical_criterion_type_code
10332: , amb_context_code

Line 10368: INTO xla_ae_line_acs (

10364: ,LENGTHB(anc_id_97))
10365: )
10366:
10367: WHEN anc_id_98 IS NOT NULL THEN
10368: INTO xla_ae_line_acs (
10369: ae_header_id , ae_line_num , object_version_number
10370: , analytical_criterion_code
10371: , analytical_criterion_type_code
10372: , amb_context_code

Line 10408: INTO xla_ae_line_acs (

10404: ,LENGTHB(anc_id_98))
10405: )
10406:
10407: WHEN anc_id_99 IS NOT NULL THEN
10408: INTO xla_ae_line_acs (
10409: ae_header_id , ae_line_num , object_version_number
10410: , analytical_criterion_code
10411: , analytical_criterion_type_code
10412: , amb_context_code

Line 10448: INTO xla_ae_line_acs (

10444: ,LENGTHB(anc_id_99))
10445: )
10446:
10447: WHEN anc_id_100 IS NOT NULL THEN
10448: INTO xla_ae_line_acs (
10449: ae_header_id , ae_line_num , object_version_number
10450: , analytical_criterion_code
10451: , analytical_criterion_type_code
10452: , amb_context_code

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

10697: l_rowcount := SQL%ROWCOUNT;
10698:
10699: IF (C_LEVEL_EVENT >= g_log_level) THEN
10700: trace
10701: (p_msg => '# line analytical criteria inserted into xla_ae_line_acs = '||l_rowcount
10702: ,p_level => C_LEVEL_EVENT
10703: ,p_module => l_log_module);
10704: END IF;
10705:

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

19420:
19421: /*======================================================================+
19422: | PRIVATE PROCEDURE : Insert_ANC_Inv_Canc |
19423: | Bug# 7382288:Insert analytical criteria for invoice cancellation |
19424: | into xla_ae_line_acs table if analytical criteria exists for |
19425: | invoice validation event. |
19426: +======================================================================*/
19427: procedure Insert_ANC_Inv_Canc
19428: is

Line 19449: insert into xla_ae_line_acs (

19445: l_rowcount := 0;
19446: l_array_base_ledgers := xla_accounting_cache_pkg.GetLedgers;
19447:
19448: for i in 1..l_array_base_ledgers.count loop
19449: insert into xla_ae_line_acs (
19450: ae_header_id,
19451: ae_line_num,
19452: analytical_criterion_code,
19453: analytical_criterion_type_code,

Line 19473: from xla_ae_line_acs la,

19469: la.ac2,
19470: la.ac3,
19471: la.ac4,
19472: la.ac5
19473: from xla_ae_line_acs la,
19474: xla_ae_lines_gt gt
19475: where la.ae_header_id=gt.ref_ae_header_id
19476: and gt.ref_ae_header_id<> gt.ae_header_id
19477: and la.ae_line_num = gt.ref_ae_line_num

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

19499: l_rowcount := SQL%ROWCOUNT;
19500:
19501: IF (C_LEVEL_EVENT >= g_log_level) THEN
19502: trace
19503: (p_msg => '# line analytical criteria inserted in xla_ae_line_acs for invoice cancellation = '||l_rowcount
19504: ,p_level => C_LEVEL_EVENT
19505: ,p_module => l_log_module);
19506: END IF;
19507: