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_HEADERS_ALL

Line 201: FROM po_headers_all ph, po_lines_all pl

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
202: WHERE pll.po_line_id = pl.po_line_id
203: AND pll.po_header_id = ph.po_header_id
204: -- following AND written only for clarity
205: --AND (pl.tax_attribute_update_code IS NOT NULL

Line 221: FROM po_headers_all ph

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
222: WHERE pll.po_header_id = ph.po_header_id
223: -- following AND written only for clarity
224: --AND ph.tax_attribute_update_code IS NOT NULL
225: )

Line 330: FROM zx_validation_errors_gt zxvegt, po_headers_all ph

326: ,zxvegt.event_class_code
327: ,zxvegt.message_text
328: ,'VALIDATE'
329: ,ph.segment1
330: FROM zx_validation_errors_gt zxvegt, po_headers_all ph
331: WHERE zxvegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
332: AND zxvegt.trx_id = ph.po_header_id;
333:
334: d_progress := 150;

Line 354: FROM zx_validation_errors_gt zxvegt, po_headers_all ph,

350: ,zxvegt.event_class_code
351: ,zxvegt.message_text
352: ,'VALIDATE'
353: ,ph.segment1
354: FROM zx_validation_errors_gt zxvegt, po_headers_all ph,
355: po_releases_all pr
356: WHERE zxvegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
357: AND zxvegt.trx_id = pr.po_release_id
358: AND pr.po_header_id = ph.po_header_id;

Line 483: FROM zx_errors_gt zxegt, po_headers_all ph

479: ,zxegt.event_class_code
480: ,zxegt.message_text
481: ,'CALCULATE_TAX'
482: ,ph.segment1
483: FROM zx_errors_gt zxegt, po_headers_all ph
484: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
485: AND zxegt.trx_id = ph.po_header_id;
486:
487: d_progress := 240;

Line 507: FROM zx_errors_gt zxegt, po_headers_all ph, po_releases_all pr

503: ,zxegt.event_class_code
504: ,zxegt.message_text
505: ,'CALCULATE_TAX'
506: ,ph.segment1
507: FROM zx_errors_gt zxegt, po_headers_all ph, po_releases_all pr
508: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
509: AND zxegt.trx_id = pr.po_release_id
510: AND pr.po_header_id = ph.po_header_id;
511:

Line 667: FROM zx_errors_gt zxegt, po_headers_all ph

663: ,zxegt.event_class_code
664: ,zxegt.message_text
665: ,'DETERMINE_RECOVERY'
666: ,ph.segment1
667: FROM zx_errors_gt zxegt, po_headers_all ph
668: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
669: AND zxegt.trx_id = ph.po_header_id;
670:
671: d_progress := 360;

Line 691: FROM zx_errors_gt zxegt, po_headers_all ph, po_releases_all pr

687: ,zxegt.event_class_code
688: ,zxegt.message_text
689: ,'DETERMINE_RECOVERY'
690: ,ph.segment1
691: FROM zx_errors_gt zxegt, po_headers_all ph, po_releases_all pr
692: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
693: AND zxegt.trx_id = pr.po_release_id
694: AND pr.po_header_id = ph.po_header_id;
695:

Line 802: UPDATE po_headers_all ph

798: -- updates a line, tax_attribute_update_code at line will be UPDATE, but
799: -- shipment level tax_attribute_update_code's will be correct (because of
800: -- denormalization) and will have a higher priority than those of the line
801: FORALL i IN 1..p_po_header_id_tbl.COUNT
802: UPDATE po_headers_all ph
803: SET ph.tax_attribute_update_code = null
804: WHERE ph.po_header_id = p_po_header_id_tbl(i)
805: -- Bug 4774900 null out if even a single shipment has been processed
806: -- correctly. That would mean that the header has been recorded

Line 1132: l_org_id PO_HEADERS_ALL.org_id%TYPE;

1128: l_line_count NUMBER;
1129: l_msg_count NUMBER;
1130: l_msg_data VARCHAR2(1000);
1131: l_trx_rec ZX_API_PUB.transaction_rec_type;
1132: l_org_id PO_HEADERS_ALL.org_id%TYPE;
1133: l_return_status VARCHAR2(1);
1134: BEGIN
1135:
1136: SAVEPOINT calculate_tax_req_savepoint;

Line 1774: FROM zx_errors_gt zxegt, po_headers_all ph,

1770: ,zxegt.trx_line_dist_id --distribution_id,
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(+);

Line 1992: FROM zx_errors_gt zxegt, po_releases_all pr, po_headers_all ph,

1988: ,zxegt.trx_line_dist_id --distribution_id,
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(+)

Line 2392: FROM po_headers_all ph, zx_lines_det_factors zxldet, fnd_currencies fc

2388: -- Bug 5025018. Updated tax attribute mappings
2389: ,ph.org_id --rounding_bill_to_party_id
2390: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id
2391: WHERE pvs.vendor_site_id=ph.vendor_site_id)
2392: FROM po_headers_all ph, zx_lines_det_factors zxldet, fnd_currencies fc
2393: WHERE ph.po_header_id = p_po_header_id_tbl(i)
2394: AND fc.currency_code = ph.currency_code
2395: -- Conditions for getting Additional Tax Attributes
2396: -- Note that the po_header_id is of current document being processed,

Line 2500: FROM po_headers_all ph, fnd_currencies fc

2496: -- Bug 5025018. Updated tax attribute mappings
2497: ,ph.org_id --rounding_bill_to_party_id
2498: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id
2499: WHERE pvs.vendor_site_id=ph.vendor_site_id)
2500: FROM po_headers_all ph, fnd_currencies fc
2501: WHERE ph.po_header_id = p_po_header_id
2502: AND fc.currency_code = ph.currency_code;
2503:
2504: END populate_header_po;

Line 2607: FROM po_headers_all ph

2603: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id
2604: WHERE pvs.vendor_site_id=ph.vendor_site_id)
2605: -- Using OUTER JOIN in FROM clause syntax here because (+) operator
2606: -- is not flexible enough to be used inside an OR condition
2607: FROM po_headers_all ph
2608: ,fnd_currencies fc
2609: ,po_releases_all pr
2610: -- Conditions for getting Additional Tax Attributes
2611: -- Copy from Planned PO if its a newly created Scheduled Release

Line 2728: FROM po_releases_all pr, po_headers_all ph, fnd_currencies fc

2724: -- Bug 5025018. Updated tax attribute mappings
2725: ,ph.org_id --rounding_bill_to_party_id
2726: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id
2727: WHERE pvs.vendor_site_id=ph.vendor_site_id)
2728: FROM po_releases_all pr, po_headers_all ph, fnd_currencies fc
2729: WHERE pr.po_release_id = p_po_release_id
2730: AND pr.po_header_id = ph.po_header_id
2731: AND fc.currency_code = ph.currency_code;
2732:

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 3397: ,po_headers_all ph

3393: ,pll.ship_to_organization_id --Bug#6902111
3394: -- Using OUTER JOIN in FROM clause syntax here because (+) operator
3395: -- is not flexible enough to be used inside an OR condition
3396: FROM po_releases_all pr
3397: ,po_headers_all ph
3398: -- Join with vendor tables to get party and party site information
3399: LEFT OUTER JOIN po_vendors pov ON (ph.vendor_id = pov.vendor_id)
3400: LEFT OUTER JOIN po_vendor_sites_all pvs
3401: ON (ph.vendor_site_id = pvs.vendor_site_id)

Line 4229: FROM po_headers_all POH,

4225: SELECT 'Y' INTO l_result
4226: FROM DUAL
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

Line 5003: l_trx_currency PO_HEADERS_ALL.CURRENCY_CODE%type;

