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 1115: lv_transaction_steps(lv_cnt).param_value := to_char(p_date_start, hr_transaction_ss.g_date_format);

1111: lv_transaction_steps(lv_cnt).param_data_type := 'NUMBER';
1112:
1113: lv_cnt := lv_cnt + 1;
1114: lv_transaction_steps(lv_cnt).param_name := 'P_DATE_START';
1115: lv_transaction_steps(lv_cnt).param_value := to_char(p_date_start, hr_transaction_ss.g_date_format);
1116: lv_transaction_steps(lv_cnt).param_data_type := 'DATE';
1117:
1118: lv_cnt := lv_cnt + 1;
1119: lv_transaction_steps(lv_cnt).param_name := 'P_EFFECTIVE_DATE';

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

1116: lv_transaction_steps(lv_cnt).param_data_type := 'DATE';
1117:
1118: lv_cnt := lv_cnt + 1;
1119: lv_transaction_steps(lv_cnt).param_name := 'P_EFFECTIVE_DATE';
1120: lv_transaction_steps(lv_cnt).param_value := to_char(p_effective_date, hr_transaction_ss.g_date_format);
1121: lv_transaction_steps(lv_cnt).param_data_type := 'DATE';
1122:
1123: lv_cnt := lv_cnt + 1;
1124: lv_transaction_steps(lv_cnt).param_name := 'P_OBJECT_VERSION_NUMBER';

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

1131: lv_transaction_steps(lv_cnt).param_data_type := 'NUMBER';
1132:
1133: lv_cnt := lv_cnt + 1;
1134: lv_transaction_steps(lv_cnt).param_name := 'P_ACTUAL_TERMINATION_DATE';
1135: lv_transaction_steps(lv_cnt).param_value := to_char(p_actual_termination_date, hr_transaction_ss.g_date_format);
1136: lv_transaction_steps(lv_cnt).param_data_type := 'DATE';
1137:
1138: IF p_final_process_date IS NOT NULL THEN
1139: lv_cnt := lv_cnt + 1;

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

1137:
1138: IF p_final_process_date IS NOT NULL THEN
1139: lv_cnt := lv_cnt + 1;
1140: lv_transaction_steps(lv_cnt).param_name := 'P_FINAL_PROCESS_DATE';
1141: lv_transaction_steps(lv_cnt).param_value := to_char(p_final_process_date, hr_transaction_ss.g_date_format);
1142: lv_transaction_steps(lv_cnt).param_data_type := 'DATE';
1143: END IF;
1144:
1145: IF p_last_standard_process_date IS NOT NULL THEN

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

1144:
1145: IF p_last_standard_process_date IS NOT NULL THEN
1146: lv_cnt := lv_cnt + 1;
1147: lv_transaction_steps(lv_cnt).param_name := 'P_LAST_STANDARD_PROCESS_DATE';
1148: lv_transaction_steps(lv_cnt).param_value := to_char(p_last_standard_process_date, hr_transaction_ss.g_date_format);
1149: lv_transaction_steps(lv_cnt).param_data_type := 'DATE';
1150: END IF;
1151:
1152: lv_cnt := lv_cnt + 1;

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

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

Line 1521: ln_transaction_id := hr_transaction_ss.get_transaction_id (

1517: -------------------------------------------------------------------
1518: -- Check if Transaction Already Exists !
1519: -------------------------------------------------------------------
1520:
1521: ln_transaction_id := hr_transaction_ss.get_transaction_id (
1522: p_Item_Type => p_item_type,
1523: p_Item_Key => p_item_key
1524: );
1525: IF ln_transaction_id IS NULL THEN

Line 1527: hr_transaction_ss.start_transaction (

1523: p_Item_Key => p_item_key
1524: );
1525: IF ln_transaction_id IS NULL THEN
1526: -- Create a New Transaction
1527: hr_transaction_ss.start_transaction (
1528: itemtype => p_item_type,
1529: itemkey => p_item_key,
1530: actid => TO_NUMBER(p_actid),
1531: funmode => 'RUN',

Line 1537: ln_transaction_id := hr_transaction_ss.get_transaction_id (

1533: p_login_person_id => p_login_person_id,
1534: result => lv_result
1535: );
1536:
1537: ln_transaction_id := hr_transaction_ss.get_transaction_id (
1538: p_Item_Type => p_item_type,
1539: p_Item_Key => p_item_key
1540: );
1541: END IF;

Line 1581: hr_transaction_ss.get_activity_trans_step_id (

1577: -- There are transaction steps for this transaction.
1578: -- Get the Transaction Step ID for this activity.
1579: --------------------------------------------------------------------
1580: ln_transaction_step_id :=
1581: hr_transaction_ss.get_activity_trans_step_id (
1582: p_activity_name => lv_activity_name,
1583: p_trans_step_id_tbl => ltt_trans_step_ids
1584: );
1585:

Line 1589: hr_transaction_ss.save_transaction_step (

1585:
1586: END IF;
1587: -- Save Transaction Step.
1588:
1589: hr_transaction_ss.save_transaction_step (
1590: p_item_Type => p_item_type,
1591: p_item_Key => p_item_key,
1592: p_actid => TO_NUMBER(p_actid),
1593: p_login_person_id => p_login_person_id,