DBA Data[Home] [Help]

APPS.OKC_CREATE_PO_FROM_K_PUB dependencies on OKC_API

Line 20: PROCEDURE create_po_from_k(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM

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

Line 21: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 22: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 40: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE

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:

Line 50: PROCEDURE notify_buyer(p_api_version IN NUMBER DEFAULT OKC_API.G_MISS_NUM

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

Line 51: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 52: ,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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

Line 53: ,p_application_name 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

Line 54: ,p_message_subject IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE 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

Line 55: ,p_message_body IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE 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

Line 56: ,p_message_body_token1 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

Line 57: ,p_message_body_token1_value 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

Line 58: ,p_message_body_token2 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

Line 59: ,p_message_body_token2_value IN VARCHAR2 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

Line 60: ,p_message_body_token3 IN VARCHAR2 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

Line 61: ,p_message_body_token3_value 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

Line 62: ,p_trace_mode IN VARCHAR2 DEFAULT OKC_API.G_FALSE

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