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_LINE_LOCATIONS_ALL

Line 91: -- PO_LINE_LOCATIONS_ALL.tax_attribute_update_code

87: --Pre-reqs:
88: -- Should be called when transaction data has been posted to the database
89: -- but not yet committed
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

Line 92: -- PO_LINE_LOCATIONS_ALL.original_shipment_id

88: -- Should be called when transaction data has been posted to the database
89: -- but not yet committed
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:

Line 93: -- PO_LINE_LOCATIONS_ALL.taxable_flag

89: -- but not yet committed
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

Line 197: UPDATE po_line_locations_all pll

193: -- 3. If none of the above problems exist then update shipment
194: -- tax_attribute_update_code with line or header tax_attribute_update_code
195: -- whichever is non-null in that order
196: FORALL i IN 1..p_po_header_id_tbl.COUNT
197: UPDATE po_line_locations_all pll
198: SET pll.tax_attribute_update_code =
199: NVL(
200: (SELECT NVL(pl.tax_attribute_update_code, ph.tax_attribute_update_code)
201: FROM po_headers_all ph, po_lines_all pl

Line 217: UPDATE po_line_locations_all pll

213: OR pll.tax_attribute_update_code = 'DIST_DELETE');
214:
215: d_progress := 50;
216: FORALL i IN 1..p_po_release_id_tbl.COUNT
217: UPDATE po_line_locations_all pll
218: SET pll.tax_attribute_update_code =
219: NVL(
220: (SELECT ph.tax_attribute_update_code
221: FROM po_headers_all ph

Line 425: FROM po_line_locations_all pll, po_lines_all pl

421: SET zxlgt.product_type =
422: (SELECT DECODE(pl.purchase_basis,
423: 'GOODS', 'GOODS',
424: 'SERVICES')
425: FROM po_line_locations_all pll, po_lines_all pl
426: WHERE pll.line_location_id = zxlgt.trx_line_id
427: AND pll.po_line_id = pl.po_line_id)
428: WHERE zxlgt.product_type IS NULL
429: AND zxlgt.line_level_action = 'CREATE';

Line 832: UPDATE po_line_locations_all

828:
829: -- bug5219124 START
830: -- Separate the original update statement into two
831:
832: UPDATE po_line_locations_all
833: SET tax_attribute_update_code = null,
834: original_shipment_id = null
835: WHERE line_location_id IN (SELECT trx_line_id FROM zx_transaction_lines_gt);
836:

Line 837: UPDATE po_line_locations_all

833: SET tax_attribute_update_code = null,
834: original_shipment_id = null
835: WHERE line_location_id IN (SELECT trx_line_id FROM zx_transaction_lines_gt);
836:
837: UPDATE po_line_locations_all
838: SET tax_attribute_update_code = null,
839: original_shipment_id = null
840: WHERE tax_attribute_update_code = 'DIST_DELETE'
841: AND line_location_id IN (SELECT trx_line_id FROM zx_itm_distributions_gt);

Line 859: UPDATE po_line_locations_all pll

855: -- Add a join to zl.trx_id so that the index on zx_lines can be used
856: -- more efficiently
857:
858: -- Set the taxable flag column of shipments which have tax lines
859: UPDATE po_line_locations_all pll
860: SET pll.taxable_flag =
861: DECODE((SELECT COUNT(1) FROM zx_lines zl
862: WHERE zl.trx_line_id = pll.line_location_id
863: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID

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 975: -- PO_LINE_LOCATIONS_ALL.tax_attribute_update_code

971: --Pre-reqs:
972: -- Should be called when transaction data has been posted to the database
973: -- but not yet committed
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

Line 976: -- PO_LINE_LOCATIONS_ALL.original_shipment_id

972: -- Should be called when transaction data has been posted to the database
973: -- but not yet committed
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:

Line 977: -- PO_LINE_LOCATIONS_ALL.taxable_flag

973: -- but not yet committed
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

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 1820: UPDATE po_line_locations_all pll

1816: WHERE pd.po_distribution_id IN
1817: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
1818:
1819: /* Bug 6157632 Start */
1820: UPDATE po_line_locations_all pll
1821: SET pll.taxable_flag =
1822: DECODE((SELECT COUNT(1) FROM zx_lines zl
1823: WHERE zl.trx_line_id = pll.line_location_id
1824: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID

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 2039: UPDATE po_line_locations_all pll

2035: WHERE pd.po_distribution_id IN
2036: (SELECT trx_line_dist_id FROM zx_itm_distributions_gt);
2037:
2038: /* Bug 6157632 Start */
2039: UPDATE po_line_locations_all pll
2040: SET pll.taxable_flag =
2041: DECODE((SELECT COUNT(1) FROM zx_lines zl
2042: WHERE zl.trx_line_id = pll.line_location_id
2043: AND zl.application_id = PO_CONSTANTS_SV.APPLICATION_ID

Line 2383: FROM po_line_locations_all pll

2379: zxldet.document_sub_type)
2380: ,DECODE(ph.document_creation_method, --provnl_tax_determination_date
2381: 'CREATE_CONSUMPTION',
2382: (SELECT pll.need_by_date
2383: FROM po_line_locations_all pll
2384: WHERE pll.po_header_id=ph.po_header_id
2385: AND pll.need_by_date IS NOT NULL
2386: AND rownum=1),
2387: null)

Line 2491: FROM po_line_locations_all pll

2487: ,null --document_sub_type
2488: ,DECODE(ph.document_creation_method, --provnl_tax_determination_date
2489: 'CREATE_CONSUMPTION',
2490: (SELECT pll.need_by_date
2491: FROM po_line_locations_all pll
2492: WHERE pll.po_header_id=ph.po_header_id
2493: AND pll.need_by_date IS NOT NULL
2494: AND rownum=1),
2495: null)

Line 2596: FROM po_line_locations_all pll

2592: ,zxldet.document_sub_type --document_sub_type
2593: ,DECODE(pr.document_creation_method, --provnl_tax_determination_date
2594: 'CREATE_CONSUMPTION',
2595: (SELECT pll.need_by_date
2596: FROM po_line_locations_all pll
2597: WHERE pll.po_release_id=pr.po_release_id
2598: AND pll.need_by_date IS NOT NULL
2599: AND rownum=1),
2600: null)

Line 2719: FROM po_line_locations_all pll

2715: ,null --document_sub_type
2716: ,DECODE(pr.document_creation_method, --provnl_tax_determination_date
2717: 'CREATE_CONSUMPTION',
2718: (SELECT pll.need_by_date
2719: FROM po_line_locations_all pll
2720: WHERE pll.po_release_id=pr.po_release_id
2721: AND pll.need_by_date IS NOT NULL
2722: AND rownum=1),
2723: null)

Line 3045: FROM po_line_locations_all source_shipment

3041: 'PORELGEB', PO_CONSTANTS_SV.REQ_EVENT_CLASS_CODE,
3042: null)
3043: ,DECODE(p_calling_program, -- source_trx_id
3044: 'COPY_DOCUMENT', (SELECT source_shipment.po_header_id --source_trx_id
3045: FROM po_line_locations_all source_shipment
3046: WHERE source_shipment.line_location_id = pll.original_shipment_id
3047: AND p_calling_program = 'COPY_DOCUMENT'),
3048:
3049: 'POXBWVRP_PO', (SELECT requisition_header_id FROM

Line 3102: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,

3098: ,(SELECT 'Y' FROM DUAL --user_upd_det_factors_flag
3099: WHERE p_calling_program = 'PDOI'
3100: AND pll.tax_name IS NOT NULL)
3101: ,pll.ship_to_organization_id --Bug#6902111
3102: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,
3103: zx_lines_det_factors zxldet, po_vendors pv,
3104: po_vendor_sites_all pvs, mtl_system_items_b msib
3105: WHERE ph.po_header_id = pll.po_header_id
3106: AND pl.po_line_id = pll.po_line_id

Line 3407: ,po_line_locations_all pll

3403: -- Join with items table for item information
3404: LEFT OUTER JOIN mtl_system_items_b msib
3405: ON (pl.item_id = msib.inventory_item_id
3406: AND pl.org_id = msib.organization_id)
3407: ,po_line_locations_all pll
3408: -- Conditions for getting Additional Tax Attributes
3409: -- Do not put a condition on zxldet.trx_id here because that would
3410: -- entail bringing the source_header_id for the shipment being
3411: -- currently processed. Join with trx_line_id itself is unique

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 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 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 4231: po_line_locations_all PLL,

4227: WHERE EXISTS
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

Line 4257: po_line_locations_all PLL,

4253: FROM DUAL
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

Line 4542: UPDATE po_line_locations_all

4538: -- for which distributions are deleted
4539: --
4540:
4541: FORALL i IN 1..p_del_dist_shipment_table.COUNT
4542: UPDATE po_line_locations_all
4543: SET tax_attribute_update_code = NVL(tax_attribute_update_code,'DIST_DELETE')
4544: WHERE line_location_id = p_del_dist_shipment_table(i);
4545:
4546: d_progress := 10;

Line 5013: l_qty PO_LINE_LOCATIONS_ALL.QUANTITY%type;

5009: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%type ;
5010: l_bill_to_loc PO_HEADERS_ALL.BILL_TO_LOCATION_ID%type; --
5011: l_uom PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%type;
5012: l_price PO_LINES_ALL.UNIT_PRICE%type;
5013: l_qty PO_LINE_LOCATIONS_ALL.QUANTITY%type;
5014: l_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%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;

Line 5014: l_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%type; --

5010: l_bill_to_loc PO_HEADERS_ALL.BILL_TO_LOCATION_ID%type; --
5011: l_uom PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%type;
5012: l_price PO_LINES_ALL.UNIT_PRICE%type;
5013: l_qty PO_LINE_LOCATIONS_ALL.QUANTITY%type;
5014: l_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%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 ;

Line 5015: l_amt PO_LINE_LOCATIONS_ALL.AMOUNT%type;

5011: l_uom PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%type;
5012: l_price PO_LINES_ALL.UNIT_PRICE%type;
5013: l_qty PO_LINE_LOCATIONS_ALL.QUANTITY%type;
5014: l_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%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;

Line 5016: l_ship_to_org PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID%type;

5012: l_price PO_LINES_ALL.UNIT_PRICE%type;
5013: l_qty PO_LINE_LOCATIONS_ALL.QUANTITY%type;
5014: l_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%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;

Line 5017: l_ship_to_loc PO_LINE_LOCATIONS_ALL.SHIP_TO_LOCATION_ID%type;

5013: l_qty PO_LINE_LOCATIONS_ALL.QUANTITY%type;
5014: l_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%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;

Line 5018: l_need_by_date PO_LINE_LOCATIONS_ALL.NEED_BY_DATE%type ;

5014: l_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%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;

Line 5145: FROM po_line_locations_all

5141: l_amt,
5142: l_ship_to_org,
5143: l_ship_to_loc,
5144: l_need_by_date
5145: FROM po_line_locations_all
5146: WHERE line_location_id = p_doc_level_id;
5147:
5148: IF nvl(l_qty ,-99) = nvl(p_qty ,-99) AND
5149: -- Shipment level price is also tax determining

Line 5570: FROM po_line_locations_all pll

5566:
5567: l_ship_id_tbl := null; l_ship_tauc_tbl := null;
5568: SELECT pll.line_location_id, pll.tax_attribute_update_code
5569: BULK COLLECT INTO l_ship_id_tbl, l_ship_tauc_tbl
5570: FROM po_line_locations_all pll
5571: WHERE pll.po_line_id = l_line_id_tbl(j);
5572:
5573: FOR k IN 1..l_ship_id_tbl.COUNT LOOP
5574: PO_LOG.stmt(d_module_base,d_progress,' line_location_id = '||l_ship_id_tbl(k)||':'||l_ship_tauc_tbl(k));

Line 5649: FROM po_line_locations_all pll

5645:
5646: l_ship_id_tbl := null; l_ship_tauc_tbl := null;
5647: SELECT pll.line_location_id, pll.tax_attribute_update_code
5648: BULK COLLECT INTO l_ship_id_tbl, l_ship_tauc_tbl
5649: FROM po_line_locations_all pll
5650: WHERE pll.po_release_id = p_po_release_id_tbl(i);
5651:
5652: FOR j IN 1..l_ship_id_tbl.COUNT LOOP
5653: PO_LOG.stmt(d_module_base,d_progress,' line_location_id = '||l_ship_id_tbl(j)||':'||l_ship_tauc_tbl(j));

Line 5971: FROM po_line_locations_all pll

5967: pll.line_location_id,
5968: 'CANCEL', --line_level_action
5969: 'N', -- dummy value
5970: 0 -- dummy value
5971: FROM po_line_locations_all pll
5972: WHERE pll.po_line_id = p_line_id;
5973:
5974: d_progress := 90;
5975: log_header_tax_attributes(d_module_base,d_progress);

Line 6432: -- PO_LINE_LOCATIONS_ALL.approved_flag

6428: --Name: unapprove_schedules
6429: --Pre-reqs:
6430: -- None
6431: --Modifies:
6432: -- PO_LINE_LOCATIONS_ALL.approved_flag
6433: --Locks:
6434: -- PO_LINE_LOCATIONS_ALL
6435: --Function:
6436: -- Unapprove the given schedules if they are approved

Line 6434: -- PO_LINE_LOCATIONS_ALL

6430: -- None
6431: --Modifies:
6432: -- PO_LINE_LOCATIONS_ALL.approved_flag
6433: --Locks:
6434: -- PO_LINE_LOCATIONS_ALL
6435: --Function:
6436: -- Unapprove the given schedules if they are approved
6437: --Parameters:
6438: --IN:

Line 6476: UPDATE po_line_locations_all pll

6472:
6473: -- Unapprove line locations that are approved
6474: d_progress := 10;
6475: FORALL i IN 1..p_line_location_id_tbl.COUNT
6476: UPDATE po_line_locations_all pll
6477: SET pll.approved_flag = 'R'
6478: WHERE pll.line_location_id = p_line_location_id_tbl(i)
6479: AND pll.approved_flag = 'Y';
6480: