[Home] [Help]
PACKAGE: APPS.PFT_PROFCAL_PROSP_IDENT_PUB
Source
1 PACKAGE PFT_PROFCAL_PROSP_IDENT_PUB AS
2 /* $Header: PFTPIDNTS.pls 120.1 2006/05/25 10:34:47 ssthiaga noship $ */
3
4 ---------------------------------------------
5 -- Package Constants
6 ---------------------------------------------
7 g_block CONSTANT VARCHAR2(80) := 'FEM.PLSQL.PFT_PROFCAL_PROSP_IDENT_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_ENG_INVALID_OBJ_DEFN_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_INVALID_OBJ_DEFN_ERR';
27 G_PL_UPD_EXEC_STEP_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_PL_UPD_EXEC_STEP_ERR';
28 G_ENG_SINGLE_RULE_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_SINGLE_RULE_ERR';
29 G_ENG_MULTI_PROC_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_MULTI_PROC_ERR';
30 G_ENG_NO_OP_ROWS_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_PC_NO_OP_ROWS_ERR';
31 --------------------------------------------
32 -- Variable Types
33 ---------------------------------------------
34 id NUMBER(9);
35 pct NUMBER(3,2);
36 flag VARCHAR2(1);
37 currency_code VARCHAR2(15);
38 varchar2_std VARCHAR2(30);
39 varchar2_150 VARCHAR2(150);
40 varchar2_240 VARCHAR2(240);
41 varchar2_1000 VARCHAR2(1000);
42 varchar2_10000 VARCHAR2(10000);
43
44 ---------------------------------------------
45 -- Package Types
46 ---------------------------------------------
47
48 TYPE cv_curs IS REF CURSOR;
49 TYPE rowid_tbl_type IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
50 TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
51 TYPE date_tbl_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;
52 TYPE flag_type IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
53 TYPE varchar2_std_tbl_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
54 TYPE varchar2_150_tbl_type IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;
55 TYPE varchar2_1000_tbl_type IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
56
57 TYPE dimension_record IS RECORD (
58 dimension_id NUMBER
59 ,dimension_varchar_label varchar2_std%TYPE
60 ,composite_dimension_flag flag%TYPE
61 ,member_col varchar2_std%TYPE
62 ,member_b_table varchar2_std%TYPE
63 ,attr_table varchar2_std%TYPE
64 ,hier_table varchar2_std%TYPE
65 ,hier_rollup_table varchar2_std%TYPE
66 ,hier_versioning_type_code varchar2_std%TYPE);
67
68 /*============================================================================+
69 | Procedure
70 | Process_Request
71 |
72 | DESCRIPTION
73 | The Procedure Performs The Prospect Identification Process of the Profit
74 | Calculation Step
75 |
76 | scope - public
77 |
78 +===========================================================================*/
79
80 PROCEDURE Process_Single_Rule ( p_rule_obj_id IN NUMBER
81 ,p_cal_period_id IN NUMBER
82 ,p_dataset_io_obj_def_id IN NUMBER
83 ,p_output_dataset_code IN NUMBER
84 ,p_effective_date IN VARCHAR2
85 ,p_ledger_id IN NUMBER
86 ,p_source_system_code IN NUMBER
87 ,p_exec_state IN VARCHAR2
88 ,x_return_status OUT NOCOPY VARCHAR2
89 );
90
91 END PFT_PROFCAL_PROSP_IDENT_PUB;