eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_STANDARD_NOTES_PUB dependencies on STANDARD

Line 1: PACKAGE OKE_STANDARD_NOTES_PUB AUTHID CURRENT_USER AS

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;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKE_STANDARD_NOTES_PUB';

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:

Line 9: PROCEDURE create_standard_note(

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,
12: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
13: x_return_status OUT NOCOPY VARCHAR2,

Line 20: PROCEDURE create_standard_note(

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,
23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,

Line 31: PROCEDURE update_standard_note(

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,
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,

Line 41: PROCEDURE update_standard_note(

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,
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,

Line 51: PROCEDURE delete_standard_note(

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,
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,

Line 60: PROCEDURE delete_standard_note(

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,
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,

Line 69: /* this one below takes in standard_note_id straight */

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:
71: PROCEDURE delete_standard_note(
72: p_api_version IN NUMBER,
73: p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,

Line 71: PROCEDURE delete_standard_note(

67:
68:
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,

Line 83: PROCEDURE delete_standard_note(

79:
80: /* this one takes one of these three, k_header_id,k_line_id,deliverable_id
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,

Line 94: PROCEDURE validate_standard_note(

90: p_cle_id IN NUMBER,
91: p_del_id IN NUMBER);
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,

Line 102: PROCEDURE validate_standard_note(

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,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,

Line 119: This is where the standard_note(s) will be sourced. For example,

115: The new way of using this procedure is as follows:
116:
117: You still specify only one 'from' value.
118: either p_from_hdr_id, p_from_cle_id or p_from_del_id.
119: This is where the standard_note(s) will be sourced. For example,
120: if you specify a p_from_hdr_id, the procedure will grab all
121: the standard_notes belonging to that header
122: (but NOT its children).
123:

Line 121: the standard_notes belonging to that header

117: You still specify only one 'from' value.
118: either p_from_hdr_id, p_from_cle_id or p_from_del_id.
119: This is where the standard_note(s) will be sourced. For example,
120: if you specify a p_from_hdr_id, the procedure will grab all
121: the standard_notes belonging to that header
122: (but NOT its children).
123:
124: However, now you can specify one or more 'to' values.
125: If you do not specify a particular 'to' value ( p_to_hdr_id,

Line 127: deliverable_id will be copied along from the old standard_note

123:
124: However, now you can specify one or more 'to' values.
125: If you do not specify a particular 'to' value ( p_to_hdr_id,
126: p_to_cle_id or p_to_del_id ), then the k_header_id,k_line_id,
127: deliverable_id will be copied along from the old standard_note
128: record into the new standard_note record respectively.
129:
130: Note: if you do not specify any of the 3 'to' values, you would
131: have basically copied the standard_notes from the origin back

Line 128: record into the new standard_note record respectively.

124: However, now you can specify one or more 'to' values.
125: If you do not specify a particular 'to' value ( p_to_hdr_id,
126: p_to_cle_id or p_to_del_id ), then the k_header_id,k_line_id,
127: deliverable_id will be copied along from the old standard_note
128: record into the new standard_note record respectively.
129:
130: Note: if you do not specify any of the 3 'to' values, you would
131: have basically copied the standard_notes from the origin back
132: into the origin, creating a duplicate!

Line 131: have basically copied the standard_notes from the origin back

127: deliverable_id will be copied along from the old standard_note
128: record into the new standard_note record respectively.
129:
130: Note: if you do not specify any of the 3 'to' values, you would
131: have basically copied the standard_notes from the origin back
132: into the origin, creating a duplicate!
133:
134: ---!!ATTENTION!! below is the old comment ---------
135: same for copy, only one pair may be not null. the other

Line 141: PROCEDURE copy_standard_note(

137: No cross-copying allowed. eg. copying from header12's Line to
138: header27's Line.
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,

Line 157: PROCEDURE lock_standard_note(

153: default_flag IN VARCHAR2
154: );
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,

Line 165: PROCEDURE lock_standard_note(

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,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,

Line 173: END OKE_STANDARD_NOTES_PUB;

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: