813: ,p_supplier_id in number
814: ,p_business_group_id in number
815: ) is
816: --
817: l_transaction_table hr_transaction_ss.transaction_table;
818: l_api_error boolean;
819: l_transaction_id number := null;
820: l_transaction_step_id number := null;
821: l_respons_id number := null;
913: -- exists.
914: -------------------------------------------------------------------------------
915: --
916: hr_utility.set_location('Entering next line'||g_package, 6);
917: l_transaction_id := hr_transaction_ss.get_transaction_id
918: (p_item_type => p_item_type
919: ,p_item_key => p_item_key);
920: --
921: hr_utility.set_location('Entering next line line'||g_package, 7);
919: ,p_item_key => p_item_key);
920: --
921: hr_utility.set_location('Entering next line line'||g_package, 7);
922: if l_transaction_id is null then
923: hr_transaction_ss.start_transaction
924: (itemtype => p_item_type
925: ,itemkey => p_item_key
926: ,actid => p_actid
927: ,funmode => 'RUN'
928: ,p_login_person_id => p_login_person_id
929: ,result => l_result);
930: --
931: hr_utility.set_location('Entering next line line'||g_package, 8);
932: l_transaction_id := hr_transaction_ss.get_transaction_id
933: (p_item_type => p_item_type
934: ,p_item_key => p_item_key);
935: end if;
936: --
1000: l_transaction_table(l_count).param_data_type := 'NUMBER';
1001: --
1002: l_count := l_count + 1;
1003: l_transaction_table(l_count).param_name := 'P_START_DATE';
1004: l_transaction_table(l_count).param_value := nvl(to_char(ben_process_user_utility.g_fnd_user_record.start_date,hr_transaction_ss.g_date_format),to_char(p_start_date,
1005: hr_transaction_ss.g_date_format));
1006: l_transaction_table(l_count).param_data_type := 'DATE';
1007: --
1008: l_count := l_count + 1;
1001: --
1002: l_count := l_count + 1;
1003: l_transaction_table(l_count).param_name := 'P_START_DATE';
1004: l_transaction_table(l_count).param_value := nvl(to_char(ben_process_user_utility.g_fnd_user_record.start_date,hr_transaction_ss.g_date_format),to_char(p_start_date,
1005: hr_transaction_ss.g_date_format));
1006: l_transaction_table(l_count).param_data_type := 'DATE';
1007: --
1008: l_count := l_count + 1;
1009: l_transaction_table(l_count).param_name := 'P_END_DATE';
1006: l_transaction_table(l_count).param_data_type := 'DATE';
1007: --
1008: l_count := l_count + 1;
1009: l_transaction_table(l_count).param_name := 'P_END_DATE';
1010: l_transaction_table(l_count).param_value := nvl(to_char(ben_process_user_utility.g_fnd_user_record.end_date,hr_transaction_ss.g_date_format),to_char(p_end_date,
1011: hr_transaction_ss.g_date_format));
1012: l_transaction_table(l_count).param_data_type := 'DATE';
1013: --
1014: l_count := l_count + 1;
1007: --
1008: l_count := l_count + 1;
1009: l_transaction_table(l_count).param_name := 'P_END_DATE';
1010: l_transaction_table(l_count).param_value := nvl(to_char(ben_process_user_utility.g_fnd_user_record.end_date,hr_transaction_ss.g_date_format),to_char(p_end_date,
1011: hr_transaction_ss.g_date_format));
1012: l_transaction_table(l_count).param_data_type := 'DATE';
1013: --
1014: l_count := l_count + 1;
1015: l_transaction_table(l_count).param_name := 'P_LAST_LOGON_DATE';
1012: l_transaction_table(l_count).param_data_type := 'DATE';
1013: --
1014: l_count := l_count + 1;
1015: l_transaction_table(l_count).param_name := 'P_LAST_LOGON_DATE';
1016: l_transaction_table(l_count).param_value := nvl(to_char(ben_process_user_utility.g_fnd_user_record.last_logon_date,hr_transaction_ss.g_date_format),to_char(p_last_logon_date,
1017: hr_transaction_ss.g_date_format));
1018: l_transaction_table(l_count).param_data_type := 'DATE';
1019: --
1020: l_count := l_count + 1;
1013: --
1014: l_count := l_count + 1;
1015: l_transaction_table(l_count).param_name := 'P_LAST_LOGON_DATE';
1016: l_transaction_table(l_count).param_value := nvl(to_char(ben_process_user_utility.g_fnd_user_record.last_logon_date,hr_transaction_ss.g_date_format),to_char(p_last_logon_date,
1017: hr_transaction_ss.g_date_format));
1018: l_transaction_table(l_count).param_data_type := 'DATE';
1019: --
1020: l_count := l_count + 1;
1021: l_transaction_table(l_count).param_name := 'P_DESCRIPTION';
1023: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
1024: --
1025: l_count := l_count + 1;
1026: l_transaction_table(l_count).param_name := 'P_PASSWORD_DATE';
1027: l_transaction_table(l_count).param_value := nvl(to_char(ben_process_user_utility.g_fnd_user_record.password_date,hr_transaction_ss.g_date_format),to_char(p_password_date,
1028: hr_transaction_ss.g_date_format));
1029: l_transaction_table(l_count).param_data_type := 'DATE';
1030: --
1031: l_count := l_count + 1;
1024: --
1025: l_count := l_count + 1;
1026: l_transaction_table(l_count).param_name := 'P_PASSWORD_DATE';
1027: l_transaction_table(l_count).param_value := nvl(to_char(ben_process_user_utility.g_fnd_user_record.password_date,hr_transaction_ss.g_date_format),to_char(p_password_date,
1028: hr_transaction_ss.g_date_format));
1029: l_transaction_table(l_count).param_data_type := 'DATE';
1030: --
1031: l_count := l_count + 1;
1032: l_transaction_table(l_count).param_name := 'P_PASSWORD_ACCESSES_LEFT';
1084: l_transaction_table(l_count).param_data_type := 'NUMBER';
1085: --
1086: --
1087: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee7', 5);
1088: hr_transaction_ss.save_transaction_step
1089: (p_item_type => p_item_type
1090: ,p_item_key => p_item_key
1091: ,p_actid => p_actid
1092: ,p_login_person_id => p_login_person_id