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 485: l_point_or_step := pqh_gsp_utility.use_point_or_step ( p_copy_entity_txn_id => p_copy_entity_txn_id);

481: AND oipl.table_alias = 'COP'
482: AND oipl.copy_entity_result_id = p_copy_entity_result_id;
483: BEGIN
484: hr_utility.set_location ('Entering remove_oipl_POINT_flavour', 10);
485: l_point_or_step := pqh_gsp_utility.use_point_or_step ( p_copy_entity_txn_id => p_copy_entity_txn_id);
486: l_dml_operation := get_dml_operation ( p_copy_entity_result_id => p_copy_entity_result_id);
487:
488: -- Get OPT Cer ID
489: OPEN csr_opt_result_id;

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

551: l_which_flavour VARCHAR2 (20);
552: BEGIN
553: hr_multi_message.enable_message_list;
554: hr_utility.set_location ('Entering remove_oipl', 10);
555: l_which_flavour := pqh_gsp_utility.use_point_or_step ( p_copy_entity_txn_id => p_copy_entity_txn_id);
556: hr_utility.set_location ('POINT/STEP :' || l_which_flavour, 30);
557: IF (l_which_flavour = 'POINT') THEN
558: pqh_gsp_grd_step_remove.remove_oipl_point_flavour (
559: p_copy_entity_txn_id => p_copy_entity_txn_id,

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

606:
607: BEGIN
608: hr_utility.set_location ('Entering remove_plip', 10);
609:
610: l_which_flavour := pqh_gsp_utility.use_point_or_step ( p_copy_entity_txn_id => p_copy_entity_txn_id);
611: l_dml_operation := get_dml_operation ( p_copy_entity_result_id => p_copy_entity_result_id);
612: hr_utility.set_location ('POINT/STEP :' || l_which_flavour, 30);
613: hr_utility.set_location ('DML Operation :' || l_dml_operation, 45);
614: