APPS.HR_PUMP_UTILS dependencies on HR_PUMP_BATCH_LINE_USER_KEYS

Line 85: insert into hr_pump_batch_line_user_keys (

81: raise value_error;
82: end if;
83:
84: -- Insert the values.
85: insert into hr_pump_batch_line_user_keys (
86: user_key_id,
87: batch_line_id,
88: user_key_value,
89: unique_key_id)

Line 90: values (hr_pump_batch_line_user_keys_s.nextval,

86: user_key_id,
87: batch_line_id,
88: user_key_value,
89: unique_key_id)
90: values (hr_pump_batch_line_user_keys_s.nextval,
91: null,
92: p_user_key_value,
93: p_unique_key_id);
94: end add_user_key;

Line 102: l_user_key_value hr_pump_batch_line_user_keys.user_key_value%type;

98: p_user_key_value in varchar2,
99: p_new_user_key_value in varchar2,
100: p_unique_key_id in number
101: ) is
102: l_user_key_value hr_pump_batch_line_user_keys.user_key_value%type;
103: l_unique_key_id hr_pump_batch_line_user_keys.unique_key_id%type;
104: begin
105: -- Check input values.
106: if ( p_user_key_value is null ) then

Line 103: l_unique_key_id hr_pump_batch_line_user_keys.unique_key_id%type;

99: p_new_user_key_value in varchar2,
100: p_unique_key_id in number
101: ) is
102: l_user_key_value hr_pump_batch_line_user_keys.user_key_value%type;
103: l_unique_key_id hr_pump_batch_line_user_keys.unique_key_id%type;
104: begin
105: -- Check input values.
106: if ( p_user_key_value is null ) then
107: raise value_error;

Line 114: from hr_pump_batch_line_user_keys

110: -- Get the current user key row.
111: select user_key_value, unique_key_id
112: into l_user_key_value,
113: l_unique_key_id
114: from hr_pump_batch_line_user_keys
115: where user_key_value = p_user_key_value;
116:
117: -- Update the row.
118: update hr_pump_batch_line_user_keys

Line 118: update hr_pump_batch_line_user_keys

114: from hr_pump_batch_line_user_keys
115: where user_key_value = p_user_key_value;
116:
117: -- Update the row.
118: update hr_pump_batch_line_user_keys
119: set user_key_value = nvl(p_new_user_key_value, l_user_key_value),
120: unique_key_id = nvl(p_unique_key_id, l_unique_key_id)
121: where user_key_value = p_user_key_value;
122: end modify_user_key;