[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;