APPS.OKC_OC_INT_QTK_PVT dependencies on OKC_K_HEADERS_B

Line 46: l_contract_number okc_k_headers_b.contract_number%TYPE;

42: --
43: -- Global variables
44: --
45:
46: l_contract_number okc_k_headers_b.contract_number%TYPE;
47: l_contract_number_modifier okc_k_headers_b.contract_number_modifier%TYPE;
48: l_quote_number okx_quote_headers_v.quote_number%TYPE;
49: l_order_number okx_order_headers_v.order_number%TYPE;
50:

Line 47: l_contract_number_modifier okc_k_headers_b.contract_number_modifier%TYPE;

43: -- Global variables
44: --
45:
46: l_contract_number okc_k_headers_b.contract_number%TYPE;
47: l_contract_number_modifier okc_k_headers_b.contract_number_modifier%TYPE;
48: l_quote_number okx_quote_headers_v.quote_number%TYPE;
49: l_order_number okx_order_headers_v.order_number%TYPE;
50:
51:

Line 146: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE

142: -- Bug : 1686001 Changed references aso_quote_headers_v.quote_header_id to okx_quote_headers_v.id1
143: PROCEDURE create_k_from_quote(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
144: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
145: ,p_quote_id IN OKX_QUOTE_HEADERS_V.id1%TYPE
146: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
147: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
148: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE
149: ,p_terms_agreed_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE
150: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE

Line 150: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE

146: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
147: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
148: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE
149: ,p_terms_agreed_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE
150: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
151: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
152: ,x_return_status OUT NOCOPY VARCHAR2
153: ,x_msg_count OUT NOCOPY NUMBER
154: ,x_msg_data OUT NOCOPY VARCHAR2

Line 151: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE

147: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
148: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE
149: ,p_terms_agreed_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE
150: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
151: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
152: ,x_return_status OUT NOCOPY VARCHAR2
153: ,x_msg_count OUT NOCOPY NUMBER
154: ,x_msg_data OUT NOCOPY VARCHAR2
155: );

Line 190: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.contract_number%TYPE

186:
187: PROCEDURE get_k_number (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
188: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
189: ,p_contract_id IN NUMBER
190: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.contract_number%TYPE
191: ,x_contract_number_modifier OUT NOCOPY OKC_K_HEADERS_B.contract_number_modifier%TYPE
192: ,x_return_status OUT NOCOPY VARCHAR2
193: ,x_msg_count OUT NOCOPY NUMBER
194: ,x_msg_data OUT NOCOPY VARCHAR2);

Line 191: ,x_contract_number_modifier OUT NOCOPY OKC_K_HEADERS_B.contract_number_modifier%TYPE

187: PROCEDURE get_k_number (p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
188: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
189: ,p_contract_id IN NUMBER
190: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.contract_number%TYPE
191: ,x_contract_number_modifier OUT NOCOPY OKC_K_HEADERS_B.contract_number_modifier%TYPE
192: ,x_return_status OUT NOCOPY VARCHAR2
193: ,x_msg_count OUT NOCOPY NUMBER
194: ,x_msg_data OUT NOCOPY VARCHAR2);
195:

Line 240: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL

236: ,p_message_body_token2 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
237: ,p_message_body_token2_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
238: ,p_message_body_token3 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
239: ,p_message_body_token3_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
240: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL
241: ,x_k_admin_user_name OUT NOCOPY VARCHAR2
242: ,x_return_status OUT NOCOPY VARCHAR2
243: ,x_msg_count OUT NOCOPY NUMBER
244: ,x_msg_data OUT NOCOPY VARCHAR2);