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.GHR_PROCESS_SF52 dependencies on DUAL

Line 18: Procedure Dual_Action_SF52(p_sf52_data in out nocopy ghr_pa_requests%rowtype,

14:
15: Procedure Single_Action_SF52(p_sf52_data in out nocopy ghr_pa_requests%rowtype,
16: p_process_type in varchar2 default 'CURRENT',
17: p_capped_other_pay in number default null);
18: Procedure Dual_Action_SF52(p_sf52_data in out nocopy ghr_pa_requests%rowtype,
19: p_process_type in varchar2 default 'CURRENT');
20:
21: procedure create_ghr_errorlog(
22: p_program_name in ghr_process_log.program_name%type,

Line 119: -- dual Action

115: p_process_type => p_process_type,
116: p_capped_other_pay => p_capped_other_pay);
117: elsif p_sf52_data.first_noa_code is not null and
118: p_sf52_data.second_noa_code is not null then
119: -- dual Action
120: dual_action_sf52 ( p_sf52_data,
121: p_process_type => p_process_type);
122: elsif p_sf52_data.first_noa_code is not null and
123: p_sf52_data.second_noa_code is null then

Line 120: dual_action_sf52 ( p_sf52_data,

116: p_capped_other_pay => p_capped_other_pay);
117: elsif p_sf52_data.first_noa_code is not null and
118: p_sf52_data.second_noa_code is not null then
119: -- dual Action
120: dual_action_sf52 ( p_sf52_data,
121: p_process_type => p_process_type);
122: elsif p_sf52_data.first_noa_code is not null and
123: p_sf52_data.second_noa_code is null then
124: -- Single action

Line 320: -- |--------------------------< dual_action_sf52>-----------------------------|

316: RAISE;
317:
318: End Single_Action_SF52;
319:
320: -- |--------------------------< dual_action_sf52>-----------------------------|
321: -- Description:
322: -- This procedure handles the case of a dual action.
323: -- Pre-Requisities:
324: -- None.

Line 322: -- This procedure handles the case of a dual action.

318: End Single_Action_SF52;
319:
320: -- |--------------------------< dual_action_sf52>-----------------------------|
321: -- Description:
322: -- This procedure handles the case of a dual action.
323: -- Pre-Requisities:
324: -- None.
325: -- In Parameters:
326: -- p_sf52_data -> ghr_pa_requests record of the sf52.

Line 337: Procedure Dual_Action_SF52( p_sf52_data in out nocopy ghr_pa_requests%rowtype,

333: -- Access Status:
334: -- Internal Development Use Only.
335: -- ---------------------------------------------------------------------------
336:
337: Procedure Dual_Action_SF52( p_sf52_data in out nocopy ghr_pa_requests%rowtype,
338: p_process_type in varchar2 default 'CURRENT') is
339:
340: l_today date:=sysdate;
341: l_sf52_data ghr_pa_requests%rowtype;

Line 348: l_proc varchar2(30):='dual_action_sf52';

344: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
345: l_shadow_data ghr_pa_request_shadow%rowtype;
346: l_session_var ghr_history_api.g_session_var_type;
347: l_result varchar2(30);
348: l_proc varchar2(30):='dual_action_sf52';
349: l_new_assignment_id per_all_assignments_f.assignment_id%type;
350: l_capped_other_pay number := hr_api.g_number;
351:
352: Begin

Line 402: -- In case of dual action we may want to derive from, to column values

398: assign_new_rg( p_action_num => 1,
399: p_pa_req => l_sf52_data);
400:
401: if (p_sf52_data.first_noa_code = 893) then
402: -- In case of dual action we may want to derive from, to column values
403: -- Will be implemented once we have the business rules requirement.
404: -- generate_from_to_colm( l_sf52_data);
405: derive_to_columns(p_sf52_data => l_sf52_data);
406: end if;

Line 421: savepoint dual_Action_sf52;

417: p_agency_ei => TRUE,
418: p_sf52_ei_data => l_agency_ei_data,
419: p_result => l_result);
420: -- issue savepoint
421: savepoint dual_Action_sf52;
422: -- Check if atleast the min. required items exist in the pa_request
423: ghr_sf52_validn_pkg.prelim_req_chk_for_update_hr
424: (p_pa_request_rec => p_sf52_data
425: );

Line 486: rollback to dual_action_sf52;

482: p_capped_other_pay => l_capped_other_pay);
483:
484: hr_utility.set_location( l_proc , 60);
485: if l_session_var.date_effective > l_today then
486: rollback to dual_action_sf52;
487: else
488: hr_utility.set_location( l_proc , 60);
489: ghr_sf52_post_update.Post_sf52_process(
490: p_pa_request_id => p_sf52_data.pa_request_id,

Line 627: -- 1) If this the second or first action of a dual action.

