1 package PN_CREATE_ACC AUTHID CURRENT_USER as
2 -- $Header: PNCRACCS.pls 120.1 2010/08/12 10:44:35 acprakas ship $
3
4 -------------------------------------------------------------------
5 -- ( Run as a Conc Process )
6 -------------------------------------------------------------------
7 PROCEDURE CREATE_ACC(
8 errbuf OUT NOCOPY VARCHAR2,
9 retcode OUT NOCOPY VARCHAR2,
10 P_journal_category IN VARCHAR2,
11 p_default_gl_date IN VARCHAR2,
12 P_batch_name IN VARCHAR2,
13 P_start_date IN VARCHAR2,
14 P_end_date IN VARCHAR2,
15 P_low_lease_id IN NUMBER ,
16 P_high_lease_id IN NUMBER ,
17 P_period_name IN VARCHAR2,
18 p_vendor_id IN NUMBER ,
19 p_customer_id IN NUMBER ,
20 P_selection_type IN VARCHAR2,
21 p_gl_transfer_mode IN VARCHAR2,
22 p_submit_journal_import IN VARCHAR2,
23 p_process_days IN VARCHAR2,
24 p_debug_flag IN VARCHAR2,
25 P_validate_account IN VARCHAR2,
26 P_Org_id IN NUMBER
27 );
28
29 PROCEDURE CREATE_AR_ACC (
30 P_journal_category IN VARCHAR2,
31 p_default_gl_date IN VARCHAR2,
32 p_default_period IN VARCHAR2,
33 P_start_date IN VARCHAR2,
34 P_end_date IN VARCHAR2,
35 P_low_lease_id IN NUMBER ,
36 P_high_lease_id IN NUMBER ,
37 P_period_name IN VARCHAR2,
38 p_customer_id IN NUMBER ,
39 P_Org_id IN NUMBER
40 );
41
42 PROCEDURE CREATE_AP_ACC (
43 P_journal_category IN VARCHAR2,
44 p_default_gl_date IN VARCHAR2,
45 p_default_period IN VARCHAR2,
46 P_start_date IN VARCHAR2,
47 P_end_date IN VARCHAR2,
48 P_low_lease_id IN NUMBER ,
49 P_high_lease_id IN NUMBER ,
50 P_period_name IN VARCHAR2,
51 p_vendor_id IN NUMBER ,
52 P_Org_id IN NUMBER
53 );
54
55 FUNCTION GET_ACCOUNTED_AMOUNT(
56 p_amount IN NUMBER,
57 p_functional_currency IN VARCHAR2,
58 p_currency IN VARCHAR2,
59 p_rate IN NUMBER,
60 p_conv_date IN DATE,
61 p_conv_type IN VARCHAR2)
62 RETURN NUMBER;
63
64 procedure distribute_amount(p_payment_item_id IN NUMBER,
65 p_payment_term_id IN NUMBER,
66 p_accounted_amount IN NUMBER,
67 p_export_currency_amount IN NUMBER,
68 p_export_currency_code PN_PAYMENT_ITEMS.export_currency_code%TYPE);
69
70
71 -- End of Package
72 ------------------------------
73 END PN_CREATE_ACC;
[Home] [Help]