APPS.CN_COLLECTION_CUSTOM_GEN dependencies on CN_COLLECTION_GEN

Line 131: -- for all pacakges (inclding OC and AR) at the start of the procedure by the cn_collection_gen

127: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''Inserting new transactions into CN_NOT_TRX.'');');
128: cn_utils.appendcr(code);
129: --+
130: -- Most local variables for the collect procedure are part of a static set, which is generated
131: -- for all pacakges (inclding OC and AR) at the start of the procedure by the cn_collection_gen
132: -- package. However, for the notification query of Custom data sources, we need local variables
133: -- which have the names of the any parameters which have been specified by the user on the Queries
134: -- tab of the Collections form. To allow use to do this, we need to enclose the notification query
135: -- in its own block.

Line 195: IF CN_COLLECTION_GEN.isParallelEnabled THEN

191: --+
192: -- Changed to fix Bug 6203234 to include PDML in Notification Query
193: --
194: --+
195: IF CN_COLLECTION_GEN.isParallelEnabled THEN
196: create_parallel_hint(x_source_string => l_notify_from,
197: x_parallel_hint => l_parallel_hint
198: );
199: END IF;

Line 210: IF CN_COLLECTION_GEN.isParallelEnabled THEN

206: cn_utils.appindcr(code, '--');
207: cn_utils.appindcr(code, '-- Insert new lines into cn_not_trx');
208: cn_utils.appindcr(code, '--');
209: cn_utils.appindcr(code, '--CN_DB_PARALLEL_ENABLE :'||fnd_profile.value('CN_DB_PARALLEL_ENABLE'));
210: IF CN_COLLECTION_GEN.isParallelEnabled THEN
211: cn_utils.appindcr(code, 'INSERT /'||'*+ PARALLEL(cn_not_trx) */ INTO cn_not_trx (');
212: ELSE
213: cn_utils.appindcr(code, 'INSERT INTO cn_not_trx (');
214: END IF;

Line 230: IF CN_COLLECTION_GEN.isParallelEnabled THEN

226: cn_utils.unindent(code, 1);
227: --+
228: -- Generate the SELECT clause for the insert statement
229: --+
230: IF CN_COLLECTION_GEN.isParallelEnabled THEN
231: cn_utils.appindcr(code, 'SELECT '||l_parallel_hint);
232: ELSE
233: cn_utils.appindcr(code, 'SELECT ');
234: END IF;

Line 276: IF CN_COLLECTION_GEN.isParallelEnabled THEN

272: -- Finish off the statement
273: --+
274:
275: cn_utils.appindcr(code, ' AND NOT EXISTS (');
276: IF CN_COLLECTION_GEN.isParallelEnabled THEN
277: cn_utils.appindcr(code, ' SELECT /'||'*'||'+ PARALLEL(cn_not_trx) '||'*/ 1');
278: ELSE
279: cn_utils.appindcr(code, ' SELECT 1');
280: END IF;

Line 349: IF CN_COLLECTION_GEN.isParallelEnabled THEN

345:
346: BEGIN
347:
348: cn_utils.set_org_id(p_org_id => x_org_id);
349: IF CN_COLLECTION_GEN.isParallelEnabled THEN
350: IF x_table_map_id > 0
351: THEN
352: cn_utils.appindcr(code, 'INSERT /'||'*+ PARALLEL(cn_comm_lines_api) */ INTO cn_comm_lines_api (');
353: ELSE

Line 379: IF CN_COLLECTION_GEN.isParallelEnabled THEN

375: cn_utils.unindent(code, 1);
376:
377:
378: -- Generate the SELECT clause for the insert statement
379: IF CN_COLLECTION_GEN.isParallelEnabled THEN
380: cn_utils.appindcr(code, 'SELECT '||x_parallel_hint);
381: ELSE
382: cn_utils.appindcr(code, 'SELECT ');
383: END IF;

Line 478: IF CN_COLLECTION_GEN.isParallelEnabled THEN

474: --+
475: -- Changed to fix Bug 6203234 to include PDML in Collection Query
476: --
477: --+
478: IF CN_COLLECTION_GEN.isParallelEnabled THEN
479: create_parallel_hint(x_source_string => l_collect_from,
480: x_parallel_hint => l_parallel_hint
481: );
482: END IF;

Line 556: IF CN_COLLECTION_GEN.isParallelEnabled THEN

552: cn_utils.appindcr(code, 'fnd_file.put_line(fnd_file.Log,''Updating collected_flag in CN_NOT_TRX .'');');
553:
554: cn_utils.appendcr(code);
555:
556: IF CN_COLLECTION_GEN.isParallelEnabled THEN
557: cn_utils.appindcr(code, 'UPDATE /'||'*+ PARALLEL(cnt) */ cn_not_trx cnt');
558: ELSE
559: cn_utils.appindcr(code, 'UPDATE cn_not_trx cnt');
560: END IF;

Line 570: IF CN_COLLECTION_GEN.isParallelEnabled THEN

566: cn_utils.appindcr(code, ' AND cnt.org_id = '||l_org_id||' ;');
567: cn_utils.appendcr(code);
568: cn_utils.appindcr(code, 'cn_message_pkg.debug(''Updated collected_flag in cn_not_trx.'');');
569:
570: IF CN_COLLECTION_GEN.isParallelEnabled THEN
571: cn_utils.appindcr(code, 'COMMIT;');
572: END IF;
573:
574: cn_utils.appendcr(code);