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 OKS_STREAM_LEVELS_B

Line 11980: -- copy_oks_stream_levels_b

11976: End copy_oks_billrate_schedules;
11977:
11978: ------------------------------------------------------------
11979: --===================================================
11980: -- copy_oks_stream_levels_b
11981: -- Parameters: P_From_Chr_ID : Header ID of source contract
11982: -- P_To_Chr_ID : Header ID of target contract
11983: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
11984: -- or as part of component copy from UI (value = 'Y')

Line 12004: PROCEDURE copy_oks_stream_levels_b(P_From_Chr_ID IN NUMBER

12000: -- End If
12001: -- End If
12002: --====================================================
12003:
12004: PROCEDURE copy_oks_stream_levels_b(P_From_Chr_ID IN NUMBER
12005: ,P_To_Chr_ID IN NUMBER
12006: ,P_Partial_Copy_YN IN VARCHAR2
12007: ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
12008: ,P_Lines_Count IN NUMBER DEFAULT 0

Line 12011: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_STREAM_LEVELS_B';

12007: ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
12008: ,P_Lines_Count IN NUMBER DEFAULT 0
12009: ,x_return_status OUT NOCOPY VARCHAR2) IS
12010:
12011: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKS_STREAM_LEVELS_B';
12012: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
12013: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
12014:
12015: CURSOR GetOksSLFull IS

Line 12043: OKS_STREAM_LEVELS_B oksSL

12039: ,oksSL.ID AS oksSL_ORIG_SYSTEM_ID1
12040: ,NULL AS oksSL_ORIG_SYSTEM_SOURCE_CODE
12041: ,'COPY' AS oksSL_ORIG_SYSTEM_REFERENCE1
12042: FROM
12043: OKS_STREAM_LEVELS_B oksSL
12044: ,OKC_K_HEADERS_B okcH
12045: WHERE
12046: oksSL.DNZ_CHR_ID = okcH.ORIG_SYSTEM_ID1
12047: AND okcH.ID = P_To_Chr_ID

Line 12079: OKS_STREAM_LEVELS_B oksSL

12075: ,oksSL.ID AS oksSL_ORIG_SYSTEM_ID1
12076: ,NULL AS oksSL_ORIG_SYSTEM_SOURCE_CODE
12077: ,'COPY' AS oksSL_ORIG_SYSTEM_REFERENCE1
12078: FROM
12079: OKS_STREAM_LEVELS_B oksSL
12080: ,OKC_K_LINES_B okcBTarget
12081: ,OKC_K_LINES_B okcBSource
12082: WHERE
12083: oksSL.CLE_ID = okcBTarget.ORIG_SYSTEM_ID1

Line 12162: OKS_STREAM_LEVELS_B oksSL

12158: ,oksSL.ID AS oksSL_ORIG_SYSTEM_ID1
12159: ,NULL AS oksSL_ORIG_SYSTEM_SOURCE_CODE
12160: ,'COPY' AS oksSL_ORIG_SYSTEM_REFERENCE1
12161: FROM
12162: OKS_STREAM_LEVELS_B oksSL
12163: ,OKC_K_HEADERS_B okcH
12164: WHERE
12165: oksSL.DNZ_CHR_ID = okcH.ORIG_SYSTEM_ID1
12166: AND okcH.ID = P_To_Chr_ID

Line 12198: OKS_STREAM_LEVELS_B oksSL

12194: ,oksSL.ID AS oksSL_ORIG_SYSTEM_ID1
12195: ,NULL AS oksSL_ORIG_SYSTEM_SOURCE_CODE
12196: ,'COPY' AS oksSL_ORIG_SYSTEM_REFERENCE1
12197: FROM
12198: OKS_STREAM_LEVELS_B oksSL
12199: ,OKC_K_LINES_B_TEMP okcBT
12200: WHERE
12201: oksSL.CLE_ID = okcBT.ORIG_SYSTEM_ID1
12202: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID

Line 12304: OKS_STREAM_LEVELS_B oksSL

12300: ,oksSL.ID AS oksSL_ORIG_SYSTEM_ID1
12301: ,NULL AS oksSL_ORIG_SYSTEM_SOURCE_CODE
12302: ,'COPY' AS oksSL_ORIG_SYSTEM_REFERENCE1
12303: FROM
12304: OKS_STREAM_LEVELS_B oksSL
12305: ,OKC_K_HEADERS_B okcH
12306: WHERE
12307: oksSL.DNZ_CHR_ID = okcH.ORIG_SYSTEM_ID1
12308: AND okcH.ID = P_To_Chr_ID

Line 12344: OKS_STREAM_LEVELS_B oksSL

12340: ,oksSL.ID AS oksSL_ORIG_SYSTEM_ID1
12341: ,NULL AS oksSL_ORIG_SYSTEM_SOURCE_CODE
12342: ,'COPY' AS oksSL_ORIG_SYSTEM_REFERENCE1
12343: FROM
12344: OKS_STREAM_LEVELS_B oksSL
12345: ,OKC_K_LINES_B_TEMP okcBT
12346: WHERE
12347: oksSL.CLE_ID = okcBT.ORIG_SYSTEM_ID1
12348: AND oksSL.DNZ_CHR_ID = P_From_Chr_ID

Line 12420: --errorout_hk('Entered copy_oks_stream_levels_b');

12416: ;
12417:
12418: Begin
12419: x_return_status := l_return_status;
12420: --errorout_hk('Entered copy_oks_stream_levels_b');
12421: If (P_Partial_Copy_YN = 'N') then
12422: OPEN GetOksSLFull;
12423: ElsIf (P_Partial_Copy_YN = 'Y') then
12424: If (P_Target_Contract_New_YN = 'Y' and P_Lines_Count = 0) then

Line 12558: INSERT INTO OKS_STREAM_LEVELS_B (

12554: End If;
12555: --errorout_hk('GetOksLEPartial_L count -'||OksLERecTab.OksLE_NewID.count);
12556:
12557: FORALL i IN OksSLRecTab.OksSL_NewID.FIRST .. OksSLRecTab.OksSL_NewID.LAST
12558: INSERT INTO OKS_STREAM_LEVELS_B (
12559: ID
12560: ,CHR_ID
12561: ,CLE_ID
12562: ,DNZ_CHR_ID

Line 12662: End copy_oks_stream_levels_b;

12658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12659: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
12660: RAISE;
12661:
12662: End copy_oks_stream_levels_b;
12663:
12664: ------------------------------------------------
12665: --===================================================
12666: -- copy_oks_level_elements

Line 12727: ,OKS_STREAM_LEVELS_B oksSL

12723: and a.DNZ_CHR_ID = P_To_Chr_ID )) AS oksLE_NewParentCleID --*
12724: ,oksLE.DATE_END AS oksLE_DATE_END
12725: FROM
12726: OKS_LEVEL_ELEMENTS oksLE
12727: ,OKS_STREAM_LEVELS_B oksSL
12728: WHERE
12729: oksLE.RUL_ID = oksSL.ORIG_SYSTEM_ID1
12730: AND oksSL.DNZ_CHR_ID = P_To_Chr_ID
12731: AND oksLE.DNZ_CHR_ID = P_From_Chr_ID;

Line 12757: ,OKS_STREAM_LEVELS_B oksSL

12753: ,NULL AS oksLE_NewParentCleID --*
12754: ,oksLE.DATE_END AS oksLE_DATE_END
12755: FROM
12756: OKS_LEVEL_ELEMENTS oksLE
12757: ,OKS_STREAM_LEVELS_B oksSL
12758: WHERE
12759: oksLE.RUL_ID = oksSL.ORIG_SYSTEM_ID1
12760: AND oksSL.CHR_ID IS NOT NULL
12761: AND oksSL.CLE_ID IS NULL

Line 12787: ,OKS_STREAM_LEVELS_B oksSL

12783: ,decode(okcBTarget.CLE_ID,NULL,okcBTarget.ID,okcBTarget.CLE_ID) AS NewParentCleID
12784: ,oksLE.DATE_END AS oksLE_DATE_END
12785: FROM
12786: OKS_LEVEL_ELEMENTS oksLE
12787: ,OKS_STREAM_LEVELS_B oksSL
12788: ,OKC_K_LINES_B okcBTarget
12789: ,OKC_K_LINES_B okcBSource
12790: WHERE
12791: oksLE.RUL_ID = oksSL.ORIG_SYSTEM_ID1

Line 12866: ,OKS_STREAM_LEVELS_B oksSL

12862: ,NULL AS oksLE_NewParentCleID --*
12863: ,oksLE.DATE_END AS oksLE_DATE_END
12864: FROM
12865: OKS_LEVEL_ELEMENTS oksLE
12866: ,OKS_STREAM_LEVELS_B oksSL
12867: WHERE
12868: oksLE.RUL_ID = oksSL.ORIG_SYSTEM_ID1
12869: AND oksSL.CHR_ID IS NOT NULL
12870: AND oksSL.CLE_ID IS NULL

Line 12897: ,OKS_STREAM_LEVELS_B oksSL

12893: ,decode(okcBT.CLE_ID,NULL,okcBT.ID,okcBT.CLE_ID) AS NewParentCleID
12894: ,oksLE.DATE_END AS oksLE_DATE_END
12895: FROM
12896: OKS_LEVEL_ELEMENTS oksLE
12897: ,OKS_STREAM_LEVELS_B oksSL
12898: ,OKC_K_LINES_B_TEMP okcBT
12899: WHERE
12900: oksLE.RUL_ID = oksSL.ORIG_SYSTEM_ID1
12901: AND oksSL.CHR_ID IS NULL

Line 12998: ,OKS_STREAM_LEVELS_B oksSL

12994: ,NULL AS NewParentCleID --*
12995: ,oksLE.DATE_END AS oksLE_DATE_END
12996: FROM
12997: OKS_LEVEL_ELEMENTS oksLE
12998: ,OKS_STREAM_LEVELS_B oksSL
12999: WHERE
13000: oksLE.RUL_ID = oksSL.ORIG_SYSTEM_ID1
13001: AND oksSL.CHR_ID IS NOT NULL
13002: AND oksSL.CLE_ID IS NULL

Line 13028: ,OKS_STREAM_LEVELS_B oksSL

13024: ,decode(okcBT.CLE_ID,NULL,okcBT.ID,okcBT.CLE_ID) AS NewParentCleID
13025: ,oksLE.DATE_END AS oksLE_DATE_END
13026: FROM
13027: OKS_LEVEL_ELEMENTS oksLE
13028: ,OKS_STREAM_LEVELS_B oksSL
13029: ,OKC_K_LINES_B_TEMP okcBT
13030: WHERE
13031: oksLE.RUL_ID = oksSL.ORIG_SYSTEM_ID1
13032: AND oksSL.CHR_ID IS NULL

Line 13667: OKS_STREAM_LEVELS_B where CLE_ID = l_Source_Top_Line_ID

13663: ,DUE_ARR_YN
13664: ,AMOUNT
13665: ,LINES_DETAILED_YN
13666: FROM
13667: OKS_STREAM_LEVELS_B where CLE_ID = l_Source_Top_Line_ID
13668: ORDER BY SEQUENCE_NO;
13669:
13670: TYPE l_SourceStreams_tbl_Type IS TABLE OF GetStreamsForSourceTopLine%ROWTYPE INDEX BY BINARY_INTEGER;
13671: l_SourceStreams_tbl l_SourceStreams_tbl_Type;

Line 14316: OKS_STREAM_LEVELS_B where CHR_ID = P_To_Chr_ID AND

14312: ,DUE_ARR_YN
14313: ,AMOUNT
14314: ,LINES_DETAILED_YN
14315: FROM
14316: OKS_STREAM_LEVELS_B where CHR_ID = P_To_Chr_ID AND
14317: CLE_ID IS NULL
14318: ORDER BY SEQUENCE_NO;
14319:
14320: TYPE l_TrgHdrStreams_Tbl_Type IS TABLE OF GetStreamsForTargetHeader%ROWTYPE INDEX BY BINARY_INTEGER;

Line 14330: OKS_STREAM_LEVELS_B

14326: SELECT
14327: INVOICE_OFFSET_DAYS
14328: ,INTERFACE_OFFSET_DAYS
14329: FROM
14330: OKS_STREAM_LEVELS_B
14331: WHERE CLE_ID = P_From_Cle_ID
14332: AND dnz_chr_id = P_FROM_CHR_ID
14333: ORDER BY SEQUENCE_NO;
14334: -- End NECHATUR Bug#5349539

Line 14358: OKS_STREAM_LEVELS_B

14354: ,DUE_ARR_YN
14355: ,AMOUNT
14356: ,LINES_DETAILED_YN
14357: FROM
14358: OKS_STREAM_LEVELS_B
14359: WHERE CLE_ID = P_From_Cle_ID
14360: AND dnz_chr_id = P_FROM_CHR_ID
14361: ORDER BY SEQUENCE_NO;
14362:

Line 19662: -------------Copy of OKS_STREAM_LEVELS_B---------------------------

19658: ) THEN -- Bulk Copy of Billing Schedule can be done from Source
19659:
19660: --================Start of Billing Schedule copy for Header and Lines==========
19661:
19662: -------------Copy of OKS_STREAM_LEVELS_B---------------------------
19663: Begin
19664: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19665: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19666: FND_LOG.string(FND_LOG.level_statement

Line 19667: ,l_module_name||'.copy_oks_stream_levels_b'

19663: Begin
19664: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19665: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19666: FND_LOG.string(FND_LOG.level_statement
19667: ,l_module_name||'.copy_oks_stream_levels_b'
19668: ,'Before call to copy_oks_stream_levels_b'
19669: );
19670: END IF;
19671: END IF;

Line 19668: ,'Before call to copy_oks_stream_levels_b'

19664: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19665: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19666: FND_LOG.string(FND_LOG.level_statement
19667: ,l_module_name||'.copy_oks_stream_levels_b'
19668: ,'Before call to copy_oks_stream_levels_b'
19669: );
19670: END IF;
19671: END IF;
19672:

Line 19673: copy_oks_stream_levels_b(P_From_Chr_ID => P_From_Chr_ID

19669: );
19670: END IF;
19671: END IF;
19672:
19673: copy_oks_stream_levels_b(P_From_Chr_ID => P_From_Chr_ID
19674: ,P_To_Chr_ID => P_To_Chr_ID
19675: ,P_Partial_Copy_YN => 'N'
19676: ,x_return_status => l_return_status);
19677:

Line 19681: ,l_module_name||'.copy_oks_stream_levels_b'

19677:
19678: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19679: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19680: FND_LOG.string(FND_LOG.level_statement
19681: ,l_module_name||'.copy_oks_stream_levels_b'
19682: ,'After call to copy_oks_stream_levels_b: x_return_status:'||l_return_status
19683: ||' '||SQLERRM
19684: );
19685: END IF;

Line 19682: ,'After call to copy_oks_stream_levels_b: x_return_status:'||l_return_status

19678: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19679: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19680: FND_LOG.string(FND_LOG.level_statement
19681: ,l_module_name||'.copy_oks_stream_levels_b'
19682: ,'After call to copy_oks_stream_levels_b: x_return_status:'||l_return_status
19683: ||' '||SQLERRM
19684: );
19685: END IF;
19686: END IF;

Line 24932: -------------Copy of OKS_STREAM_LEVELS_B---------------------------

24928: IF (P_Target_Contract_New_YN = 'Y') then
24929: IF ( (l_SrcContractPPSetupExists_YN = 'Y') OR (l_SrcContractPPSetupExists_YN = 'N' AND l_GCDPPSetupExists_YN = 'N')) THEN
24930: -- Bulk Copy of Billing Schedule can be done from Source
24931: --errorout_hk('Copy Line Components, Copy of bill sch');
24932: -------------Copy of OKS_STREAM_LEVELS_B---------------------------
24933: Begin
24934: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24935: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24936: FND_LOG.string(FND_LOG.level_statement

Line 24937: ,l_module_name||'.copy_oks_stream_levels_b'

24933: Begin
24934: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24935: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24936: FND_LOG.string(FND_LOG.level_statement
24937: ,l_module_name||'.copy_oks_stream_levels_b'
24938: ,'Before call to copy_oks_stream_levels_b'
24939: );
24940: END IF;
24941: END IF;

Line 24938: ,'Before call to copy_oks_stream_levels_b'

24934: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24935: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24936: FND_LOG.string(FND_LOG.level_statement
24937: ,l_module_name||'.copy_oks_stream_levels_b'
24938: ,'Before call to copy_oks_stream_levels_b'
24939: );
24940: END IF;
24941: END IF;
24942:

Line 24943: copy_oks_stream_levels_b(P_From_Chr_ID => P_From_Chr_ID

24939: );
24940: END IF;
24941: END IF;
24942:
24943: copy_oks_stream_levels_b(P_From_Chr_ID => P_From_Chr_ID
24944: ,P_To_Chr_ID => P_To_Chr_ID
24945: ,P_Partial_Copy_YN => 'Y'
24946: ,P_Target_Contract_New_YN => P_Target_Contract_New_YN
24947: ,P_Lines_Count => P_Lines_Tbl.COUNT

Line 24953: ,l_module_name||'.copy_oks_stream_levels_b'

24949:
24950: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24951: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24952: FND_LOG.string(FND_LOG.level_statement
24953: ,l_module_name||'.copy_oks_stream_levels_b'
24954: ,'After call to copy_oks_stream_levels_b: x_return_status:'||l_return_status
24955: ||' '||SQLERRM
24956: );
24957: END IF;

Line 24954: ,'After call to copy_oks_stream_levels_b: x_return_status:'||l_return_status

24950: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24951: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24952: FND_LOG.string(FND_LOG.level_statement
24953: ,l_module_name||'.copy_oks_stream_levels_b'
24954: ,'After call to copy_oks_stream_levels_b: x_return_status:'||l_return_status
24955: ||' '||SQLERRM
24956: );
24957: END IF;
24958: END IF;