[Home] [Help]
9: v_tmp VARCHAR2(1) := 'N';
10:
11: BEGIN
12:
13: /** The below code lists all standard sqls to identify whether commitments
14: have changed or not since the last summarization run. Customers can
15: uncomment the below code to check whether commitments have changed or not.
16: One benefit of uncommenting the below code is that customers can add hints
17: (which are suitable for the data distribution that exists in their system)
16: One benefit of uncommenting the below code is that customers can add hints
17: (which are suitable for the data distribution that exists in their system)
18: to the below sqls which will make the Summarization process much faster.
19: The default code which is written below inside comments is simlar to
20: what has been coded inside the standard Oracle Projects function
21: PA_CHECK_COMMITMENTS.COMMITMENTS_CHANGED. If customer uncomments the below
22: code then the same code in PA_CHECK_COMMITMENTS.COMMITMENTS_CHANGED
23: will not get executed again ensuring that performance is not hit.
24:
28: This function should be able to determine whether the user defined
29: commitments have changed from the last summarization run or not.
30: If the commitments have changed, then the function should return
31: Y, else it should return S indicating STOP. If customers return 'N'
32: from this procedure then the code in standard Oracle Projects function
33: PA_CHECK_COMMITMENTS.COMMITMENTS_CHANGED will also get executed.
34: So for users who are going to uncomment the below code it is not
35: recommended to return 'N' from this function.
36:
36:
37: If Y is returned, then the summarization process would rebuild the
38: commitments, if S is returned then it will not rebuild the
39: commitments and if N is returned then it may or may not rebuild the commitments
40: depending on the output of the sqls coded inside standard Oracle Projects function
41: PA_CHECK_COMMITMENTS.COMMITMENTS_CHANGED. **/
42:
43: v_tmp := 'N';
44:
192: BETWEEN NVL(REQ.EFFECTIVE_START_DATE,TRUNC(SYSDATE))
193: AND NVL(REQ.EFFECTIVE_END_DATE,TRUNC(SYSDATE))
194: AND NVL(POH.CLOSED_CODE,'OPEN') NOT IN ('CLOSED','FINALLY CLOSED')
195: AND NVL(PLL.CLOSED_CODE,'OPEN') NOT IN ('CLOSED','FINALLY CLOSED')
196: AND PLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
197: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','BLANKET','PLANNED')
198: AND POH.TYPE_LOOKUP_CODE = PDT.DOCUMENT_SUBTYPE
199: AND PDT.DOCUMENT_TYPE_CODE IN ('PO','PA')
200: AND PLL.PO_RELEASE_ID = POR.PO_RELEASE_ID(+)
193: AND NVL(REQ.EFFECTIVE_END_DATE,TRUNC(SYSDATE))
194: AND NVL(POH.CLOSED_CODE,'OPEN') NOT IN ('CLOSED','FINALLY CLOSED')
195: AND NVL(PLL.CLOSED_CODE,'OPEN') NOT IN ('CLOSED','FINALLY CLOSED')
196: AND PLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
197: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','BLANKET','PLANNED')
198: AND POH.TYPE_LOOKUP_CODE = PDT.DOCUMENT_SUBTYPE
199: AND PDT.DOCUMENT_TYPE_CODE IN ('PO','PA')
200: AND PLL.PO_RELEASE_ID = POR.PO_RELEASE_ID(+)
201: AND NVL(POH.CANCEL_FLAG,'N') = 'N'
278: BETWEEN NVL(REQ.EFFECTIVE_START_DATE,TRUNC(SYSDATE))
279: AND NVL(REQ.EFFECTIVE_END_DATE,TRUNC(SYSDATE))
280: AND NVL(POH.CLOSED_CODE,'OPEN') NOT IN ('CLOSED','FINALLY CLOSED')
281: AND NVL(PLL.CLOSED_CODE,'OPEN') NOT IN ('CLOSED','FINALLY CLOSED')
282: AND PLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
283: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','BLANKET','PLANNED')
284: AND POH.TYPE_LOOKUP_CODE = PDT.DOCUMENT_SUBTYPE
285: AND PDT.DOCUMENT_TYPE_CODE IN ('PO','PA')
286: AND PLL.PO_RELEASE_ID = POR.PO_RELEASE_ID(+)
279: AND NVL(REQ.EFFECTIVE_END_DATE,TRUNC(SYSDATE))
280: AND NVL(POH.CLOSED_CODE,'OPEN') NOT IN ('CLOSED','FINALLY CLOSED')
281: AND NVL(PLL.CLOSED_CODE,'OPEN') NOT IN ('CLOSED','FINALLY CLOSED')
282: AND PLL.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
283: AND POH.TYPE_LOOKUP_CODE IN ('STANDARD','BLANKET','PLANNED')
284: AND POH.TYPE_LOOKUP_CODE = PDT.DOCUMENT_SUBTYPE
285: AND PDT.DOCUMENT_TYPE_CODE IN ('PO','PA')
286: AND PLL.PO_RELEASE_ID = POR.PO_RELEASE_ID(+)
287: AND NVL(POH.CANCEL_FLAG,'N') = 'N'