[Home] [Help]
PACKAGE: APPS.FEM_PARTY_PROFITABILITY_PUB
Source
1 package FEM_PARTY_PROFITABILITY_PUB AS
2 -- $Header: femprfSS.pls 120.0 2005/06/15 18:21:51 appldev noship $
3
4 TYPE profitability_rec_type IS RECORD(
5 party_id NUMBER,
6 profit NUMBER,
7 profit_pct NUMBER,
8 relationship_expense NUMBER,
9 total_equity NUMBER,
10 total_gross_contrib NUMBER,
11 total_roe NUMBER,
12 contrib_after_cptl_chg NUMBER,
13 partner_value_index NUMBER,
14 iso_currency_cd VARCHAR2(3),
15 last_update_date DATE,
16 last_updated_by NUMBER,
17 creation_date DATE,
18 created_by NUMBER,
19 last_update_login NUMBER,
20 REVENUE1 NUMBER,
21 REVENUE2 NUMBER,
22 REVENUE3 NUMBER,
23 REVENUE4 NUMBER,
24 REVENUE5 NUMBER,
25 REVENUE_TOTAL NUMBER,
26 EXPENSE1 NUMBER,
27 EXPENSE2 NUMBER,
28 EXPENSE3 NUMBER,
29 EXPENSE4 NUMBER,
30 EXPENSE5 NUMBER,
31 EXPENSE_TOTAL NUMBER,
32 PROFIT1 NUMBER,
33 PROFIT2 NUMBER,
34 PROFIT3 NUMBER,
35 PROFIT4 NUMBER,
36 PROFIT5 NUMBER,
37 PROFIT_TOTAL NUMBER,
38 CACC1 NUMBER,
39 CACC2 NUMBER,
40 CACC3 NUMBER,
41 CACC4 NUMBER,
42 CACC5 NUMBER,
43 CACC_TOTAL NUMBER,
44 BALANCE1 NUMBER,
45 BALANCE2 NUMBER,
46 BALANCE3 NUMBER,
47 BALANCE4 NUMBER,
48 BALANCE5 NUMBER,
49 ACCOUNTS1 NUMBER,
50 ACCOUNTS2 NUMBER,
51 ACCOUNTS3 NUMBER,
52 ACCOUNTS4 NUMBER,
53 ACCOUNTS5 NUMBER,
54 TRANSACTION1 NUMBER,
55 TRANSACTION2 NUMBER,
56 TRANSACTION3 NUMBER,
57 TRANSACTION4 NUMBER,
58 TRANSACTION5 NUMBER,
59 RATIO1 NUMBER,
60 RATIO2 NUMBER,
61 RATIO3 NUMBER,
62 RATIO4 NUMBER,
63 RATIO5 NUMBER,
64 VALUE1 NUMBER,
65 VALUE2 NUMBER,
66 VALUE3 NUMBER,
67 VALUE4 NUMBER,
68 VALUE5 NUMBER,
69 YTD1 NUMBER,
70 YTD2 NUMBER,
71 YTD3 NUMBER,
72 YTD4 NUMBER,
73 YTD5 NUMBER,
74 LTD1 NUMBER,
75 LTD2 NUMBER,
76 LTD3 NUMBER,
77 LTD4 NUMBER,
78 LTD5 NUMBER
79 );
80
81
82 procedure create_profitability (
83 p_api_version IN NUMBER:=1.0,
84 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
85 p_commit IN VARCHAR2:= FND_API.G_TRUE,
86 p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
87 p_profitability_rec IN PROFITABILITY_REC_TYPE,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 x_party_id OUT NOCOPY NUMBER
92
93 );
94
95
96 procedure update_profitability (
97 p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2:=FND_API.G_FALSE,
99 p_commit IN VARCHAR2:=FND_API.G_TRUE,
100 p_validation_level IN NUMBER:=FND_API.G_VALID_LEVEL_FULL,
101 p_profitability_rec IN PROFITABILITY_REC_TYPE,
102 p_last_update_date IN OUT NOCOPY DATE,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2
106 );
107
108 END FEM_PARTY_PROFITABILITY_PUB;