[Home] [Help]
PACKAGE: APPS.AR_LATE_CHARGE_UPG
Source
1 PACKAGE ar_late_charge_upg AUTHID CURRENT_USER AS
2 /* $Header: ARLCUPS.pls 120.2 2006/06/28 21:32:48 hyu noship $ */
3
4 FUNCTION f_number(p_val IN VARCHAR2) RETURN NUMBER;
5
6 FUNCTION f_date(p_value IN VARCHAR2) RETURN DATE;
7
8
9 PROCEDURE upgrade_schedule
10 (l_table_owner IN VARCHAR2, -- JG
11 l_table_name IN VARCHAR2, -- JG_ZZ_II_INT_RATES
12 l_script_name IN VARCHAR2, -- ar120lcjgr.sql
13 l_worker_id IN VARCHAR2,
14 l_num_workers IN VARCHAR2,
15 l_batch_size IN VARCHAR2);
16
17 PROCEDURE upgrade_profile_amount
18 (l_table_owner IN VARCHAR2, -- AR
19 l_table_name IN VARCHAR2, -- HZ_CUST_PROFILE_AMTS
20 l_script_name IN VARCHAR2, -- ar120lccpa.sql
21 l_worker_id IN VARCHAR2,
22 l_num_workers IN VARCHAR2,
23 l_batch_size IN VARCHAR2);
24
25 PROCEDURE upgrade_profile
26 (l_table_owner IN VARCHAR2, -- AR
27 l_table_name IN VARCHAR2, -- HZ_CUSTOMER_PROFILES
28 l_script_name IN VARCHAR2, -- ar120lccp.sql
29 l_worker_id IN VARCHAR2,
30 l_num_workers IN VARCHAR2,
31 l_batch_size IN VARCHAR2);
32
33 PROCEDURE upgrade_profile_class_amount
34 (l_table_owner IN VARCHAR2, -- AR
35 l_table_name IN VARCHAR2, -- HZ_CUST_PROF_CLASS_AMTS
36 l_script_name IN VARCHAR2, -- ar120lccpca.sql
37 l_worker_id IN VARCHAR2,
38 l_num_workers IN VARCHAR2,
39 l_batch_size IN VARCHAR2);
40
41
42 PROCEDURE upgrade_profile_class
43 (l_table_owner IN VARCHAR2, -- AR
44 l_table_name IN VARCHAR2, -- HZ_CUST_PROFILE_CLASSES
45 l_script_name IN VARCHAR2, -- ar120lccpc.sql
46 l_worker_id IN VARCHAR2,
47 l_num_workers IN VARCHAR2,
48 l_batch_size IN VARCHAR2);
49
50 PROCEDURE upgrade_lc_sysp
51 (l_table_owner IN VARCHAR2, -- AR
52 l_table_name IN VARCHAR2, -- AR_SYSTEM_PARAMETERS_ALL
53 l_script_name IN VARCHAR2, -- ar120lcsysp.sql
54 l_worker_id IN VARCHAR2,
55 l_num_workers IN VARCHAR2,
56 l_batch_size IN VARCHAR2);
57
58 PROCEDURE upgrade_ps_for_adj
59 (l_table_owner IN VARCHAR2, -- AR
60 l_table_name IN VARCHAR2, -- HZ_CUST_SITE_USES_ALL
61 l_script_name IN VARCHAR2, -- ar120lccsups.sql
62 l_worker_id IN VARCHAR2,
63 l_num_workers IN VARCHAR2,
64 l_batch_size IN VARCHAR2);
65
66 PROCEDURE upgrade_lc_site_use
67 (l_table_owner IN VARCHAR2, --AR
68 l_table_name IN VARCHAR2, --HZ_CUST_ACCT_SITES_ALL
69 l_script_name IN VARCHAR2, --ar120lclcsu.sql
70 l_worker_id IN VARCHAR2,
71 l_num_workers IN VARCHAR2,
72 l_batch_size IN VARCHAR2);
73
74 END;