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 1620: FROM okc_price_adjustments_V

1616: WHERE chr_id = p_from_chr_id;
1617:
1618: CURSOR c_patv IS
1619: SELECT id
1620: FROM okc_price_adjustments_V
1621: WHERE chr_id = p_from_chr_id
1622: AND cle_id IS NULL; -- Added for Bug 2027165
1623:
1624: -- cursor for goverances

Line 3688: FROM OKC_PRICE_ADJUSTMENTS_V

3684: ATTRIBUTE14,
3685: ATTRIBUTE15,
3686: LAST_UPDATE_LOGIN,
3687: REBATE_TRANSACTION_TYPE_CODE
3688: FROM OKC_PRICE_ADJUSTMENTS_V
3689: WHERE ID = p_pat_id;
3690: BEGIN
3691: OPEN c_patv_rec;
3692: FETCH c_patv_rec

Line 6975: -- copy_okc_price_adjustments

6971:
6972: End copy_okc_price_att_values;
6973:
6974: --===================================================
6975: -- copy_okc_price_adjustments
6976: -- Parameters: P_From_Chr_ID : Header ID of source contract
6977: -- P_To_Chr_ID : Header ID of target contract
6978: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
6979: -- or as part of component copy from UI (value = 'Y')

Line 6999: PROCEDURE copy_okc_price_adjustments(P_From_Chr_ID IN NUMBER

6995: -- End If
6996: -- End If
6997:
6998: --====================================================
6999: PROCEDURE copy_okc_price_adjustments(P_From_Chr_ID IN NUMBER
7000: ,P_To_Chr_ID IN NUMBER
7001: ,P_Partial_Copy_YN IN VARCHAR2
7002: ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
7003: ,P_Lines_Count IN NUMBER DEFAULT 0

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

7002: ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
7003: ,P_Lines_Count IN NUMBER DEFAULT 0
7004: ,x_return_status OUT NOCOPY VARCHAR2) IS
7005:
7006: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKC_PRICE_ADJUSTMENTS';
7007: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
7008:
7009: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
7010:

Line 7078: OKC_PRICE_ADJUSTMENTS okcPA

7074: ,okcPA.PRORATION_TYPE_CODE AS okcPA_PRORATION_TYPE_CODE
7075: ,okcPA.INCLUDE_ON_RETURNS_FLAG AS okcPA_INCLUDE_ON_RETURNS_FLAG
7076: ,okcPA.REBATE_TRANSACTION_TYPE_CODE AS okcPA_REBATE_TRXN_TYPE_CODE
7077: FROM
7078: OKC_PRICE_ADJUSTMENTS okcPA
7079: ,OKC_K_HEADERS_B okcH
7080: WHERE okcPA.CHR_ID = okcH.ORIG_SYSTEM_ID1
7081: and okcH.ID = P_To_Chr_ID
7082: and okcPA.CLE_ID is NULL

Line 7151: OKC_PRICE_ADJUSTMENTS okcPA

7147: ,okcPA.PRORATION_TYPE_CODE AS okcPA_PRORATION_TYPE_CODE
7148: ,okcPA.INCLUDE_ON_RETURNS_FLAG AS okcPA_INCLUDE_ON_RETURNS_FLAG
7149: ,okcPA.REBATE_TRANSACTION_TYPE_CODE AS okcPA_REBATE_TRXN_TYPE_CODE
7150: FROM
7151: OKC_PRICE_ADJUSTMENTS okcPA
7152: ,OKC_K_LINES_B okcB
7153: WHERE okcPA.CLE_ID = okcB.ORIG_SYSTEM_ID1
7154: AND okcB.DNZ_CHR_ID = P_To_Chr_ID;
7155:

Line 7227: OKC_PRICE_ADJUSTMENTS okcPA

7223: ,okcPA.PRORATION_TYPE_CODE AS okcPA_PRORATION_TYPE_CODE
7224: ,okcPA.INCLUDE_ON_RETURNS_FLAG AS okcPA_INCLUDE_ON_RETURNS_FLAG
7225: ,okcPA.REBATE_TRANSACTION_TYPE_CODE AS okcPA_REBATE_TRXN_TYPE_CODE
7226: FROM
7227: OKC_PRICE_ADJUSTMENTS okcPA
7228: ,OKC_K_HEADERS_B okcH
7229: WHERE okcPA.CHR_ID = okcH.ORIG_SYSTEM_ID1
7230: and okcH.ID = P_To_Chr_ID
7231: and okcPA.CLE_ID is NULL

Line 7300: OKC_PRICE_ADJUSTMENTS okcPA

7296: ,okcPA.PRORATION_TYPE_CODE AS okcPA_PRORATION_TYPE_CODE
7297: ,okcPA.INCLUDE_ON_RETURNS_FLAG AS okcPA_INCLUDE_ON_RETURNS_FLAG
7298: ,okcPA.REBATE_TRANSACTION_TYPE_CODE AS okcPA_REBATE_TRXN_TYPE_CODE
7299: FROM
7300: OKC_PRICE_ADJUSTMENTS okcPA
7301: ,OKC_K_LINES_B_TEMP okcBT
7302: WHERE okcPA.CLE_ID = okcBT.ORIG_SYSTEM_ID1
7303: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID;
7304:

Line 7376: OKC_PRICE_ADJUSTMENTS okcPA

7372: ,okcPA.PRORATION_TYPE_CODE AS okcPA_PRORATION_TYPE_CODE
7373: ,okcPA.INCLUDE_ON_RETURNS_FLAG AS okcPA_INCLUDE_ON_RETURNS_FLAG
7374: ,okcPA.REBATE_TRANSACTION_TYPE_CODE AS okcPA_REBATE_TRXN_TYPE_CODE
7375: FROM
7376: OKC_PRICE_ADJUSTMENTS okcPA
7377: ,OKC_K_HEADERS_B okcH
7378: WHERE okcPA.CHR_ID = okcH.ORIG_SYSTEM_ID1
7379: and okcH.ID = P_To_Chr_ID
7380: and okcPA.CLE_ID is NULL

Line 7456: OKC_PRICE_ADJUSTMENTS okcPA

7452: ,okcPA.PRORATION_TYPE_CODE AS okcPA_PRORATION_TYPE_CODE
7453: ,okcPA.INCLUDE_ON_RETURNS_FLAG AS okcPA_INCLUDE_ON_RETURNS_FLAG
7454: ,okcPA.REBATE_TRANSACTION_TYPE_CODE AS okcPA_REBATE_TRXN_TYPE_CODE
7455: FROM
7456: OKC_PRICE_ADJUSTMENTS okcPA
7457: ,OKC_K_LINES_B_TEMP okcBT
7458: WHERE okcPA.CLE_ID = okcBT.ORIG_SYSTEM_ID1
7459: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID;
7460:

Line 7812: INSERT INTO OKC_PRICE_ADJUSTMENTS(

7808:
7809:
7810:
7811: FORALL i in okcPARecTab.OkcPA_NewID.FIRST .. okcPARecTab.OkcPA_NewID.LAST
7812: INSERT INTO OKC_PRICE_ADJUSTMENTS(
7813: ID
7814: ,PAT_ID
7815: ,CHR_ID
7816: ,CLE_ID

Line 7994: End copy_okc_price_adjustments;

7990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7991: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
7992: RAISE;
7993:
7994: End copy_okc_price_adjustments;
7995:
7996:
7997: --===================================================
7998: -- copy_okc_k_party_roles_b

Line 19600: -----------Copy of OKC_PRICE_ADJUSTMENTS---------------------------

19596: RAISE G_EXCEPTION_HALT_VALIDATION;
19597: End If;
19598: End;
19599: ---------------------------------------------------------------------
19600: -----------Copy of OKC_PRICE_ADJUSTMENTS---------------------------
19601: Begin
19602: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19603: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19604: FND_LOG.string(FND_LOG.level_statement

Line 19605: ,l_module_name||'.copy_okc_price_adjustments'

19601: Begin
19602: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19603: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19604: FND_LOG.string(FND_LOG.level_statement
19605: ,l_module_name||'.copy_okc_price_adjustments'
19606: ,'Before call to copy_okc_price_adjustments'
19607: );
19608: END IF;
19609: END IF;

Line 19606: ,'Before call to copy_okc_price_adjustments'

19602: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19603: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19604: FND_LOG.string(FND_LOG.level_statement
19605: ,l_module_name||'.copy_okc_price_adjustments'
19606: ,'Before call to copy_okc_price_adjustments'
19607: );
19608: END IF;
19609: END IF;
19610:

Line 19611: copy_okc_price_adjustments(P_From_Chr_ID => P_From_Chr_ID

19607: );
19608: END IF;
19609: END IF;
19610:
19611: copy_okc_price_adjustments(P_From_Chr_ID => P_From_Chr_ID
19612: ,P_To_Chr_ID => P_To_Chr_ID
19613: ,P_Partial_Copy_YN => 'N'
19614: ,x_return_status => l_return_status);
19615:

Line 19619: ,l_module_name||'.copy_okc_price_adjustments'

19615:
19616: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19617: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19618: FND_LOG.string(FND_LOG.level_statement
19619: ,l_module_name||'.copy_okc_price_adjustments'
19620: ,'After call to copy_okc_price_adjustments: x_return_status:'||l_return_status
19621: ||' '||SQLERRM
19622: );
19623: END IF;

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

19616: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19617: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19618: FND_LOG.string(FND_LOG.level_statement
19619: ,l_module_name||'.copy_okc_price_adjustments'
19620: ,'After call to copy_okc_price_adjustments: x_return_status:'||l_return_status
19621: ||' '||SQLERRM
19622: );
19623: END IF;
19624: END IF;

Line 24975: -----------Copy of OKC_PRICE_ADJUSTMENTS---------------------------

24971: RAISE G_EXCEPTION_HALT_VALIDATION;
24972: End If;
24973: End;
24974: ---------------------------------------------------------------------
24975: -----------Copy of OKC_PRICE_ADJUSTMENTS---------------------------
24976: Begin
24977: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24978: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24979: FND_LOG.string(FND_LOG.level_statement

Line 24980: ,l_module_name||'.copy_okc_price_adjustments'

24976: Begin
24977: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24978: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24979: FND_LOG.string(FND_LOG.level_statement
24980: ,l_module_name||'.copy_okc_price_adjustments'
24981: ,'Before call to copy_okc_price_adjustments'
24982: );
24983: END IF;
24984: END IF;

Line 24981: ,'Before call to copy_okc_price_adjustments'

24977: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24978: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24979: FND_LOG.string(FND_LOG.level_statement
24980: ,l_module_name||'.copy_okc_price_adjustments'
24981: ,'Before call to copy_okc_price_adjustments'
24982: );
24983: END IF;
24984: END IF;
24985:

Line 24986: copy_okc_price_adjustments(P_From_Chr_ID => P_From_Chr_ID

24982: );
24983: END IF;
24984: END IF;
24985:
24986: copy_okc_price_adjustments(P_From_Chr_ID => P_From_Chr_ID
24987: ,P_To_Chr_ID => P_To_Chr_ID
24988: ,P_Partial_Copy_YN => 'Y'
24989: ,P_Target_Contract_New_YN => P_Target_Contract_New_YN
24990: ,P_Lines_Count => P_Lines_Tbl.COUNT

Line 24996: ,l_module_name||'.copy_okc_price_adjustments'

24992:
24993: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24994: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24995: FND_LOG.string(FND_LOG.level_statement
24996: ,l_module_name||'.copy_okc_price_adjustments'
24997: ,'After call to copy_okc_price_adjustments: x_return_status:'||l_return_status
24998: ||' '||SQLERRM
24999: );
25000: END IF;

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

24993: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24994: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24995: FND_LOG.string(FND_LOG.level_statement
24996: ,l_module_name||'.copy_okc_price_adjustments'
24997: ,'After call to copy_okc_price_adjustments: x_return_status:'||l_return_status
24998: ||' '||SQLERRM
24999: );
25000: END IF;
25001: END IF;