[Home] [Help]
PACKAGE: APPS.GL_CONS_BATCHES_PKG
Source
1 PACKAGE GL_CONS_BATCHES_PKG 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;