APPS.PAY_SE_TAX_CARD dependencies on HR_PUMP_BATCH_LINE_USER_KEYS

Line 65: L_EE_USER_KEY hr_pump_batch_line_user_keys.user_key_value%type;

61: l_batch_seq NUMBER := 0;
62: l_batch_id NUMBER;
63:
64: -- Parameter values to create Batch Lines
65: L_EE_USER_KEY hr_pump_batch_line_user_keys.user_key_value%type;
66: L_ASSIGNMENT_USER_KEY hr_pump_batch_line_user_keys.user_key_value%type;
67: L_ELEMENT_LINK_USER_KEY hr_pump_batch_line_user_keys.user_key_value%type;
68:
69: l_user_key_value hr_pump_batch_line_user_keys.user_key_value%type;

Line 66: L_ASSIGNMENT_USER_KEY hr_pump_batch_line_user_keys.user_key_value%type;

62: l_batch_id NUMBER;
63:
64: -- Parameter values to create Batch Lines
65: L_EE_USER_KEY hr_pump_batch_line_user_keys.user_key_value%type;
66: L_ASSIGNMENT_USER_KEY hr_pump_batch_line_user_keys.user_key_value%type;
67: L_ELEMENT_LINK_USER_KEY hr_pump_batch_line_user_keys.user_key_value%type;
68:
69: l_user_key_value hr_pump_batch_line_user_keys.user_key_value%type;
70: l_unique_key_id hr_pump_batch_line_user_keys.unique_key_id%type;

Line 67: L_ELEMENT_LINK_USER_KEY hr_pump_batch_line_user_keys.user_key_value%type;

63:
64: -- Parameter values to create Batch Lines
65: L_EE_USER_KEY hr_pump_batch_line_user_keys.user_key_value%type;
66: L_ASSIGNMENT_USER_KEY hr_pump_batch_line_user_keys.user_key_value%type;
67: L_ELEMENT_LINK_USER_KEY hr_pump_batch_line_user_keys.user_key_value%type;
68:
69: l_user_key_value hr_pump_batch_line_user_keys.user_key_value%type;
70: l_unique_key_id hr_pump_batch_line_user_keys.unique_key_id%type;
71:

Line 69: l_user_key_value hr_pump_batch_line_user_keys.user_key_value%type;

65: L_EE_USER_KEY hr_pump_batch_line_user_keys.user_key_value%type;
66: L_ASSIGNMENT_USER_KEY hr_pump_batch_line_user_keys.user_key_value%type;
67: L_ELEMENT_LINK_USER_KEY hr_pump_batch_line_user_keys.user_key_value%type;
68:
69: l_user_key_value hr_pump_batch_line_user_keys.user_key_value%type;
70: l_unique_key_id hr_pump_batch_line_user_keys.unique_key_id%type;
71:
72: l_datetrack_update_mode VARCHAR2(80);
73:

Line 70: l_unique_key_id hr_pump_batch_line_user_keys.unique_key_id%type;

66: L_ASSIGNMENT_USER_KEY hr_pump_batch_line_user_keys.user_key_value%type;
67: L_ELEMENT_LINK_USER_KEY hr_pump_batch_line_user_keys.user_key_value%type;
68:
69: l_user_key_value hr_pump_batch_line_user_keys.user_key_value%type;
70: l_unique_key_id hr_pump_batch_line_user_keys.unique_key_id%type;
71:
72: l_datetrack_update_mode VARCHAR2(80);
73:
74: -- Variables to Read from File

Line 473: DELETE FROM HR_PUMP_BATCH_LINE_USER_KEYS WHERE unique_key_id =l_unique_key_id;

469: IF l_unique_key_id > 0
470: THEN
471: BEGIN
472: hr_utility.set_location ( ' User Key deleted: ' , 201);
473: DELETE FROM HR_PUMP_BATCH_LINE_USER_KEYS WHERE unique_key_id =l_unique_key_id;
474: end;
475: END IF ;
476:
477: /* deletion code for user key*/

Line 897: PARAMATERS : user key value User Key value from table hr_pump_batch_line_user_keys

893: /* &&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
894: USER KEY VALUE TO KEY ID CONVERTOR FUNC()
895:
896: PROCEDURE NAME : USER_KEY_TO_ID
897: PARAMATERS : user key value User Key value from table hr_pump_batch_line_user_keys
898:
899: PURPOSE : To get the User key id for that Value
900: ERRORS HANDLED : Return ZERO when no data found.
901:

Line 912: from hr_pump_batch_line_user_keys

908: BEGIN
909:
910: select unique_key_id
911: into l_id
912: from hr_pump_batch_line_user_keys
913: where user_key_value = p_user_key_value;
914: return(l_id);
915: EXCEPTION
916: WHEN NO_DATA_FOUND