DBA Data[Home] [Help]

PACKAGE: APPS.PAY_DBITL_UPDATE_ERRORS_PKG

Source


1 package pay_dbitl_update_errors_pkg AUTHID CURRENT_USER as
2 /* $Header: pydbtlue.pkh 120.1 2006/11/10 17:24:20 arashid noship $ */
3 --
4 -- Longer bulk bind type.
5 --
6 type t_vc4k is table of varchar2(4096) index by binary_integer;
7 ------------------------------- insert_row -------------------------------
8 --
9 -- NAME
10 --   insert_row
11 --
12 -- DESCRIPTION
13 --   Inserts a row into PAY_DBITL_UPDATE_ERRORS.
14 --
15 procedure insert_row
16 (p_user_name       in varchar2
17 ,p_user_entity_id  in number
18 ,p_translated_name in varchar2
19 ,p_message_text    in varchar2
20 );
21 
22 procedure insert_row
23 (p_user_name       in varchar2
24 ,p_user_entity_id  in number
25 ,p_translated_name in varchar2
26 ,p_message_text    in varchar2
27 ,p_rowid              out nocopy varchar2
28 );
29 
30 
31 ------------------------------- delete_rows ------------------------------
32 --
33 -- NAME
34 --   delete_rows, delete_row
35 --
36 -- DESCRIPTION
37 --   Delete row(s) from PAY_DBITL_UPDATE_ERRORS.
38 --
39 procedure delete_rows
40 (p_user_name       in varchar2
41 ,p_user_entity_id  in number
42 ,p_translated_name in varchar2
43 );
44 
45 procedure delete_rows
46 (p_rowids in dbms_sql.varchar2s
47 );
48 
49 procedure delete_row
50 (p_rowid in varchar2
51 );
52 
53 ----------------------------- fetch_all_rows -----------------------------
54 --
55 -- NAME
56 --   fetch_all_rows
57 --
58 -- DESCRIPTION
59 --   Fetch all rows from PAY_DBITL_UPDATE_ERRORS.
60 --
61 procedure fetch_all_rows
62 (p_rowids   out nocopy dbms_sql.varchar2s
63 ,p_messages out nocopy dbms_sql.varchar2_table
64 );
65 
66 end pay_dbitl_update_errors_pkg;