eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_JE_MAPPINGS_PKG dependencies on CE_JE_MAPPINGS

Line 1: PACKAGE BODY CE_JE_MAPPINGS_PKG as

1: PACKAGE BODY CE_JE_MAPPINGS_PKG as
2: /* $Header: cejemcdb.pls 120.1 2006/04/07 06:27:20 svali noship $ */
3: --
4: -- Package
5: -- ce_je_mappings_pkg

Line 5: -- ce_je_mappings_pkg

1: PACKAGE BODY CE_JE_MAPPINGS_PKG as
2: /* $Header: cejemcdb.pls 120.1 2006/04/07 06:27:20 svali noship $ */
3: --
4: -- Package
5: -- ce_je_mappings_pkg
6: -- Purpose
7: -- To contain validation and insertion routines for cb_transaction_codes
8: -- History
9: -- 08-Sept-2004 Sahik Vali Created

Line 30: -- Inserts a row into ce_je_mappings

26: --
27: -- Procedure
28: -- Insert_Row
29: -- Purpose
30: -- Inserts a row into ce_je_mappings
31: -- History
32: -- 08-Sept-2004 Shaik Vali Created
33: -- Arguments
34: -- all the columns of the table CE_JE_MAPPINGS

Line 34: -- all the columns of the table CE_JE_MAPPINGS

