APPS.PQH_SS_HISTORY dependencies on HR_API_TRANSACTION_VALUES

Line 546: from hr_api_transaction_values v

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 );
548: --
549: cursor c_th_value (c_step_id in number) is
550: select transaction_value_id ,

Line 564: from hr_api_transaction_values

560: creation_date ,
561: last_update_date ,
562: last_updated_by ,
563: last_update_login
564: from hr_api_transaction_values
565: where transaction_step_id = c_step_id;
566: --
567: BEGIN
568: -- new code to support the archive api's

Line 778: from hr_api_transaction_values v

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 );
780: --
781: cursor c_ov_value (c_step_id in number) is
782: select transaction_value_id ,

Line 796: from hr_api_transaction_values

792: creation_date ,
793: last_update_date ,
794: last_updated_by ,
795: last_update_login
796: from hr_api_transaction_values
797: where transaction_step_id = c_step_id;
798: --
799: begin
800: for apr in c_ov_apr_h (l_transactionId) loop

Line 1092: from hr_api_transaction_values

1088: creation_date ,
1089: last_update_date ,
1090: last_updated_by ,
1091: last_update_login
1092: from hr_api_transaction_values
1093: where transaction_step_id = r_supStep.transaction_step_id ;
1094: --
1095: hr_utility.set_location('Leaving: copy_value to history', 75);
1096: end loop ; --c_vt_sup_step

Line 1143: delete from hr_api_transaction_values v

1139: BEGIN
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

Line 1199: delete from hr_api_transaction_values

1195: exit; -- exit loop, when no further records are found
1196: --
1197: else
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;

Line 1262: delete from hr_api_transaction_values

1258: --
1259: else
1260: l_step_id := r_supStep.transaction_step_id ;
1261:
1262: delete from hr_api_transaction_values
1263: where transaction_step_id = r_supStep.transaction_step_id;
1264: end if; -- c_sup_step%NOTFOUND
1265:
1266:

Line 1267: insert into hr_api_transaction_values (

1263: where transaction_step_id = r_supStep.transaction_step_id;
1264: end if; -- c_sup_step%NOTFOUND
1265:
1266:
1267: insert into hr_api_transaction_values (
1268: transaction_value_id,
1269: transaction_step_id,
1270: datatype,
1271: name,

Line 1283: select hr_api_transaction_values_s.nextval ,

1279: creation_date,
1280: last_update_date,
1281: last_updated_by,
1282: last_update_login )
1283: select hr_api_transaction_values_s.nextval ,
1284: l_step_id, -- nvl( r_supStep.transaction_step_id, step_history_id) step_history_id,
1285: datatype,
1286: name,
1287: decode(datatype,'VARCHAR2',value),

Line 1313: delete from hr_api_transaction_values

1309: if c_vf_sup_step%NOTFOUND then
1310: exit; -- exit loop, when no further records are found
1311: --
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;