1 PACKAGE OKC_CREATE_PO_FROM_K_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKCPKPOS.pls 120.0 2005/05/25 23:13:47 appldev noship $ */
3
4 -------------------------------------------------------------------------------
5 -- Procedure: create_po_from_k
6 -- Version: 1.0
7 -- Purpose: The first one is planned to be called by a Conc. Prog.
8 -- and calls itself the second one
9 -- Public face for the API to create PO out of Active/signed buy contracts
10
11
12 PROCEDURE create_po_from_k(ERRBUF OUT NOCOPY VARCHAR2
13 ,RETCODE OUT NOCOPY NUMBER
14 ,p_contract_id IN okc_k_headers_b.ID%TYPE
15 );
16
17 -- we might later want to modify this to return the po number of the craeted PO since we are going to call
18 -- PDOI from inside this
19 -- take out p_batch_id then as it will be generated from inside the code now.
20 PROCEDURE create_po_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
21 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
22 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
23 ,p_contract_id IN okc_k_headers_b.ID%TYPE
24 ,x_return_status OUT NOCOPY VARCHAR2
25 ,x_msg_count OUT NOCOPY NUMBER
26 ,x_msg_data OUT NOCOPY VARCHAR2);
27
28
29 -------------------------------------------------------------------------------
30 -- Procedure: submit_req_for_po_creation
31 -- Version: 1.0
32 -- Purpose: This procedure is called from a condition when the
33 -- contract is signed to automate PO creation without running the
34 -- concurrent program
35 -------------------------------------------------------------------------------
36
37 PROCEDURE submit_req_for_po_creation(
38 p_api_version IN NUMBER DEFAULT 1
39 ,p_contract_id IN NUMBER
40 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
41 ,x_return_status OUT NOCOPY VARCHAR2
42 ,x_msg_count OUT NOCOPY NUMBER
43 ,x_msg_data OUT NOCOPY VARCHAR2);
44
45 -------------------------------------------------------------------------------
46 -- Procedure: notify_buyer
47 -- Version: 1.0
48 -- Purpose: notify the buyer of a purchase order creation
49 -------------------------------------------------------------------------------
50 PROCEDURE notify_buyer(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM
51 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
52 ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
53 ,p_application_name IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
54 ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
55 ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE DEFAULT OKC_API.G_MISS_CHAR
56 ,p_message_body_token1 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
57 ,p_message_body_token1_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
58 ,p_message_body_token2 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
59 ,p_message_body_token2_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
60 ,p_message_body_token3 IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
61 ,p_message_body_token3_value IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR
62 ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE
63 ,p_chr_id IN OKC_K_HEADERS_B.ID%TYPE DEFAULT NULL
64 ,x_k_buyer_name OUT NOCOPY VARCHAR2
65 ,x_return_status OUT NOCOPY VARCHAR2
66 ,x_msg_count OUT NOCOPY NUMBER
67 ,x_msg_data OUT NOCOPY VARCHAR2);
68
69
70 END OKC_CREATE_PO_FROM_K_PUB;
[Home] [Help]