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_CONTACTS

Line 876: FROM okc_contacts_v

872: WHERE id = p_id;
873:
874: CURSOR c_ctcv IS
875: SELECT id
876: FROM okc_contacts_v
877: WHERE cpl_id = p_cpl_id;
878:
879: BEGIN
880: x_return_status := l_return_status;

Line 2722: FROM OKC_CONTACTS_V

2718: START_DATE,
2719: END_DATE,
2720: PRIMARY_YN -- Bug 2374325
2721:
2722: FROM OKC_CONTACTS_V
2723: WHERE ID = p_ctc_id;
2724:
2725: BEGIN
2726: OPEN c_ctcv_rec;

Line 8643: -- copy_okc_contacts

8639: End copy_okc_k_party_roles_tl;
8640:
8641:
8642: --===================================================
8643: -- copy_okc_contacts
8644: -- Parameters: P_From_Chr_ID : Header ID of source contract
8645: -- P_To_Chr_ID : Header ID of target contract
8646: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
8647: -- or as part of component copy from UI (value = 'Y')

Line 8649: PROCEDURE copy_okc_contacts(P_From_Chr_ID IN NUMBER

8645: -- P_To_Chr_ID : Header ID of target contract
8646: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
8647: -- or as part of component copy from UI (value = 'Y')
8648: --====================================================
8649: PROCEDURE copy_okc_contacts(P_From_Chr_ID IN NUMBER
8650: ,P_To_Chr_ID IN NUMBER
8651: ,P_Partial_Copy_YN IN VARCHAR2
8652: ,P_Lines_Count IN NUMBER DEFAULT 0
8653: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 8655: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKC_CONTACTS';

8651: ,P_Partial_Copy_YN IN VARCHAR2
8652: ,P_Lines_Count IN NUMBER DEFAULT 0
8653: ,x_return_status OUT NOCOPY VARCHAR2) IS
8654:
8655: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKC_CONTACTS';
8656: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
8657:
8658: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8659: CURSOR GetOkcCFull IS

Line 8694: OKC_CONTACTS okcC

8690: , okcC.PRIMARY_YN AS okcC_PRIMARY_YN
8691: , okcC.RESOURCE_CLASS AS okcC_RESOURCE_CLASS
8692: , okcC.SALES_GROUP_ID AS okcC_SALES_GROUP_ID
8693: FROM
8694: OKC_CONTACTS okcC
8695: ,OKC_K_PARTY_ROLES_B okcPRB
8696: WHERE okcC.CPL_ID = okcPRB.ORIG_SYSTEM_ID1
8697: AND okcPRB.DNZ_CHR_ID = P_To_Chr_ID
8698: AND okcC.DNZ_CHR_ID = P_From_Chr_ID;

Line 8735: OKC_CONTACTS okcC

8731: , okcC.PRIMARY_YN AS okcC_PRIMARY_YN
8732: , okcC.RESOURCE_CLASS AS okcC_RESOURCE_CLASS
8733: , okcC.SALES_GROUP_ID AS okcC_SALES_GROUP_ID
8734: FROM
8735: OKC_CONTACTS okcC
8736: ,OKC_K_PARTY_ROLES_B okcPRB
8737: ,OKC_K_LINES_B_TEMP okcBT
8738: WHERE okcC.CPL_ID = okcPRB.ORIG_SYSTEM_ID1
8739: AND okcPRB.DNZ_CHR_ID = okcBT.DNZ_CHR_ID

Line 8826: INSERT INTO OKC_CONTACTS(

8822: End If;
8823:
8824:
8825: FORALL i IN OkcCRecTab.OkcC_NewID.FIRST .. OkcCRecTab.OkcC_NewID.LAST
8826: INSERT INTO OKC_CONTACTS(
8827: ID
8828: , CPL_ID
8829: , CRO_CODE
8830: , DNZ_CHR_ID

Line 8928: End copy_okc_contacts;

8924: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
8925: RAISE;
8926:
8927:
8928: End copy_okc_contacts;
8929:
8930:
8931: --===================================================
8932: -- copy_okc_operation_lines

Line 19394: ------------Copy of OKC_CONTACTS--------------------------------------

19390: RAISE G_EXCEPTION_HALT_VALIDATION;
19391: End If;
19392: End;
19393: ----------------------------------------------------------------------
19394: ------------Copy of OKC_CONTACTS--------------------------------------
19395: Begin
19396: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19397: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19398: FND_LOG.string(FND_LOG.level_statement

Line 19399: ,l_module_name||'.copy_okc_contacts'

19395: Begin
19396: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19397: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19398: FND_LOG.string(FND_LOG.level_statement
19399: ,l_module_name||'.copy_okc_contacts'
19400: ,'Before call to copy_okc_contacts'
19401: );
19402: END IF;
19403: END IF;

Line 19400: ,'Before call to copy_okc_contacts'

19396: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19397: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19398: FND_LOG.string(FND_LOG.level_statement
19399: ,l_module_name||'.copy_okc_contacts'
19400: ,'Before call to copy_okc_contacts'
19401: );
19402: END IF;
19403: END IF;
19404: copy_okc_contacts(P_From_Chr_ID => P_From_Chr_ID

Line 19404: copy_okc_contacts(P_From_Chr_ID => P_From_Chr_ID

19400: ,'Before call to copy_okc_contacts'
19401: );
19402: END IF;
19403: END IF;
19404: copy_okc_contacts(P_From_Chr_ID => P_From_Chr_ID
19405: ,P_To_Chr_ID => P_To_Chr_ID
19406: ,P_Partial_Copy_YN => 'N'
19407: ,x_return_status => l_return_status);
19408:

Line 19412: ,l_module_name||'.copy_okc_contacts'

19408:
19409: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19410: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19411: FND_LOG.string(FND_LOG.level_statement
19412: ,l_module_name||'.copy_okc_contacts'
19413: ,'After call to copy_okc_contacts: x_return_status:'||l_return_status
19414: ||' '||SQLERRM
19415: );
19416: END IF;

Line 19413: ,'After call to copy_okc_contacts: x_return_status:'||l_return_status

19409: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19410: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19411: FND_LOG.string(FND_LOG.level_statement
19412: ,l_module_name||'.copy_okc_contacts'
19413: ,'After call to copy_okc_contacts: x_return_status:'||l_return_status
19414: ||' '||SQLERRM
19415: );
19416: END IF;
19417: END IF;

Line 24716: ------------Copy of OKC_CONTACTS--------------------------------------

24712: End If;
24713: End;
24714: END IF;
24715: ----------------------------------------------------------------------
24716: ------------Copy of OKC_CONTACTS--------------------------------------
24717: IF (P_Lines_Tbl.COUNT > 0) then
24718: Begin
24719: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24720: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN

Line 24722: ,l_module_name||'.copy_okc_contacts'

24718: Begin
24719: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24720: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24721: FND_LOG.string(FND_LOG.level_statement
24722: ,l_module_name||'.copy_okc_contacts'
24723: ,'Before call to copy_okc_contacts'
24724: );
24725: END IF;
24726: END IF;

Line 24723: ,'Before call to copy_okc_contacts'

24719: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24720: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24721: FND_LOG.string(FND_LOG.level_statement
24722: ,l_module_name||'.copy_okc_contacts'
24723: ,'Before call to copy_okc_contacts'
24724: );
24725: END IF;
24726: END IF;
24727: copy_okc_contacts(P_From_Chr_ID => P_From_Chr_ID

Line 24727: copy_okc_contacts(P_From_Chr_ID => P_From_Chr_ID

24723: ,'Before call to copy_okc_contacts'
24724: );
24725: END IF;
24726: END IF;
24727: copy_okc_contacts(P_From_Chr_ID => P_From_Chr_ID
24728: ,P_To_Chr_ID => P_To_Chr_ID
24729: ,P_Partial_Copy_YN => 'Y'
24730: ,P_Lines_Count => P_Lines_Tbl.COUNT
24731: ,x_return_status => l_return_status);

Line 24736: ,l_module_name||'.copy_okc_contacts'

24732:
24733: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24734: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24735: FND_LOG.string(FND_LOG.level_statement
24736: ,l_module_name||'.copy_okc_contacts'
24737: ,'After call to copy_okc_contacts: x_return_status:'||l_return_status
24738: ||' '||SQLERRM
24739: );
24740: END IF;

Line 24737: ,'After call to copy_okc_contacts: x_return_status:'||l_return_status

24733: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24734: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24735: FND_LOG.string(FND_LOG.level_statement
24736: ,l_module_name||'.copy_okc_contacts'
24737: ,'After call to copy_okc_contacts: x_return_status:'||l_return_status
24738: ||' '||SQLERRM
24739: );
24740: END IF;
24741: END IF;

Line 26088: l_stage := 'Deleting from OKC_CONTACTS';

26084: WHERE DNZ_CHR_ID = P_To_Chr_ID
26085: AND CLE_ID in (select ID from okc_k_lines_b where DNZ_CHR_ID = P_To_Chr_ID and CLE_ID IS NULL);
26086:
26087: --Delete line level party contacts--
26088: l_stage := 'Deleting from OKC_CONTACTS';
26089: DELETE from okc_contacts
26090: where cpl_id in (SELECT ID from OKC_K_PARTY_ROLES_B WHERE DNZ_CHR_ID = P_To_Chr_ID
26091: --npalepu removed the condition on 5/8/2006 for bug # 5116858
26092: /* and JTOT_OBJECT1_CODE = 'OKX_PARTY' */

Line 26089: DELETE from okc_contacts

26085: AND CLE_ID in (select ID from okc_k_lines_b where DNZ_CHR_ID = P_To_Chr_ID and CLE_ID IS NULL);
26086:
26087: --Delete line level party contacts--
26088: l_stage := 'Deleting from OKC_CONTACTS';
26089: DELETE from okc_contacts
26090: where cpl_id in (SELECT ID from OKC_K_PARTY_ROLES_B WHERE DNZ_CHR_ID = P_To_Chr_ID
26091: --npalepu removed the condition on 5/8/2006 for bug # 5116858
26092: /* and JTOT_OBJECT1_CODE = 'OKX_PARTY' */
26093: --end npalepu

Line 26147: l_stage := 'Deleting from OKC_CONTACTS';

26143: AND CLE_ID in (select ID from okc_k_lines_b where DNZ_CHR_ID = P_To_Chr_ID and CLE_ID IS NULL
26144: AND id in (SELECT ID FROM OKC_K_LINES_B_TEMP));
26145:
26146: --Delete line level party contacts--
26147: l_stage := 'Deleting from OKC_CONTACTS';
26148: DELETE from okc_contacts
26149: where cpl_id in (SELECT ID from OKC_K_PARTY_ROLES_B WHERE DNZ_CHR_ID = P_To_Chr_ID
26150: and CLE_ID is NOT NULL
26151: AND CLE_ID in (select ID from okc_k_lines_b where DNZ_CHR_ID = P_To_Chr_ID and CLE_ID IS NULL

Line 26148: DELETE from okc_contacts

26144: AND id in (SELECT ID FROM OKC_K_LINES_B_TEMP));
26145:
26146: --Delete line level party contacts--
26147: l_stage := 'Deleting from OKC_CONTACTS';
26148: DELETE from okc_contacts
26149: where cpl_id in (SELECT ID from OKC_K_PARTY_ROLES_B WHERE DNZ_CHR_ID = P_To_Chr_ID
26150: and CLE_ID is NOT NULL
26151: AND CLE_ID in (select ID from okc_k_lines_b where DNZ_CHR_ID = P_To_Chr_ID and CLE_ID IS NULL
26152: AND id in (SELECT ID FROM OKC_K_LINES_B_TEMP)));