APPS.CNSYSP_SYSTEM_PARAMETERS_PKG dependencies on CN_REPOSITORIES

Line 133: update cn_repositories

129: X_system_batch_size < 5000 ) then
130:
131: X_system_batch_size := 5000;
132:
133: update cn_repositories
134: set system_batch_size = 5000
135: where repository_id = X_repository_id;
136: end if;
137:

Line 143: update cn_repositories

139: X_transfer_batch_size < 5000 ) then
140:
141: X_transfer_batch_size := 5000;
142:
143: update cn_repositories
144: set transfer_batch_size = 5000
145: where repository_id = X_repository_id;
146: end if;
147:

Line 153: update cn_repositories

149: X_clawback_grace_days < 0) then
150:
151: X_clawback_grace_days := 0;
152:
153: update cn_repositories
154: set clawback_grace_days = 0
155: where repository_id = X_repository_id;
156: end if;
157:

Line 162: update cn_repositories

158: if (X_trx_rollup_method is NULL) then
159:
160: X_trx_rollup_method := 'INV';
161:
162: update cn_repositories
163: set trx_rollup_method = 'INV'
164: where repository_id = X_repository_id;
165:
166: end if;

Line 172: update cn_repositories

168: if (X_srp_rollup_flag is NULL) then
169:
170: X_srp_rollup_flag := 'N';
171:
172: update cn_repositories
173: set srp_rollup_flag = 'N'
174: where repository_id = X_repository_id;
175:
176: end if;

Line 190: update cn_repositories

186: (X_repository_id number) is
187:
188: begin
189:
190: update cn_repositories
191: set ( last_set_of_books_id,
192: last_current_period,
193: last_system_start_period,
194: last_system_end_period,

Line 209: from cn_repositories

205: transfer_batch_size,
206: clawback_grace_days,
207: trx_rollup_method,
208: srp_rollup_flag
209: from cn_repositories
210: where repository_id = X_repository_id )
211: where repository_id = X_repository_id;
212:
213: end save_to_last_sp;

Line 226: update cn_repositories

222: (X_repository_id number) is
223:
224: begin
225:
226: update cn_repositories
227: set ( set_of_books_id,
228: current_period,
229: system_start_period,
230: system_end_period,

Line 245: from cn_repositories

241: last_transfer_batch_size,
242: last_clawback_grace_days,
243: last_trx_rollup_method,
244: last_srp_rollup_flag
245: from cn_repositories
246: where repository_id = X_repository_id )
247: where repository_id = X_repository_id;
248:
249: end restore_from_last_sp;