DBA Data[Home] [Help]

APPS.OKE_STANDARD_NOTES_PUB dependencies on OKE_NOTE_PVT

Line 7: SUBTYPE note_rec_type IS oke_note_pvt.note_rec_type;

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(
10:
11: p_api_version IN NUMBER,

Line 17: p_note_rec IN oke_note_pvt.note_rec_type,

13: x_return_status OUT NOCOPY VARCHAR2,
14: x_msg_count OUT NOCOPY NUMBER,
15: x_msg_data OUT NOCOPY VARCHAR2,
16:
17: p_note_rec IN oke_note_pvt.note_rec_type,
18: x_note_rec OUT NOCOPY oke_note_pvt.note_rec_type);
19:
20: PROCEDURE create_standard_note(
21: p_api_version IN NUMBER,

Line 18: x_note_rec OUT NOCOPY oke_note_pvt.note_rec_type);

14: x_msg_count OUT NOCOPY NUMBER,
15: x_msg_data OUT NOCOPY VARCHAR2,
16:
17: p_note_rec IN oke_note_pvt.note_rec_type,
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,

Line 27: p_note_tbl IN oke_note_pvt.note_tbl_type,

23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,
25: x_msg_data OUT NOCOPY VARCHAR2,
26:
27: p_note_tbl IN oke_note_pvt.note_tbl_type,
28: x_note_tbl OUT NOCOPY oke_note_pvt.note_tbl_type);
29:
30:
31: PROCEDURE update_standard_note(

Line 28: x_note_tbl OUT NOCOPY oke_note_pvt.note_tbl_type);

24: x_msg_count OUT NOCOPY NUMBER,
25: x_msg_data OUT NOCOPY VARCHAR2,
26:
27: p_note_tbl IN oke_note_pvt.note_tbl_type,
28: x_note_tbl OUT NOCOPY oke_note_pvt.note_tbl_type);
29:
30:
31: PROCEDURE update_standard_note(
32: p_api_version IN NUMBER,

Line 37: p_note_rec IN oke_note_pvt.note_rec_type,

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,
38: x_note_rec OUT NOCOPY oke_note_pvt.note_rec_type);
39:
40:
41: PROCEDURE update_standard_note(

Line 38: x_note_rec OUT NOCOPY oke_note_pvt.note_rec_type);

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,
38: x_note_rec OUT NOCOPY oke_note_pvt.note_rec_type);
39:
40:
41: PROCEDURE update_standard_note(
42: p_api_version IN NUMBER,

Line 47: p_note_tbl IN oke_note_pvt.note_tbl_type,

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,
48: x_note_tbl OUT NOCOPY oke_note_pvt.note_tbl_type);
49:
50:
51: PROCEDURE delete_standard_note(

Line 48: x_note_tbl OUT NOCOPY oke_note_pvt.note_tbl_type);

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,
48: x_note_tbl OUT NOCOPY oke_note_pvt.note_tbl_type);
49:
50:
51: PROCEDURE delete_standard_note(
52: p_api_version IN NUMBER,

Line 57: p_note_rec IN oke_note_pvt.note_rec_type);

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);
58:
59:
60: PROCEDURE delete_standard_note(
61: p_api_version IN NUMBER,

Line 66: p_note_tbl IN oke_note_pvt.note_tbl_type);

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);
67:
68:
69: /* this one below takes in standard_note_id straight */
70:

Line 100: p_note_rec IN oke_note_pvt.note_rec_type);

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);
101:
102: PROCEDURE validate_standard_note(
103: p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 108: p_note_tbl IN oke_note_pvt.note_tbl_type);

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);
109:
110:
111: /*
112: 10/11/2000

Line 163: p_note_rec IN OKE_NOTE_PVT.note_rec_type);

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);
164:
165: PROCEDURE lock_standard_note(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 171: p_note_tbl IN oke_note_pvt.note_tbl_type);

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);
172:
173: END OKE_STANDARD_NOTES_PUB;
174: