DBA Data[Home] [Help]

PACKAGE: APPS.PFT_PROFCAL_CUST_PPTILE_PUB

Source


1 PACKAGE PFT_PROFCAL_CUST_PPTILE_PUB AS
2 /* $Header: PFTPPCTS.pls 120.1 2006/05/25 10:24:44 ssthiaga noship $ */
3 
4 ---------------------------------------------
5 --  Package Constants
6 ---------------------------------------------
7    g_block                CONSTANT  VARCHAR2(80) := 'FEM.PLSQL.PFT_PROFCAL_CUST_PPTILE_PUB';
8    g_pft                  CONSTANT  VARCHAR2(3)  := 'PFT';
9    g_fem                  CONSTANT  VARCHAR2(3)  := 'FEM';
10    g_calling_api_version  CONSTANT  NUMBER       :=  1.0;
11    g_complete_normal      CONSTANT  VARCHAR2(30) := 'COMPLETE:NORMAL';
12 
13    g_false        CONSTANT  VARCHAR2(1)  := FND_API.G_FALSE;
14    g_true         CONSTANT  VARCHAR2(1)  := FND_API.G_TRUE;
15    g_success      CONSTANT  VARCHAR2(1)  := FND_API.G_RET_STS_SUCCESS;
16    g_error        CONSTANT  VARCHAR2(1)  := FND_API.G_RET_STS_ERROR;
17    g_unexp        CONSTANT  VARCHAR2(1)  := FND_API.G_RET_STS_UNEXP_ERROR;
18    g_api_version  CONSTANT  NUMBER       := 1.0;
19 
20 --------Message Constants--------------
21    G_ENG_INVALID_LEDGER_ERR      CONSTANT  VARCHAR2(30) := 'PFT_PPROF_INVALID_LEDGER_ERR';
22    G_ENG_INVALID_GVSC_ERR        CONSTANT  VARCHAR2(30) := 'PFT_PPROF_INVALID_GVSC_ERR';
23    G_ENG_DS_WHERE_CLAUSE_ERR     CONSTANT  VARCHAR2(30) := 'PFT_PPROF_DS_WHERE_CLAS_ERR';
24    G_PL_OP_UPD_ROWS_ERR          CONSTANT  VARCHAR2(30) := 'PFT_PPROF_PL_OP_UPD_ROWS_ERR';
25    G_PL_IP_UPD_ROWS_ERR          CONSTANT  VARCHAR2(30) := 'PFT_PPROF_PL_IP_UPD_ROWS_ERR';
26    G_PL_UPD_EXEC_STEP_ERR        CONSTANT  VARCHAR2(30) := 'PFT_PPROF_PL_UPD_EXEC_STEP_ERR';
27    G_ENG_SINGLE_RULE_ERR         CONSTANT  VARCHAR2(30) := 'PFT_PPROF_SINGLE_RULE_ERR';
28    G_ENG_MULTI_PROC_ERR          CONSTANT  VARCHAR2(30) := 'PFT_PPROF_MULTI_PROC_ERR';
29    G_ENG_PPCT_NO_OP_ROWS_ERR     CONSTANT  VARCHAR2(30) := 'PFT_PPROF_PPCT_NO_OP_ROWS_ERR';
30    G_UNEXPECTED_ERROR            CONSTANT  VARCHAR2(30) := 'FEM_UNEXPECTED_ERROR';
31 
32 --------------------------------------------
33 --  Variable Types
34 ---------------------------------------------
35    id                              NUMBER(9);
36    pct                             NUMBER(3,2);
37    flag                            VARCHAR2(1);
38    currency_code                   VARCHAR2(15);
39    varchar2_std                    VARCHAR2(30);
40    varchar2_150                    VARCHAR2(150);
41    varchar2_240                    VARCHAR2(240);
42    varchar2_1000                   VARCHAR2(1000);
43    varchar2_10000                  VARCHAR2(10000);
44 
45 ---------------------------------------------
46 --  Package Types
47 ---------------------------------------------
48 
49    TYPE cv_curs                IS REF CURSOR;
50    TYPE rowid_tbl_type         IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
51    TYPE number_tbl_type        IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
52    TYPE date_tbl_type          IS TABLE OF DATE INDEX BY BINARY_INTEGER;
53    TYPE flag_type              IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
54    TYPE varchar2_std_tbl_type  IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
55    TYPE varchar2_150_tbl_type  IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;
56    TYPE varchar2_1000_tbl_type IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
57 
58    TYPE dimension_record IS RECORD (
59            dimension_id                 NUMBER
60           ,dimension_varchar_label      varchar2_std%TYPE
61           ,composite_dimension_flag     flag%TYPE
62           ,member_col                   varchar2_std%TYPE
63           ,member_b_table               varchar2_std%TYPE
64           ,attr_table                   varchar2_std%TYPE
65           ,hier_table                   varchar2_std%TYPE
66           ,hier_rollup_table            varchar2_std%TYPE
67           ,hier_versioning_type_code    varchar2_std%TYPE);
68 
69 /*=============================================================================+
70  | Procedure
71  |   Process_Request
72  |
73  | DESCRIPTION
74  |   The procedure performs the Profit Percentile Step of the Profit Calculation
75  | Step
76  |
77  | scope - public
78  |
79  +============================================================================*/
80 
81    PROCEDURE Process_Single_Rule ( p_rule_obj_id            IN NUMBER
82                                   ,p_cal_period_id          IN NUMBER
83                                   ,p_dataset_io_obj_def_id  IN NUMBER
84                                   ,p_output_dataset_code    IN NUMBER
85                                   ,p_effective_date         IN VARCHAR2
86                                   ,p_ledger_id              IN NUMBER
87                                   ,p_source_system_code     IN NUMBER
88                                   ,p_customer_level         IN NUMBER
89                                   ,p_exec_state             IN VARCHAR2
90                                   ,x_return_status          OUT NOCOPY VARCHAR2
91    );
92 
93    END PFT_PROFCAL_CUST_PPTILE_PUB;