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 102: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax

98: --Modifies:
99: -- PO_LINE_LOCATIONS_ALL.tax_attribute_update_code
100: -- PO_LINE_LOCATIONS_ALL.original_shipment_id
101: -- PO_LINE_LOCATIONS_ALL.taxable_flag
102: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
103: -- PO_DISTRIBUTIONS_ALL.recoverable_tax
104: --Locks:
105: -- Transaction tables if update is allowed
106: --Function:

Line 103: -- PO_DISTRIBUTIONS_ALL.recoverable_tax

99: -- PO_LINE_LOCATIONS_ALL.tax_attribute_update_code
100: -- PO_LINE_LOCATIONS_ALL.original_shipment_id
101: -- PO_LINE_LOCATIONS_ALL.taxable_flag
102: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
103: -- PO_DISTRIBUTIONS_ALL.recoverable_tax
104: --Locks:
105: -- Transaction tables if update is allowed
106: --Function:
107: -- Calculate tax amounts for the documents passed in

Line 216: FROM po_distributions_all pod

212: UPDATE po_line_locations_all pll
213: SET pll.tax_attribute_update_code =
214: NVL ((SELECT NVL (
215: (SELECT pod.tax_attribute_update_code
216: FROM po_distributions_all pod
217: WHERE pod.tax_attribute_update_code = 'UPDATE'
218: AND pod.line_location_id = pll.line_location_id
219: AND ROWNUM = 1),
220: NVL (pl.tax_attribute_update_code,

Line 240: FROM po_distributions_all pod

236: SET pll.tax_attribute_update_code =
237: NVL(
238: (SELECT NVL (
239: (SELECT pod.tax_attribute_update_code
240: FROM po_distributions_all pod
241: WHERE pod.tax_attribute_update_code = 'UPDATE'
242: AND pod.line_location_id = pll.line_location_id
243: AND ROWNUM = 1), pr.tax_attribute_update_code)
244: FROM po_releases_all pr

Line 654: FROM po_distributions_all pd

650: NVL2((SELECT 'EXISTING DISTRIBUTIONS'
651: FROM DUAL
652: WHERE EXISTS
653: (SELECT 'Y'
654: FROM po_distributions_all pd
655: WHERE pd.po_header_id = zxhgt.trx_id
656: AND (pd.tax_attribute_update_code <> 'CREATE'
657: OR pd.tax_attribute_update_code IS NULL)
658: )

Line 668: FROM po_distributions_all pd

664: NVL2((SELECT 'EXISTING DISTRIBUTIONS'
665: FROM DUAL
666: WHERE EXISTS
667: (SELECT 'Y'
668: FROM po_distributions_all pd
669: WHERE pd.po_release_id = zxhgt.trx_id
670: AND (pd.tax_attribute_update_code <> 'CREATE'
671: OR pd.tax_attribute_update_code IS NULL)
672: )

Line 801: UPDATE po_distributions_all

797: -- Update the distributions that errored out and yet have a tauc of null
798: -- If this is not done, it is possible that all dist tauc's for a
799: -- document get nulled out and hence tax redistribution does not take
800: -- place despite determine_recovery erroring out for some of them
801: UPDATE po_distributions_all
802: SET tax_attribute_update_code = 'NO_ACTION'
803: WHERE tax_attribute_update_code IS NULL
804: AND po_distribution_id IN (SELECT psgt.NUM2 FROM po_session_gt psgt
805: WHERE psgt.key = l_po_session_gt_key

Line 820: UPDATE po_distributions_all pd

816: -- Modified the subquery by adding a where clause so that trx_id is joined
817: -- to different columns based on entity_code and event_class_code
818:
819: -- Populate recoverable/nonrecoverable tax columns in distributions table
820: UPDATE po_distributions_all pd
821: SET pd.recoverable_tax =
822: (SELECT SUM(zxdist.rec_nrec_tax_amt)
823: FROM zx_rec_nrec_dist zxdist
824: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id

Line 920: UPDATE po_distributions_all

916:
917: -- bug5219124 END
918:
919: d_progress := 500;
920: UPDATE po_distributions_all
921: SET tax_attribute_update_code = null
922: WHERE po_distribution_id IN (SELECT trx_line_dist_id
923: FROM zx_itm_distributions_gt);
924:

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

965: ,pd.po_distribution_id --distribution_id
966: ,pd.distribution_num --distribution_num
967: ,psgt.char2 --message_text
968: BULK COLLECT INTO G_TAX_ERRORS_TBL
969: FROM po_session_gt psgt, po_line_locations_all pll, po_distributions_all pd
970: WHERE psgt.num1 = pll.line_location_id
971: AND psgt.num2 = pd.po_distribution_id(+)
972: AND psgt.key = l_po_session_gt_key;
973:

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

1009: ,pd.po_distribution_id --distribution_id
1010: ,pd.distribution_num --distribution_num
1011: ,psgt.char2 --message_text
1012: BULK COLLECT INTO G_TAX_ERRORS_TBL
1013: FROM po_session_gt psgt, po_line_locations_all pll, po_distributions_all pd
1014: WHERE psgt.index_num1 = pll.po_header_id
1015: AND pll.line_location_id = pd.line_location_id
1016: AND psgt.key = l_po_session_gt_key;
1017:

Line 1089: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax

1085: --Modifies:
1086: -- PO_LINE_LOCATIONS_ALL.tax_attribute_update_code
1087: -- PO_LINE_LOCATIONS_ALL.original_shipment_id
1088: -- PO_LINE_LOCATIONS_ALL.taxable_flag
1089: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
1090: -- PO_DISTRIBUTIONS_ALL.recoverable_tax
1091: --Locks:
1092: -- Transaction tables if update is allowed
1093: --Function:

Line 1090: -- PO_DISTRIBUTIONS_ALL.recoverable_tax

1086: -- PO_LINE_LOCATIONS_ALL.tax_attribute_update_code
1087: -- PO_LINE_LOCATIONS_ALL.original_shipment_id
1088: -- PO_LINE_LOCATIONS_ALL.taxable_flag
1089: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
1090: -- PO_DISTRIBUTIONS_ALL.recoverable_tax
1091: --Locks:
1092: -- Transaction tables if update is allowed
1093: --Function:
1094: -- Calculate tax amounts for the documents passed in

Line 1831: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax

1827: --Name: determine_recovery_po
1828: --Pre-reqs:
1829: -- None
1830: --Modifies:
1831: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
1832: -- PO_DISTRIBUTIONS_ALL.recoverable_tax
1833: --Locks:
1834: -- Transaction tables if update is allowed
1835: --Function:

Line 1832: -- PO_DISTRIBUTIONS_ALL.recoverable_tax

1828: --Pre-reqs:
1829: -- None
1830: --Modifies:
1831: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
1832: -- PO_DISTRIBUTIONS_ALL.recoverable_tax
1833: --Locks:
1834: -- Transaction tables if update is allowed
1835: --Function:
1836: -- Distribute tax lines and calculate recoverable and nonrecoverable tax

Line 1944: po_line_locations_all pll, po_distributions_all pd

1940: ,pd.distribution_num --distribution_num,
1941: ,zxegt.message_text --message_text
1942: BULK COLLECT INTO G_TAX_ERRORS_TBL
1943: FROM zx_errors_gt zxegt, po_headers_all ph,
1944: po_line_locations_all pll, po_distributions_all pd
1945: WHERE zxegt.trx_id = ph.po_header_id
1946: AND zxegt.trx_line_id = pll.line_location_id(+)
1947: AND zxegt.trx_line_dist_id = pd.po_distribution_id(+);
1948:

Line 1968: UPDATE po_distributions_all pd

1964: END IF; --IF (l_return_status = FND_API.G_RET_STS_ERROR)
1965:
1966: d_progress := 50;
1967: -- Populate recoverable/nonrecoverable tax columns in distributions table
1968: UPDATE po_distributions_all pd
1969: SET pd.recoverable_tax =
1970: (SELECT SUM(zxdist.rec_nrec_tax_amt)
1971: FROM zx_rec_nrec_dist zxdist
1972: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id

Line 2016: 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);

2012: last_updated_by = fnd_global.user_id,
2013: last_update_login = fnd_global.login_id
2014: --Bug 10305728 end
2015: WHERE
2016: 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);
2017: /* Bug 6157632 End */
2018: END IF;
2019:
2020: d_progress := 60;

Line 2021: UPDATE po_distributions_all

2017: /* Bug 6157632 End */
2018: END IF;
2019:
2020: d_progress := 60;
2021: UPDATE po_distributions_all
2022: SET tax_attribute_update_code = null,
2023: --Bug 10305728 start
2024: last_update_date = sysdate,
2025: last_updated_by = fnd_global.user_id,

Line 2065: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax

2061: --Name: determine_recovery_rel
2062: --Pre-reqs:
2063: -- None
2064: --Modifies:
2065: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
2066: -- PO_DISTRIBUTIONS_ALL.recoverable_tax
2067: --Locks:
2068: -- Transaction tables if update is allowed
2069: --Function:

Line 2066: -- PO_DISTRIBUTIONS_ALL.recoverable_tax

2062: --Pre-reqs:
2063: -- None
2064: --Modifies:
2065: -- PO_DISTRIBUTIONS_ALL.nonrecoverable_tax
2066: -- PO_DISTRIBUTIONS_ALL.recoverable_tax
2067: --Locks:
2068: -- Transaction tables if update is allowed
2069: --Function:
2070: -- Distribute tax lines and calculate recoverable and nonrecoverable tax

Line 2178: po_line_locations_all pll, po_distributions_all pd

2174: ,pd.distribution_num --distribution_num,
2175: ,zxegt.message_text --message_text
2176: BULK COLLECT INTO G_TAX_ERRORS_TBL
2177: FROM zx_errors_gt zxegt, po_releases_all pr, po_headers_all ph,
2178: po_line_locations_all pll, po_distributions_all pd
2179: WHERE zxegt.trx_id = pr.po_release_id
2180: AND pr.po_header_id = ph.po_header_id
2181: AND zxegt.trx_line_id = pll.line_location_id(+)
2182: AND zxegt.trx_line_dist_id = pd.po_distribution_id(+);

Line 2203: UPDATE po_distributions_all pd

2199: END IF; --IF (l_return_status = FND_API.G_RET_STS_ERROR)
2200:
2201: d_progress := 50;
2202: -- Populate recoverable/nonrecoverable tax columns in distributions table
2203: UPDATE po_distributions_all pd
2204: SET pd.recoverable_tax =
2205: (SELECT SUM(zxdist.rec_nrec_tax_amt)
2206: FROM zx_rec_nrec_dist zxdist
2207: WHERE zxdist.trx_line_dist_id = pd.po_distribution_id

Line 2240: 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);

2236: 0, 'N',
2237: 'Y'
2238: )
2239: WHERE
2240: 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);
2241: /* Bug 6157632 End */
2242:
2243:
2244: END IF;

Line 2247: UPDATE po_distributions_all

2243:
2244: END IF;
2245:
2246: d_progress := 60;
2247: UPDATE po_distributions_all
2248: SET tax_attribute_update_code = null
2249: WHERE po_distribution_id IN (SELECT trx_line_dist_id
2250: FROM zx_itm_distributions_gt);
2251:

Line 3163: FROM po_distributions_all pd

3159: WHERE pvs.vendor_site_id=ph.vendor_site_id)
3160: -- Get account id from first distribution, if created
3161: -- otherwise from the expense account of the item
3162: ,NVL((SELECT pd.code_combination_id --account_ccid
3163: FROM po_distributions_all pd
3164: WHERE pd.line_location_id = pll.line_location_id
3165: AND rownum = 1),
3166: msib.expense_account
3167: )

Line 3479: FROM po_distributions_all pd

3475: WHERE pvs.vendor_site_id=ph.vendor_site_id)
3476: -- Get account id from first distribution, if created
3477: -- otherwise from the expense account of the item
3478: ,NVL((SELECT pd.code_combination_id --account_ccid
3479: FROM po_distributions_all pd
3480: WHERE pd.line_location_id = pll.line_location_id
3481: AND rownum = 1),
3482: msib.expense_account
3483: )

Line 3823: FROM po_distributions_all pd

3819: WHERE pvs.vendor_site_id=ph.vendor_site_id)
3820: -- Get account id from first distribution, if created
3821: -- otherwise from the expense account of the item
3822: ,NVL((SELECT pd.code_combination_id --account_ccid
3823: FROM po_distributions_all pd
3824: WHERE pd.line_location_id = pll.line_location_id
3825: AND rownum = 1),
3826: msib.expense_account
3827: )

Line 4135: FROM po_distributions_all pd

4131: WHERE pvs.vendor_site_id=ph.vendor_site_id)
4132: -- Get account id from first distribution, if created
4133: -- otherwise from the expense account of the item
4134: ,NVL((SELECT pd.code_combination_id --account_ccid
4135: FROM po_distributions_all pd
4136: WHERE pd.line_location_id = pll.line_location_id
4137: AND rownum = 1),
4138: msib.expense_account
4139: )

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

4662: ,pll.quantity --trx_line_quantity
4663: ,pd1.code_combination_id --account_ccid
4664: ,pd1.rate --currency_exchange_rate
4665: , decode(pd1.tax_recovery_override_flag, 'Y', pd1.recovery_rate, null) --overriding_recovery_rate
4666: FROM po_distributions_all pd1, po_line_locations_all pll, po_lines_all pl
4667: WHERE pd1.po_header_id = p_po_header_id_tbl(i)
4668: AND pd1.line_location_id=pll.line_location_id
4669: AND pll.po_line_id=pl.po_line_id
4670: AND (EXISTS(SELECT 'SIBLING DIST WITH TAUC'

Line 4671: FROM po_distributions_all pd2

4667: WHERE pd1.po_header_id = p_po_header_id_tbl(i)
4668: AND pd1.line_location_id=pll.line_location_id
4669: AND pll.po_line_id=pl.po_line_id
4670: AND (EXISTS(SELECT 'SIBLING DIST WITH TAUC'
4671: FROM po_distributions_all pd2
4672: WHERE pd2.line_location_id = pd1.line_location_id
4673: --AND pd2.po_distribution_id<>pd1.po_distribution_id
4674: AND pd2.tax_attribute_update_code IS NOT NULL
4675: )

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

4755: ,pll.quantity --trx_line_quantity
4756: ,pd.code_combination_id --account_ccid
4757: ,pd.rate --currency_exchange_rate
4758: , decode(pd.tax_recovery_override_flag, 'Y', pd.recovery_rate, null) --overriding_recovery_rate
4759: FROM po_distributions_all pd, po_line_locations_all pll, po_lines_all pl
4760: WHERE pd.po_header_id = p_po_header_id
4761: AND pd.line_location_id=pll.line_location_id
4762: AND pll.po_line_id = pl.po_line_id
4763: -- Conditions that determine that po line is 'Active'

Line 4770: FROM po_distributions_all pd2

4766: AND nvl(pll.cancel_flag,'N') = 'N'
4767: AND nvl(pll.closed_code,'OPEN') <> 'FINALLY CLOSED'
4768: --Bug 10305728 start
4769: AND (EXISTS(SELECT 'SIBLING DIST WITH TAUC'
4770: FROM po_distributions_all pd2
4771: WHERE pd2.line_location_id = pd.line_location_id
4772: AND pd2.tax_attribute_update_code IS NOT NULL
4773: )
4774: OR pll.tax_attribute_update_code IS NOT NULL

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

4859: ,pll.quantity --trx_line_quantity
4860: ,pd1.code_combination_id --account_ccid
4861: ,pd1.rate --currency_exchange_rate
4862: , decode(pd1.tax_recovery_override_flag, 'Y', pd1.recovery_rate, null) --overriding_recovery_rate
4863: FROM po_distributions_all pd1, po_line_locations_all pll, po_lines_all pl
4864: WHERE pd1.po_release_id = p_po_release_id_tbl(i)
4865: AND pd1.line_location_id=pll.line_location_id
4866: AND pll.po_line_id=pl.po_line_id
4867: AND (EXISTS(SELECT 'SIBLING DIST WITH TAUC'

Line 4868: FROM po_distributions_all pd2

4864: WHERE pd1.po_release_id = p_po_release_id_tbl(i)
4865: AND pd1.line_location_id=pll.line_location_id
4866: AND pll.po_line_id=pl.po_line_id
4867: AND (EXISTS(SELECT 'SIBLING DIST WITH TAUC'
4868: FROM po_distributions_all pd2
4869: WHERE pd2.line_location_id = pd1.line_location_id
4870: --AND pd2.po_distribution_id<>pd1.po_distribution_id
4871: AND pd2.tax_attribute_update_code IS NOT NULL
4872: )

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

4952: ,pll.quantity --trx_line_quantity
4953: ,pd.code_combination_id --account_ccid
4954: ,pd.rate --currency_exchange_rate
4955: , decode(pd.tax_recovery_override_flag, 'Y', pd.recovery_rate, null) --overriding_recovery_rate
4956: FROM po_distributions_all pd, po_line_locations_all pll, po_lines_all pl
4957: WHERE pd.po_release_id = p_po_release_id
4958: AND pd.line_location_id = pll.line_location_id
4959: AND pll.po_line_id = pl.po_line_id
4960: -- Conditions that determine that po line is 'Active'

Line 5125: po_distributions_all POD

5121: (SELECT 'Y'
5122: FROM po_headers_all POH,
5123: po_lines_all POL,
5124: po_line_locations_all PLL,
5125: po_distributions_all POD
5126: WHERE POH.po_header_id = p_po_header_id
5127: AND POH.po_header_id = POL.po_header_id
5128: AND POL.po_line_id = PLL.po_line_id
5129: AND PLL.line_location_id = POD.line_location_id

Line 5151: po_distributions_all POD

5147: WHERE EXISTS
5148: (SELECT 'Y'
5149: FROM po_releases_all POR,
5150: po_line_locations_all PLL,
5151: po_distributions_all POD
5152: WHERE POR.po_release_id = p_po_release_id
5153: AND POR.po_release_id = PLL.po_release_id
5154: AND PLL.line_location_id = POD.line_location_id
5155: AND NVL(PLL.cancel_flag,'N') = 'N'

Line 5914: l_ccid PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID%type;

5910: l_amt PO_LINE_LOCATIONS_ALL.AMOUNT%type;
5911: l_ship_to_org PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID%type;
5912: l_ship_to_loc PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID%type;
5913: l_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%type ;
5914: l_ccid PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID%type;
5915: l_tax_rec_rate PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%type;
5916: l_project PO_DISTRIBUTIONS_ALL.PROJECT_ID%type;
5917: l_task PO_DISTRIBUTIONS_ALL.TASK_ID%type;
5918: l_award PO_DISTRIBUTIONS_ALL.AWARD_ID%type;

Line 5915: l_tax_rec_rate PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%type;

5911: l_ship_to_org PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID%type;
5912: l_ship_to_loc PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID%type;
5913: l_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%type ;
5914: l_ccid PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID%type;
5915: l_tax_rec_rate PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%type;
5916: l_project PO_DISTRIBUTIONS_ALL.PROJECT_ID%type;
5917: l_task PO_DISTRIBUTIONS_ALL.TASK_ID%type;
5918: l_award PO_DISTRIBUTIONS_ALL.AWARD_ID%type;
5919: l_exp_type PO_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE%type;

Line 5916: l_project PO_DISTRIBUTIONS_ALL.PROJECT_ID%type;

5912: l_ship_to_loc PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID%type;
5913: l_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%type ;
5914: l_ccid PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID%type;
5915: l_tax_rec_rate PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%type;
5916: l_project PO_DISTRIBUTIONS_ALL.PROJECT_ID%type;
5917: l_task PO_DISTRIBUTIONS_ALL.TASK_ID%type;
5918: l_award PO_DISTRIBUTIONS_ALL.AWARD_ID%type;
5919: l_exp_type PO_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE%type;
5920: l_exp_org PO_DISTRIBUTIONS_ALL.EXPENDITURE_ORGANIZATION_ID%type;

Line 5917: l_task PO_DISTRIBUTIONS_ALL.TASK_ID%type;

5913: l_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%type ;
5914: l_ccid PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID%type;
5915: l_tax_rec_rate PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%type;
5916: l_project PO_DISTRIBUTIONS_ALL.PROJECT_ID%type;
5917: l_task PO_DISTRIBUTIONS_ALL.TASK_ID%type;
5918: l_award PO_DISTRIBUTIONS_ALL.AWARD_ID%type;
5919: l_exp_type PO_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE%type;
5920: l_exp_org PO_DISTRIBUTIONS_ALL.EXPENDITURE_ORGANIZATION_ID%type;
5921: l_exp_date PO_DISTRIBUTIONS_ALL.EXPENDITURE_ITEM_DATE%type;

Line 5918: l_award PO_DISTRIBUTIONS_ALL.AWARD_ID%type;

5914: l_ccid PO_DISTRIBUTIONS_ALL.CODE_COMBINATION_ID%type;
5915: l_tax_rec_rate PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%type;
5916: l_project PO_DISTRIBUTIONS_ALL.PROJECT_ID%type;
5917: l_task PO_DISTRIBUTIONS_ALL.TASK_ID%type;
5918: l_award PO_DISTRIBUTIONS_ALL.AWARD_ID%type;
5919: l_exp_type PO_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE%type;
5920: l_exp_org PO_DISTRIBUTIONS_ALL.EXPENDITURE_ORGANIZATION_ID%type;
5921: l_exp_date PO_DISTRIBUTIONS_ALL.EXPENDITURE_ITEM_DATE%type;
5922: l_dist_quantity_ordered PO_DISTRIBUTIONS_ALL.QUANTITY_ORDERED%type;

Line 5919: l_exp_type PO_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE%type;

5915: l_tax_rec_rate PO_DISTRIBUTIONS_ALL.RECOVERY_RATE%type;
5916: l_project PO_DISTRIBUTIONS_ALL.PROJECT_ID%type;
5917: l_task PO_DISTRIBUTIONS_ALL.TASK_ID%type;
5918: l_award PO_DISTRIBUTIONS_ALL.AWARD_ID%type;
5919: l_exp_type PO_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE%type;
5920: l_exp_org PO_DISTRIBUTIONS_ALL.EXPENDITURE_ORGANIZATION_ID%type;
5921: l_exp_date PO_DISTRIBUTIONS_ALL.EXPENDITURE_ITEM_DATE%type;
5922: l_dist_quantity_ordered PO_DISTRIBUTIONS_ALL.QUANTITY_ORDERED%type;
5923: l_dist_amount_ordered PO_DISTRIBUTIONS_ALL.AMOUNT_ORDERED%type;

Line 5920: l_exp_org PO_DISTRIBUTIONS_ALL.EXPENDITURE_ORGANIZATION_ID%type;

5916: l_project PO_DISTRIBUTIONS_ALL.PROJECT_ID%type;
5917: l_task PO_DISTRIBUTIONS_ALL.TASK_ID%type;
5918: l_award PO_DISTRIBUTIONS_ALL.AWARD_ID%type;
5919: l_exp_type PO_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE%type;
5920: l_exp_org PO_DISTRIBUTIONS_ALL.EXPENDITURE_ORGANIZATION_ID%type;
5921: l_exp_date PO_DISTRIBUTIONS_ALL.EXPENDITURE_ITEM_DATE%type;
5922: l_dist_quantity_ordered PO_DISTRIBUTIONS_ALL.QUANTITY_ORDERED%type;
5923: l_dist_amount_ordered PO_DISTRIBUTIONS_ALL.AMOUNT_ORDERED%type;
5924:

Line 5921: l_exp_date PO_DISTRIBUTIONS_ALL.EXPENDITURE_ITEM_DATE%type;

5917: l_task PO_DISTRIBUTIONS_ALL.TASK_ID%type;
5918: l_award PO_DISTRIBUTIONS_ALL.AWARD_ID%type;
5919: l_exp_type PO_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE%type;
5920: l_exp_org PO_DISTRIBUTIONS_ALL.EXPENDITURE_ORGANIZATION_ID%type;
5921: l_exp_date PO_DISTRIBUTIONS_ALL.EXPENDITURE_ITEM_DATE%type;
5922: l_dist_quantity_ordered PO_DISTRIBUTIONS_ALL.QUANTITY_ORDERED%type;
5923: l_dist_amount_ordered PO_DISTRIBUTIONS_ALL.AMOUNT_ORDERED%type;
5924:
5925: l_module_name CONSTANT VARCHAR2(100) := 'ANY_TAX_ATTRIBUTES_UPDATED';

Line 5922: l_dist_quantity_ordered PO_DISTRIBUTIONS_ALL.QUANTITY_ORDERED%type;

5918: l_award PO_DISTRIBUTIONS_ALL.AWARD_ID%type;
5919: l_exp_type PO_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE%type;
5920: l_exp_org PO_DISTRIBUTIONS_ALL.EXPENDITURE_ORGANIZATION_ID%type;
5921: l_exp_date PO_DISTRIBUTIONS_ALL.EXPENDITURE_ITEM_DATE%type;
5922: l_dist_quantity_ordered PO_DISTRIBUTIONS_ALL.QUANTITY_ORDERED%type;
5923: l_dist_amount_ordered PO_DISTRIBUTIONS_ALL.AMOUNT_ORDERED%type;
5924:
5925: l_module_name CONSTANT VARCHAR2(100) := 'ANY_TAX_ATTRIBUTES_UPDATED';
5926: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(

Line 5923: l_dist_amount_ordered PO_DISTRIBUTIONS_ALL.AMOUNT_ORDERED%type;

5919: l_exp_type PO_DISTRIBUTIONS_ALL.EXPENDITURE_TYPE%type;
5920: l_exp_org PO_DISTRIBUTIONS_ALL.EXPENDITURE_ORGANIZATION_ID%type;
5921: l_exp_date PO_DISTRIBUTIONS_ALL.EXPENDITURE_ITEM_DATE%type;
5922: l_dist_quantity_ordered PO_DISTRIBUTIONS_ALL.QUANTITY_ORDERED%type;
5923: l_dist_amount_ordered PO_DISTRIBUTIONS_ALL.AMOUNT_ORDERED%type;
5924:
5925: l_module_name CONSTANT VARCHAR2(100) := 'ANY_TAX_ATTRIBUTES_UPDATED';
5926: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(
5927: D_PACKAGE_BASE, l_module_name);

Line 6082: FROM po_distributions_all

6078: l_exp_org,
6079: l_exp_date,
6080: l_dist_quantity_ordered,
6081: l_dist_amount_ordered
6082: FROM po_distributions_all
6083: WHERE po_distribution_id =p_doc_level_id;
6084:
6085: IF nvl(l_tax_rec_rate,-99) = nvl(p_tax_rec_rate ,-99) AND
6086: nvl(l_project,-99) = nvl(p_project,-99) AND

Line 6475: FROM po_distributions_all pd

6471:
6472: l_dist_id_tbl := null; l_dist_tauc_tbl := null;
6473: SELECT pd.po_distribution_id, pd.tax_attribute_update_code
6474: BULK COLLECT INTO l_dist_id_tbl, l_dist_tauc_tbl
6475: FROM po_distributions_all pd
6476: WHERE pd.line_location_id = l_ship_id_tbl(k);
6477:
6478: FOR l IN 1..l_dist_id_tbl.COUNT LOOP
6479: PO_LOG.stmt(d_module_base,d_progress,' po_distribution_id = '||l_dist_id_tbl(l)||':'||l_dist_tauc_tbl(l));

Line 6554: FROM po_distributions_all pd

6550:
6551: l_dist_id_tbl := null; l_dist_tauc_tbl := null;
6552: SELECT pd.po_distribution_id, pd.tax_attribute_update_code
6553: BULK COLLECT INTO l_dist_id_tbl, l_dist_tauc_tbl
6554: FROM po_distributions_all pd
6555: WHERE pd.line_location_id = l_ship_id_tbl(j);
6556:
6557: FOR k IN 1..l_dist_id_tbl.COUNT LOOP
6558: PO_LOG.stmt(d_module_base,d_progress,' po_distribution_id = '||l_dist_id_tbl(k)||':'||l_dist_tauc_tbl(k));