DBA Data[Home] [Help]

APPS.POS_COMPARE_REVISIONS dependencies on PER_JOBS

Line 2661: c_job per_jobs.name%TYPE;

2657:
2658: c_job_id NUMBER := NULL;
2659: c_org_id NUMBER := NULL;
2660: c_item mtl_system_items_kfv.concatenated_segments%TYPE;
2661: c_job per_jobs.name%TYPE;
2662:
2663: v_progress VARCHAR2(3);
2664:
2665: BEGIN

Line 3889: c_job per_jobs.name%TYPE;

3885:
3886: c_job_id NUMBER := NULL;
3887: c_org_id NUMBER := NULL;
3888: c_item mtl_system_items_kfv.concatenated_segments%TYPE;
3889: c_job per_jobs.name%TYPE;
3890:
3891: v_progress VARCHAR2(3);
3892:
3893: v_from_payment_type VARCHAR(100) := NULL;

Line 5131: v_job_name per_jobs.name%TYPE;

5127: ********************************************************************/
5128: FUNCTION get_job( p_job_id IN NUMBER )
5129: RETURN VARCHAR2 AS
5130:
5131: v_job_name per_jobs.name%TYPE;
5132: v_progress varchar2(3);
5133:
5134: BEGIN
5135:

Line 5140: FROM per_jobs

5136: v_progress := '111';
5137:
5138: SELECT name
5139: INTO v_job_name
5140: FROM per_jobs
5141: WHERE job_id = p_job_id and rownum = 1;
5142:
5143: RETURN v_job_name;
5144: