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

Line 34: l_comments varchar2(100) := hr_api.g_varchar2;

30: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
31: l_api_names hr_util_web.g_varchar2_tab_type;
32: l_trans_step_rows NUMBER ;
33: l_proc varchar2(72) := g_package||'create_batch';
34: l_comments varchar2(100) := hr_api.g_varchar2;
35: p_batch_id number;
36: p_item_type varchar2(50) := 'HRSSA';
37: -- p_item_key number;
38: p_actid number :=100;

Line 234: l_comments varchar2(100) := hr_api.g_varchar2;

230: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
231: l_api_names hr_util_web.g_varchar2_tab_type;
232: l_trans_step_rows NUMBER ;
233: l_proc varchar2(72) := g_package||'create_batch_assignment_lines';
234: l_comments varchar2(100) := hr_api.g_varchar2;
235: p_item_type varchar2(50) := 'HRSSA';
236: p_item_key number := g_item_key;
237: p_actid number :=101;
238: -- p_login_person_id number := 125;

Line 291: select count(*) into l_flag from hr_api_transaction_values where name = p_assignment_no||'@P_EMPLOYEE_NAME' and transaction_step_id = l_transaction_step_id;

287:
288:
289: l_count := 0;
290: -- -- -- bee_trace('Entered procedure 123');
291: select count(*) into l_flag from hr_api_transaction_values where name = p_assignment_no||'@P_EMPLOYEE_NAME' and transaction_step_id = l_transaction_step_id;
292:
293: -- -- bee_trace('Entered procedure 123');
294: if (l_flag = 0) then
295: l_count := l_count + 1;

Line 397: l_comments varchar2(100) := hr_api.g_varchar2;

393: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
394: l_api_names hr_util_web.g_varchar2_tab_type;
395: l_trans_step_rows NUMBER ;
396: l_proc varchar2(72) := g_package||'create_batch_element_lines';
397: l_comments varchar2(100) := hr_api.g_varchar2;
398: p_item_type varchar2(50) := 'HRSSA';
399: p_item_key number := g_item_key;
400: p_actid number :=102;
401: -- p_login_person_id number := 125;

Line 411: UPDATE hr_api_transaction_values

407: (p_item_type => p_item_type
408: ,p_item_key => p_item_key);
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:

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 459: select count(*) into l_flag from hr_api_transaction_values where name = 'P_BATCH_TYPE' and transaction_step_id = l_transaction_step_id;

455:
456:
457: l_count := 0;
458:
459: select count(*) into l_flag from hr_api_transaction_values where name = 'P_BATCH_TYPE' and transaction_step_id = l_transaction_step_id;
460:
461: if (l_flag = 0) then
462: ---- -- bee_trace('Exception:Others 000'||l_proc);
463: l_count := l_count + 1;

Line 554: l_comments varchar2(100) := hr_api.g_varchar2;

550: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
551: l_api_names hr_util_web.g_varchar2_tab_type;
552: l_trans_step_rows NUMBER ;
553: l_proc varchar2(200) := g_package||'set_input_values';
554: l_comments varchar2(100) := hr_api.g_varchar2;
555: p_item_type varchar2(50) := 'HRSSA';
556: p_item_key number := g_item_key;
557: p_actid number :=101;
558: -- p_login_person_id number := 125;

Line 655: l_comments varchar2(100) := hr_api.g_varchar2;

651: l_trans_step_ids hr_util_web.g_varchar2_tab_type;
652: l_api_names hr_util_web.g_varchar2_tab_type;
653: l_trans_step_rows NUMBER ;
654: l_proc varchar2(200) := g_package||'set_element_input_values';
655: l_comments varchar2(100) := hr_api.g_varchar2;
656: p_item_type varchar2(50) := 'HRSSA';
657: p_item_key number := g_item_key;
658: p_actid number :=103;
659: -- p_login_person_id number := 125;

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 796: from hr_api_transaction_values

792:
793: select pay_batch_headers_s.nextval into l_batch_id from dual;
794:
795: select transaction_step_id into l_transaction_step_id
796: from hr_api_transaction_values
797: where name = 'P_BATCH_NAME'
798: and varchar2_value = p_batch_name;
799:
800: l_effective_date:=hr_transaction_api.get_date_value

Line 823: update hr_api_transaction_values set number_value=l_batch_id