623: -- |--------------------------< assign_new_rg>--------------------------------|
624: -- Description:
625: -- This procedure nulls out or populates the unneeded columns in p_pa_req according to the
626: -- following two criteria:
627: -- 1) If this the second or first action of a dual action.
628: -- 2) Which fields are in pa_data_fields for this noa.
629: -- If p_action_num is 2 (We are building this from the second noa of a dual action),
630: -- then copy all second noa columns to the first noa columns and null out
631: -- the second noa columns.

Line 629: -- If p_action_num is 2 (We are building this from the second noa of a dual action),

625: -- This procedure nulls out or populates the unneeded columns in p_pa_req according to the
626: -- following two criteria:
627: -- 1) If this the second or first action of a dual action.
628: -- 2) Which fields are in pa_data_fields for this noa.
629: -- If p_action_num is 2 (We are building this from the second noa of a dual action),
630: -- then copy all second noa columns to the first noa columns and null out
631: -- the second noa columns.
632: -- Then, for each of the fields, copy them to the pa_request record we are building
633: -- according to the criteria listed in the function (Some fields are copied regardless

Line 673: CURSOR get_dual_family( p_first_noa_id in ghr_dual_actions.first_noa_id%type,

669: CONNECT BY pa_request_id = prior altered_pa_request_id
670: START WITH pa_request_id = cp_pa_request_id)
671: AND ghrpah_1.nature_of_action_id = cp_noa_id;
672:
673: CURSOR get_dual_family( p_first_noa_id in ghr_dual_actions.first_noa_id%type,
674: p_second_noa_id in ghr_dual_actions.second_noa_id%type) IS
675: SELECT noa_family_code
676: FROM ghr_dual_actions
677: WHERE first_noa_id = p_first_noa_id

Line 674: p_second_noa_id in ghr_dual_actions.second_noa_id%type) IS

670: START WITH pa_request_id = cp_pa_request_id)
671: AND ghrpah_1.nature_of_action_id = cp_noa_id;
672:
673: CURSOR get_dual_family( p_first_noa_id in ghr_dual_actions.first_noa_id%type,
674: p_second_noa_id in ghr_dual_actions.second_noa_id%type) IS
675: SELECT noa_family_code
676: FROM ghr_dual_actions
677: WHERE first_noa_id = p_first_noa_id
678: AND second_noa_id = p_second_noa_id;

Line 676: FROM ghr_dual_actions

672:
673: CURSOR get_dual_family( p_first_noa_id in ghr_dual_actions.first_noa_id%type,
674: p_second_noa_id in ghr_dual_actions.second_noa_id%type) IS
675: SELECT noa_family_code
676: FROM ghr_dual_actions
677: WHERE first_noa_id = p_first_noa_id
678: AND second_noa_id = p_second_noa_id;
679: CURSOR get_dual_action( p_noa_family_code in ghr_dual_actions.noa_family_code%type,
680: p_form_field_name in ghr_dual_actions.noa_family_code%type) IS

Line 679: CURSOR get_dual_action( p_noa_family_code in ghr_dual_actions.noa_family_code%type,

675: SELECT noa_family_code
676: FROM ghr_dual_actions
677: WHERE first_noa_id = p_first_noa_id
678: AND second_noa_id = p_second_noa_id;
679: CURSOR get_dual_action( p_noa_family_code in ghr_dual_actions.noa_family_code%type,
680: p_form_field_name in ghr_dual_actions.noa_family_code%type) IS
681: SELECT *
682: FROM ghr_dual_proc_methods
683: WHERE LOWER(noa_family_code) = LOWER(p_noa_family_code)

Line 680: p_form_field_name in ghr_dual_actions.noa_family_code%type) IS

676: FROM ghr_dual_actions
677: WHERE first_noa_id = p_first_noa_id
678: AND second_noa_id = p_second_noa_id;
679: CURSOR get_dual_action( p_noa_family_code in ghr_dual_actions.noa_family_code%type,
680: p_form_field_name in ghr_dual_actions.noa_family_code%type) IS
681: SELECT *
682: FROM ghr_dual_proc_methods
683: WHERE LOWER(noa_family_code) = LOWER(p_noa_family_code)
684: AND LOWER(form_field_name) = LOWER(p_form_field_name);

Line 682: FROM ghr_dual_proc_methods

678: AND second_noa_id = p_second_noa_id;
679: CURSOR get_dual_action( p_noa_family_code in ghr_dual_actions.noa_family_code%type,
680: p_form_field_name in ghr_dual_actions.noa_family_code%type) IS
681: SELECT *
682: FROM ghr_dual_proc_methods
683: WHERE LOWER(noa_family_code) = LOWER(p_noa_family_code)
684: AND LOWER(form_field_name) = LOWER(p_form_field_name);
685: TYPE fld_names_typ is TABLE of fields_type
686: INDEX BY BINARY_INTEGER;

Line 699: l_noa_family_code ghr_dual_actions.noa_family_code%type := null;

695: l_non_from_pa_req ghr_pa_requests%rowtype;
696: l_correction boolean:= null;
697: l_pa_req_ref ghr_pa_requests%rowtype;
698: l_pa_req_ref2 ghr_pa_requests%rowtype;
699: l_noa_family_code ghr_dual_actions.noa_family_code%type := null;
700: tmp_varchar varchar2(150);
701:
702: l_proc varchar2(30):='assign_new_rg';
703:

Line 1510: l_dual_actions ghr_dual_proc_methods%rowtype;

1506: l_count2 number :=0;
1507: l_from_to varchar2(1) ;
1508: l_field_name varchar2(150);
1509: l_to_field_name varchar2(150);
1510: l_dual_actions ghr_dual_proc_methods%rowtype;
1511: l_session_var ghr_history_api.g_session_var_type;
1512: l_pa_history_id ghr_pa_history.pa_history_id%type;
1513: l_to_field varchar2(2000);
1514: l_proc varchar2(30):='copy_to_new_rg_shared';

