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.OKS_COPY_CONTRACT_PVT dependencies on STANDARD

Line 92: -- Out Parameters: x_return_status standard return status

88: -- Procedure: chk_line_effectivity
89: -- Purpose: This procedure checks the effectivity dates of source
90: -- contract line and target contract line
91: -- In Parameters: p_new_cle_id Target contract line id
92: -- Out Parameters: x_return_status standard return status
93: -- x_flag yes no flag
94: -----------------------------------------------------------------------------
95:
96: PROCEDURE chk_line_effectivity

Line 15882: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN

15878: ,oksB.TAX_CLASSIFICATION_CODE AS OksB_TAX_CLASSIFICATION_CODE
15879: ,oksB.EXEMPT_CERTIFICATE_NUMBER AS OksB_EXEMPT_CERTIFICATE_NUMBER
15880: ,oksB.EXEMPT_REASON_CODE AS OksB_EXEMPT_REASON_CODE
15881: ,oksB.COVERAGE_ID AS OksB_COVERAGE_ID
15882: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN
15883: --------------------------------End of OKS_K_LINES_B columns-------------------------
15884: --------------------------------Start of OKC_K_ITEMS columns-------------------------
15885: ,okcI.ID AS OkcI_OldOkcItemID
15886: ,To_number(rawtohex(sys_guid()), HexFormatStr) AS OkcI_NewOkcItemID

Line 16146: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN

16142: ,oksB.TAX_CLASSIFICATION_CODE AS OksB_TAX_CLASSIFICATION_CODE
16143: ,oksB.EXEMPT_CERTIFICATE_NUMBER AS OksB_EXEMPT_CERTIFICATE_NUMBER
16144: ,oksB.EXEMPT_REASON_CODE AS OksB_EXEMPT_REASON_CODE
16145: ,oksB.COVERAGE_ID AS OksB_COVERAGE_ID
16146: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN
16147: --------------------------------End of OKS_K_LINES_B columns-------------------------
16148: --------------------------------Start of OKC_K_ITEMS columns-------------------------
16149: ,okcI.ID AS OkcI_OldOkcItemID
16150: ,To_number(rawtohex(sys_guid()), HexFormatStr) AS OkcI_NewOkcItemID

Line 16411: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN

16407: ,oksB.TAX_CLASSIFICATION_CODE AS OksB_TAX_CLASSIFICATION_CODE
16408: ,oksB.EXEMPT_CERTIFICATE_NUMBER AS OksB_EXEMPT_CERTIFICATE_NUMBER
16409: ,oksB.EXEMPT_REASON_CODE AS OksB_EXEMPT_REASON_CODE
16410: ,oksB.COVERAGE_ID AS OksB_COVERAGE_ID
16411: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN
16412: --------------------------------End of OKS_K_LINES_B columns-------------------------
16413: --------------------------------Start of OKC_K_ITEMS columns-------------------------
16414: ,okcI.ID AS OkcI_OldOkcItemID
16415: ,To_number(rawtohex(sys_guid()), HexFormatStr) AS OkcI_NewOkcItemID

Line 16676: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN

16672: ,oksB.TAX_CLASSIFICATION_CODE AS OksB_TAX_CLASSIFICATION_CODE
16673: ,oksB.EXEMPT_CERTIFICATE_NUMBER AS OksB_EXEMPT_CERTIFICATE_NUMBER
16674: ,oksB.EXEMPT_REASON_CODE AS OksB_EXEMPT_REASON_CODE
16675: ,oksB.COVERAGE_ID AS OksB_COVERAGE_ID
16676: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN
16677: --------------------------------End of OKS_K_LINES_B columns-------------------------
16678: --------------------------------Start of OKC_K_ITEMS columns-------------------------
16679: ,okcI.ID AS OkcI_OldOkcItemID
16680: ,To_number(rawtohex(sys_guid()), HexFormatStr) AS OkcI_NewOkcItemID

Line 16929: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN

16925: ,oksB.TAX_CLASSIFICATION_CODE AS OksB_TAX_CLASSIFICATION_CODE
16926: ,oksB.EXEMPT_CERTIFICATE_NUMBER AS OksB_EXEMPT_CERTIFICATE_NUMBER
16927: ,oksB.EXEMPT_REASON_CODE AS OksB_EXEMPT_REASON_CODE
16928: ,oksB.COVERAGE_ID AS OksB_COVERAGE_ID
16929: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN
16930: --------------------------------End of OKS_K_LINES_B columns-------------------------
16931: --------------------------------Start of OKC_K_ITEMS columns-------------------------
16932: ,okcI.ID AS OkcI_OldOkcItemID
16933: ,To_number(rawtohex(sys_guid()), HexFormatStr)AS OkcI_NewOkcItemID

Line 17343: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN

17339: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE
17340: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER
17341: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE
17342: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID
17343: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN
17344: -----------------End of record members for OKS_K_LINES_B columns
17345: -----------------Start of record members for OKC_K_ITEMS columns
17346: ,OKCOKSLinesRecTab.OkcI_OldOkcItemID
17347: ,OKCOKSLinesRecTab.OkcI_NewOkcItemID

Line 17558: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN

17554: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE
17555: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER
17556: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE
17557: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID
17558: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN
17559: -----------------End of record members for OKS_K_LINES_B columns
17560: -----------------Start of record members for OKC_K_ITEMS columns
17561: ,OKCOKSLinesRecTab.OkcI_OldOkcItemID
17562: ,OKCOKSLinesRecTab.OkcI_NewOkcItemID

Line 17772: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN

17768: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE
17769: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER
17770: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE
17771: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID
17772: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN
17773: -----------------End of record members for OKS_K_LINES_B columns
17774: -----------------Start of record members for OKC_K_ITEMS columns
17775: ,OKCOKSLinesRecTab.OkcI_OldOkcItemID
17776: ,OKCOKSLinesRecTab.OkcI_NewOkcItemID

Line 17985: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN

17981: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE
17982: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER
17983: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE
17984: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID
17985: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN
17986: -----------------End of record members for OKS_K_LINES_B columns
17987: -----------------Start of record members for OKC_K_ITEMS columns
17988: ,OKCOKSLinesRecTab.OkcI_OldOkcItemID
17989: ,OKCOKSLinesRecTab.OkcI_NewOkcItemID

Line 18206: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN

18202: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE
18203: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER
18204: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE
18205: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID
18206: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN
18207: -----------------End of record members for OKS_K_LINES_B columns
18208: -----------------Start of record members for OKC_K_ITEMS columns
18209: ,OKCOKSLinesRecTab.OkcI_OldOkcItemID
18210: ,OKCOKSLinesRecTab.OkcI_NewOkcItemID

Line 18553: ,STANDARD_COV_YN

18549: ,TAX_CLASSIFICATION_CODE
18550: ,EXEMPT_CERTIFICATE_NUMBER
18551: ,EXEMPT_REASON_CODE
18552: ,COVERAGE_ID
18553: ,STANDARD_COV_YN
18554: ,CREATION_DATE
18555: ,CREATED_BY
18556: ,LAST_UPDATE_DATE
18557: ,LAST_UPDATED_BY

Line 18655: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN(i)

18651: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE(i)
18652: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER(i)
18653: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE(i)
18654: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID(i)
18655: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN(i)
18656: ,SYSDATE
18657: ,FND_GLOBAL.USER_ID
18658: ,SYSDATE
18659: ,FND_GLOBAL.USER_ID

Line 19284: -- iii) COVERAGE_ID on OKS_K_LINES_B for toplines with STANDARD_COV_YN = 'N'

19280: -- i) CLE_ID on OKC_K_LINES_B for sublines
19281: -- ii) PRICE_NEGOTIATED on OKC_K_LINES_B for toplines
19282: --
19283: -- Update of OKS_K_LINES_B
19284: -- iii) COVERAGE_ID on OKS_K_LINES_B for toplines with STANDARD_COV_YN = 'N'
19285: -- iv) TAX_AMOUNT on OKS_K_LINES_B for all toplines
19286:
19287: Begin
19288:

