APPS.PO_DOCUMENT_REVISION_GRP dependencies on DUAL

Line 175: FROM dual

171: -- p_keey_summary = 'Y'
172: BEGIN
173: SELECT 'N'
174: INTO l_keep_summary
175: FROM dual
176: WHERE exists (SELECT 'approved document'
177: FROM po_headers
178: WHERE po_header_id = p_doc_id
179: AND NVL(approved_flag, 'N') IN ('R', 'Y'));

Line 257: --IF Check Cancel Flag is N, then compare all invidual attributes except cancel flag

253: */
254: l_progress := '020';
255:
256: IF p_chk_cancel_flag = 'Y' THEN --
257: --IF Check Cancel Flag is N, then compare all invidual attributes except cancel flag
258:
259: l_need_to_check := PO_Archive_Check(p_doc_id);
260:
261: if (not l_need_to_check) then

Line 471: --IF Check Cancel Flag is N, then compare all invidual attributes except cancel flag

467:
468: end if;
469:
470: IF p_chk_cancel_flag = 'Y' THEN --
471: --IF Check Cancel Flag is N, then compare all invidual attributes except cancel flag
472:
473: l_need_to_check := Release_Archive_Check(p_doc_id);
474:
475: if (not l_need_to_check) then

Line 734: from sys.dual

730: Hence donot use the agent_id comparision for cancel flow*/
731:
732: Select 'Y'
733: INTO x_different
734: from sys.dual
735: where exists(
736: select null
737: FROM PO_HEADERS POH,
738: PO_HEADERS_ARCHIVE POHA

Line 906: from sys.dual

902: l_progress := '020';
903: if (p_doc_subtype = 'BLANKET') then
904: Select 'Y'
905: INTO x_different
906: from sys.dual
907: where exists(
908: select null
909: FROM PO_LINES POL,
910: PO_LINES_ARCHIVE POLA

Line 1045: from sys.dual

1041:
1042: else -- (p_doc_subtype = 'BLANKET') */
1043: Select 'Y'
1044: INTO x_different
1045: from sys.dual
1046: where exists(
1047: select null
1048: FROM PO_LINES POL,
1049: PO_LINES_ARCHIVE POLA

Line 1235: from sys.dual

1231:
1232: elsif(p_element = 'PORCH_SHIPMENTS') then --p_element='PORCH_HEADER'*/
1233: Select 'Y'
1234: INTO x_different
1235: from sys.dual
1236: where exists(
1237: select null
1238: FROM PO_LINE_LOCATIONS POLL,
1239: PO_LINE_LOCATIONS_ARCHIVE POLLA

Line 1326: from sys.dual

1322: ** since print changed orders report does not cover that case.
1323: */
1324: Select 'Y'
1325: INTO x_different
1326: from sys.dual
1327: where exists(
1328: select null
1329: FROM PO_LINE_LOCATIONS POLL,
1330: PO_LINE_LOCATIONS_ARCHIVE POLLA

Line 1449: from sys.dual

1445: base tables and remain the same in the archive tables when a shipment is
1446: finally closed, thereby causing a mis-match during comparision*/
1447: Select 'Y'
1448: INTO x_different
1449: from sys.dual
1450: where exists(
1451: select null
1452: FROM PO_DISTRIBUTIONS POD,
1453: PO_DISTRIBUTIONS_ARCHIVE PODA,

Line 1545: from sys.dual

1541: Hence donot use the agent_id comparision for cancel flow*/
1542:
1543: Select 'Y'
1544: INTO x_different
1545: from sys.dual
1546: where exists(
1547: select null
1548: FROM PO_RELEASES POR,
1549: PO_RELEASES_ARCHIVE PORA

Line 1589: from sys.dual

1585:
1586: elsif(p_element = 'PORCH_SHIPMENTS') then --p_element='PORCH_HEADER'*/
1587: Select 'Y'
1588: INTO x_different
1589: from sys.dual
1590: where exists(
1591: select null
1592: FROM PO_LINE_LOCATIONS POLL,
1593: PO_LINE_LOCATIONS_ARCHIVE POLLA

Line 1656: from sys.dual

1652:
1653: elsif (p_element = 'PORCH_DISTRIBUTIONS') then --p_element='PORCH_HEADER'*/
1654: Select 'Y'
1655: INTO x_different
1656: from sys.dual
1657: where exists(
1658: select null
1659: FROM PO_DISTRIBUTIONS POD,
1660: PO_DISTRIBUTIONS_ARCHIVE PODA