PACKAGE: APPS.XLA_GL_TRANSFER_PKG

Source

1 PACKAGE xla_gl_transfer_pkg AS
2 /* $Header: XLACGLXS.pls 120.1 2005/06/03 00:12:32 masada ship $ */
3 
4  -- Cursor to get table, sequence names
5  CURSOR c_get_program_info(P_program_name VARCHAR2) IS
6      SELECT acct_events_table_name, ae_headers_table_name,
7             ae_lines_table_name,
8             ae_encumbrance_table_name,
9             ae_lines_linkid_seq_name,
10             ae_enc_lines_linkid_seq_name,
11             ae_lines_table_alias,
12             ae_enc_table_alias
13       FROM  xla_gl_transfer_program_lines gtl
14      WHERE  gtl.program_name = P_program_name;
15 
16  -- Set of books info.
17  TYPE r_sob_info IS RECORD ( sob_id                NUMBER(15),
18 			     sob_name              VARCHAR2(30),
19 			     sob_curr_code         VARCHAR2(15),
20 			     encum_flag            VARCHAR2(1),
21 			     average_balances_flag VARCHAR2(1),
22 			     legal_entity_id       NUMBER,
23 			     cost_group_id         NUMBER,
24 			     cost_type_id          NUMBER
25 			     );
26  TYPE t_sob_list IS TABLE OF r_sob_info;
27 
28  -- Stores Journal Category
29  TYPE t_ae_category IS TABLE OF VARCHAR2(30)
30    INDEX BY BINARY_INTEGER ;
31 
32  -- Stores the control information for the transfer
33  TYPE r_control_info IS RECORD ( sob_id              NUMBER(15),
34 				 period_name         VARCHAR2(30),
35 				 rec_transferred     NUMBER,
36 				 cnt_transfer_errors NUMBER,
37 				 cnt_acct_errors     NUMBER
38 				 );
39 
40 TYPE t_control_info  IS TABLE OF r_control_info
41   INDEX BY BINARY_INTEGER;
42 
43 g_control_info  t_control_info;
44 
45 -- Returns the summary information for the transfer.
46 FUNCTION get_control_info( p_sob_id         NUMBER,
47 			   p_period_name    VARCHAR2,
48 			   p_error_type     VARCHAR2
49 			  ) RETURN NUMBER;
50 --pragma restrict_references(get_control_info, WNDS, WNPS);
51 PROCEDURE xla_gl_transfer( p_application_id           NUMBER,
52                            p_user_id                  NUMBER,
53 			   p_org_id                   NUMBER,
54                            p_request_id               NUMBER,
55 			   p_program_name             VARCHAR2,
56                            p_selection_type           NUMBER     DEFAULT 1,
57                            p_sob_list                 t_sob_list,
58                            p_batch_name               VARCHAR2   DEFAULT NULL,
59                            p_source_doc_id            NUMBER     DEFAULT NULL,
60                            p_source_document_table    VARCHAR2   DEFAULT NULL,
61                            p_start_date               DATE,
62                            p_end_date                 DATE,
63                            p_journal_category         t_ae_category,
64 			   p_validate_account         VARCHAR2   DEFAULT NULL,
65                            p_gl_transfer_mode         VARCHAR2,
66                            p_submit_journal_import    VARCHAR2   DEFAULT 'Y',
67                            p_summary_journal_entry    VARCHAR2   DEFAULT 'N',
68 			   p_process_days             NUMBER,
69 			   p_batch_desc               VARCHAR2   DEFAULT NULL,
70 			   p_je_desc                  VARCHAR2   DEFAULT NULL,
71 			   p_je_line_desc             VARCHAR2   DEFAULT NULL,
72 			   p_fc_force_flag            BOOLEAN    DEFAULT TRUE,
73                            p_debug_flag               VARCHAR2   DEFAULT 'N'
74   );
75 
76 
77 FUNCTION get_linkid( p_program_name VARCHAR2 ) RETURN NUMBER;
78 END xla_gl_transfer_pkg;