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