DBA Data[Home] [Help]

APPS.PAY_DYNDBI_CHANGES_PKG dependencies on DBMS_SQL

Line 34: ,p_languages in dbms_sql.varchar2s

30: ------------------------------ insert_rows -------------------------------
31: procedure insert_rows
32: (p_id in varchar2
33: ,p_type in varchar2
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

Line 61: ,p_languages in dbms_sql.varchar2s

57:
58: -------------------------- element_type_change ---------------------------
59: procedure element_type_change
60: (p_element_type_id in number
61: ,p_languages in dbms_sql.varchar2s
62: ) is
63: --
64: -- Cursor for getting input values. Note: only need to fetch values
65: -- with GENERATE_DB_ITEMS_FLAG = 'Y'. Also, use the maximum effective

Line 102: ,p_languages in dbms_sql.varchar2s

98:
99: -------------------------- balance_type_change ---------------------------
100: procedure balance_type_change
101: (p_balance_type_id in number
102: ,p_languages in dbms_sql.varchar2s
103: ) is
104: cursor csr_defined_balances
105: (p_balance_type_id in number
106: ) is

Line 124: ,p_languages in dbms_sql.varchar2s

120:
121: --------------------------- input_value_change ---------------------------
122: procedure input_value_change
123: (p_input_value_id in number
124: ,p_languages in dbms_sql.varchar2s
125: ) is
126: cursor csr_input_value(p_input_value_id in number) is
127: select null
128: from pay_input_values_f iv

Line 157: ,p_languages in dbms_sql.varchar2s

153:
154: ------------------------ balance_dimension_change ------------------------
155: procedure balance_dimension_change
156: (p_balance_dimension_id in number
157: ,p_languages in dbms_sql.varchar2s
158: ) is
159: cursor csr_defined_balances
160: (p_balance_dimension_id in number
161: ) is