eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_COMMITMENT_PKG dependencies on PQH_BUDGET_DETAILS

Line 24: type bdgt_posn_rec is record(position_id pqh_budget_details.position_id%type);

20: overhead_percentage pqh_bdgt_cmmtmnt_elmnts.overhead_percentage%type);
21: --
22: type cmmtmnt_elmnts_tab is table of cmmtmnt_elmnts_rec index by binary_integer;
23: --
24: type bdgt_posn_rec is record(position_id pqh_budget_details.position_id%type);
25: type bdgt_orgn_rec is record(organization_id pqh_budget_details.organization_id%type);
26: type bdgt_job_rec is record(job_id pqh_budget_details.job_id%type);
27: type bdgt_grade_rec is record(grade_id pqh_budget_details.grade_id%type);
28: type bdgt_entity_rec is record(entity_id pqh_budget_details.position_id%type);

Line 25: type bdgt_orgn_rec is record(organization_id pqh_budget_details.organization_id%type);

21: --
22: type cmmtmnt_elmnts_tab is table of cmmtmnt_elmnts_rec index by binary_integer;
23: --
24: type bdgt_posn_rec is record(position_id pqh_budget_details.position_id%type);
25: type bdgt_orgn_rec is record(organization_id pqh_budget_details.organization_id%type);
26: type bdgt_job_rec is record(job_id pqh_budget_details.job_id%type);
27: type bdgt_grade_rec is record(grade_id pqh_budget_details.grade_id%type);
28: type bdgt_entity_rec is record(entity_id pqh_budget_details.position_id%type);
29:

Line 26: type bdgt_job_rec is record(job_id pqh_budget_details.job_id%type);

22: type cmmtmnt_elmnts_tab is table of cmmtmnt_elmnts_rec index by binary_integer;
23: --
24: type bdgt_posn_rec is record(position_id pqh_budget_details.position_id%type);
25: type bdgt_orgn_rec is record(organization_id pqh_budget_details.organization_id%type);
26: type bdgt_job_rec is record(job_id pqh_budget_details.job_id%type);
27: type bdgt_grade_rec is record(grade_id pqh_budget_details.grade_id%type);
28: type bdgt_entity_rec is record(entity_id pqh_budget_details.position_id%type);
29:
30: --

Line 27: type bdgt_grade_rec is record(grade_id pqh_budget_details.grade_id%type);

23: --
24: type bdgt_posn_rec is record(position_id pqh_budget_details.position_id%type);
25: type bdgt_orgn_rec is record(organization_id pqh_budget_details.organization_id%type);
26: type bdgt_job_rec is record(job_id pqh_budget_details.job_id%type);
27: type bdgt_grade_rec is record(grade_id pqh_budget_details.grade_id%type);
28: type bdgt_entity_rec is record(entity_id pqh_budget_details.position_id%type);
29:
30: --
31: type bdgt_posn_tab is table of bdgt_posn_rec index by binary_integer;

Line 28: type bdgt_entity_rec is record(entity_id pqh_budget_details.position_id%type);

24: type bdgt_posn_rec is record(position_id pqh_budget_details.position_id%type);
25: type bdgt_orgn_rec is record(organization_id pqh_budget_details.organization_id%type);
26: type bdgt_job_rec is record(job_id pqh_budget_details.job_id%type);
27: type bdgt_grade_rec is record(grade_id pqh_budget_details.grade_id%type);
28: type bdgt_entity_rec is record(entity_id pqh_budget_details.position_id%type);
29:
30: --
31: type bdgt_posn_tab is table of bdgt_posn_rec index by binary_integer;
32: type bdgt_orgn_tab is table of bdgt_orgn_rec index by binary_integer;

Line 293: From pqh_budget_details bdt,pqh_budget_versions bvr

