1 PACKAGE IGS_FI_PRC_BALANCES AS
2 /* $Header: IGSFI57S.pls 120.0 2005/06/01 14:30:31 appldev noship $ */
3
4 ------------------------------------------------------------------
5 --Created by : Sanil Madathil, Oracle IDC
6 --Date created: 27052001
7 --
8 --Purpose: Package specification contains definition of procedures
9 -- calc_balances and calculate_balances
10 --
11 --
12 --
13 --Known limitations/enhancements and/or remarks:
14 --
15 --Change History:
16 --Who When What
17 --pathipat 08-OCT-2002 Enh# 2562745 Added new procedures convert_holds_balances() and
18 -- conv_balances() for new concurrent program, Holds Conversion.
19 --vvutukur 04-Oct-2002 Enh#2562745.Added new parametre p_balance_rule_id to the generic function
20 -- check_exclusion_rules,removed existing calculate_balance procedure and
21 -- existing calculate_balance_1 local function in package body is renamed
22 -- as a public procedure calculate_balance.
23 --smvk 17-Sep-2002 Removed the parameter p_subaccount_id from the procedures calc_balances,
24 -- calculate_balance and update_balances. As a part of Enh Bug # 2564643.
25 --Nishikant 14DEC2001 A new parameter source_id is added in the procedure
26 -- update_balances for enhancement bug#2124001
27 --Nishikant 10DEC2001 The function check_exclusion_rules added for the
28 -- enhancement bug# 2124001
29 --sykrishn 03october2001 Added a new proc update_balances according to SFCR10
30 --
31 -------------------------------------------------------------------
32
33 PROCEDURE calc_balances ( errbuf OUT NOCOPY VARCHAR2 ,
34 retcode OUT NOCOPY NUMBER ,
35 p_person_id IN igs_pe_person_v.person_id%TYPE ,
36 p_person_id_grp IN igs_pe_persid_group_v.group_id%TYPE ,
37 /* Removed the parameter p_subaccount_id as a part of Bug # 2564643 */
38 p_bal_type IN igs_lookups_view.lookup_code%TYPE ,
39 p_bal_date IN VARCHAR2 ,
40 p_org_id IN NUMBER
41 ) ;
42 PROCEDURE calculate_balance(p_person_id IN igs_pe_person_v.person_id%TYPE,
43 p_balance_type IN igs_lookup_values.lookup_code%TYPE,
44 p_balance_date IN igs_fi_balances.balance_date%TYPE,
45 p_action IN VARCHAR2,
46 p_balance_rule_id IN igs_fi_balance_rules.balance_rule_id%TYPE,
47 p_balance_amount OUT NOCOPY igs_fi_balances.standard_balance%TYPE,
48 p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE
49 );
50
51 PROCEDURE update_balances ( p_party_id IN igs_fi_balances.party_id%TYPE ,
52 /* Removed the parameter p_subaccount_id as a part of Bug # 2564643 */
53 p_balance_type IN igs_lookups_view.lookup_code%TYPE ,
54 p_balance_date IN igs_fi_balances.balance_date%TYPE ,
55 p_amount IN igs_fi_inv_int.invoice_amount%TYPE ,
56 p_source IN VARCHAR2 ,
57 p_source_id IN NUMBER DEFAULT NULL,
58 p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE
59 ) ;
60 FUNCTION check_exclusion_rules (
61 p_balance_type IN igs_fi_balance_rules.balance_name%TYPE ,
62 p_balance_date IN igs_fi_balance_rules.effective_start_date%TYPE,
63 p_source_type IN VARCHAR2 ,
64 p_source_id IN NUMBER ,
65 p_balance_rule_id IN igs_fi_balance_rules.balance_rule_id%TYPE,
66 p_message_name OUT NOCOPY VARCHAR2 ) RETURN BOOLEAN;
67
68 PROCEDURE convert_holds_balances( p_conv_st_date IN igs_fi_balance_rules.last_conversion_date%TYPE );
69
70 PROCEDURE conv_balances ( errbuf OUT NOCOPY VARCHAR2,
71 retcode OUT NOCOPY NUMBER,
72 p_conv_st_date IN VARCHAR2 );
73
74 END IGS_FI_PRC_BALANCES ;