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_PRICE_ADJUSTMENTS

Line 1613: FROM okc_price_adjustments_V

1609: WHERE chr_id = p_from_chr_id;
1610:
1611: CURSOR c_patv IS
1612: SELECT id
1613: FROM okc_price_adjustments_V
1614: WHERE chr_id = p_from_chr_id
1615: AND cle_id IS NULL; -- Added for Bug 2027165
1616:
1617: -- cursor for goverances

Line 3651: FROM OKC_PRICE_ADJUSTMENTS_V

3647: ATTRIBUTE14,
3648: ATTRIBUTE15,
3649: LAST_UPDATE_LOGIN,
3650: REBATE_TRANSACTION_TYPE_CODE
3651: FROM OKC_PRICE_ADJUSTMENTS_V
3652: WHERE ID = p_pat_id;
3653: BEGIN
3654: OPEN c_patv_rec;
3655: FETCH c_patv_rec

Line 6938: -- copy_okc_price_adjustments

6934:
6935: End copy_okc_price_att_values;
6936:
6937: --===================================================
6938: -- copy_okc_price_adjustments
6939: -- Parameters: P_From_Chr_ID : Header ID of source contract
6940: -- P_To_Chr_ID : Header ID of target contract
6941: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
6942: -- or as part of component copy from UI (value = 'Y')

Line 6962: PROCEDURE copy_okc_price_adjustments(P_From_Chr_ID IN NUMBER

6958: -- End If
6959: -- End If
6960:
6961: --====================================================
6962: PROCEDURE copy_okc_price_adjustments(P_From_Chr_ID IN NUMBER
6963: ,P_To_Chr_ID IN NUMBER
6964: ,P_Partial_Copy_YN IN VARCHAR2
6965: ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
6966: ,P_Lines_Count IN NUMBER DEFAULT 0

Line 6969: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKC_PRICE_ADJUSTMENTS';

6965: ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
6966: ,P_Lines_Count IN NUMBER DEFAULT 0
6967: ,x_return_status OUT NOCOPY VARCHAR2) IS
6968:
6969: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKC_PRICE_ADJUSTMENTS';
6970: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
6971:
6972: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
6973:

Line 7041: OKC_PRICE_ADJUSTMENTS okcPA

7037: ,okcPA.PRORATION_TYPE_CODE AS okcPA_PRORATION_TYPE_CODE
7038: ,okcPA.INCLUDE_ON_RETURNS_FLAG AS okcPA_INCLUDE_ON_RETURNS_FLAG
7039: ,okcPA.REBATE_TRANSACTION_TYPE_CODE AS okcPA_REBATE_TRXN_TYPE_CODE
7040: FROM
7041: OKC_PRICE_ADJUSTMENTS okcPA
7042: ,OKC_K_HEADERS_B okcH
7043: WHERE okcPA.CHR_ID = okcH.ORIG_SYSTEM_ID1
7044: and okcH.ID = P_To_Chr_ID
7045: and okcPA.CLE_ID is NULL

Line 7114: OKC_PRICE_ADJUSTMENTS okcPA

7110: ,okcPA.PRORATION_TYPE_CODE AS okcPA_PRORATION_TYPE_CODE
7111: ,okcPA.INCLUDE_ON_RETURNS_FLAG AS okcPA_INCLUDE_ON_RETURNS_FLAG
7112: ,okcPA.REBATE_TRANSACTION_TYPE_CODE AS okcPA_REBATE_TRXN_TYPE_CODE
7113: FROM
7114: OKC_PRICE_ADJUSTMENTS okcPA
7115: ,OKC_K_LINES_B okcB
7116: WHERE okcPA.CLE_ID = okcB.ORIG_SYSTEM_ID1
7117: AND okcB.DNZ_CHR_ID = P_To_Chr_ID;
7118:

Line 7190: OKC_PRICE_ADJUSTMENTS okcPA

7186: ,okcPA.PRORATION_TYPE_CODE AS okcPA_PRORATION_TYPE_CODE
7187: ,okcPA.INCLUDE_ON_RETURNS_FLAG AS okcPA_INCLUDE_ON_RETURNS_FLAG
7188: ,okcPA.REBATE_TRANSACTION_TYPE_CODE AS okcPA_REBATE_TRXN_TYPE_CODE
7189: FROM
7190: OKC_PRICE_ADJUSTMENTS okcPA
7191: ,OKC_K_HEADERS_B okcH
7192: WHERE okcPA.CHR_ID = okcH.ORIG_SYSTEM_ID1
7193: and okcH.ID = P_To_Chr_ID
7194: and okcPA.CLE_ID is NULL

Line 7263: OKC_PRICE_ADJUSTMENTS okcPA

7259: ,okcPA.PRORATION_TYPE_CODE AS okcPA_PRORATION_TYPE_CODE
7260: ,okcPA.INCLUDE_ON_RETURNS_FLAG AS okcPA_INCLUDE_ON_RETURNS_FLAG
7261: ,okcPA.REBATE_TRANSACTION_TYPE_CODE AS okcPA_REBATE_TRXN_TYPE_CODE
7262: FROM
7263: OKC_PRICE_ADJUSTMENTS okcPA
7264: ,OKC_K_LINES_B_TEMP okcBT
7265: WHERE okcPA.CLE_ID = okcBT.ORIG_SYSTEM_ID1
7266: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID;
7267:

Line 7339: OKC_PRICE_ADJUSTMENTS okcPA

7335: ,okcPA.PRORATION_TYPE_CODE AS okcPA_PRORATION_TYPE_CODE
7336: ,okcPA.INCLUDE_ON_RETURNS_FLAG AS okcPA_INCLUDE_ON_RETURNS_FLAG
7337: ,okcPA.REBATE_TRANSACTION_TYPE_CODE AS okcPA_REBATE_TRXN_TYPE_CODE
7338: FROM
7339: OKC_PRICE_ADJUSTMENTS okcPA
7340: ,OKC_K_HEADERS_B okcH
7341: WHERE okcPA.CHR_ID = okcH.ORIG_SYSTEM_ID1
7342: and okcH.ID = P_To_Chr_ID
7343: and okcPA.CLE_ID is NULL

Line 7419: OKC_PRICE_ADJUSTMENTS okcPA

7415: ,okcPA.PRORATION_TYPE_CODE AS okcPA_PRORATION_TYPE_CODE
7416: ,okcPA.INCLUDE_ON_RETURNS_FLAG AS okcPA_INCLUDE_ON_RETURNS_FLAG
7417: ,okcPA.REBATE_TRANSACTION_TYPE_CODE AS okcPA_REBATE_TRXN_TYPE_CODE
7418: FROM
7419: OKC_PRICE_ADJUSTMENTS okcPA
7420: ,OKC_K_LINES_B_TEMP okcBT
7421: WHERE okcPA.CLE_ID = okcBT.ORIG_SYSTEM_ID1
7422: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID;
7423:

Line 7775: INSERT INTO OKC_PRICE_ADJUSTMENTS(

7771:
7772:
7773:
7774: FORALL i in okcPARecTab.OkcPA_NewID.FIRST .. okcPARecTab.OkcPA_NewID.LAST
7775: INSERT INTO OKC_PRICE_ADJUSTMENTS(
7776: ID
7777: ,PAT_ID
7778: ,CHR_ID
7779: ,CLE_ID

Line 7957: End copy_okc_price_adjustments;

7953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7954: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
7955: RAISE;
7956:
7957: End copy_okc_price_adjustments;
7958:
7959:
7960: --===================================================
7961: -- copy_okc_k_party_roles_b

Line 19453: -----------Copy of OKC_PRICE_ADJUSTMENTS---------------------------

19449: RAISE G_EXCEPTION_HALT_VALIDATION;
19450: End If;
19451: End;
19452: ---------------------------------------------------------------------
19453: -----------Copy of OKC_PRICE_ADJUSTMENTS---------------------------
19454: Begin
19455: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19456: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19457: FND_LOG.string(FND_LOG.level_statement

Line 19458: ,l_module_name||'.copy_okc_price_adjustments'

19454: Begin
19455: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19456: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19457: FND_LOG.string(FND_LOG.level_statement
19458: ,l_module_name||'.copy_okc_price_adjustments'
19459: ,'Before call to copy_okc_price_adjustments'
19460: );
19461: END IF;
19462: END IF;

Line 19459: ,'Before call to copy_okc_price_adjustments'

19455: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19456: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19457: FND_LOG.string(FND_LOG.level_statement
19458: ,l_module_name||'.copy_okc_price_adjustments'
19459: ,'Before call to copy_okc_price_adjustments'
19460: );
19461: END IF;
19462: END IF;
19463:

Line 19464: copy_okc_price_adjustments(P_From_Chr_ID => P_From_Chr_ID

19460: );
19461: END IF;
19462: END IF;
19463:
19464: copy_okc_price_adjustments(P_From_Chr_ID => P_From_Chr_ID
19465: ,P_To_Chr_ID => P_To_Chr_ID
19466: ,P_Partial_Copy_YN => 'N'
19467: ,x_return_status => l_return_status);
19468:

Line 19472: ,l_module_name||'.copy_okc_price_adjustments'

19468:
19469: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19470: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19471: FND_LOG.string(FND_LOG.level_statement
19472: ,l_module_name||'.copy_okc_price_adjustments'
19473: ,'After call to copy_okc_price_adjustments: x_return_status:'||l_return_status
19474: ||' '||SQLERRM
19475: );
19476: END IF;

Line 19473: ,'After call to copy_okc_price_adjustments: x_return_status:'||l_return_status

19469: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19470: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19471: FND_LOG.string(FND_LOG.level_statement
19472: ,l_module_name||'.copy_okc_price_adjustments'
19473: ,'After call to copy_okc_price_adjustments: x_return_status:'||l_return_status
19474: ||' '||SQLERRM
19475: );
19476: END IF;
19477: END IF;

Line 24780: -----------Copy of OKC_PRICE_ADJUSTMENTS---------------------------

24776: RAISE G_EXCEPTION_HALT_VALIDATION;
24777: End If;
24778: End;
24779: ---------------------------------------------------------------------
24780: -----------Copy of OKC_PRICE_ADJUSTMENTS---------------------------
24781: Begin
24782: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24783: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24784: FND_LOG.string(FND_LOG.level_statement

Line 24785: ,l_module_name||'.copy_okc_price_adjustments'

24781: Begin
24782: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24783: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24784: FND_LOG.string(FND_LOG.level_statement
24785: ,l_module_name||'.copy_okc_price_adjustments'
24786: ,'Before call to copy_okc_price_adjustments'
24787: );
24788: END IF;
24789: END IF;

Line 24786: ,'Before call to copy_okc_price_adjustments'

24782: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24783: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24784: FND_LOG.string(FND_LOG.level_statement
24785: ,l_module_name||'.copy_okc_price_adjustments'
24786: ,'Before call to copy_okc_price_adjustments'
24787: );
24788: END IF;
24789: END IF;
24790:

Line 24791: copy_okc_price_adjustments(P_From_Chr_ID => P_From_Chr_ID

24787: );
24788: END IF;
24789: END IF;
24790:
24791: copy_okc_price_adjustments(P_From_Chr_ID => P_From_Chr_ID
24792: ,P_To_Chr_ID => P_To_Chr_ID
24793: ,P_Partial_Copy_YN => 'Y'
24794: ,P_Target_Contract_New_YN => P_Target_Contract_New_YN
24795: ,P_Lines_Count => P_Lines_Tbl.COUNT

Line 24801: ,l_module_name||'.copy_okc_price_adjustments'

24797:
24798: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24799: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24800: FND_LOG.string(FND_LOG.level_statement
24801: ,l_module_name||'.copy_okc_price_adjustments'
24802: ,'After call to copy_okc_price_adjustments: x_return_status:'||l_return_status
24803: ||' '||SQLERRM
24804: );
24805: END IF;

Line 24802: ,'After call to copy_okc_price_adjustments: x_return_status:'||l_return_status

24798: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24799: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24800: FND_LOG.string(FND_LOG.level_statement
24801: ,l_module_name||'.copy_okc_price_adjustments'
24802: ,'After call to copy_okc_price_adjustments: x_return_status:'||l_return_status
24803: ||' '||SQLERRM
24804: );
24805: END IF;
24806: END IF;