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_PTX_UTL dependencies on HR_ALL_POSITIONS_F

Line 1078: hr_all_positions_f

1074: This procedure will determine whether it is an update transaction or
1075: a new position transaction and will call the apis to populate the
1076: underlying master tables.
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:

Line 1096: l_position_id hr_all_positions_f.position_id%TYPE;

1092: l_update_mode varchar2(20);
1093: l_dummy varchar2(10);
1094: l_ptx_rec pqh_position_transactions%ROWTYPE;
1095: l_pte_rec pqh_ptx_extra_info%ROWTYPE;
1096: l_position_id hr_all_positions_f.position_id%TYPE;
1097: l_effective_start_date hr_all_positions_f.effective_start_date%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;

Line 1097: l_effective_start_date hr_all_positions_f.effective_start_date%TYPE;

1093: l_dummy varchar2(10);
1094: l_ptx_rec pqh_position_transactions%ROWTYPE;
1095: l_pte_rec pqh_ptx_extra_info%ROWTYPE;
1096: l_position_id hr_all_positions_f.position_id%TYPE;
1097: l_effective_start_date hr_all_positions_f.effective_start_date%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;

Line 1098: l_effective_end_date hr_all_positions_f.effective_end_date%TYPE;

1094: l_ptx_rec pqh_position_transactions%ROWTYPE;
1095: l_pte_rec pqh_ptx_extra_info%ROWTYPE;
1096: l_position_id hr_all_positions_f.position_id%TYPE;
1097: l_effective_start_date hr_all_positions_f.effective_start_date%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;

Line 1099: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE;

1095: l_pte_rec pqh_ptx_extra_info%ROWTYPE;
1096: l_position_id hr_all_positions_f.position_id%TYPE;
1097: l_effective_start_date hr_all_positions_f.effective_start_date%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;

Line 1100: l_name hr_all_positions_f.name%TYPE;

1096: l_position_id hr_all_positions_f.position_id%TYPE;
1097: l_effective_start_date hr_all_positions_f.effective_start_date%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;

Line 1101: l_object_version_number hr_all_positions_f.object_version_number%TYPE;

1097: l_effective_start_date hr_all_positions_f.effective_start_date%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;

Line 1107: p_position_id hr_all_positions_f.position_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;
1110: l_pei_object_version_number per_position_extra_info.object_version_number%type;
1111: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type;

Line 1108: p_effective_start_date hr_all_positions_f.effective_start_date%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;
1110: l_pei_object_version_number per_position_extra_info.object_version_number%type;
1111: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type;
1112: l_return varchar2(30) := 'SUCCESS';

Line 1131: CURSOR c2(p_position_id IN hr_all_positions_f.position_id%TYPE,

1127: select *
1128: from pqh_position_transactions
1129: where position_transaction_id = p_transaction_id;
1130:
1131: CURSOR c2(p_position_id IN hr_all_positions_f.position_id%TYPE,
1132: p_effective_date IN hr_all_positions_f.effective_start_date%TYPE) IS
1133: select effective_start_date, effective_end_date, object_version_number, date_effective, availability_status_id --'X'
1134: from hr_all_positions_f
1135: where position_id = p_position_id

Line 1132: p_effective_date IN hr_all_positions_f.effective_start_date%TYPE) IS

1128: from pqh_position_transactions
1129: where position_transaction_id = p_transaction_id;
1130:
1131: CURSOR c2(p_position_id IN hr_all_positions_f.position_id%TYPE,
1132: p_effective_date IN hr_all_positions_f.effective_start_date%TYPE) IS
1133: select effective_start_date, effective_end_date, object_version_number, date_effective, availability_status_id --'X'
1134: from hr_all_positions_f
1135: where position_id = p_position_id
1136: and p_effective_date

Line 1134: from hr_all_positions_f

1130:
1131: CURSOR c2(p_position_id IN hr_all_positions_f.position_id%TYPE,
1132: p_effective_date IN hr_all_positions_f.effective_start_date%TYPE) IS
1133: select effective_start_date, effective_end_date, object_version_number, date_effective, availability_status_id --'X'
1134: from hr_all_positions_f
1135: where position_id = p_position_id
1136: and p_effective_date
1137: between effective_start_date and effective_end_date ;
1138:

Line 1156: cursor c4 (p_position_id in hr_all_positions_f.position_id%TYPE)is

1152: from pqh_ptx_extra_info ppei
1153: where position_transaction_id = p_transaction_id
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:

Line 1161: CURSOR c5 (p_position_id in hr_all_positions_f.position_id%TYPE,

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,
1163: p_position_extra_info_id in
1164: per_position_extra_info.position_extra_info_id%type) IS
1165: select position_extra_info_id,object_version_number

Line 1263: hr_all_positions_f

1259: /*
1260: Determine if UPDATE mode or CORRECTION mode in case of Update txn type
1261: This is done as follows :
1262: If for the action_date in the PTX table there exists a row in
1263: hr_all_positions_f
1264: table for the same position_id and effective_start_date = action_date
1265: of PTX , it will
1266: be correction , else it will be update
1267: */

Line 1313: -- TABLE : hr_all_positions_f AND per_positions ( Common API )

1309: Depending on the txn type call the respective APIs
1310: */
1311:
1312: --
1313: -- TABLE : hr_all_positions_f AND per_positions ( Common API )
1314: --
1315:
1316: IF l_txn_type = 'C' THEN
1317: hr_utility.set_location('Calling create_dt_position '||l_proc, 15);

Line 3247: CURSOR c5 (p_position_id in hr_all_positions_f.position_id%TYPE,

3243: cursor c_pes(p_txn_job_requirement_id number) is
3244: select *
3245: from pqh_tjr_shadow
3246: where txn_job_requirement_id = p_txn_job_requirement_id;
3247: CURSOR c5 (p_position_id in hr_all_positions_f.position_id%TYPE,
3248: -- p_information_type in per_position_extra_info.information_type%type,
3249: p_job_requirement_id in
3250: per_job_requirements.job_requirement_id%type) IS
3251: select job_requirement_id,object_version_number