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_K_SALES_CREDITS

Line 11390: -- copy_oks_k_sales_credits

11386: End copy_oks_action_times;
11387:
11388: --------------------------------------------------------
11389: --===================================================
11390: -- copy_oks_k_sales_credits
11391: -- Parameters: P_From_Chr_ID : Header ID of source contract
11392: -- P_To_Chr_ID : Header ID of target contract
11393: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
11394: -- or as part of component copy from UI (value = 'Y')

Line 11410: PROCEDURE copy_oks_k_sales_credits(P_From_Chr_ID IN NUMBER

11406: -- End If
11407: -- End If
11408:
11409: --====================================================
11410: PROCEDURE copy_oks_k_sales_credits(P_From_Chr_ID IN NUMBER
11411: ,P_To_Chr_ID IN NUMBER
11412: ,P_Partial_Copy_YN IN VARCHAR2
11413: ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
11414: ,P_Lines_Count IN NUMBER DEFAULT 0

Line 11435: OKS_K_SALES_CREDITS oksSC

11431: ,1 AS oksSC_OBJECT_VERSION_NUMBER
11432: ,oksSC.SECURITY_GROUP_ID AS oksSC_SECURITY_GROUP_ID
11433: ,oksSC.SALES_GROUP_ID AS oksSC_SALES_GROUP_ID
11434: FROM
11435: OKS_K_SALES_CREDITS oksSC
11436: ,OKC_K_HEADERS_B okcH
11437: WHERE oksSC.CHR_ID = okcH.ORIG_SYSTEM_ID1
11438: AND oksSC.CLE_ID IS NULL
11439: AND okcH.ID = P_To_Chr_ID

Line 11455: OKS_K_SALES_CREDITS oksSC

11451: ,1 AS oksSC_OBJECT_VERSION_NUMBER
11452: ,oksSC.SECURITY_GROUP_ID AS oksSC_SECURITY_GROUP_ID
11453: ,oksSC.SALES_GROUP_ID AS oksSC_SALES_GROUP_ID
11454: FROM
11455: OKS_K_SALES_CREDITS oksSC
11456: ,OKC_K_LINES_B okcB
11457: WHERE oksSC.CLE_ID = okcB.ORIG_SYSTEM_ID1
11458: AND okcB.DNZ_CHR_ID = P_To_Chr_ID
11459: AND oksSC.CHR_ID = P_From_Chr_ID;

Line 11475: OKS_K_SALES_CREDITS oksSC

11471: ,1 AS oksSC_OBJECT_VERSION_NUMBER
11472: ,oksSC.SECURITY_GROUP_ID AS oksSC_SECURITY_GROUP_ID
11473: ,oksSC.SALES_GROUP_ID AS oksSC_SALES_GROUP_ID
11474: FROM
11475: OKS_K_SALES_CREDITS oksSC
11476: ,OKC_K_HEADERS_B okcH
11477: WHERE oksSC.CHR_ID = okcH.ORIG_SYSTEM_ID1
11478: AND oksSC.CLE_ID IS NULL
11479: AND okcH.ID = P_To_Chr_ID

Line 11496: OKS_K_SALES_CREDITS oksSC

11492: ,1 AS oksSC_OBJECT_VERSION_NUMBER
11493: ,oksSC.SECURITY_GROUP_ID AS oksSC_SECURITY_GROUP_ID
11494: ,oksSC.SALES_GROUP_ID AS oksSC_SALES_GROUP_ID
11495: FROM
11496: OKS_K_SALES_CREDITS oksSC
11497: ,OKC_K_LINES_B_TEMP okcBT
11498: WHERE
11499: oksSC.CLE_ID = okcBT.ORIG_SYSTEM_ID1
11500: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID

Line 11517: OKS_K_SALES_CREDITS oksSC

11513: ,1 AS oksSC_OBJECT_VERSION_NUMBER
11514: ,oksSC.SECURITY_GROUP_ID AS oksSC_SECURITY_GROUP_ID
11515: ,oksSC.SALES_GROUP_ID AS oksSC_SALES_GROUP_ID
11516: FROM
11517: OKS_K_SALES_CREDITS oksSC
11518: ,OKC_K_HEADERS_B okcH
11519: WHERE oksSC.CHR_ID = okcH.ORIG_SYSTEM_ID1
11520: AND oksSC.CLE_ID IS NULL
11521: AND okcH.ID = P_To_Chr_ID

Line 11537: OKS_K_SALES_CREDITS oksSC

11533: ,1 AS oksSC_OBJECT_VERSION_NUMBER
11534: ,oksSC.SECURITY_GROUP_ID AS oksSC_SECURITY_GROUP_ID
11535: ,oksSC.SALES_GROUP_ID AS oksSC_SALES_GROUP_ID
11536: FROM
11537: OKS_K_SALES_CREDITS oksSC
11538: ,OKC_K_LINES_B_TEMP okcBT
11539: WHERE
11540: oksSC.CLE_ID = okcBT.ORIG_SYSTEM_ID1
11541: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID

Line 11624: INSERT INTO OKS_K_SALES_CREDITS(

11620: End If;
11621: End If;
11622:
11623: FORALL i IN OksSCRecTab.OksSC_NewID.FIRST .. OksSCRecTab.OksSC_NewID.LAST
11624: INSERT INTO OKS_K_SALES_CREDITS(
11625: ID
11626: ,PERCENT
11627: ,CHR_ID
11628: ,CLE_ID

Line 11697: End copy_oks_k_sales_credits;

11693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11694: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
11695: RAISE;
11696:
11697: End copy_oks_k_sales_credits;
11698:
11699: ------------------------------------------------------------
11700: --===================================================
11701: -- copy_oks_billrate_schedules

Line 19577: --------------Copy of OKS_K_SALES_CREDITS-------------------------------

19573: End If;
19574: End;
19575: ----------------------------------------------------------------------
19576:
19577: --------------Copy of OKS_K_SALES_CREDITS-------------------------------
19578: Begin
19579: copy_oks_k_sales_credits(P_From_Chr_ID => P_From_Chr_ID
19580: ,P_To_Chr_ID => P_To_Chr_ID
19581: ,P_Partial_Copy_YN => 'N'

Line 19579: copy_oks_k_sales_credits(P_From_Chr_ID => P_From_Chr_ID

19575: ----------------------------------------------------------------------
19576:
19577: --------------Copy of OKS_K_SALES_CREDITS-------------------------------
19578: Begin
19579: copy_oks_k_sales_credits(P_From_Chr_ID => P_From_Chr_ID
19580: ,P_To_Chr_ID => P_To_Chr_ID
19581: ,P_Partial_Copy_YN => 'N'
19582: ,x_return_status => l_return_status);
19583:

Line 25375: ---------------Copy of OKS_K_SALES_CREDITS---------------------------

25371:
25372: --=====================End of BillRate Schedule copy============================
25373:
25374:
25375: ---------------Copy of OKS_K_SALES_CREDITS---------------------------
25376: Begin
25377: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25378: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25379: FND_LOG.string(FND_LOG.level_statement

Line 25380: ,l_module_name||'.copy_oks_k_sales_credits'

25376: Begin
25377: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25378: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25379: FND_LOG.string(FND_LOG.level_statement
25380: ,l_module_name||'.copy_oks_k_sales_credits'
25381: ,'Before call to copy_oks_k_sales_credits'
25382: );
25383: END IF;
25384: END IF;

Line 25381: ,'Before call to copy_oks_k_sales_credits'

25377: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25378: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25379: FND_LOG.string(FND_LOG.level_statement
25380: ,l_module_name||'.copy_oks_k_sales_credits'
25381: ,'Before call to copy_oks_k_sales_credits'
25382: );
25383: END IF;
25384: END IF;
25385:

Line 25386: copy_oks_k_sales_credits(P_From_Chr_ID => P_From_Chr_ID

25382: );
25383: END IF;
25384: END IF;
25385:
25386: copy_oks_k_sales_credits(P_From_Chr_ID => P_From_Chr_ID
25387: ,P_To_Chr_ID => P_To_Chr_ID
25388: ,P_Partial_Copy_YN => 'Y'
25389: ,P_Target_Contract_New_YN => P_Target_Contract_New_YN
25390: ,P_Lines_Count => P_Lines_Tbl.COUNT

Line 25396: ,l_module_name||'.copy_oks_k_sales_credits'

25392:
25393: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25394: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25395: FND_LOG.string(FND_LOG.level_statement
25396: ,l_module_name||'.copy_oks_k_sales_credits'
25397: ,'After call to copy_oks_k_sales_credits: x_return_status:'||l_return_status
25398: ||' '||SQLERRM
25399: );
25400: END IF;

Line 25397: ,'After call to copy_oks_k_sales_credits: x_return_status:'||l_return_status

25393: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25394: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25395: FND_LOG.string(FND_LOG.level_statement
25396: ,l_module_name||'.copy_oks_k_sales_credits'
25397: ,'After call to copy_oks_k_sales_credits: x_return_status:'||l_return_status
25398: ||' '||SQLERRM
25399: );
25400: END IF;
25401: END IF;