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 90: -- Out Parameters: x_return_status standard return status

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

Line 15832: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN

15828: ,oksB.TAX_CLASSIFICATION_CODE AS OksB_TAX_CLASSIFICATION_CODE
15829: ,oksB.EXEMPT_CERTIFICATE_NUMBER AS OksB_EXEMPT_CERTIFICATE_NUMBER
15830: ,oksB.EXEMPT_REASON_CODE AS OksB_EXEMPT_REASON_CODE
15831: ,oksB.COVERAGE_ID AS OksB_COVERAGE_ID
15832: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN
15833: --------------------------------End of OKS_K_LINES_B columns-------------------------
15834: --------------------------------Start of OKC_K_ITEMS columns-------------------------
15835: ,okcI.ID AS OkcI_OldOkcItemID
15836: ,To_number(rawtohex(sys_guid()), HexFormatStr) AS OkcI_NewOkcItemID

Line 16091: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN

16087: ,oksB.TAX_CLASSIFICATION_CODE AS OksB_TAX_CLASSIFICATION_CODE
16088: ,oksB.EXEMPT_CERTIFICATE_NUMBER AS OksB_EXEMPT_CERTIFICATE_NUMBER
16089: ,oksB.EXEMPT_REASON_CODE AS OksB_EXEMPT_REASON_CODE
16090: ,oksB.COVERAGE_ID AS OksB_COVERAGE_ID
16091: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN
16092: --------------------------------End of OKS_K_LINES_B columns-------------------------
16093: --------------------------------Start of OKC_K_ITEMS columns-------------------------
16094: ,okcI.ID AS OkcI_OldOkcItemID
16095: ,To_number(rawtohex(sys_guid()), HexFormatStr) AS OkcI_NewOkcItemID

Line 16351: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN

16347: ,oksB.TAX_CLASSIFICATION_CODE AS OksB_TAX_CLASSIFICATION_CODE
16348: ,oksB.EXEMPT_CERTIFICATE_NUMBER AS OksB_EXEMPT_CERTIFICATE_NUMBER
16349: ,oksB.EXEMPT_REASON_CODE AS OksB_EXEMPT_REASON_CODE
16350: ,oksB.COVERAGE_ID AS OksB_COVERAGE_ID
16351: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN
16352: --------------------------------End of OKS_K_LINES_B columns-------------------------
16353: --------------------------------Start of OKC_K_ITEMS columns-------------------------
16354: ,okcI.ID AS OkcI_OldOkcItemID
16355: ,To_number(rawtohex(sys_guid()), HexFormatStr) AS OkcI_NewOkcItemID

Line 16611: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN

16607: ,oksB.TAX_CLASSIFICATION_CODE AS OksB_TAX_CLASSIFICATION_CODE
16608: ,oksB.EXEMPT_CERTIFICATE_NUMBER AS OksB_EXEMPT_CERTIFICATE_NUMBER
16609: ,oksB.EXEMPT_REASON_CODE AS OksB_EXEMPT_REASON_CODE
16610: ,oksB.COVERAGE_ID AS OksB_COVERAGE_ID
16611: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN
16612: --------------------------------End of OKS_K_LINES_B columns-------------------------
16613: --------------------------------Start of OKC_K_ITEMS columns-------------------------
16614: ,okcI.ID AS OkcI_OldOkcItemID
16615: ,To_number(rawtohex(sys_guid()), HexFormatStr) AS OkcI_NewOkcItemID

Line 16863: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN

16859: ,oksB.TAX_CLASSIFICATION_CODE AS OksB_TAX_CLASSIFICATION_CODE
16860: ,oksB.EXEMPT_CERTIFICATE_NUMBER AS OksB_EXEMPT_CERTIFICATE_NUMBER
16861: ,oksB.EXEMPT_REASON_CODE AS OksB_EXEMPT_REASON_CODE
16862: ,oksB.COVERAGE_ID AS OksB_COVERAGE_ID
16863: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN
16864: --------------------------------End of OKS_K_LINES_B columns-------------------------
16865: --------------------------------Start of OKC_K_ITEMS columns-------------------------
16866: ,okcI.ID AS OkcI_OldOkcItemID
16867: ,To_number(rawtohex(sys_guid()), HexFormatStr)AS OkcI_NewOkcItemID

