DBA Data[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;