[Home] [Help]
PACKAGE: APPS.GMF_ALLOC_PROC
Source
1 PACKAGE GMF_ALLOC_PROC AS
2 /* $Header: gmfalocs.pls 120.2.12010000.1 2008/07/30 05:36:47 appldev 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 PROCEDURE delete_interface(v_status OUT NOCOPY NUMBER);
66
67 PROCEDURE cost_allocate(v_from_alloc_code VARCHAR2,
68 v_to_alloc_code VARCHAR2,
69 v_refresh_interface NUMBER,
70 v_status OUT NOCOPY NUMBER);
71
72
73 PROCEDURE get_expenses(v_from_alloc_code VARCHAR2,
74 v_to_alloc_code VARCHAR2);
75
76
77 PROCEDURE insert_alloc_inp(v_alloc_id NUMBER,
78 v_line_no VARCHAR2,
79 v_account_type NUMBER,
80 v_to_segment NUMBER, /* INVCONV sschinch*/
81 v_amount NUMBER);
82
83 PROCEDURE put_alloc_expenses(v_alloc_id NUMBER,
84 v_line_no VARCHAR2,
85 v_from_segment NUMBER, /* INVCONV sschinch */
86 v_to_segment NUMBER, /* INVCONV sschinch */
87 v_balance_type NUMBER,
88 v_ytd_ptd NUMBER,
89 v_account_type NUMBER);
90
91 PROCEDURE get_alloc_basis(v_from_alloc_code VARCHAR2,
92 v_to_alloc_code VARCHAR2);
93
94 PROCEDURE refresh_fixed(v_from_alloc_code VARCHAR2,
95 v_to_alloc_code VARCHAR2);
96
97
98 PROCEDURE process_alloc_dtl(v_from_alloc_code VARCHAR2,
99 v_to_alloc_code VARCHAR2);
100
101 END GMF_ALLOC_PROC;