[Home] [Help]
373: --initialize message list
374: fnd_msg_pub.initialize;
375:
376: -- insert people into cn_process_batches
377: select cn_process_batches_s2.nextval into l_logical_batch_id from dual;
378:
379: -- determine the periods to process
380: select min(period_id), max(period_id), min(start_date), max(end_date)
381: into l_start_period_id, l_end_period_id, l_start_date, l_end_date
421: from jtf_rs_role_relations rr,
422: cn_rs_salesreps s,
423: jtf_rs_roles_b r
424: where rr.role_resource_id = s.resource_id
425: and rr.role_resource_type = 'RS_INDIVIDUAL'
426: and rr.delete_flag = 'N'
427: and rr.role_id = r.role_id
428: and r.role_type_code = 'SALES_COMP'
429: and (rr.end_date_active IS NULL OR rr.end_date_active >= l_start_date)
450: fnd_file.put_line(fnd_file.Log, ' : Logical Batch Id => '||l_logical_batch_id);
451: ----------------------------------------------------------------------------
452:
453: loop
454: select cn_process_batches_s3.nextval into l_physical_batch_id from dual;
455: ----------------------------------------------------------------------------
456: fnd_file.put_line(fnd_file.Log, ' : Physical Batch Id => '||l_physical_batch_id);
457: ----------------------------------------------------------------------------
458: update cn_process_batches
521: p_logical_batch_id => l_logical_batch_id,
522: p_org_id => l_org_id);
523:
524: BEGIN
525: SELECT 1 INTO l_temp FROM dual
526: WHERE NOT exists (SELECT 1
527: FROM cn_process_batches
528: WHERE logical_batch_id = l_logical_batch_id AND status_code = 'ERROR');
529: EXCEPTION
1002:
1003: IF (c1%NOTFOUND) THEN
1004: SELECT cn_period_types_s.NEXTVAL
1005: INTO x_period_type_id
1006: FROM dual;
1007: INSERT INTO cn_period_types
1008: (period_type_id,
1009: period_type,
1010: org_id)
1022:
1023: IF (c2%NOTFOUND) THEN
1024: SELECT cn_period_sets_s.NEXTVAL
1025: INTO x_period_set_id
1026: FROM dual;
1027: INSERT INTO cn_period_sets
1028: (period_set_id,
1029: period_set_name,
1030: org_id)