DBA Data[Home] [Help]

APPS.PQH_MGMT_RPT_PKG dependencies on PER_JOBS

Line 205: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL,

201: FUNCTION get_entity_bdgt
202: (
203: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
204: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
205: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL,
206: p_grade_id IN per_grades.grade_id%TYPE DEFAULT NULL,
207: p_organization_id IN hr_organization_units.organization_id%TYPE DEFAULT NULL,
208: p_start_date IN pqh_budgets.budget_start_date%TYPE,
209: p_end_date IN pqh_budgets.budget_end_date%TYPE,

Line 1017: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL,

1013: FUNCTION get_entity_actual_cmmtmnts
1014: (
1015: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1016: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
1017: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL,
1018: p_grade_id IN per_grades.grade_id%TYPE DEFAULT NULL,
1019: p_organization_id IN hr_organization_units.organization_id%TYPE DEFAULT NULL,
1020: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1021: p_end_date IN pqh_budgets.budget_end_date%TYPE,

Line 1357: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL,

1353: FUNCTION get_entity_budget_amt
1354: (
1355: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1356: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
1357: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL,
1358: p_grade_id IN per_grades.grade_id%TYPE DEFAULT NULL,
1359: p_organization_id IN hr_organization_units.organization_id%TYPE DEFAULT NULL,
1360: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1361: p_end_date IN pqh_budgets.budget_end_date%TYPE,

Line 1549: p_job_id IN per_jobs.job_id%TYPE,

1545: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1546: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1547: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1548: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1549: p_job_id IN per_jobs.job_id%TYPE,
1550: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
1551: )
1552: RETURN NUMBER IS
1553: /*

Line 1692: p_job_id IN per_jobs.job_id%TYPE,

1688: --
1689: FUNCTION get_job_element_bdgt_amt
1690: (
1691: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1692: p_job_id IN per_jobs.job_id%TYPE,
1693: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1694: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1695: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1696: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 2406: p_job_id IN per_jobs.job_id%TYPE,

2402: ---------------------------------------------------------------------------------------------------------
2403: FUNCTION get_job_elmnt_actual_cmmtmnts
2404: (
2405: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2406: p_job_id IN per_jobs.job_id%TYPE,
2407: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2408: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2409: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2410: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 4252: p_job_id IN per_jobs.job_id%TYPE,

4248: --
4249: FUNCTION check_job_type_and_variance
4250: (
4251: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4252: p_job_id IN per_jobs.job_id%TYPE,
4253: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4254: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4255: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4256: p_entity_type IN VARCHAR2 DEFAULT 'Y',