Line 17259: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN

17255: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE
17256: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER
17257: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE
17258: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID
17259: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN
17260: -----------------End of record members for OKS_K_LINES_B columns
17261: -----------------Start of record members for OKC_K_ITEMS columns
17262: ,OKCOKSLinesRecTab.OkcI_OldOkcItemID
17263: ,OKCOKSLinesRecTab.OkcI_NewOkcItemID

Line 17473: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN

17469: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE
17470: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER
17471: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE
17472: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID
17473: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN
17474: -----------------End of record members for OKS_K_LINES_B columns
17475: -----------------Start of record members for OKC_K_ITEMS columns
17476: ,OKCOKSLinesRecTab.OkcI_OldOkcItemID
17477: ,OKCOKSLinesRecTab.OkcI_NewOkcItemID

Line 17686: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN

17682: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE
17683: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER
17684: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE
17685: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID
17686: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN
17687: -----------------End of record members for OKS_K_LINES_B columns
17688: -----------------Start of record members for OKC_K_ITEMS columns
17689: ,OKCOKSLinesRecTab.OkcI_OldOkcItemID
17690: ,OKCOKSLinesRecTab.OkcI_NewOkcItemID

Line 17898: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN

17894: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE
17895: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER
17896: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE
17897: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID
17898: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN
17899: -----------------End of record members for OKS_K_LINES_B columns
17900: -----------------Start of record members for OKC_K_ITEMS columns
17901: ,OKCOKSLinesRecTab.OkcI_OldOkcItemID
17902: ,OKCOKSLinesRecTab.OkcI_NewOkcItemID

Line 18118: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN

18114: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE
18115: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER
18116: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE
18117: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID
18118: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN
18119: -----------------End of record members for OKS_K_LINES_B columns
18120: -----------------Start of record members for OKC_K_ITEMS columns
18121: ,OKCOKSLinesRecTab.OkcI_OldOkcItemID
18122: ,OKCOKSLinesRecTab.OkcI_NewOkcItemID

Line 18464: ,STANDARD_COV_YN

18460: ,TAX_CLASSIFICATION_CODE
18461: ,EXEMPT_CERTIFICATE_NUMBER
18462: ,EXEMPT_REASON_CODE
18463: ,COVERAGE_ID
18464: ,STANDARD_COV_YN
18465: ,CREATION_DATE
18466: ,CREATED_BY
18467: ,LAST_UPDATE_DATE
18468: ,LAST_UPDATED_BY

Line 18565: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN(i)

18561: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE(i)
18562: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER(i)
18563: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE(i)
18564: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID(i)
18565: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN(i)
18566: ,SYSDATE
18567: ,FND_GLOBAL.USER_ID
18568: ,SYSDATE
18569: ,FND_GLOBAL.USER_ID

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

19145: -- i) CLE_ID on OKC_K_LINES_B for sublines
19146: -- ii) PRICE_NEGOTIATED on OKC_K_LINES_B for toplines
19147: --
19148: -- Update of OKS_K_LINES_B
19149: -- iii) COVERAGE_ID on OKS_K_LINES_B for toplines with STANDARD_COV_YN = 'N'
19150: -- iv) TAX_AMOUNT on OKS_K_LINES_B for all toplines
19151:
19152: Begin
19153:

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

19182: WHERE a.DNZ_CHR_ID = P_To_Chr_ID
19183: AND a.CLE_ID in (select c.ID from OKC_K_LINES_B c
19184: where c.DNZ_CHR_ID = P_To_Chr_ID
19185: and c.LSE_ID in (1,19))
19186: AND a.STANDARD_COV_YN = 'N';
19187:
19188: UPDATE OKS_K_LINES_B a
19189: SET a.TAX_AMOUNT = (select sum(b.TAX_AMOUNT)
19190: FROM

Line 20359: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN

20355: ,oksB.TAX_CLASSIFICATION_CODE AS OksB_TAX_CLASSIFICATION_CODE
20356: ,oksB.EXEMPT_CERTIFICATE_NUMBER AS OksB_EXEMPT_CERTIFICATE_NUMBER
20357: ,oksB.EXEMPT_REASON_CODE AS OksB_EXEMPT_REASON_CODE
20358: ,oksB.COVERAGE_ID AS OksB_COVERAGE_ID
20359: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN
20360: --------------------------------End of OKS_K_LINES_B columns-------------------------
20361: --------------------------------Start of OKC_K_ITEMS columns-------------------------
20362: ,okcI.ID AS OkcI_OldOkcItemID
20363: ,To_number(rawtohex(sys_guid()), HexFormatStr) AS OkcI_NewOkcItemID

Line 20675: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN

20671: ,oksB.TAX_CLASSIFICATION_CODE AS OksB_TAX_CLASSIFICATION_CODE
20672: ,oksB.EXEMPT_CERTIFICATE_NUMBER AS OksB_EXEMPT_CERTIFICATE_NUMBER
20673: ,oksB.EXEMPT_REASON_CODE AS OksB_EXEMPT_REASON_CODE
20674: ,oksB.COVERAGE_ID AS OksB_COVERAGE_ID
20675: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN
20676: --------------------------------End of OKS_K_LINES_B columns-------------------------
20677: --------------------------------Start of OKC_K_ITEMS columns-------------------------
20678: ,okcI.ID AS OkcI_OldOkcItemID
20679: ,To_number(rawtohex(sys_guid()), HexFormatStr) AS OkcI_NewOkcItemID

Line 20992: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN

20988: ,oksB.TAX_CLASSIFICATION_CODE AS OksB_TAX_CLASSIFICATION_CODE
20989: ,oksB.EXEMPT_CERTIFICATE_NUMBER AS OksB_EXEMPT_CERTIFICATE_NUMBER
20990: ,oksB.EXEMPT_REASON_CODE AS OksB_EXEMPT_REASON_CODE
20991: ,oksB.COVERAGE_ID AS OksB_COVERAGE_ID
20992: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN
20993: --------------------------------End of OKS_K_LINES_B columns-------------------------
20994: --------------------------------Start of OKC_K_ITEMS columns-------------------------
20995: ,okcI.ID AS OkcI_OldOkcItemID
20996: ,To_number(rawtohex(sys_guid()), HexFormatStr) AS OkcI_NewOkcItemID

Line 21309: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN

21305: ,oksB.TAX_CLASSIFICATION_CODE AS OksB_TAX_CLASSIFICATION_CODE
21306: ,oksB.EXEMPT_CERTIFICATE_NUMBER AS OksB_EXEMPT_CERTIFICATE_NUMBER
21307: ,oksB.EXEMPT_REASON_CODE AS OksB_EXEMPT_REASON_CODE
21308: ,oksB.COVERAGE_ID AS OksB_COVERAGE_ID
21309: ,oksB.STANDARD_COV_YN AS OksB_STANDARD_COV_YN
21310: --------------------------------End of OKS_K_LINES_B columns-------------------------
21311: --------------------------------Start of OKC_K_ITEMS columns-------------------------
21312: ,okcI.ID AS OkcI_OldOkcItemID
21313: ,To_number(rawtohex(sys_guid()), HexFormatStr) AS OkcI_NewOkcItemID

Line 22910: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN

22906: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE
22907: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER
22908: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE
22909: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID
22910: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN
22911: -----------------End of record members for OKS_K_LINES_B columns
22912: -----------------Start of record members for OKC_K_ITEMS columns
22913: ,OKCOKSLinesRecTab.OkcI_OldOkcItemID
22914: ,OKCOKSLinesRecTab.OkcI_NewOkcItemID

Line 23122: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN

23118: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE
23119: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER
23120: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE
23121: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID
23122: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN
23123: -----------------End of record members for OKS_K_LINES_B columns
23124: -----------------Start of record members for OKC_K_ITEMS columns
23125: ,OKCOKSLinesRecTab.OkcI_OldOkcItemID
23126: ,OKCOKSLinesRecTab.OkcI_NewOkcItemID

Line 23334: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN

23330: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE
23331: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER
23332: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE
23333: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID
23334: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN
23335: -----------------End of record members for OKS_K_LINES_B columns
23336: -----------------Start of record members for OKC_K_ITEMS columns
23337: ,OKCOKSLinesRecTab.OkcI_OldOkcItemID
23338: ,OKCOKSLinesRecTab.OkcI_NewOkcItemID

Line 23546: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN

23542: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE
23543: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER
23544: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE
23545: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID
23546: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN
23547: -----------------End of record members for OKS_K_LINES_B columns
23548: -----------------Start of record members for OKC_K_ITEMS columns
23549: ,OKCOKSLinesRecTab.OkcI_OldOkcItemID
23550: ,OKCOKSLinesRecTab.OkcI_NewOkcItemID

Line 23880: ,STANDARD_COV_YN

23876: ,TAX_CLASSIFICATION_CODE
23877: ,EXEMPT_CERTIFICATE_NUMBER
23878: ,EXEMPT_REASON_CODE
23879: ,COVERAGE_ID
23880: ,STANDARD_COV_YN
23881: ,CREATION_DATE
23882: ,CREATED_BY
23883: ,LAST_UPDATE_DATE
23884: ,LAST_UPDATED_BY

Line 23987: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN(i)

23983: ,OKCOKSLinesRecTab.OksB_TAX_CLASSIFICATION_CODE(i)
23984: ,OKCOKSLinesRecTab.OksB_EXEMPT_CERTIFICATE_NUMBER(i)
23985: ,OKCOKSLinesRecTab.OksB_EXEMPT_REASON_CODE(i)
23986: ,OKCOKSLinesRecTab.OksB_COVERAGE_ID(i)
23987: ,OKCOKSLinesRecTab.OksB_STANDARD_COV_YN(i)
23988: ,SYSDATE
23989: ,FND_GLOBAL.USER_ID
23990: ,SYSDATE
23991: ,FND_GLOBAL.USER_ID

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

24421: -- Update of OKC_K_LINES_B
24422: -- ii) PRICE_NEGOTIATED on OKC_K_LINES_B for toplines
24423: --
24424: -- Update of OKS_K_LINES_B
24425: -- iii) COVERAGE_ID on OKS_K_LINES_B for toplines with STANDARD_COV_YN = 'N'
24426: -- iv) TAX_AMOUNT on OKS_K_LINES_B for all toplines
24427: -- v) PRICE_UOM on OKS_K_LINES_B as per Partial Period uptake rules, when copying to an existing Target Contract
24428: ----------------------------------------------------------------------------
24429: Begin

Line 24454: AND a.STANDARD_COV_YN = 'N'

24450: AND b.CLE_ID = a.CLE_ID
24451: AND b.DNZ_CHR_ID = P_To_Chr_ID
24452: AND b.LSE_ID in (2,20))
24453: WHERE a.DNZ_CHR_ID = P_To_Chr_ID
24454: AND a.STANDARD_COV_YN = 'N'
24455: AND a.CLE_ID in (SELECT b.ID from OKC_K_LINES_B_TEMP b where b.LINE_EXISTS_YN = 'N'
24456: and b.LSE_ID in (1,19));
24457:
24458: