DBA Data[Home] [Help]

APPS.PQH_GSP_GRD_STEP_REMOVE dependencies on PQH_GSP_UTILITY

Line 250: pqh_gsp_utility.use_point_or_step (

246: l_dml_operation VARCHAR2 (40);
247: BEGIN
248: hr_utility.set_location ('Entering remove_opt', 100);
249: l_point_or_step :=
250: pqh_gsp_utility.use_point_or_step (
251: p_copy_entity_txn_id => p_copy_entity_txn_id
252: );
253: l_dml_operation :=
254: get_dml_operation (

Line 329: l_exits := pqh_gsp_utility.chk_profile_exists ( p_copy_entity_result_id => p_copy_entity_result_id,

325: AND elp.table_alias = 'ELP';
326: BEGIN
327: hr_utility.set_location ('Entering remove_elig_profile', 10);
328: -- Check Eligibility Profiles Exists for OIPL Rec
329: l_exits := pqh_gsp_utility.chk_profile_exists ( p_copy_entity_result_id => p_copy_entity_result_id,
330: p_copy_entity_txn_id => p_copy_entity_txn_id);
331:
332: hr_utility.set_location ( 'Eligibility Profiles Exists (Y/N) :' || l_exits, 50);
333: IF (l_exits = 'Y') THEN

Line 384: l_point_or_step := pqh_gsp_utility.use_point_or_step ( p_copy_entity_txn_id => p_copy_entity_txn_id);

380: AND oipl.table_alias = 'COP'
381: AND oipl.copy_entity_result_id = p_copy_entity_result_id;
382: BEGIN
383: hr_utility.set_location ('Entering remove_oipl_STEP_flavour', 10);
384: l_point_or_step := pqh_gsp_utility.use_point_or_step ( p_copy_entity_txn_id => p_copy_entity_txn_id);
385: l_dml_operation := get_dml_operation ( p_copy_entity_result_id => p_copy_entity_result_id);
386:
387: -- Get OPT Cer ID
388: OPEN csr_opt_result_id;

Line 479: l_point_or_step := pqh_gsp_utility.use_point_or_step ( p_copy_entity_txn_id => p_copy_entity_txn_id);

475: AND oipl.table_alias = 'COP'
476: AND oipl.copy_entity_result_id = p_copy_entity_result_id;
477: BEGIN
478: hr_utility.set_location ('Entering remove_oipl_POINT_flavour', 10);
479: l_point_or_step := pqh_gsp_utility.use_point_or_step ( p_copy_entity_txn_id => p_copy_entity_txn_id);
480: l_dml_operation := get_dml_operation ( p_copy_entity_result_id => p_copy_entity_result_id);
481:
482: -- Get OPT Cer ID
483: OPEN csr_opt_result_id;

Line 543: l_which_flavour := pqh_gsp_utility.use_point_or_step ( p_copy_entity_txn_id => p_copy_entity_txn_id);

539: l_which_flavour VARCHAR2 (20);
540: BEGIN
541: hr_multi_message.enable_message_list;
542: hr_utility.set_location ('Entering remove_oipl', 10);
543: l_which_flavour := pqh_gsp_utility.use_point_or_step ( p_copy_entity_txn_id => p_copy_entity_txn_id);
544: hr_utility.set_location ('POINT/STEP :' || l_which_flavour, 30);
545: IF (l_which_flavour = 'POINT') THEN
546: pqh_gsp_grd_step_remove.remove_oipl_point_flavour (
547: p_copy_entity_txn_id => p_copy_entity_txn_id,

Line 598: l_which_flavour := pqh_gsp_utility.use_point_or_step ( p_copy_entity_txn_id => p_copy_entity_txn_id);

594:
595: BEGIN
596: hr_utility.set_location ('Entering remove_plip', 10);
597:
598: l_which_flavour := pqh_gsp_utility.use_point_or_step ( p_copy_entity_txn_id => p_copy_entity_txn_id);
599: l_dml_operation := get_dml_operation ( p_copy_entity_result_id => p_copy_entity_result_id);
600: hr_utility.set_location ('POINT/STEP :' || l_which_flavour, 30);
601: hr_utility.set_location ('DML Operation :' || l_dml_operation, 45);
602: