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.ZX_MIGRATE_TAX_DEF dependencies on ZX_ACCOUNTS

Line 976: | ZX_ACCOUNTS |

972: | This routine processes AP normal Tax codes and inserts appropriate |
973: | data into the following zx base tables. |
974: | ZX_RATES_B |
975: | ZX_RATES_TL |
976: | ZX_ACCOUNTS |
977: | |
978: | SCOPE - PUBLIC |
979: | |
980: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 1138: INTO zx_accounts

1134: 1
1135: -- 6820043, commenting out description
1136: -- DESCRIPTION -- Bug 4705196
1137: )
1138: INTO zx_accounts
1139: (
1140: TAX_ACCOUNT_ID ,
1141: TAX_ACCOUNT_ENTITY_ID ,
1142: TAX_ACCOUNT_ENTITY_CODE ,

Line 1186: ZX_ACCOUNTS_S.nextval ,

1182: OBJECT_VERSION_NUMBER
1183: )
1184: VALUES
1185: (
1186: ZX_ACCOUNTS_S.nextval ,
1187: zx_rates_b_s.nextval ,--TAX_RATE_ID
1188: 'RATES' ,
1189: LEDGER_ID ,
1190: ORG_ID ,

Line 1555: INTO zx_accounts

1551: 1
1552: -- 6820043, commenting out description
1553: -- DESCRIPTION -- Bug 4705196
1554: )
1555: INTO zx_accounts
1556: (
1557: TAX_ACCOUNT_ID ,
1558: TAX_ACCOUNT_ENTITY_ID ,
1559: TAX_ACCOUNT_ENTITY_CODE ,

Line 1603: ZX_ACCOUNTS_S.nextval ,

1599: OBJECT_VERSION_NUMBER
1600: )
1601: VALUES
1602: (
1603: ZX_ACCOUNTS_S.nextval ,
1604: zx_rates_b_s.nextval ,--TAX_RATE_ID
1605: 'RATES' ,
1606: LEDGER_ID ,
1607: ORG_ID ,

Line 1982: INTO zx_accounts

1978: TAX_RATE_ID
1979: -- 6820043, commenting out description
1980: -- DESCRIPTION -- Bug 4705196
1981: )
1982: INTO zx_accounts
1983: (
1984: TAX_ACCOUNT_ID ,
1985: TAX_ACCOUNT_ENTITY_ID ,
1986: TAX_ACCOUNT_ENTITY_CODE ,

Line 2030: ZX_ACCOUNTS_S.nextval ,

2026: OBJECT_VERSION_NUMBER
2027: )
2028: VALUES
2029: (
2030: ZX_ACCOUNTS_S.nextval ,
2031: TAX_RATE_ID ,
2032: 'RATES' ,
2033: LEDGER_ID ,
2034: ORG_ID ,

Line 2406: INTO zx_accounts

2402: TAX_RATE_ID
2403: -- 6820043, commenting out description
2404: -- DESCRIPTION -- Bug 4705196
2405: )
2406: INTO zx_accounts
2407: (
2408: TAX_ACCOUNT_ID ,
2409: TAX_ACCOUNT_ENTITY_ID ,
2410: TAX_ACCOUNT_ENTITY_CODE ,

Line 2454: ZX_ACCOUNTS_S.nextval ,

2450: OBJECT_VERSION_NUMBER
2451: )
2452: VALUES
2453: (
2454: ZX_ACCOUNTS_S.nextval ,
2455: TAX_RATE_ID ,
2456: 'RATES' ,
2457: LEDGER_ID ,
2458: ORG_ID ,

Line 2777: | ZX_ACCOUNTS |

2773: | This routine processes assigned OFFSET Tax codes and inserts |
2774: | appropriate data into the following zx base tables. |
2775: | ZX_RATES_B |
2776: | ZX_RATES_TL |
2777: | ZX_ACCOUNTS |
2778: | |
2779: | SCOPE - PUBLIC |
2780: | |
2781: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 2937: INTO zx_accounts

2933: 1
2934: -- 6820043, commenting out description
2935: -- DESCRIPTION -- Bug 4705196
2936: )
2937: INTO zx_accounts
2938: (
2939: TAX_ACCOUNT_ID ,
2940: TAX_ACCOUNT_ENTITY_ID ,
2941: TAX_ACCOUNT_ENTITY_CODE ,

Line 2985: ZX_ACCOUNTS_S.NEXTVAL,

2981: OBJECT_VERSION_NUMBER
2982: )
2983: VALUES
2984: (
2985: ZX_ACCOUNTS_S.NEXTVAL,
2986: zx_rates_b_s.nextval ,--TAX_RATE_ID
2987: 'RATES' ,
2988: LEDGER_ID ,
2989: ORG_ID ,

Line 3250: INTO zx_accounts

3246: 1
3247: -- 6820043, commenting out description
3248: -- DESCRIPTION -- Bug 4705196
3249: )
3250: INTO zx_accounts
3251: (
3252: TAX_ACCOUNT_ID ,
3253: TAX_ACCOUNT_ENTITY_ID ,
3254: TAX_ACCOUNT_ENTITY_CODE ,

Line 3298: ZX_ACCOUNTS_S.NEXTVAL ,

3294: OBJECT_VERSION_NUMBER
3295: )
3296: VALUES
3297: (
3298: ZX_ACCOUNTS_S.NEXTVAL ,
3299: zx_rates_b_s.nextval ,--TAX_RATE_ID
3300: 'RATES' ,
3301: LEDGER_ID ,
3302: ORG_ID ,

Line 3572: INTO zx_accounts

3568: TAX_RATE_ID
3569: -- 6820043, commenting out description
3570: -- DESCRIPTION -- Bug 4705196
3571: )
3572: INTO zx_accounts
3573: (
3574: TAX_ACCOUNT_ID ,
3575: TAX_ACCOUNT_ENTITY_ID ,
3576: TAX_ACCOUNT_ENTITY_CODE ,

Line 3620: ZX_ACCOUNTS_S.NEXTVAL ,

3616: OBJECT_VERSION_NUMBER
3617: )
3618: VALUES
3619: (
3620: ZX_ACCOUNTS_S.NEXTVAL ,
3621: TAX_RATE_ID ,
3622: 'RATES' ,
3623: LEDGER_ID ,
3624: ORG_ID ,

Line 3885: INTO zx_accounts

3881: TAX_RATE_ID
3882: -- 6820043, commenting out description
3883: -- DESCRIPTION -- Bug 4705196
3884: )
3885: INTO zx_accounts
3886: (
3887: TAX_ACCOUNT_ID ,
3888: TAX_ACCOUNT_ENTITY_ID ,
3889: TAX_ACCOUNT_ENTITY_CODE ,

Line 3933: ZX_ACCOUNTS_S.NEXTVAL ,

3929: OBJECT_VERSION_NUMBER
3930: )
3931: VALUES
3932: (
3933: ZX_ACCOUNTS_S.NEXTVAL ,
3934: TAX_RATE_ID ,
3935: 'RATES' ,
3936: LEDGER_ID ,
3937: ORG_ID ,

Line 4136: | ZX_ACCOUNTS |

4132: | This routine processes unassigned OFFSET Tax codes and inserts |
4133: | appropriate data into the following zx base tables. |
4134: | ZX_RATES_B |
4135: | ZX_RATES_TL |
4136: | ZX_ACCOUNTS |
4137: | |
4138: | SCOPE - PUBLIC |
4139: | |
4140: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 4295: INTO zx_accounts

4291: 1
4292: -- 6820043, commenting out description
4293: -- DESCRIPTION -- Bug 4705196
4294: )
4295: INTO zx_accounts
4296: (
4297: TAX_ACCOUNT_ID ,
4298: TAX_ACCOUNT_ENTITY_ID ,
4299: TAX_ACCOUNT_ENTITY_CODE ,

Line 4343: ZX_ACCOUNTS_S.NEXTVAL ,

4339: OBJECT_VERSION_NUMBER
4340: )
4341: VALUES
4342: (
4343: ZX_ACCOUNTS_S.NEXTVAL ,
4344: zx_rates_b_s.nextval ,--TAX_RATE_ID
4345: 'RATES' ,
4346: LEDGER_ID ,
4347: ORG_ID ,

Line 4606: INTO zx_accounts

4602: 1
4603: -- 6820043, commenting out description
4604: -- DESCRIPTION -- Bug 4705196
4605: )
4606: INTO zx_accounts
4607: (
4608: TAX_ACCOUNT_ID ,
4609: TAX_ACCOUNT_ENTITY_ID ,
4610: TAX_ACCOUNT_ENTITY_CODE ,

Line 4654: ZX_ACCOUNTS_S.NEXTVAL ,

4650: OBJECT_VERSION_NUMBER
4651: )
4652: VALUES
4653: (
4654: ZX_ACCOUNTS_S.NEXTVAL ,
4655: zx_rates_b_s.nextval ,--TAX_RATE_ID
4656: 'RATES' ,
4657: LEDGER_ID ,
4658: ORG_ID ,

Line 4924: INTO zx_accounts

4920: TAX_RATE_ID
4921: -- 6820043, commenting out description
4922: -- DESCRIPTION -- Bug 4705196
4923: )
4924: INTO zx_accounts
4925: (
4926: TAX_ACCOUNT_ID ,
4927: TAX_ACCOUNT_ENTITY_ID ,
4928: TAX_ACCOUNT_ENTITY_CODE ,

Line 4972: ZX_ACCOUNTS_S.NEXTVAL ,

4968: OBJECT_VERSION_NUMBER
4969: )
4970: VALUES
4971: (
4972: ZX_ACCOUNTS_S.NEXTVAL ,
4973: TAX_RATE_ID ,
4974: 'RATES' ,
4975: LEDGER_ID ,
4976: ORG_ID ,

Line 5237: INTO zx_accounts

5233: TAX_RATE_ID
5234: -- 6820043, commenting out description
5235: -- DESCRIPTION -- Bug 4705196
5236: )
5237: INTO zx_accounts
5238: (
5239: TAX_ACCOUNT_ID ,
5240: TAX_ACCOUNT_ENTITY_ID ,
5241: TAX_ACCOUNT_ENTITY_CODE ,

Line 5285: ZX_ACCOUNTS_S.NEXTVAL ,

5281: OBJECT_VERSION_NUMBER
5282: )
5283: VALUES
5284: (
5285: ZX_ACCOUNTS_S.NEXTVAL ,
5286: TAX_RATE_ID ,
5287: 'RATES' ,
5288: LEDGER_ID ,
5289: ORG_ID ,

Line 5484: | ZX_ACCOUNTS |

5480: | This routine processes distinct recovery rates,inserts appropriate |
5481: | data into the following zx base tables. |
5482: | ZX_RATES_B |
5483: | ZX_RATES_TL |
5484: | ZX_ACCOUNTS |
5485: | |
5486: | SCOPE - PUBLIC |
5487: | |
5488: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 5721: -- No need to insert into ZX_ACCOUNTS for Recovery rates.

5717: END;
5718: end loop;
5719: end;
5720:
5721: -- No need to insert into ZX_ACCOUNTS for Recovery rates.
5722: BEGIN
5723: INSERT INTO ZX_RATES_TL
5724: (
5725: TAX_RATE_ID,

Line 5790: | ZX_ACCOUNTS |

5786: | This routine processes distinct recovery rates,inserts appropriate |
5787: | data into the following zx base tables. |
5788: | ZX_RATES_B |
5789: | ZX_RATES_TL |
5790: | ZX_ACCOUNTS |
5791: | |
5792: | SCOPE - PUBLIC |
5793: | |
5794: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |

Line 10387: ZX_ACCOUNTS accounts,

10383: non_rec_account_ccid,
10384: ledger_id,
10385: accounts.internal_organization_id
10386: FROM
10387: ZX_ACCOUNTS accounts,
10388: ZX_RATES_B rates,
10389: ZX_TAXES_B taxes
10390: WHERE taxes.tax = rates.tax
10391: and taxes.tax_regime_code = rates.tax_regime_code

Line 10407: TYPE ac_id_tab IS TABLE OF ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE

10403: ------------------------pl/sql table declarations----------------------------
10404: TYPE tax_id_tab IS TABLE OF ZX_TAXES_B.TAX_ID%TYPE
10405: INDEX BY BINARY_INTEGER;
10406:
10407: TYPE ac_id_tab IS TABLE OF ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE
10408: INDEX BY BINARY_INTEGER;
10409:
10410: TYPE ledger_id_tab IS TABLE OF ZX_ACCOUNTS.LEDGER_ID%TYPE
10411: INDEX BY BINARY_INTEGER;

Line 10410: TYPE ledger_id_tab IS TABLE OF ZX_ACCOUNTS.LEDGER_ID%TYPE

10406:
10407: TYPE ac_id_tab IS TABLE OF ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE
10408: INDEX BY BINARY_INTEGER;
10409:
10410: TYPE ledger_id_tab IS TABLE OF ZX_ACCOUNTS.LEDGER_ID%TYPE
10411: INDEX BY BINARY_INTEGER;
10412:
10413: TYPE org_id_tab IS TABLE OF ZX_ACCOUNTS.INTERNAL_ORGANIZATION_ID%TYPE
10414: INDEX BY BINARY_INTEGER;

Line 10413: TYPE org_id_tab IS TABLE OF ZX_ACCOUNTS.INTERNAL_ORGANIZATION_ID%TYPE

10409:
10410: TYPE ledger_id_tab IS TABLE OF ZX_ACCOUNTS.LEDGER_ID%TYPE
10411: INDEX BY BINARY_INTEGER;
10412:
10413: TYPE org_id_tab IS TABLE OF ZX_ACCOUNTS.INTERNAL_ORGANIZATION_ID%TYPE
10414: INDEX BY BINARY_INTEGER;
10415:
10416: -----The tables given below used to collect all account info. records-------
10417:

Line 10442: v_prev_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;

10438: v_count number;
10439: v_insert_flag boolean;
10440:
10441: v_prev_tax_id ZX_TAXES_B.TAX_ID%TYPE;
10442: v_prev_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;
10443: v_current_tax_id ZX_TAXES_B.TAX_ID%TYPE;
10444: v_current_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;
10445:
10446:

Line 10444: v_current_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;

10440:
10441: v_prev_tax_id ZX_TAXES_B.TAX_ID%TYPE;
10442: v_prev_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;
10443: v_current_tax_id ZX_TAXES_B.TAX_ID%TYPE;
10444: v_current_ac_id ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;
10445:
10446:
10447: BEGIN
10448: arp_util_tax.debug('Create Tax Accounts(+)');

Line 10548: INSERT INTO ZX_ACCOUNTS

10544: END IF;
10545:
10546: FORALL j IN 1..nvl(pg_max_tax_id_tab.last,0)
10547:
10548: INSERT INTO ZX_ACCOUNTS
10549: (
10550: TAX_ACCOUNT_ENTITY_CODE,
10551: TAX_ACCOUNT_CCID,
10552: INTERIM_TAX_CCID,

Line 10633: zx_accounts_s.nextval,

10629: NULL,
10630: NULL,
10631: NULL,
10632: fnd_global.conc_login_id,
10633: zx_accounts_s.nextval,
10634: pg_max_tax_id_tab(j),
10635: pg_max_ledger_id_tab(j),
10636: pg_max_org_id_tab(j),
10637: 1

Line 10640: ( SELECT NULL FROM ZX_ACCOUNTS accounts

10636: pg_max_org_id_tab(j),
10637: 1
10638:
10639: FROM DUAL WHERE NOT EXISTS
10640: ( SELECT NULL FROM ZX_ACCOUNTS accounts
10641: WHERE accounts.TAX_ACCOUNT_ENTITY_CODE = 'TAXES' and
10642: accounts.TAX_ACCOUNT_ENTITY_ID = pg_max_tax_id_tab(j)
10643: )
10644: );

Line 10907: INTO zx_accounts

10903: 1
10904: -- 6820043, commenting out description
10905: -- DESCRIPTION -- Bug 4705196
10906: )
10907: INTO zx_accounts
10908: (
10909: TAX_ACCOUNT_ID ,
10910: TAX_ACCOUNT_ENTITY_ID ,
10911: TAX_ACCOUNT_ENTITY_CODE ,

Line 10955: ZX_ACCOUNTS_S.nextval ,

10951: OBJECT_VERSION_NUMBER
10952: )
10953: VALUES
10954: (
10955: ZX_ACCOUNTS_S.nextval ,
10956: zx_rates_b_s.nextval ,--TAX_RATE_ID
10957: 'RATES' ,
10958: LEDGER_ID ,
10959: ORG_ID ,

Line 11329: INTO zx_accounts

11325: 1
11326: -- 6820043, commenting out description
11327: -- DESCRIPTION -- Bug 4705196
11328: )
11329: INTO zx_accounts
11330: (
11331: TAX_ACCOUNT_ID ,
11332: TAX_ACCOUNT_ENTITY_ID ,
11333: TAX_ACCOUNT_ENTITY_CODE ,

Line 11377: ZX_ACCOUNTS_S.nextval ,

11373: OBJECT_VERSION_NUMBER
11374: )
11375: VALUES
11376: (
11377: ZX_ACCOUNTS_S.nextval ,
11378: zx_rates_b_s.nextval ,--TAX_RATE_ID
11379: 'RATES' ,
11380: LEDGER_ID ,
11381: ORG_ID ,

Line 11765: INTO zx_accounts

11761: TAX_RATE_ID
11762: -- 6820043, commenting out description
11763: -- DESCRIPTION -- Bug 4705196
11764: )
11765: INTO zx_accounts
11766: (
11767: TAX_ACCOUNT_ID ,
11768: TAX_ACCOUNT_ENTITY_ID ,
11769: TAX_ACCOUNT_ENTITY_CODE ,

Line 11813: ZX_ACCOUNTS_S.nextval ,

11809: OBJECT_VERSION_NUMBER
11810: )
11811: VALUES
11812: (
11813: ZX_ACCOUNTS_S.nextval ,
11814: TAX_RATE_ID ,
11815: 'RATES' ,
11816: LEDGER_ID ,
11817: ORG_ID ,

Line 12189: INTO zx_accounts

12185: TAX_RATE_ID
12186: -- 6820043, commenting out description
12187: -- DESCRIPTION -- Bug 4705196
12188: )
12189: INTO zx_accounts
12190: (
12191: TAX_ACCOUNT_ID ,
12192: TAX_ACCOUNT_ENTITY_ID ,
12193: TAX_ACCOUNT_ENTITY_CODE ,

Line 12237: ZX_ACCOUNTS_S.nextval ,

12233: OBJECT_VERSION_NUMBER
12234: )
12235: VALUES
12236: (
12237: ZX_ACCOUNTS_S.nextval ,
12238: TAX_RATE_ID ,
12239: 'RATES' ,
12240: LEDGER_ID ,
12241: ORG_ID ,

Line 12630: INTO zx_accounts

12626: 1
12627: -- 6820043, commenting out description
12628: -- DESCRIPTION -- Bug 4705196
12629: )
12630: INTO zx_accounts
12631: (
12632: TAX_ACCOUNT_ID ,
12633: TAX_ACCOUNT_ENTITY_ID ,
12634: TAX_ACCOUNT_ENTITY_CODE ,

Line 12678: ZX_ACCOUNTS_S.nextval ,

12674: OBJECT_VERSION_NUMBER
12675: )
12676: VALUES
12677: (
12678: ZX_ACCOUNTS_S.nextval ,
12679: zx_rates_b_s.nextval ,--TAX_RATE_ID
12680: 'RATES' ,
12681: LEDGER_ID ,
12682: ORG_ID ,

Line 13053: INTO zx_accounts

13049: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
13050: 1
13051: -- , DESCRIPTION -- Bug 4705196
13052: )
13053: INTO zx_accounts
13054: (
13055: TAX_ACCOUNT_ID ,
13056: TAX_ACCOUNT_ENTITY_ID ,
13057: TAX_ACCOUNT_ENTITY_CODE ,

Line 13101: ZX_ACCOUNTS_S.nextval ,

13097: OBJECT_VERSION_NUMBER
13098: )
13099: VALUES
13100: (
13101: ZX_ACCOUNTS_S.nextval ,
13102: zx_rates_b_s.nextval ,--TAX_RATE_ID
13103: 'RATES' ,
13104: LEDGER_ID ,
13105: ORG_ID ,

Line 13491: INTO zx_accounts

13487: TAX_RATE_ID
13488: -- 6820043, commenting out description
13489: -- DESCRIPTION -- Bug 4705196
13490: )
13491: INTO zx_accounts
13492: (
13493: TAX_ACCOUNT_ID ,
13494: TAX_ACCOUNT_ENTITY_ID ,
13495: TAX_ACCOUNT_ENTITY_CODE ,

Line 13539: ZX_ACCOUNTS_S.nextval ,

13535: OBJECT_VERSION_NUMBER
13536: )
13537: VALUES
13538: (
13539: ZX_ACCOUNTS_S.nextval ,
13540: TAX_RATE_ID ,
13541: 'RATES' ,
13542: LEDGER_ID ,
13543: ORG_ID ,

Line 13915: INTO zx_accounts

13911: TAX_RATE_ID
13912: -- 6820043, commenting out description
13913: -- DESCRIPTION -- Bug 4705196
13914: )
13915: INTO zx_accounts
13916: (
13917: TAX_ACCOUNT_ID ,
13918: TAX_ACCOUNT_ENTITY_ID ,
13919: TAX_ACCOUNT_ENTITY_CODE ,

Line 13963: ZX_ACCOUNTS_S.nextval ,

13959: OBJECT_VERSION_NUMBER
13960: )
13961: VALUES
13962: (
13963: ZX_ACCOUNTS_S.nextval ,
13964: TAX_RATE_ID ,
13965: 'RATES' ,
13966: LEDGER_ID ,
13967: ORG_ID ,