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 1246: FROM okc_k_items_v

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

Line 1328: FROM okc_k_items

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

Line 2158: FROM OKC_K_ITEMS_V

2154: UOM_CODE,
2155: EXCEPTION_YN,
2156: NUMBER_OF_ITEMS,
2157: PRICED_ITEM_YN
2158: FROM OKC_K_ITEMS_V
2159: WHERE ID = p_cim_id;
2160: BEGIN
2161: OPEN c_cimv_rec;
2162: FETCH c_cimv_rec

Line 15658: OKC_K_ITEMS

15654: /*if p_include_cancelled_lines 'Y' AND p_include_terminated_lines = 'Y' */
15655: /* Cursor to get rows to be copied from:
15656: OKC_K_LINES_B
15657: OKS_K_LINES_B
15658: OKC_K_ITEMS
15659: for a specified Source Contract. This cursor is used when P_Renew_Ref_YN = 'N' */
15660: CURSOR GetOKCOKSLinesB_Copy(P_From_Chr_ID IN NUMBER
15661: ,P_To_Chr_ID IN NUMBER) IS
15662: SELECT /*+ leading(okcB) use_nl(oksB,okcI) */

Line 15884: --------------------------------Start of OKC_K_ITEMS columns-------------------------

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

Line 15909: ,OKC_K_ITEMS okcI

15905: ,oksB.COUNTER_VALUE_ID AS OksB_COUNTER_VALUE_ID
15906: FROM
15907: OKC_K_LINES_B okcB
15908: ,OKS_K_LINES_B oksB
15909: ,OKC_K_ITEMS okcI
15910: Where okcB.DNZ_CHR_ID = P_From_Chr_ID
15911: AND okcB.ID = oksB.CLE_ID(+)
15912: AND okcB.ID = okcI.CLE_ID(+)
15913: AND oksB.DNZ_CHR_ID(+) = okcB.DNZ_CHR_ID

Line 15922: OKC_K_ITEMS

15918: /*if p_include_cancelled_lines ='Y' and p_include_terminated_lines = 'N'*/
15919: /* Cursor to get rows to be copied from:
15920: OKC_K_LINES_B
15921: OKS_K_LINES_B
15922: OKC_K_ITEMS
15923: for a specified Source Contract. This cursor is used when P_Renew_Ref_YN = 'N' */
15924: CURSOR GetOKCOKSLinesB_Copy_CANCEL(P_From_Chr_ID IN NUMBER
15925: ,P_To_Chr_ID IN NUMBER) IS
15926: SELECT /*+ leading(okcB) use_nl(oksB,okcI) */

Line 16148: --------------------------------Start of OKC_K_ITEMS columns-------------------------

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

Line 16173: ,OKC_K_ITEMS okcI

16169: ,oksB.COUNTER_VALUE_ID AS OksB_COUNTER_VALUE_ID
16170: FROM
16171: OKC_K_LINES_B okcB
16172: ,OKS_K_LINES_B oksB
16173: ,OKC_K_ITEMS okcI
16174: Where okcB.DNZ_CHR_ID = P_From_Chr_ID
16175: AND okcB.ID = oksB.CLE_ID(+)
16176: AND okcB.ID = okcI.CLE_ID(+)
16177: AND oksB.DNZ_CHR_ID(+) = okcB.DNZ_CHR_ID

Line 16187: OKC_K_ITEMS

16183: /*if p_include_cancelled_lines = 'N' and p_include_terminated_lines = 'Y' */
16184: /* Cursor to get rows to be copied from:
16185: OKC_K_LINES_B
16186: OKS_K_LINES_B
16187: OKC_K_ITEMS
16188: for a specified Source Contract. This cursor is used when P_Renew_Ref_YN = 'N' */
16189: CURSOR GetOKCOKSLinesB_Copy_TERMN(P_From_Chr_ID IN NUMBER
16190: ,P_To_Chr_ID IN NUMBER) IS
16191: SELECT /*+ leading(okcB) use_nl(oksB,okcI) */

Line 16413: --------------------------------Start of OKC_K_ITEMS columns-------------------------

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

Line 16438: ,OKC_K_ITEMS okcI

16434: ,oksB.COUNTER_VALUE_ID AS OksB_COUNTER_VALUE_ID
16435: FROM
16436: OKC_K_LINES_B okcB
16437: ,OKS_K_LINES_B oksB
16438: ,OKC_K_ITEMS okcI
16439: Where okcB.DNZ_CHR_ID = P_From_Chr_ID
16440: AND okcB.ID = oksB.CLE_ID(+)
16441: AND okcB.ID = okcI.CLE_ID(+)
16442: AND oksB.DNZ_CHR_ID(+) = okcB.DNZ_CHR_ID

Line 16452: OKC_K_ITEMS

16448: /*if p_include_cancelled_lines = 'N' and p_include_terminated_lines = 'N' */
16449: /* Cursor to get rows to be copied from:
16450: OKC_K_LINES_B
16451: OKS_K_LINES_B
16452: OKC_K_ITEMS
16453: for a specified Source Contract. This cursor is used when P_Renew_Ref_YN = 'N' */
16454: CURSOR GetOKCOKSLinesB_Copy_exclude(P_From_Chr_ID IN NUMBER
16455: ,P_To_Chr_ID IN NUMBER) IS
16456: SELECT /*+ leading(okcB) use_nl(oksB,okcI) */

Line 16678: --------------------------------Start of OKC_K_ITEMS columns-------------------------

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

Line 16703: ,OKC_K_ITEMS okcI

16699: ,oksB.COUNTER_VALUE_ID AS OksB_COUNTER_VALUE_ID
16700: FROM
16701: OKC_K_LINES_B okcB
16702: ,OKS_K_LINES_B oksB
16703: ,OKC_K_ITEMS okcI
16704: Where okcB.DNZ_CHR_ID = P_From_Chr_ID
16705: AND okcB.ID = oksB.CLE_ID(+)
16706: AND okcB.ID = okcI.CLE_ID(+)
16707: AND oksB.DNZ_CHR_ID(+) = okcB.DNZ_CHR_ID

Line 16718: OKC_K_ITEMS

