PACKAGE: APPS.PSB_WS_PERIOD_TOTAL

Source

1 PACKAGE PSB_WS_PERIOD_TOTAL AUTHID CURRENT_USER as
2 /* $Header: PSBVWPTS.pls 115.8 2002/11/12 11:24:51 msuram ship $ */
3 
4 
5   PROCEDURE Get_Totals
6   (
7     p_worksheet_id               NUMBER,
8   --following 1 parameter added for DDSP
9     p_profile_worksheet_id       NUMBER,
10     p_budget_year_id             NUMBER,
11     p_balance_type               VARCHAR2,
12     p_user_id                    NUMBER,
13     p_template_id                NUMBER,
14     p_account_flag               VARCHAR2,
15     p_currency_flag              VARCHAR2,
16     p_spkg_flag                  VARCHAR2,
17     p_spkg_selection_exists      VARCHAR2,
18 /* Bug No 2543015 Start */
19     p_spkg_name                  VARCHAR2,
20 /* Bug No 2543015 End */
21     p_flexfield_low              VARCHAR2,
22     p_flexfield_high             VARCHAR2,
23     p_flexfield_delimiter        VARCHAR2,
24     p_chart_of_accounts          NUMBER,
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     p_year_amount        OUT  NOCOPY     NUMBER
38   );
39 
40  PROCEDURE Get_Data_Selection_Profile
41  (
42   p_current_worksheet_id   IN  NUMBER,
43   p_current_user_id        IN  NUMBER,
44   p_global_profile_user_id IN  NUMBER default NULL,
45   p_profile_worksheet_id   OUT  NOCOPY NUMBER,
46   p_profile_user_id        OUT  NOCOPY NUMBER
47  );
48 
49 
50 END PSB_WS_PERIOD_TOTAL;