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 1608: FROM okc_price_att_values_V

1604: l_to_entity_name VARCHAR2(30);
1605:
1606: CURSOR c_pavv IS
1607: SELECT id
1608: FROM okc_price_att_values_V
1609: WHERE chr_id = p_from_chr_id;
1610:
1611: CURSOR c_patv IS
1612: SELECT id

Line 3343: FROM OKC_PRICE_ATT_VALUES_V

3339: QUALIFIER_ATTRIBUTE97,
3340: QUALIFIER_ATTRIBUTE98,
3341: QUALIFIER_ATTRIBUTE99,
3342: QUALIFIER_ATTRIBUTE100
3343: FROM OKC_PRICE_ATT_VALUES_V
3344: WHERE ID = p_pav_id;
3345: BEGIN
3346: OPEN c_pavv_rec;
3347: FETCH c_pavv_rec

Line 4131: -- copy_okc_price_att_values

4127: End copy_okc_k_lines_tl;
4128:
4129:
4130: --===================================================
4131: -- copy_okc_price_att_values
4132: -- Parameters: P_From_Chr_ID : Header ID of source contract
4133: -- P_To_Chr_ID : Header ID of target contract
4134: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
4135: -- or as part of component copy from UI (value = 'Y')

Line 4154: PROCEDURE copy_okc_price_att_values(P_From_Chr_ID IN NUMBER

4150: -- nothing needs to be copied, no copy needed
4151: -- End If
4152: -- End If
4153: --====================================================
4154: PROCEDURE copy_okc_price_att_values(P_From_Chr_ID IN NUMBER
4155: ,P_To_Chr_ID IN NUMBER
4156: ,P_Partial_Copy_YN IN VARCHAR2
4157: ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
4158: ,P_Lines_Count IN NUMBER DEFAULT 0

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

4157: ,P_Target_Contract_New_YN IN VARCHAR2 DEFAULT 'Y'
4158: ,P_Lines_Count IN NUMBER DEFAULT 0
4159: ,x_return_status OUT NOCOPY VARCHAR2) IS
4160:
4161: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKC_PRICE_ATT_VALUES';
4162: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
4163:
4164: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4165: CURSOR GetOkcPAVFull IS

Line 4381: OKC_PRICE_ATT_VALUES okcPAV

4377: ,okcPAV.PROGRAM_UPDATE_DATE AS okcPAV_PROGRAM_UPDATE_DATE
4378: ,okcPAV.REQUEST_ID AS okcPAV_REQUEST_ID
4379: ,1 AS okcPAV_OBJECT_VERSION_NUMBER
4380: FROM
4381: OKC_PRICE_ATT_VALUES okcPAV
4382: ,OKC_K_HEADERS_B okcH
4383: WHERE okcPAV.CHR_ID = okcH.ORIG_SYSTEM_ID1
4384: and okcH.ID = P_To_Chr_ID
4385: and okcPAV.CLE_ID is NULL

Line 4603: OKC_PRICE_ATT_VALUES okcPAV

4599: ,okcPAV.PROGRAM_UPDATE_DATE AS okcPAV_PROGRAM_UPDATE_DATE
4600: ,okcPAV.REQUEST_ID AS okcPAV_REQUEST_ID
4601: ,1 AS okcPAV_OBJECT_VERSION_NUMBER
4602: FROM
4603: OKC_PRICE_ATT_VALUES okcPAV
4604: ,OKC_K_LINES_B okcB
4605: WHERE okcPAV.CLE_ID = okcB.ORIG_SYSTEM_ID1
4606: AND okcB.DNZ_CHR_ID = P_To_Chr_ID;
4607:

Line 4827: OKC_PRICE_ATT_VALUES okcPAV

4823: ,okcPAV.PROGRAM_UPDATE_DATE AS okcPAV_PROGRAM_UPDATE_DATE
4824: ,okcPAV.REQUEST_ID AS okcPAV_REQUEST_ID
4825: ,1 AS okcPAV_OBJECT_VERSION_NUMBER
4826: FROM
4827: OKC_PRICE_ATT_VALUES okcPAV
4828: ,OKC_K_HEADERS_B okcH
4829: WHERE okcPAV.CHR_ID = okcH.ORIG_SYSTEM_ID1
4830: and okcH.ID = P_To_Chr_ID
4831: and okcPAV.CLE_ID is NULL

Line 5049: OKC_PRICE_ATT_VALUES okcPAV

5045: ,okcPAV.PROGRAM_UPDATE_DATE AS okcPAV_PROGRAM_UPDATE_DATE
5046: ,okcPAV.REQUEST_ID AS okcPAV_REQUEST_ID
5047: ,1 AS okcPAV_OBJECT_VERSION_NUMBER
5048: FROM
5049: OKC_PRICE_ATT_VALUES okcPAV
5050: ,OKC_K_LINES_B_TEMP okcBT
5051: WHERE okcPAV.CLE_ID = okcBT.ORIG_SYSTEM_ID1
5052: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID;
5053:

Line 5274: OKC_PRICE_ATT_VALUES okcPAV

5270: ,okcPAV.PROGRAM_UPDATE_DATE AS okcPAV_PROGRAM_UPDATE_DATE
5271: ,okcPAV.REQUEST_ID AS okcPAV_REQUEST_ID
5272: ,1 AS okcPAV_OBJECT_VERSION_NUMBER
5273: FROM
5274: OKC_PRICE_ATT_VALUES okcPAV
5275: ,OKC_K_HEADERS_B okcH
5276: WHERE okcPAV.CHR_ID = okcH.ORIG_SYSTEM_ID1
5277: and okcH.ID = P_To_Chr_ID
5278: and okcPAV.CLE_ID is NULL

Line 5502: OKC_PRICE_ATT_VALUES okcPAV

5498: ,okcPAV.PROGRAM_UPDATE_DATE AS okcPAV_PROGRAM_UPDATE_DATE
5499: ,okcPAV.REQUEST_ID AS okcPAV_REQUEST_ID
5500: ,1 AS okcPAV_OBJECT_VERSION_NUMBER
5501: FROM
5502: OKC_PRICE_ATT_VALUES okcPAV
5503: ,OKC_K_LINES_B_TEMP okcBT
5504: WHERE okcPAV.CLE_ID = okcBT.ORIG_SYSTEM_ID1
5505: AND okcBT.DNZ_CHR_ID = P_To_Chr_ID;
5506:

Line 6449: ---Bulk insert into okc_price_att_values---

6445: LIMIT G_BULK_FETCH_LIMIT;
6446: END IF;
6447: END IF;
6448:
6449: ---Bulk insert into okc_price_att_values---
6450: FORALL i in OkcPAVRecTab.OkcPAV_NewID.FIRST .. OkcPAVRecTab.OkcPAV_NewID.LAST
6451: INSERT INTO OKC_PRICE_ATT_VALUES(
6452: ID
6453: ,FLEX_TITLE

Line 6451: INSERT INTO OKC_PRICE_ATT_VALUES(

6447: END IF;
6448:
6449: ---Bulk insert into okc_price_att_values---
6450: FORALL i in OkcPAVRecTab.OkcPAV_NewID.FIRST .. OkcPAVRecTab.OkcPAV_NewID.LAST
6451: INSERT INTO OKC_PRICE_ATT_VALUES(
6452: ID
6453: ,FLEX_TITLE
6454: ,PRICING_CONTEXT
6455: ,PRICING_ATTRIBUTE1

Line 6935: End copy_okc_price_att_values;

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

Line 19423: ------------Copy of OKC_PRICE_ATT_VALUES-----------------------------

19419: RAISE G_EXCEPTION_HALT_VALIDATION;
19420: End If;
19421: End;
19422: -------------------------------------------------------------------------
19423: ------------Copy of OKC_PRICE_ATT_VALUES-----------------------------
19424: Begin
19425: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19426: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19427: FND_LOG.string(FND_LOG.level_statement

Line 19428: ,l_module_name||'.copy_okc_price_att_values'

19424: Begin
19425: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19426: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19427: FND_LOG.string(FND_LOG.level_statement
19428: ,l_module_name||'.copy_okc_price_att_values'
19429: ,'Before call to copy_okc_price_att_values'
19430: );
19431: END IF;
19432: END IF;

Line 19429: ,'Before call to copy_okc_price_att_values'

19425: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19426: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19427: FND_LOG.string(FND_LOG.level_statement
19428: ,l_module_name||'.copy_okc_price_att_values'
19429: ,'Before call to copy_okc_price_att_values'
19430: );
19431: END IF;
19432: END IF;
19433: copy_okc_price_att_values(P_From_Chr_ID => P_From_Chr_ID

Line 19433: copy_okc_price_att_values(P_From_Chr_ID => P_From_Chr_ID

19429: ,'Before call to copy_okc_price_att_values'
19430: );
19431: END IF;
19432: END IF;
19433: copy_okc_price_att_values(P_From_Chr_ID => P_From_Chr_ID
19434: ,P_To_Chr_ID => P_To_Chr_ID
19435: ,P_Partial_Copy_YN => 'N'
19436: ,x_return_status => l_return_status);
19437:

Line 19441: ,l_module_name||'.copy_okc_price_att_values'

19437:
19438: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19439: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19440: FND_LOG.string(FND_LOG.level_statement
19441: ,l_module_name||'.copy_okc_price_att_values'
19442: ,'After call to copy_okc_price_att_values: x_return_status:'||l_return_status
19443: ||' '||SQLERRM
19444: );
19445: END IF;

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

19438: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19439: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19440: FND_LOG.string(FND_LOG.level_statement
19441: ,l_module_name||'.copy_okc_price_att_values'
19442: ,'After call to copy_okc_price_att_values: x_return_status:'||l_return_status
19443: ||' '||SQLERRM
19444: );
19445: END IF;
19446: END IF;

Line 24748: ------------Copy of OKC_PRICE_ATT_VALUES-----------------------------

24744: End If;
24745: End;
24746: END IF;
24747: -------------------------------------------------------------------------
24748: ------------Copy of OKC_PRICE_ATT_VALUES-----------------------------
24749: Begin
24750: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24751: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24752: FND_LOG.string(FND_LOG.level_statement

Line 24753: ,l_module_name||'.copy_okc_price_att_values'

24749: Begin
24750: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24751: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24752: FND_LOG.string(FND_LOG.level_statement
24753: ,l_module_name||'.copy_okc_price_att_values'
24754: ,'Before call to copy_okc_price_att_values'
24755: );
24756: END IF;
24757: END IF;

Line 24754: ,'Before call to copy_okc_price_att_values'

24750: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24751: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24752: FND_LOG.string(FND_LOG.level_statement
24753: ,l_module_name||'.copy_okc_price_att_values'
24754: ,'Before call to copy_okc_price_att_values'
24755: );
24756: END IF;
24757: END IF;
24758: copy_okc_price_att_values(P_From_Chr_ID => P_From_Chr_ID

Line 24758: copy_okc_price_att_values(P_From_Chr_ID => P_From_Chr_ID

24754: ,'Before call to copy_okc_price_att_values'
24755: );
24756: END IF;
24757: END IF;
24758: copy_okc_price_att_values(P_From_Chr_ID => P_From_Chr_ID
24759: ,P_To_Chr_ID => P_To_Chr_ID
24760: ,P_Partial_Copy_YN => 'Y'
24761: ,P_Target_Contract_New_YN => P_Target_Contract_New_YN
24762: ,P_Lines_Count => P_Lines_Tbl.COUNT

Line 24768: ,l_module_name||'.copy_okc_price_att_values'

24764:
24765: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24766: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24767: FND_LOG.string(FND_LOG.level_statement
24768: ,l_module_name||'.copy_okc_price_att_values'
24769: ,'After call to copy_okc_price_att_values: x_return_status:'||l_return_status
24770: ||' '||SQLERRM
24771: );
24772: END IF;

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

24765: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24766: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24767: FND_LOG.string(FND_LOG.level_statement
24768: ,l_module_name||'.copy_okc_price_att_values'
24769: ,'After call to copy_okc_price_att_values: x_return_status:'||l_return_status
24770: ||' '||SQLERRM
24771: );
24772: END IF;
24773: END IF;