[Home] [Help]
PACKAGE: APPS.PFT_ACCTRELCONS_PUB
Source
1 PACKAGE PFT_ACCTRELCONS_PUB AS
2 /* $Header: pftparcs.pls 120.4 2006/05/25 09:23:43 ssthiaga noship $ */
3
4 ---------------------------------------------
5 -- Package Constants
6 ---------------------------------------------
7 g_block CONSTANT VARCHAR2(80) := 'FEM.PLSQL.PFT_ACCTRELCONS_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
22 G_ENG_ENGINE_POST_PROC_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_ENGINE_POST_PROC_ERR';
23 G_ENG_INVALIDRULETYPE_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_INVALID_RULETYPE_ERR';
24 G_ENG_INVALID_OBJ_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_INVALID_OBJ_ERR';
25 G_ENG_NO_OUTPUT_DS_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_NO_OUTPUT_DS_ERR';
26 G_ENG_INVALID_OBJ_DEFN_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_INVALID_OBJ_DEFN_ERR';
27 G_ENG_INV_OBJ_DEFN_RS_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_INV_OBJ_DEFN_RS_ERR';
28 G_PL_REG_REQUEST_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_PL_REG_REQUEST_ERR';
29 G_PL_OBJ_EXEC_LOCK_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_PL_REG_OBJ_EXEC_ERR';
30 G_PL_OBJ_EXECLOCK_EXISTS_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_PL_EXE_LCK_EXIST_ERR';
31 G_PL_DEP_OBJ_DEF_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_PL_DEP_OBJ_DEF_ERR';
32 G_PL_REG_TABLE_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_PL_REG_TABLE_ERR';
33 G_ENG_COL_POP_API_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_COL_POP_API_ERR';
34 G_ENG_MULTI_PROC_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_MULTI_PROC_ERR';
35 G_PL_OP_UPD_ROWS_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_PL_OP_UPD_ROWS_ERR';
36 G_PL_IP_UPD_ROWS_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_PL_IP_UPD_ROWS_ERR';
37 G_ENG_SINGLE_RULE_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_SINGLE_RULE_ERR';
38 G_ENG_PRE_PROC_RS_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_PRE_PROC_RS_ERR';
39 G_PL_REG_EXEC_STEP_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_PL_REG_EXEC_STEP_ERR';
40 G_PL_UPD_EXEC_STEP_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_PL_UPD_EXEC_STEP_ERR';
41 G_PL_REG_UPD_COL_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_PL_REG_UPD_COL_ERR';
42 G_ENG_INVALID_LEDGER_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_INVALID_LEDGER_ERR';
43 G_ENG_INVALID_GVSC_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_INVALID_GVSC_ERR';
44 G_PL_REG_CHAIN_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_PL_REG_CHAIN_ERR';
45 G_ENG_NO_OP_ROWS_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_ARC_NO_OP_ROWS_ERR';
46 G_ENG_BAD_CONC_REQ_PARAM_ERR CONSTANT VARCHAR2(30) := 'FEM_ENG_BAD_CONC_REQ_PARAM_ERR';
47 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'FEM_UNEXPECTED_ERROR';
48 G_ENG_GENERIC_5_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_GENERIC_ENGINE_5_ERR';
49 G_ENG_COL_POP_GEN_ARC_AGG_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_GEN_CPOP_ARC_AGG_ERR';
50 G_ENG_SEC_NO_OP_ROWS_ERR CONSTANT VARCHAR2(30) := 'PFT_PPROF_SEC_NO_OP_ROWS_ERR';
51
52 --------------------------------------------
53 -- Variable Types
54 ---------------------------------------------
55 id NUMBER(9);
56 pct NUMBER(3,2);
57 flag VARCHAR2(1);
58 currency_code VARCHAR2(15);
59 varchar2_std VARCHAR2(30);
60 varchar2_150 VARCHAR2(150);
61 varchar2_240 VARCHAR2(240);
62 varchar2_1000 VARCHAR2(1000);
63 varchar2_10000 VARCHAR2(10000);
64
65 ---------------------------------------------
66 -- Package Types
67 ---------------------------------------------
68
69 TYPE cv_curs IS REF CURSOR;
70 TYPE rowid_tbl_type IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
71 TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
72 TYPE date_tbl_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;
73 TYPE flag_type IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
74 TYPE varchar2_std_tbl_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
75 TYPE varchar2_150_tbl_type IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;
76 TYPE varchar2_1000_tbl_type IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
77
78 TYPE dimension_record IS RECORD (
79 dimension_id NUMBER
80 ,dimension_varchar_label varchar2_std%TYPE
81 ,composite_dimension_flag flag%TYPE
82 ,member_col varchar2_std%TYPE
83 ,member_b_table varchar2_std%TYPE
84 ,attr_table varchar2_std%TYPE
85 ,hier_table varchar2_std%TYPE
86 ,hier_rollup_table varchar2_std%TYPE
87 ,hier_versioning_type_code varchar2_std%TYPE);
88
89 TYPE param_record IS RECORD (
90 cond_obj_id id%TYPE
91 ,dataset_io_obj_def_id id%TYPE
92 ,dataset_grp_obj_id id%TYPE
93 ,dataset_grp_name varchar2_240%TYPE
94 ,effective_date DATE
95 ,effective_date_varchar varchar2_240%TYPE
96 ,continue_process_on_err_flg varchar2_std%TYPE
97 ,source_system_code NUMBER
98 ,ledger_id NUMBER
99 ,local_vs_combo_id id%TYPE
100 ,login_id NUMBER
101 ,output_cal_period_id NUMBER
102 ,output_dataset_code NUMBER
103 ,input_dataset_code NUMBER
104 ,pgm_app_id NUMBER
105 ,pgm_id NUMBER
106 ,resp_id NUMBER
107 ,request_id NUMBER
108 ,obj_id NUMBER
109 ,obj_type_code varchar2_std%TYPE
110 ,object_name varchar2_150%TYPE
111 ,crnt_proc_child_obj_id NUMBER
112 ,crnt_proc_child_obj_defn_id NUMBER
113 ,user_id NUMBER
114 ,return_status varchar2_std%TYPE
115 ,sec_relns_flag VARCHAR2(1)
116 ,rows_processed NUMBER
117 ,rows_loaded NUMBER
118 ,rows_rejected NUMBER);
119
120 /*===========================================================================+
121 | PROCEDURE
122 | Process_Request
123 |
124 | DESCRIPTION
125 | The procedure combines the customer account data with the account
126 | relationship data by placing the results in pft_party_profit_detail
127 | table
128 |
129 | SCOPE - PUBLIC
130 |
131 +===========================================================================*/
132
133 PROCEDURE Process_Request (Errbuf OUT NOCOPY VARCHAR2,
134 Retcode OUT NOCOPY NUMBER,
135 p_obj_id IN NUMBER,
136 p_effective_date IN VARCHAR2,
137 p_ledger_id IN NUMBER,
138 p_output_cal_period_id IN NUMBER,
139 p_dataset_grp_obj_def_id IN NUMBER,
140 p_continue_process_on_err_flg IN VARCHAR2,
141 p_source_system_code IN NUMBER);
142
143
144 END PFT_AcctRelCons_PUB;