DBA Data[Home] [Help]

APPS.PQH_GSP_BEN_VALIDATIONS dependencies on PQH_GSP_BEN_VALIDATIONS

Line 1: package body pqh_gsp_ben_validations as

1: package body pqh_gsp_ben_validations as
2: /* $Header: pqgspben.pkb 120.1 2008/06/04 11:29:54 brsinha noship $ */
3: -- dml_operation can be I(Insert)/ U(Update)/ D(Delete)
4: -- call to this validation routine is to be made after the actual event i.e.
5: -- insert update or delete should already have happened

Line 9: g_package Varchar2(30) := 'pqh_gsp_ben_validations.';

5: -- insert update or delete should already have happened
6: -- we will try to check here that the event has not failed any GSP data
7: -- if any, we will be raising the error.
8:
9: g_package Varchar2(30) := 'pqh_gsp_ben_validations.';
10: g_debug boolean := hr_utility.debug_enabled;
11:
12: --
13: ---------------------------get_pl_type-----------------------------

Line 1156: pqh_gsp_ben_validations.pgm_ins_val( p_Pgm_Id => p_pgm_id,

1152: hr_utility.set_location('p_Acty_Ref_Perd_Cd:'||p_Acty_Ref_Perd_Cd, 41);
1153: hr_utility.set_location('p_Pgm_Uom:'||p_Pgm_Uom, 42);
1154: end if;
1155:
1156: pqh_gsp_ben_validations.pgm_ins_val( p_Pgm_Id => p_pgm_id,
1157: p_Business_Group_Id => p_business_group_id,
1158: p_Short_Name => p_short_name,
1159: p_Short_Code => p_short_code,
1160: p_Effective_Date => p_effective_date,

Line 1344: pqh_gsp_ben_validations.pgm_ins_val( p_Pgm_Id => p_pgm_id,

1340:
1341: if g_debug then
1342: hr_utility.set_location(' PGM Insert Validations ', 90);
1343: end if;
1344: pqh_gsp_ben_validations.pgm_ins_val( p_Pgm_Id => p_pgm_id,
1345: p_Business_Group_Id => p_business_group_id,
1346: p_Short_Name => p_short_name,
1347: p_Short_Code => p_short_code,
1348: p_Effective_Date => p_effective_date,

Line 1359: pqh_gsp_ben_validations.pgm_upd_val( p_Pgm_Id => p_pgm_id,

1355:
1356: if g_debug then
1357: hr_utility.set_location(' PGM Update Validations ', 95);
1358: end if;
1359: pqh_gsp_ben_validations.pgm_upd_val( p_Pgm_Id => p_pgm_id,
1360: p_Business_Group_Id => p_business_group_id,
1361: p_Short_Name => p_short_name,
1362: p_Short_Code => p_short_code,
1363: p_Effective_Date => p_effective_date,

Line 1381: pqh_gsp_ben_validations.pgm_del_val( p_Pgm_Id => p_pgm_id,

1377:
1378: if g_debug then
1379: hr_utility.set_location(' PGM Delete Validations ', 100);
1380: end if;
1381: pqh_gsp_ben_validations.pgm_del_val( p_Pgm_Id => p_pgm_id,
1382: p_Business_Group_Id => p_business_group_id,
1383: p_Effective_Date => p_effective_date);
1384: End if;
1385:

Line 2616: end pqh_gsp_ben_validations;

2612: hr_utility.set_location('Leaving'||l_proc,100);
2613: end if;
2614:
2615: end abr_validations;
2616: end pqh_gsp_ben_validations;