APPS.OKC_CONTRACT_PVT dependencies on OKC_K_REL_OBJS

Line 990: FROM OKC_K_REL_OBJS

986: where chr_id = p_chrv_rec.id;
987:
988: Cursor l_crjv_csr Is
989: SELECT id, object_version_number
990: FROM OKC_K_REL_OBJS
991: WHERE chr_id = p_chrv_rec.id;
992:
993: Cursor l_cvm_csr Is
994: SELECT to_char(major_version)

Line 1014: l_crjv_rec OKC_K_REL_OBJS_PUB.crjv_rec_type;

1010: AND header.id = p_chrv_rec.id;
1011:
1012:
1013:
1014: l_crjv_rec OKC_K_REL_OBJS_PUB.crjv_rec_type;
1015: l_oiev_tbl OKC_OPER_INST_PUB.oiev_tbl_type;
1016: i NUMBER := 0;
1017:
1018: l_scrv_rec OKC_SALES_credit_PUB.scrv_rec_type;

Line 1112: OKC_K_REL_OBJS_PUB.delete_row(

1108: Loop
1109: l_crjv_rec.id := c.id;
1110: l_crjv_rec.object_version_number := c.object_version_number;
1111:
1112: OKC_K_REL_OBJS_PUB.delete_row(
1113: p_api_version => p_api_version,
1114: p_init_msg_list => p_init_msg_list,
1115: x_return_status => x_return_status,
1116: x_msg_count => x_msg_count,

Line 1773: FROM OKC_K_REL_OBJS

1769: where cle_id = p_clev_rec.id;
1770:
1771: Cursor l_crjv_csr Is
1772: SELECT id, object_version_number
1773: FROM OKC_K_REL_OBJS
1774: WHERE cle_id = p_clev_rec.id;
1775:
1776: Cursor l_cvm_csr(p_chr_id NUMBER) Is
1777: SELECT to_char(major_version)

Line 1802: l_crjv_rec OKC_K_REL_OBJS_PUB.crjv_rec_type;

1798: WHERE cle_id = p_clev_rec.id
1799: AND dnz_chr_id = l_chr_id;
1800:
1801:
1802: l_crjv_rec OKC_K_REL_OBJS_PUB.crjv_rec_type;
1803: i NUMBER := 0;
1804:
1805: l_scrv_rec OKC_SALES_credit_PUB.scrv_rec_type;
1806:

Line 1890: OKC_K_REL_OBJS_PUB.delete_row(

1886: Loop
1887: l_crjv_rec.id := c.id;
1888: l_crjv_rec.object_version_number := c.object_version_number;
1889:
1890: OKC_K_REL_OBJS_PUB.delete_row(
1891: p_api_version => p_api_version,
1892: p_init_msg_list => p_init_msg_list,
1893: x_return_status => x_return_status,
1894: x_msg_count => x_msg_count,

Line 2140: SELECT Id FROM OKC_K_REL_OBJS

2136: SELECT ID FROM OKC_RULE_GROUPS_B
2137: WHERE cle_Id=P_Cle_Id;
2138:
2139: CURSOR Relobj_Cur(P_Cle_Id IN NUMBER) IS
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;

Line 2151: l_crjv_tbl_in okc_k_rel_objs_pub.crjv_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;
2150: l_cplv_tbl_in okc_contract_party_pub.cplv_tbl_type;
2151: l_crjv_tbl_in okc_k_rel_objs_pub.crjv_tbl_type;
2152: l_api_version CONSTANT NUMBER := 1.0;
2153: l_init_msg_list CONSTANT VARCHAR2(1) := 'T';
2154: l_return_status VARCHAR2(1);
2155: l_msg_count NUMBER;

Line 2314: OKC_K_REL_OBJS_PUB.Delete_Row(

2310:
2311: IF NOT l_crjv_tbl_in.COUNT=0
2312: THEN
2313:
2314: OKC_K_REL_OBJS_PUB.Delete_Row(
2315: p_api_version => l_api_version,
2316: p_init_msg_list => l_init_msg_list,
2317: x_return_status => l_return_status,
2318: x_msg_count => l_msg_count,

Line 2595: SELECT Id FROM OKC_K_REL_OBJS

2591: SELECT ID FROM OKC_RULE_GROUPS_B
2592: WHERE cle_Id=P_Cle_Id;
2593:
2594: CURSOR Relobj_Cur(P_Cle_Id IN NUMBER) IS
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;

Line 2606: l_crjv_tbl_in okc_k_rel_objs_pub.crjv_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;
2605: l_cplv_tbl_in okc_contract_party_pub.cplv_tbl_type;
2606: l_crjv_tbl_in okc_k_rel_objs_pub.crjv_tbl_type;
2607: l_api_version CONSTANT NUMBER := 1.0;
2608: l_init_msg_list CONSTANT VARCHAR2(1) := 'T';
2609: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2610: l_msg_count NUMBER;

Line 3005: okc_debug.log('400: calling OKC_K_REL_OBJS_PUB.Delete_Row', 2);

3001: END LOOP;
3002: END LOOP;
3003:
3004: IF (l_debug = 'Y') THEN
3005: okc_debug.log('400: calling OKC_K_REL_OBJS_PUB.Delete_Row', 2);
3006: END IF;
3007: IF NOT l_crjv_tbl_in.COUNT=0
3008: THEN
3009:

Line 3010: OKC_K_REL_OBJS_PUB.Delete_Row(

3006: END IF;
3007: IF NOT l_crjv_tbl_in.COUNT=0
3008: THEN
3009:
3010: OKC_K_REL_OBJS_PUB.Delete_Row(
3011: p_api_version => l_api_version,
3012: p_init_msg_list => l_init_msg_list,
3013: x_return_status => l_return_status,
3014: x_msg_count => l_msg_count,