DBA Data[Home] [Help]

APPS.POS_COMPARE_REVISIONS dependencies on PER_JOBS

Line 2657: c_job per_jobs.name%TYPE;

2653:
2654: c_job_id NUMBER := NULL;
2655: c_org_id NUMBER := NULL;
2656: c_item mtl_system_items_kfv.concatenated_segments%TYPE;
2657: c_job per_jobs.name%TYPE;
2658:
2659: v_progress VARCHAR2(3);
2660:
2661: BEGIN

Line 3885: c_job per_jobs.name%TYPE;

3881:
3882: c_job_id NUMBER := NULL;
3883: c_org_id NUMBER := NULL;
3884: c_item mtl_system_items_kfv.concatenated_segments%TYPE;
3885: c_job per_jobs.name%TYPE;
3886:
3887: v_progress VARCHAR2(3);
3888:
3889: v_from_payment_type VARCHAR(100) := NULL;

Line 5125: v_job_name per_jobs.name%TYPE;

5121: ********************************************************************/
5122: FUNCTION get_job( p_job_id IN NUMBER )
5123: RETURN VARCHAR2 AS
5124:
5125: v_job_name per_jobs.name%TYPE;
5126: v_progress varchar2(3);
5127:
5128: BEGIN
5129:

Line 5134: FROM per_jobs

5130: v_progress := '111';
5131:
5132: SELECT name
5133: INTO v_job_name
5134: FROM per_jobs
5135: WHERE job_id = p_job_id and rownum = 1;
5136:
5137: RETURN v_job_name;
5138: