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

218: AND pod.line_location_id = pll.line_location_id
219: AND ROWNUM = 1),
220: NVL (pl.tax_attribute_update_code,
221: ph.tax_attribute_update_code))
222: FROM po_headers_all ph,
223: po_lines_all pl
224: WHERE pll.po_line_id = pl.po_line_id
225: AND pll.po_header_id = ph.po_header_id
226: ),

Line 256: -- Replaced po_headers_all with po_releases_all for releases case.

252: pll.po_release_id = p_po_release_id_tbl(i)
253: AND (pll.tax_attribute_update_code IS NULL
254: OR pll.tax_attribute_update_code = 'DIST_DELETE');
255:
256: -- Replaced po_headers_all with po_releases_all for releases case.
257: -- End bug 13925912
258:
259: IF PO_LOG.d_stmt THEN
260: PO_LOG.stmt(d_module_base,d_progress,'tax_attribute_update_codes after denormalization');

Line 356: FROM zx_validation_errors_gt zxvegt, po_headers_all ph

352: ,zxvegt.event_class_code
353: ,zxvegt.message_text
354: ,'VALIDATE'
355: ,ph.segment1
356: FROM zx_validation_errors_gt zxvegt, po_headers_all ph
357: WHERE zxvegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
358: AND zxvegt.trx_id = ph.po_header_id;
359:
360: d_progress := 150;

Line 380: FROM zx_validation_errors_gt zxvegt, po_headers_all ph,

376: ,zxvegt.event_class_code
377: ,zxvegt.message_text
378: ,'VALIDATE'
379: ,ph.segment1
380: FROM zx_validation_errors_gt zxvegt, po_headers_all ph,
381: po_releases_all pr
382: WHERE zxvegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
383: AND zxvegt.trx_id = pr.po_release_id
384: AND pr.po_header_id = ph.po_header_id;

Line 540: FROM zx_errors_gt zxegt, po_headers_all ph

536: ,zxegt.event_class_code
537: ,zxegt.message_text
538: ,'CALCULATE_TAX'
539: ,ph.segment1
540: FROM zx_errors_gt zxegt, po_headers_all ph
541: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
542: AND zxegt.trx_id = ph.po_header_id;
543:
544: d_progress := 240;

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

560: ,zxegt.event_class_code
561: ,zxegt.message_text
562: ,'CALCULATE_TAX'
563: ,ph.segment1
564: FROM zx_errors_gt zxegt, po_headers_all ph, po_releases_all pr
565: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
566: AND zxegt.trx_id = pr.po_release_id
567: AND pr.po_header_id = ph.po_header_id;
568:

Line 732: FROM zx_errors_gt zxegt, po_headers_all ph

728: ,zxegt.event_class_code
729: ,zxegt.message_text
730: ,'DETERMINE_RECOVERY'
731: ,ph.segment1
732: FROM zx_errors_gt zxegt, po_headers_all ph
733: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.PO_EVENT_CLASS_CODE
734: AND zxegt.trx_id = ph.po_header_id;
735:
736: d_progress := 360;

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

752: ,zxegt.event_class_code
753: ,zxegt.message_text
754: ,'DETERMINE_RECOVERY'
755: ,ph.segment1
756: FROM zx_errors_gt zxegt, po_headers_all ph, po_releases_all pr
757: WHERE zxegt.event_class_code = PO_CONSTANTS_SV.REL_EVENT_CLASS_CODE
758: AND zxegt.trx_id = pr.po_release_id
759: AND pr.po_header_id = ph.po_header_id;
760:

Line 875: UPDATE po_headers_all ph

871: -- updates a line, tax_attribute_update_code at line will be UPDATE, but
872: -- shipment level tax_attribute_update_code's will be correct (because of
873: -- denormalization) and will have a higher priority than those of the line
874: FORALL i IN 1..p_po_header_id_tbl.COUNT
875: UPDATE po_headers_all ph
876: SET ph.tax_attribute_update_code = null
877: WHERE ph.po_header_id = p_po_header_id_tbl(i)
878: -- Bug 4774900 null out if even a single shipment has been processed
879: -- correctly. That would mean that the header has been recorded

Line 1167: FROM po_headers_all

1163: -- is null in case of 'RELEASE'. So added if check.
1164: IF (p_po_header_id <> NULL) THEN
1165: SELECT type_lookup_code
1166: INTO l_type_lookup_code
1167: FROM po_headers_all
1168: WHERE po_header_id = p_po_header_id;
1169:
1170: IF PO_LOG.d_stmt THEN
1171: PO_LOG.stmt(d_module_base,d_progress,'Tax will not be calculated for blanket purchase = ' || l_type_lookup_code );

Line 1286: l_org_id PO_HEADERS_ALL.org_id%TYPE;

1282: l_line_count NUMBER;
1283: l_msg_count NUMBER;
1284: l_msg_data VARCHAR2(1000);
1285: l_trx_rec ZX_API_PUB.transaction_rec_type;
1286: l_org_id PO_HEADERS_ALL.org_id%TYPE;
1287: l_return_status VARCHAR2(1);
1288:
1289: l_is_clm_req VARCHAR2(1); -- Bug 9718704
1290:

Line 1943: FROM zx_errors_gt zxegt, po_headers_all ph,

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

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

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

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

2573: -- Bug 5025018. Updated tax attribute mappings
2574: ,ph.org_id --rounding_bill_to_party_id
2575: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id
2576: WHERE pvs.vendor_site_id=ph.vendor_site_id)
2577: FROM po_headers_all ph, zx_lines_det_factors zxldet, fnd_currencies fc
2578: WHERE ph.po_header_id = p_po_header_id_tbl(i)
2579: AND fc.currency_code = ph.currency_code
2580: -- Conditions for getting Additional Tax Attributes
2581: -- Note that the po_header_id is of current document being processed,

Line 2685: FROM po_headers_all ph, fnd_currencies fc

2681: -- Bug 5025018. Updated tax attribute mappings
2682: ,ph.org_id --rounding_bill_to_party_id
2683: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id
2684: WHERE pvs.vendor_site_id=ph.vendor_site_id)
2685: FROM po_headers_all ph, fnd_currencies fc
2686: WHERE ph.po_header_id = p_po_header_id
2687: AND fc.currency_code = ph.currency_code;
2688:
2689: END populate_header_po;

Line 2792: FROM po_headers_all ph

2788: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id
2789: WHERE pvs.vendor_site_id=ph.vendor_site_id)
2790: -- Using OUTER JOIN in FROM clause syntax here because (+) operator
2791: -- is not flexible enough to be used inside an OR condition
2792: FROM po_headers_all ph
2793: ,fnd_currencies fc
2794: ,po_releases_all pr
2795: -- Conditions for getting Additional Tax Attributes
2796: -- Copy from Planned PO if its a newly created Scheduled Release

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

2909: -- Bug 5025018. Updated tax attribute mappings
2910: ,ph.org_id --rounding_bill_to_party_id
2911: ,(SELECT pvs.party_site_id from po_vendor_sites_all pvs --rndg_ship_from_party_site_id
2912: WHERE pvs.vendor_site_id=ph.vendor_site_id)
2913: FROM po_releases_all pr, po_headers_all ph, fnd_currencies fc
2914: WHERE pr.po_release_id = p_po_release_id
2915: AND pr.po_header_id = ph.po_header_id
2916: AND fc.currency_code = ph.currency_code;
2917:

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

