DBA Data[Home] [Help]

APPS.HR_CWK_TERMINATION_SWI dependencies on HR_TRANSACTION_SS

Line 7: lv_transaction_steps hr_transaction_ss.transaction_table;

3: --
4: -- Package variables
5: --
6: g_package varchar2(33) := 'hr_cwk_termination_swi.';
7: lv_transaction_steps hr_transaction_ss.transaction_table;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |---------------------< actual_termination_placement >---------------------|
11: -- ----------------------------------------------------------------------------

Line 1126: lv_transaction_steps(lv_cnt).param_value := to_char(p_date_start, hr_transaction_ss.g_date_format);

1122: lv_transaction_steps(lv_cnt).param_data_type := 'NUMBER';
1123:
1124: lv_cnt := lv_cnt + 1;
1125: lv_transaction_steps(lv_cnt).param_name := 'P_DATE_START';
1126: lv_transaction_steps(lv_cnt).param_value := to_char(p_date_start, hr_transaction_ss.g_date_format);
1127: lv_transaction_steps(lv_cnt).param_data_type := 'DATE';
1128:
1129: lv_cnt := lv_cnt + 1;
1130: lv_transaction_steps(lv_cnt).param_name := 'P_EFFECTIVE_DATE';

Line 1131: lv_transaction_steps(lv_cnt).param_value := to_char(p_effective_date, hr_transaction_ss.g_date_format);

1127: lv_transaction_steps(lv_cnt).param_data_type := 'DATE';
1128:
1129: lv_cnt := lv_cnt + 1;
1130: lv_transaction_steps(lv_cnt).param_name := 'P_EFFECTIVE_DATE';
1131: lv_transaction_steps(lv_cnt).param_value := to_char(p_effective_date, hr_transaction_ss.g_date_format);
1132: lv_transaction_steps(lv_cnt).param_data_type := 'DATE';
1133:
1134: lv_cnt := lv_cnt + 1;
1135: lv_transaction_steps(lv_cnt).param_name := 'P_OBJECT_VERSION_NUMBER';

Line 1146: lv_transaction_steps(lv_cnt).param_value := to_char(p_actual_termination_date, hr_transaction_ss.g_date_format);

1142: lv_transaction_steps(lv_cnt).param_data_type := 'NUMBER';
1143:
1144: lv_cnt := lv_cnt + 1;
1145: lv_transaction_steps(lv_cnt).param_name := 'P_ACTUAL_TERMINATION_DATE';
1146: lv_transaction_steps(lv_cnt).param_value := to_char(p_actual_termination_date, hr_transaction_ss.g_date_format);
1147: lv_transaction_steps(lv_cnt).param_data_type := 'DATE';
1148:
1149: IF p_final_process_date IS NOT NULL THEN
1150: lv_cnt := lv_cnt + 1;

Line 1152: lv_transaction_steps(lv_cnt).param_value := to_char(p_final_process_date, hr_transaction_ss.g_date_format);

1148:
1149: IF p_final_process_date IS NOT NULL THEN
1150: lv_cnt := lv_cnt + 1;
1151: lv_transaction_steps(lv_cnt).param_name := 'P_FINAL_PROCESS_DATE';
1152: lv_transaction_steps(lv_cnt).param_value := to_char(p_final_process_date, hr_transaction_ss.g_date_format);
1153: lv_transaction_steps(lv_cnt).param_data_type := 'DATE';
1154: END IF;
1155:
1156: IF p_last_standard_process_date IS NOT NULL THEN

Line 1159: lv_transaction_steps(lv_cnt).param_value := to_char(p_last_standard_process_date, hr_transaction_ss.g_date_format);

1155:
1156: IF p_last_standard_process_date IS NOT NULL THEN
1157: lv_cnt := lv_cnt + 1;
1158: lv_transaction_steps(lv_cnt).param_name := 'P_LAST_STANDARD_PROCESS_DATE';
1159: lv_transaction_steps(lv_cnt).param_value := to_char(p_last_standard_process_date, hr_transaction_ss.g_date_format);
1160: lv_transaction_steps(lv_cnt).param_data_type := 'DATE';
1161: END IF;
1162:
1163: lv_cnt := lv_cnt + 1;

Line 1171: lv_transaction_steps(lv_cnt).param_value := to_char(p_projected_termination_date, hr_transaction_ss.g_date_format);

1167:
1168: IF p_projected_termination_date IS NOT NULL THEN
1169: lv_cnt := lv_cnt + 1;
1170: lv_transaction_steps(lv_cnt).param_name := 'P_PROJECTED_TERMINATION_DATE';
1171: lv_transaction_steps(lv_cnt).param_value := to_char(p_projected_termination_date, hr_transaction_ss.g_date_format);
1172: lv_transaction_steps(lv_cnt).param_data_type := 'DATE';
1173: END IF;
1174:
1175: lv_cnt := lv_cnt + 1;

Line 1532: ln_transaction_id := hr_transaction_ss.get_transaction_id (

1528: -------------------------------------------------------------------
1529: -- Check if Transaction Already Exists !
1530: -------------------------------------------------------------------
1531:
1532: ln_transaction_id := hr_transaction_ss.get_transaction_id (
1533: p_Item_Type => p_item_type,
1534: p_Item_Key => p_item_key
1535: );
1536: IF ln_transaction_id IS NULL THEN

Line 1538: hr_transaction_ss.start_transaction (

1534: p_Item_Key => p_item_key
1535: );
1536: IF ln_transaction_id IS NULL THEN
1537: -- Create a New Transaction
1538: hr_transaction_ss.start_transaction (
1539: itemtype => p_item_type,
1540: itemkey => p_item_key,
1541: actid => TO_NUMBER(p_actid),
1542: funmode => 'RUN',

Line 1548: ln_transaction_id := hr_transaction_ss.get_transaction_id (

1544: p_login_person_id => p_login_person_id,
1545: result => lv_result
1546: );
1547:
1548: ln_transaction_id := hr_transaction_ss.get_transaction_id (
1549: p_Item_Type => p_item_type,
1550: p_Item_Key => p_item_key
1551: );
1552: END IF;

Line 1592: hr_transaction_ss.get_activity_trans_step_id (

1588: -- There are transaction steps for this transaction.
1589: -- Get the Transaction Step ID for this activity.
1590: --------------------------------------------------------------------
1591: ln_transaction_step_id :=
1592: hr_transaction_ss.get_activity_trans_step_id (
1593: p_activity_name => lv_activity_name,
1594: p_trans_step_id_tbl => ltt_trans_step_ids
1595: );
1596:

Line 1600: hr_transaction_ss.save_transaction_step (

1596:
1597: END IF;
1598: -- Save Transaction Step.
1599:
1600: hr_transaction_ss.save_transaction_step (
1601: p_item_Type => p_item_type,
1602: p_item_Key => p_item_key,
1603: p_actid => TO_NUMBER(p_actid),
1604: p_login_person_id => p_login_person_id,