DBA Data[Home] [Help]

PACKAGE: APPS.PAY_SLA_PKG

Source


1 PACKAGE pay_sla_pkg AUTHID CURRENT_USER AS
2 /* $Header: pysla.pkh 120.6.12010000.1 2008/07/27 23:42:36 appldev ship $ */
3 --
4 /*
5  * ***************************************************************************
6 --
7   Copyright (c) Oracle Corporation (UK) Ltd 1993,1994.
8   All Rights Reserved.
9 --
10   PRODUCT
11     Oracle*Payroll
12 --
13   NAME
14     PAY_SLA_PKG  - Payroll support for SLA (Sub Ledger Accounting)
15 --
16 --
17   DESCRIPTION
18 
19   MODIFIED      (DD-MON-YYYY)
20      A.Logue    04-Oct-2006     Added create_custom_adrs.
21      A.Logue    04-Sep-2006     Added delete_event.
22      A.Logue	25-Nov-2005	Added stubs for SLA preaccounting,
23                                 postaccounting and extract hook procedures.
24      A.Logue	22-Nov-2005	Changed post_processing to postprocessing.
25      A.Logue	16-Nov-2005	Added various procedures and functions.
26      A.Logue	07-Oct-2005	Created
27 --
28 */
29 --
30 PROCEDURE trans_asg_costs
31 	(i_assignment_action_id NUMBER);
32 --
33 PROCEDURE postprocessing
34         (p_application_id  NUMBER,
35          p_accounting_mode VARCHAR2);
36 --
37 FUNCTION get_conversion_type
38         (i_business_group_id NUMBER,
39          i_conversion_date   DATE) RETURN VARCHAR2;
40 --
41 FUNCTION get_accounting_date
42          (run_action_type     VARCHAR2,
43           cost_effective_date DATE,
44           run_effective_date  DATE,
45           run_date_earned     DATE) RETURN DATE;
46 --
47 FUNCTION get_ecost_accounting_date
48          (ecost_payroll_id    NUMBER,
49           cost_effective_date DATE) RETURN DATE;
50 --
51 PROCEDURE preaccounting
52         (p_application_id     NUMBER,
53          p_ledger_id          NUMBER,
54          p_process_category   VARCHAR2,
55          p_end_date           DATE,
56          p_accounting_mode    VARCHAR2,
57          p_valuation_method   VARCHAR2,
58          p_security_id_int_1  NUMBER,
59          p_security_id_int_2  NUMBER,
60          p_security_id_int_3  NUMBER,
61          p_security_id_char_1 VARCHAR2,
62          p_security_id_char_2 VARCHAR2,
63          p_security_id_char_3 VARCHAR2,
64          p_report_request_id  NUMBER);
65 --
66 PROCEDURE postaccounting
67         (p_application_id     NUMBER,
68          p_ledger_id          NUMBER,
69          p_process_category   VARCHAR2,
70          p_end_date           DATE,
71          p_accounting_mode    VARCHAR2,
72          p_valuation_method   VARCHAR2,
73          p_security_id_int_1  NUMBER,
74          p_security_id_int_2  NUMBER,
75          p_security_id_int_3  NUMBER,
76          p_security_id_char_1 VARCHAR2,
77          p_security_id_char_2 VARCHAR2,
78          p_security_id_char_3 VARCHAR2,
79          p_report_request_id  NUMBER);
80 --
81 PROCEDURE extract
82         (p_application_id     NUMBER,
83          p_accounting_mode    VARCHAR2);
84 --
85 PROCEDURE delete_event
86 	(i_assignment_action_id NUMBER);
87 --
88 PROCEDURE create_custom_adrs;
89 --
90 END pay_sla_pkg;