4999: p_dist_amount_ordered IN NUMBER DEFAULT NULL
5000: ) RETURN BOOLEAN IS
5001: pragma AUTONOMOUS_TRANSACTION;
5002:
5003: l_trx_currency PO_HEADERS_ALL.CURRENCY_CODE%type;
5004: l_rate_type PO_HEADERS_ALL.RATE_TYPE %type;
5005: l_rate_date PO_HEADERS_ALL. RATE_DATE%type;
5006: l_rate PO_HEADERS_ALL. RATE%type;
5007: l_fob PO_HEADERS_ALL.FOB_LOOKUP_CODE%type ;

Line 5004: l_rate_type PO_HEADERS_ALL.RATE_TYPE %type;

5000: ) RETURN BOOLEAN IS
5001: pragma AUTONOMOUS_TRANSACTION;
5002:
5003: l_trx_currency PO_HEADERS_ALL.CURRENCY_CODE%type;
5004: l_rate_type PO_HEADERS_ALL.RATE_TYPE %type;
5005: l_rate_date PO_HEADERS_ALL. RATE_DATE%type;
5006: l_rate PO_HEADERS_ALL. RATE%type;
5007: l_fob PO_HEADERS_ALL.FOB_LOOKUP_CODE%type ;
5008: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%type;

Line 5005: l_rate_date PO_HEADERS_ALL. RATE_DATE%type;

5001: pragma AUTONOMOUS_TRANSACTION;
5002:
5003: l_trx_currency PO_HEADERS_ALL.CURRENCY_CODE%type;
5004: l_rate_type PO_HEADERS_ALL.RATE_TYPE %type;
5005: l_rate_date PO_HEADERS_ALL. RATE_DATE%type;
5006: l_rate PO_HEADERS_ALL. RATE%type;
5007: l_fob PO_HEADERS_ALL.FOB_LOOKUP_CODE%type ;
5008: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%type;
5009: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%type ;

Line 5006: l_rate PO_HEADERS_ALL. RATE%type;

5002:
5003: l_trx_currency PO_HEADERS_ALL.CURRENCY_CODE%type;
5004: l_rate_type PO_HEADERS_ALL.RATE_TYPE %type;
5005: l_rate_date PO_HEADERS_ALL. RATE_DATE%type;
5006: l_rate PO_HEADERS_ALL. RATE%type;
5007: l_fob PO_HEADERS_ALL.FOB_LOOKUP_CODE%type ;
5008: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%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; --

Line 5007: l_fob PO_HEADERS_ALL.FOB_LOOKUP_CODE%type ;

5003: l_trx_currency PO_HEADERS_ALL.CURRENCY_CODE%type;
5004: l_rate_type PO_HEADERS_ALL.RATE_TYPE %type;
5005: l_rate_date PO_HEADERS_ALL. RATE_DATE%type;
5006: l_rate PO_HEADERS_ALL. RATE%type;
5007: l_fob PO_HEADERS_ALL.FOB_LOOKUP_CODE%type ;
5008: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%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;

Line 5008: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%type;

5004: l_rate_type PO_HEADERS_ALL.RATE_TYPE %type;
5005: l_rate_date PO_HEADERS_ALL. RATE_DATE%type;
5006: l_rate PO_HEADERS_ALL. RATE%type;
5007: l_fob PO_HEADERS_ALL.FOB_LOOKUP_CODE%type ;
5008: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%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;

Line 5009: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%type ;

5005: l_rate_date PO_HEADERS_ALL. RATE_DATE%type;
5006: l_rate PO_HEADERS_ALL. RATE%type;
5007: l_fob PO_HEADERS_ALL.FOB_LOOKUP_CODE%type ;
5008: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%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;

Line 5010: l_bill_to_loc PO_HEADERS_ALL.BILL_TO_LOCATION_ID%type; --

