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.PAY_BEE_SS dependencies on HR_API_TRANSACTION_STEPS

Line 413: WHERE transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id =l_transaction_id)

409: ---- -- bee_trace('Exception:Others 13'||l_proc);
410:
411: UPDATE hr_api_transaction_values
412: SET varchar2_value ='Unprocessed'
413: WHERE transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id =l_transaction_id)
414: and name = 'P_BATCH_STATUS_FLAG';
415:
416: hr_transaction_api.get_transaction_step_info
417: (p_item_type => p_item_type

Line 763: select transaction_id into l_transaction_id from hr_api_transaction_steps where transaction_step_id in (select TRANSACTION_STEP_ID from hr_api_transaction_values where name='P_BATCH_NAME' and VARCHAR2_VALUE=p_batch_name);

759:
760: function get_transaction_id_batch_name(p_batch_name in varchar2) return number is
761: l_transaction_id number;
762: begin
763: select transaction_id into l_transaction_id from hr_api_transaction_steps where transaction_step_id in (select TRANSACTION_STEP_ID from hr_api_transaction_values where name='P_BATCH_NAME' and VARCHAR2_VALUE=p_batch_name);
764: return l_transaction_id;
765: end get_transaction_id_batch_name;
766:
767: procedure update_delete_flag(p_transaction_id in number,p_name in varchar2) is

Line 772: update hr_api_transaction_values set varchar2_value='Y' where name=p_name and transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=p_transaction_id);

768: --pragma autonomous_transaction;
769: begin
770: -- -- -- bee_trace('Name is '||p_name);
771: -- -- -- bee_trace('Transaction Id is '||p_transaction_id);
772: update hr_api_transaction_values set varchar2_value='Y' where name=p_name and transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=p_transaction_id);
773: --commit;
774: end update_delete_flag;
775:
776:

Line 881: AND TRANSACTION_STEP_ID in (select TRANSACTION_STEP_ID from hr_api_transaction_steps where TRANSACTION_ID=l_transaction_id)

877: where (name like l_temp5
878: or name like l_temp6
879: or name like l_temp7
880: or name like l_temp8)
881: AND TRANSACTION_STEP_ID in (select TRANSACTION_STEP_ID from hr_api_transaction_steps where TRANSACTION_ID=l_transaction_id)
882: group by regexp_replace(substr(name,instr(name,'@')+1), '[A-Z]','')
883: order by regexp_replace(substr(name,instr(name,'@')+1), '[A-Z]','');
884:
885: cursor input_values_cur is

Line 893: from hr_api_transaction_steps

889:
890: begin
891:
892: select transaction_id into l_transaction_id
893: from hr_api_transaction_steps
894: where transaction_step_id = (select transaction_step_id
895: from hr_api_transaction_values
896: where name = 'P_BATCH_NAME'
897: and varchar2_value = p_batch_name);

Line 902: and transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id);

898:
899: select distinct transaction_step_id into l_transaction_step_id
900: from hr_api_transaction_values
901: where name like '%P_EMPLOYEE_NAME%'
902: and transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id);
903:
904: select batch_id into l_batch_id from pay_batch_headers
905: where batch_name = p_batch_name;
906:

Line 944: and transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id); */

940:
941: /* select distinct transaction_step_id into l_transaction_step_id_1
942: from hr_api_transaction_values
943: where name like l_temp9
944: and transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id); */
945:
946:
947:
948: for l_count in 1..15 loop

Line 1112: --WHERE transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id =l_transaction_id)

1108:
1109: --if l_phase_code='P' then
1110: --UPDATE hr_api_transaction_values
1111: --SET varchar2_value ='Processing'
1112: --WHERE transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id =l_transaction_id)
1113: --and name = 'P_BATCH_STATUS_FLAG';
1114: --end if;
1115: while (l_phase_code<>'C')
1116: loop

Line 1147: WHERE transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id =l_transaction_id)

1143:
1144: if l_validation_count=0 then
1145: UPDATE hr_api_transaction_values
1146: SET varchar2_value ='Valid'
1147: WHERE transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id =l_transaction_id)
1148: and name = 'P_BATCH_STATUS_FLAG';
1149: elsif l_validation_count <> 0 then
1150: UPDATE hr_api_transaction_values
1151: SET varchar2_value ='Validation Failed'

Line 1152: WHERE transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id =l_transaction_id)

1148: and name = 'P_BATCH_STATUS_FLAG';
1149: elsif l_validation_count <> 0 then
1150: UPDATE hr_api_transaction_values
1151: SET varchar2_value ='Validation Failed'
1152: WHERE transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id =l_transaction_id)
1153: and name = 'P_BATCH_STATUS_FLAG';
1154: end if;
1155:
1156: -- bee_trace('Deleting batch');

Line 1181: --WHERE transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id =l_transaction_id)

1177: WHERE batch_name =p_batch_name;
1178: --if l_validation_count=0 then
1179: --UPDATE hr_api_transaction_values
1180: --SET varchar2_value ='Valid'
1181: --WHERE transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id =l_transaction_id)
1182: --and name = 'P_BATCH_STATUS_FLAG';
1183: --elsif l_validation_count <> 0 then
1184: --UPDATE hr_api_transaction_values
1185: --SET varchar2_value ='Validation Failed'

Line 1186: --WHERE transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id =l_transaction_id)

1182: --and name = 'P_BATCH_STATUS_FLAG';
1183: --elsif l_validation_count <> 0 then
1184: --UPDATE hr_api_transaction_values
1185: --SET varchar2_value ='Validation Failed'
1186: --WHERE transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id =l_transaction_id)
1187: --and name = 'P_BATCH_STATUS_FLAG';
1188: --end if;
1189:
1190:

Line 1211: WHERE transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id =l_transaction_id)

1207: l_transaction_id := get_transaction_id_batch_name(p_batch_name=>p_batch_name);
1208:
1209: UPDATE hr_api_transaction_values
1210: SET varchar2_value ='Processing'
1211: WHERE transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id =l_transaction_id)
1212: and name = 'P_BATCH_STATUS_FLAG';
1213:
1214: -- -- bee_trace('Entered call validate batch');
1215: l_request_id := fnd_request.submit_request (

Line 1293: AND TRANSACTION_STEP_ID in (select TRANSACTION_STEP_ID from hr_api_transaction_steps where TRANSACTION_ID=l_transaction_id)

1289: or name like 'P_EFFECTIVE_DATE_%'
1290: or name like 'P_COSTING_ID_%'
1291: or name like 'P_ELEMENT_ID_%'
1292: or name like 'P_ASSIGNMENT_NUMBER_%')
1293: AND TRANSACTION_STEP_ID in (select TRANSACTION_STEP_ID from hr_api_transaction_steps where TRANSACTION_ID=l_transaction_id)
1294: group by regexp_replace(name, '[A-Z]','')
1295: order by regexp_replace(name, '[A-Z]','');
1296: cursor input_values_cur is
1297: select input_value_id from pay_input_values_f

Line 1304: from hr_api_transaction_steps

1300:
1301: begin
1302:
1303: select transaction_id into l_transaction_id
1304: from hr_api_transaction_steps
1305: where transaction_step_id = (select transaction_step_id
1306: from hr_api_transaction_values
1307: where name = 'P_BATCH_NAME'
1308: and varchar2_value = p_batch_name);

Line 1314: and transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id);

1310: -- bee_trace('bharath1'||l_transaction_id);
1311: select number_value into l_business_group_id
1312: from hr_api_transaction_values
1313: where name = 'P_BUSINESS_GROUP_ID'
1314: and transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id);
1315:
1316: select distinct transaction_step_id into l_transaction_step_id
1317: from hr_api_transaction_values
1318: where name like 'P_EMPLOYEE_NAME%'

Line 1319: and transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id);

1315:
1316: select distinct transaction_step_id into l_transaction_step_id
1317: from hr_api_transaction_values
1318: where name like 'P_EMPLOYEE_NAME%'
1319: and transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id);
1320:
1321: delete from hr_api_transaction_values where transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id)
1322: and name like 'P_EFFECTIVE_DATE_OPTION';
1323:

Line 1321: delete from hr_api_transaction_values where transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id)

1317: from hr_api_transaction_values
1318: where name like 'P_EMPLOYEE_NAME%'
1319: and transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id);
1320:
1321: delete from hr_api_transaction_values where transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id)
1322: and name like 'P_EFFECTIVE_DATE_OPTION';
1323:
1324: -- bee_trace('bharath2'||l_transaction_step_id);
1325: -- bee_trace('p_batch_name'||p_batch_name);

Line 1356: and transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id);

1352: -- bee_trace('l_temp9'||l_temp9);
1353: select distinct transaction_step_id into l_transaction_step_id_1
1354: from hr_api_transaction_values
1355: where name like '%@%'
1356: and transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id);
1357:
1358: -- bee_trace('l_transaction_step_id_1'||l_transaction_step_id_1);
1359:
1360: for l_count in 1..15 loop

Line 1551: from hr_api_transaction_steps

1547:
1548:
1549:
1550: select transaction_id into l_old_transaction_id
1551: from hr_api_transaction_steps
1552: where transaction_step_id = (select transaction_step_id
1553: from hr_api_transaction_values
1554: where name = 'P_BATCH_NAME'
1555: and varchar2_value = p_batch_name);

Line 1604: update hr_api_transaction_steps set transaction_id=l_transaction_id,item_key=p_item_key

1600: from hr_api_transaction_values
1601: where name = 'P_BATCH_NAME'
1602: and varchar2_value = p_batch_name);
1603:
1604: update hr_api_transaction_steps set transaction_id=l_transaction_id,item_key=p_item_key
1605: where item_type='HRSSA'
1606: and item_key=l_old_item_key
1607: and transaction_id = l_old_transaction_id;
1608:

Line 1635: and transaction_step_id in(select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id );

1631: select count(*) into l_flag
1632: from hr_api_transaction_values
1633: where name = p_assignment_no||'@P_ASSIGNMENT_NUMBER'
1634: and varchar2_value =p_assignment_no
1635: and transaction_step_id in(select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id );
1636:
1637: -- -- bee_trace('l_flag is ='||l_flag);
1638:
1639: if(l_flag>0) then

Line 1645: and transaction_step_id in(select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id );

1641:
1642: select transaction_step_id into l_transaction_step_id from hr_api_transaction_values
1643: where name = p_assignment_no||'@P_ASSIGNMENT_NUMBER'
1644: and varchar2_value =p_assignment_no
1645: and transaction_step_id in(select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id );
1646:
1647: -- -- bee_trace('Transaction step id is '||l_transaction_step_id);
1648:
1649: delete from hr_api_transaction_values

Line 1680: from hr_api_transaction_steps

1676: begin
1677: hr_utility.set_location('Process api',1);
1678: -- bee_trace('Entered process api');
1679: select transaction_id into l_transaction_id
1680: from hr_api_transaction_steps
1681: where transaction_step_id=p_transaction_step_id;
1682:
1683: -- bee_trace('Transaction id is '||l_transaction_id);
1684:

Line 1695: and transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id);

1691:
1692: select varchar2_value into l_batch_name
1693: from hr_api_transaction_values
1694: where name = 'P_BATCH_NAME'
1695: and transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id);
1696:
1697: select number_value into l_business_group_id
1698: from hr_api_transaction_values
1699: where name = 'P_BUSINESS_GROUP_ID'

Line 1700: and transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id);

1696:
1697: select number_value into l_business_group_id
1698: from hr_api_transaction_values
1699: where name = 'P_BUSINESS_GROUP_ID'
1700: and transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id);
1701:
1702: select status into l_status_wf
1703: from hr_api_transactions
1704: where transaction_id=l_transaction_id;

Line 1834: and transaction_step_id in(select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id );

1830:
1831: select count(*) into l_flag
1832: from hr_api_transaction_values
1833: where name = 'P_BATCH_TYPE'
1834: and transaction_step_id in(select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id );
1835:
1836: -- bee_trace('flag val is '||l_flag);
1837: if l_flag=0 then
1838: delete from hr_api_transaction_values

Line 1839: where transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id );

1835:
1836: -- bee_trace('flag val is '||l_flag);
1837: if l_flag=0 then
1838: delete from hr_api_transaction_values
1839: where transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id );
1840:
1841: -- bee_trace('deleted from hr_api_transaction_values');
1842: delete from hr_api_transaction_steps
1843: where transaction_id=l_transaction_id;

Line 1842: delete from hr_api_transaction_steps

1838: delete from hr_api_transaction_values
1839: where transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id );
1840:
1841: -- bee_trace('deleted from hr_api_transaction_values');
1842: delete from hr_api_transaction_steps
1843: where transaction_id=l_transaction_id;
1844:
1845: -- bee_trace('deleted from hr_api_transaction_steps');
1846: delete from hr_api_transactions

Line 1845: -- bee_trace('deleted from hr_api_transaction_steps');

1841: -- bee_trace('deleted from hr_api_transaction_values');
1842: delete from hr_api_transaction_steps
1843: where transaction_id=l_transaction_id;
1844:
1845: -- bee_trace('deleted from hr_api_transaction_steps');
1846: delete from hr_api_transactions
1847: where transaction_id=l_transaction_id;
1848:
1849: -- bee_trace('deleted from hr_api_transactions');