DBA Data[Home] [Help]

APPS.HR_RATE_VALUES_SWI dependencies on HR_TRANSACTION_SS

Line 6: l_trans_tbl hr_transaction_ss.transaction_table;

2: /* $Header: hrpgrswi.pkb 115.9 2004/04/01 10:46 svittal noship $ */
3: --
4: -- Package variables
5: -- Global Variables
6: l_trans_tbl hr_transaction_ss.transaction_table;
7: g_package Varchar2(30):='HR_RATE_VALUES_SWI';
8:
9: --
10: --

Line 849: l_effective_date:= to_date(hr_transaction_ss.get_wf_effective_date

845: return;
846: end if;
847: end if;
848:
849: l_effective_date:= to_date(hr_transaction_ss.get_wf_effective_date
850: (p_transaction_step_id => p_transaction_step_id),
851: hr_transaction_ss.g_date_format
852: );
853: dt_fndate.set_effective_date(l_effective_date);

Line 851: hr_transaction_ss.g_date_format

847: end if;
848:
849: l_effective_date:= to_date(hr_transaction_ss.get_wf_effective_date
850: (p_transaction_step_id => p_transaction_step_id),
851: hr_transaction_ss.g_date_format
852: );
853: dt_fndate.set_effective_date(l_effective_date);
854: -- start registration
855: -- If its a new user registration flow then the assignmentId which is coming

Line 947: hr_transaction_ss.get_transaction_id(p_item_type ,p_item_key);

943: l_current_rec csr_basetb_data%rowtype;
944: Begin
945: l_login_person_id := fnd_global.employee_id;
946: l_transaction_id :=
947: hr_transaction_ss.get_transaction_id(p_item_type ,p_item_key);
948: l_asg_rate_rec := p_asg_rate_tab(1);
949:
950:
951: if l_transaction_id is NULL

Line 953: hr_transaction_ss.start_transaction

949:
950:
951: if l_transaction_id is NULL
952: then
953: hr_transaction_ss.start_transaction
954: (itemtype => p_item_type
955: ,itemkey => p_item_key
956: ,actid => p_activity_id
957: ,funmode => 'RUN'

Line 963: hr_transaction_ss.get_transaction_id(p_item_type ,p_item_key);

959: ,p_login_person_id => l_login_person_id
960: ,result => l_result
961: );
962: l_transaction_id :=
963: hr_transaction_ss.get_transaction_id(p_item_type ,p_item_key);
964: end if;
965:
966: open csr_basetb_data(l_asg_rate_rec.grade_rule_id,
967: l_asg_rate_rec.business_group_id, l_asg_rate_rec.assignment_id,

Line 1143: to_char(l_asg_rate_rec.effective_start_date,hr_transaction_ss.g_date_format);

1139:
1140: l_count := l_count+1;
1141: l_trans_tbl(l_count).param_name := 'P_EFFECTIVE_START_DATE';
1142: l_trans_tbl(l_count).param_value :=
1143: to_char(l_asg_rate_rec.effective_start_date,hr_transaction_ss.g_date_format);
1144: l_trans_tbl(l_count).param_data_type := 'DATE';
1145:
1146: l_count := l_count+1;
1147: l_trans_tbl(l_count).param_name := 'P_EFFECTIVE_END_DATE';

Line 1149: to_char(l_asg_rate_rec.effective_end_date,hr_transaction_ss.g_date_format);

1145:
1146: l_count := l_count+1;
1147: l_trans_tbl(l_count).param_name := 'P_EFFECTIVE_END_DATE';
1148: l_trans_tbl(l_count).param_value :=
1149: to_char(l_asg_rate_rec.effective_end_date,hr_transaction_ss.g_date_format);
1150: l_trans_tbl(l_count).param_data_type := 'DATE';
1151:
1152: l_count := l_count+1;
1153: l_trans_tbl(l_count).param_name := 'P_REVIEW_PROC_CALL';

Line 1175: hr_transaction_ss.save_transaction_step

1171: l_trans_tbl(l_count).param_value := l_record_status;
1172: l_trans_tbl(l_count).param_data_type := 'VARCHAR2';
1173:
1174:
1175: hr_transaction_ss.save_transaction_step
1176: (p_item_type => p_item_type
1177: ,p_item_key => p_item_key
1178: ,p_actid => p_activity_id
1179: ,p_login_person_id => l_login_person_id

Line 1223: hr_transaction_ss.get_transaction_id(p_item_type ,p_item_key);

1219:
1220: Begin
1221: l_login_person_id := fnd_global.employee_id;
1222: l_transaction_id :=
1223: hr_transaction_ss.get_transaction_id(p_item_type ,p_item_key);
1224:
1225: if l_transaction_id is NULL
1226: then
1227: hr_transaction_ss.start_transaction

Line 1227: hr_transaction_ss.start_transaction

1223: hr_transaction_ss.get_transaction_id(p_item_type ,p_item_key);
1224:
1225: if l_transaction_id is NULL
1226: then
1227: hr_transaction_ss.start_transaction
1228: (itemtype => p_item_type
1229: ,itemkey => p_item_key
1230: ,actid => p_activity_id
1231: ,funmode => 'RUN'

Line 1237: hr_transaction_ss.get_transaction_id(p_item_type ,p_item_key);

1233: ,p_login_person_id => l_login_person_id
1234: ,result => l_result
1235: );
1236: l_transaction_id :=
1237: hr_transaction_ss.get_transaction_id(p_item_type ,p_item_key);
1238: end if;
1239:
1240:
1241:

Line 1318: hr_transaction_ss.save_transaction_step

1314: l_trans_tbl(l_count).param_name := 'P_REVIEW_ACTID';
1315: l_trans_tbl(l_count).param_value := p_activity_id;
1316: l_trans_tbl(l_count).param_data_type := 'VARCHAR2';
1317:
1318: hr_transaction_ss.save_transaction_step
1319: (p_item_type => p_item_type
1320: ,p_item_key => p_item_key
1321: ,p_actid => p_activity_id
1322: ,p_login_person_id => l_login_person_id