1 PACKAGE HZ_MGD_MASS_UPDATE_REP_GEN AUTHID CURRENT_USER AS
2 /* $Header: ARHCMURS.pls 115.1 2002/11/27 22:01:42 tsimmond noship $ */
3
4 /*+=======================================================================+
5 --| Copyright (c) 1999 Oracle Corporation |
6 --| Redwood Shores, CA, USA |
7 --| All rights reserved. |
8 --+=======================================================================+
9 --| FILENAME |
10 --| ARHCMURS.pls |
11 --| |
12 --| DESCRIPTION |
13 --| Use this package to generate output report for Mass uopdate |
14 --| |
15 --| HISTORY |
16 --| 05/22/2002 tsimmond Created |
17 --| 11/27/2002 tsimmond Updated Added WHENEVER OSERROR EXIT |
18 --| FAILURE ROLLBACK |
19 --+======================================================================*/
20
21
22 --===================
23 -- CONSTANTS
24 --===================
25
26 G_RPT_PAGE_COL CONSTANT INTEGER :=130;
27 G_FORMAT_SPACE CONSTANT INTEGER :=2;
28 --
29 G_LOG_ERROR CONSTANT NUMBER := 5;
30 G_LOG_EXCEPTION CONSTANT NUMBER := 4;
31 G_LOG_EVENT CONSTANT NUMBER := 3;
32 G_LOG_PROCEDURE CONSTANT NUMBER := 2;
33 G_LOG_STATEMENT CONSTANT NUMBER := 1;
34
35 G_PROF_NUMBER NUMBER;
36
37 --===================
38 -- PROCEDURE : Initialize PUBLIC
39 -- PARAMETERS:
40 -- COMMENT : This is the procedure to initialize pls/sql tables
41 -- for recording action information of vendor conversion.
42 --===================
43 PROCEDURE Initialize;
44
45
46 --========================================================================
47 -- PROCEDURE : Log PUBLIC
48 -- PARAMETERS: p_level IN priority of the message -
49 -- from highest to lowest:
50 -- G_LOG_ERROR
51 -- G_LOG_EXCEPTION
52 -- G_LOG_EVENT
53 -- G_LOG_PROCEDURE
54 -- G_LOG_STATEMENT
55 -- p_msg IN message to be print on the log file
56 -- COMMENT : Add an entry to the log
57 --=======================================================================--
58 PROCEDURE Log
59 ( p_priority IN NUMBER
60 , p_msg IN VARCHAR2
61 );
62
63
64
65 --==========================================================================
66 -- PROCEDURE : Add_Exp_Item PUBLIC
67 -- PARAMETERS: p_party name of the party not updated
68 -- p_customer name of the customer not updated
69 -- p_site name of the customer site not updated
70 --
71 -- COMMENT : This is the procedure to record exception information into g_exp_table.
72 --
73 --==========================================================================
74 PROCEDURE Add_Exp_Item
75 ( p_party IN VARCHAR2
76 , p_customer IN VARCHAR2
77 , p_site IN VARCHAR2
78 );
79
80
81 --====================
82 -- PROCEDURE : Generate_Report PUBLIC
83 -- PARAMETERS: p_cust_prof_class Name of the profile class
84 -- p_currency_code Profile currency
85 -- p_rule_set Name of the rule set
86 --
87 -- COMMENT : This is the procedure to print action information.
88 --====================
89 PROCEDURE Generate_Report
90 ( p_prof_class_id IN NUMBER
91 , p_currency_code IN VARCHAR2
92 , p_profile_class_amount_id IN NUMBER
93 );
94
95
96 END HZ_MGD_MASS_UPDATE_REP_GEN;