1 PACKAGE POGOT_S AUTHID CURRENT_USER AS
2 /* $Header: POGOTS.pls 120.0 2005/06/01 21:13:03 appldev noship $*/
3 /*===========================================================================
4 FUNCTION NAME: get_total
5
6 DESCRIPTION: Calculates the total of an object
7
8 PARAMETERS:
9
10 Parameter IN/OUT Datatype Description
11 ------------- ------ ---------- ----------------------------
12 x_object_type IN VARCHAR2 Object Type
13 'H' - for PO Header
14 'L' - for PO Line
15 'B' - for PO Blanket
16 'P' - for Po Planned
17 'E' - for Requisition Header
18 'I' - for Requisition Line
19 'C' - for Contract
20 'R' - for Release
21
22 x_object_id IN NUMBER Id of the object to be
23 totalled
24
25 x_base_cur_result IN BOOLEAN Result in Base Currency
26
27 RETURN VALUE: Returns total of the object
28
29 DESIGN REFERENCES:
30
31 ALGORITHM:
32
33 NOTES:
34
35 OPEN ISSUES:
36
37 CLOSED ISSUES:
38
39 CHANGE HISTORY:
40 ===========================================================================*/
41 FUNCTION get_total (x_object_type IN VARCHAR2,
42 x_object_id IN NUMBER,
43 x_base_cur_result IN BOOLEAN ) RETURN NUMBER;
44
45 FUNCTION ecx_get_total (x_object_type IN VARCHAR2,
46 x_object_id IN NUMBER,
47 x_po_currency IN VARCHAR2) RETURN NUMBER;
48 -- x_base_cur_result_1 IN NUMBER ) RETURN NUMBER;
49
50 end;