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 OKC_K_ITEMS

Line 1244: FROM okc_k_items_v

1240: WHERE id = p_id;
1241:
1242: CURSOR c_cim(p_cle_id IN NUMBER) IS
1243: SELECT id
1244: FROM okc_k_items_v
1245: WHERE cle_id = p_cle_id
1246: AND priced_item_yn = 'Y';
1247:
1248: BEGIN

Line 1326: FROM okc_k_items

1322: l_actual_coverage_id NUMBER;
1323:
1324: CURSOR c_item IS
1325: SELECT object1_id1
1326: FROM okc_k_items
1327: WHERE cle_id = p_old_cle_id;
1328:
1329: Cursor l_ctr_csr (p_id Number) Is
1330: Select Counter_Group_id

Line 2121: FROM OKC_K_ITEMS_V

2117: UOM_CODE,
2118: EXCEPTION_YN,
2119: NUMBER_OF_ITEMS,
2120: PRICED_ITEM_YN
2121: FROM OKC_K_ITEMS_V
2122: WHERE ID = p_cim_id;
2123: BEGIN
2124: OPEN c_cimv_rec;
2125: FETCH c_cimv_rec

Line 15612: OKC_K_ITEMS

15608: /*if p_include_cancelled_lines 'Y' AND p_include_terminated_lines = 'Y' */
15609: /* Cursor to get rows to be copied from:
15610: OKC_K_LINES_B
15611: OKS_K_LINES_B
15612: OKC_K_ITEMS
15613: for a specified Source Contract. This cursor is used when P_Renew_Ref_YN = 'N' */
15614: CURSOR GetOKCOKSLinesB_Copy(P_From_Chr_ID IN NUMBER
15615: ,P_To_Chr_ID IN NUMBER) IS
15616: SELECT /*+ leading(okcB) use_nl(oksB,okcI) */

Line 15834: --------------------------------Start of OKC_K_ITEMS columns-------------------------

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
15837: ,okcI.CLE_ID AS OkcI_CLE_ID
15838: ,P_To_Chr_ID AS OkcI_NewDnzChrID

Line 15858: ,OKC_K_ITEMS okcI

15854: ,okcI.REQUEST_ID AS OkcI_REQUEST_ID
15855: FROM
15856: OKC_K_LINES_B okcB
15857: ,OKS_K_LINES_B oksB
15858: ,OKC_K_ITEMS okcI
15859: Where okcB.DNZ_CHR_ID = P_From_Chr_ID
15860: AND okcB.ID = oksB.CLE_ID(+)
15861: AND okcB.ID = okcI.CLE_ID(+)
15862: AND oksB.DNZ_CHR_ID(+) = okcB.DNZ_CHR_ID

Line 15871: OKC_K_ITEMS

15867: /*if p_include_cancelled_lines ='Y' and p_include_terminated_lines = 'N'*/
15868: /* Cursor to get rows to be copied from:
15869: OKC_K_LINES_B
15870: OKS_K_LINES_B
15871: OKC_K_ITEMS
15872: for a specified Source Contract. This cursor is used when P_Renew_Ref_YN = 'N' */
15873: CURSOR GetOKCOKSLinesB_Copy_CANCEL(P_From_Chr_ID IN NUMBER
15874: ,P_To_Chr_ID IN NUMBER) IS
15875: SELECT /*+ leading(okcB) use_nl(oksB,okcI) */

Line 16093: --------------------------------Start of OKC_K_ITEMS columns-------------------------

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
16096: ,okcI.CLE_ID AS OkcI_CLE_ID
16097: ,P_To_Chr_ID AS OkcI_NewDnzChrID

Line 16117: ,OKC_K_ITEMS okcI

16113: ,okcI.REQUEST_ID AS OkcI_REQUEST_ID
16114: FROM
16115: OKC_K_LINES_B okcB
16116: ,OKS_K_LINES_B oksB
16117: ,OKC_K_ITEMS okcI
16118: Where okcB.DNZ_CHR_ID = P_From_Chr_ID
16119: AND okcB.ID = oksB.CLE_ID(+)
16120: AND okcB.ID = okcI.CLE_ID(+)
16121: AND oksB.DNZ_CHR_ID(+) = okcB.DNZ_CHR_ID

Line 16131: OKC_K_ITEMS

