DBA Data[Home] [Help]

APPS.PQH_MGMT_RPT_PKG dependencies on PER_POSITIONS

Line 82: p_position_id IN per_positions.position_id%TYPE,

78: (
79: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
80: p_start_date IN pqh_budgets.budget_start_date%TYPE,
81: p_end_date IN pqh_budgets.budget_end_date%TYPE,
82: p_position_id IN per_positions.position_id%TYPE,
83: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
84: )
85: RETURN NUMBER IS
86: /*

Line 526: p_position_id IN per_positions.position_id%TYPE,

522: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
523: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
524: p_start_date IN pqh_budgets.budget_start_date%TYPE,
525: p_end_date IN pqh_budgets.budget_end_date%TYPE,
526: p_position_id IN per_positions.position_id%TYPE,
527: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
528: )
529: RETURN NUMBER IS
530: /*

Line 656: p_position_id IN per_positions.position_id%TYPE,

652: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
653: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
654: p_start_date IN pqh_budgets.budget_start_date%TYPE,
655: p_end_date IN pqh_budgets.budget_end_date%TYPE,
656: p_position_id IN per_positions.position_id%TYPE,
657: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
658: )
659: RETURN NUMBER IS
660: /*

Line 975: p_position_id IN per_positions.position_id%TYPE,

971: ---------------------------------------------------------------------------------------------------------
972: FUNCTION get_position_actual_cmmtmnts
973: (
974: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
975: p_position_id IN per_positions.position_id%TYPE,
976: p_start_date IN pqh_budgets.budget_start_date%TYPE,
977: p_end_date IN pqh_budgets.budget_end_date%TYPE,
978: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
979: p_value_type IN varchar2 DEFAULT 'T',

Line 1322: p_position_id IN per_positions.position_id%TYPE,

1318: ---------------------------------------------------------------------------------------------------------
1319: FUNCTION get_position_budget_amt
1320: (
1321: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1322: p_position_id IN per_positions.position_id%TYPE,
1323: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1324: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1325: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1326: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 1516: p_position_id IN per_positions.position_id%TYPE,

1512: ---------------------------------------------------------------------------------------------------------
1513: FUNCTION get_posn_element_bdgt_amt
1514: (
1515: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1516: p_position_id IN per_positions.position_id%TYPE,
1517: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1518: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1519: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1520: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 2258: p_position_id IN per_positions.position_id%TYPE,

2254: ---------------------------------------------------------------------------------------------------------
2255: FUNCTION get_posn_bset_bdgt_amt
2256: (
2257: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2258: p_position_id IN per_positions.position_id%TYPE,
2259: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
2260: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2261: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2262: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

Line 2287: p_position_id IN per_positions.position_id%TYPE,

2283: ---------------------------------------------------------------------------------------------------------
2284: FUNCTION get_posn_elmnt_actual_cmmtmnts
2285: (
2286: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2287: p_position_id IN per_positions.position_id%TYPE,
2288: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2289: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2290: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2291: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 2756: p_position_id IN per_positions.position_id%TYPE,

2752: ---------------------------------------------------------------------------------------------------------
2753: FUNCTION get_posn_bset_actual_cmmtmnts
2754: (
2755: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2756: p_position_id IN per_positions.position_id%TYPE,
2757: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
2758: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2759: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2760: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 4021: p_position_id IN per_positions.position_id%TYPE,

4017: ---------------------------------------------------------------------------------------------------------
4018: FUNCTION get_position_type
4019: (
4020: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4021: p_position_id IN per_positions.position_id%TYPE,
4022: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4023: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4024: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4025: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 4118: p_position_id IN per_positions.position_id%TYPE,

4114: --
4115: FUNCTION check_pos_type_and_variance
4116: (
4117: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4118: p_position_id IN per_positions.position_id%TYPE,
4119: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4120: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4121: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4122: p_position_type IN VARCHAR2 DEFAULT 'Y',