[Home] [Help]
PACKAGE: APPS.GMF_ALLOC_PROC
Source
1 PACKAGE GMF_ALLOC_PROC AUTHID CURRENT_USER AS
2 /* $Header: gmfalocs.pls 120.2.12020000.2 2012/07/24 15:10:12 spabolu ship $ */
3
4 /*****************************************************************************
5 * PROCEDURE
6 * cost_alloc_proc
7 *
8 * DESCRIPTION
9 * This procedure allocates the expenses and is the
10 * main call.
11 *
12 * INPUT PARAMETERS
13 *
14 * v_from_alloc_code = From Allocation Code.
15 * v_to_alloc_code = To Allocation Code.
16 * v_refresh_interface = 0 do not refresh the interface table
17 * 1 Refresh the interface table.
18 *
19 * OUTPUT PARAMETERS
20 * errbuf holds the exception information
21 *
22 ******************************************************************************/
23
24 P_fiscal_plcy gmf_fiscal_policies%ROWTYPE; /* To hold fiscal policy information.*/
25
26 C_MODULE CONSTANT VARCHAR2(80) := 'gmf.plsql.cost_alloc_proc';
27 C_LOG_FILE CONSTANT NUMBER(1) := 1;
28 C_OUT_FILE CONSTANT NUMBER(1) := 2;
29
30 TYPE segment_value IS TABLE OF VARCHAR2(255)
31 INDEX BY BINARY_INTEGER;
32
33 /* The variables below are used to stored ROW WHO information.*/
34
35 P_created_by NUMBER DEFAULT fnd_global.user_id;
36 P_login_id NUMBER DEFAULT fnd_global.login_id;
37 P_prog_application_id NUMBER DEFAULT fnd_global.prog_appl_id;
38 P_program_id NUMBER DEFAULT fnd_global.conc_program_id;
39 P_request_id NUMBER DEFAULT fnd_global.conc_request_id;
40
41 /* The variables below are used to hold account key mask information.*/
42
43 P_of_segment_delimeter VARCHAR2(1);
44
45 PROCEDURE cost_alloc_proc(errbuf OUT NOCOPY VARCHAR2,
46 retcode OUT NOCOPY VARCHAR2,
47 p_legal_entity_id IN NUMBER,
48 p_calendar_code IN VARCHAR2,
49 p_period_code IN VARCHAR2,
50 p_cost_type_id IN NUMBER,
51 p_fiscal_year IN VARCHAR2,
52 p_period_num IN NUMBER,
53 v_from_alloc_code IN gl_aloc_mst.alloc_code%TYPE,
54 v_to_alloc_code IN gl_aloc_mst.alloc_code%TYPE,
55 v_refresh_interface IN VARCHAR2
56 );
57
58 PROCEDURE delete_allocations(v_from_alloc_code VARCHAR2,
59 v_to_alloc_code VARCHAR2,
60 v_status OUT NOCOPY NUMBER);
61
62
63 FUNCTION get_legal_entity_details RETURN NUMBER; /* INVCONV sschinch */
64
65 /* bug13803220 passing allocation code parameter */
66 PROCEDURE delete_interface(v_from_alloc_code VARCHAR2,
67 v_to_alloc_code VARCHAR2,
68 v_status OUT NOCOPY NUMBER);
69
70 PROCEDURE cost_allocate(v_from_alloc_code VARCHAR2,
71 v_to_alloc_code VARCHAR2,
72 v_refresh_interface NUMBER,
73 v_status OUT NOCOPY NUMBER);
74
75
76 PROCEDURE get_expenses(v_from_alloc_code VARCHAR2,
77 v_to_alloc_code VARCHAR2);
78
79
80 PROCEDURE insert_alloc_inp(v_alloc_id NUMBER,
81 v_line_no VARCHAR2,
82 v_account_type NUMBER,
83 v_to_segment NUMBER, /* INVCONV sschinch*/
84 v_amount NUMBER);
85
86 PROCEDURE put_alloc_expenses(v_alloc_id NUMBER,
87 v_line_no VARCHAR2,
88 v_from_segment NUMBER, /* INVCONV sschinch */
89 v_to_segment NUMBER, /* INVCONV sschinch */
90 v_balance_type NUMBER,
91 v_ytd_ptd NUMBER,
92 v_account_type NUMBER);
93
94 PROCEDURE get_alloc_basis(v_from_alloc_code VARCHAR2,
95 v_to_alloc_code VARCHAR2);
96
97 PROCEDURE refresh_fixed(v_from_alloc_code VARCHAR2,
98 v_to_alloc_code VARCHAR2);
99
100
101 PROCEDURE process_alloc_dtl(v_from_alloc_code VARCHAR2,
102 v_to_alloc_code VARCHAR2);
103
104 END GMF_ALLOC_PROC;