1 PACKAGE FTP_TP_PKG as
2 /* $Header: FTPEFTPS.pls 120.5 2006/12/05 05:36:34 rknanda noship $ */
3 -- create or validate map of tp and pp assumptions to appropriate
4 -- nodes in the hierarchies used.
5 procedure VALIDATE_NODE_MAP(
6 OBJ_ID in number,
7 REQ_ID in number,
8 EFFECTIVE_DATE in date,
9 NODE_MAP_ID out nocopy number,
10 DIM_COL_NAME out nocopy varchar2
11 );
12
13 -- return the appropirate instrument table columns
14 -- to update given the tp process id (to allow for
15 -- future expansion to support multiple transfer rate
16 -- columns.
17 procedure GET_TP_OUT_COLS(
18 obj_id in number,
19 data_set_id in number,
20 jobid in number,
21 effective_date in date,
22 TRATE_COL out nocopy varchar2,
23 MSPREAD_COL out nocopy varchar2,
24 OAS_COL out nocopy varchar2,
25 SS_COL out nocopy varchar2,
26 LAST_OBJID_COL out nocopy varchar2,
27 LAST_REQID_COL out nocopy varchar2
28 );
29
30 procedure REGISTER_TP_PROCESS(
31 OBJ_ID in number,
32 LEDGER_ID In number,
33 EFFECTIVE_DATE in date,
34 PROCESS_PARAM_ID out NOCOPY number
35 );
36
37 -- return information for joining ftp_pp_node_map to
38 -- attribute table to get account type.
39 -- aliases needed to properly generate where clause.
40 procedure ACCT_TYPE_JOIN_INFO(
41 TBL_ALIAS in varchar2, -- alias of main table
42 TBL_JOIN_ALIAS in varchar2, -- alias of attribute table
43 JOIN_TBL_NAME out NOCOPY varchar2, -- table to join to
44 ATTR_COL_NAME out NOCOPY varchar2, -- attribute column to select
45 IS_ASSET_DECODE out NOCOPY varchar2, -- decode to determine if asset/liab
46 WHERE_CLAUSE out NOCOPY varchar2 -- where clause for join
47 );
48
49 -- return information for joining ftp_pp_node_map to
50 -- attribute table to get account type.
51 -- aliases needed to properly generate where clause.
52 procedure CHG_CRDT_ACC_BASIS_JOIN(
53 TBL_ALIAS in varchar2, -- alias of main table
54 TBL_JOIN_ALIAS in varchar2, -- alias of attribute table
55 JOIN_TBL_NAME out NOCOPY varchar2, -- table to join to
56 ATTR_COL_NAME out NOCOPY varchar2, -- attribute column to select
57 ACCR_DECODE out NOCOPY varchar2, -- decode to determine if asset/liab
58 WHERE_CLAUSE out NOCOPY varchar2 -- where clause for join
59 );
60
61 PROCEDURE GET_VALUESETS_INFO(
62 OBJ_ID in number,
63 EFFECTIVE_DATE in date,
64 LN_ITEM_VAL_SET out NOCOPY number,
65 ORG_VAL_SET out NOCOPY number,
66 SOURCE_SYS_CD out NOCOPY number
67 );
68
69 PROCEDURE START_PROCESS_LOCKS(
70 p_request_id IN NUMBER,
71 p_object_id IN NUMBER,
72 p_cal_period_id IN NUMBER,
73 p_ledger_id IN NUMBER,
74 p_dataset_def_id IN NUMBER,
75 p_job_id IN NUMBER,
76 p_condition_id IN NUMBER,
77 p_effective_date IN DATE,
78 p_user_id IN NUMBER,
79 p_last_update_login IN NUMBER,
80 p_program_id IN NUMBER,
81 p_program_login_id IN NUMBER,
82 p_program_application_id IN NUMBER,
83 x_exec_lock_exists OUT NOCOPY VARCHAR2,
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2
87 );
88
89 PROCEDURE STOP_PROCESS_LOCKS(
90 p_request_id IN NUMBER,
91 p_object_id IN NUMBER,
92 p_cal_period_id IN NUMBER,
93 p_ledger_id IN NUMBER,
94 p_dataset_def_id IN NUMBER,
95 p_exec_status_code IN VARCHAR2,
96 p_job_id IN NUMBER,
97 p_condition_id IN NUMBER,
98 p_effective_date IN DATE,
99 p_user_id IN NUMBER,
100 p_last_update_login IN NUMBER,
101 x_return_status OUT NOCOPY VARCHAR2,
102 x_msg_count OUT NOCOPY NUMBER,
103 x_msg_data OUT NOCOPY VARCHAR2
104 );
105
106 PROCEDURE LEDGER_PROCESSING(
107 p_request_id IN NUMBER,
108 p_object_id IN NUMBER,
109 p_cal_period_id IN NUMBER,
110 p_ledger_id IN NUMBER,
111 p_dataset_def_id IN NUMBER,
112 p_job_id IN NUMBER,
113 p_condition_id IN NUMBER,
114 p_effective_date IN DATE,
115 p_user_id IN NUMBER,
116 p_last_update_login IN NUMBER,
117 x_exec_lock_exists OUT NOCOPY VARCHAR2,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2
121 );
122
123 PROCEDURE CHAINING_EXISTS(
124 p_request_id IN NUMBER,
125 p_object_id IN NUMBER,
126 p_cal_period_id IN NUMBER,
127 p_ledger_id IN NUMBER,
128 p_dataset_def_id IN NUMBER,
129 p_condition_str IN VARCHAR2,
130 p_effective_date IN DATE,
131 p_table_name IN VARCHAR2,
132 x_exec_lock_exists OUT NOCOPY VARCHAR2
133 );
134
135 procedure GET_VALID_TABLE_LIST(
136 obj_id in number,
137 jobid in number,
138 effective_date in date,
139 new_valid_table_list out nocopy varchar2,
140 LAST_OBJID_COL out nocopy varchar2,
141 LAST_REQID_COL out nocopy varchar2,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2
145 );
146
147 PROCEDURE VERIFY_VALID_COLUMN(
148 rate_output_rule_obj_id IN NUMBER,
149 p_col_name IN VARCHAR2,
150 p_col_value IN VARCHAR2,
151 p_table_name IN VARCHAR2,
152 valid_flg IN OUT NOCOPY BOOLEAN
153 );
154 end FTP_TP_PKG;
155