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 878: FROM okc_contacts_v

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

Line 2759: FROM OKC_CONTACTS_V

2755: START_DATE,
2756: END_DATE,
2757: PRIMARY_YN -- Bug 2374325
2758:
2759: FROM OKC_CONTACTS_V
2760: WHERE ID = p_ctc_id;
2761:
2762: BEGIN
2763: OPEN c_ctcv_rec;

Line 8680: -- copy_okc_contacts

8676: End copy_okc_k_party_roles_tl;
8677:
8678:
8679: --===================================================
8680: -- copy_okc_contacts
8681: -- Parameters: P_From_Chr_ID : Header ID of source contract
8682: -- P_To_Chr_ID : Header ID of target contract
8683: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
8684: -- or as part of component copy from UI (value = 'Y')

Line 8686: PROCEDURE copy_okc_contacts(P_From_Chr_ID IN NUMBER

8682: -- P_To_Chr_ID : Header ID of target contract
8683: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
8684: -- or as part of component copy from UI (value = 'Y')
8685: --====================================================
8686: PROCEDURE copy_okc_contacts(P_From_Chr_ID IN NUMBER
8687: ,P_To_Chr_ID IN NUMBER
8688: ,P_Partial_Copy_YN IN VARCHAR2
8689: ,P_Lines_Count IN NUMBER DEFAULT 0
8690: ,x_return_status OUT NOCOPY VARCHAR2) IS

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

8688: ,P_Partial_Copy_YN IN VARCHAR2
8689: ,P_Lines_Count IN NUMBER DEFAULT 0
8690: ,x_return_status OUT NOCOPY VARCHAR2) IS
8691:
8692: l_api_name CONSTANT VARCHAR2(30) := 'COPY_OKC_CONTACTS';
8693: l_module_name VARCHAR2(256) := G_APP_NAME || '.plsql.' || G_PKG_NAME || '.' || l_api_name;
8694:
8695: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8696: CURSOR GetOkcCFull IS

Line 8731: OKC_CONTACTS okcC

8727: , okcC.PRIMARY_YN AS okcC_PRIMARY_YN
8728: , okcC.RESOURCE_CLASS AS okcC_RESOURCE_CLASS
8729: , okcC.SALES_GROUP_ID AS okcC_SALES_GROUP_ID
8730: FROM
8731: OKC_CONTACTS okcC
8732: ,OKC_K_PARTY_ROLES_B okcPRB
8733: WHERE okcC.CPL_ID = okcPRB.ORIG_SYSTEM_ID1
8734: AND okcPRB.DNZ_CHR_ID = P_To_Chr_ID
8735: AND okcC.DNZ_CHR_ID = P_From_Chr_ID;

Line 8772: OKC_CONTACTS okcC

8768: , okcC.PRIMARY_YN AS okcC_PRIMARY_YN
8769: , okcC.RESOURCE_CLASS AS okcC_RESOURCE_CLASS
8770: , okcC.SALES_GROUP_ID AS okcC_SALES_GROUP_ID
8771: FROM
8772: OKC_CONTACTS okcC
8773: ,OKC_K_PARTY_ROLES_B okcPRB
8774: ,OKC_K_LINES_B_TEMP okcBT
8775: WHERE okcC.CPL_ID = okcPRB.ORIG_SYSTEM_ID1
8776: AND okcPRB.DNZ_CHR_ID = okcBT.DNZ_CHR_ID

