APPS.OKS_OCINT_PUB dependencies on OKC_K_REL_OBJS

Line 694: FROM okc_k_rel_objs_v rel, okc_k_lines_b line

690:
691: CURSOR l_contract_csr (p_ordlineid NUMBER)
692: IS
693: SELECT rel.cle_id, rel.chr_id
694: FROM okc_k_rel_objs_v rel, okc_k_lines_b line
695: WHERE rel.object1_id1 = TO_CHAR (p_ordlineid)
696: AND rel.jtot_object1_code = 'OKX_ORDERLINE'
697: AND line.ID = rel.cle_id
698: AND line.lse_id IN (9, 25);

Line 953: FROM okc_k_rel_objs okro,oe_order_lines_all ol,csi_item_instances csi

949: AND b.organization_id = okc_context.get_okc_organization_id;
950:
951: CURSOR Check_Contract_Exists(p_instance_id NUMBER,p_order_header_id NUMBER) IS
952: SELECT okro.chr_id
953: FROM okc_k_rel_objs okro,oe_order_lines_all ol,csi_item_instances csi
954: WHERE ol.line_id=okro.object1_id1
955: AND csi.last_oe_order_line_id=ol.line_id
956: AND csi.instance_id=p_instance_id
957: AND ol.header_id=p_order_header_id;

Line 983: l_crjv_tbl_in okc_k_rel_objs_pub.crjv_tbl_type;

979: l_priceattrib_id NUMBER;
980: l_api_version CONSTANT NUMBER := 1.0;
981: l_init_msg_list CONSTANT VARCHAR2 (1) := 'F';
982: l_return_status VARCHAR2 (1) := 'S';
983: l_crjv_tbl_in okc_k_rel_objs_pub.crjv_tbl_type;
984: l_crjv_tbl_out okc_k_rel_objs_pub.crjv_tbl_type;
985: l_chr_id_old NUMBER;
986: l_contract_item_type_code VARCHAR2(100);
987: l_bill_option VARCHAR2(100);

Line 984: l_crjv_tbl_out okc_k_rel_objs_pub.crjv_tbl_type;

980: l_api_version CONSTANT NUMBER := 1.0;
981: l_init_msg_list CONSTANT VARCHAR2 (1) := 'F';
982: l_return_status VARCHAR2 (1) := 'S';
983: l_crjv_tbl_in okc_k_rel_objs_pub.crjv_tbl_type;
984: l_crjv_tbl_out okc_k_rel_objs_pub.crjv_tbl_type;
985: l_chr_id_old NUMBER;
986: l_contract_item_type_code VARCHAR2(100);
987: l_bill_option VARCHAR2(100);
988: l_bill_profile_id NUMBER;

Line 2205: okc_k_rel_objs_pub.create_row (p_api_version => l_api_version,

2201: l_crjv_tbl_in (1).object1_id2 := '#';
2202: l_crjv_tbl_in (1).jtot_object1_code := 'OKX_ORDERLINE';
2203: l_crjv_tbl_in(1).rty_code := 'CONTRACTSERVICESORDER';
2204:
2205: okc_k_rel_objs_pub.create_row (p_api_version => l_api_version,
2206: p_init_msg_list => l_init_msg_list,
2207: x_return_status => l_return_status,
2208: x_msg_count => x_msg_count,
2209: x_msg_data => x_msg_data,

Line 2220: 'okc_k_rel_objs_pub.create_row(Return status = '

2216: fnd_log.STRING
2217: (fnd_log.level_event,
2218: g_module_current
2219: || '.Create_Obj_Rel.external_call_line.after',
2220: 'okc_k_rel_objs_pub.create_row(Return status = '
2221: || l_return_status
2222: || ')'
2223: );
2224: END IF;