22:
23: PROCEDURE create_order_from_k(ERRBUF OUT NOCOPY VARCHAR2
24: ,RETCODE OUT NOCOPY NUMBER
25: ,p_contract_id IN okc_k_headers_b.ID%TYPE
26: ,p_default_date IN DATE DEFAULT OKC_API.G_MISS_DATE
27: ,P_Customer_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
28: ,P_Grp_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
29: ,P_org_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
30: ,P_contract_hdr_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
23: PROCEDURE create_order_from_k(ERRBUF OUT NOCOPY VARCHAR2
24: ,RETCODE OUT NOCOPY NUMBER
25: ,p_contract_id IN okc_k_headers_b.ID%TYPE
26: ,p_default_date IN DATE DEFAULT OKC_API.G_MISS_DATE
27: ,P_Customer_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
28: ,P_Grp_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
29: ,P_org_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
30: ,P_contract_hdr_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
31: ,P_contract_hdr_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
24: ,RETCODE OUT NOCOPY NUMBER
25: ,p_contract_id IN okc_k_headers_b.ID%TYPE
26: ,p_default_date IN DATE DEFAULT OKC_API.G_MISS_DATE
27: ,P_Customer_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
28: ,P_Grp_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
29: ,P_org_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
30: ,P_contract_hdr_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
31: ,P_contract_hdr_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
32: -- Bug 4915691 --
25: ,p_contract_id IN okc_k_headers_b.ID%TYPE
26: ,p_default_date IN DATE DEFAULT OKC_API.G_MISS_DATE
27: ,P_Customer_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
28: ,P_Grp_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
29: ,P_org_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
30: ,P_contract_hdr_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
31: ,P_contract_hdr_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
32: -- Bug 4915691 --
33: ,P_contract_line_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
26: ,p_default_date IN DATE DEFAULT OKC_API.G_MISS_DATE
27: ,P_Customer_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
28: ,P_Grp_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
29: ,P_org_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
30: ,P_contract_hdr_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
31: ,P_contract_hdr_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
32: -- Bug 4915691 --
33: ,P_contract_line_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
34: ,P_contract_line_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
27: ,P_Customer_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
28: ,P_Grp_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
29: ,P_org_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
30: ,P_contract_hdr_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
31: ,P_contract_hdr_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
32: -- Bug 4915691 --
33: ,P_contract_line_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
34: ,P_contract_line_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
35: -- Bug 4915691 --
29: ,P_org_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
30: ,P_contract_hdr_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
31: ,P_contract_hdr_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
32: -- Bug 4915691 --
33: ,P_contract_line_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
34: ,P_contract_line_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
35: -- Bug 4915691 --
36: );
37:
30: ,P_contract_hdr_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
31: ,P_contract_hdr_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
32: -- Bug 4915691 --
33: ,P_contract_line_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
34: ,P_contract_line_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
35: -- Bug 4915691 --
36: );
37:
38:
35: -- Bug 4915691 --
36: );
37:
38:
39: PROCEDURE create_order_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
40: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
41: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
42: ,x_return_status OUT NOCOPY VARCHAR2
43: ,x_msg_count OUT NOCOPY NUMBER
36: );
37:
38:
39: PROCEDURE create_order_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
40: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
41: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
42: ,x_return_status OUT NOCOPY VARCHAR2
43: ,x_msg_count OUT NOCOPY NUMBER
44: ,x_msg_data OUT NOCOPY VARCHAR2
37:
38:
39: PROCEDURE create_order_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
40: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
41: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
42: ,x_return_status OUT NOCOPY VARCHAR2
43: ,x_msg_count OUT NOCOPY NUMBER
44: ,x_msg_data OUT NOCOPY VARCHAR2
45: ,p_contract_id IN okc_k_headers_b.ID%TYPE
42: ,x_return_status OUT NOCOPY VARCHAR2
43: ,x_msg_count OUT NOCOPY NUMBER
44: ,x_msg_data OUT NOCOPY VARCHAR2
45: ,p_contract_id IN okc_k_headers_b.ID%TYPE
46: ,p_default_date IN DATE DEFAULT OKC_API.G_MISS_DATE
47: ,P_Customer_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
48: ,P_Grp_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
49: ,P_org_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
50: ,P_contract_hdr_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
43: ,x_msg_count OUT NOCOPY NUMBER
44: ,x_msg_data OUT NOCOPY VARCHAR2
45: ,p_contract_id IN okc_k_headers_b.ID%TYPE
46: ,p_default_date IN DATE DEFAULT OKC_API.G_MISS_DATE
47: ,P_Customer_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
48: ,P_Grp_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
49: ,P_org_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
50: ,P_contract_hdr_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
51: ,P_contract_hdr_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
44: ,x_msg_data OUT NOCOPY VARCHAR2
45: ,p_contract_id IN okc_k_headers_b.ID%TYPE
46: ,p_default_date IN DATE DEFAULT OKC_API.G_MISS_DATE
47: ,P_Customer_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
48: ,P_Grp_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
49: ,P_org_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
50: ,P_contract_hdr_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
51: ,P_contract_hdr_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
52: -- Bug 4915691 --
45: ,p_contract_id IN okc_k_headers_b.ID%TYPE
46: ,p_default_date IN DATE DEFAULT OKC_API.G_MISS_DATE
47: ,P_Customer_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
48: ,P_Grp_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
49: ,P_org_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
50: ,P_contract_hdr_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
51: ,P_contract_hdr_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
52: -- Bug 4915691 --
53: ,P_contract_line_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
46: ,p_default_date IN DATE DEFAULT OKC_API.G_MISS_DATE
47: ,P_Customer_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
48: ,P_Grp_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
49: ,P_org_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
50: ,P_contract_hdr_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
51: ,P_contract_hdr_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
52: -- Bug 4915691 --
53: ,P_contract_line_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
54: ,P_contract_line_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
47: ,P_Customer_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
48: ,P_Grp_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
49: ,P_org_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
50: ,P_contract_hdr_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
51: ,P_contract_hdr_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
52: -- Bug 4915691 --
53: ,P_contract_line_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
54: ,P_contract_line_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
55:
49: ,P_org_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM
50: ,P_contract_hdr_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
51: ,P_contract_hdr_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
52: -- Bug 4915691 --
53: ,P_contract_line_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
54: ,P_contract_line_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
55:
56: -- Bug 4915691 --
57:
50: ,P_contract_hdr_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
51: ,P_contract_hdr_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
52: -- Bug 4915691 --
53: ,P_contract_line_id_lo in NUMBER DEFAULT OKC_API.G_MISS_NUM
54: ,P_contract_line_id_hi in NUMBER DEFAULT OKC_API.G_MISS_NUM
55:
56: -- Bug 4915691 --
57:
58: ,x_order_id OUT NOCOPY okx_order_headers_v.id1%TYPE