PACKAGE: APPS.JL_CO_GL_MG_MEDIA_PKG

Source

1 PACKAGE JL_CO_GL_MG_MEDIA_PKG AS
2 /* $Header: jlcogmgs.pls 120.4.12010000.1 2008/07/31 04:23:56 appldev ship $ */
3 
4 
5   /*********************************************************************
6    PROCEDURE
7      get_movement
8 
9    DESCRIPTION
10      Use this procedure to insert transactions and balances from nit
11      tables into jl_co_gl_mg_headers and jl_co_gl_mg_lines tables, for a
12      set of literal/sub-literal, reported_value (called report_group)
13      for a given range of accounts from magnetic media set-up tables
14 
15    PURPOSE:
16      Oracle Applications Rel 11.0
17 
18    PARAMETERS:
19      p_set_of_books_id
20      p_reported_year
21      p_period_start
22      p_period_end
23      p_literal_start
24      p_literal_end
25 
26    HISTORY:
27      23-DEC-1998   Raja Reddy Kappera    Created
28 
29    *********************************************************************/
30 
31 
32   PROCEDURE 	get_movement
33 		(ERRBUF			OUT NOCOPY	VARCHAR2,
34 		 RETCODE		OUT NOCOPY	VARCHAR2,
35  		 p_set_of_books_id 	IN 	gl_sets_of_books.set_of_books_id%TYPE,
36  		 p_reported_year 	IN 	jl_co_gl_mg_literals.reported_year%TYPE,
37                  p_period_start 	IN 	gl_periods.period_num%TYPE,
38 		 p_period_end		IN	gl_periods.period_num%TYPE,
39 		 p_literal_start	IN	jl_co_gl_mg_literals.literal_code%TYPE,
40 		 p_literal_end		IN	jl_co_gl_mg_literals.literal_code%TYPE
41 		);
42 
43 
44   /*********************************************************************
45    PROCEDURE
46      threshold
47 
48    DESCRIPTION
49      Use this procedure to apply Parent Report Grouping Threshold,
50      Literal Threshold and Child Report Grouping Threshold to the rows
51      in jl_co_gl_mg_lines table.
52 
53    PURPOSE:
54      Oracle Applications Rel 11.0
55 
56    PARAMETERS:
57      p_set_of_books_id
58      p_reported_year
59      p_literal_start
60      p_literal_end
61 
62    HISTORY:
63      23-DEC-1998   Raja Reddy Kappera    Created
64 
65    *********************************************************************/
66 
67   PROCEDURE 	threshold
68 		(ERRBUF			OUT NOCOPY	VARCHAR2,
69 		 RETCODE		OUT NOCOPY	VARCHAR2,
70  		 p_set_of_books_id 	IN 	gl_sets_of_books.set_of_books_id%TYPE,
71  		 p_reported_year 	IN 	jl_co_gl_mg_literals.reported_year%TYPE,
72 		 p_literal_start	IN	jl_co_gl_mg_literals.literal_code%TYPE,
73 		 p_literal_end		IN	jl_co_gl_mg_literals.literal_code%TYPE
74 		);
75 
76 
77   /*********************************************************************
78    PROCEDURE
79      generate_mg_media
80 
81    DESCRIPTION
82      Use this procedure to generate magnetic media flat file in standard
83      out directory of application with a file name of "o.request_id.out"
84 
85    PURPOSE:
86      Oracle Applications Rel 11.0
87 
88    PARAMETERS:
89      p_set_of_books_id
90      p_legal_entity_id
91      p_reported_year
92      p_label
93 
94    HISTORY:
95      23-DEC-1998   Raja Reddy Kappera    Created
96 
97    *********************************************************************/
98 
99   PROCEDURE	generate_mg_media
100 		(ERRBUF			OUT NOCOPY	VARCHAR2,
101 		 RETCODE		OUT NOCOPY	VARCHAR2,
102  		 p_set_of_books_id 	IN 	gl_sets_of_books.set_of_books_id%TYPE,
103                  p_legal_entity_id      IN      xle_entity_profiles.legal_entity_id%TYPE,
104  		 p_reported_year 	IN 	jl_co_gl_mg_literals.reported_year%TYPE,
105 		 p_label		IN	VARCHAR2
106 		);
107 
108 
109 END JL_CO_GL_MG_MEDIA_PKG;