16714:
16715: /* Cursor to get rows to be copied from:
16716: OKC_K_LINES_B
16717: OKS_K_LINES_B
16718: OKC_K_ITEMS
16719: for a specified Source Contracti. This cursor is used when P_Renew_Ref_YN = 'Y'. It filters out
16720: the lines that have been renewed,cancelled or terminated or have been marked as 'DNR' (Do not renew) */
16721:
16722: CURSOR GetOKCOKSLinesB_Renew(P_From_Chr_ID IN NUMBER

Line 16931: --------------------------------Start of OKC_K_ITEMS columns-------------------------

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

Line 16956: ,OKC_K_ITEMS okcI

16952: ,oksB.COUNTER_VALUE_ID AS OksB_COUNTER_VALUE_ID
16953: FROM
16954: OKC_K_LINES_B okcB
16955: ,OKS_K_LINES_B oksB
16956: ,OKC_K_ITEMS okcI
16957: WHERE
16958: okcB.ID = oksB.CLE_ID(+)
16959: AND okcB.ID = okcI.CLE_ID(+)
16960: AND okcB.DNZ_CHR_ID = P_From_Chr_ID

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

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
17348: ,OKCOKSLinesRecTab.OkcI_CLE_ID
17349: ,OKCOKSLinesRecTab.OkcI_NewDnzChrID

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

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
17563: ,OKCOKSLinesRecTab.OkcI_CLE_ID
17564: ,OKCOKSLinesRecTab.OkcI_NewDnzChrID

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

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
17777: ,OKCOKSLinesRecTab.OkcI_CLE_ID
17778: ,OKCOKSLinesRecTab.OkcI_NewDnzChrID

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

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
17990: ,OKCOKSLinesRecTab.OkcI_CLE_ID
17991: ,OKCOKSLinesRecTab.OkcI_NewDnzChrID

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

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
18211: ,OKCOKSLinesRecTab.OkcI_CLE_ID
18212: ,OKCOKSLinesRecTab.OkcI_NewDnzChrID

Line 18689: --Bulk Insert into OKC_K_ITEMS

18685: RAISE G_EXCEPTION_HALT_VALIDATION;
18686:
18687: End;
18688:
18689: --Bulk Insert into OKC_K_ITEMS
18690: Begin
18691:
18692:
18693: FORALL i IN OKCOKSLinesRecTab.OkcB_NewOKCLineID.FIRST .. OKCOKSLinesRecTab.OkcB_NewOKCLineID.LAST

Line 18694: INSERT INTO OKC_K_ITEMS(

18690: Begin
18691:
18692:
18693: FORALL i IN OKCOKSLinesRecTab.OkcB_NewOKCLineID.FIRST .. OKCOKSLinesRecTab.OkcB_NewOKCLineID.LAST
18694: INSERT INTO OKC_K_ITEMS(
18695: ID
18696: ,CLE_ID
18697: ,DNZ_CHR_ID
18698: ,CHR_ID

Line 18752: ,'AFTER INSERT into OKC_K_ITEMS '

18748:
18749: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
18750: FND_LOG.string(FND_LOG.level_statement
18751: ,l_module_name
18752: ,'AFTER INSERT into OKC_K_ITEMS '
18753: );
18754: END IF;
18755:
18756: EXCEPTION

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

18758: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
18759: IF (FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level) then
18760: FND_LOG.string(FND_LOG.level_unexpected
18761: ,l_module_name
18762: ,'EXCEPTION during insert into OKC_K_ITEMS '||SQLERRM
18763: );
18764: END IF;
18765:
18766: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

19250: ELSIF (P_Renew_Ref_YN = 'Y') THEN
19251: EXIT WHEN GetOKCOKSLinesB_Renew%NOTFOUND;
19252: END IF;
19253:
19254: END LOOP; --End of Bulk fetch and insert into OKC_K_LINES_B,OKS_K_LINES_B,OKC_K_ITEMS
19255:
19256: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19257: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19258: FND_LOG.string(FND_LOG.level_statement

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

19256: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19257: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19258: FND_LOG.string(FND_LOG.level_statement
19259: ,l_module_name
19260: ,'After BULK FETCH and BULK INSERT into OKC_K_LINES_B,OKS_K_LINES_B,OKC_K_ITEMS'
19261: );
19262: END IF;
19263: END IF;
19264:

Line 20228: -- OKC_K_ITEMS

20224: ----------------------------------------------------------------------------
20225: -- Cursor to get rows to be copied from:
20226: -- OKC_K_LINES_B_TEMP
20227: -- OKS_K_LINES_B
20228: -- OKC_K_ITEMS
20229: -- for a specified Source Contract and for the lines chosen by the user for copy.
20230:
20231: CURSOR GetOKCOKSLinesB_Temp(P_From_Chr_ID IN NUMBER
20232: ,P_To_Chr_ID IN NUMBER) IS

Line 20508: --------------------------------Start of OKC_K_ITEMS columns-------------------------

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

Line 20533: ,OKC_K_ITEMS okcI

20529: ,oksB.COUNTER_VALUE_ID AS OksB_COUNTER_VALUE_ID
20530: FROM
20531: OKC_K_LINES_B_TEMP okcBT
20532: ,OKS_K_LINES_B oksB
20533: ,OKC_K_ITEMS okcI
20534: Where okcBT.DNZ_CHR_ID = P_To_Chr_ID
20535: AND okcBT.ORIG_SYSTEM_ID1 = oksB.CLE_ID(+)
20536: AND okcBT.ORIG_SYSTEM_ID1 = okcI.CLE_ID(+)
20537: AND oksB.DNZ_CHR_ID(+) = P_From_Chr_ID

Line 20545: -- OKC_K_ITEMS

20541: ----------------------------------------------------------------------------
20542: -- Cursor to get rows to be copied from:
20543: -- OKC_K_LINES_B_TEMP
20544: -- OKS_K_LINES_B
20545: -- OKC_K_ITEMS
20546: -- for a specified Source Contract and for the lines chosen by the user for copy.
20547:
20548: CURSOR GetOKCOKSLinesB_Temp_CANCEL(P_From_Chr_ID IN NUMBER
20549: ,P_To_Chr_ID IN NUMBER) IS

Line 20825: --------------------------------Start of OKC_K_ITEMS columns-------------------------

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

Line 20850: ,OKC_K_ITEMS okcI

20846: ,oksB.COUNTER_VALUE_ID AS OksB_COUNTER_VALUE_ID
20847: FROM
20848: OKC_K_LINES_B_TEMP okcBT
20849: ,OKS_K_LINES_B oksB
20850: ,OKC_K_ITEMS okcI
20851: Where okcBT.DNZ_CHR_ID = P_To_Chr_ID
20852: AND okcBT.ORIG_SYSTEM_ID1 = oksB.CLE_ID(+)
20853: AND okcBT.ORIG_SYSTEM_ID1 = okcI.CLE_ID(+)
20854: AND oksB.DNZ_CHR_ID(+) = P_From_Chr_ID

Line 20863: -- OKC_K_ITEMS

20859: ----------------------------------------------------------------------------
20860: -- Cursor to get rows to be copied from:
20861: -- OKC_K_LINES_B_TEMP
20862: -- OKS_K_LINES_B
20863: -- OKC_K_ITEMS
20864: -- for a specified Source Contract and for the lines chosen by the user for copy.
20865:
20866: CURSOR GetOKCOKSLinesB_Temp_TERMN(P_From_Chr_ID IN NUMBER
20867: ,P_To_Chr_ID IN NUMBER) IS

Line 21143: --------------------------------Start of OKC_K_ITEMS columns-------------------------

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

Line 21168: ,OKC_K_ITEMS okcI

21164: ,oksB.COUNTER_VALUE_ID AS OksB_COUNTER_VALUE_ID
21165: FROM
21166: OKC_K_LINES_B_TEMP okcBT
21167: ,OKS_K_LINES_B oksB
21168: ,OKC_K_ITEMS okcI
21169: Where okcBT.DNZ_CHR_ID = P_To_Chr_ID
21170: AND okcBT.ORIG_SYSTEM_ID1 = oksB.CLE_ID(+)
21171: AND okcBT.ORIG_SYSTEM_ID1 = okcI.CLE_ID(+)
21172: AND oksB.DNZ_CHR_ID(+) = P_From_Chr_ID

Line 21181: -- OKC_K_ITEMS

21177: ----------------------------------------------------------------------------
21178: -- Cursor to get rows to be copied from:
21179: -- OKC_K_LINES_B_TEMP
21180: -- OKS_K_LINES_B
21181: -- OKC_K_ITEMS
21182: -- for a specified Source Contract and for the lines chosen by the user for copy.
21183:
21184: CURSOR GetOKCOKSLinesB_Temp_EXCLUDE(P_From_Chr_ID IN NUMBER
21185: ,P_To_Chr_ID IN NUMBER) IS

Line 21461: --------------------------------Start of OKC_K_ITEMS columns-------------------------

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

Line 21486: ,OKC_K_ITEMS okcI

21482: ,oksB.COUNTER_VALUE_ID AS OksB_COUNTER_VALUE_ID
21483: FROM
21484: OKC_K_LINES_B_TEMP okcBT
21485: ,OKS_K_LINES_B oksB
21486: ,OKC_K_ITEMS okcI
21487: Where okcBT.DNZ_CHR_ID = P_To_Chr_ID
21488: AND okcBT.ORIG_SYSTEM_ID1 = oksB.CLE_ID(+)
21489: AND okcBT.ORIG_SYSTEM_ID1 = okcI.CLE_ID(+)
21490: AND oksB.DNZ_CHR_ID(+) = P_From_Chr_ID

Line 22839: --OKS_K_LINES_B and OKC_K_ITEMS

22835:
22836:
22837: -----------------------------------------------------------------------------
22838: --Process rows in OKC_K_LINES_B_TEMP and do bulk inserts into OKC_K_LINES_B
22839: --OKS_K_LINES_B and OKC_K_ITEMS
22840: ----------------------------------------------------------------------------
22841: IF (P_Lines_Tbl.COUNT > 0) then ---Start of Check of P_Lines_Tbl.COUNT > 0 *****************
22842: ---for bulk insert into OKC_K_LINES_B, *****************
22843: ---OKS_K_LINES_B,OKC_K_ITEMS *****************

Line 22843: ---OKS_K_LINES_B,OKC_K_ITEMS *****************

22839: --OKS_K_LINES_B and OKC_K_ITEMS
22840: ----------------------------------------------------------------------------
22841: IF (P_Lines_Tbl.COUNT > 0) then ---Start of Check of P_Lines_Tbl.COUNT > 0 *****************
22842: ---for bulk insert into OKC_K_LINES_B, *****************
22843: ---OKS_K_LINES_B,OKC_K_ITEMS *****************
22844:
22845: If (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
22846: FND_LOG.string(FND_LOG.level_statement
22847: ,l_module_name

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

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
23066: ,OKCOKSLinesRecTab.OkcI_CLE_ID
23067: ,OKCOKSLinesRecTab.OkcI_NewDnzChrID

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

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
23279: ,OKCOKSLinesRecTab.OkcI_CLE_ID
23280: ,OKCOKSLinesRecTab.OkcI_NewDnzChrID

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

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
23492: ,OKCOKSLinesRecTab.OkcI_CLE_ID
23493: ,OKCOKSLinesRecTab.OkcI_NewDnzChrID

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

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
23705: ,OKCOKSLinesRecTab.OkcI_CLE_ID
23706: ,OKCOKSLinesRecTab.OkcI_NewDnzChrID

Line 24162: ---Bulk insert into OKC_K_ITEMS---

24158: ,'After BULK INSERT into OKS_K_LINES_B'
24159: );
24160: End If;
24161:
24162: ---Bulk insert into OKC_K_ITEMS---
24163:
24164: FORALL i IN OKCOKSLinesRecTab.OkcB_NewOKCLineID.FIRST .. OKCOKSLinesRecTab.OkcB_NewOKCLineID.LAST
24165: INSERT INTO OKC_K_ITEMS(
24166: ID

Line 24165: INSERT INTO OKC_K_ITEMS(

24161:
24162: ---Bulk insert into OKC_K_ITEMS---
24163:
24164: FORALL i IN OKCOKSLinesRecTab.OkcB_NewOKCLineID.FIRST .. OKCOKSLinesRecTab.OkcB_NewOKCLineID.LAST
24165: INSERT INTO OKC_K_ITEMS(
24166: ID
24167: ,CLE_ID
24168: ,DNZ_CHR_ID
24169: ,CHR_ID

Line 24223: ,'After BULK INSERT into OKC_K_ITEMS'

24219:
24220: If (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) then
24221: FND_LOG.string(FND_LOG.level_statement
24222: ,l_module_name
24223: ,'After BULK INSERT into OKC_K_ITEMS'
24224: );
24225: End If;
24226:
24227:

Line 24612: ---OKS_K_LINES_B,OKC_K_ITEMS *****************

24608: --------End of BULK FETCH FROM OKC_K_LINES_B_TEMP---------------
24609:
24610: END IF; ---End of Check of P_Lines_Tbl.COUNT > 0 *****************
24611: ---for bulk insert into OKC_K_LINES_B, *****************
24612: ---OKS_K_LINES_B,OKC_K_ITEMS *****************
24613:
24614:
24615: ----------------------------------------------------------------------------
24616: -- Update of OKC_K_LINES_B