Line 1584: open get_dual_family( p_first_noa_id => p_pa_req.first_noa_id,

1580: else
1581: -- non-WGI first action.
1582: -- here's the handling for the new table:
1583: if (l_noa_family_code is null) then
1584: open get_dual_family( p_first_noa_id => p_pa_req.first_noa_id,
1585: p_second_noa_id => p_pa_req.second_noa_id);
1586: fetch get_dual_family into l_noa_family_code;
1587: close get_dual_family;
1588: end if;

Line 1586: fetch get_dual_family into l_noa_family_code;

1582: -- here's the handling for the new table:
1583: if (l_noa_family_code is null) then
1584: open get_dual_family( p_first_noa_id => p_pa_req.first_noa_id,
1585: p_second_noa_id => p_pa_req.second_noa_id);
1586: fetch get_dual_family into l_noa_family_code;
1587: close get_dual_family;
1588: end if;
1589: if (LOWER(SUBSTR(p_field_name,0,3)) = 'to_') then
1590: open get_dual_action( p_noa_family_code => l_noa_family_code,

Line 1587: close get_dual_family;

1583: if (l_noa_family_code is null) then
1584: open get_dual_family( p_first_noa_id => p_pa_req.first_noa_id,
1585: p_second_noa_id => p_pa_req.second_noa_id);
1586: fetch get_dual_family into l_noa_family_code;
1587: close get_dual_family;
1588: end if;
1589: if (LOWER(SUBSTR(p_field_name,0,3)) = 'to_') then
1590: open get_dual_action( p_noa_family_code => l_noa_family_code,
1591: p_form_field_name => 'TO_INFO');

Line 1590: open get_dual_action( p_noa_family_code => l_noa_family_code,

1586: fetch get_dual_family into l_noa_family_code;
1587: close get_dual_family;
1588: end if;
1589: if (LOWER(SUBSTR(p_field_name,0,3)) = 'to_') then
1590: open get_dual_action( p_noa_family_code => l_noa_family_code,
1591: p_form_field_name => 'TO_INFO');
1592: fetch get_dual_action into l_dual_actions;
1593: if (LOWER(l_dual_actions.first_noa_proc_method) = 'uf') then
1594: -- copy corresponding 'from' value into 'to' value

Line 1592: fetch get_dual_action into l_dual_actions;

1588: end if;
1589: if (LOWER(SUBSTR(p_field_name,0,3)) = 'to_') then
1590: open get_dual_action( p_noa_family_code => l_noa_family_code,
1591: p_form_field_name => 'TO_INFO');
1592: fetch get_dual_action into l_dual_actions;
1593: if (LOWER(l_dual_actions.first_noa_proc_method) = 'uf') then
1594: -- copy corresponding 'from' value into 'to' value
1595: -- Right now, all the calls wil have null in p_fld_nm_copy_from
1596: -- or if p_field_name is 'TO_...' and p_fld_nm_copy_from has a value

Line 1593: if (LOWER(l_dual_actions.first_noa_proc_method) = 'uf') then

1589: if (LOWER(SUBSTR(p_field_name,0,3)) = 'to_') then
1590: open get_dual_action( p_noa_family_code => l_noa_family_code,
1591: p_form_field_name => 'TO_INFO');
1592: fetch get_dual_action into l_dual_actions;
1593: if (LOWER(l_dual_actions.first_noa_proc_method) = 'uf') then
1594: -- copy corresponding 'from' value into 'to' value
1595: -- Right now, all the calls wil have null in p_fld_nm_copy_from
1596: -- or if p_field_name is 'TO_...' and p_fld_nm_copy_from has a value
1597: -- then it will also be 'TO_....'

Line 1602: elsif (LOWER(l_dual_actions.first_noa_proc_method) = 'ue') then

1598: l_field_name := nvl(p_fld_nm_copy_from, p_field_name);
1599: l_to_field_name := REPLACE(l_field_name, 'TO_','FROM_');
1600: p_to_field := get_field_info( p_field_name => l_to_field_name,
1601: p_sf52_data => p_pa_req);
1602: elsif (LOWER(l_dual_actions.first_noa_proc_method) = 'ue') then
1603: NULL;
1604: else
1605: close get_dual_action;
1606: hr_utility.set_message(8301, 'GHR_38414_UNSUPPORTED_ACT_TYP');

Line 1605: close get_dual_action;

1601: p_sf52_data => p_pa_req);
1602: elsif (LOWER(l_dual_actions.first_noa_proc_method) = 'ue') then
1603: NULL;
1604: else
1605: close get_dual_action;
1606: hr_utility.set_message(8301, 'GHR_38414_UNSUPPORTED_ACT_TYP');
1607: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.first_noa_proc_method);
1608: hr_utility.raise_error;
1609: end if;

Line 1607: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.first_noa_proc_method);

1603: NULL;
1604: else
1605: close get_dual_action;
1606: hr_utility.set_message(8301, 'GHR_38414_UNSUPPORTED_ACT_TYP');
1607: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.first_noa_proc_method);
1608: hr_utility.raise_error;
1609: end if;
1610: close get_dual_action;
1611: else

Line 1610: close get_dual_action;

1606: hr_utility.set_message(8301, 'GHR_38414_UNSUPPORTED_ACT_TYP');
1607: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.first_noa_proc_method);
1608: hr_utility.raise_error;
1609: end if;
1610: close get_dual_action;
1611: else
1612: open get_dual_action( p_noa_family_code => l_noa_family_code,
1613: p_form_field_name => p_field_name);
1614: fetch get_dual_action into l_dual_actions;

Line 1612: open get_dual_action( p_noa_family_code => l_noa_family_code,

1608: hr_utility.raise_error;
1609: end if;
1610: close get_dual_action;
1611: else
1612: open get_dual_action( p_noa_family_code => l_noa_family_code,
1613: p_form_field_name => p_field_name);
1614: fetch get_dual_action into l_dual_actions;
1615: if (LOWER(l_dual_actions.first_noa_proc_method) = 'rp') then
1616: if (not l_refresh_called) then

Line 1614: fetch get_dual_action into l_dual_actions;

1610: close get_dual_action;
1611: else
1612: open get_dual_action( p_noa_family_code => l_noa_family_code,
1613: p_form_field_name => p_field_name);
1614: fetch get_dual_action into l_dual_actions;
1615: if (LOWER(l_dual_actions.first_noa_proc_method) = 'rp') then
1616: if (not l_refresh_called) then
1617:
1618: l_pa_req_ref.from_position_id := l_pa_req.from_position_id;

Line 1615: if (LOWER(l_dual_actions.first_noa_proc_method) = 'rp') then

1611: else
1612: open get_dual_action( p_noa_family_code => l_noa_family_code,
1613: p_form_field_name => p_field_name);
1614: fetch get_dual_action into l_dual_actions;
1615: if (LOWER(l_dual_actions.first_noa_proc_method) = 'rp') then
1616: if (not l_refresh_called) then
1617:
1618: l_pa_req_ref.from_position_id := l_pa_req.from_position_id;
1619: -- if this is a return_to_duty first action, then set to_position = from_position

Line 1638: elsif (LOWER(l_dual_actions.first_noa_proc_method) = 'ue') then

1634: l_refresh_called := TRUE;
1635: end if;
1636: p_to_field := get_field_info( p_field_name => nvl(p_fld_nm_copy_from,p_field_name),
1637: p_sf52_data => l_pa_req_ref);
1638: elsif (LOWER(l_dual_actions.first_noa_proc_method) = 'ue') then
1639: -- do nothing, pass it along as is.
1640: null;
1641: else
1642: -- unsupported type. Throw error.

Line 1643: close get_dual_action;

1639: -- do nothing, pass it along as is.
1640: null;
1641: else
1642: -- unsupported type. Throw error.
1643: close get_dual_action;
1644: hr_utility.set_message(8301, 'GHR_38498_UNSUPPORTED_ACT_TYP');
1645: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.first_noa_proc_method);
1646: hr_utility.raise_error;
1647: end if;

Line 1645: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.first_noa_proc_method);

1641: else
1642: -- unsupported type. Throw error.
1643: close get_dual_action;
1644: hr_utility.set_message(8301, 'GHR_38498_UNSUPPORTED_ACT_TYP');
1645: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.first_noa_proc_method);
1646: hr_utility.raise_error;
1647: end if;
1648: close get_dual_action;
1649: end if;

Line 1648: close get_dual_action;

1644: hr_utility.set_message(8301, 'GHR_38498_UNSUPPORTED_ACT_TYP');
1645: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.first_noa_proc_method);
1646: hr_utility.raise_error;
1647: end if;
1648: close get_dual_action;
1649: end if;
1650: end if;
1651: elsif (l_fld_names_tab1(l_count1).process_method_code = 'AP' and
1652: l_fld_names_tab2(l_count2).process_method_code = 'AP') or

Line 1706: -- when processing the second action of a dual action with WGI as the first action,

1702: -- this covers the case where the user can enter data for both actions.
1703: -- i.e. - APUE/UE first action with a APUE/UE second action.
1704: if (p_pa_req.first_noa_code = 893) then
1705: -- this is a WGI first action, and requires special handling of UE/APUE-UE/APUE cases.
1706: -- when processing the second action of a dual action with WGI as the first action,
1707: -- we will always pass the field along as is. The reasons for this are as follows:
1708: -- 1) If the form field is a to field, then it is automatically associated with the second action.
1709: -- 2) Non-to field information, is also passed along as is. The requirement specifies that
1710: -- all information on the form is associated with the second action. The only exception to this

Line 1718: open get_dual_family( p_first_noa_id => p_pa_req.first_noa_id,

1714: else
1715: -- non-WGI first action
1716: -- Here's the functionality to access the new table:
1717: if (l_noa_family_code is null) then
1718: open get_dual_family( p_first_noa_id => p_pa_req.first_noa_id,
1719: p_second_noa_id => p_pa_req.second_noa_id);
1720: fetch get_dual_family into l_noa_family_code;
1721: close get_dual_family;
1722: end if;

Line 1720: fetch get_dual_family into l_noa_family_code;

1716: -- Here's the functionality to access the new table:
1717: if (l_noa_family_code is null) then
1718: open get_dual_family( p_first_noa_id => p_pa_req.first_noa_id,
1719: p_second_noa_id => p_pa_req.second_noa_id);
1720: fetch get_dual_family into l_noa_family_code;
1721: close get_dual_family;
1722: end if;
1723: if (LOWER(SUBSTR(p_field_name,0,3)) = 'to_') then
1724: open get_dual_action( p_noa_family_code => l_noa_family_code,

Line 1721: close get_dual_family;

1717: if (l_noa_family_code is null) then
1718: open get_dual_family( p_first_noa_id => p_pa_req.first_noa_id,
1719: p_second_noa_id => p_pa_req.second_noa_id);
1720: fetch get_dual_family into l_noa_family_code;
1721: close get_dual_family;
1722: end if;
1723: if (LOWER(SUBSTR(p_field_name,0,3)) = 'to_') then
1724: open get_dual_action( p_noa_family_code => l_noa_family_code,
1725: p_form_field_name => 'TO_INFO');

Line 1724: open get_dual_action( p_noa_family_code => l_noa_family_code,

1720: fetch get_dual_family into l_noa_family_code;
1721: close get_dual_family;
1722: end if;
1723: if (LOWER(SUBSTR(p_field_name,0,3)) = 'to_') then
1724: open get_dual_action( p_noa_family_code => l_noa_family_code,
1725: p_form_field_name => 'TO_INFO');
1726: fetch get_dual_action into l_dual_actions;
1727: if (LOWER(l_dual_actions.second_noa_proc_method) = 'ue') then
1728: -- do nothing, pass it along as is.

Line 1726: fetch get_dual_action into l_dual_actions;

1722: end if;
1723: if (LOWER(SUBSTR(p_field_name,0,3)) = 'to_') then
1724: open get_dual_action( p_noa_family_code => l_noa_family_code,
1725: p_form_field_name => 'TO_INFO');
1726: fetch get_dual_action into l_dual_actions;
1727: if (LOWER(l_dual_actions.second_noa_proc_method) = 'ue') then
1728: -- do nothing, pass it along as is.
1729: null;
1730: else

Line 1727: if (LOWER(l_dual_actions.second_noa_proc_method) = 'ue') then

1723: if (LOWER(SUBSTR(p_field_name,0,3)) = 'to_') then
1724: open get_dual_action( p_noa_family_code => l_noa_family_code,
1725: p_form_field_name => 'TO_INFO');
1726: fetch get_dual_action into l_dual_actions;
1727: if (LOWER(l_dual_actions.second_noa_proc_method) = 'ue') then
1728: -- do nothing, pass it along as is.
1729: null;
1730: else
1731: close get_dual_action;

Line 1731: close get_dual_action;

1727: if (LOWER(l_dual_actions.second_noa_proc_method) = 'ue') then
1728: -- do nothing, pass it along as is.
1729: null;
1730: else
1731: close get_dual_action;
1732: hr_utility.set_message(8301, 'GHR_38418_UNSUPPORTED_ACT_TYP');
1733: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.second_noa_proc_method);
1734: hr_utility.raise_error;
1735: end if;

Line 1733: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.second_noa_proc_method);

1729: null;
1730: else
1731: close get_dual_action;
1732: hr_utility.set_message(8301, 'GHR_38418_UNSUPPORTED_ACT_TYP');
1733: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.second_noa_proc_method);
1734: hr_utility.raise_error;
1735: end if;
1736: close get_dual_action;
1737: else

Line 1736: close get_dual_action;

1732: hr_utility.set_message(8301, 'GHR_38418_UNSUPPORTED_ACT_TYP');
1733: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.second_noa_proc_method);
1734: hr_utility.raise_error;
1735: end if;
1736: close get_dual_action;
1737: else
1738: open get_dual_action( p_noa_family_code => l_noa_family_code,
1739: p_form_field_name => p_field_name);
1740: fetch get_dual_action into l_dual_actions;

Line 1738: open get_dual_action( p_noa_family_code => l_noa_family_code,

1734: hr_utility.raise_error;
1735: end if;
1736: close get_dual_action;
1737: else
1738: open get_dual_action( p_noa_family_code => l_noa_family_code,
1739: p_form_field_name => p_field_name);
1740: fetch get_dual_action into l_dual_actions;
1741: if (LOWER(l_dual_actions.second_noa_proc_method) = 'ue' ) then
1742: -- do nothing, pass it along as is.

Line 1740: fetch get_dual_action into l_dual_actions;

1736: close get_dual_action;
1737: else
1738: open get_dual_action( p_noa_family_code => l_noa_family_code,
1739: p_form_field_name => p_field_name);
1740: fetch get_dual_action into l_dual_actions;
1741: if (LOWER(l_dual_actions.second_noa_proc_method) = 'ue' ) then
1742: -- do nothing, pass it along as is.
1743: null;
1744: else

Line 1741: if (LOWER(l_dual_actions.second_noa_proc_method) = 'ue' ) then

1737: else
1738: open get_dual_action( p_noa_family_code => l_noa_family_code,
1739: p_form_field_name => p_field_name);
1740: fetch get_dual_action into l_dual_actions;
1741: if (LOWER(l_dual_actions.second_noa_proc_method) = 'ue' ) then
1742: -- do nothing, pass it along as is.
1743: null;
1744: else
1745: -- unsupported type. Throw error.

Line 1746: close get_dual_action;

1742: -- do nothing, pass it along as is.
1743: null;
1744: else
1745: -- unsupported type. Throw error.
1746: close get_dual_action;
1747: hr_utility.set_message(8301, 'GHR_38418_UNSUPPORTED_ACT_TYP');
1748: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.second_noa_proc_method);
1749: hr_utility.raise_error;
1750: end if;

Line 1748: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.second_noa_proc_method);

1744: else
1745: -- unsupported type. Throw error.
1746: close get_dual_action;
1747: hr_utility.set_message(8301, 'GHR_38418_UNSUPPORTED_ACT_TYP');
1748: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.second_noa_proc_method);
1749: hr_utility.raise_error;
1750: end if;
1751: close get_dual_action;
1752: end if;

Line 1751: close get_dual_action;

1747: hr_utility.set_message(8301, 'GHR_38418_UNSUPPORTED_ACT_TYP');
1748: hr_utility.set_message_token('ACTION_TYPE', l_dual_actions.second_noa_proc_method);
1749: hr_utility.raise_error;
1750: end if;
1751: close get_dual_action;
1752: end if;
1753: end if;
1754: elsif ((l_fld_names_tab1(l_count1).process_method_code = 'UE' or
1755: l_fld_names_tab1(l_count1).process_method_code = 'APUE' or

Line 1759: -- if this is a separation/separation incentive dual

1755: l_fld_names_tab1(l_count1).process_method_code = 'APUE' or
1756: l_fld_names_tab1(l_count1).process_method_code = 'AP' ) and
1757: (l_fld_names_tab2(l_count2).process_method_code = 'AP')) then
1758: if ((LOWER(SUBSTR(p_field_name, 0, 5))) = 'from_') then
1759: -- if this is a separation/separation incentive dual
1760: -- action, then take the from info from the first action as
1761: -- the from info for the second action. This is necessary because
1762: -- the separation first action has no to info.
1763: if ( (p_pa_req.first_noa_code in (302,303,312,317) and

Line 1777: -- dual action is being processed. i.e. - this is not a correction of the dual action.

1773: cp_noa_id => p_pa_req.second_noa_id);
1774: fetch get_root_pa_hist_id into l_pa_history_id;
1775: close get_root_pa_hist_id;
1776: -- if this cursor returned a null, then this means that this if the first time this
1777: -- dual action is being processed. i.e. - this is not a correction of the dual action.
1778: if l_pa_history_id is not null then
1779: -- successfully found the root. Call refresh with this pa_history_id.
1780: l_correction := true;
1781: ghr_history_api.get_g_session_var(l_session_var);

Line 1836: -- dual action is being processed. i.e. - this is not a correction of the dual action.

1832: cp_noa_id => p_pa_req.second_noa_id);
1833: fetch get_root_pa_hist_id into l_pa_history_id;
1834: close get_root_pa_hist_id;
1835: -- if this cursor returned a null, then this means that this if the first time this
1836: -- dual action is being processed. i.e. - this is not a correction of the dual action.
1837: if l_pa_history_id is not null then
1838: -- successfully found the root. Call refresh with this pa_history_id.
1839: l_correction := true;
1840: ghr_history_api.get_g_session_var(l_session_var);

Line 2231: -- if we are correcting the second action of a dual action, then copy all second noa columns into

2227: -- copy_to_new_rg(p_action_num,'CUSTOM_PAY_CALC_FLAG',p_pa_req.custom_pay_calc_flag,l_pa_req.custom_pay_calc_flag);
2228:
2229: if (p_action_num = 2) then
2230: hr_utility.set_location('Correcting second action'|| l_proc, 10);
2231: -- if we are correcting the second action of a dual action, then copy all second noa columns into
2232: -- corresponding first noa columns
2233: copy_2ndNoa_to_1stNoa(l_pa_req);
2234: end if;
2235: -- null out second noa columns

Line 2260: -- the design of always processing both actions of a dual action as if

2256: -- {Start Of Comments}
2257: --
2258: -- Description:
2259: -- Copies second noa columns to first noa columns. This is needed to facilitate
2260: -- the design of always processing both actions of a dual action as if
2261: -- each is the first action (i.e. - we pass it to update to database as if
2262: -- it is the first action, regardless of whether or not it is the first or second
2263: -- action).
2264: --

Line 2616: select userenv('sessionid') sesid from dual;

2612: ***********/
2613:
2614:
2615: Cursor cur_sessionid is
2616: select userenv('sessionid') sesid from dual;
2617:
2618: l_sid number;
2619: ----
2620: ---- Inserted a new procedure sub_proc_futr_sf52.

Line 4614: hr_utility.set_location( l_proc || 'dual action', 7);

4610: hr_utility.set_location('Entering:'|| l_proc, 5);
4611:
4612: -- populate the local table with the form_field_names for this noa.
4613: if (p_2nd_noa_id is not null) then
4614: hr_utility.set_location( l_proc || 'dual action', 7);
4615: FOR curflds_rec in cur_flds2(p_1st_noa_id, p_2nd_noa_id) LOOP
4616: l_column_count := l_column_count + 1;
4617: p_fld_names_tab(l_column_count) := curflds_rec;
4618: END LOOP;

Line 4905: -- record. This is meant to be called for the first action in a dual action where

4901: -- {Start Of Comments}
4902: --
4903: -- Description:
4904: -- This procedure derives the to column values for the given ghr_pa_request
4905: -- record. This is meant to be called for the first action in a dual action where
4906: -- the first action is a WGI.
4907: --
4908: -- Pre-Requisities:
4909: -- None.

Line 5106: -- don't bother with other pay stuff since this never gets used for dual actions where

5102: p_sf52_data.to_locality_adj := l_locality_adj;
5103: p_sf52_data.to_adj_basic_pay := l_adj_basic_pay;
5104: p_sf52_data.to_total_salary := l_total_salary;
5105:
5106: -- don't bother with other pay stuff since this never gets used for dual actions where
5107: -- WGI is the first action (that is the only time this procedure will have been called).
5108: /*
5109: -- Be careful with setting 'other' pay if it is 'NE'
5110: IF get_other_pay_amount_pm <> 'NE' THEN