819:
820: insert into pay_batch_headers(BATCH_ID,BUSINESS_GROUP_ID,BATCH_NAME,batch_status,ACTION_IF_EXISTS,PURGE_AFTER_TRANSFER,REJECT_IF_FUTURE_CHANGES,DATE_EFFECTIVE_CHANGES)
821: values(l_batch_id,p_business_group_id,p_batch_name,'U',l_action_if_exists,l_purge_after_transfer,l_reject_if_future_changes,l_date_effective_changes);
822:
823: update hr_api_transaction_values set number_value=l_batch_id
824: where name='P_BATCH_ID'
825: and transaction_step_id=l_transaction_step_id;
826:
827: commit;

Line 867: select varchar2_value from hr_api_transaction_values

863: l_count number :=1;
864: l_request_id number;
865:
866: cursor asg_cur is
867: select varchar2_value from hr_api_transaction_values
868: where name like '%P_ASSIGNMENT_NUMBER%'
869: and transaction_step_id=l_transaction_step_id;
870:
871: cursor asg_entries_cur is

Line 876: from hr_api_transaction_values

872: select max(decode(substr(name,1,instr(name,'@'))||regexp_replace(substr(name,instr(name,'@')+1),'[0-9]',''),l_temp1, VARCHAR2_VALUE, null)),
873: max(decode(substr(name,1,instr(name,'@'))||regexp_replace(substr(name,instr(name,'@')+1),'[0-9]',''),l_temp2, VARCHAR2_VALUE, null)),
874: max(decode(substr(name,1,instr(name,'@'))||regexp_replace(substr(name,instr(name,'@')+1),'[0-9]',''),l_temp3, DATE_VALUE, null)),
875: max(decode(substr(name,1,instr(name,'@'))||regexp_replace(substr(name,instr(name,'@')+1),'[0-9]',''),l_temp4, VARCHAR2_VALUE, null))
876: from hr_api_transaction_values
877: where (name like l_temp5
878: or name like l_temp6
879: or name like l_temp7
880: or name like l_temp8)

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 895: from hr_api_transaction_values

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);
898:
899: select distinct transaction_step_id into l_transaction_step_id

Line 900: from hr_api_transaction_values

896: where name = 'P_BATCH_NAME'
897: and varchar2_value = p_batch_name);
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

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 942: from hr_api_transaction_values

938:
939: l_assignment_id:=hr_transaction_api.get_number_value(p_transaction_step_id => l_transaction_step_id,p_name=>l_temp10);
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:

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 1110: --UPDATE hr_api_transaction_values

1106:
1107: -- bee_trace('Initial phase cose is '||l_phase_code);
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;

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 1145: UPDATE hr_api_transaction_values

1141: l_validation_count := l_validation_count+1;
1142: end loop;
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

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 1150: 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'
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;

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 1179: --UPDATE hr_api_transaction_values

1175: SELECT batch_status into l_batch_status
1176: FROM pay_batch_headers
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

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 1184: --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'
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;

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 1209: UPDATE hr_api_transaction_values

1205:
1206: begin
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:

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 1274: select varchar2_value from hr_api_transaction_values

1270:
1271:
1272:
1273: cursor asg_cur is
1274: select varchar2_value from hr_api_transaction_values
1275: where name like '%P_ASSIGNMENT_NUMBER%'
1276: and transaction_step_id=l_transaction_step_id;
1277:
1278:

Line 1286: from hr_api_transaction_values

1282: max(decode(substr(name,1,17),'P_EFFECTIVE_DATE_', DATE_VALUE, null)),
1283: max(decode(substr(name,1,13),'P_COSTING_ID_', VARCHAR2_VALUE, null)),
1284: max(decode(substr(name,1,13),'P_ELEMENT_ID_', VARCHAR2_VALUE, null)),
1285: max(decode(substr(name,1,20),'P_ASSIGNMENT_NUMBER_', VARCHAR2_VALUE, null))
1286: from hr_api_transaction_values
1287: where (name like 'P_ELEMENT_NAME_%'
1288: or name like 'P_ELEMENT_TYPE_%'
1289: or name like 'P_EFFECTIVE_DATE_%'
1290: or name like 'P_COSTING_ID_%'

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 1306: from hr_api_transaction_values

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);
1309:
1310: -- bee_trace('bharath1'||l_transaction_id);

Line 1312: from hr_api_transaction_values

1308: and varchar2_value = p_batch_name);
1309:
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

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 1317: 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%'
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)

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 1354: from hr_api_transaction_values

1350: l_temp9 := l_assignment_number||'@'||l_element_type_id||'_%';
1351:
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);

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 1553: from hr_api_transaction_values

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);
1556:
1557:

Line 1559: --from hr_api_transactions

1555: and varchar2_value = p_batch_name);
1556:
1557:
1558: --select CREATOR_PERSON_ID into p_login_person_id
1559: --from hr_api_transactions
1560: --where transaction_id=l_old_transaction_id;
1561:
1562:
1563: -- -- -- bee_trace('item key==' ||p_item_key);

Line 1588: from hr_api_transaction_values

1584:
1585:
1586:
1587: select varchar2_value into l_old_item_key
1588: from hr_api_transaction_values
1589: where name = 'P_ITEM_KEY'
1590: and transaction_step_id = (select transaction_step_id
1591: from hr_api_transaction_values
1592: where name = 'P_BATCH_NAME'

Line 1591: from hr_api_transaction_values

1587: select varchar2_value into l_old_item_key
1588: from hr_api_transaction_values
1589: where name = 'P_ITEM_KEY'
1590: and transaction_step_id = (select transaction_step_id
1591: from hr_api_transaction_values
1592: where name = 'P_BATCH_NAME'
1593: and varchar2_value = p_batch_name);
1594:
1595:

Line 1597: update hr_api_transaction_values set varchar2_value=p_item_key where

1593: and varchar2_value = p_batch_name);
1594:
1595:
1596:
1597: update hr_api_transaction_values set varchar2_value=p_item_key where
1598: name = 'P_ITEM_KEY'
1599: and transaction_step_id = (select transaction_step_id
1600: from hr_api_transaction_values
1601: where name = 'P_BATCH_NAME'

Line 1600: from hr_api_transaction_values

1596:
1597: update hr_api_transaction_values set varchar2_value=p_item_key where
1598: name = 'P_ITEM_KEY'
1599: and transaction_step_id = (select transaction_step_id
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

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 1632: from hr_api_transaction_values

1628: l_transaction_id :=get_transaction_id_batch_name(p_batch_name);
1629: l_temp:=p_assignment_no||'@P%';
1630:
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:

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 1642: select transaction_step_id into l_transaction_step_id from hr_api_transaction_values

1638:
1639: if(l_flag>0) then
1640:
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:

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 1649: delete from hr_api_transaction_values

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
1650: where name like l_temp
1651: and transaction_step_id =l_transaction_step_id;
1652:
1653: commit;

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 1686: from hr_api_transaction_values

1682:
1683: -- bee_trace('Transaction id is '||l_transaction_id);
1684:
1685: select varchar2_value into l_batch_type
1686: from hr_api_transaction_values
1687: where name = 'P_BATCH_TYPE'
1688: and transaction_step_id = p_transaction_step_id;
1689:
1690: -- bee_trace('Batch type is '||l_batch_type);

Line 1693: from hr_api_transaction_values

1689:
1690: -- bee_trace('Batch type is '||l_batch_type);
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

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 1698: 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'
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

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 1703: from hr_api_transactions

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;
1705:
1706: -- bee_trace('Batch name is '||l_batch_name);
1707: select created_by into l_user_id

Line 1708: from hr_api_transactions

1704: where transaction_id=l_transaction_id;
1705:
1706: -- bee_trace('Batch name is '||l_batch_name);
1707: select created_by into l_user_id
1708: from hr_api_transactions
1709: where transaction_id=l_transaction_id;
1710: select responsibility_id into l_resp_id from fnd_user_resp_groups_direct where user_id=l_user_id and rownum=1;
1711: --bee_trace('l_resp_id is '||l_resp_id);
1712: if (FND_GLOBAL.resp_id= -1) then

Line 1832: from hr_api_transaction_values

1828: l_transaction_id :=get_transaction_id_batch_name(p_batch_name);
1829:
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);

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 1838: delete from hr_api_transaction_values

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
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

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 1841: -- bee_trace('deleted from hr_api_transaction_values');

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;
1844:
1845: -- bee_trace('deleted from hr_api_transaction_steps');

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');

Line 1846: delete from hr_api_transactions

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');
1850: end if;

Line 1849: -- bee_trace('deleted from hr_api_transactions');

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');
1850: end if;
1851:
1852:
1853: end delete_batch_on_cancel;