APPS.HR_PAY_RATE_SS dependencies on HR_API_TRANSACTION_VALUES

Line 632: | parameter value from the hr_api_transaction_values table

628: /*===============================================================
629: | Procedure: check_gsp_txn
630: | Function: This is called from process_api to check
631: | whether current txn is gsp txn by reading 'p_gsp_dummy_txn_value'
632: | parameter value from the hr_api_transaction_values table
633: |================================================================
634: */
635: PROCEDURE check_gsp_txn
636: (p_transaction_step_id IN hr_api_transaction_steps.transaction_step_id%type

Line 6309: select VARCHAR2_VALUE into l_flow_mode from hr_api_transaction_values where TRANSACTION_STEP_ID = p_transaction_step_id and NAME = 'P_FLOW_MODE';

6305: l_get_defaults_date := ltt_salary_data(1).default_date;
6306: ld_effective_date := to_date(l_effective_date,'RRRR-MM-DD');
6307:
6308: begin
6309: select VARCHAR2_VALUE into l_flow_mode from hr_api_transaction_values where TRANSACTION_STEP_ID = p_transaction_step_id and NAME = 'P_FLOW_MODE';
6310: exception
6311: when no_data_found then
6312: l_flow_mode := null;
6313: end;