[Home] [Help]
PACKAGE: APPS.PAY_DB_BALANCES_PKG
Source
1 package pay_db_balances_pkg AUTHID CURRENT_USER as
2 /* $Header: pybaldim.pkh 115.5 2003/05/26 03:43:37 sdhole ship $ */
3 /* Copyright (C) 1993 Oracle Corporation. All rights reserved. */
4
5 /*
6 Change List
7 ===========
8
9 Date Author ER/CR No. Description of Change
10 +---------+----------+---------+-------------------------------------------
11 25-May-03 sdhole 2898483 Support new two columns START_DATE_CODE,
12 SAVE_RUN_BALANCE_ENABLED to the function
13 create_balance_dimension.
14 10-OCT-02 nbristow New attribution on dimenion routes.
15 07-OCT-02 nbristow Support new balance dimension functionality.
16 31-AUG-01 dsaxby Support new balance dimension columns.
17 05-OCT-94 R.FINE Renamed package to pay_db_balances_pkg
18 11/03/93 H.MINTON Added copyright and exit line
19 ---------------------------------------------------------------------------
20 */
21 --
22 function create_balance_dimension
23 (p_business_group_id number default null,
24 p_legislation_code varchar2 default null,
25 p_route_id number,
26 p_database_item_suffix varchar2,
27 p_dimension_name varchar2,
28 p_dimension_type varchar2 default 'N',
29 p_description varchar2 default null,
30 p_feed_checking_type varchar2 default null,
31 p_feed_checking_code varchar2 default null,
32 p_payments_flag varchar2 default 'N',
33 p_expiry_checking_code varchar2 default null,
34 p_expiry_checking_level varchar2 default null,
35 p_dimension_level varchar2 default null,
36 p_period_type varchar2 default null,
37 p_asg_bal_dim number default null,
38 p_dbi_function varchar2 default null,
39 p_save_run_balance_enabled varchar2 default null,
40 p_start_date_code varchar2 default null)
41 return number;
42 --------------------------------------------------------------------------
43 -- Procedure create_dimension_route
44 --
45 -- Description
46 -- Inserts dimension routes relationshipts ofr run_balances
47 --------------------------------------------------------------------------
48 procedure create_dimension_route(
49 p_dim_id in number,
50 p_route_id in number,
51 p_route_type in varchar2,
52 p_run_dim_id in number,
53 p_priority in number,
54 p_baltyp_col in varchar2 default null,
55 p_dec_required in varchar2 default null);
56 --
57 end pay_db_balances_pkg;