DBA Data[Home] [Help]

APPS.PO_APPROVE_SV dependencies on PO_APPROVE_SV

Line 1: PACKAGE BODY po_approve_sv AS

1: PACKAGE BODY po_approve_sv AS
2: /* $Header: POXAPAPB.pls 115.6 2004/06/24 23:27:26 zxzhang ship $*/
3:
4: /*===========================================================================
5:

Line 23: po_approve_sv.get_document_types(x_document_type_code,

19: BEGIN
20:
21: --dbms_output.put_line('before call');
22:
23: po_approve_sv.get_document_types(x_document_type_code,
24: x_document_subtype,
25: x_can_change_forward_from_flag,
26: x_can_change_forward_to_flag,
27: x_can_change_approval_path,

Line 93: PO_MESSAGE_S.SQL_ERROR('PO_APPROVE_SV.GET_DOCUMENT_TYPES', x_progress, sqlcode);

89:
90: EXCEPTION
91: WHEN OTHERS THEN
92: --dbms_output.put_line('In Exception');
93: PO_MESSAGE_S.SQL_ERROR('PO_APPROVE_SV.GET_DOCUMENT_TYPES', x_progress, sqlcode);
94: RAISE;
95: END;
96:
97: /*===========================================================================

Line 114: po_approve_sv.get_approval_path (x_default_approval_path_id,

110: BEGIN
111:
112: --dbms_output.put_line('before call');
113:
114: po_approve_sv.get_approval_path (x_default_approval_path_id,
115: x_forward_from_id,
116: x_object_id,
117: x_document_type_code,
118: x_document_subtype,

Line 224: PO_MESSAGE_S.SQL_ERROR('PO_APPROVE_SV.GET_APPROVAL_PATH', x_progress, sqlcode);

220:
221: WHEN NO_DATA_FOUND THEN
222: RETURN;
223: WHEN OTHERS THEN
224: PO_MESSAGE_S.SQL_ERROR('PO_APPROVE_SV.GET_APPROVAL_PATH', x_progress, sqlcode);
225: RAISE;
226: END;
227:
228:

Line 281: PO_MESSAGE_S.SQL_ERROR('PO_APPROVE_SV.GET_DOCUMENT_TYPES',

277: end if;
278:
279: EXCEPTION
280: WHEN OTHERS THEN
281: PO_MESSAGE_S.SQL_ERROR('PO_APPROVE_SV.GET_DOCUMENT_TYPES',
282: l_progress, sqlcode);
283: RAISE;
284: END get_document_types;
285: /* RETROACTIVE FPI END */

Line 364: -- PO_MESSAGE_S.SQL_ERROR('PO_APPROVE_SV.get_change_summary',

360:
361: l_progress := '100';
362: EXCEPTION
363: WHEN OTHERS THEN
364: -- PO_MESSAGE_S.SQL_ERROR('PO_APPROVE_SV.get_change_summary',
365: -- l_progress, sqlcode);
366: -- RAISE;
367: NULL;
368: END get_change_summary;

Line 372: END PO_APPROVE_SV;

368: END get_change_summary;
369: --
370:
371:
372: END PO_APPROVE_SV;