16127: /*if p_include_cancelled_lines = 'N' and p_include_terminated_lines = 'Y' */
16128: /* Cursor to get rows to be copied from:
16129: OKC_K_LINES_B
16130: OKS_K_LINES_B
16131: OKC_K_ITEMS
16132: for a specified Source Contract. This cursor is used when P_Renew_Ref_YN = 'N' */
16133: CURSOR GetOKCOKSLinesB_Copy_TERMN(P_From_Chr_ID IN NUMBER
16134: ,P_To_Chr_ID IN NUMBER) IS
16135: SELECT /*+ leading(okcB) use_nl(oksB,okcI) */

Line 16353: --------------------------------Start of OKC_K_ITEMS columns-------------------------

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
16356: ,okcI.CLE_ID AS OkcI_CLE_ID
16357: ,P_To_Chr_ID AS OkcI_NewDnzChrID

Line 16377: ,OKC_K_ITEMS okcI

16373: ,okcI.REQUEST_ID AS OkcI_REQUEST_ID
16374: FROM
16375: OKC_K_LINES_B okcB
16376: ,OKS_K_LINES_B oksB
16377: ,OKC_K_ITEMS okcI
16378: Where okcB.DNZ_CHR_ID = P_From_Chr_ID
16379: AND okcB.ID = oksB.CLE_ID(+)
16380: AND okcB.ID = okcI.CLE_ID(+)
16381: AND oksB.DNZ_CHR_ID(+) = okcB.DNZ_CHR_ID

Line 16391: OKC_K_ITEMS

16387: /*if p_include_cancelled_lines = 'N' and p_include_terminated_lines = 'N' */
16388: /* Cursor to get rows to be copied from:
16389: OKC_K_LINES_B
16390: OKS_K_LINES_B
16391: OKC_K_ITEMS
16392: for a specified Source Contract. This cursor is used when P_Renew_Ref_YN = 'N' */
16393: CURSOR GetOKCOKSLinesB_Copy_exclude(P_From_Chr_ID IN NUMBER
16394: ,P_To_Chr_ID IN NUMBER) IS
16395: SELECT /*+ leading(okcB) use_nl(oksB,okcI) */

Line 16613: --------------------------------Start of OKC_K_ITEMS columns-------------------------

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
16616: ,okcI.CLE_ID AS OkcI_CLE_ID
16617: ,P_To_Chr_ID AS OkcI_NewDnzChrID

Line 16637: ,OKC_K_ITEMS okcI

16633: ,okcI.REQUEST_ID AS OkcI_REQUEST_ID
16634: FROM
16635: OKC_K_LINES_B okcB
16636: ,OKS_K_LINES_B oksB
16637: ,OKC_K_ITEMS okcI
16638: Where okcB.DNZ_CHR_ID = P_From_Chr_ID
16639: AND okcB.ID = oksB.CLE_ID(+)
16640: AND okcB.ID = okcI.CLE_ID(+)
16641: AND oksB.DNZ_CHR_ID(+) = okcB.DNZ_CHR_ID

Line 16652: OKC_K_ITEMS

16648:
16649: /* Cursor to get rows to be copied from:
16650: OKC_K_LINES_B
16651: OKS_K_LINES_B
16652: OKC_K_ITEMS
16653: for a specified Source Contracti. This cursor is used when P_Renew_Ref_YN = 'Y'. It filters out
16654: the lines that have been renewed,cancelled or terminated or have been marked as 'DNR' (Do not renew) */
16655:
16656: CURSOR GetOKCOKSLinesB_Renew(P_From_Chr_ID IN NUMBER

Line 16865: --------------------------------Start of OKC_K_ITEMS columns-------------------------

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
16868: ,okcI.CLE_ID AS OkcI_CLE_ID
16869: ,P_To_Chr_ID AS OkcI_NewDnzChrID

Line 16889: ,OKC_K_ITEMS okcI

16885: ,okcI.REQUEST_ID AS OkcI_REQUEST_ID
16886: FROM
16887: OKC_K_LINES_B okcB
16888: ,OKS_K_LINES_B oksB
16889: ,OKC_K_ITEMS okcI
16890: WHERE
16891: okcB.ID = oksB.CLE_ID(+)
16892: AND okcB.ID = okcI.CLE_ID(+)
16893: AND okcB.DNZ_CHR_ID = P_From_Chr_ID

Line 17261: -----------------Start of record members for OKC_K_ITEMS columns

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
17264: ,OKCOKSLinesRecTab.OkcI_CLE_ID
17265: ,OKCOKSLinesRecTab.OkcI_NewDnzChrID

Line 17475: -----------------Start of record members for OKC_K_ITEMS columns

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
17478: ,OKCOKSLinesRecTab.OkcI_CLE_ID
17479: ,OKCOKSLinesRecTab.OkcI_NewDnzChrID

Line 17688: -----------------Start of record members for OKC_K_ITEMS columns

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
17691: ,OKCOKSLinesRecTab.OkcI_CLE_ID
17692: ,OKCOKSLinesRecTab.OkcI_NewDnzChrID

Line 17900: -----------------Start of record members for OKC_K_ITEMS columns

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
17903: ,OKCOKSLinesRecTab.OkcI_CLE_ID
17904: ,OKCOKSLinesRecTab.OkcI_NewDnzChrID

Line 18120: -----------------Start of record members for OKC_K_ITEMS columns

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
18123: ,OKCOKSLinesRecTab.OkcI_CLE_ID
18124: ,OKCOKSLinesRecTab.OkcI_NewDnzChrID

Line 18598: --Bulk Insert into OKC_K_ITEMS

18594: RAISE G_EXCEPTION_HALT_VALIDATION;
18595:
18596: End;
18597:
18598: --Bulk Insert into OKC_K_ITEMS
18599: Begin
18600:
18601:
18602: FORALL i IN OKCOKSLinesRecTab.OkcB_NewOKCLineID.FIRST .. OKCOKSLinesRecTab.OkcB_NewOKCLineID.LAST

Line 18603: INSERT INTO OKC_K_ITEMS(

18599: Begin
18600:
18601:
18602: FORALL i IN OKCOKSLinesRecTab.OkcB_NewOKCLineID.FIRST .. OKCOKSLinesRecTab.OkcB_NewOKCLineID.LAST
18603: INSERT INTO OKC_K_ITEMS(
18604: ID
18605: ,CLE_ID
18606: ,DNZ_CHR_ID
18607: ,CHR_ID

Line 18661: ,'AFTER INSERT into OKC_K_ITEMS '

18657:
18658: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
18659: FND_LOG.string(FND_LOG.level_statement
18660: ,l_module_name
18661: ,'AFTER INSERT into OKC_K_ITEMS '
18662: );
18663: END IF;
18664:
18665: EXCEPTION

Line 18671: ,'EXCEPTION during insert into OKC_K_ITEMS '||SQLERRM

18667: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
18668: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) then
18669: FND_LOG.string(FND_LOG.level_unexpected
18670: ,l_module_name
18671: ,'EXCEPTION during insert into OKC_K_ITEMS '||SQLERRM
18672: );
18673: END IF;
18674:
18675: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 19119: END LOOP; --End of Bulk fetch and insert into OKC_K_LINES_B,OKS_K_LINES_B,OKC_K_ITEMS

19115: ELSIF (P_Renew_Ref_YN = 'Y') THEN
19116: EXIT WHEN GetOKCOKSLinesB_Renew%NOTFOUND;
19117: END IF;
19118:
19119: END LOOP; --End of Bulk fetch and insert into OKC_K_LINES_B,OKS_K_LINES_B,OKC_K_ITEMS
19120:
19121: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19122: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19123: FND_LOG.string(FND_LOG.level_statement

Line 19125: ,'After BULK FETCH and BULK INSERT into OKC_K_LINES_B,OKS_K_LINES_B,OKC_K_ITEMS'

19121: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19122: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19123: FND_LOG.string(FND_LOG.level_statement
19124: ,l_module_name
19125: ,'After BULK FETCH and BULK INSERT into OKC_K_LINES_B,OKS_K_LINES_B,OKC_K_ITEMS'
19126: );
19127: END IF;
19128: END IF;
19129:

Line 20081: -- OKC_K_ITEMS

20077: ----------------------------------------------------------------------------
20078: -- Cursor to get rows to be copied from:
20079: -- OKC_K_LINES_B_TEMP
20080: -- OKS_K_LINES_B
20081: -- OKC_K_ITEMS
20082: -- for a specified Source Contract and for the lines chosen by the user for copy.
20083:
20084: CURSOR GetOKCOKSLinesB_Temp(P_From_Chr_ID IN NUMBER
20085: ,P_To_Chr_ID IN NUMBER) IS

Line 20361: --------------------------------Start of OKC_K_ITEMS columns-------------------------

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
20364: ,okcI.CLE_ID AS OkcI_CLE_ID
20365: ,P_To_Chr_ID AS OkcI_NewDnzChrID

Line 20385: ,OKC_K_ITEMS okcI

20381: ,okcI.REQUEST_ID AS OkcI_REQUEST_ID
20382: FROM
20383: OKC_K_LINES_B_TEMP okcBT
20384: ,OKS_K_LINES_B oksB
20385: ,OKC_K_ITEMS okcI
20386: Where okcBT.DNZ_CHR_ID = P_To_Chr_ID
20387: AND okcBT.ORIG_SYSTEM_ID1 = oksB.CLE_ID(+)
20388: AND okcBT.ORIG_SYSTEM_ID1 = okcI.CLE_ID(+)
20389: AND oksB.DNZ_CHR_ID(+) = P_From_Chr_ID

Line 20397: -- OKC_K_ITEMS

20393: ----------------------------------------------------------------------------
20394: -- Cursor to get rows to be copied from:
20395: -- OKC_K_LINES_B_TEMP
20396: -- OKS_K_LINES_B
20397: -- OKC_K_ITEMS
20398: -- for a specified Source Contract and for the lines chosen by the user for copy.
20399:
20400: CURSOR GetOKCOKSLinesB_Temp_CANCEL(P_From_Chr_ID IN NUMBER
20401: ,P_To_Chr_ID IN NUMBER) IS

Line 20677: --------------------------------Start of OKC_K_ITEMS columns-------------------------

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
20680: ,okcI.CLE_ID AS OkcI_CLE_ID
20681: ,P_To_Chr_ID AS OkcI_NewDnzChrID

Line 20701: ,OKC_K_ITEMS okcI

20697: ,okcI.REQUEST_ID AS OkcI_REQUEST_ID
20698: FROM
20699: OKC_K_LINES_B_TEMP okcBT
20700: ,OKS_K_LINES_B oksB
20701: ,OKC_K_ITEMS okcI
20702: Where okcBT.DNZ_CHR_ID = P_To_Chr_ID
20703: AND okcBT.ORIG_SYSTEM_ID1 = oksB.CLE_ID(+)
20704: AND okcBT.ORIG_SYSTEM_ID1 = okcI.CLE_ID(+)
20705: AND oksB.DNZ_CHR_ID(+) = P_From_Chr_ID

Line 20714: -- OKC_K_ITEMS

20710: ----------------------------------------------------------------------------
20711: -- Cursor to get rows to be copied from:
20712: -- OKC_K_LINES_B_TEMP
20713: -- OKS_K_LINES_B
20714: -- OKC_K_ITEMS
20715: -- for a specified Source Contract and for the lines chosen by the user for copy.
20716:
20717: CURSOR GetOKCOKSLinesB_Temp_TERMN(P_From_Chr_ID IN NUMBER
20718: ,P_To_Chr_ID IN NUMBER) IS

Line 20994: --------------------------------Start of OKC_K_ITEMS columns-------------------------

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
20997: ,okcI.CLE_ID AS OkcI_CLE_ID
20998: ,P_To_Chr_ID AS OkcI_NewDnzChrID

Line 21018: ,OKC_K_ITEMS okcI

21014: ,okcI.REQUEST_ID AS OkcI_REQUEST_ID
21015: FROM
21016: OKC_K_LINES_B_TEMP okcBT
21017: ,OKS_K_LINES_B oksB
21018: ,OKC_K_ITEMS okcI
21019: Where okcBT.DNZ_CHR_ID = P_To_Chr_ID
21020: AND okcBT.ORIG_SYSTEM_ID1 = oksB.CLE_ID(+)
21021: AND okcBT.ORIG_SYSTEM_ID1 = okcI.CLE_ID(+)
21022: AND oksB.DNZ_CHR_ID(+) = P_From_Chr_ID

Line 21031: -- OKC_K_ITEMS

21027: ----------------------------------------------------------------------------
21028: -- Cursor to get rows to be copied from:
21029: -- OKC_K_LINES_B_TEMP
21030: -- OKS_K_LINES_B
21031: -- OKC_K_ITEMS
21032: -- for a specified Source Contract and for the lines chosen by the user for copy.
21033:
21034: CURSOR GetOKCOKSLinesB_Temp_EXCLUDE(P_From_Chr_ID IN NUMBER
21035: ,P_To_Chr_ID IN NUMBER) IS

Line 21311: --------------------------------Start of OKC_K_ITEMS columns-------------------------

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
21314: ,okcI.CLE_ID AS OkcI_CLE_ID
21315: ,P_To_Chr_ID AS OkcI_NewDnzChrID

Line 21335: ,OKC_K_ITEMS okcI

21331: ,okcI.REQUEST_ID AS OkcI_REQUEST_ID
21332: FROM
21333: OKC_K_LINES_B_TEMP okcBT
21334: ,OKS_K_LINES_B oksB
21335: ,OKC_K_ITEMS okcI
21336: Where okcBT.DNZ_CHR_ID = P_To_Chr_ID
21337: AND okcBT.ORIG_SYSTEM_ID1 = oksB.CLE_ID(+)
21338: AND okcBT.ORIG_SYSTEM_ID1 = okcI.CLE_ID(+)
21339: AND oksB.DNZ_CHR_ID(+) = P_From_Chr_ID

Line 22688: --OKS_K_LINES_B and OKC_K_ITEMS

22684:
22685:
22686: -----------------------------------------------------------------------------
22687: --Process rows in OKC_K_LINES_B_TEMP and do bulk inserts into OKC_K_LINES_B
22688: --OKS_K_LINES_B and OKC_K_ITEMS
22689: ----------------------------------------------------------------------------
22690: IF (P_Lines_Tbl.COUNT > 0) then ---Start of Check of P_Lines_Tbl.COUNT > 0 *****************
22691: ---for bulk insert into OKC_K_LINES_B, *****************
22692: ---OKS_K_LINES_B,OKC_K_ITEMS *****************

Line 22692: ---OKS_K_LINES_B,OKC_K_ITEMS *****************

22688: --OKS_K_LINES_B and OKC_K_ITEMS
22689: ----------------------------------------------------------------------------
22690: IF (P_Lines_Tbl.COUNT > 0) then ---Start of Check of P_Lines_Tbl.COUNT > 0 *****************
22691: ---for bulk insert into OKC_K_LINES_B, *****************
22692: ---OKS_K_LINES_B,OKC_K_ITEMS *****************
22693:
22694: If (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
22695: FND_LOG.string(FND_LOG.level_statement
22696: ,l_module_name

Line 22912: -----------------Start of record members for OKC_K_ITEMS columns

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
22915: ,OKCOKSLinesRecTab.OkcI_CLE_ID
22916: ,OKCOKSLinesRecTab.OkcI_NewDnzChrID

Line 23124: -----------------Start of record members for OKC_K_ITEMS columns

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
23127: ,OKCOKSLinesRecTab.OkcI_CLE_ID
23128: ,OKCOKSLinesRecTab.OkcI_NewDnzChrID

Line 23336: -----------------Start of record members for OKC_K_ITEMS columns

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
23339: ,OKCOKSLinesRecTab.OkcI_CLE_ID
23340: ,OKCOKSLinesRecTab.OkcI_NewDnzChrID

Line 23548: -----------------Start of record members for OKC_K_ITEMS columns

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
23551: ,OKCOKSLinesRecTab.OkcI_CLE_ID
23552: ,OKCOKSLinesRecTab.OkcI_NewDnzChrID

Line 24005: ---Bulk insert into OKC_K_ITEMS---

24001: ,'After BULK INSERT into OKS_K_LINES_B'
24002: );
24003: End If;
24004:
24005: ---Bulk insert into OKC_K_ITEMS---
24006:
24007: FORALL i IN OKCOKSLinesRecTab.OkcB_NewOKCLineID.FIRST .. OKCOKSLinesRecTab.OkcB_NewOKCLineID.LAST
24008: INSERT INTO OKC_K_ITEMS(
24009: ID

Line 24008: INSERT INTO OKC_K_ITEMS(

24004:
24005: ---Bulk insert into OKC_K_ITEMS---
24006:
24007: FORALL i IN OKCOKSLinesRecTab.OkcB_NewOKCLineID.FIRST .. OKCOKSLinesRecTab.OkcB_NewOKCLineID.LAST
24008: INSERT INTO OKC_K_ITEMS(
24009: ID
24010: ,CLE_ID
24011: ,DNZ_CHR_ID
24012: ,CHR_ID

Line 24066: ,'After BULK INSERT into OKC_K_ITEMS'

24062:
24063: If (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
24064: FND_LOG.string(FND_LOG.level_statement
24065: ,l_module_name
24066: ,'After BULK INSERT into OKC_K_ITEMS'
24067: );
24068: End If;
24069:
24070:

Line 24417: ---OKS_K_LINES_B,OKC_K_ITEMS *****************

24413: --------End of BULK FETCH FROM OKC_K_LINES_B_TEMP---------------
24414:
24415: END IF; ---End of Check of P_Lines_Tbl.COUNT > 0 *****************
24416: ---for bulk insert into OKC_K_LINES_B, *****************
24417: ---OKS_K_LINES_B,OKC_K_ITEMS *****************
24418:
24419:
24420: ----------------------------------------------------------------------------
24421: -- Update of OKC_K_LINES_B