APPS.PQH_PTX_UTL dependencies on PER_DEPLOYMENT_FACTORS

Line 148: v_wc_rec PER_DEPLOYMENT_FACTORS%ROWTYPE;

144: CURSOR c1 IS
145: SELECT *
146: FROM hr_positions
147: WHERE position_id = p_position_id;
148: v_wc_rec PER_DEPLOYMENT_FACTORS%ROWTYPE;
149: --
150: CURSOR c2 IS
151: SELECT *
152: FROM per_deployment_factors

Line 152: FROM per_deployment_factors

148: v_wc_rec PER_DEPLOYMENT_FACTORS%ROWTYPE;
149: --
150: CURSOR c2 IS
151: SELECT *
152: FROM per_deployment_factors
153: WHERE position_id = p_position_id;
154: begin
155: --
156: OPEN c1;

Line 403: from per_deployment_factors

399: where position_id=p_position_id;
400:
401: cursor c2 is
402: select *
403: from per_deployment_factors
404: where position_id=p_position_id;
405:
406: cursor c3 is
407: select *

Line 1081: per_deployment_factors

1077: It will poppulate the following tables
1078: hr_all_positions_f
1079: per_positions
1080: per_position_extra_info
1081: per_deployment_factors
1082:
1083: */
1084:
1085: --

Line 1102: l_dpf_deployment_factor_id per_deployment_factors.deployment_factor_id%type;

1098: l_effective_end_date hr_all_positions_f.effective_end_date%TYPE;
1099: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE;
1100: l_name hr_all_positions_f.name%TYPE;
1101: l_object_version_number hr_all_positions_f.object_version_number%TYPE;
1102: l_dpf_deployment_factor_id per_deployment_factors.deployment_factor_id%type;
1103: l_dpf_object_version_number per_deployment_factors.object_version_number%type;
1104: l_warning boolean;
1105: l_deployment_factor_id per_deployment_factors.deployment_factor_id%TYPE;
1106: l_position_extra_info_id per_position_extra_info.position_extra_info_id%TYPE;

Line 1103: l_dpf_object_version_number per_deployment_factors.object_version_number%type;

1099: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE;
1100: l_name hr_all_positions_f.name%TYPE;
1101: l_object_version_number hr_all_positions_f.object_version_number%TYPE;
1102: l_dpf_deployment_factor_id per_deployment_factors.deployment_factor_id%type;
1103: l_dpf_object_version_number per_deployment_factors.object_version_number%type;
1104: l_warning boolean;
1105: l_deployment_factor_id per_deployment_factors.deployment_factor_id%TYPE;
1106: l_position_extra_info_id per_position_extra_info.position_extra_info_id%TYPE;
1107: p_position_id hr_all_positions_f.position_id%TYPE;

Line 1105: l_deployment_factor_id per_deployment_factors.deployment_factor_id%TYPE;

1101: l_object_version_number hr_all_positions_f.object_version_number%TYPE;
1102: l_dpf_deployment_factor_id per_deployment_factors.deployment_factor_id%type;
1103: l_dpf_object_version_number per_deployment_factors.object_version_number%type;
1104: l_warning boolean;
1105: l_deployment_factor_id per_deployment_factors.deployment_factor_id%TYPE;
1106: l_position_extra_info_id per_position_extra_info.position_extra_info_id%TYPE;
1107: p_position_id hr_all_positions_f.position_id%TYPE;
1108: p_effective_start_date hr_all_positions_f.effective_start_date%TYPE;
1109: l_pei_position_extra_info_id per_position_extra_info.position_extra_info_id%type;

Line 1158: from per_deployment_factors

1154: and ppei.position_extra_info_id = pps.position_extra_info_id);
1155:
1156: cursor c4 (p_position_id in hr_all_positions_f.position_id%TYPE)is
1157: select deployment_factor_id,object_version_number
1158: from per_deployment_factors
1159: where position_id = p_position_id;
1160:
1161: CURSOR c5 (p_position_id in hr_all_positions_f.position_id%TYPE,
1162: p_information_type in per_position_extra_info.information_type%type,

Line 1785: -- TABLE : per_deployment_factors

1781: END IF; -- api call positions table
1782:
1783:
1784: --
1785: -- TABLE : per_deployment_factors
1786: -- In deployment factors , we will pass only the position_id as deployment
1787: -- is for a position_id OR person_id OR job_id
1788: -- Business Rule in per_deployment_factors :
1789: -- For position_id following fileds are NULL

Line 1788: -- Business Rule in per_deployment_factors :

1784: --
1785: -- TABLE : per_deployment_factors
1786: -- In deployment factors , we will pass only the position_id as deployment
1787: -- is for a position_id OR person_id OR job_id
1788: -- Business Rule in per_deployment_factors :
1789: -- For position_id following fileds are NULL
1790: -- VISIT_INTERNATIONALLY, COMMENTS , EARLIEST_AVAILABLE_DATE
1791: --
1792:

Line 1930: END IF; -- api call per_deployment_factors

1926: ,p_attribute_category => l_dpf_df.attribute_category
1927: );
1928:
1929: --
1930: END IF; -- api call per_deployment_factors
1931:
1932:
1933: --
1934: -- create/update the per_position_extra_info