5006: l_rate PO_HEADERS_ALL. RATE%type;
5007: l_fob PO_HEADERS_ALL.FOB_LOOKUP_CODE%type ;
5008: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%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; --

Line 5092: FROM po_headers_all

5088: l_fob,
5089: l_vendor_id,
5090: l_vendor_site_id,
5091: l_bill_to_loc --
5092: FROM po_headers_all
5093: WHERE po_header_id = p_doc_level_id;
5094: END;
5095: IF ((nvl(l_trx_currency,'-99') = nvl(p_trx_currency,'-99')) AND
5096: (nvl(l_rate_type,'-99') = nvl(p_rate_type,'-99')) AND

Line 5229: FROM po_headers_all

5225: l_rate,
5226: l_fob,
5227: l_vendor_id,
5228: l_vendor_site_id
5229: FROM po_headers_all
5230: WHERE po_header_id = p_doc_level_id;
5231:
5232: IF ((nvl(l_trx_currency,'-99') = nvl(p_trx_currency,'-99')) AND
5233: (nvl(l_rate_type,'-99') = nvl(p_rate_type,'-99')) AND

Line 5543: l_header_tauc PO_HEADERS_ALL.tax_attribute_update_code%TYPE;

5539: d_progress NUMBER := p_progress;
5540: l_line_id_tbl PO_TBL_NUMBER;
5541: l_ship_id_tbl PO_TBL_NUMBER;
5542: l_dist_id_tbl PO_TBL_NUMBER;
5543: l_header_tauc PO_HEADERS_ALL.tax_attribute_update_code%TYPE;
5544: l_line_tauc_tbl PO_TBL_VARCHAR15;
5545: l_ship_tauc_tbl PO_TBL_VARCHAR15;
5546: l_dist_tauc_tbl PO_TBL_VARCHAR15;
5547: BEGIN

Line 5553: FROM po_headers_all ph

5549: FOR i IN 1..p_po_header_id_tbl.COUNT LOOP
5550:
5551: SELECT ph.tax_attribute_update_code
5552: INTO l_header_tauc
5553: FROM po_headers_all ph
5554: WHERE ph.po_header_id = p_po_header_id_tbl(i);
5555:
5556: PO_LOG.stmt(d_module_base,d_progress,' po_header_id = '||p_po_header_id_tbl(i)||':'||l_header_tauc);
5557:

Line 5825: l_org_id PO_HEADERS_ALL.org_id%TYPE;

5821: l_module_name CONSTANT VARCHAR2(100) := 'CANCEL_TAX_LINES';
5822: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(
5823: D_PACKAGE_BASE, l_module_name);
5824: d_progress NUMBER;
5825: l_org_id PO_HEADERS_ALL.org_id%TYPE;
5826: BEGIN
5827:
5828: IF (PO_LOG.d_proc) THEN
5829: PO_LOG.proc_begin(d_module_base);

Line 5864: FROM po_headers_all ph

5860: sysdate, -- dummy value
5861: PO_CORE_S.get_default_legal_entity_id(ph.org_id),
5862: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id
5863: WHERE vendor_id=ph.vendor_id)
5864: FROM po_headers_all ph
5865: WHERE ph.po_header_id = p_document_id;
5866:
5867: d_progress := 30;
5868: INSERT INTO zx_transaction_lines_gt

Line 5945: FROM po_headers_all ph

5941: sysdate, -- dummy value
5942: PO_CORE_S.get_default_legal_entity_id(ph.org_id),
5943: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id
5944: WHERE vendor_id=ph.vendor_id)
5945: FROM po_headers_all ph
5946: WHERE ph.po_header_id = p_document_id;
5947:
5948: d_progress := 80;
5949: INSERT INTO zx_transaction_lines_gt

Line 6005: FROM po_headers_all ph

