APPS.OKC_CONTRACT_PVT dependencies on OKC_CONTRACT_PUB

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

601: BEGIN
602: -- if the update is not a restricted update (restricted_update <> 'Y'),
603: -- check whether update is allowed or not
604: If (p_restricted_update <> OKC_API.G_TRUE) Then
605: If (OKC_CONTRACT_PUB.Update_Allowed(p_chrv_rec.id) <> 'Y') Then
606: raise G_NO_UPDATE_ALLOWED_EXCEPTION;
607: End If;
608: End If;
609:

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

822: BEGIN
823: -- if the update is not a restricted update (restricted_update <> 'Y'),
824: -- check whether update is allowed or not
825: If (p_restricted_update <> OKC_API.G_TRUE) Then
826: If (OKC_CONTRACT_PUB.Update_Allowed(p_chrv_rec.id) <> 'Y') Then
827: raise G_NO_UPDATE_ALLOWED_EXCEPTION;
828: End If;
829: End If;
830:

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

1020:
1021:
1022: BEGIN
1023: -- check whether delete is allowed or not
1024: If (OKC_CONTRACT_PUB.Update_Allowed(p_chrv_rec.id) <> 'Y') Then
1025: raise G_NO_UPDATE_ALLOWED_EXCEPTION;
1026: End If;
1027:
1028: -- check whether detail records exists

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

1444: If (l_return_status = OKC_API.G_RET_STS_SUCCESS) Then
1445: -- if the update is not a restricted update (restricted_update <> 'Y'),
1446: -- check whether update is allowed or not
1447: If (p_restricted_update <> OKC_API.G_TRUE) Then
1448: If (OKC_CONTRACT_PUB.Update_Allowed(l_chr_id) <> 'Y') Then
1449: raise G_NO_UPDATE_ALLOWED_EXCEPTION;
1450: End If;
1451: End If;
1452: Else

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

1558: If (l_return_status = OKC_API.G_RET_STS_SUCCESS) Then
1559: -- if the update is not a restricted update (restricted_update <> 'Y'),
1560: -- check whether update is allowed or not
1561: If (p_restricted_update <> OKC_API.G_TRUE) Then
1562: If (OKC_CONTRACT_PUB.Update_Allowed(l_chr_id) <> 'Y') Then
1563: raise G_NO_UPDATE_ALLOWED_EXCEPTION;
1564: End If;
1565: End If;
1566: Else

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

1820: x_chr_id => l_chr_id,
1821: x_return_status => l_return_status);
1822:
1823: If (l_return_status = OKC_API.G_RET_STS_SUCCESS) Then
1824: If (OKC_CONTRACT_PUB.Update_Allowed(l_chr_id) <> 'Y') Then
1825: raise G_NO_UPDATE_ALLOWED_EXCEPTION;
1826: End If;
1827: End If;
1828:

Line 2144: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

2140: SELECT Id FROM OKC_K_REL_OBJS
2141: WHERE cle_Id = P_cle_Id;
2142:
2143: n NUMBER:=0;
2144: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
2145: l_clev_tbl_tmp okc_contract_pub.clev_tbl_type;
2146: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
2147: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
2148: l_cimv_tbl_in okc_Contract_Item_Pub.cimv_tbl_TYPE;

Line 2145: l_clev_tbl_tmp okc_contract_pub.clev_tbl_type;

2141: WHERE cle_Id = P_cle_Id;
2142:
2143: n NUMBER:=0;
2144: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
2145: l_clev_tbl_tmp okc_contract_pub.clev_tbl_type;
2146: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
2147: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
2148: l_cimv_tbl_in okc_Contract_Item_Pub.cimv_tbl_TYPE;
2149: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;

Line 2443: okc_contract_pub.delete_contract_line (

2439: END IF;
2440:
2441: IF NOT l_clev_tbl_in.COUNT=0
2442: THEN
2443: okc_contract_pub.delete_contract_line (
2444: p_api_version => l_api_version,
2445: p_init_msg_list => l_init_msg_list,
2446: x_return_status => l_return_status,
2447: x_msg_count => l_msg_count,

Line 2599: l_clev_tbl_in okc_contract_pub.clev_tbl_type;

2595: SELECT Id FROM OKC_K_REL_OBJS
2596: WHERE cle_Id = P_cle_Id;
2597:
2598: n NUMBER:=0;
2599: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
2600: l_clev_tbl_tmp okc_contract_pub.clev_tbl_type;
2601: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
2602: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
2603: l_cimv_tbl_in okc_Contract_Item_Pub.cimv_tbl_TYPE;

Line 2600: l_clev_tbl_tmp okc_contract_pub.clev_tbl_type;

2596: WHERE cle_Id = P_cle_Id;
2597:
2598: n NUMBER:=0;
2599: l_clev_tbl_in okc_contract_pub.clev_tbl_type;
2600: l_clev_tbl_tmp okc_contract_pub.clev_tbl_type;
2601: l_rgpv_tbl_in okc_rule_pub.rgpv_tbl_type;
2602: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
2603: l_cimv_tbl_in okc_Contract_Item_Pub.cimv_tbl_TYPE;
2604: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;