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
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
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);
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:
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
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
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
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
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
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
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
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
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
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
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
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
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