3289: ,(SELECT 'Y' FROM DUAL --user_upd_det_factors_flag
3290: WHERE p_calling_program = 'PDOI'
3291: AND pll.tax_name IS NOT NULL)
3292: ,pll.ship_to_organization_id --Bug#6902111
3293: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,
3294: zx_lines_det_factors zxldet, po_vendors pv,
3295: po_vendor_sites_all pvs, mtl_system_items_b msib
3296: WHERE ph.po_header_id = pll.po_header_id
3297: AND pl.po_line_id = pll.po_line_id

Line 3601: ,po_headers_all ph

3597: ,pll.ship_to_organization_id --Bug#6902111
3598: -- Using OUTER JOIN in FROM clause syntax here because (+) operator
3599: -- is not flexible enough to be used inside an OR condition
3600: FROM po_releases_all pr
3601: ,po_headers_all ph
3602: -- Join with vendor tables to get party and party site information
3603: LEFT OUTER JOIN po_vendors pov ON (ph.vendor_id = pov.vendor_id)
3604: LEFT OUTER JOIN po_vendor_sites_all pvs
3605: ON (ph.vendor_site_id = pvs.vendor_site_id)

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

3949: ,(SELECT 'Y' FROM DUAL --user_upd_det_factors_flag
3950: WHERE p_calling_program = 'PDOI'
3951: AND pll.tax_name IS NOT NULL)
3952: ,pll.ship_to_organization_id --Bug#6902111
3953: FROM po_headers_all ph, po_lines_all pl, po_line_locations_all pll,
3954: zx_lines_det_factors zxldet, po_vendors pv,
3955: po_vendor_sites_all pvs, mtl_system_items_b msib
3956: WHERE ph.po_header_id = pll.po_header_id
3957: AND pl.po_line_id = pll.po_line_id

Line 4257: ,po_headers_all ph

4253: ,pll.ship_to_organization_id --Bug#6902111
4254: -- Using OUTER JOIN in FROM clause syntax here because (+) operator
4255: -- is not flexible enough to be used inside an OR condition
4256: FROM po_releases_all pr
4257: ,po_headers_all ph
4258: -- Join with vendor tables to get party and party site information
4259: LEFT OUTER JOIN po_vendors pov ON (ph.vendor_id = pov.vendor_id)
4260: LEFT OUTER JOIN po_vendor_sites_all pvs
4261: ON (ph.vendor_site_id = pvs.vendor_site_id)

Line 5122: FROM po_headers_all POH,

5118: SELECT 'Y' INTO l_result
5119: FROM DUAL
5120: WHERE EXISTS
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

Line 5898: l_trx_currency PO_HEADERS_ALL.CURRENCY_CODE%type;

5894: p_dist_amount_ordered IN NUMBER DEFAULT NULL
5895: ) RETURN BOOLEAN IS
5896: pragma AUTONOMOUS_TRANSACTION;
5897:
5898: l_trx_currency PO_HEADERS_ALL.CURRENCY_CODE%type;
5899: l_rate_type PO_HEADERS_ALL.RATE_TYPE %type;
5900: l_rate_date PO_HEADERS_ALL. RATE_DATE%type;
5901: l_rate PO_HEADERS_ALL. RATE%type;
5902: l_fob PO_HEADERS_ALL.FOB_LOOKUP_CODE%type ;

Line 5899: l_rate_type PO_HEADERS_ALL.RATE_TYPE %type;

5895: ) RETURN BOOLEAN IS
5896: pragma AUTONOMOUS_TRANSACTION;
5897:
5898: l_trx_currency PO_HEADERS_ALL.CURRENCY_CODE%type;
5899: l_rate_type PO_HEADERS_ALL.RATE_TYPE %type;
5900: l_rate_date PO_HEADERS_ALL. RATE_DATE%type;
5901: l_rate PO_HEADERS_ALL. RATE%type;
5902: l_fob PO_HEADERS_ALL.FOB_LOOKUP_CODE%type ;
5903: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%type;

Line 5900: l_rate_date PO_HEADERS_ALL. RATE_DATE%type;

5896: pragma AUTONOMOUS_TRANSACTION;
5897:
5898: l_trx_currency PO_HEADERS_ALL.CURRENCY_CODE%type;
5899: l_rate_type PO_HEADERS_ALL.RATE_TYPE %type;
5900: l_rate_date PO_HEADERS_ALL. RATE_DATE%type;
5901: l_rate PO_HEADERS_ALL. RATE%type;
5902: l_fob PO_HEADERS_ALL.FOB_LOOKUP_CODE%type ;
5903: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%type;
5904: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%type ;

Line 5901: l_rate PO_HEADERS_ALL. RATE%type;

5897:
5898: l_trx_currency PO_HEADERS_ALL.CURRENCY_CODE%type;
5899: l_rate_type PO_HEADERS_ALL.RATE_TYPE %type;
5900: l_rate_date PO_HEADERS_ALL. RATE_DATE%type;
5901: l_rate PO_HEADERS_ALL. RATE%type;
5902: l_fob PO_HEADERS_ALL.FOB_LOOKUP_CODE%type ;
5903: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%type;
5904: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%type ;
5905: l_bill_to_loc PO_HEADERS_ALL.BILL_TO_LOCATION_ID%type; --

Line 5902: l_fob PO_HEADERS_ALL.FOB_LOOKUP_CODE%type ;

5898: l_trx_currency PO_HEADERS_ALL.CURRENCY_CODE%type;
5899: l_rate_type PO_HEADERS_ALL.RATE_TYPE %type;
5900: l_rate_date PO_HEADERS_ALL. RATE_DATE%type;
5901: l_rate PO_HEADERS_ALL. RATE%type;
5902: l_fob PO_HEADERS_ALL.FOB_LOOKUP_CODE%type ;
5903: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%type;
5904: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%type ;
5905: l_bill_to_loc PO_HEADERS_ALL.BILL_TO_LOCATION_ID%type; --
5906: l_uom PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%type;

Line 5903: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%type;

5899: l_rate_type PO_HEADERS_ALL.RATE_TYPE %type;
5900: l_rate_date PO_HEADERS_ALL. RATE_DATE%type;
5901: l_rate PO_HEADERS_ALL. RATE%type;
5902: l_fob PO_HEADERS_ALL.FOB_LOOKUP_CODE%type ;
5903: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%type;
5904: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%type ;
5905: l_bill_to_loc PO_HEADERS_ALL.BILL_TO_LOCATION_ID%type; --
5906: l_uom PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%type;
5907: l_price PO_LINES_ALL.UNIT_PRICE%type;

Line 5904: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%type ;

5900: l_rate_date PO_HEADERS_ALL. RATE_DATE%type;
5901: l_rate PO_HEADERS_ALL. RATE%type;
5902: l_fob PO_HEADERS_ALL.FOB_LOOKUP_CODE%type ;
5903: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%type;
5904: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%type ;
5905: l_bill_to_loc PO_HEADERS_ALL.BILL_TO_LOCATION_ID%type; --
5906: l_uom PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%type;
5907: l_price PO_LINES_ALL.UNIT_PRICE%type;
5908: l_qty PO_LINE_LOCATIONS_ALL.QUANTITY%type;

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

5901: l_rate PO_HEADERS_ALL. RATE%type;
5902: l_fob PO_HEADERS_ALL.FOB_LOOKUP_CODE%type ;
5903: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%type;
5904: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%type ;
5905: l_bill_to_loc PO_HEADERS_ALL.BILL_TO_LOCATION_ID%type; --
5906: l_uom PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%type;
5907: l_price PO_LINES_ALL.UNIT_PRICE%type;
5908: l_qty PO_LINE_LOCATIONS_ALL.QUANTITY%type;
5909: l_price_override PO_LINE_LOCATIONS_ALL.PRICE_OVERRIDE%type; --

Line 5987: FROM po_headers_all

5983: l_fob,
5984: l_vendor_id,
5985: l_vendor_site_id,
5986: l_bill_to_loc --
5987: FROM po_headers_all
5988: WHERE po_header_id = p_doc_level_id;
5989: END;
5990: IF ((nvl(l_trx_currency,'-99') = nvl(p_trx_currency,'-99')) AND
5991: (nvl(l_rate_type,'-99') = nvl(p_rate_type,'-99')) AND

Line 6124: FROM po_headers_all

6120: l_rate,
6121: l_fob,
6122: l_vendor_id,
6123: l_vendor_site_id
6124: FROM po_headers_all
6125: WHERE po_header_id = p_doc_level_id;
6126:
6127: IF ((nvl(l_trx_currency,'-99') = nvl(p_trx_currency,'-99')) AND
6128: (nvl(l_rate_type,'-99') = nvl(p_rate_type,'-99')) AND

Line 6439: l_header_tauc PO_HEADERS_ALL.tax_attribute_update_code%TYPE;

6435: d_progress NUMBER := p_progress;
6436: l_line_id_tbl PO_TBL_NUMBER;
6437: l_ship_id_tbl PO_TBL_NUMBER;
6438: l_dist_id_tbl PO_TBL_NUMBER;
6439: l_header_tauc PO_HEADERS_ALL.tax_attribute_update_code%TYPE;
6440: l_line_tauc_tbl PO_TBL_VARCHAR15;
6441: l_ship_tauc_tbl PO_TBL_VARCHAR15;
6442: l_dist_tauc_tbl PO_TBL_VARCHAR15;
6443: BEGIN

Line 6449: FROM po_headers_all ph

6445: FOR i IN 1..p_po_header_id_tbl.COUNT LOOP
6446:
6447: SELECT ph.tax_attribute_update_code
6448: INTO l_header_tauc
6449: FROM po_headers_all ph
6450: WHERE ph.po_header_id = p_po_header_id_tbl(i);
6451:
6452: PO_LOG.stmt(d_module_base,d_progress,' po_header_id = '||p_po_header_id_tbl(i)||':'||l_header_tauc);
6453:

Line 6721: l_org_id PO_HEADERS_ALL.org_id%TYPE;

6717: l_module_name CONSTANT VARCHAR2(100) := 'CANCEL_TAX_LINES';
6718: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(
6719: D_PACKAGE_BASE, l_module_name);
6720: d_progress NUMBER;
6721: l_org_id PO_HEADERS_ALL.org_id%TYPE;
6722: BEGIN
6723:
6724: IF (PO_LOG.d_proc) THEN
6725: PO_LOG.proc_begin(d_module_base);

Line 6772: FROM po_headers_all ph

6768: sysdate, -- dummy value
6769: PO_CORE_S.get_default_legal_entity_id(ph.org_id),
6770: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id
6771: WHERE vendor_id=ph.vendor_id)
6772: FROM po_headers_all ph
6773: WHERE ph.po_header_id = p_document_id;
6774:
6775: d_progress := 30;
6776: INSERT INTO zx_transaction_lines_gt

Line 6853: FROM po_headers_all ph

6849: sysdate, -- dummy value
6850: PO_CORE_S.get_default_legal_entity_id(ph.org_id),
6851: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id
6852: WHERE vendor_id=ph.vendor_id)
6853: FROM po_headers_all ph
6854: WHERE ph.po_header_id = p_document_id;
6855:
6856: d_progress := 80;
6857: INSERT INTO zx_transaction_lines_gt

Line 6913: FROM po_headers_all ph

6909: -- in Cancel mode
6910: d_progress := 120;
6911: SELECT ph.org_id
6912: INTO l_org_id
6913: FROM po_headers_all ph
6914: WHERE ph.po_header_id = p_document_id;
6915:
6916: d_progress := 130;
6917: IF (PO_LOG.d_stmt) THEN

Line 6970: FROM po_releases_all pr, po_headers_all ph

