APPS.OKC_CONTRACT_PVT dependencies on OKC_CONTRACT_PUB

Line 598: If (OKC_CONTRACT_PUB.Update_Allowed(p_chrv_rec.id) <> 'Y') Then

594: BEGIN
595: -- if the update is not a restricted update (restricted_update <> 'Y'),
596: -- check whether update is allowed or not
597: If (p_restricted_update <> OKC_API.G_TRUE) Then
598: If (OKC_CONTRACT_PUB.Update_Allowed(p_chrv_rec.id) <> 'Y') Then
599: raise G_NO_UPDATE_ALLOWED_EXCEPTION;
600: End If;
601: End If;
602:

Line 790: If (OKC_CONTRACT_PUB.Update_Allowed(p_chrv_rec.id) <> 'Y') Then

786: BEGIN
787: -- if the update is not a restricted update (restricted_update <> 'Y'),
788: -- check whether update is allowed or not
789: If (p_restricted_update <> OKC_API.G_TRUE) Then
790: If (OKC_CONTRACT_PUB.Update_Allowed(p_chrv_rec.id) <> 'Y') Then
791: raise G_NO_UPDATE_ALLOWED_EXCEPTION;
792: End If;
793: End If;
794:

Line 966: If (OKC_CONTRACT_PUB.Update_Allowed(p_chrv_rec.id) <> 'Y') Then

962:
963:
964: BEGIN
965: -- check whether delete is allowed or not
966: If (OKC_CONTRACT_PUB.Update_Allowed(p_chrv_rec.id) <> 'Y') Then
967: raise G_NO_UPDATE_ALLOWED_EXCEPTION;
968: End If;
969:
970: -- check whether detail records exists

Line 1390: If (OKC_CONTRACT_PUB.Update_Allowed(l_chr_id) <> 'Y') Then

1386: If (l_return_status = OKC_API.G_RET_STS_SUCCESS) Then
1387: -- if the update is not a restricted update (restricted_update <> 'Y'),
1388: -- check whether update is allowed or not
1389: If (p_restricted_update <> OKC_API.G_TRUE) Then
1390: If (OKC_CONTRACT_PUB.Update_Allowed(l_chr_id) <> 'Y') Then
1391: raise G_NO_UPDATE_ALLOWED_EXCEPTION;
1392: End If;
1393: End If;
1394: Else

Line 1504: If (OKC_CONTRACT_PUB.Update_Allowed(l_chr_id) <> 'Y') Then

1500: If (l_return_status = OKC_API.G_RET_STS_SUCCESS) Then
1501: -- if the update is not a restricted update (restricted_update <> 'Y'),
1502: -- check whether update is allowed or not
1503: If (p_restricted_update <> OKC_API.G_TRUE) Then
1504: If (OKC_CONTRACT_PUB.Update_Allowed(l_chr_id) <> 'Y') Then
1505: raise G_NO_UPDATE_ALLOWED_EXCEPTION;
1506: End If;
1507: End If;
1508: Else

Line 1766: If (OKC_CONTRACT_PUB.Update_Allowed(l_chr_id) <> 'Y') Then

1762: x_chr_id => l_chr_id,
1763: x_return_status => l_return_status);
1764:
1765: If (l_return_status = OKC_API.G_RET_STS_SUCCESS) Then
1766: If (OKC_CONTRACT_PUB.Update_Allowed(l_chr_id) <> 'Y') Then
1767: raise G_NO_UPDATE_ALLOWED_EXCEPTION;
1768: End If;
1769: End If;
1770:

Line 2086: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

2082: SELECT Id FROM OKC_K_REL_OBJS
2083: WHERE cle_Id = P_cle_Id;
2084:
2085: n NUMBER:=0;
2086: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
2087: l_clev_tbl_tmp okc_contract_pub.clev_tbl_type;
2088: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
2089: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
2090: l_cimv_tbl_in okc_Contract_Item_Pub.cimv_tbl_TYPE;

Line 2087: l_clev_tbl_tmp okc_contract_pub.clev_tbl_type;

2083: WHERE cle_Id = P_cle_Id;
2084:
2085: n NUMBER:=0;
2086: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
2087: l_clev_tbl_tmp okc_contract_pub.clev_tbl_type;
2088: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
2089: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
2090: l_cimv_tbl_in okc_Contract_Item_Pub.cimv_tbl_TYPE;
2091: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;

Line 2385: okc_contract_pub.delete_contract_line (

2381: END IF;
2382:
2383: IF NOT l_clev_tbl_in.COUNT=0
2384: THEN
2385: okc_contract_pub.delete_contract_line (
2386: p_api_version => l_api_version,
2387: p_init_msg_list => l_init_msg_list,
2388: x_return_status => l_return_status,
2389: x_msg_count => l_msg_count,

Line 2541: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

2537: SELECT Id FROM OKC_K_REL_OBJS
2538: WHERE cle_Id = P_cle_Id;
2539:
2540: n NUMBER:=0;
2541: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
2542: l_clev_tbl_tmp okc_contract_pub.clev_tbl_type;
2543: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
2544: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
2545: l_cimv_tbl_in okc_Contract_Item_Pub.cimv_tbl_TYPE;

Line 2542: l_clev_tbl_tmp okc_contract_pub.clev_tbl_type;

2538: WHERE cle_Id = P_cle_Id;
2539:
2540: n NUMBER:=0;
2541: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
2542: l_clev_tbl_tmp okc_contract_pub.clev_tbl_type;
2543: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
2544: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
2545: l_cimv_tbl_in okc_Contract_Item_Pub.cimv_tbl_TYPE;
2546: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;