APPS.GHR_MTO_PKG dependencies on GHR_MASS_TRANSFERS

Line 373: from ghr_mass_transfers

369: old_pos_structure_version_id,
370: TO_AGENCY_CODE_SUBELEMENT,
371: NVL(INTERFACE_FLAG,'N') INTERFACE_FLAG,
372: PA_REQUEST_ID
373: from ghr_mass_transfers
374: where mass_transfer_id = p_mass_transfer_id
375: and TRANSFER_TYPE = 'OUT'
376: for update of status nowait;
377:

Line 1563: update ghr_mass_transfers

1559:
1560: if (l_recs_failed = 0 ) then
1561: IF upper(p_action) in ('CREATE','DUMP OUT') THEN
1562: begin
1563: update ghr_mass_transfers
1564: set status = decode(upper(p_action),'CREATE','P',status),
1565: interface_flag = decode(upper(p_action),'DUMP OUT','Y',
1566: interface_flag)
1567: where mass_transfer_id = p_mass_transfer_id;

Line 1578: update ghr_mass_transfers

1574: end if;
1575: ELSE
1576: -- 4215268
1577: 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
1578: update ghr_mass_transfers
1579: set status = decode(upper(p_action),'CREATE','P',status),
1580: interface_flag = decode(upper(p_action),'DUMP OUT','Y',
1581: interface_flag)
1582: where mass_transfer_id = p_mass_transfer_id;

Line 1596: update ghr_mass_transfers

1592: -- 4215268
1593: p_errbuf := 'Error in '||l_proc || ' Details in GHR_PROCESS_LOG';
1594: p_retcode := 2;
1595: IF upper(p_action) = 'CREATE' THEN
1596: update ghr_mass_transfers
1597: set status = 'E'
1598: where mass_transfer_id = p_mass_transfer_id;
1599: END IF;
1600: -- Bug#4183516/4201876 Added/Modified the message text and message name.

Line 1624: update ghr_mass_transfers

1620: exception
1621: when others then null;
1622: end;
1623: IF upper(p_action) = 'CREATE' THEN
1624: update ghr_mass_transfers
1625: set status = 'E'
1626: where mass_transfer_id = p_mass_transfer_id;
1627: END IF;
1628: HR_UTILITY.SET_LOCATION('Error occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),10);

Line 1649: update ghr_mass_transfers

1645: exception
1646: when others then null;
1647: end;
1648: IF upper(p_action) = 'CREATE' THEN
1649: update ghr_mass_transfers
1650: set status = 'E'
1651: where mass_transfer_id = p_mass_transfer_id;
1652: END IF;
1653: HR_UTILITY.SET_LOCATION('Error (Others2) occurred in '||l_proc||' Sql error '||sqlerrm(sqlcode),30);

Line 2298: l_mtfr_id GHR_MASS_TRANSFERS.mass_transfer_id%type;

2294: l_eff_date date;
2295:
2296: l_sel_flag varchar2(5);
2297: l_comments varchar2(4000);
2298: l_mtfr_id GHR_MASS_TRANSFERS.mass_transfer_id%type;
2299: begin
2300: g_proc := 'get_extra_info_comments';
2301:
2302: -- NOCOPY Changes

Line 2681: FROM GHR_MASS_TRANSFERS

2677: function get_mto_name(p_mto_id in number) return varchar2 is
2678:
2679: CURSOR mto_cur is
2680: SELECT NAME
2681: FROM GHR_MASS_TRANSFERS
2682: WHERE MASS_TRANSFER_ID = p_mto_id;
2683:
2684: l_mto_name varchar2(150);
2685: l_proc varchar2(72) := g_package || '.get_mre_name';