PACKAGE: APPS.IGS_FI_GEN_007

Source

1 PACKAGE igs_fi_gen_007 AS
2 /* $Header: IGSFI62S.pls 120.0 2005/06/01 16:18:44 appldev noship $ */
3 
4 FUNCTION get_sob_id RETURN NUMBER;
5 PRAGMA restrict_references(get_sob_id,wnds,wnps);
6 
7 FUNCTION get_coa_id RETURN NUMBER;
8 PRAGMA restrict_references(get_coa_id,wnds,wnps);
9 
10 FUNCTION get_gl_shortname RETURN VARCHAR2;
11 PRAGMA restrict_references(get_sob_id,wnds);
12 
13 FUNCTION get_segval_desc(p_value_set_id NUMBER,p_value VARCHAR2) RETURN VARCHAR2;
14 PRAGMA restrict_references(get_segval_desc,wnds);
15 
16 PROCEDURE get_appl_acc(p_cr_activity_id   IN  igs_fi_cr_activities.credit_activity_id%TYPE,
17                        p_invoice_lines_id IN  igs_fi_invln_int.invoice_lines_id%TYPE,
18                        p_dr_gl_ccid       OUT NOCOPY igs_fi_cr_activities.dr_gl_ccid%TYPE,
19                        p_cr_gl_ccid       OUT NOCOPY igs_fi_cr_activities.cr_gl_ccid%TYPE,
20                        p_dr_account_cd    OUT NOCOPY igs_fi_cr_activities.dr_account_cd%TYPE,
21                        p_cr_account_cd    OUT NOCOPY igs_fi_cr_activities.cr_account_cd%TYPE,
22                        p_status           OUT NOCOPY BOOLEAN);
23 
24 FUNCTION get_sum_appl_amnt(p_application_id  igs_fi_applications.application_id%TYPE) RETURN NUMBER;
25 PRAGMA restrict_references(get_sum_appl_amnt,wnds,wnps);
26 
27 PROCEDURE create_application (p_application_id    IN OUT NOCOPY igs_fi_applications.application_id%TYPE,
28                               p_credit_id         IN     igs_fi_applications.credit_id%TYPE,
29                               p_invoice_id        IN     igs_fi_applications.invoice_id%TYPE,
30                               p_amount_apply      IN     igs_fi_applications.amount_applied%TYPE,
31                               p_appl_type         IN     igs_fi_applications.application_type%TYPE,
32                               p_appl_hierarchy_id IN     igs_fi_applications.appl_hierarchy_Id%TYPE,
33                               p_validation        IN     VARCHAR2 DEFAULT 'Y',
34                               p_dr_gl_ccid        OUT NOCOPY    igs_fi_cr_activities.dr_gl_ccid%TYPE,
35                               p_cr_gl_ccid        OUT NOCOPY    igs_fi_cr_activities.cr_gl_ccid%TYPE,
36                               p_dr_account_cd     OUT NOCOPY    igs_fi_cr_activities.dr_account_cd%TYPE,
37                               p_cr_account_cd     OUT NOCOPY    igs_fi_cr_activities.cr_account_cd%TYPE,
38                               p_unapp_amount      OUT NOCOPY    igs_fi_credits_all.unapplied_amount%TYPE,
39                               p_inv_amt_due       OUT NOCOPY    igs_fi_inv_int_all.invoice_amount_due%TYPE,
40                               p_err_msg           OUT NOCOPY    fnd_new_messages.message_name%TYPE,
41                               p_status            OUT NOCOPY    BOOLEAN,
42 			      p_d_gl_date         IN     DATE
43 			      );
44 
45 
46 FUNCTION validate_person(p_person_id igs_pe_person.person_id%TYPE) RETURN VARCHAR2;
47 PRAGMA restrict_references(validate_person,wnds,wnps);
48 
49 FUNCTION get_ccid_concat(p_ccid   IN  NUMBER) RETURN VARCHAR2;
50 PRAGMA restrict_references(get_ccid_concat,wnds,wnps);
51 
52 FUNCTION get_person_id_type RETURN VARCHAR2;
53 PRAGMA restrict_references(get_person_id_type,wnds,wnps);
54 
55 PROCEDURE finp_get_conv_prc_run_ind(p_n_conv_process_run_ind  OUT NOCOPY  igs_fi_control.conv_process_run_ind%TYPE,
56                                     p_v_message_name          OUT NOCOPY  fnd_new_messages.message_name%TYPE);
57 
58 PROCEDURE finp_get_balance_rule (p_v_balance_type          IN  igs_fi_balance_rules.balance_name%TYPE,
59                                  p_v_action                IN  VARCHAR2,
60 				 p_n_balance_rule_id       OUT NOCOPY igs_fi_balance_rules.balance_rule_id%TYPE,
61 				 p_d_last_conversion_date  OUT NOCOPY igs_fi_balance_rules.last_conversion_date%TYPE,
62 				 p_n_version_number        OUT NOCOPY igs_fi_balance_rules.version_number%TYPE );
63 
64 END igs_fi_gen_007;