Line 8863: INSERT INTO OKC_CONTACTS(

8859: End If;
8860:
8861:
8862: FORALL i IN OkcCRecTab.OkcC_NewID.FIRST .. OkcCRecTab.OkcC_NewID.LAST
8863: INSERT INTO OKC_CONTACTS(
8864: ID
8865: , CPL_ID
8866: , CRO_CODE
8867: , DNZ_CHR_ID

Line 8973: End copy_okc_contacts;

8969: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
8970: RAISE;
8971:
8972:
8973: End copy_okc_contacts;
8974:
8975:
8976: --===================================================
8977: -- copy_okc_operation_lines

Line 19541: ------------Copy of OKC_CONTACTS--------------------------------------

19537: RAISE G_EXCEPTION_HALT_VALIDATION;
19538: End If;
19539: End;
19540: ----------------------------------------------------------------------
19541: ------------Copy of OKC_CONTACTS--------------------------------------
19542: Begin
19543: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19544: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19545: FND_LOG.string(FND_LOG.level_statement

Line 19546: ,l_module_name||'.copy_okc_contacts'

19542: Begin
19543: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19544: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19545: FND_LOG.string(FND_LOG.level_statement
19546: ,l_module_name||'.copy_okc_contacts'
19547: ,'Before call to copy_okc_contacts'
19548: );
19549: END IF;
19550: END IF;

Line 19547: ,'Before call to copy_okc_contacts'

19543: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19544: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19545: FND_LOG.string(FND_LOG.level_statement
19546: ,l_module_name||'.copy_okc_contacts'
19547: ,'Before call to copy_okc_contacts'
19548: );
19549: END IF;
19550: END IF;
19551: copy_okc_contacts(P_From_Chr_ID => P_From_Chr_ID

Line 19551: copy_okc_contacts(P_From_Chr_ID => P_From_Chr_ID

19547: ,'Before call to copy_okc_contacts'
19548: );
19549: END IF;
19550: END IF;
19551: copy_okc_contacts(P_From_Chr_ID => P_From_Chr_ID
19552: ,P_To_Chr_ID => P_To_Chr_ID
19553: ,P_Partial_Copy_YN => 'N'
19554: ,x_return_status => l_return_status);
19555:

Line 19559: ,l_module_name||'.copy_okc_contacts'

19555:
19556: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19557: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19558: FND_LOG.string(FND_LOG.level_statement
19559: ,l_module_name||'.copy_okc_contacts'
19560: ,'After call to copy_okc_contacts: x_return_status:'||l_return_status
19561: ||' '||SQLERRM
19562: );
19563: END IF;

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

19556: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19557: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19558: FND_LOG.string(FND_LOG.level_statement
19559: ,l_module_name||'.copy_okc_contacts'
19560: ,'After call to copy_okc_contacts: x_return_status:'||l_return_status
19561: ||' '||SQLERRM
19562: );
19563: END IF;
19564: END IF;

Line 24911: ------------Copy of OKC_CONTACTS--------------------------------------

24907: End If;
24908: End;
24909: END IF;
24910: ----------------------------------------------------------------------
24911: ------------Copy of OKC_CONTACTS--------------------------------------
24912: IF (P_Lines_Tbl.COUNT > 0) then
24913: Begin
24914: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24915: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN

Line 24917: ,l_module_name||'.copy_okc_contacts'

24913: Begin
24914: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24915: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24916: FND_LOG.string(FND_LOG.level_statement
24917: ,l_module_name||'.copy_okc_contacts'
24918: ,'Before call to copy_okc_contacts'
24919: );
24920: END IF;
24921: END IF;

Line 24918: ,'Before call to copy_okc_contacts'

24914: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24915: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24916: FND_LOG.string(FND_LOG.level_statement
24917: ,l_module_name||'.copy_okc_contacts'
24918: ,'Before call to copy_okc_contacts'
24919: );
24920: END IF;
24921: END IF;
24922: copy_okc_contacts(P_From_Chr_ID => P_From_Chr_ID

Line 24922: copy_okc_contacts(P_From_Chr_ID => P_From_Chr_ID

24918: ,'Before call to copy_okc_contacts'
24919: );
24920: END IF;
24921: END IF;
24922: copy_okc_contacts(P_From_Chr_ID => P_From_Chr_ID
24923: ,P_To_Chr_ID => P_To_Chr_ID
24924: ,P_Partial_Copy_YN => 'Y'
24925: ,P_Lines_Count => P_Lines_Tbl.COUNT
24926: ,x_return_status => l_return_status);

Line 24931: ,l_module_name||'.copy_okc_contacts'

24927:
24928: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24929: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24930: FND_LOG.string(FND_LOG.level_statement
24931: ,l_module_name||'.copy_okc_contacts'
24932: ,'After call to copy_okc_contacts: x_return_status:'||l_return_status
24933: ||' '||SQLERRM
24934: );
24935: END IF;

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

24928: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24929: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24930: FND_LOG.string(FND_LOG.level_statement
24931: ,l_module_name||'.copy_okc_contacts'
24932: ,'After call to copy_okc_contacts: x_return_status:'||l_return_status
24933: ||' '||SQLERRM
24934: );
24935: END IF;
24936: END IF;

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

26283: WHERE DNZ_CHR_ID = P_To_Chr_ID
26284: AND CLE_ID in (select ID from okc_k_lines_b where DNZ_CHR_ID = P_To_Chr_ID and CLE_ID IS NULL);
26285:
26286: --Delete line level party contacts--
26287: l_stage := 'Deleting from OKC_CONTACTS';
26288: DELETE from okc_contacts
26289: where cpl_id in (SELECT ID from OKC_K_PARTY_ROLES_B WHERE DNZ_CHR_ID = P_To_Chr_ID
26290: --npalepu removed the condition on 5/8/2006 for bug # 5116858
26291: /* and JTOT_OBJECT1_CODE = 'OKX_PARTY' */

Line 26288: DELETE from okc_contacts

26284: AND CLE_ID in (select ID from okc_k_lines_b where DNZ_CHR_ID = P_To_Chr_ID and CLE_ID IS NULL);
26285:
26286: --Delete line level party contacts--
26287: l_stage := 'Deleting from OKC_CONTACTS';
26288: DELETE from okc_contacts
26289: where cpl_id in (SELECT ID from OKC_K_PARTY_ROLES_B WHERE DNZ_CHR_ID = P_To_Chr_ID
26290: --npalepu removed the condition on 5/8/2006 for bug # 5116858
26291: /* and JTOT_OBJECT1_CODE = 'OKX_PARTY' */
26292: --end npalepu

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

26342: AND CLE_ID in (select ID from okc_k_lines_b where DNZ_CHR_ID = P_To_Chr_ID and CLE_ID IS NULL
26343: AND id in (SELECT ID FROM OKC_K_LINES_B_TEMP));
26344:
26345: --Delete line level party contacts--
26346: l_stage := 'Deleting from OKC_CONTACTS';
26347: DELETE from okc_contacts
26348: where cpl_id in (SELECT ID from OKC_K_PARTY_ROLES_B WHERE DNZ_CHR_ID = P_To_Chr_ID
26349: and CLE_ID is NOT NULL
26350: 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 26347: DELETE from okc_contacts

26343: AND id in (SELECT ID FROM OKC_K_LINES_B_TEMP));
26344:
26345: --Delete line level party contacts--
26346: l_stage := 'Deleting from OKC_CONTACTS';
26347: DELETE from okc_contacts
26348: where cpl_id in (SELECT ID from OKC_K_PARTY_ROLES_B WHERE DNZ_CHR_ID = P_To_Chr_ID
26349: and CLE_ID is NOT NULL
26350: AND CLE_ID in (select ID from okc_k_lines_b where DNZ_CHR_ID = P_To_Chr_ID and CLE_ID IS NULL
26351: AND id in (SELECT ID FROM OKC_K_LINES_B_TEMP)));

Line 26993: --Update Status field in OKC_CONTACTS table.

26989: set sts_code = 'QA_HOLD'
26990: ,object_version_number = decode(l_Target_Contract_New_YN,'Y',object_version_number,object_version_number+1)
26991: where id = l_to_chr_id;
26992:
26993: --Update Status field in OKC_CONTACTS table.
26994: /*cgopinee Bug fix for 6882512*/
26995: OKC_CTC_PVT.update_contact_stecode(p_chr_id => l_to_chr_id,
26996: x_return_status=>l_return_status);
26997: