DBA Data[Home] [Help]

APPS.OKC_OC_INT_PUB dependencies on OKC_K_HEADERS_B

Line 23: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE

19: PROCEDURE create_quote_for_renewal(p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
20: ,x_return_status OUT NOCOPY VARCHAR2
21: ,x_msg_count OUT NOCOPY NUMBER
22: ,x_msg_data OUT NOCOPY VARCHAR2
23: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
24: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
25: );
26:
27:

Line 47: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE DEFAULT OKC_API.g_miss_char

43: -- Out Parameters: x_quote_id Id of created quote
44:
45: PROCEDURE create_quote_from_k(ERRBUF OUT NOCOPY VARCHAR2
46: ,RETCODE OUT NOCOPY NUMBER
47: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE DEFAULT OKC_API.g_miss_char
48: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE
49: --p_contract_number is in fact equal to contract ID
50: ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE DEFAULT OKC_API.g_miss_char
51: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

Line 48: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE

44:
45: PROCEDURE create_quote_from_k(ERRBUF OUT NOCOPY VARCHAR2
46: ,RETCODE OUT NOCOPY NUMBER
47: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE DEFAULT OKC_API.g_miss_char
48: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE
49: --p_contract_number is in fact equal to contract ID
50: ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE DEFAULT OKC_API.g_miss_char
51: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
52: );

Line 61: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE

57: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
58: ,x_return_status OUT NOCOPY VARCHAR2
59: ,x_msg_count OUT NOCOPY NUMBER
60: ,x_msg_data OUT NOCOPY VARCHAR2
61: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
62: ,p_rel_type IN OKC_K_REL_OBJS.rty_code%TYPE DEFAULT OKC_API.g_miss_char
63: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
64: ,x_quote_id OUT NOCOPY okx_quote_headers_v.id1%TYPE
65: );

Line 87: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE

83: --
84: PROCEDURE update_quote_from_k(ERRBUF OUT NOCOPY VARCHAR2
85: ,RETCODE OUT NOCOPY NUMBER
86: --
87: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE
88: -- p_contract_number is in fact equal to contract ID
89: --
90: ,p_quote_number IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
91: -- p_quote_number is in fact equal to quote ID

Line 101: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE

97: PROCEDURE update_quote_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
98: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
99: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
100: ,p_quote_id IN OKX_QUOTE_HEADERS_V.id1%TYPE DEFAULT OKC_API.G_MISS_NUM
101: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
102: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
103: ,x_return_status OUT NOCOPY VARCHAR2
104: ,x_msg_count OUT NOCOPY NUMBER
105: ,x_msg_data OUT NOCOPY VARCHAR2

Line 134: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE DEFAULT OKC_API.g_miss_char

130: -------------------------------------------------------------------------------
131:
132: PROCEDURE create_order_from_k(ERRBUF OUT NOCOPY VARCHAR2
133: ,RETCODE OUT NOCOPY NUMBER
134: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE DEFAULT OKC_API.g_miss_char
135: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE
136: --
137: -- p_contract_number is in fact equal to contract ID
138: --

Line 135: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE

131:
132: PROCEDURE create_order_from_k(ERRBUF OUT NOCOPY VARCHAR2
133: ,RETCODE OUT NOCOPY NUMBER
134: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE DEFAULT OKC_API.g_miss_char
135: ,p_contract_number IN OKC_K_HEADERS_B.ID%TYPE
136: --
137: -- p_contract_number is in fact equal to contract ID
138: --
139: ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE DEFAULT OKC_API.g_miss_char

Line 150: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE

146: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
147: ,x_return_status OUT NOCOPY VARCHAR2
148: ,x_msg_count OUT NOCOPY NUMBER
149: ,x_msg_data OUT NOCOPY VARCHAR2
150: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE
151: ,p_rel_type IN OKC_K_REL_OBJS.rty_code%TYPE DEFAULT OKC_API.g_miss_char
152: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
153: ,x_order_id OUT NOCOPY okx_order_headers_v.id1%TYPE
154: );

Line 191: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE DEFAULT OKC_API.g_miss_char

187: -- Bug : 1686001 Changed references to ASO_QUOTE_HEADERS_ALL.QUOTE_HEADER_ID to OKX_QUOTE_HEADERS_V.ID1
188: PROCEDURE create_k_from_quote(ERRBUF OUT NOCOPY VARCHAR2
189: ,RETCODE OUT NOCOPY NUMBER
190: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
191: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE DEFAULT OKC_API.g_miss_char
192: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
193: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
194: ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE DEFAULT OKC_API.g_miss_char
195: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR

Line 192: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE

188: PROCEDURE create_k_from_quote(ERRBUF OUT NOCOPY VARCHAR2
189: ,RETCODE OUT NOCOPY NUMBER
190: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
191: ,p_contract_category IN OKC_K_HEADERS_B.SCS_CODE%TYPE DEFAULT OKC_API.g_miss_char
192: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE
193: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
194: ,p_rel_type IN FND_LOOKUPS.LOOKUP_CODE%TYPE DEFAULT OKC_API.g_miss_char
195: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
196: );

Line 203: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM

199: PROCEDURE create_k_from_quote(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
200: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
201: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
202: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
203: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
204: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
205: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE DEFAULT OKC_API.G_MISS_CHAR
206: ,p_terms_agreed_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE
207: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

204: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
205: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE DEFAULT OKC_API.G_MISS_CHAR
206: ,p_terms_agreed_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE
207: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
208: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
209: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
210: ,x_return_status OUT NOCOPY VARCHAR2
211: ,x_msg_count OUT NOCOPY NUMBER
212: ,x_msg_data OUT NOCOPY VARCHAR2

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

205: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE DEFAULT OKC_API.G_MISS_CHAR
206: ,p_terms_agreed_flag IN VARCHAR2 DEFAULT OKC_API.G_FALSE
207: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
208: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
209: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE
210: ,x_return_status OUT NOCOPY VARCHAR2
211: ,x_msg_count OUT NOCOPY NUMBER
212: ,x_msg_data OUT NOCOPY VARCHAR2
213: );

Line 236: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM

232: PROCEDURE create_k_from_quote(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
233: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
234: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
235: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE
236: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
237: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
238: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE DEFAULT OKC_API.G_MISS_CHAR
239: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
240: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE

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

236: ,p_template_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
237: ,p_template_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
238: ,p_rel_type IN OKC_K_REL_OBJS.RTY_CODE%TYPE DEFAULT OKC_API.G_MISS_CHAR
239: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
240: ,x_contract_id OUT NOCOPY OKC_K_HEADERS_B.ID%TYPE
241: ,x_return_status OUT NOCOPY VARCHAR2
242: ,x_msg_count OUT NOCOPY NUMBER
243: ,x_msg_data OUT NOCOPY VARCHAR2
244: );

Line 282: ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM

278:
279: PROCEDURE create_k_relationships(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
280: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
281: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
282: ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
283: ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
284: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
285: ,p_quote_line_tab IN OKC_OC_INT_PUB.OKC_QUOTE_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_QL_TAB
286: ,p_order_id IN OKX_ORDER_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM

Line 283: ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM

279: PROCEDURE create_k_relationships(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
280: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
281: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
282: ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
283: ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
284: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
285: ,p_quote_line_tab IN OKC_OC_INT_PUB.OKC_QUOTE_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_QL_TAB
286: ,p_order_id IN OKX_ORDER_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
287: ,p_order_line_tab IN OKC_OC_INT_PUB.OKC_ORDER_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_OL_TAB

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

367: ,p_message_body_token2_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
368: ,p_message_body_token3 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
369: ,p_message_body_token3_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
370: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
371: ,p_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL
372: ,x_k_admin_user_name OUT NOCOPY VARCHAR2
373: ,x_return_status OUT NOCOPY VARCHAR2
374: ,x_msg_count OUT NOCOPY NUMBER
375: ,x_msg_data OUT NOCOPY VARCHAR2

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

408: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
409: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
410: ,p_contract_id IN NUMBER
411: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
412: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.contract_number%TYPE
413: ,x_contract_number_modifier OUT NOCOPY OKC_K_HEADERS_B.contract_number_modifier%TYPE
414: ,x_return_status OUT NOCOPY VARCHAR2
415: ,x_msg_count OUT NOCOPY NUMBER
416: ,x_msg_data OUT NOCOPY VARCHAR2);

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

409: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
410: ,p_contract_id IN NUMBER
411: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
412: ,x_contract_number OUT NOCOPY OKC_K_HEADERS_B.contract_number%TYPE
413: ,x_contract_number_modifier OUT NOCOPY OKC_K_HEADERS_B.contract_number_modifier%TYPE
414: ,x_return_status OUT NOCOPY VARCHAR2
415: ,x_msg_count OUT NOCOPY NUMBER
416: ,x_msg_data OUT NOCOPY VARCHAR2);
417: