[Home] [Help]
PACKAGE: APPS.PQP_GB_SWF_VALIDATIONS
Source
1 PACKAGE PQP_GB_SWF_VALIDATIONS AUTHID CURRENT_USER AS
2 /* $Header: pqpgbswfv.pkh 120.0.12010000.1 2009/12/07 10:04:24 parusia noship $ */
3 /* Copyright (c) Oracle Corporation 2005. All rights reserved. */
4 /*
5 PRODUCT
6 Oracle Public Sector Payroll - GB Localisation School Workforce
7
8 NAME
9 PQP_GB_SWF_VALIDATIONS package
10
11 DESCRIPTION
12 This package contains utility functions for School Workforce
13 configuration setup validation.
14
15 MODIFICATION HISTORY
16 Person Date Version Bug Comments
17 --------- ---------- -------------- ------- --------------------------------
18 P Arusia 8-Jul-2009 115.0 8682922 This package contains utility
19 functions for School Workforce
20 configuration setup validation
21
22 */
23
24 procedure chk_single_unique_mapping(
25 p_configuration_value_id number
26 , p_business_group_id number
27 , p_pcv_information_category varchar2
28 , p_information_column varchar2
29 , p_value varchar2
30 , p_return OUT NOCOPY boolean
31 ) ;
32 procedure chk_range_unique_mapping(
33 p_configuration_value_id number
34 , p_business_group_id number
35 , p_pcv_information_category varchar2
36 , p_information_start_column varchar2
37 , p_information_end_column varchar2
38 , p_value_start varchar2
39 , p_value_end varchar2
40 , p_return OUT NOCOPY boolean
41 ) ;
42 procedure chk_spine_pt_unique_mapping(
43 p_configuration_value_id number
44 , p_business_group_id number
45 , p_pcv_information_category varchar2
46 , p_payscale_column varchar2
47 , p_information_start_column varchar2
48 , p_information_end_column varchar2
49 , p_payscale_value varchar2
50 , p_value_start varchar2
51 , p_value_end varchar2
52 , p_return OUT NOCOPY boolean
53 ) ;
54 procedure chk_unique_lookup_name(
55 p_configuration_value_id number
56 , p_business_group_id number
57 , p_pcv_information_category varchar2
58 , p_information_column varchar2
59 , p_value varchar2
60 , p_return OUT NOCOPY boolean
61 ) ;
62 procedure chk_hours_cntrct_tp_unq_map(
63 p_configuration_value_id number
64 , p_business_group_id number
65 , p_pcv_information_category varchar2
66 , p_information_column varchar2
67 , p_value varchar2
68 , p_return OUT NOCOPY boolean
69 ) ;
70 END PQP_GB_SWF_VALIDATIONS ;