[Home] [Help]
PACKAGE: APPS.BEN_WARNINGS
Source
1 package ben_warnings AUTHID CURRENT_USER as
2 /* $Header: benwarng.pkh 120.1 2006/11/23 13:56:16 gsehgal noship $ */
3
4 type g_oab_warnings_rec is record
5 (message_name fnd_new_messages.message_name%type,
6 application_short_name fnd_application.application_short_name%type,
7 parm1 number,
8 parm2 number,
9 parma varchar2(600),/*bug 3127048 increased the length */
10 parmb varchar2(600),/*bug 3127048 increased the length */
11 parmc varchar2(600),--bug 4120426
12 person_id number);
13
14 type g_oab_warnings_table is table of g_oab_warnings_rec
15 index by binary_integer;
16
17 g_oab_warnings g_oab_warnings_table;
18
19 g_oab_warnings_count number ;
20
21 g_warning_rec ben_type.g_report_rec ;
22 ----------------------------------------------------------------------------
23 -- exist_warning -- bug 4120426
24 ----------------------------------------------------------------------------
25 FUNCTION exist_warning
26 (p_application_short_name in varchar2,
27 p_message_name in varchar2,
28 p_parm1 in number default null,
29 p_parm2 in number default null,
30 p_parma in varchar2 default null,
31 p_parmb in varchar2 default null,
32 p_parmc in varchar2 default null,
33 p_person_id in number default null) return boolean;
34 ----------------------------------------------------------------------------
35 -- load_warning
36 ----------------------------------------------------------------------------
37 PROCEDURE load_warning
38 (p_application_short_name in varchar2,
39 p_message_name in varchar2,
40 p_parm1 in number default null,
41 p_parm2 in number default null,
42 p_parma in varchar2 default null,
43 p_parmb in varchar2 default null,
44 p_parmc in varchar2 default null,--bug 4120426
45 p_person_id in number default null);
46
47 ----------------------------------------------------------------------------
48 -- trim_warnings
49 ----------------------------------------------------------------------------
50 PROCEDURE trim_warnings(p_trim in number);
51
52 ----------------------------------------------------------------------------
53 -- empty_warnings
54 ----------------------------------------------------------------------------
55 PROCEDURE empty_warnings;
56
57 ----------------------------------------------------------------------------
58 -- set_warning
59 ----------------------------------------------------------------------------
60 PROCEDURE set_warning
61 (p_index number);
62
63 ----------------------------------------------------------------------------
64 -- write_warnings_batch
65 ----------------------------------------------------------------------------
66 PROCEDURE write_warnings_batch;
67
68 ----------------------------------------------------------------------------
69 -- write_warnings_online
70 ----------------------------------------------------------------------------
71 PROCEDURE write_warnings_online (p_session_id in number) ;
72
73 ----------------------------------------------------------------------------
74 -- delete_warnings
75 ----------------------------------------------------------------------------
76 PROCEDURE delete_warnings (
77 p_application_short_name IN VARCHAR2,
78 p_message_name IN VARCHAR2,
79 p_parm1 IN NUMBER DEFAULT NULL,
80 p_parm2 IN NUMBER DEFAULT NULL,
81 p_parma IN VARCHAR2 DEFAULT NULL,
82 p_parmb IN VARCHAR2 DEFAULT NULL,
83 p_parmc IN VARCHAR2 DEFAULT NULL,
84 p_person_id IN NUMBER DEFAULT NULL
85 );
86
87 end ben_warnings;