APPS.FII_GL_JE_B_C dependencies on FII_GL_WORKER_JOBS

Line 608: g_phase := 'Loop to insert into FII_GL_WORKER_JOBS: '

604: FROM FII_GL_NEW_JRL_HEADER_IDS;
605:
606: WHILE (l_start_number <= l_max_number) LOOP
607: l_end_number:= l_start_number + g_child_process_size;
608: g_phase := 'Loop to insert into FII_GL_WORKER_JOBS: '
609: || l_start_number || ', ' || l_end_number;
610: INSERT INTO FII_GL_WORKER_JOBS (start_range, end_range, worker_number, status)
611: VALUES (l_start_number, least(l_end_number, l_max_number), 0, 'UNASSIGNED');
612: l_count := l_count + 1;

Line 610: INSERT INTO FII_GL_WORKER_JOBS (start_range, end_range, worker_number, status)

606: WHILE (l_start_number <= l_max_number) LOOP
607: l_end_number:= l_start_number + g_child_process_size;
608: g_phase := 'Loop to insert into FII_GL_WORKER_JOBS: '
609: || l_start_number || ', ' || l_end_number;
610: INSERT INTO FII_GL_WORKER_JOBS (start_range, end_range, worker_number, status)
611: VALUES (l_start_number, least(l_end_number, l_max_number), 0, 'UNASSIGNED');
612: l_count := l_count + 1;
613: l_start_number := least(l_end_number, l_max_number) + 1;
614: END LOOP;

Line 617: FII_UTIL.put_line('Inserted ' || l_count || ' jobs into FII_GL_WORKER_JOBS table');

613: l_start_number := least(l_end_number, l_max_number) + 1;
614: END LOOP;
615:
616: if g_debug_flag = 'Y' then
617: FII_UTIL.put_line('Inserted ' || l_count || ' jobs into FII_GL_WORKER_JOBS table');
618: end if;
619:
620: COMMIT;
621:

Line 837: TRUNCATE_TABLE('FII_GL_WORKER_JOBS');

833: if g_debug_flag = 'Y' then
834: FII_UTIL.put_line('Calling procedure: CLEAN_UP');
835: end if;
836:
837: TRUNCATE_TABLE('FII_GL_WORKER_JOBS');
838:
839: IF (g_truncate_id) THEN
840: TRUNCATE_TABLE('FII_GL_NEW_JRL_HEADER_IDS');
841: END IF;

Line 3623: -- Register jobs in the table FII_GL_WORKER_JOBS for launching

3619:
3620: ELSE
3621:
3622: ----------------------------------------------------------------
3623: -- Register jobs in the table FII_GL_WORKER_JOBS for launching
3624: -- child processes.
3625: ----------------------------------------------------------------
3626: g_phase := 'Calling Routine Register_Jobs';
3627:

Line 3682: FROM FII_GL_WORKER_JOBS;

3678: l_completed_cnt,
3679: l_wip_cnt,
3680: l_failed_cnt,
3681: l_tot_cnt
3682: FROM FII_GL_WORKER_JOBS;
3683:
3684: if g_debug_flag = 'Y' then
3685: FII_UTIL.put_line('Job status - Unassigned:'||l_unassigned_cnt||
3686: ' In Process:'||l_wip_cnt||

Line 3986: FROM FII_GL_WORKER_JOBS;

3982: l_failed_cnt,
3983: l_wip_cnt,
3984: l_completed_cnt,
3985: l_total_cnt
3986: FROM FII_GL_WORKER_JOBS;
3987:
3988: if g_debug_flag = 'Y' then
3989: FII_UTIL.put_line('Job status - Unassigned: '||l_unassigned_cnt||
3990: ' In Process: '||l_wip_cnt||

Line 4015: UPDATE FII_GL_WORKER_JOBS

4011: FII_UTIL.put_line('All jobs completed, no more job. Terminating');
4012: end if;
4013: EXIT;
4014: ELSIF (l_unassigned_cnt > 0) THEN
4015: UPDATE FII_GL_WORKER_JOBS
4016: SET status = 'IN PROCESS',
4017: worker_number = p_worker_no
4018: WHERE status = 'UNASSIGNED'
4019: AND rownum < 2;

Line 4037: g_phase := 'Getting ID range from FII_GL_WORKER_JOBS table';

4033: -- -----------------------------------
4034: IF (l_count > 0) THEN
4035: DECLARE
4036: BEGIN
4037: g_phase := 'Getting ID range from FII_GL_WORKER_JOBS table';
4038: if g_debug_flag = 'Y' then
4039: FII_UTIL.put_line(g_phase);
4040: end if;
4041:

Line 4046: FROM FII_GL_WORKER_JOBS

4042: SELECT start_range,
4043: end_range
4044: INTO l_start_range,
4045: l_end_range
4046: FROM FII_GL_WORKER_JOBS
4047: WHERE worker_number = p_worker_no
4048: AND status = 'IN PROCESS';
4049:
4050: --------------------------------------------------

Line 4069: g_phase:='Updating job status in FII_GL_WORKER_JOBS table';

4065: -- process
4066: -- After completing the work, set the job status
4067: -- to complete
4068: -----------------------------------------------------
4069: g_phase:='Updating job status in FII_GL_WORKER_JOBS table';
4070: if g_debug_flag = 'Y' then
4071: FII_UTIL.put_line(g_phase);
4072: end if;
4073:

Line 4074: UPDATE FII_GL_WORKER_JOBS

4070: if g_debug_flag = 'Y' then
4071: FII_UTIL.put_line(g_phase);
4072: end if;
4073:
4074: UPDATE FII_GL_WORKER_JOBS
4075: SET status = 'COMPLETED'
4076: WHERE status = 'IN PROCESS'
4077: AND worker_number = p_worker_no;
4078:

Line 4088: UPDATE FII_GL_WORKER_JOBS

4084: EXCEPTION
4085: WHEN OTHERS THEN
4086: g_retcode := -1;
4087:
4088: UPDATE FII_GL_WORKER_JOBS
4089: SET status = 'FAILED'
4090: WHERE worker_number = p_worker_no
4091: AND status = 'IN PROCESS';
4092: