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.PO_TAX_INTERFACE_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 94: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax

90: --Modifies:
91: -- PO_LINE_LOCATIONS_ALL.tax_attribute_update_code
92: -- PO_LINE_LOCATIONS_ALL.original_shipment_id
93: -- PO_LINE_LOCATIONS_ALL.taxable_flag
94: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
95: -- PO_DISTRIBUTIONS_ALL.recoverable_tax
96: --Locks:
97: -- Transaction tables if update is allowed
98: --Function:

Line 95: -- PO_DISTRIBUTIONS_ALL.recoverable_tax

91: -- PO_LINE_LOCATIONS_ALL.tax_attribute_update_code
92: -- PO_LINE_LOCATIONS_ALL.original_shipment_id
93: -- PO_LINE_LOCATIONS_ALL.taxable_flag
94: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
95: -- PO_DISTRIBUTIONS_ALL.recoverable_tax
96: --Locks:
97: -- Transaction tables if update is allowed
98: --Function:
99: -- Calculate tax amounts for the documents passed in

Line 589: FROM po_distributions_all pd

585: NVL2((SELECT 'EXISTING DISTRIBUTIONS'
586: FROM DUAL
587: WHERE EXISTS
588: (SELECT 'Y'
589: FROM po_distributions_all pd
590: WHERE pd.po_header_id = zxhgt.trx_id
591: AND (pd.tax_attribute_update_code <> 'CREATE'
592: OR pd.tax_attribute_update_code IS NULL)
593: )

Line 603: FROM po_distributions_all pd

599: NVL2((SELECT 'EXISTING DISTRIBUTIONS'
600: FROM DUAL
601: WHERE EXISTS
602: (SELECT 'Y'
603: FROM po_distributions_all pd
604: WHERE pd.po_release_id = zxhgt.trx_id
605: AND (pd.tax_attribute_update_code <> 'CREATE'
606: OR pd.tax_attribute_update_code IS NULL)
607: )

Line 736: UPDATE po_distributions_all

732: -- Update the distributions that errored out and yet have a tauc of null
733: -- If this is not done, it is possible that all dist tauc's for a
734: -- document get nulled out and hence tax redistribution does not take
735: -- place despite determine_recovery erroring out for some of them
736: UPDATE po_distributions_all
737: SET tax_attribute_update_code = 'NO_ACTION'
738: WHERE tax_attribute_update_code IS NULL
739: AND po_distribution_id IN (SELECT psgt.NUM2 FROM po_session_gt psgt
740: WHERE psgt.key = l_po_session_gt_key

Line 752: UPDATE po_distributions_all pd

748: -- Modified the subquery by adding a where clause so that trx_id is joined
749: -- to different columns based on entity_code and event_class_code
750:
751: -- Populate recoverable/nonrecoverable tax columns in distributions table
752: UPDATE po_distributions_all pd
753: SET pd.recoverable_tax =
754: (SELECT SUM(zxdist.rec_nrec_tax_amt)
755: FROM zx_rec_nrec_dist zxdist
756: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id

Line 847: UPDATE po_distributions_all

843:
844: -- bug5219124 END
845:
846: d_progress := 500;
847: UPDATE po_distributions_all
848: SET tax_attribute_update_code = null
849: WHERE po_distribution_id IN (SELECT trx_line_dist_id
850: FROM zx_itm_distributions_gt);
851:

Line 896: FROM po_session_gt psgt, po_line_locations_all pll, po_distributions_all pd

892: ,pd.po_distribution_id --distribution_id
893: ,pd.distribution_num --distribution_num
894: ,psgt.char2 --message_text
895: BULK COLLECT INTO G_TAX_ERRORS_TBL
896: FROM po_session_gt psgt, po_line_locations_all pll, po_distributions_all pd
897: WHERE psgt.num1 = pll.line_location_id
898: AND psgt.num2 = pd.po_distribution_id(+)
899: AND psgt.key = l_po_session_gt_key;
900:

Line 978: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax

974: --Modifies:
975: -- PO_LINE_LOCATIONS_ALL.tax_attribute_update_code
976: -- PO_LINE_LOCATIONS_ALL.original_shipment_id
977: -- PO_LINE_LOCATIONS_ALL.taxable_flag
978: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
979: -- PO_DISTRIBUTIONS_ALL.recoverable_tax
980: --Locks:
981: -- Transaction tables if update is allowed
982: --Function:

Line 979: -- PO_DISTRIBUTIONS_ALL.recoverable_tax

975: -- PO_LINE_LOCATIONS_ALL.tax_attribute_update_code
976: -- PO_LINE_LOCATIONS_ALL.original_shipment_id
977: -- PO_LINE_LOCATIONS_ALL.taxable_flag
978: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
979: -- PO_DISTRIBUTIONS_ALL.recoverable_tax
980: --Locks:
981: -- Transaction tables if update is allowed
982: --Function:
983: -- Calculate tax amounts for the documents passed in

Line 1662: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax

1658: --Name: determine_recovery_po
1659: --Pre-reqs:
1660: -- None
1661: --Modifies:
1662: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
1663: -- PO_DISTRIBUTIONS_ALL.recoverable_tax
1664: --Locks:
1665: -- Transaction tables if update is allowed
1666: --Function:

Line 1663: -- PO_DISTRIBUTIONS_ALL.recoverable_tax

1659: --Pre-reqs:
1660: -- None
1661: --Modifies:
1662: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
1663: -- PO_DISTRIBUTIONS_ALL.recoverable_tax
1664: --Locks:
1665: -- Transaction tables if update is allowed
1666: --Function:
1667: -- Distribute tax lines and calculate recoverable and nonrecoverable tax

Line 1775: po_line_locations_all pll, po_distributions_all pd

1771: ,pd.distribution_num --distribution_num,
1772: ,zxegt.message_text --message_text
1773: BULK COLLECT INTO G_TAX_ERRORS_TBL
1774: FROM zx_errors_gt zxegt, po_headers_all ph,
1775: po_line_locations_all pll, po_distributions_all pd
1776: WHERE zxegt.trx_id = ph.po_header_id
1777: AND zxegt.trx_line_id = pll.line_location_id(+)
1778: AND zxegt.trx_line_dist_id = pd.po_distribution_id(+);
1779:

Line 1799: UPDATE po_distributions_all pd

1795: END IF; --IF (l_return_status = FND_API.G_RET_STS_ERROR)
1796:
1797: d_progress := 50;
1798: -- Populate recoverable/nonrecoverable tax columns in distributions table
1799: UPDATE po_distributions_all pd
1800: SET pd.recoverable_tax =
1801: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1802: FROM zx_rec_nrec_dist zxdist
1803: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id

Line 1836: pll.line_location_id IN (SELECT line_location_id FROM po_distributions_all pd,zx_itm_distributions_gt zi WHERE pd.po_distribution_id=zi.trx_line_dist_id);

1832: 0, 'N',
1833: 'Y'
1834: )
1835: WHERE
1836: pll.line_location_id IN (SELECT line_location_id FROM po_distributions_all pd,zx_itm_distributions_gt zi WHERE pd.po_distribution_id=zi.trx_line_dist_id);
1837: /* Bug 6157632 End */
1838: END IF;
1839:
1840: d_progress := 60;

Line 1841: UPDATE po_distributions_all

1837: /* Bug 6157632 End */
1838: END IF;
1839:
1840: d_progress := 60;
1841: UPDATE po_distributions_all
1842: SET tax_attribute_update_code = null
1843: WHERE po_distribution_id IN (SELECT trx_line_dist_id
1844: FROM zx_itm_distributions_gt);
1845:

Line 1880: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax

1876: --Name: determine_recovery_rel
1877: --Pre-reqs:
1878: -- None
1879: --Modifies:
1880: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
1881: -- PO_DISTRIBUTIONS_ALL.recoverable_tax
1882: --Locks:
1883: -- Transaction tables if update is allowed
1884: --Function:

Line 1881: -- PO_DISTRIBUTIONS_ALL.recoverable_tax

1877: --Pre-reqs:
1878: -- None
1879: --Modifies:
1880: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
1881: -- PO_DISTRIBUTIONS_ALL.recoverable_tax
1882: --Locks:
1883: -- Transaction tables if update is allowed
1884: --Function:
1885: -- Distribute tax lines and calculate recoverable and nonrecoverable tax

Line 1993: po_line_locations_all pll, po_distributions_all pd

1989: ,pd.distribution_num --distribution_num,
1990: ,zxegt.message_text --message_text
1991: BULK COLLECT INTO G_TAX_ERRORS_TBL
1992: FROM zx_errors_gt zxegt, po_releases_all pr, po_headers_all ph,
1993: po_line_locations_all pll, po_distributions_all pd
1994: WHERE zxegt.trx_id = pr.po_release_id
1995: AND pr.po_header_id = ph.po_header_id
1996: AND zxegt.trx_line_id = pll.line_location_id(+)
1997: AND zxegt.trx_line_dist_id = pd.po_distribution_id(+);

Line 2018: UPDATE po_distributions_all pd

2014: END IF; --IF (l_return_status = FND_API.G_RET_STS_ERROR)
2015:
2016: d_progress := 50;
2017: -- Populate recoverable/nonrecoverable tax columns in distributions table
2018: UPDATE po_distributions_all pd
2019: SET pd.recoverable_tax =
2020: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2021: FROM zx_rec_nrec_dist zxdist
2022: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id

Line 2055: pll.line_location_id IN (SELECT line_location_id FROM po_distributions_all pd,zx_itm_distributions_gt zi WHERE pd.po_distribution_id=zi.trx_line_dist_id);

2051: 0, 'N',
2052: 'Y'
2053: )
2054: WHERE
2055: pll.line_location_id IN (SELECT line_location_id FROM po_distributions_all pd,zx_itm_distributions_gt zi WHERE pd.po_distribution_id=zi.trx_line_dist_id);
2056: /* Bug 6157632 End */
2057:
2058:
2059: END IF;

Line 2062: UPDATE po_distributions_all

2058:
2059: END IF;
2060:
2061: d_progress := 60;
2062: UPDATE po_distributions_all
2063: SET tax_attribute_update_code = null
2064: WHERE po_distribution_id IN (SELECT trx_line_dist_id
2065: FROM zx_itm_distributions_gt);
2066:

Line 2972: FROM po_distributions_all pd

2968: WHERE pvs.vendor_site_id=ph.vendor_site_id)
2969: -- Get account id from first distribution, if created
2970: -- otherwise from the expense account of the item
2971: ,NVL((SELECT pd.code_combination_id --account_ccid
2972: FROM po_distributions_all pd
2973: WHERE pd.line_location_id = pll.line_location_id
2974: AND rownum = 1),
2975: msib.expense_account
2976: )

Line 3275: FROM po_distributions_all pd

3271: WHERE pvs.vendor_site_id=ph.vendor_site_id)
3272: -- Get account id from first distribution, if created
3273: -- otherwise from the expense account of the item
3274: ,NVL((SELECT pd.code_combination_id --account_ccid
3275: FROM po_distributions_all pd
3276: WHERE pd.line_location_id = pll.line_location_id
3277: AND rownum = 1),
3278: msib.expense_account
3279: )

Line 3782: FROM po_distributions_all pd1, po_line_locations_all pll, po_lines_all pl

3778: ,pll.quantity --trx_line_quantity
3779: ,pd1.code_combination_id --account_ccid
3780: ,pd1.rate --currency_exchange_rate
3781: , decode(pd1.tax_recovery_override_flag, 'Y', pd1.recovery_rate, null) --overriding_recovery_rate
3782: FROM po_distributions_all pd1, po_line_locations_all pll, po_lines_all pl
3783: WHERE pd1.po_header_id = p_po_header_id_tbl(i)
3784: AND pd1.line_location_id=pll.line_location_id
3785: AND pll.po_line_id=pl.po_line_id
3786: AND (EXISTS(SELECT 'SIBLING DIST WITH TAUC'

Line 3787: FROM po_distributions_all pd2

3783: WHERE pd1.po_header_id = p_po_header_id_tbl(i)
3784: AND pd1.line_location_id=pll.line_location_id
3785: AND pll.po_line_id=pl.po_line_id
3786: AND (EXISTS(SELECT 'SIBLING DIST WITH TAUC'
3787: FROM po_distributions_all pd2
3788: WHERE pd2.line_location_id = pd1.line_location_id
3789: --AND pd2.po_distribution_id<>pd1.po_distribution_id
3790: AND pd2.tax_attribute_update_code IS NOT NULL
3791: )

Line 3875: FROM po_distributions_all pd, po_line_locations_all pll, po_lines_all pl

3871: ,pll.quantity --trx_line_quantity
3872: ,pd.code_combination_id --account_ccid
3873: ,pd.rate --currency_exchange_rate
3874: , decode(pd.tax_recovery_override_flag, 'Y', pd.recovery_rate, null) --overriding_recovery_rate
3875: FROM po_distributions_all pd, po_line_locations_all pll, po_lines_all pl
3876: WHERE pd.po_header_id = p_po_header_id
3877: AND pd.line_location_id=pll.line_location_id
3878: AND pll.po_line_id = pl.po_line_id
3879: -- Conditions that determine that po line is 'Active'

Line 3970: FROM po_distributions_all pd1, po_line_locations_all pll, po_lines_all pl

3966: ,pll.quantity --trx_line_quantity
3967: ,pd1.code_combination_id --account_ccid
3968: ,pd1.rate --currency_exchange_rate
3969: , decode(pd1.tax_recovery_override_flag, 'Y', pd1.recovery_rate, null) --overriding_recovery_rate
3970: FROM po_distributions_all pd1, po_line_locations_all pll, po_lines_all pl
3971: WHERE pd1.po_release_id = p_po_release_id_tbl(i)
3972: AND pd1.line_location_id=pll.line_location_id
3973: AND pll.po_line_id=pl.po_line_id
3974: AND (EXISTS(SELECT 'SIBLING DIST WITH TAUC'

Line 3975: FROM po_distributions_all pd2

3971: WHERE pd1.po_release_id = p_po_release_id_tbl(i)
3972: AND pd1.line_location_id=pll.line_location_id
3973: AND pll.po_line_id=pl.po_line_id
3974: AND (EXISTS(SELECT 'SIBLING DIST WITH TAUC'
3975: FROM po_distributions_all pd2
3976: WHERE pd2.line_location_id = pd1.line_location_id
3977: --AND pd2.po_distribution_id<>pd1.po_distribution_id
3978: AND pd2.tax_attribute_update_code IS NOT NULL
3979: )

Line 4063: FROM po_distributions_all pd, po_line_locations_all pll, po_lines_all pl

4059: ,pll.quantity --trx_line_quantity
4060: ,pd.code_combination_id --account_ccid
4061: ,pd.rate --currency_exchange_rate
4062: , decode(pd.tax_recovery_override_flag, 'Y', pd.recovery_rate, null) --overriding_recovery_rate
4063: FROM po_distributions_all pd, po_line_locations_all pll, po_lines_all pl
4064: WHERE pd.po_release_id = p_po_release_id
4065: AND pd.line_location_id = pll.line_location_id
4066: AND pll.po_line_id = pl.po_line_id
4067: -- Conditions that determine that po line is 'Active'

Line 4232: po_distributions_all POD

4228: (SELECT 'Y'
4229: FROM po_headers_all POH,
4230: po_lines_all POL,
4231: po_line_locations_all PLL,
4232: po_distributions_all POD
4233: WHERE POH.po_header_id = p_po_header_id
4234: AND POH.po_header_id = POL.po_header_id
4235: AND POL.po_line_id = PLL.po_line_id
4236: AND PLL.line_location_id = POD.line_location_id

Line 4258: po_distributions_all POD

4254: WHERE EXISTS
4255: (SELECT 'Y'
4256: FROM po_releases_all POR,
4257: po_line_locations_all PLL,
4258: po_distributions_all POD
4259: WHERE POR.po_release_id = p_po_release_id
4260: AND POR.po_release_id = PLL.po_release_id
4261: AND PLL.line_location_id = POD.line_location_id
4262: AND NVL(PLL.cancel_flag,'N') = 'N'

Line 5019: l_ccid PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID%type;

5015: l_amt PO_LINE_LOCATIONS_ALL.AMOUNT%type;
5016: l_ship_to_org PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID%type;
5017: l_ship_to_loc PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID%type;
5018: l_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%type ;
5019: l_ccid PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID%type;
5020: l_tax_rec_rate PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%type;
5021: l_project PO_DISTRIBUTIONS_ALL.PROJECT_ID%type;
5022: l_task PO_DISTRIBUTIONS_ALL.TASK_ID%type;
5023: l_award PO_DISTRIBUTIONS_ALL.AWARD_ID%type;

Line 5020: l_tax_rec_rate PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%type;

5016: l_ship_to_org PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID%type;
5017: l_ship_to_loc PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID%type;
5018: l_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%type ;
5019: l_ccid PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID%type;
5020: l_tax_rec_rate PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%type;
5021: l_project PO_DISTRIBUTIONS_ALL.PROJECT_ID%type;
5022: l_task PO_DISTRIBUTIONS_ALL.TASK_ID%type;
5023: l_award PO_DISTRIBUTIONS_ALL.AWARD_ID%type;
5024: l_exp_type PO_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE%type;

Line 5021: l_project PO_DISTRIBUTIONS_ALL.PROJECT_ID%type;

5017: l_ship_to_loc PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID%type;
5018: l_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%type ;
5019: l_ccid PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID%type;
5020: l_tax_rec_rate PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%type;
5021: l_project PO_DISTRIBUTIONS_ALL.PROJECT_ID%type;
5022: l_task PO_DISTRIBUTIONS_ALL.TASK_ID%type;
5023: l_award PO_DISTRIBUTIONS_ALL.AWARD_ID%type;
5024: l_exp_type PO_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE%type;
5025: l_exp_org PO_DISTRIBUTIONS_ALL.EXPENDITURE_ORGANIZATION_ID%type;

Line 5022: l_task PO_DISTRIBUTIONS_ALL.TASK_ID%type;

5018: l_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%type ;
5019: l_ccid PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID%type;
5020: l_tax_rec_rate PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%type;
5021: l_project PO_DISTRIBUTIONS_ALL.PROJECT_ID%type;
5022: l_task PO_DISTRIBUTIONS_ALL.TASK_ID%type;
5023: l_award PO_DISTRIBUTIONS_ALL.AWARD_ID%type;
5024: l_exp_type PO_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE%type;
5025: l_exp_org PO_DISTRIBUTIONS_ALL.EXPENDITURE_ORGANIZATION_ID%type;
5026: l_exp_date PO_DISTRIBUTIONS_ALL.EXPENDITURE_ITEM_DATE%type;

Line 5023: l_award PO_DISTRIBUTIONS_ALL.AWARD_ID%type;

5019: l_ccid PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID%type;
5020: l_tax_rec_rate PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%type;
5021: l_project PO_DISTRIBUTIONS_ALL.PROJECT_ID%type;
5022: l_task PO_DISTRIBUTIONS_ALL.TASK_ID%type;
5023: l_award PO_DISTRIBUTIONS_ALL.AWARD_ID%type;
5024: l_exp_type PO_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE%type;
5025: l_exp_org PO_DISTRIBUTIONS_ALL.EXPENDITURE_ORGANIZATION_ID%type;
5026: l_exp_date PO_DISTRIBUTIONS_ALL.EXPENDITURE_ITEM_DATE%type;
5027: l_dist_quantity_ordered PO_DISTRIBUTIONS_ALL.QUANTITY_ORDERED%type;

Line 5024: l_exp_type PO_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE%type;

5020: l_tax_rec_rate PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%type;
5021: l_project PO_DISTRIBUTIONS_ALL.PROJECT_ID%type;
5022: l_task PO_DISTRIBUTIONS_ALL.TASK_ID%type;
5023: l_award PO_DISTRIBUTIONS_ALL.AWARD_ID%type;
5024: l_exp_type PO_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE%type;
5025: l_exp_org PO_DISTRIBUTIONS_ALL.EXPENDITURE_ORGANIZATION_ID%type;
5026: l_exp_date PO_DISTRIBUTIONS_ALL.EXPENDITURE_ITEM_DATE%type;
5027: l_dist_quantity_ordered PO_DISTRIBUTIONS_ALL.QUANTITY_ORDERED%type;
5028: l_dist_amount_ordered PO_DISTRIBUTIONS_ALL.AMOUNT_ORDERED%type;

Line 5025: l_exp_org PO_DISTRIBUTIONS_ALL.EXPENDITURE_ORGANIZATION_ID%type;

5021: l_project PO_DISTRIBUTIONS_ALL.PROJECT_ID%type;
5022: l_task PO_DISTRIBUTIONS_ALL.TASK_ID%type;
5023: l_award PO_DISTRIBUTIONS_ALL.AWARD_ID%type;
5024: l_exp_type PO_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE%type;
5025: l_exp_org PO_DISTRIBUTIONS_ALL.EXPENDITURE_ORGANIZATION_ID%type;
5026: l_exp_date PO_DISTRIBUTIONS_ALL.EXPENDITURE_ITEM_DATE%type;
5027: l_dist_quantity_ordered PO_DISTRIBUTIONS_ALL.QUANTITY_ORDERED%type;
5028: l_dist_amount_ordered PO_DISTRIBUTIONS_ALL.AMOUNT_ORDERED%type;
5029:

Line 5026: l_exp_date PO_DISTRIBUTIONS_ALL.EXPENDITURE_ITEM_DATE%type;

5022: l_task PO_DISTRIBUTIONS_ALL.TASK_ID%type;
5023: l_award PO_DISTRIBUTIONS_ALL.AWARD_ID%type;
5024: l_exp_type PO_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE%type;
5025: l_exp_org PO_DISTRIBUTIONS_ALL.EXPENDITURE_ORGANIZATION_ID%type;
5026: l_exp_date PO_DISTRIBUTIONS_ALL.EXPENDITURE_ITEM_DATE%type;
5027: l_dist_quantity_ordered PO_DISTRIBUTIONS_ALL.QUANTITY_ORDERED%type;
5028: l_dist_amount_ordered PO_DISTRIBUTIONS_ALL.AMOUNT_ORDERED%type;
5029:
5030: l_module_name CONSTANT VARCHAR2(100) := 'ANY_TAX_ATTRIBUTES_UPDATED';

Line 5027: l_dist_quantity_ordered PO_DISTRIBUTIONS_ALL.QUANTITY_ORDERED%type;

5023: l_award PO_DISTRIBUTIONS_ALL.AWARD_ID%type;
5024: l_exp_type PO_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE%type;
5025: l_exp_org PO_DISTRIBUTIONS_ALL.EXPENDITURE_ORGANIZATION_ID%type;
5026: l_exp_date PO_DISTRIBUTIONS_ALL.EXPENDITURE_ITEM_DATE%type;
5027: l_dist_quantity_ordered PO_DISTRIBUTIONS_ALL.QUANTITY_ORDERED%type;
5028: l_dist_amount_ordered PO_DISTRIBUTIONS_ALL.AMOUNT_ORDERED%type;
5029:
5030: l_module_name CONSTANT VARCHAR2(100) := 'ANY_TAX_ATTRIBUTES_UPDATED';
5031: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(

Line 5028: l_dist_amount_ordered PO_DISTRIBUTIONS_ALL.AMOUNT_ORDERED%type;

5024: l_exp_type PO_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE%type;
5025: l_exp_org PO_DISTRIBUTIONS_ALL.EXPENDITURE_ORGANIZATION_ID%type;
5026: l_exp_date PO_DISTRIBUTIONS_ALL.EXPENDITURE_ITEM_DATE%type;
5027: l_dist_quantity_ordered PO_DISTRIBUTIONS_ALL.QUANTITY_ORDERED%type;
5028: l_dist_amount_ordered PO_DISTRIBUTIONS_ALL.AMOUNT_ORDERED%type;
5029:
5030: l_module_name CONSTANT VARCHAR2(100) := 'ANY_TAX_ATTRIBUTES_UPDATED';
5031: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(
5032: D_PACKAGE_BASE, l_module_name);

Line 5187: FROM po_distributions_all

5183: l_exp_org,
5184: l_exp_date,
5185: l_dist_quantity_ordered,
5186: l_dist_amount_ordered
5187: FROM po_distributions_all
5188: WHERE po_distribution_id =p_doc_level_id;
5189:
5190: IF nvl(l_tax_rec_rate,-99) = nvl(p_tax_rec_rate ,-99) AND
5191: nvl(l_project,-99) = nvl(p_project,-99) AND

Line 5579: FROM po_distributions_all pd

5575:
5576: l_dist_id_tbl := null; l_dist_tauc_tbl := null;
5577: SELECT pd.po_distribution_id, pd.tax_attribute_update_code
5578: BULK COLLECT INTO l_dist_id_tbl, l_dist_tauc_tbl
5579: FROM po_distributions_all pd
5580: WHERE pd.line_location_id = l_ship_id_tbl(k);
5581:
5582: FOR l IN 1..l_dist_id_tbl.COUNT LOOP
5583: PO_LOG.stmt(d_module_base,d_progress,' po_distribution_id = '||l_dist_id_tbl(l)||':'||l_dist_tauc_tbl(l));

Line 5658: FROM po_distributions_all pd

5654:
5655: l_dist_id_tbl := null; l_dist_tauc_tbl := null;
5656: SELECT pd.po_distribution_id, pd.tax_attribute_update_code
5657: BULK COLLECT INTO l_dist_id_tbl, l_dist_tauc_tbl
5658: FROM po_distributions_all pd
5659: WHERE pd.line_location_id = l_ship_id_tbl(j);
5660:
5661: FOR k IN 1..l_dist_id_tbl.COUNT LOOP
5662: PO_LOG.stmt(d_module_base,d_progress,' po_distribution_id = '||l_dist_id_tbl(k)||':'||l_dist_tauc_tbl(k));