APPS.ICX_POR_TRACK_VALIDATE_JOB_S dependencies on ICX_POR_BATCH_JOBS

Line 25: update icx_por_batch_jobs

21: p_user_id IN NUMBER) is
22: l_progress varchar2(10) := '000';
23: begin
24: l_progress := '001';
25: update icx_por_batch_jobs
26: set job_status = p_new_status,
27: start_datetime = decode(p_new_status, 'RUNNING', sysdate, start_datetime),
28: items_loaded = p_loaded_items,
29: items_failed = p_failed_items,

Line 61: select icx_por_batch_jobs_s.nextval

57: l_jobno number;
58: begin
59:
60: l_progress := '001';
61: select icx_por_batch_jobs_s.nextval
62: into l_jobno
63: from sys.dual;
64:
65: l_progress := '002';

Line 66: insert into icx_por_batch_jobs (

62: into l_jobno
63: from sys.dual;
64:
65: l_progress := '002';
66: insert into icx_por_batch_jobs (
67: job_number,
68: request_id,
69: supplier_id,
70: supplier_file_name,

Line 135: select icx_por_batch_jobs_s.nextval

131: l_jobno number;
132: begin
133:
134: l_progress := '001';
135: select icx_por_batch_jobs_s.nextval
136: into l_jobno
137: from sys.dual;
138:
139: l_progress := '002';

Line 140: insert into icx_por_batch_jobs (

136: into l_jobno
137: from sys.dual;
138:
139: l_progress := '002';
140: insert into icx_por_batch_jobs (
141: job_number,
142: request_id,
143: supplier_id,
144: supplier_file_name,

Line 186: DELETE FROM ICX_POR_BATCH_JOBS WHERE JOB_NUMBER = p_jobno;

182: END create_job;
183:
184: FUNCTION delete_job(p_jobno in number) return varchar2 is
185: BEGIN
186: DELETE FROM ICX_POR_BATCH_JOBS WHERE JOB_NUMBER = p_jobno;
187: DELETE FROM ICX_POR_FAILED_LINES WHERE JOB_NUMBER = p_jobno;
188: DELETE FROM ICX_POR_FAILED_LINE_MESSAGES WHERE JOB_NUMBER = p_jobno;
189: COMMIT;
190: return 'Y';