[Home] [Help]
PACKAGE: APPS.PSB_WS_YEAR_TOTAL
Source
1 PACKAGE PSB_WS_YEAR_TOTAL as
2 /* $Header: PSBVWYTS.pls 120.2 2005/07/13 11:31:38 shtripat ship $ */
3
4
5
6 PROCEDURE Get_Totals
7 (
8 p_worksheet_id NUMBER,
9 --following 1 parameter addd for DDSP
10 p_profile_worksheet_id NUMBER,
11 p_user_id NUMBER,
12 p_template_id NUMBER,
13 p_account_flag VARCHAR2,
14 p_currency_flag VARCHAR2,
15 p_spkg_flag VARCHAR2,
16 p_spkg_selection_exists VARCHAR2,
17 p_spkg_name VARCHAR2,
18 p_flexfield_low VARCHAR2,
19 p_flexfield_high VARCHAR2,
20 p_flexfield_delimiter VARCHAR2,
21 p_chart_of_accounts NUMBER,
22 /* Bug No 1328826 Start */
23 p_flex_value VARCHAR2 default null,
24 /* Bug No 1328826 End */
25 p1_amount OUT NOCOPY NUMBER,
26 p2_amount OUT NOCOPY NUMBER,
27 p3_amount OUT NOCOPY NUMBER,
28 p4_amount OUT NOCOPY NUMBER,
29 p5_amount OUT NOCOPY NUMBER,
30 p6_amount OUT NOCOPY NUMBER,
31 p7_amount OUT NOCOPY NUMBER,
32 p8_amount OUT NOCOPY NUMBER,
33 p9_amount OUT NOCOPY NUMBER,
34 p10_amount OUT NOCOPY NUMBER,
35 p11_amount OUT NOCOPY NUMBER,
36 p12_amount OUT NOCOPY NUMBER
37 );
38 /* Bug No 667777 Start */
39 PROCEDURE Position_Totals
40 (
41 pworksheet_id number,
42 --following 1 parameter added for DDSP
43 pprofile_worksheet_id number,
44 pposition_line_id number,
45 paccount_flag varchar2,
46 pcurrency_flag varchar2,
47 pservice_package_flag varchar2,
48 pselection_exists varchar2,
49 puser_id number,
50 pchart_of_accounts_id number default null,
51 pspkg_name varchar2,
52 pflex_value varchar2,
53 ptcolumn1 OUT NOCOPY number,
54 ptcolumn2 OUT NOCOPY number,
55 ptcolumn3 OUT NOCOPY number,
56 ptcolumn4 OUT NOCOPY number,
57 ptcolumn5 OUT NOCOPY number,
58 ptcolumn6 OUT NOCOPY number,
59 ptcolumn7 OUT NOCOPY number,
60 ptcolumn8 OUT NOCOPY number,
61 ptcolumn9 OUT NOCOPY number,
62 ptcolumn10 OUT NOCOPY number,
63 ptcolumn11 OUT NOCOPY number,
64 ptcolumn12 OUT NOCOPY number
65 );
66 /* Bug No 667777 End */
67
68
69 END PSB_WS_YEAR_TOTAL;