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 11435: -- copy_oks_k_sales_credits

11431: End copy_oks_action_times;
11432:
11433: --------------------------------------------------------
11434: --===================================================
11435: -- copy_oks_k_sales_credits
11436: -- Parameters: P_From_Chr_ID : Header ID of source contract
11437: -- P_To_Chr_ID : Header ID of target contract
11438: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
11439: -- or as part of component copy from UI (value = 'Y')

Line 11455: PROCEDURE copy_oks_k_sales_credits(P_From_Chr_ID IN NUMBER

11451: -- End If
11452: -- End If
11453:
11454: --====================================================
11455: PROCEDURE copy_oks_k_sales_credits(P_From_Chr_ID IN NUMBER
11456: ,P_To_Chr_ID IN NUMBER
11457: ,P_Partial_Copy_YN IN VARCHAR2
11458: ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
11459: ,P_Lines_Count IN NUMBER DEFAULT 0

Line 11480: OKS_K_SALES_CREDITS oksSC

11476: ,1 AS oksSC_OBJECT_VERSION_NUMBER
11477: ,oksSC.SECURITY_GROUP_ID AS oksSC_SECURITY_GROUP_ID
11478: ,oksSC.SALES_GROUP_ID AS oksSC_SALES_GROUP_ID
11479: FROM
11480: OKS_K_SALES_CREDITS oksSC
11481: ,OKC_K_HEADERS_B okcH
11482: WHERE oksSC.CHR_ID = okcH.ORIG_SYSTEM_ID1
11483: AND oksSC.CLE_ID IS NULL
11484: AND okcH.ID = P_To_Chr_ID

Line 11500: OKS_K_SALES_CREDITS oksSC

11496: ,1 AS oksSC_OBJECT_VERSION_NUMBER
11497: ,oksSC.SECURITY_GROUP_ID AS oksSC_SECURITY_GROUP_ID
11498: ,oksSC.SALES_GROUP_ID AS oksSC_SALES_GROUP_ID
11499: FROM
11500: OKS_K_SALES_CREDITS oksSC
11501: ,OKC_K_LINES_B okcB
11502: WHERE oksSC.CLE_ID = okcB.ORIG_SYSTEM_ID1
11503: AND okcB.DNZ_CHR_ID = P_To_Chr_ID
11504: AND oksSC.CHR_ID = P_From_Chr_ID;

Line 11520: OKS_K_SALES_CREDITS oksSC

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

Line 11541: OKS_K_SALES_CREDITS oksSC

11537: ,1 AS oksSC_OBJECT_VERSION_NUMBER
11538: ,oksSC.SECURITY_GROUP_ID AS oksSC_SECURITY_GROUP_ID
11539: ,oksSC.SALES_GROUP_ID AS oksSC_SALES_GROUP_ID
11540: FROM
11541: OKS_K_SALES_CREDITS oksSC
11542: ,OKC_K_LINES_B_TEMP okcBT
11543: WHERE
11544: oksSC.CLE_ID = okcBT.ORIG_SYSTEM_ID1
11545: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID

Line 11562: OKS_K_SALES_CREDITS oksSC

11558: ,1 AS oksSC_OBJECT_VERSION_NUMBER
11559: ,oksSC.SECURITY_GROUP_ID AS oksSC_SECURITY_GROUP_ID
11560: ,oksSC.SALES_GROUP_ID AS oksSC_SALES_GROUP_ID
11561: FROM
11562: OKS_K_SALES_CREDITS oksSC
11563: ,OKC_K_HEADERS_B okcH
11564: WHERE oksSC.CHR_ID = okcH.ORIG_SYSTEM_ID1
11565: AND oksSC.CLE_ID IS NULL
11566: AND okcH.ID = P_To_Chr_ID

Line 11582: OKS_K_SALES_CREDITS oksSC

11578: ,1 AS oksSC_OBJECT_VERSION_NUMBER
11579: ,oksSC.SECURITY_GROUP_ID AS oksSC_SECURITY_GROUP_ID
11580: ,oksSC.SALES_GROUP_ID AS oksSC_SALES_GROUP_ID
11581: FROM
11582: OKS_K_SALES_CREDITS oksSC
11583: ,OKC_K_LINES_B_TEMP okcBT
11584: WHERE
11585: oksSC.CLE_ID = okcBT.ORIG_SYSTEM_ID1
11586: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID

Line 11669: INSERT INTO OKS_K_SALES_CREDITS(

11665: End If;
11666: End If;
11667:
11668: FORALL i IN OksSCRecTab.OksSC_NewID.FIRST .. OksSCRecTab.OksSC_NewID.LAST
11669: INSERT INTO OKS_K_SALES_CREDITS(
11670: ID
11671: ,PERCENT
11672: ,CHR_ID
11673: ,CLE_ID

Line 11742: End copy_oks_k_sales_credits;

11738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11739: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
11740: RAISE;
11741:
11742: End copy_oks_k_sales_credits;
11743:
11744: ------------------------------------------------------------
11745: --===================================================
11746: -- copy_oks_billrate_schedules

Line 19724: --------------Copy of OKS_K_SALES_CREDITS-------------------------------

19720: End If;
19721: End;
19722: ----------------------------------------------------------------------
19723:
19724: --------------Copy of OKS_K_SALES_CREDITS-------------------------------
19725: Begin
19726: copy_oks_k_sales_credits(P_From_Chr_ID => P_From_Chr_ID
19727: ,P_To_Chr_ID => P_To_Chr_ID
19728: ,P_Partial_Copy_YN => 'N'

Line 19726: copy_oks_k_sales_credits(P_From_Chr_ID => P_From_Chr_ID

19722: ----------------------------------------------------------------------
19723:
19724: --------------Copy of OKS_K_SALES_CREDITS-------------------------------
19725: Begin
19726: copy_oks_k_sales_credits(P_From_Chr_ID => P_From_Chr_ID
19727: ,P_To_Chr_ID => P_To_Chr_ID
19728: ,P_Partial_Copy_YN => 'N'
19729: ,x_return_status => l_return_status);
19730:

Line 25570: ---------------Copy of OKS_K_SALES_CREDITS---------------------------

25566:
25567: --=====================End of BillRate Schedule copy============================
25568:
25569:
25570: ---------------Copy of OKS_K_SALES_CREDITS---------------------------
25571: Begin
25572: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25573: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25574: FND_LOG.string(FND_LOG.level_statement

Line 25575: ,l_module_name||'.copy_oks_k_sales_credits'

25571: Begin
25572: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25573: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25574: FND_LOG.string(FND_LOG.level_statement
25575: ,l_module_name||'.copy_oks_k_sales_credits'
25576: ,'Before call to copy_oks_k_sales_credits'
25577: );
25578: END IF;
25579: END IF;

Line 25576: ,'Before call to copy_oks_k_sales_credits'

25572: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25573: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25574: FND_LOG.string(FND_LOG.level_statement
25575: ,l_module_name||'.copy_oks_k_sales_credits'
25576: ,'Before call to copy_oks_k_sales_credits'
25577: );
25578: END IF;
25579: END IF;
25580:

Line 25581: copy_oks_k_sales_credits(P_From_Chr_ID => P_From_Chr_ID

25577: );
25578: END IF;
25579: END IF;
25580:
25581: copy_oks_k_sales_credits(P_From_Chr_ID => P_From_Chr_ID
25582: ,P_To_Chr_ID => P_To_Chr_ID
25583: ,P_Partial_Copy_YN => 'Y'
25584: ,P_Target_Contract_New_YN => P_Target_Contract_New_YN
25585: ,P_Lines_Count => P_Lines_Tbl.COUNT

Line 25591: ,l_module_name||'.copy_oks_k_sales_credits'

25587:
25588: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25589: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25590: FND_LOG.string(FND_LOG.level_statement
25591: ,l_module_name||'.copy_oks_k_sales_credits'
25592: ,'After call to copy_oks_k_sales_credits: x_return_status:'||l_return_status
25593: ||' '||SQLERRM
25594: );
25595: END IF;

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

25588: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
25589: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
25590: FND_LOG.string(FND_LOG.level_statement
25591: ,l_module_name||'.copy_oks_k_sales_credits'
25592: ,'After call to copy_oks_k_sales_credits: x_return_status:'||l_return_status
25593: ||' '||SQLERRM
25594: );
25595: END IF;
25596: END IF;