APPS.OKC_CREATE_PO_FROM_K_PUB dependencies on OKC_K_HEADERS_B

Line 10: ,p_chr_id IN okc_k_headers_b.ID%TYPE

6: -- Local private procedures not declared in specification
7:
8: PROCEDURE submit_pdoi_errors_report( p_api_version IN NUMBER
9: ,p_init_msg_list IN VARCHAR2
10: ,p_chr_id IN okc_k_headers_b.ID%TYPE
11: ,x_return_status OUT NOCOPY VARCHAR2
12: ,x_msg_count OUT NOCOPY NUMBER
13: ,x_msg_data OUT NOCOPY VARCHAR2);
14:

Line 52: ,p_contract_id IN okc_k_headers_b.ID%TYPE

48: -- This will be a wrapper for create_PO_from_k
49: -- procedure described below
50: PROCEDURE create_po_from_k(ERRBUF OUT NOCOPY VARCHAR2
51: ,RETCODE OUT NOCOPY NUMBER
52: ,p_contract_id IN okc_k_headers_b.ID%TYPE
53: ) IS
54:
55: l_api_version CONSTANT NUMBER := 1;
56: lx_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 95: FROM okc_k_headers_b

91: -- select contract number and contract number modifier
92:
93: SELECT contract_number, contract_number_modifier
94: INTO l_k_number, l_k_number_modifier
95: FROM okc_k_headers_b
96: WHERE id = p_contract_id;
97:
98: l_k_number_modifier := nvl(l_k_number_modifier, ' ');
99:

Line 264: ,p_contract_id IN okc_k_headers_b.ID%TYPE

260:
261: PROCEDURE create_po_from_k(p_api_version IN NUMBER
262: ,p_init_msg_list IN VARCHAR2
263: ,p_commit IN VARCHAR2
264: ,p_contract_id IN okc_k_headers_b.ID%TYPE
265: ,x_return_status OUT NOCOPY VARCHAR2
266: ,x_msg_count OUT NOCOPY NUMBER
267: ,x_msg_data OUT NOCOPY VARCHAR2)IS
268:

Line 437: FROM okc_k_headers_b

433: );
434:
435: SELECT contract_number_modifier
436: INTO l_k_number_modifier
437: FROM okc_k_headers_b
438: WHERE id = p_contract_id;
439:
440: l_k_number_modifier := nvl(l_k_number_modifier, ' ');
441:

Line 514: ,p_chr_id IN okc_k_headers_b.ID%TYPE

510: ------------------------------------------------------------
511:
512: PROCEDURE submit_pdoi_errors_report( p_api_version IN NUMBER
513: ,p_init_msg_list IN VARCHAR2
514: ,p_chr_id IN okc_k_headers_b.ID%TYPE
515: ,x_return_status OUT NOCOPY VARCHAR2
516: ,x_msg_count OUT NOCOPY NUMBER
517: ,x_msg_data OUT NOCOPY VARCHAR2)IS
518:

Line 582: ,p_chr_id IN OKC_K_HEADERS_B.ID%TYPE

578: ,p_message_body_token2_value IN VARCHAR2
579: ,p_message_body_token3 IN VARCHAR2
580: ,p_message_body_token3_value IN VARCHAR2
581: ,p_trace_mode IN VARCHAR2
582: ,p_chr_id IN OKC_K_HEADERS_B.ID%TYPE
583: ,x_k_buyer_name OUT NOCOPY VARCHAR2
584: ,x_return_status OUT NOCOPY VARCHAR2
585: ,x_msg_count OUT NOCOPY NUMBER
586: ,x_msg_data OUT NOCOPY VARCHAR2) IS