[Home] [Help]
PACKAGE: APPS.CE_JE_MAPPINGS_PKG
Source
1 PACKAGE CE_JE_MAPPINGS_PKG as
2 /* $Header: cejemcds.pls 120.1 2006/04/07 06:27:14 svali noship $ */
3 --
4 -- Package
5 -- ce_je_mappings_pkg
6 -- Purpose
7 -- To contain validation and insertion routines for ce_je_mappings
8 -- History
9 -- 08-Sept-2004 Sahik Vali Created
10 G_spec_revision VARCHAR2(1000) := '$Revision: 120.1 $';
11
12 FUNCTION spec_revision RETURN VARCHAR2;
13
14 FUNCTION body_revision RETURN VARCHAR2;
15
16 --
17 -- Procedure
18 -- Insert_Row
19 -- Purpose
20 -- Inserts a row into ce_je_mappings
21 -- History
22 -- 08-Sept-2004 Shaik Vali Created
23 -- Arguments
24 -- all the columns of the table ce_je_mappings
25 -- Example
26 -- ce_je_mappings_pkg.Insert_Row(....;
27 -- Notes
28 --
29 PROCEDURE Insert_Row( X_Rowid IN OUT NOCOPY VARCHAR2,
30 X_JE_Mapping_Id IN OUT NOCOPY NUMBER,
31 X_Bank_Account_Id NUMBER,
32 X_Trx_Code_Id NUMBER,
33 X_Search_String_txt VARCHAR2,
34 X_GL_Account_CCID NUMBER,
35 X_Reference_txt VARCHAR2,
36 X_Last_Updated_By NUMBER,
37 X_Last_Update_Date DATE,
38 X_Last_Update_Login NUMBER,
39 X_Created_By NUMBER,
40 X_Creation_Date DATE,
41 X_trxn_subtype_code_id NUMBER
42 );
43 --
44 -- Procedure
45 -- Lock_Row
46 -- Purpose
47 -- Locks a row into ce_je_mappings
48 -- History
49 -- 08-Sept-2004 Shaik Vali Created
50 -- Arguments
51 -- all the columns of the table ce_je_mappings
52 -- Example
53 -- ce_je_mappings_pkg.Lock_Row(....;
54 -- Notes
55 --
56 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
57 X_JE_Mapping_Id NUMBER,
58 X_Bank_Account_Id NUMBER,
59 X_Trx_Code_Id NUMBER,
60 X_GL_Account_CCID NUMBER,
61 X_Search_String_txt VARCHAR2,
62 X_Reference_txt VARCHAR2,
63 X_trxn_subtype_code_id NUMBER );
64 --
65 -- Procedure
66 -- Update_Row
67 -- Purpose
68 -- Updates a row into ce_je_mappings
69 -- History
70 -- 08-Sept-2004 Shaik Vali Created
71 -- Arguments
72 -- all the columns of the table ce_je_mappings
73 -- Example
74 -- ce_je_mappings.Update_Row(....;
75 -- Notes
76 --
77 PROCEDURE Update_Row(X_Rowid VARCHAR2,
78 X_JE_Mapping_Id NUMBER,
79 X_Bank_Account_Id NUMBER,
80 X_Trx_Code_Id NUMBER,
81 X_GL_Account_CCID NUMBER,
82 X_Search_String_txt VARCHAR2,
83 X_Reference_txt VARCHAR2,
84 X_Last_Updated_By NUMBER,
85 X_Last_Update_Date DATE,
86 X_Last_Update_Login NUMBER,
87 X_trxn_subtype_code_id NUMBER
88 );
89 --
90 -- Procedure
91 -- Delete_Row
92 -- Purpose
93 -- Deletes a row from ce_je_mappings
94 -- History
95 -- 08-Sept-2004 Shaik Vali Created
96 -- Arguments
97 -- x_rowid Rowid of a row
98 -- Example
99 -- ce_je_mappings_pkg.delete_row();
100 -- Notes
101 --
102 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
103 --
104 -- Procedure
105 -- check_unique_combination
106 -- Purpose
107 -- Checks for uniquness of combination of the Bank account,
108 -- Transaction code,Search string and GL Account before
109 -- insertion and updates for a given mapping
110 -- History
111 -- 08-Sept-2004 Shaik Vali Created
112 -- Arguments
113 -- x_row_id Rowid of a row
114 -- X_trx_code Transaction code of row to be inserted or updated
115 -- X_bank_account_id Bank Account Id
116 -- Example
117 -- ce_je_mappings_pkg.check_unique_combination(
118 -- Notes
119 --
120
121
122 PROCEDURE check_unique_combination( X_bank_account_id IN NUMBER,
123 X_trx_code_id IN NUMBER,
124 X_GL_account_ccid IN NUMBER,
125 X_Search_string_txt VARCHAR2,
126 X_Row_id IN VARCHAR2 );
127
128
129 END CE_JE_MAPPINGS_PKG;