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_K_PARTY_ROLES_B

Line 7961: -- copy_okc_k_party_roles_b

7957: End copy_okc_price_adjustments;
7958:
7959:
7960: --===================================================
7961: -- copy_okc_k_party_roles_b
7962: -- Parameters: P_From_Chr_ID : Header ID of source contract
7963: -- P_To_Chr_ID : Header ID of target contract
7964: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
7965: -- or as part of component copy from UI (value = 'Y')

Line 7968: PROCEDURE copy_okc_k_party_roles_b(P_From_Chr_ID IN NUMBER

7964: -- P_Partial_Copy_YN : Flag to indicate whether the routine is being invoked as part of full contract copy (value = 'N')
7965: -- or as part of component copy from UI (value = 'Y')
7966: -- P_Lines_Count : Count of rows in P_Lines_Tbl PLSQL Table
7967: --====================================================
7968: PROCEDURE copy_okc_k_party_roles_b(P_From_Chr_ID IN NUMBER
7969: ,P_To_Chr_ID IN NUMBER
7970: ,P_Partial_Copy_YN IN VARCHAR2
7971: ,P_Lines_Count IN NUMBER DEFAULT 0
7972: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 8020: OKC_K_PARTY_ROLES_B okcPRB

8016: ,okcPRB.ID AS okcPRB_ORIG_SYSTEM_ID1
8017: ,'COPY' AS okcPRB_ORIG_SYSTEM_REFERENCE1
8018: ,NULL AS okcPRB_ORIG_SYSTEM_SOURCE_CODE
8019: FROM
8020: OKC_K_PARTY_ROLES_B okcPRB
8021: ,OKC_K_HEADERS_B okcH
8022: where okcPRB.DNZ_CHR_ID = okcH.ORIG_SYSTEM_ID1
8023: and okcPRB.CLE_ID is NULL
8024: and okcH.ID = P_To_Chr_ID

Line 8068: OKC_K_PARTY_ROLES_B okcPRB

8064: ,okcPRB.ID AS okcPRB_ORIG_SYSTEM_ID1
8065: ,'COPY' AS okcPRB_ORIG_SYSTEM_REFERENCE1
8066: ,NULL AS okcPRB_ORIG_SYSTEM_SOURCE_CODE
8067: FROM
8068: OKC_K_PARTY_ROLES_B okcPRB
8069: ,OKC_K_LINES_B okcB
8070: WHERE
8071: okcPRB.CLE_ID = okcB.ORIG_SYSTEM_ID1
8072: AND okcPRB.DNZ_CHR_ID = P_From_Chr_ID

Line 8120: OKC_K_PARTY_ROLES_B okcPRB

8116: ,okcPRB.ID AS okcPRB_ORIG_SYSTEM_ID1
8117: ,'COPY' AS okcPRB_ORIG_SYSTEM_REFERENCE1
8118: ,NULL AS okcPRB_ORIG_SYSTEM_SOURCE_CODE
8119: FROM
8120: OKC_K_PARTY_ROLES_B okcPRB
8121: ,OKC_K_LINES_B_TEMP okcBT
8122: WHERE
8123: okcPRB.CLE_ID = okcBT.ORIG_SYSTEM_ID1
8124: AND okcPRB.CHR_ID IS NULL

Line 8239: INSERT INTO OKC_K_PARTY_ROLES_B(

8235: ,OkcPRBRecTab.OkcPRB_ORIG_SYSTEM_SOURCE_CODE LIMIT G_BULK_FETCH_LIMIT;
8236: END IF;
8237:
8238: FORALL i in OkcPRBRecTab.OkcPRB_NewID.FIRST .. OkcPRBRecTab.OkcPRB_NewID.LAST
8239: INSERT INTO OKC_K_PARTY_ROLES_B(
8240: ID
8241: ,CHR_ID
8242: ,CLE_ID
8243: ,DNZ_CHR_ID

Line 8368: End copy_okc_k_party_roles_b;

8364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8365: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name, substr(SQLERRM,1,240));
8366: RAISE;
8367:
8368: End copy_okc_k_party_roles_b;
8369:
8370: ---------------------------------------------------------------------------------
8371:
8372: --==================================================

Line 8373: -- create_vendor_if_missing : Creates a record in okc_k_party_roles_b for the target contract based on the org_id of the target contract

8369:
8370: ---------------------------------------------------------------------------------
8371:
8372: --==================================================
8373: -- create_vendor_if_missing : Creates a record in okc_k_party_roles_b for the target contract based on the org_id of the target contract
8374: -- Parameters: P_To_Chr_ID
8375: --==================================================
8376: PROCEDURE create_vendor_if_missing(P_From_Chr_ID IN NUMBER
8377: ,P_To_Chr_ID IN NUMBER

Line 8395: FROM okc_k_party_roles_b

8391: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
8392:
8393: CURSOR getSourceHdrVendorPartyRoleID IS
8394: SELECT id
8395: FROM okc_k_party_roles_b
8396: WHERE dnz_chr_id = P_From_Chr_ID
8397: AND cle_id is NULL
8398: AND jtot_object1_code = 'OKX_OPERUNIT';
8399: l_Source_Vendor_PRole_ID NUMBER;

Line 8407: from okc_k_party_roles_b

8403: Begin
8404: /*modified the where clause for bug6667810*/
8405: select ID
8406: into l_vendor_role_id
8407: from okc_k_party_roles_b
8408: where dnz_chr_id = P_To_Chr_ID /*where chr_id = P_To_Chr_ID*/
8409: and jtot_object1_code = 'OKX_OPERUNIT';
8410: EXCEPTION
8411: WHEN NO_DATA_FOUND THEN

Line 8436: --create a record in okc_k_party_roles_b--

8432: l_cplv_rec.dnz_chr_id := P_To_Chr_ID;
8433: l_cplv_rec.chr_id := P_To_Chr_ID;
8434: End;
8435:
8436: --create a record in okc_k_party_roles_b--
8437: Begin
8438: OKC_CONTRACT_PARTY_PUB.create_k_party_role(
8439: p_api_version => p_api_version,
8440: p_init_msg_list => p_init_msg_list,

Line 8515: ,OKC_K_PARTY_ROLES_B okcPRB

8511: ,okcPRTL.ALIAS AS okcPRTL_ALIAS
8512: ,okcPRTL.SECURITY_GROUP_ID AS okcPRTL_SECURITY_GROUP_ID
8513: FROM
8514: OKC_K_PARTY_ROLES_TL okcPRTL
8515: ,OKC_K_PARTY_ROLES_B okcPRB
8516: where okcPRTL.ID = okcPRB.ORIG_SYSTEM_ID1
8517: AND okcPRB.DNZ_CHR_ID = P_To_Chr_ID;
8518:
8519: CURSOR GetOkcPRTLPartial IS

Line 8531: ,OKC_K_PARTY_ROLES_B okcPRB

8527: ,okcPRTL.ALIAS AS okcPRTL_ALIAS
8528: ,okcPRTL.SECURITY_GROUP_ID AS okcPRTL_SECURITY_GROUP_ID
8529: FROM
8530: OKC_K_PARTY_ROLES_TL okcPRTL
8531: ,OKC_K_PARTY_ROLES_B okcPRB
8532: ,OKC_K_LINES_B_TEMP okcBT
8533: where okcPRTL.ID = okcPRB.ORIG_SYSTEM_ID1
8534: AND okcPRB.DNZ_CHR_ID = okcBT.DNZ_CHR_ID
8535: AND okcPRB.CLE_ID = okcBT.ID

Line 8695: ,OKC_K_PARTY_ROLES_B okcPRB

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;
8699:

Line 8736: ,OKC_K_PARTY_ROLES_B okcPRB

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
8740: AND okcPRB.CLE_ID = okcBT.ID

Line 19338: ,l_module_name||'.copy_okc_k_party_roles_b'

19334: Begin
19335: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19336: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19337: FND_LOG.string(FND_LOG.level_statement
19338: ,l_module_name||'.copy_okc_k_party_roles_b'
19339: ,'Before call to copy_okc_k_party_roles_b'
19340: );
19341: END IF;
19342: END IF;

Line 19339: ,'Before call to copy_okc_k_party_roles_b'

19335: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19336: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19337: FND_LOG.string(FND_LOG.level_statement
19338: ,l_module_name||'.copy_okc_k_party_roles_b'
19339: ,'Before call to copy_okc_k_party_roles_b'
19340: );
19341: END IF;
19342: END IF;
19343:

Line 19344: copy_okc_k_party_roles_b(P_From_Chr_ID => P_From_Chr_ID

19340: );
19341: END IF;
19342: END IF;
19343:
19344: copy_okc_k_party_roles_b(P_From_Chr_ID => P_From_Chr_ID
19345: ,P_To_Chr_ID => P_To_Chr_ID
19346: ,P_Partial_Copy_YN => 'N'
19347: ,x_return_status => l_return_status);
19348:

Line 19352: ,l_module_name||'.copy_okc_k_party_roles_b'

19348:
19349: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19350: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19351: FND_LOG.string(FND_LOG.level_statement
19352: ,l_module_name||'.copy_okc_k_party_roles_b'
19353: ,'After call to copy_okc_k_party_roles_b: x_return_status:'||l_return_status
19354: ||' '||SQLERRM
19355: );
19356: END IF;

Line 19353: ,'After call to copy_okc_k_party_roles_b: x_return_status:'||l_return_status

19349: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19350: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19351: FND_LOG.string(FND_LOG.level_statement
19352: ,l_module_name||'.copy_okc_k_party_roles_b'
19353: ,'After call to copy_okc_k_party_roles_b: x_return_status:'||l_return_status
19354: ||' '||SQLERRM
19355: );
19356: END IF;
19357: END IF;

Line 24655: ,l_module_name||'.copy_okc_k_party_roles_b'

24651: Begin
24652: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24653: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24654: FND_LOG.string(FND_LOG.level_statement
24655: ,l_module_name||'.copy_okc_k_party_roles_b'
24656: ,'Before call to copy_okc_k_party_roles_b'
24657: );
24658: END IF;
24659: END IF;

Line 24656: ,'Before call to copy_okc_k_party_roles_b'

24652: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24653: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24654: FND_LOG.string(FND_LOG.level_statement
24655: ,l_module_name||'.copy_okc_k_party_roles_b'
24656: ,'Before call to copy_okc_k_party_roles_b'
24657: );
24658: END IF;
24659: END IF;
24660:

Line 24661: copy_okc_k_party_roles_b(P_From_Chr_ID => P_From_Chr_ID

24657: );
24658: END IF;
24659: END IF;
24660:
24661: copy_okc_k_party_roles_b(P_From_Chr_ID => P_From_Chr_ID
24662: ,P_To_Chr_ID => P_To_Chr_ID
24663: ,P_Partial_Copy_YN => 'Y'
24664: ,P_Lines_Count => P_Lines_Tbl.COUNT
24665: ,x_return_status => l_return_status);

Line 24670: ,l_module_name||'.copy_okc_k_party_roles_b'

24666:
24667: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24668: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24669: FND_LOG.string(FND_LOG.level_statement
24670: ,l_module_name||'.copy_okc_k_party_roles_b'
24671: ,'After call to copy_okc_k_party_roles_b: x_return_status:'||l_return_status
24672: ||' '||SQLERRM
24673: );
24674: END IF;

Line 24671: ,'After call to copy_okc_k_party_roles_b: x_return_status:'||l_return_status

24667: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24668: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24669: FND_LOG.string(FND_LOG.level_statement
24670: ,l_module_name||'.copy_okc_k_party_roles_b'
24671: ,'After call to copy_okc_k_party_roles_b: x_return_status:'||l_return_status
24672: ||' '||SQLERRM
24673: );
24674: END IF;
24675: END IF;

Line 25980: FROM okc_k_party_roles_b

25976:
25977: l_stage VARCHAR2(100);
25978: CURSOR l_party_csr(P_To_Chr_ID IN NUMBER) IS
25979: SELECT count(ID)
25980: FROM okc_k_party_roles_b
25981: WHERE dnz_chr_id = P_To_Chr_ID
25982: AND jtot_object1_code = 'OKX_PARTY'
25983: --npalepu added on for bug # 5116858
25984: AND RLE_CODE in ('CUSTOMER','SUBSCRIBER')

Line 25992: FROM okc_k_party_roles_b

25988: --npalepu added on 5/8/2006 for bug # 5116858
25989: CURSOR l_party_comp_csr IS
25990: SELECT COUNT(*) FROM
25991: (SELECT RLE_CODE,jtot_object1_code
25992: FROM okc_k_party_roles_b
25993: WHERE dnz_chr_id = P_From_Chr_ID
25994: AND cle_id is null
25995: MINUS
25996: SELECT RLE_CODE,jtot_object1_code

Line 25997: FROM okc_k_party_roles_b

25993: WHERE dnz_chr_id = P_From_Chr_ID
25994: AND cle_id is null
25995: MINUS
25996: SELECT RLE_CODE,jtot_object1_code
25997: FROM okc_k_party_roles_b
25998: WHERE dnz_chr_id = P_To_Chr_ID
25999: AND cle_id is null);
26000:
26001: l_party_comp_count NUMBER;

Line 26090: where cpl_id in (SELECT ID from OKC_K_PARTY_ROLES_B WHERE DNZ_CHR_ID = P_To_Chr_ID

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
26094: and CLE_ID is NOT NULL);

Line 26097: l_stage := 'Deleting from OKC_K_PARTY_ROLES_B';

26093: --end npalepu
26094: and CLE_ID is NOT NULL);
26095:
26096: --Delete line level party roles--
26097: l_stage := 'Deleting from OKC_K_PARTY_ROLES_B';
26098: DELETE from okc_k_party_roles_b
26099: where dnz_chr_id = P_To_Chr_ID
26100: --npalepu removed the condition on 5/8/2006 for bug # 5116858
26101: /* and jtot_object1_code = 'OKX_PARTY' */

Line 26098: DELETE from okc_k_party_roles_b

26094: and CLE_ID is NOT NULL);
26095:
26096: --Delete line level party roles--
26097: l_stage := 'Deleting from OKC_K_PARTY_ROLES_B';
26098: DELETE from okc_k_party_roles_b
26099: where dnz_chr_id = P_To_Chr_ID
26100: --npalepu removed the condition on 5/8/2006 for bug # 5116858
26101: /* and jtot_object1_code = 'OKX_PARTY' */
26102: --end npalepu

Line 26149: where cpl_id in (SELECT ID from OKC_K_PARTY_ROLES_B WHERE DNZ_CHR_ID = P_To_Chr_ID

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)));
26153:

Line 26155: l_stage := 'Deleting from OKC_K_PARTY_ROLES_B';

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)));
26153:
26154: --Delete line level party roles--
26155: l_stage := 'Deleting from OKC_K_PARTY_ROLES_B';
26156: DELETE from okc_k_party_roles_b
26157: where dnz_chr_id = P_To_Chr_ID
26158: and cle_id is not null
26159: 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 26156: DELETE from okc_k_party_roles_b

26152: AND id in (SELECT ID FROM OKC_K_LINES_B_TEMP)));
26153:
26154: --Delete line level party roles--
26155: l_stage := 'Deleting from OKC_K_PARTY_ROLES_B';
26156: DELETE from okc_k_party_roles_b
26157: where dnz_chr_id = P_To_Chr_ID
26158: and cle_id is not null
26159: AND CLE_ID in (select ID from okc_k_lines_b where DNZ_CHR_ID = P_To_Chr_ID and CLE_ID IS NULL
26160: AND id in (SELECT ID FROM OKC_K_LINES_B_TEMP));