PACKAGE: APPS.GL_CONS_BATCHES_PKG

Source

1 PACKAGE GL_CONS_BATCHES_PKG AUTHID CURRENT_USER as
2 /* $Header: glicobts.pls 120.5 2005/12/07 08:29:56 mikeward ship $ */
3 --
4 -- Package
5 --   gl_cons_batches_pkg
6 -- Purpose
7 --   Package procedures for Consolidation RUN form,
8 --     BATCHES block
9 -- History
10 --   20-APR-94	E Wilson	Created
11 --   25-JAN-95	C Schalk	Modifed to accept Batch_Query_Options
12 --   10-MAR-95	C Schalk	Added GL_CONS_DELETE_BATCH. Renamed
13 --				Insert_Cons_Batches to Insert_Cons
14 --				_Batch.
15 --   05-22-95   C Schalk        Added 'And Actual_Flag = 'A'' for 276779
16 
17 --
18 
19   --
20   -- Procedure
21   --   Insert_Consolidation_Batches
22   -- Purpose
23   --   Insert records into GL_CONS_BATCHES for new consolidation
24   -- Arguments
25   --   batch_query_options
26   --   consolidation_id
27   --   consolidation_run_id
28   --   last_updated_by
29   -- Example
30   --   GL_CONS_BATCHES_PKG.Insert_Consolidation_Batches(
31   --                   :SELECT_BATCHES.batch_query_options,
32   --                   :SUBMIT.consolidation_id,
33   --                   :SUBMIT.consolidation_run_id,
34   --                   :SUBMIT.last_updated_by,
35   --                   :SUBMIT.to_ledger_id,
36   --                   :SUBMIT.from_ledger_id,
37   --                   :SUBMIT.from_period_name);
38   -- Notes
39   --
40   FUNCTION Insert_Consolidation_Batches(
41 		X_Batch_Query_Options_Flag	VARCHAR2,
42 		X_Consolidation_Id		NUMBER,
43 		X_Consolidation_Run_Id		NUMBER,
44 		X_Last_Updated_By		NUMBER,
45 		X_From_Ledger_Id		NUMBER,
46 		X_To_Ledger_Id			NUMBER,
47 		X_Default_Period_Name		VARCHAR2,
48 		X_Currency_Code			VARCHAR2) RETURN BOOLEAN;
49 
50   --
51   -- Procedure
52   --   Insert_Cons_Batch
53   -- Purpose
54   --   Insert batch selected for consolidation into GL_CONS_BATCHES
55   -- Arguments
56   --   consolidation_id
57   --   consolidation_run_id
58   --   je_batch_id
59   --   user_id
60   -- Example
61   --   GL_CONS_BATCHES_PKG.Insert_Cons_Batch(
62   --              :SUBMIT.consolidation_id,
63   --              :SUBMIT.consolidation_run_id,
64   --              :BATCHES.je_batch_id,
65   --               fnd_profile.value('USER_ID'))
66   -- Notes
67   --
68   PROCEDURE Insert_Cons_Batch(
69 		X_Consolidation_Id		NUMBER,
70 		X_Consolidation_Run_Id		NUMBER,
71 		X_Je_Batch_Id			NUMBER,
72 		X_User_Id			NUMBER);
73 
74   --
75   -- Procedure
76   --   Delete_Cons_Batch
77   -- Purpose
78   --   Delete a single batch selected rom GL_CONS_BATCHES.
79   --   It is called when for a marked record that is not consolidated
80   --   but inserted into GL_CONS_BATCHES because the selected_all_before
81   --   flag is set.
82   --
83   -- Arguments
84   --   je_batch_id
85   -- Example
86   --   GL_CONS_BATCHES_PKG.Delete_Cons_Batch(
87   --              :BATCHES.je_batch_id,
88   --               )
89   -- Notes
90   --
91   PROCEDURE Delete_Cons_Batch( X_Je_Batch_Id  NUMBER);
92 
93   --
94   -- Procedure
95   --   Remove_Cons_Run_Batches
96   -- Purpose
97   --   Remove all rows in gl_cons_batches for the specified
98   --   consolidation_run_id. This is a concurrent program.
99   -- Arguments
100   --   p_consolidation_run_id
101   -- Example
102   --   GL_CONS_BATCHES_PKG.Remove_Cons_Run_Batches(
103   --              x_errbuf,
104   --              x_retcode,
105   --              cons_run_id
106   --   )
107   -- Notes
108   --
109   PROCEDURE Remove_Cons_Run_Batches(
110     x_errbuf        OUT NOCOPY VARCHAR2,
111     x_retcode       OUT NOCOPY VARCHAR2,
112     p_consolidation_run_id     NUMBER);
113 
114 END GL_CONS_BATCHES_PKG;