APPS.OKL_COPY_ASSET_PVT dependencies on OKC_K_REL_OBJS

Line 5764: -- DESCRIPTION: This process copies records from OKC_K_REL_OBJS

5760:
5761: --
5762: -- NAME: copy_service_line_link
5763: --
5764: -- DESCRIPTION: This process copies records from OKC_K_REL_OBJS
5765: -- in case a linked service line exists at copied contract.
5766: --
5767: PROCEDURE copy_service_line_link(
5768: x_return_status OUT NOCOPY VARCHAR2,

Line 5786: FROM okc_k_rel_objs

5782: AND lse.lse_type = G_TLS_TYPE;
5783:
5784: CURSOR h_new_link_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
5785: SELECT 'Y'
5786: FROM okc_k_rel_objs
5787: WHERE chr_id = p_chr_id
5788: AND cle_id IS NULL
5789: AND rty_code = 'OKLSRV'
5790: AND jtot_object1_code = 'OKL_SERVICE';

Line 5799: FROM okc_k_rel_objs

5795: rty_code,
5796: object1_id1,
5797: object1_id2,
5798: jtot_object1_code
5799: FROM okc_k_rel_objs
5800: WHERE chr_id = p_chr_id
5801: AND cle_id IS NULL
5802: AND rty_code = 'OKLSRV'
5803: AND jtot_object1_code = 'OKL_SERVICE';

Line 5817: FROM okc_k_rel_objs rel

5813: rel.rty_code,
5814: rel.object1_id1,
5815: rel.object1_id2,
5816: rel.jtot_object1_code
5817: FROM okc_k_rel_objs rel
5818: WHERE rty_code = 'OKLSRV'
5819: AND cle_id is not null
5820: AND jtot_object1_code = 'OKL_SERVICE_LINE'
5821: AND cle_id = p_srv_top_line_id

Line 5830: FROM okc_k_rel_objs rel,

5826: rel.rty_code,
5827: rel.object1_id1,
5828: rel.object1_id2,
5829: rel.jtot_object1_code
5830: FROM okc_k_rel_objs rel,
5831: okc_k_lines_b line
5832: WHERE rty_code = 'OKLSRV'
5833: AND rel.cle_id is not null
5834: AND rel.jtot_object1_code = 'OKL_COV_PROD'

Line 5851: l_crjv_rec OKC_K_REL_OBJS_PUB.crjv_rec_type;

5847: l_from_chr_id OKC_K_HEADERS_B.ID%TYPE;
5848: l_h_link_exist VARCHAR2(1) := 'N';
5849: l_to_line_id OKC_K_LINES_V.ID%TYPE;
5850:
5851: l_crjv_rec OKC_K_REL_OBJS_PUB.crjv_rec_type;
5852: x_crjv_rec OKC_K_REL_OBJS_PUB.crjv_rec_type;
5853:
5854: BEGIN
5855:

Line 5852: x_crjv_rec OKC_K_REL_OBJS_PUB.crjv_rec_type;

5848: l_h_link_exist VARCHAR2(1) := 'N';
5849: l_to_line_id OKC_K_LINES_V.ID%TYPE;
5850:
5851: l_crjv_rec OKC_K_REL_OBJS_PUB.crjv_rec_type;
5852: x_crjv_rec OKC_K_REL_OBJS_PUB.crjv_rec_type;
5853:
5854: BEGIN
5855:
5856: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 5897: OKC_K_REL_OBJS_PUB.create_row (

5893: l_crjv_rec.object1_id1 := h_old_link_rec.object1_id1;
5894: l_crjv_rec.object1_id2 := h_old_link_rec.object1_id2;
5895: l_crjv_rec.jtot_object1_code := h_old_link_rec.jtot_object1_code;
5896:
5897: OKC_K_REL_OBJS_PUB.create_row (
5898: p_api_version => 1.0,
5899: p_init_msg_list => OKC_API.G_FALSE,
5900: x_return_status => x_return_status,
5901: x_msg_count => x_msg_count,

Line 5935: OKC_K_REL_OBJS_PUB.create_row (

5931:
5932: l_crjv_rec.cle_id := l_to_line_id;
5933: END IF;
5934:
5935: OKC_K_REL_OBJS_PUB.create_row (
5936: p_api_version => 1.0,
5937: p_init_msg_list => OKC_API.G_FALSE,
5938: x_return_status => x_return_status,
5939: x_msg_count => x_msg_count,

Line 6134: -- Copy Link detail from OKC_K_REL_OBJS

6130:
6131: --Bug# 2872267:
6132: /*-----------------------------------------------------------------
6133: --
6134: -- Copy Link detail from OKC_K_REL_OBJS
6135: -- in case of Service Integration, where
6136: -- OKL service line(s) is/are linked with OKS Service contract
6137: --
6138: --copy_service_line_link(