6001: -- in Cancel mode
6002: d_progress := 120;
6003: SELECT ph.org_id
6004: INTO l_org_id
6005: FROM po_headers_all ph
6006: WHERE ph.po_header_id = p_document_id;
6007:
6008: d_progress := 130;
6009: IF (PO_LOG.d_stmt) THEN

Line 6062: FROM po_releases_all pr, po_headers_all ph

6058: sysdate, -- dummy value
6059: PO_CORE_S.get_default_legal_entity_id(pr.org_id),
6060: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id
6061: WHERE vendor_id=ph.vendor_id)
6062: FROM po_releases_all pr, po_headers_all ph
6063: WHERE pr.po_release_id = p_document_id
6064: AND pr.po_header_id = ph.po_header_id;
6065:
6066: d_progress := 180;

Line 6312: -- PO_HEADERS_ALL.authorization_status

6308: --Name: unapprove_doc_header
6309: --Pre-reqs:
6310: -- None
6311: --Modifies:
6312: -- PO_HEADERS_ALL.authorization_status
6313: -- PO_HEADERS_ALL.approved_flag
6314: -- PO_RELEASES_ALL.authorization_status
6315: -- PO_RELEASES_ALL.approved_flag
6316: --Locks:

Line 6313: -- PO_HEADERS_ALL.approved_flag

6309: --Pre-reqs:
6310: -- None
6311: --Modifies:
6312: -- PO_HEADERS_ALL.authorization_status
6313: -- PO_HEADERS_ALL.approved_flag
6314: -- PO_RELEASES_ALL.authorization_status
6315: -- PO_RELEASES_ALL.approved_flag
6316: --Locks:
6317: -- PO_HEADERS_ALL

Line 6317: -- PO_HEADERS_ALL

6313: -- PO_HEADERS_ALL.approved_flag
6314: -- PO_RELEASES_ALL.authorization_status
6315: -- PO_RELEASES_ALL.approved_flag
6316: --Locks:
6317: -- PO_HEADERS_ALL
6318: -- PO_RELEASES_ALL
6319: --Function:
6320: -- Unapprove the header for the given document
6321: --Parameters:

Line 6347: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;

6343: l_module_name CONSTANT VARCHAR2(100) := 'UNAPPROVE_DOC_HEADER';
6344: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(
6345: D_PACKAGE_BASE, l_module_name);
6346: d_progress NUMBER;
6347: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;
6348: BEGIN
6349:
6350: IF (PO_LOG.d_proc) THEN
6351: PO_LOG.proc_begin(d_module_base);

Line 6364: FROM po_headers_all ph

6360: d_progress := 10;
6361: IF p_document_type = PO_CONSTANTS_SV.PO THEN
6362: SELECT ph.authorization_status
6363: INTO l_authorization_status
6364: FROM po_headers_all ph
6365: WHERE ph.po_header_id = p_document_id;
6366: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
6367: SELECT pr.authorization_status
6368: INTO l_authorization_status

Line 6381: UPDATE po_headers_all ph

6377: IF l_authorization_status = PO_CONSTANTS_SV.PRE_APPROVED THEN
6378:
6379: d_progress := 20;
6380: IF p_document_type = PO_CONSTANTS_SV.PO THEN
6381: UPDATE po_headers_all ph
6382: SET ph.authorization_status = PO_CONSTANTS_SV.IN_PROCESS,
6383: ph.approved_flag = 'N'
6384: WHERE ph.po_header_id = p_document_id;
6385: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN

Line 6396: UPDATE po_headers_all ph

6392: ELSIF l_authorization_status = PO_CONSTANTS_SV.APPROVED THEN
6393:
6394: d_progress := 30;
6395: IF p_document_type = PO_CONSTANTS_SV.PO THEN
6396: UPDATE po_headers_all ph
6397: SET ph.authorization_status = PO_CONSTANTS_SV.REQUIRES_REAPPROVAL,
6398: ph.approved_flag = 'R'
6399: WHERE ph.po_header_id = p_document_id;
6400: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN