DBA Data[Home] [Help]

APPS.PO_DOC_STYLE_GRP dependencies on STANDARD

Line 139: --Name: is_standard_doc_style

135:
136:
137: --------------------------------------------------------------------------------
138: --Start of Comments
139: --Name: is_standard_doc_style
140: --Pre-reqs:
141: -- None.
142: --Modifies:
143: -- None.

Line 148: -- is of STANDARD type.

144: --Locks:
145: -- None.
146: --Function:
147: -- This procedure check if the document styles with the supplied style id
148: -- is of STANDARD type.
149: --Parameters:
150: --IN:
151: --p_style_id
152: -- The style id.

Line 154: -- Y if the style is of type STANDARD.

150: --IN:
151: --p_style_id
152: -- The style id.
153: --OUT:
154: -- Y if the style is of type STANDARD.
155: -- N if the style is not of type STANDARD.
156: --End of Comments
157: -------------------------------------------------------------------------------
158:

Line 155: -- N if the style is not of type STANDARD.

151: --p_style_id
152: -- The style id.
153: --OUT:
154: -- Y if the style is of type STANDARD.
155: -- N if the style is not of type STANDARD.
156: --End of Comments
157: -------------------------------------------------------------------------------
158:
159: FUNCTION is_standard_doc_style (p_style_id IN NUMBER)

Line 159: FUNCTION is_standard_doc_style (p_style_id IN NUMBER)

155: -- N if the style is not of type STANDARD.
156: --End of Comments
157: -------------------------------------------------------------------------------
158:
159: FUNCTION is_standard_doc_style (p_style_id IN NUMBER)
160: RETURN VARCHAR2
161: IS
162: l_api_name CONSTANT VARCHAR2(30) := 'is_standard_doc_style';
163: l_progress VARCHAR2(3);

Line 162: l_api_name CONSTANT VARCHAR2(30) := 'is_standard_doc_style';

158:
159: FUNCTION is_standard_doc_style (p_style_id IN NUMBER)
160: RETURN VARCHAR2
161: IS
162: l_api_name CONSTANT VARCHAR2(30) := 'is_standard_doc_style';
163: l_progress VARCHAR2(3);
164: l_return_value VARCHAR2(1);
165: l_count NUMBER;
166: BEGIN

Line 178: WHERE style_type = 'STANDARD'

174: FROM dual
175: WHERE exists (
176: SELECT NULL
177: FROM po_doc_style_headers pdhs
178: WHERE style_type = 'STANDARD'
179: and style_id = p_style_id);
180:
181: l_progress := '020';
182:

Line 200: --Name: get_standard_doc_style

196:
197:
198: --------------------------------------------------------------------------------
199: --Start of Comments
200: --Name: get_standard_doc_style
201: --Pre-reqs:
202: -- None.
203: --Modifies:
204: -- None.

Line 213: -- The style id of the STANDARD style.

209: --Parameters:
210: --IN:
211: --None.
212: --OUT:
213: -- The style id of the STANDARD style.
214: --End of Comments
215: -------------------------------------------------------------------------------
216: FUNCTION get_standard_doc_style
217: RETURN NUMBER

Line 216: FUNCTION get_standard_doc_style

212: --OUT:
213: -- The style id of the STANDARD style.
214: --End of Comments
215: -------------------------------------------------------------------------------
216: FUNCTION get_standard_doc_style
217: RETURN NUMBER
218: IS
219: l_api_name CONSTANT VARCHAR2(30) := 'get_standard_doc_style';
220: l_progress VARCHAR2(3);

Line 219: l_api_name CONSTANT VARCHAR2(30) := 'get_standard_doc_style';

215: -------------------------------------------------------------------------------
216: FUNCTION get_standard_doc_style
217: RETURN NUMBER
218: IS
219: l_api_name CONSTANT VARCHAR2(30) := 'get_standard_doc_style';
220: l_progress VARCHAR2(3);
221: l_style_id NUMBER;
222: BEGIN
223:

Line 229: WHERE style_type = 'STANDARD';

225:
226: SELECT style_id
227: INTO l_style_id
228: FROM po_doc_style_headers pdhs
229: WHERE style_type = 'STANDARD';
230:
231: l_progress := '020';
232:
233: return l_style_id;

Line 311: -- Standard call to check for call compatibility

307: BEGIN
308:
309: l_progress := '010';
310:
311: -- Standard call to check for call compatibility
312: IF NOT FND_API.compatible_api_call(l_api_version,
313: p_api_version,
314: l_api_name,
315: g_pkg_name) THEN

Line 378: -- Standard call to check for call compatibility

374: BEGIN
375:
376: l_progress := '010';
377:
378: -- Standard call to check for call compatibility
379: IF NOT FND_API.compatible_api_call(l_api_version,
380: p_api_version,
381: l_api_name,
382: g_pkg_name) THEN