45: -- Out Parameters: x_order_id Id of created order
46: --
47:
48: PROCEDURE create_order_from_k( p_api_version IN NUMBER
49: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
50: ,x_return_status OUT NOCOPY VARCHAR2
51: ,x_msg_count OUT NOCOPY NUMBER
52: ,x_msg_data OUT NOCOPY VARCHAR2
53: --
51: ,x_msg_count OUT NOCOPY NUMBER
52: ,x_msg_data OUT NOCOPY VARCHAR2
53: --
54: ,p_contract_id IN okc_k_headers_b.ID%TYPE
55: ,p_rel_type IN okc_k_rel_objs.rty_code%TYPE DEFAULT OKC_API.g_miss_char
56: --
57: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
58: ,x_order_id OUT NOCOPY okx_order_headers_v.id1%TYPE
59: );
53: --
54: ,p_contract_id IN okc_k_headers_b.ID%TYPE
55: ,p_rel_type IN okc_k_rel_objs.rty_code%TYPE DEFAULT OKC_API.g_miss_char
56: --
57: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
58: ,x_order_id OUT NOCOPY okx_order_headers_v.id1%TYPE
59: );
60:
61: -- ---------------------------------------------------------------------------
82: -- p_order_line_tab Order line ids (PL/SQL table)
83: --
84: -- Out Parameters: x_return_status Final status of the O-K relationship
85: -- creation API:
86: -- OKC_API.G_RET_STS_SUCCESS
87: -- OKC_API.G_RET_STS_ERROR
88: -- OKC_API.G_RET_STS_UNEXP_ERROR
89:
90: PROCEDURE create_k_relationships(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
83: --
84: -- Out Parameters: x_return_status Final status of the O-K relationship
85: -- creation API:
86: -- OKC_API.G_RET_STS_SUCCESS
87: -- OKC_API.G_RET_STS_ERROR
88: -- OKC_API.G_RET_STS_UNEXP_ERROR
89:
90: PROCEDURE create_k_relationships(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
91: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
84: -- Out Parameters: x_return_status Final status of the O-K relationship
85: -- creation API:
86: -- OKC_API.G_RET_STS_SUCCESS
87: -- OKC_API.G_RET_STS_ERROR
88: -- OKC_API.G_RET_STS_UNEXP_ERROR
89:
90: PROCEDURE create_k_relationships(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
91: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
92: ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
86: -- OKC_API.G_RET_STS_SUCCESS
87: -- OKC_API.G_RET_STS_ERROR
88: -- OKC_API.G_RET_STS_UNEXP_ERROR
89:
90: PROCEDURE create_k_relationships(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
91: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
92: ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
93: ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
94: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
87: -- OKC_API.G_RET_STS_ERROR
88: -- OKC_API.G_RET_STS_UNEXP_ERROR
89:
90: PROCEDURE create_k_relationships(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
91: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
92: ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
93: ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
94: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
95: ,p_quote_line_tab IN OKC_OC_INT_PUB.OKC_QUOTE_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_QL_TAB
88: -- OKC_API.G_RET_STS_UNEXP_ERROR
89:
90: PROCEDURE create_k_relationships(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
91: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
92: ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
93: ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
94: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
95: ,p_quote_line_tab IN OKC_OC_INT_PUB.OKC_QUOTE_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_QL_TAB
96: ,p_order_id IN OKX_ORDER_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
89:
90: PROCEDURE create_k_relationships(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
91: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
92: ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
93: ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
94: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
95: ,p_quote_line_tab IN OKC_OC_INT_PUB.OKC_QUOTE_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_QL_TAB
96: ,p_order_id IN OKX_ORDER_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
97: ,p_order_line_tab IN OKC_OC_INT_PUB.OKC_ORDER_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_OL_TAB
90: PROCEDURE create_k_relationships(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
91: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
92: ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
93: ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
94: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
95: ,p_quote_line_tab IN OKC_OC_INT_PUB.OKC_QUOTE_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_QL_TAB
96: ,p_order_id IN OKX_ORDER_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
97: ,p_order_line_tab IN OKC_OC_INT_PUB.OKC_ORDER_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_OL_TAB
98: ,x_return_status OUT NOCOPY VARCHAR2
92: ,p_sales_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
93: ,p_service_contract_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT OKC_API.G_MISS_NUM
94: ,p_quote_id IN OKX_QUOTE_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
95: ,p_quote_line_tab IN OKC_OC_INT_PUB.OKC_QUOTE_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_QL_TAB
96: ,p_order_id IN OKX_ORDER_HEADERS_V.ID1%TYPE DEFAULT OKC_API.G_MISS_NUM
97: ,p_order_line_tab IN OKC_OC_INT_PUB.OKC_ORDER_LINE_TAB DEFAULT OKC_OC_INT_PUB.G_MISS_OL_TAB
98: ,x_return_status OUT NOCOPY VARCHAR2
99: ,x_msg_count OUT NOCOPY NUMBER
100: ,x_msg_data OUT NOCOPY VARCHAR2