289: -- budget version.
290: --
291: Cursor csr_positions_in_bdgt(l_position_id in number) is
292: Select Position_id
293: From pqh_budget_details bdt,pqh_budget_versions bvr
294: Where bvr.budget_version_id = p_budget_version_id
295: AND bvr.budget_version_id = bdt.budget_version_id
296: AND bdt.position_id IS NOT NULL
297: AND (bdt.position_id = l_position_id or l_position_id IS NULL);

Line 301: From pqh_budget_details bdt,pqh_budget_versions bvr

297: AND (bdt.position_id = l_position_id or l_position_id IS NULL);
298: --
299: Cursor csr_orgs_in_bdgt(l_organization_id in number) is
300: Select Organization_id
301: From pqh_budget_details bdt,pqh_budget_versions bvr
302: Where bvr.budget_version_id = p_budget_version_id
303: AND bvr.budget_version_id = bdt.budget_version_id
304: AND bdt.organization_id IS NOT NULL
305: AND (bdt.organization_id = l_organization_id or l_organization_id IS NULL);

Line 309: From pqh_budget_details bdt,pqh_budget_versions bvr

305: AND (bdt.organization_id = l_organization_id or l_organization_id IS NULL);
306: --
307: Cursor csr_jobs_in_bdgt(l_job_id in number) is
308: Select Job_id
309: From pqh_budget_details bdt,pqh_budget_versions bvr
310: Where bvr.budget_version_id = p_budget_version_id
311: AND bvr.budget_version_id = bdt.budget_version_id
312: AND bdt.job_id IS NOT NULL
313: AND (bdt.job_id = l_job_id or l_job_id IS NULL);

Line 317: From pqh_budget_details bdt,pqh_budget_versions bvr

313: AND (bdt.job_id = l_job_id or l_job_id IS NULL);
314: --
315: Cursor csr_grades_in_bdgt(l_grade_id in number) is
316: Select Grade_id
317: From pqh_budget_details bdt,pqh_budget_versions bvr
318: Where bvr.budget_version_id = p_budget_version_id
319: AND bvr.budget_version_id = bdt.budget_version_id
320: AND bdt.grade_id IS NOT NULL
321: AND (bdt.grade_id = l_grade_id or l_grade_id IS NULL);

Line 3049: Update pqh_budget_details

3045: hr_utility.set_location('PositionId '||g_budget_entities(pos_cnt).entity_id,13);
3046:
3047: If p_budgeted_entity_cd = 'POSITION' then
3048:
3049: Update pqh_budget_details
3050: set commitment_gl_status = g_budget_detail_status
3051: Where budget_version_id = p_budget_version_id
3052: and position_id = g_budget_entities(pos_cnt).entity_id;
3053:

Line 3056: Update pqh_budget_details

3052: and position_id = g_budget_entities(pos_cnt).entity_id;
3053:
3054: elsif p_budgeted_entity_cd ='JOB' then
3055:
3056: Update pqh_budget_details
3057: set commitment_gl_status = g_budget_detail_status
3058: Where budget_version_id = p_budget_version_id
3059: and job_id = g_budget_entities(pos_cnt).entity_id;
3060:

Line 3063: Update pqh_budget_details

3059: and job_id = g_budget_entities(pos_cnt).entity_id;
3060:
3061: elsif p_budgeted_entity_cd ='ORGANIZATION' then
3062:
3063: Update pqh_budget_details
3064: set commitment_gl_status = g_budget_detail_status
3065: Where budget_version_id = p_budget_version_id
3066: and organization_id = g_budget_entities(pos_cnt).entity_id;
3067:

Line 3069: Update pqh_budget_details

3065: Where budget_version_id = p_budget_version_id
3066: and organization_id = g_budget_entities(pos_cnt).entity_id;
3067:
3068: elsif p_budgeted_entity_cd ='GRADE' then
3069: Update pqh_budget_details
3070: set commitment_gl_status = g_budget_detail_status
3071: Where budget_version_id = p_budget_version_id
3072: and grade_id = g_budget_entities(pos_cnt).entity_id;
3073: