APPS.CN_SYSTEM_PARAMETERS_PVT dependencies on CN_REPOSITORIES

Line 37: FROM cn_repositories

33: system_batch_size, transfer_batch_size, clawback_grace_days,
34: srp_batch_size, srp_rollup_flag, latest_processed_date, usage_flag,
35: salesrep_batch_size, cls_package_size, payables_flag, payroll_flag,
36: payables_ccid_level, income_planner_disclaimer,object_version_number
37: FROM cn_repositories
38: WHERE application_type = 'CN' and repository_id > 0;
39:
40: r c%rowtype;
41: junk varchar2(30);

Line 112: from cn_repositories

108: l_api_version CONSTANT NUMBER := 1.0;
109:
110: cursor c is
111: select object_version_number
112: from cn_repositories
113: where application_type = 'CN'
114: and repository_id > 0
115: for update of repository_id nowait;
116:

Line 156: update cn_repositories

152: raise fnd_api.g_exc_unexpected_error;
153: end if;
154:
155: -- updating
156: update cn_repositories
157: set name = p_name,
158: rev_class_hierarchy_id = p_rev_class_hierarchy_id,
159: set_of_books_id = p_set_of_books_id,
160: system_batch_size = p_batch_size,

Line 189: from cn_repositories r,

185: select 0,
186: gl.period_set_name,
187: -1,
188: SYSDATE
189: from cn_repositories r,
190: gl_sets_of_books gl
191: where gl.set_of_books_id = r.set_of_books_id
192: and not exists
193: ( select 1 from cn_period_sets where period_set_id = 0 );

Line 205: from cn_repositories r,

201: select 0,
202: gl.accounted_period_type,
203: -1,
204: SYSDATE
205: from cn_repositories r,
206: gl_sets_of_books gl
207: where gl.set_of_books_id = r.set_of_books_id
208: and not exists
209: ( select 1 from cn_period_types where period_type_id = 0 );

Line 211: update cn_repositories

207: where gl.set_of_books_id = r.set_of_books_id
208: and not exists
209: ( select 1 from cn_period_types where period_type_id = 0 );
210:
211: update cn_repositories
212: set period_set_id = 0 ,
213: period_type_id = 0
214: where set_of_books_id is not null;
215: