APPS.PQH_SS_UTILITY dependencies on HR_API_TRANSACTION_STEPS

Line 389: FROM hr_api_transaction_steps

385: l_effDate DATE;
386: --
387: CURSOR cur_txnStep (c_txnId NUMBER ) IS
388: SELECT transaction_step_id
389: FROM hr_api_transaction_steps
390: WHERE transaction_id = c_txnId
391: AND api_name IN ( 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API', 'HR_SUPERVISOR_SS.PROCESS_API');
392: --
393: BEGIN

Line 448: FROM hr_api_transaction_steps ts

444: ,p_assignId IN NUMBER ) RETURN VARCHAR2 IS
445: --
446: CURSOR cur_txn IS
447: SELECT 'X'
448: FROM hr_api_transaction_steps ts
449: WHERE ts.transaction_id = p_txnId
450: AND ts.api_name IN ('HR_SUPERVISOR_SS.PROCESS_API',
451: 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API',
452: 'HR_PAY_RATE_SS.PROCESS_API',

Line 457: FROM hr_api_transactions t, hr_api_transaction_steps ts

453: 'HR_TERMINATION_SS.PROCESS_API' );
454: --
455: CURSOR cur_pnd IS
456: SELECT 'X'
457: FROM hr_api_transactions t, hr_api_transaction_steps ts
458: WHERE t.transaction_id = ts.transaction_id
459: AND ts.item_type = p_itemType
460: AND ts.update_person_id = p_personId
461: AND t.status in ('Y','YS','RO','ROS') -- not considering C, RI, RIS as they are with init

Line 613: FROM hr_api_transaction_steps

609: SET varchar2_value = l_mode
610: WHERE name = 'P_DATETRACK_UPDATE_MODE'
611: AND transaction_step_id = (
612: SELECT transaction_step_id
613: FROM hr_api_transaction_steps
614: WHERE transaction_id = p_txnId
615: AND api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API' )
616: AND varchar2_value <> l_mode;
617:

Line 801: FROM hr_api_transaction_steps

797: WHERE att.column_name = name
798: AND att.master_table_route_id = ptr.table_route_id
799: AND ptr.table_alias IN ('PQH_SS_ASG_PG1','PQH_SS_OTHER_EMP_INFO_PG1')
800: AND atv.transaction_step_id IN ( SELECT transaction_step_id
801: FROM hr_api_transaction_steps
802: WHERE transaction_id = p_txnId
803: AND api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API');
804:
805: CURSOR csr_assignment IS

Line 820: FROM hr_api_transaction_steps

816: AND name = p_param_name;
817: --
818: CURSOR cur_txnStep (c_txnId NUMBER ) IS
819: SELECT transaction_step_id
820: FROM hr_api_transaction_steps
821: WHERE transaction_id = c_txnId
822: AND api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API';
823: --
824: l_ovn VARCHAR2(15);

Line 906: FROM hr_api_transaction_steps

902: ,p_apiName IN VARCHAR2 ) RETURN VARCHAR2 IS
903: --
904: CURSOR cur_txnStep IS
905: SELECT transaction_step_id
906: FROM hr_api_transaction_steps
907: WHERE item_type = p_itemType
908: AND item_key = p_itemKey
909: AND api_name = p_apiName;
910: --

Line 928: FROM hr_api_transaction_steps

924: p_transaction_id IN NUMBER ) RETURN VARCHAR2 IS
925: --
926: CURSOR csr_transaction_step_exist IS
927: SELECT 'Y'
928: FROM hr_api_transaction_steps
929: WHERE transaction_id = p_transaction_id;
930: --
931: l_transaction_step_exist VARCHAR2(5) := 'N';
932: --