APPS.PAY_DYNDBI_CHANGES_PKG dependencies on PAY_DYNDBI_CHANGES

Line 1: package body pay_dyndbi_changes_pkg as

1: package body pay_dyndbi_changes_pkg as
2: /* $Header: pydbichg.pkb 120.3 2008/04/25 10:05:03 ubhat noship $ */
3:
4: ------------------------------- insert_row -------------------------------
5: procedure insert_row

Line 11: insert into pay_dyndbi_changes

7: ,p_type in varchar2
8: ,p_language in varchar2
9: ) is
10: begin
11: insert into pay_dyndbi_changes
12: (id
13: ,type
14: ,language
15: )

Line 23: from pay_dyndbi_changes pdc

19: from dual
20: where not exists
21: (
22: select null
23: from pay_dyndbi_changes pdc
24: where pdc.id = p_id
25: and pdc.type = p_type
26: and pdc.language = p_language
27: );

Line 38: insert into pay_dyndbi_changes

34: ,p_languages in dbms_sql.varchar2s
35: ) is
36: begin
37: for i in 1 .. p_languages.count loop
38: insert into pay_dyndbi_changes
39: (id
40: ,type
41: ,language
42: )

Line 50: from pay_dyndbi_changes pdc

46: from dual
47: where not exists
48: (
49: select null
50: from pay_dyndbi_changes pdc
51: where pdc.id = p_id
52: and pdc.type = p_type
53: and pdc.language = p_languages(i)
54: );

Line 183: delete from pay_dyndbi_changes pdc

179: ,p_type in varchar2
180: ,p_language in varchar2
181: ) is
182: begin
183: delete from pay_dyndbi_changes pdc
184: where pdc.id = p_id
185: and pdc.type = p_type
186: and pdc.language = p_language
187: ;

Line 196: delete from pay_dyndbi_changes pdc

192: (p_id in number
193: ,p_type in varchar2
194: ) is
195: begin
196: delete from pay_dyndbi_changes pdc
197: where pdc.id = p_id
198: and pdc.type = p_type
199: ;
200: end delete_rows;

Line 202: end pay_dyndbi_changes_pkg;

198: and pdc.type = p_type
199: ;
200: end delete_rows;
201:
202: end pay_dyndbi_changes_pkg;