APPS.PAY_DBITL_UPDATE_ERRORS_PKG dependencies on PAY_DBITL_UPDATE_ERRORS

Line 1: package body pay_dbitl_update_errors_pkg as

1: package body pay_dbitl_update_errors_pkg as
2: /* $Header: pydbtlue.pkb 120.1 2006/11/10 17:26:54 arashid noship $ */
3: ------------------------------- insert_row -------------------------------
4: procedure insert_row
5: (p_user_name in varchar2

Line 29: insert into pay_dbitl_update_errors

25: ,p_message_text in varchar2
26: ,p_rowid out nocopy varchar2
27: ) is
28: begin
29: insert into pay_dbitl_update_errors
30: (user_name
31: ,user_entity_id
32: ,translated_name
33: ,message_text

Line 52: delete pay_dbitl_update_errors

48: ,p_user_entity_id in number
49: ,p_translated_name in varchar2
50: ) is
51: begin
52: delete pay_dbitl_update_errors
53: where user_name = p_user_name
54: and user_entity_id = p_user_entity_id
55: and translated_name = p_translated_name
56: ;

Line 69: delete pay_dbitl_update_errors

65: return;
66: end if;
67:
68: forall i in 1 .. p_rowids.count
69: delete pay_dbitl_update_errors
70: where rowid = p_rowids(i);
71: end delete_rows;
72:
73: ------------------------------- delete_row -------------------------------

Line 78: delete pay_dbitl_update_errors

74: procedure delete_row
75: (p_rowid in varchar2
76: ) is
77: begin
78: delete pay_dbitl_update_errors
79: where rowid = p_rowid
80: ;
81: end delete_row;
82:

Line 93: from pay_dbitl_update_errors

89: select rowid
90: , message_text bulk collect
91: into p_rowids
92: , p_messages
93: from pay_dbitl_update_errors
94: ;
95: end fetch_all_rows;
96:
97: end pay_dbitl_update_errors_pkg;

Line 97: end pay_dbitl_update_errors_pkg;

93: from pay_dbitl_update_errors
94: ;
95: end fetch_all_rows;
96:
97: end pay_dbitl_update_errors_pkg;