APPS.OKS_INTEGRATION_UTIL_PUB dependencies on OKS_K_ORDER_DETAILS

Line 44: From Oks_K_Order_Details

40: Is
41:
42: Cursor l_order_csr Is
43: Select Order_Line_Id1
44: From Oks_K_Order_Details
45: Where Order_Line_Id1 = to_char(P_Order_Line_id);
46:
47: l_order_exists_rec l_order_csr%rowtype;
48: Begin

Line 95: from Oks_K_Order_Details

91: select order_line_id1, order_line_id2, line_renewal_type, renewal_type,
92: po_required_yn, renewal_pricing_type,markup_percent,billing_profile_id,
93: chr_id, cle_id, cod_type, cod_id, end_date,contact_id, email_id, phone_id, fax_id, site_id
94: ,renewal_approval_flag --Bug# 5173373
95: from Oks_K_Order_Details
96: where Link_Order_Header_ID = P_header_id
97: And APPLY_ALL_YN = 'Y';
98:
99: -- Cursor to check if all other orders has to be linked with

Line 106: from Oks_K_Order_Details

102: Cursor line_enddate_cur (l_ser_end_date date) Is
103: select order_line_id1, order_line_id2, line_renewal_type, renewal_type,
104: po_required_yn, renewal_pricing_type,markup_percent,
105: chr_id, cle_id, cod_type, cod_id, end_date,contact_id, email_id, phone_id, fax_id, site_id
106: from Oks_K_Order_Details
107: where Link_Order_Header_ID = P_header_id
108: And Cod_Type = 'NCT'
109: And trunc(end_date) = trunc(l_ser_end_date);
110:

Line 116: where cod_id in (select id from Oks_K_Order_Details

112:
113: Cursor Order_contacts_cur (order_line_id VARCHAR2) Is
114: select Cro_Code, Jtot_Object_Code, Object1_Id1, Object1_Id2
115: from oks_k_order_contacts_v
116: where cod_id in (select id from Oks_K_Order_Details
117: where Order_Line_Id1 = order_line_id);
118:
119: line_dtl_rec line_dtl_cur%rowtype;
120: line_enddate_rec line_enddate_cur%rowtype;

Line 132: l_order_id Oks_K_Order_Details.order_line_id1%type;

128:
129: l_covd_tbl_in Oks_Cod_Pvt.codv_tbl_type;
130: l_covd_tbl_out Oks_Cod_Pvt.codv_tbl_type;
131:
132: l_order_id Oks_K_Order_Details.order_line_id1%type;
133:
134:
135: l_api_version CONSTANT NUMBER := 1.0;
136: l_init_msg_list CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;