DBA Data[Home] [Help]

APPS.PO_TAX_INTERFACE_PVT dependencies on PO_RELEASES_ALL

Line 355: po_releases_all pr

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;
359:

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 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 814: UPDATE po_releases_all pr

810: WHERE zxlgt.trx_id=ph.po_header_id);
811:
812: d_progress := 470;
813: FORALL i IN 1..p_po_release_id_tbl.COUNT
814: UPDATE po_releases_all pr
815: SET pr.tax_attribute_update_code = null
816: WHERE pr.po_release_id = p_po_release_id_tbl(i)
817: AND EXISTS (SELECT 'Y'
818: FROM zx_transaction_lines_gt zxlgt

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 2609: ,po_releases_all pr

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
2612: -- ELSE simply copy from existing release header (ie. in case of a
2613: -- shipment split or regular blanket/scheduled release create/update

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 3396: FROM po_releases_all pr

3392: ,pll.ship_to_organization_id --ship_to_party_id
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

Line 4256: FROM po_releases_all POR,

4252: SELECT 'Y' INTO l_Result
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

Line 5632: l_header_tauc PO_RELEASES_ALL.tax_attribute_update_code%TYPE;

5628: d_module_base CONSTANT VARCHAR2(100) := p_module_base;
5629: d_progress NUMBER := p_progress;
5630: l_ship_id_tbl PO_TBL_NUMBER;
5631: l_dist_id_tbl PO_TBL_NUMBER;
5632: l_header_tauc PO_RELEASES_ALL.tax_attribute_update_code%TYPE;
5633: l_ship_tauc_tbl PO_TBL_VARCHAR15;
5634: l_dist_tauc_tbl PO_TBL_VARCHAR15;
5635: BEGIN
5636:

Line 5641: FROM po_releases_all pr

5637: FOR i IN 1..p_po_release_id_tbl.COUNT LOOP
5638:
5639: SELECT pr.tax_attribute_update_code
5640: INTO l_header_tauc
5641: FROM po_releases_all pr
5642: WHERE pr.po_release_id = p_po_release_id_tbl(i);
5643:
5644: PO_LOG.stmt(d_module_base,d_progress,' po_release_id = '||p_po_release_id_tbl(i)||':'||l_header_tauc);
5645:

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 6124: FROM po_releases_all pr

6120: -- in Cancel mode
6121: d_progress := 220;
6122: SELECT pr.org_id
6123: INTO l_org_id
6124: FROM po_releases_all pr
6125: WHERE pr.po_release_id = p_document_id;
6126:
6127: d_progress := 230;
6128: IF (PO_LOG.d_stmt) THEN

Line 6314: -- PO_RELEASES_ALL.authorization_status

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
6318: -- PO_RELEASES_ALL

Line 6315: -- PO_RELEASES_ALL.approved_flag

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
6318: -- PO_RELEASES_ALL
6319: --Function:

Line 6318: -- PO_RELEASES_ALL

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:
6322: --IN:

Line 6369: FROM po_releases_all pr

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
6369: FROM po_releases_all pr
6370: WHERE pr.po_release_id = p_document_id;
6371: END IF;
6372:
6373: IF PO_LOG.d_stmt THEN

Line 6386: UPDATE po_releases_all pr

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
6386: UPDATE po_releases_all pr
6387: SET pr.authorization_status = PO_CONSTANTS_SV.IN_PROCESS,
6388: pr.approved_flag = 'N'
6389: WHERE pr.po_release_id = p_document_id;
6390: END IF;

Line 6401: UPDATE po_releases_all pr

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
6401: UPDATE po_releases_all pr
6402: SET pr.authorization_status = PO_CONSTANTS_SV.REQUIRES_REAPPROVAL,
6403: pr.approved_flag = 'R'
6404: WHERE pr.po_release_id = p_document_id;
6405: END IF;