APPS.PQH_SS_HISTORY dependencies on HR_API_TRANSACTION_STEPS

Line 543: from hr_api_transaction_steps s

539: and approval_history_id > 0 ;
540: --
541: cursor c_th_step (c_txn_id in number) is
542: select *
543: from hr_api_transaction_steps s
544: where transaction_id = c_txn_id
545: and exists (select null
546: from hr_api_transaction_values v
547: where v.transaction_step_id = s.transaction_step_id );

Line 775: from hr_api_transaction_steps s

771: where transaction_history_id = c_txn_id ;
772: --
773: cursor c_ov_step (c_txn_id in number) is
774: select *
775: from hr_api_transaction_steps s
776: where transaction_id = c_txn_id
777: and exists (select null
778: from hr_api_transaction_values v
779: where v.transaction_step_id = s.transaction_step_id );

Line 954: FROM hr_api_transaction_steps

950: --
951: --
952: CURSOR c_vt_sup_step(c_txn_id in number, c_api_name in varchar2 default null) IS
953: SELECT *
954: FROM hr_api_transaction_steps
955: WHERE transaction_id = c_txn_id
956: AND ( (c_api_name is null AND api_name in (
957: 'HR_PAY_RATE_SS.PROCESS_API'
958: ,'HR_SUPERVISOR_SS.PROCESS_API'

Line 1105: FROM hr_api_transaction_steps

1101: p_txnId IN NUMBER ) IS
1102: --
1103: CURSOR c_vf_sup_step(c_txn_id in number, c_api_name in varchar2 default null) IS
1104: SELECT *
1105: FROM hr_api_transaction_steps
1106: WHERE transaction_id = c_txn_id
1107: AND ( (c_api_name is null AND api_name in (
1108: 'HR_SUPERVISOR_SS.PROCESS_API'
1109: ,'HR_PROCESS_SIT_SS.PROCESS_API'

Line 1144: where v.transaction_step_id in (select s.transaction_step_id from hr_api_transaction_steps s

1140: --
1141: -- Remove values and step which are not part of history.
1142: --
1143: delete from hr_api_transaction_values v
1144: where v.transaction_step_id in (select s.transaction_step_id from hr_api_transaction_steps s
1145: where s.transaction_id = p_txnId
1146: and s.api_name not in (select h.api_name from pqh_ss_step_history h
1147: where transaction_history_id = p_txnId
1148: and approval_history_id = -1 )

Line 1160: delete from hr_api_transaction_steps s

1156: ,'HR_PROCESS_CONTACT_SS.PROCESS_API'
1157: ,'HR_PROCESS_PERSON_SS.PROCESS_API'
1158: ,'HR_COMP_PROFILE_SS.PROCESS_API' ));
1159: --
1160: delete from hr_api_transaction_steps s
1161: where s.transaction_id = p_txnId
1162: and s.api_name not in (select h.api_name from pqh_ss_step_history h
1163: where transaction_history_id = p_txnId
1164: and approval_history_id = -1 )

Line 1202: delete from hr_api_transaction_steps

1198: --
1199: delete from hr_api_transaction_values
1200: where transaction_step_id = r_supStep.transaction_step_id;
1201: --
1202: delete from hr_api_transaction_steps
1203: where transaction_step_id = r_supStep.transaction_step_id;
1204: --
1205: end if; -- c_vf_sup_step%FOUND
1206: --

Line 1223: select hr_api_transaction_steps_s.nextval

1219: fetch c_vf_sup_step INTO r_supStep;
1220: --
1221: if c_vf_sup_step%NOTFOUND then
1222: --
1223: select hr_api_transaction_steps_s.nextval
1224: into l_step_id
1225: from dual;
1226:
1227: insert into hr_api_transaction_steps(

Line 1227: insert into hr_api_transaction_steps(

1223: select hr_api_transaction_steps_s.nextval
1224: into l_step_id
1225: from dual;
1226:
1227: insert into hr_api_transaction_steps(
1228: transaction_step_id ,
1229: transaction_id ,
1230: api_name ,
1231: api_display_name ,

Line 1316: delete from hr_api_transaction_steps

1312: else
1313: delete from hr_api_transaction_values
1314: where transaction_step_id = r_supStep.transaction_step_id;
1315: --
1316: delete from hr_api_transaction_steps
1317: where transaction_step_id = r_supStep.transaction_step_id;
1318: --
1319: end if; -- c_vf_sup_step%FOUND
1320: --