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_ATT_VALUES

Line 1615: FROM okc_price_att_values_V

1611: l_to_currency VARCHAR2(50);
1612:
1613: CURSOR c_pavv IS
1614: SELECT id
1615: FROM okc_price_att_values_V
1616: WHERE chr_id = p_from_chr_id;
1617:
1618: CURSOR c_patv IS
1619: SELECT id

Line 3380: FROM OKC_PRICE_ATT_VALUES_V

3376: QUALIFIER_ATTRIBUTE97,
3377: QUALIFIER_ATTRIBUTE98,
3378: QUALIFIER_ATTRIBUTE99,
3379: QUALIFIER_ATTRIBUTE100
3380: FROM OKC_PRICE_ATT_VALUES_V
3381: WHERE ID = p_pav_id;
3382: BEGIN
3383: OPEN c_pavv_rec;
3384: FETCH c_pavv_rec

Line 4168: -- copy_okc_price_att_values

4164: End copy_okc_k_lines_tl;
4165:
4166:
4167: --===================================================
4168: -- copy_okc_price_att_values
4169: -- Parameters: P_From_Chr_ID : Header ID of source contract
4170: -- P_To_Chr_ID : Header ID of target contract
4171: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
4172: -- or as part of component copy from UI (value = 'Y')

Line 4191: PROCEDURE copy_okc_price_att_values(P_From_Chr_ID IN NUMBER

4187: -- nothing needs to be copied, no copy needed
4188: -- End If
4189: -- End If
4190: --====================================================
4191: PROCEDURE copy_okc_price_att_values(P_From_Chr_ID IN NUMBER
4192: ,P_To_Chr_ID IN NUMBER
4193: ,P_Partial_Copy_YN IN VARCHAR2
4194: ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
4195: ,P_Lines_Count IN NUMBER DEFAULT 0

Line 4198: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKC_PRICE_ATT_VALUES';

4194: ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
4195: ,P_Lines_Count IN NUMBER DEFAULT 0
4196: ,x_return_status OUT NOCOPY VARCHAR2) IS
4197:
4198: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKC_PRICE_ATT_VALUES';
4199: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
4200:
4201: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4202: CURSOR GetOkcPAVFull IS

Line 4418: OKC_PRICE_ATT_VALUES okcPAV

4414: ,okcPAV.PROGRAM_UPDATE_DATE AS okcPAV_PROGRAM_UPDATE_DATE
4415: ,okcPAV.REQUEST_ID AS okcPAV_REQUEST_ID
4416: ,1 AS okcPAV_OBJECT_VERSION_NUMBER
4417: FROM
4418: OKC_PRICE_ATT_VALUES okcPAV
4419: ,OKC_K_HEADERS_B okcH
4420: WHERE okcPAV.CHR_ID = okcH.ORIG_SYSTEM_ID1
4421: and okcH.ID = P_To_Chr_ID
4422: and okcPAV.CLE_ID is NULL

Line 4640: OKC_PRICE_ATT_VALUES okcPAV

4636: ,okcPAV.PROGRAM_UPDATE_DATE AS okcPAV_PROGRAM_UPDATE_DATE
4637: ,okcPAV.REQUEST_ID AS okcPAV_REQUEST_ID
4638: ,1 AS okcPAV_OBJECT_VERSION_NUMBER
4639: FROM
4640: OKC_PRICE_ATT_VALUES okcPAV
4641: ,OKC_K_LINES_B okcB
4642: WHERE okcPAV.CLE_ID = okcB.ORIG_SYSTEM_ID1
4643: AND okcB.DNZ_CHR_ID = P_To_Chr_ID;
4644:

Line 4864: OKC_PRICE_ATT_VALUES okcPAV

4860: ,okcPAV.PROGRAM_UPDATE_DATE AS okcPAV_PROGRAM_UPDATE_DATE
4861: ,okcPAV.REQUEST_ID AS okcPAV_REQUEST_ID
4862: ,1 AS okcPAV_OBJECT_VERSION_NUMBER
4863: FROM
4864: OKC_PRICE_ATT_VALUES okcPAV
4865: ,OKC_K_HEADERS_B okcH
4866: WHERE okcPAV.CHR_ID = okcH.ORIG_SYSTEM_ID1
4867: and okcH.ID = P_To_Chr_ID
4868: and okcPAV.CLE_ID is NULL

Line 5086: OKC_PRICE_ATT_VALUES okcPAV

5082: ,okcPAV.PROGRAM_UPDATE_DATE AS okcPAV_PROGRAM_UPDATE_DATE
5083: ,okcPAV.REQUEST_ID AS okcPAV_REQUEST_ID
5084: ,1 AS okcPAV_OBJECT_VERSION_NUMBER
5085: FROM
5086: OKC_PRICE_ATT_VALUES okcPAV
5087: ,OKC_K_LINES_B_TEMP okcBT
5088: WHERE okcPAV.CLE_ID = okcBT.ORIG_SYSTEM_ID1
5089: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID;
5090:

Line 5311: OKC_PRICE_ATT_VALUES okcPAV

5307: ,okcPAV.PROGRAM_UPDATE_DATE AS okcPAV_PROGRAM_UPDATE_DATE
5308: ,okcPAV.REQUEST_ID AS okcPAV_REQUEST_ID
5309: ,1 AS okcPAV_OBJECT_VERSION_NUMBER
5310: FROM
5311: OKC_PRICE_ATT_VALUES okcPAV
5312: ,OKC_K_HEADERS_B okcH
5313: WHERE okcPAV.CHR_ID = okcH.ORIG_SYSTEM_ID1
5314: and okcH.ID = P_To_Chr_ID
5315: and okcPAV.CLE_ID is NULL

Line 5539: OKC_PRICE_ATT_VALUES okcPAV

5535: ,okcPAV.PROGRAM_UPDATE_DATE AS okcPAV_PROGRAM_UPDATE_DATE
5536: ,okcPAV.REQUEST_ID AS okcPAV_REQUEST_ID
5537: ,1 AS okcPAV_OBJECT_VERSION_NUMBER
5538: FROM
5539: OKC_PRICE_ATT_VALUES okcPAV
5540: ,OKC_K_LINES_B_TEMP okcBT
5541: WHERE okcPAV.CLE_ID = okcBT.ORIG_SYSTEM_ID1
5542: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID;
5543:

Line 6486: ---Bulk insert into okc_price_att_values---

6482: LIMIT G_BULK_FETCH_LIMIT;
6483: END IF;
6484: END IF;
6485:
6486: ---Bulk insert into okc_price_att_values---
6487: FORALL i in OkcPAVRecTab.OkcPAV_NewID.FIRST .. OkcPAVRecTab.OkcPAV_NewID.LAST
6488: INSERT INTO OKC_PRICE_ATT_VALUES(
6489: ID
6490: ,FLEX_TITLE

Line 6488: INSERT INTO OKC_PRICE_ATT_VALUES(

6484: END IF;
6485:
6486: ---Bulk insert into okc_price_att_values---
6487: FORALL i in OkcPAVRecTab.OkcPAV_NewID.FIRST .. OkcPAVRecTab.OkcPAV_NewID.LAST
6488: INSERT INTO OKC_PRICE_ATT_VALUES(
6489: ID
6490: ,FLEX_TITLE
6491: ,PRICING_CONTEXT
6492: ,PRICING_ATTRIBUTE1

Line 6972: End copy_okc_price_att_values;

6968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6969: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
6970: RAISE;
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

Line 19570: ------------Copy of OKC_PRICE_ATT_VALUES-----------------------------

19566: RAISE G_EXCEPTION_HALT_VALIDATION;
19567: End If;
19568: End;
19569: -------------------------------------------------------------------------
19570: ------------Copy of OKC_PRICE_ATT_VALUES-----------------------------
19571: Begin
19572: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19573: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19574: FND_LOG.string(FND_LOG.level_statement

Line 19575: ,l_module_name||'.copy_okc_price_att_values'

19571: Begin
19572: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19573: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19574: FND_LOG.string(FND_LOG.level_statement
19575: ,l_module_name||'.copy_okc_price_att_values'
19576: ,'Before call to copy_okc_price_att_values'
19577: );
19578: END IF;
19579: END IF;

Line 19576: ,'Before call to copy_okc_price_att_values'

19572: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19573: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19574: FND_LOG.string(FND_LOG.level_statement
19575: ,l_module_name||'.copy_okc_price_att_values'
19576: ,'Before call to copy_okc_price_att_values'
19577: );
19578: END IF;
19579: END IF;
19580: copy_okc_price_att_values(P_From_Chr_ID => P_From_Chr_ID

Line 19580: copy_okc_price_att_values(P_From_Chr_ID => P_From_Chr_ID

19576: ,'Before call to copy_okc_price_att_values'
19577: );
19578: END IF;
19579: END IF;
19580: copy_okc_price_att_values(P_From_Chr_ID => P_From_Chr_ID
19581: ,P_To_Chr_ID => P_To_Chr_ID
19582: ,P_Partial_Copy_YN => 'N'
19583: ,x_return_status => l_return_status);
19584:

Line 19588: ,l_module_name||'.copy_okc_price_att_values'

19584:
19585: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19586: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19587: FND_LOG.string(FND_LOG.level_statement
19588: ,l_module_name||'.copy_okc_price_att_values'
19589: ,'After call to copy_okc_price_att_values: x_return_status:'||l_return_status
19590: ||' '||SQLERRM
19591: );
19592: END IF;

Line 19589: ,'After call to copy_okc_price_att_values: x_return_status:'||l_return_status

19585: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19586: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19587: FND_LOG.string(FND_LOG.level_statement
19588: ,l_module_name||'.copy_okc_price_att_values'
19589: ,'After call to copy_okc_price_att_values: x_return_status:'||l_return_status
19590: ||' '||SQLERRM
19591: );
19592: END IF;
19593: END IF;

Line 24943: ------------Copy of OKC_PRICE_ATT_VALUES-----------------------------

24939: End If;
24940: End;
24941: END IF;
24942: -------------------------------------------------------------------------
24943: ------------Copy of OKC_PRICE_ATT_VALUES-----------------------------
24944: Begin
24945: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24946: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24947: FND_LOG.string(FND_LOG.level_statement

Line 24948: ,l_module_name||'.copy_okc_price_att_values'

24944: Begin
24945: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24946: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24947: FND_LOG.string(FND_LOG.level_statement
24948: ,l_module_name||'.copy_okc_price_att_values'
24949: ,'Before call to copy_okc_price_att_values'
24950: );
24951: END IF;
24952: END IF;

Line 24949: ,'Before call to copy_okc_price_att_values'

24945: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24946: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24947: FND_LOG.string(FND_LOG.level_statement
24948: ,l_module_name||'.copy_okc_price_att_values'
24949: ,'Before call to copy_okc_price_att_values'
24950: );
24951: END IF;
24952: END IF;
24953: copy_okc_price_att_values(P_From_Chr_ID => P_From_Chr_ID

Line 24953: copy_okc_price_att_values(P_From_Chr_ID => P_From_Chr_ID

24949: ,'Before call to copy_okc_price_att_values'
24950: );
24951: END IF;
24952: END IF;
24953: copy_okc_price_att_values(P_From_Chr_ID => P_From_Chr_ID
24954: ,P_To_Chr_ID => P_To_Chr_ID
24955: ,P_Partial_Copy_YN => 'Y'
24956: ,P_Target_Contract_New_YN => P_Target_Contract_New_YN
24957: ,P_Lines_Count => P_Lines_Tbl.COUNT

Line 24963: ,l_module_name||'.copy_okc_price_att_values'

24959:
24960: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24961: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24962: FND_LOG.string(FND_LOG.level_statement
24963: ,l_module_name||'.copy_okc_price_att_values'
24964: ,'After call to copy_okc_price_att_values: x_return_status:'||l_return_status
24965: ||' '||SQLERRM
24966: );
24967: END IF;

Line 24964: ,'After call to copy_okc_price_att_values: x_return_status:'||l_return_status

24960: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24961: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24962: FND_LOG.string(FND_LOG.level_statement
24963: ,l_module_name||'.copy_okc_price_att_values'
24964: ,'After call to copy_okc_price_att_values: x_return_status:'||l_return_status
24965: ||' '||SQLERRM
24966: );
24967: END IF;
24968: END IF;