Line 19321: AND a.STANDARD_COV_YN = 'N';

19317: WHERE a.DNZ_CHR_ID = P_To_Chr_ID
19318: AND a.CLE_ID in (select c.ID from OKC_K_LINES_B c
19319: where c.DNZ_CHR_ID = P_To_Chr_ID
19320: and c.LSE_ID in (1,19))
19321: AND a.STANDARD_COV_YN = 'N';
19322:
19323: UPDATE OKS_K_LINES_B a
19324: SET a.TAX_AMOUNT = (select sum(b.TAX_AMOUNT)
19325: FROM

Line 20506: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN

20502: ,oksB.TAX_CLASSIFICATION_CODE AS OksB_TAX_CLASSIFICATION_CODE
20503: ,oksB.EXEMPT_CERTIFICATE_NUMBER AS OksB_EXEMPT_CERTIFICATE_NUMBER
20504: ,oksB.EXEMPT_REASON_CODE AS OksB_EXEMPT_REASON_CODE
20505: ,oksB.COVERAGE_ID AS OksB_COVERAGE_ID
20506: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN
20507: --------------------------------End of OKS_K_LINES_B columns-------------------------
20508: --------------------------------Start of OKC_K_ITEMS columns-------------------------
20509: ,okcI.ID AS OkcI_OldOkcItemID
20510: ,To_number(rawtohex(sys_guid()), HexFormatStr) AS OkcI_NewOkcItemID

Line 20823: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN

20819: ,oksB.TAX_CLASSIFICATION_CODE AS OksB_TAX_CLASSIFICATION_CODE
20820: ,oksB.EXEMPT_CERTIFICATE_NUMBER AS OksB_EXEMPT_CERTIFICATE_NUMBER
20821: ,oksB.EXEMPT_REASON_CODE AS OksB_EXEMPT_REASON_CODE
20822: ,oksB.COVERAGE_ID AS OksB_COVERAGE_ID
20823: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN
20824: --------------------------------End of OKS_K_LINES_B columns-------------------------
20825: --------------------------------Start of OKC_K_ITEMS columns-------------------------
20826: ,okcI.ID AS OkcI_OldOkcItemID
20827: ,To_number(rawtohex(sys_guid()), HexFormatStr) AS OkcI_NewOkcItemID

Line 21141: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN

21137: ,oksB.TAX_CLASSIFICATION_CODE AS OksB_TAX_CLASSIFICATION_CODE
21138: ,oksB.EXEMPT_CERTIFICATE_NUMBER AS OksB_EXEMPT_CERTIFICATE_NUMBER
21139: ,oksB.EXEMPT_REASON_CODE AS OksB_EXEMPT_REASON_CODE
21140: ,oksB.COVERAGE_ID AS OksB_COVERAGE_ID
21141: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN
21142: --------------------------------End of OKS_K_LINES_B columns-------------------------
21143: --------------------------------Start of OKC_K_ITEMS columns-------------------------
21144: ,okcI.ID AS OkcI_OldOkcItemID
21145: ,To_number(rawtohex(sys_guid()), HexFormatStr) AS OkcI_NewOkcItemID

Line 21459: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN

21455: ,oksB.TAX_CLASSIFICATION_CODE AS OksB_TAX_CLASSIFICATION_CODE
21456: ,oksB.EXEMPT_CERTIFICATE_NUMBER AS OksB_EXEMPT_CERTIFICATE_NUMBER
21457: ,oksB.EXEMPT_REASON_CODE AS OksB_EXEMPT_REASON_CODE
21458: ,oksB.COVERAGE_ID AS OksB_COVERAGE_ID
21459: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN
21460: --------------------------------End of OKS_K_LINES_B columns-------------------------
21461: --------------------------------Start of OKC_K_ITEMS columns-------------------------
21462: ,okcI.ID AS OkcI_OldOkcItemID
21463: ,To_number(rawtohex(sys_guid()), HexFormatStr) AS OkcI_NewOkcItemID

Line 23061: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN

23057: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE
23058: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER
23059: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE
23060: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID
23061: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN
23062: -----------------End of record members for OKS_K_LINES_B columns
23063: -----------------Start of record members for OKC_K_ITEMS columns
23064: ,OKCOKSLinesRecTab.OkcI_OldOkcItemID
23065: ,OKCOKSLinesRecTab.OkcI_NewOkcItemID

Line 23274: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN

23270: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE
23271: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER
23272: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE
23273: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID
23274: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN
23275: -----------------End of record members for OKS_K_LINES_B columns
23276: -----------------Start of record members for OKC_K_ITEMS columns
23277: ,OKCOKSLinesRecTab.OkcI_OldOkcItemID
23278: ,OKCOKSLinesRecTab.OkcI_NewOkcItemID

Line 23487: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN

23483: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE
23484: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER
23485: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE
23486: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID
23487: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN
23488: -----------------End of record members for OKS_K_LINES_B columns
23489: -----------------Start of record members for OKC_K_ITEMS columns
23490: ,OKCOKSLinesRecTab.OkcI_OldOkcItemID
23491: ,OKCOKSLinesRecTab.OkcI_NewOkcItemID

Line 23700: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN

23696: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE
23697: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER
23698: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE
23699: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID
23700: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN
23701: -----------------End of record members for OKS_K_LINES_B columns
23702: -----------------Start of record members for OKC_K_ITEMS columns
23703: ,OKCOKSLinesRecTab.OkcI_OldOkcItemID
23704: ,OKCOKSLinesRecTab.OkcI_NewOkcItemID

Line 24035: ,STANDARD_COV_YN

24031: ,TAX_CLASSIFICATION_CODE
24032: ,EXEMPT_CERTIFICATE_NUMBER
24033: ,EXEMPT_REASON_CODE
24034: ,COVERAGE_ID
24035: ,STANDARD_COV_YN
24036: ,CREATION_DATE
24037: ,CREATED_BY
24038: ,LAST_UPDATE_DATE
24039: ,LAST_UPDATED_BY

Line 24143: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN(i)

24139: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE(i)
24140: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER(i)
24141: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE(i)
24142: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID(i)
24143: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN(i)
24144: ,SYSDATE
24145: ,FND_GLOBAL.USER_ID
24146: ,SYSDATE
24147: ,FND_GLOBAL.USER_ID

Line 24620: -- iii) COVERAGE_ID on OKS_K_LINES_B for toplines with STANDARD_COV_YN = 'N'

24616: -- Update of OKC_K_LINES_B
24617: -- ii) PRICE_NEGOTIATED on OKC_K_LINES_B for toplines
24618: --
24619: -- Update of OKS_K_LINES_B
24620: -- iii) COVERAGE_ID on OKS_K_LINES_B for toplines with STANDARD_COV_YN = 'N'
24621: -- iv) TAX_AMOUNT on OKS_K_LINES_B for all toplines
24622: -- v) PRICE_UOM on OKS_K_LINES_B as per Partial Period uptake rules, when copying to an existing Target Contract
24623: ----------------------------------------------------------------------------
24624: Begin

Line 24649: AND a.STANDARD_COV_YN = 'N'

24645: AND b.CLE_ID = a.CLE_ID
24646: AND b.DNZ_CHR_ID = P_To_Chr_ID
24647: AND b.LSE_ID in (2,20))
24648: WHERE a.DNZ_CHR_ID = P_To_Chr_ID
24649: AND a.STANDARD_COV_YN = 'N'
24650: AND a.CLE_ID in (SELECT b.ID from OKC_K_LINES_B_TEMP b where b.LINE_EXISTS_YN = 'N'
24651: and b.LSE_ID in (1,19));
24652:
24653: