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 933: FROM hr_api_transaction_steps

929: ,p_apiName IN VARCHAR2 ) RETURN VARCHAR2 IS
930: --
931: CURSOR cur_txnStep IS
932: SELECT transaction_step_id
933: FROM hr_api_transaction_steps
934: WHERE item_type = p_itemType
935: AND item_key = p_itemKey
936: AND api_name = p_apiName;
937: --

Line 955: FROM hr_api_transaction_steps

951: p_transaction_id IN NUMBER ) RETURN VARCHAR2 IS
952: --
953: CURSOR csr_transaction_step_exist IS
954: SELECT 'Y'
955: FROM hr_api_transaction_steps
956: WHERE transaction_id = p_transaction_id;
957: --
958: l_transaction_step_exist VARCHAR2(5) := 'N';
959: --