12:
13: ---------------------------------------------------------------------------
14: -- GLOBAL MESSAGE CONSTANTS
15: ---------------------------------------------------------------------------
16: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
19: G_INVALID_ACTION_STATUS CONSTANT VARCHAR2(200) := 'INVALID_ACTION_STATUS';
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
14: -- GLOBAL MESSAGE CONSTANTS
15: ---------------------------------------------------------------------------
16: G_FND_APP CONSTANT VARCHAR2(200) := Okc_Api.G_FND_APP;
17: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := 'OKL_REQUIRED_VALUE';
18: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okc_Api.G_INVALID_VALUE;
19: G_INVALID_ACTION_STATUS CONSTANT VARCHAR2(200) := 'INVALID_ACTION_STATUS';
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME';
21: G_COL_NAME1_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME1';
22: G_COL_NAME2_TOKEN CONSTANT VARCHAR2(200) := 'COL_NAME2';
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
108: p_interface_id IN NUMBER,
109: p_report_date IN DATE,
110: p_comments IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2);
114:
121: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
122: p_interface_id IN NUMBER,
123: p_hst_id IN NUMBER,
124: p_notification_date IN DATE,
125: p_comments IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_count OUT NOCOPY NUMBER,
128: x_msg_data OUT NOCOPY VARCHAR2);
129:
135: p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
137: p_interface_id IN NUMBER,
138: p_transfer_date IN DATE,
139: p_comments IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2);
143:
150: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
151: p_interface_id IN NUMBER,
152: p_hst_id IN NUMBER,
153: p_notification_date IN DATE,
154: p_comments IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2);
158:
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
167: p_interface_id IN NUMBER,
168: p_recall_date IN DATE,
169: p_comments IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
170: p_ext_agncy_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2);
166: p_init_msg_list IN VARCHAR2 DEFAULT okl_api.G_FALSE,
167: p_interface_id IN NUMBER,
168: p_recall_date IN DATE,
169: p_comments IN VARCHAR2 DEFAULT OKC_API.G_MISS_CHAR,
170: p_ext_agncy_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2);
174: