APPS.GHR_MTO_PKG dependencies on GHR_MASS_TRANSFERS

Line 346: from ghr_mass_transfers

342: old_pos_structure_version_id,
343: TO_AGENCY_CODE_SUBELEMENT,
344: NVL(INTERFACE_FLAG,'N') INTERFACE_FLAG,
345: PA_REQUEST_ID
346: from ghr_mass_transfers
347: where mass_transfer_id = p_mass_transfer_id
348: and TRANSFER_TYPE = 'OUT'
349: for update of status nowait;
350:

Line 1458: update ghr_mass_transfers

1454:
1455: if (l_recs_failed = 0 ) then
1456: IF upper(p_action) in ('CREATE','DUMP OUT') THEN
1457: begin
1458: update ghr_mass_transfers
1459: set status = decode(upper(p_action),'CREATE','P',status),
1460: interface_flag = decode(upper(p_action),'DUMP OUT','Y',
1461: interface_flag)
1462: where mass_transfer_id = p_mass_transfer_id;

Line 1473: update ghr_mass_transfers

1469: end if;
1470: ELSE
1471: -- 4215268
1472: IF upper(p_action) = 'DUMP OUT' and nvl(l_recs_failed,0) > 0 and nvl(l_recs_failed,0) < nvl(l_mass_cnt,0) THEN
1473: update ghr_mass_transfers
1474: set status = decode(upper(p_action),'CREATE','P',status),
1475: interface_flag = decode(upper(p_action),'DUMP OUT','Y',
1476: interface_flag)
1477: where mass_transfer_id = p_mass_transfer_id;

Line 1491: update ghr_mass_transfers

1487: -- 4215268
1488: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
1489: p_retcode := 2;
1490: IF upper(p_action) = 'CREATE' THEN
1491: update ghr_mass_transfers
1492: set status = 'E'
1493: where mass_transfer_id = p_mass_transfer_id;
1494: END IF;
1495: -- Bug#4183516/4201876 Added/Modified the message text and message name.

Line 1519: update ghr_mass_transfers

1515: exception
1516: when others then null;
1517: end;
1518: IF upper(p_action) = 'CREATE' THEN
1519: update ghr_mass_transfers
1520: set status = 'E'
1521: where mass_transfer_id = p_mass_transfer_id;
1522: END IF;
1523: HR_UTILITY.SET_LOCATION('Error occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),10);

Line 1544: update ghr_mass_transfers

1540: exception
1541: when others then null;
1542: end;
1543: IF upper(p_action) = 'CREATE' THEN
1544: update ghr_mass_transfers
1545: set status = 'E'
1546: where mass_transfer_id = p_mass_transfer_id;
1547: END IF;
1548: HR_UTILITY.SET_LOCATION('Error (Others2) occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),30);

Line 2191: l_mtfr_id GHR_MASS_TRANSFERS.mass_transfer_id%type;

2187: l_eff_date date;
2188:
2189: l_sel_flag varchar2(5);
2190: l_comments varchar2(4000);
2191: l_mtfr_id GHR_MASS_TRANSFERS.mass_transfer_id%type;
2192: begin
2193: g_proc := 'get_extra_info_comments';
2194:
2195: -- NOCOPY Changes

Line 2568: FROM GHR_MASS_TRANSFERS

2564: function get_mto_name(p_mto_id in number) return varchar2 is
2565:
2566: CURSOR mto_cur is
2567: SELECT NAME
2568: FROM GHR_MASS_TRANSFERS
2569: WHERE MASS_TRANSFER_ID = p_mto_id;
2570:
2571: l_mto_name varchar2(150);
2572: l_proc varchar2(72) := g_package || '.get_mre_name';