6966: sysdate, -- dummy value
6967: PO_CORE_S.get_default_legal_entity_id(pr.org_id),
6968: (SELECT party_id FROM po_vendors --rounding_ship_from_party_id
6969: WHERE vendor_id=ph.vendor_id)
6970: FROM po_releases_all pr, po_headers_all ph
6971: WHERE pr.po_release_id = p_document_id
6972: AND pr.po_header_id = ph.po_header_id;
6973:
6974: d_progress := 180;

Line 7220: -- PO_HEADERS_ALL.authorization_status

7216: --Name: unapprove_doc_header
7217: --Pre-reqs:
7218: -- None
7219: --Modifies:
7220: -- PO_HEADERS_ALL.authorization_status
7221: -- PO_HEADERS_ALL.approved_flag
7222: -- PO_RELEASES_ALL.authorization_status
7223: -- PO_RELEASES_ALL.approved_flag
7224: --Locks:

Line 7221: -- PO_HEADERS_ALL.approved_flag

7217: --Pre-reqs:
7218: -- None
7219: --Modifies:
7220: -- PO_HEADERS_ALL.authorization_status
7221: -- PO_HEADERS_ALL.approved_flag
7222: -- PO_RELEASES_ALL.authorization_status
7223: -- PO_RELEASES_ALL.approved_flag
7224: --Locks:
7225: -- PO_HEADERS_ALL

Line 7225: -- PO_HEADERS_ALL

7221: -- PO_HEADERS_ALL.approved_flag
7222: -- PO_RELEASES_ALL.authorization_status
7223: -- PO_RELEASES_ALL.approved_flag
7224: --Locks:
7225: -- PO_HEADERS_ALL
7226: -- PO_RELEASES_ALL
7227: --Function:
7228: -- Unapprove the header for the given document
7229: --Parameters:

Line 7255: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;

7251: l_module_name CONSTANT VARCHAR2(100) := 'UNAPPROVE_DOC_HEADER';
7252: d_module_base CONSTANT VARCHAR2(100) := PO_LOG.get_subprogram_base(
7253: D_PACKAGE_BASE, l_module_name);
7254: d_progress NUMBER;
7255: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;
7256: BEGIN
7257:
7258: IF (PO_LOG.d_proc) THEN
7259: PO_LOG.proc_begin(d_module_base);

Line 7272: FROM po_headers_all ph

7268: d_progress := 10;
7269: IF p_document_type = PO_CONSTANTS_SV.PO THEN
7270: SELECT ph.authorization_status
7271: INTO l_authorization_status
7272: FROM po_headers_all ph
7273: WHERE ph.po_header_id = p_document_id;
7274: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN
7275: SELECT pr.authorization_status
7276: INTO l_authorization_status

Line 7289: UPDATE po_headers_all ph

7285: IF l_authorization_status = PO_CONSTANTS_SV.PRE_APPROVED THEN
7286:
7287: d_progress := 20;
7288: IF p_document_type = PO_CONSTANTS_SV.PO THEN
7289: UPDATE po_headers_all ph
7290: SET ph.authorization_status = PO_CONSTANTS_SV.IN_PROCESS,
7291: ph.approved_flag = 'N'
7292: WHERE ph.po_header_id = p_document_id;
7293: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN

Line 7304: UPDATE po_headers_all ph

7300: ELSIF l_authorization_status = PO_CONSTANTS_SV.APPROVED THEN
7301:
7302: d_progress := 30;
7303: IF p_document_type = PO_CONSTANTS_SV.PO THEN
7304: UPDATE po_headers_all ph
7305: SET ph.authorization_status = PO_CONSTANTS_SV.REQUIRES_REAPPROVAL,
7306: ph.approved_flag = 'R'
7307: WHERE ph.po_header_id = p_document_id;
7308: ELSIF p_document_type = PO_CONSTANTS_SV.RELEASE THEN