PACKAGE: APPS.PQP_FEDHR_USPAY_INTG_PKG

Source

1 PACKAGE pqp_fedhr_uspay_intg_pkg
2 /* $Header: pqpfhrel.pkh 115.20 2003/07/02 03:15:32 ashgupta noship $ */
3 AUTHID CURRENT_USER AS
4 -- ---------------------------------------------------------------------------
5 --  |--------------------< pqp_fedhr_element_creation >----------------------|
6 -- ---------------------------------------------------------------------------
7 -- {Start of Comments}
8 --
9 -- Description:
10 --  Checks for
11 --     1) GHR,PAY Product Installations.Proceeds if Installed.
12 --     2) If already script is run,if yes stops exec.
13 --     3) If for the Element Prefix passed, any Element Link exists stops exec.
14 --     4) After all checks the Script creates the Federal Payroll Elements.
15 --
16 -- Access Status:
17 --   Internal Use Only.
18 --
19 -- {End of Comments}
20 -- ---------------------------------------------------------------------------
21 PROCEDURE pqp_fedhr_element_creation
22 (
23     errbuf              OUT NOCOPY VARCHAR2 ,
24     retcode             OUT NOCOPY NUMBER   ,
25     p_business_group_id            NUMBER   ,
26     p_effective_date               VARCHAR2 ,
27     p_prefix                       VARCHAR2
28 );
29 -- **************************************************************************
30 -- ---------------------------------------------------------------------------
31 --  |-----------------< update_or_ins_config_vals >----------------------|
32 -- ---------------------------------------------------------------------------
33 -- {Start of Comments}
34 --
35 -- Description:
36 --  Checks for the existence of Old Element name under PQP_CONFIGURATION_VALUES
37 --     1) If exists then UPDATE the entry in pqp_configuration_values for
38 --        element_type_id with the new element element_type_id
39 --        ELSE
40 --     2) INSERT a row into pqp_configuration_values table.
41 --
42 -- Access Status:
43 --   Internal Use Only.
44 --
45 -- {End of Comments}
46 -- ---------------------------------------------------------------------------
47 PROCEDURE update_or_ins_pqp_config_vals
48 (
49      errbuf                OUT NOCOPY VARCHAR2 ,
50      retcode               OUT NOCOPY NUMBER   ,
51      p_business_group_id              NUMBER   ,
52      p_old_ele_name                   VARCHAR2 ,
53      p_new_ele_name                   VARCHAR2 ,
54      p_is_pb_enabled                  VARCHAR2 ,
55      p_pay_basis                      VARCHAR2
56 );
57 
58 END pqp_fedhr_uspay_intg_pkg;