DBA Data[Home] [Help]

APPS.OKE_STANDARD_NOTES_PUB dependencies on OKE_API

Line 5: G_APP_NAME CONSTANT VARCHAR2(200) := OKE_API.G_APP_NAME;

1: PACKAGE OKE_STANDARD_NOTES_PUB AUTHID CURRENT_USER AS
2: /* $Header: OKEPNOTS.pls 115.6 2002/08/14 01:42:27 alaw ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_STANDARD_NOTES_PUB';
5: G_APP_NAME CONSTANT VARCHAR2(200) := OKE_API.G_APP_NAME;
6:
7: SUBTYPE note_rec_type IS oke_note_pvt.note_rec_type;
8:
9: PROCEDURE create_standard_note(

Line 12: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

8:
9: PROCEDURE create_standard_note(
10:
11: p_api_version IN NUMBER,
12: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
13: x_return_status OUT NOCOPY VARCHAR2,
14: x_msg_count OUT NOCOPY NUMBER,
15: x_msg_data OUT NOCOPY VARCHAR2,
16:

Line 22: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

18: x_note_rec OUT NOCOPY oke_note_pvt.note_rec_type);
19:
20: PROCEDURE create_standard_note(
21: p_api_version IN NUMBER,
22: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,
25: x_msg_data OUT NOCOPY VARCHAR2,
26:

Line 33: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

29:
30:
31: PROCEDURE update_standard_note(
32: p_api_version IN NUMBER,
33: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
34: x_return_status OUT NOCOPY VARCHAR2,
35: x_msg_count OUT NOCOPY NUMBER,
36: x_msg_data OUT NOCOPY VARCHAR2,
37: p_note_rec IN oke_note_pvt.note_rec_type,

Line 43: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

39:
40:
41: PROCEDURE update_standard_note(
42: p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
44: x_return_status OUT NOCOPY VARCHAR2,
45: x_msg_count OUT NOCOPY NUMBER,
46: x_msg_data OUT NOCOPY VARCHAR2,
47: p_note_tbl IN oke_note_pvt.note_tbl_type,

Line 53: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

49:
50:
51: PROCEDURE delete_standard_note(
52: p_api_version IN NUMBER,
53: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
54: x_return_status OUT NOCOPY VARCHAR2,
55: x_msg_count OUT NOCOPY NUMBER,
56: x_msg_data OUT NOCOPY VARCHAR2,
57: p_note_rec IN oke_note_pvt.note_rec_type);

Line 62: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

58:
59:
60: PROCEDURE delete_standard_note(
61: p_api_version IN NUMBER,
62: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
63: x_return_status OUT NOCOPY VARCHAR2,
64: x_msg_count OUT NOCOPY NUMBER,
65: x_msg_data OUT NOCOPY VARCHAR2,
66: p_note_tbl IN oke_note_pvt.note_tbl_type);

Line 73: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

69: /* this one below takes in standard_note_id straight */
70:
71: PROCEDURE delete_standard_note(
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2,
77: p_note_id IN NUMBER);

Line 85: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

81: the other two Must be left NULL */
82:
83: PROCEDURE delete_standard_note(
84: p_api_version IN NUMBER,
85: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,
89: p_hdr_id IN NUMBER,

Line 96: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

92:
93:
94: PROCEDURE validate_standard_note(
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2,
100: p_note_rec IN oke_note_pvt.note_rec_type);

Line 104: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

100: p_note_rec IN oke_note_pvt.note_rec_type);
101:
102: PROCEDURE validate_standard_note(
103: p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,
108: p_note_tbl IN oke_note_pvt.note_tbl_type);

Line 143: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

139: */
140:
141: PROCEDURE copy_standard_note(
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147: p_from_hdr_id IN NUMBER,

Line 159: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

155:
156:
157: PROCEDURE lock_standard_note(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_note_rec IN OKE_NOTE_PVT.note_rec_type);

Line 167: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

163: p_note_rec IN OKE_NOTE_PVT.note_rec_type);
164:
165: PROCEDURE lock_standard_note(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_note_tbl IN oke_note_pvt.note_tbl_type);