APPS.ICX_POR_JOB_TRACK_VALIDATION_S dependencies on ICX_POR_BATCH_JOBS

Line 18: update icx_por_batch_jobs

14: p_failed_items in number) is
15: l_progress varchar2(10) := '000';
16: begin
17: l_progress := '001';
18: update icx_por_batch_jobs
19: set job_status = p_new_status,
20: start_datetime = decode(p_new_status, 'RUNNING', sysdate, start_datetime),
21: items_loaded = p_loaded_items,
22: items_failed = p_failed_items

Line 38: update icx_por_batch_jobs

34: procedure complete_job(p_jobno in number) is
35: l_progress varchar2(10) := '000';
36: begin
37: l_progress := '001';
38: update icx_por_batch_jobs
39: set job_status = decode(items_failed, 0, 'COMPLETED', 'COMPLETED W/ERRORS'),
40: completion_datetime = sysdate
41: where job_number = p_jobno;
42:

Line 57: update icx_por_batch_jobs

53: p_error_message in varchar2) is
54: l_progress varchar2(10) := '000';
55: begin
56: l_progress := '001';
57: update icx_por_batch_jobs
58: set job_status = 'FAILED',
59: completion_datetime = sysdate,
60: failure_message = p_error_message
61: where job_number = p_jobno;

Line 87: select icx_por_batch_jobs_s.nextval

83: begin
84: l_progress := '001';
85: if (p_jobno is null) then
86: l_progress := '002';
87: select icx_por_batch_jobs_s.nextval
88: into p_jobno
89: from sys.dual;
90: end if;
91:

Line 562: from icx_por_batch_jobs

558: l_progress := '010';
559: begin
560: select min(job_number)
561: into p_jobno
562: from icx_por_batch_jobs
563: where job_status='PENDING'
564: and host_ip_address = p_host_ip_address;
565: exception
566: when no_data_found then

Line 582: from icx_por_batch_jobs jb

578: p_supplier_id,
579: p_supplier_name,
580: p_exchange_operator
581: /* from po_vendors pt, */
582: from icx_por_batch_jobs jb
583: where job_number = p_jobno;
584: -- and jb.supplier_id = pt.vendor_id;
585:
586: update icx_por_batch_jobs

Line 586: update icx_por_batch_jobs

582: from icx_por_batch_jobs jb
583: where job_number = p_jobno;
584: -- and jb.supplier_id = pt.vendor_id;
585:
586: update icx_por_batch_jobs
587: set job_status = 'RUNNING',
588: start_datetime = sysdate
589: where job_number = p_jobno;
590:

Line 612: select icx_por_batch_jobs_s.nextval

608: l_jobno number;
609: begin
610:
611: l_progress := '001';
612: select icx_por_batch_jobs_s.nextval
613: into l_jobno
614: from sys.dual;
615:
616: l_progress := '002';

Line 617: insert into icx_por_batch_jobs (

613: into l_jobno
614: from sys.dual;
615:
616: l_progress := '002';
617: insert into icx_por_batch_jobs (
618: job_number,
619: supplier_id,
620: supplier_file_name,
621: exchange_file_name,