30: -- Inserts a row into ce_je_mappings
31: -- History
32: -- 08-Sept-2004 Shaik Vali Created
33: -- Arguments
34: -- all the columns of the table CE_JE_MAPPINGS
35: -- Example
36: -- CE_JE_MAPPINGS_PKG.Insert_Row(....;
37: -- Notes
38: --

Line 36: -- CE_JE_MAPPINGS_PKG.Insert_Row(....;

32: -- 08-Sept-2004 Shaik Vali Created
33: -- Arguments
34: -- all the columns of the table CE_JE_MAPPINGS
35: -- Example
36: -- CE_JE_MAPPINGS_PKG.Insert_Row(....;
37: -- Notes
38: --
39: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
40: X_JE_Mapping_Id IN OUT NOCOPY NUMBER,

Line 53: CURSOR C IS SELECT rowid FROM CE_JE_MAPPINGS

49: X_Created_By NUMBER,
50: X_Creation_Date DATE,
51: X_trxn_subtype_code_id NUMBER
52: ) IS
53: CURSOR C IS SELECT rowid FROM CE_JE_MAPPINGS
54: WHERE je_mapping_id = X_JE_Mapping_Id;
55:
56: CURSOR C2 IS SELECT ce_je_mappings_s.nextval FROM sys.dual;
57: --

Line 56: CURSOR C2 IS SELECT ce_je_mappings_s.nextval FROM sys.dual;

52: ) IS
53: CURSOR C IS SELECT rowid FROM CE_JE_MAPPINGS
54: WHERE je_mapping_id = X_JE_Mapping_Id;
55:
56: CURSOR C2 IS SELECT ce_je_mappings_s.nextval FROM sys.dual;
57: --
58: BEGIN
59: -- cep_standard.debug('open c2 ');
60:

Line 66: INSERT INTO CE_JE_MAPPINGS(

62: FETCH C2 INTO X_JE_Mapping_id;
63: CLOSE C2;
64: --
65:
66: INSERT INTO CE_JE_MAPPINGS(
67: je_mapping_id,
68: bank_account_id,
69: trx_code_id,
70: search_string_txt,

Line 108: -- Locks a row into ce_je_mappings

104: --
105: -- Procedure
106: -- Lock_Row
107: -- Purpose
108: -- Locks a row into ce_je_mappings
109: -- History
110: -- 08-Sept-2004 Shaik Vali Created
111: -- Arguments
112: -- all the columns of the table CE_JE_MAPPINGS

Line 112: -- all the columns of the table CE_JE_MAPPINGS

108: -- Locks a row into ce_je_mappings
109: -- History
110: -- 08-Sept-2004 Shaik Vali Created
111: -- Arguments
112: -- all the columns of the table CE_JE_MAPPINGS
113: -- Example
114: -- ce_je_mappings_pkg.Lock_Row(....;
115: -- Notes
116: --

Line 114: -- ce_je_mappings_pkg.Lock_Row(....;

110: -- 08-Sept-2004 Shaik Vali Created
111: -- Arguments
112: -- all the columns of the table CE_JE_MAPPINGS
113: -- Example
114: -- ce_je_mappings_pkg.Lock_Row(....;
115: -- Notes
116: --
117: PROCEDURE Lock_Row(X_Rowid VARCHAR2,
118: X_JE_Mapping_Id NUMBER,

Line 128: FROM CE_JE_MAPPINGS

124: X_trxn_subtype_code_id NUMBER
125: ) IS
126: CURSOR C IS
127: SELECT *
128: FROM CE_JE_MAPPINGS
129: WHERE rowid = X_Rowid
130: FOR UPDATE of JE_Mapping_Id NOWAIT;
131: Recinfo C%ROWTYPE;
132: BEGIN

Line 162: -- Updates a row into ce_je_mappings

158: --
159: -- Procedure
160: -- Update_Row
161: -- Purpose
162: -- Updates a row into ce_je_mappings
163: -- History
164: -- 08-Sept-2004 Shaik Vali Created
165: -- Arguments
166: -- all the columns of the table CE_JE_MAPPINGS

Line 166: -- all the columns of the table CE_JE_MAPPINGS

162: -- Updates a row into ce_je_mappings
163: -- History
164: -- 08-Sept-2004 Shaik Vali Created
165: -- Arguments
166: -- all the columns of the table CE_JE_MAPPINGS
167: -- Example
168: -- ce_je_mappings_pkg.Update_Row(....;
169: -- Notes
170: --

Line 168: -- ce_je_mappings_pkg.Update_Row(....;

164: -- 08-Sept-2004 Shaik Vali Created
165: -- Arguments
166: -- all the columns of the table CE_JE_MAPPINGS
167: -- Example
168: -- ce_je_mappings_pkg.Update_Row(....;
169: -- Notes
170: --
171: PROCEDURE Update_Row(X_Rowid VARCHAR2,
172: X_JE_Mapping_Id NUMBER,

Line 184: UPDATE CE_JE_MAPPINGS

180: X_Last_Update_Login NUMBER,
181: X_trxn_subtype_code_id NUMBER
182: ) IS
183: BEGIN
184: UPDATE CE_JE_MAPPINGS
185: SET
186: je_mapping_id = X_JE_Mapping_Id,
187: bank_account_id = X_Bank_Account_Id,
188: trx_code_id = X_Trx_Code_Id,

Line 207: -- Deletes a row from ce_je_mappings

203:
204: -- Procedure
205: -- Delete_Row
206: -- Purpose
207: -- Deletes a row from ce_je_mappings
208: -- History
209: -- 08-Sept-2004 Shaik Vali Created
210: -- Arguments
211: -- x_rowid Rowid of a row

Line 213: -- ce_je_mappings_pkg.delete_row(...;

209: -- 08-Sept-2004 Shaik Vali Created
210: -- Arguments
211: -- x_rowid Rowid of a row
212: -- Example
213: -- ce_je_mappings_pkg.delete_row(...;
214: -- Notes
215: --
216: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
217: BEGIN

Line 218: DELETE FROM CE_JE_MAPPINGS

214: -- Notes
215: --
216: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
217: BEGIN
218: DELETE FROM CE_JE_MAPPINGS
219: WHERE rowid = X_Rowid;
220: --
221: if (SQL%NOTFOUND) then
222: Raise NO_DATA_FOUND;

Line 242: -- ce_je_mappings_pkg.check_unique_combination(..;

238: -- X_bank_account_id Bank Account Id
239: -- X_GL_accountccid GL Account ccid
240: -- X_Search_string_txt Search string
241: -- Example
242: -- ce_je_mappings_pkg.check_unique_combination(..;
243: -- Notes
244: --
245:
246:

Line 255: FROM ce_je_mappings jem

251: X_Row_id IN VARCHAR2 ) IS
252: --
253: CURSOR chk_duplicates is
254: SELECT 'Duplicate'
255: FROM ce_je_mappings jem
256: WHERE bank_account_id = X_bank_account_id
257: AND trx_code_id = X_trx_code_id
258: AND ((search_string_txt is null and X_Search_string_txt is null) or
259: (search_string_txt = X_Search_string_txt))

Line 292: END CE_JE_MAPPINGS_PKG;

288: END IF;
289: RAISE;
290: END check_unique_combination;
291:
292: END CE_JE_MAPPINGS_PKG;