APPS.JE_IT_EXEMPT_LETTERS_PKG dependencies on JE_IT_EXEMPT_LETTERS

Line 1: PACKAGE BODY JE_IT_EXEMPT_LETTERS_PKG as

1: PACKAGE BODY JE_IT_EXEMPT_LETTERS_PKG as
2: /* $Header: jeitexlb.pls 120.6 2006/05/31 05:44:38 samalhot ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Legal_Entity_Id NUMBER,

Line 24: CURSOR C IS SELECT rowid FROM JE_IT_EXEMPT_LETTERS

20: X_Last_Updated_By NUMBER,
21: X_Creation_Date DATE,
22: X_Created_By NUMBER
23: ) IS
24: CURSOR C IS SELECT rowid FROM JE_IT_EXEMPT_LETTERS
25: WHERE vendor_id = X_Vendor_Id
26: AND effective_from = X_Effective_From
27: AND effective_to = X_Effective_To;
28:

Line 43: INSERT INTO JE_IT_EXEMPT_LETTERS(

39: declare
40: exchange_rate NUMBER;
41: c_ledger_id NUMBER;
42: begin
43: INSERT INTO JE_IT_EXEMPT_LETTERS(
44: legal_entity_id,
45: set_of_books_id,
46: vendor_id,
47: effective_from,

Line 92: INSERT INTO JE_IT_EXEMPT_LETTERS(

88: exchange_rate := gl_currency_api.get_rate_sql (rledger_rec.ledger_id,
89: rledger_rec.currency_code,NULL,NULL);
90:
91:
92: INSERT INTO JE_IT_EXEMPT_LETTERS(
93: legal_entity_id,
94: set_of_books_id,
95: vendor_id,
96: effective_from,

Line 165: FROM JE_IT_EXEMPT_LETTERS

161: X_Created_By NUMBER
162: ) IS
163: CURSOR C IS
164: SELECT *
165: FROM JE_IT_EXEMPT_LETTERS
166: WHERE rowid = X_Rowid
167: FOR UPDATE of Vendor_Id NOWAIT;
168: Recinfo C%ROWTYPE;
169:

Line 239: update_exemption_letter_id JE_IT_EXEMPT_LETTERS.exemption_letter_id%TYPE;

235: AND relationship_enabled_flag = 'Y' ;
236:
237: BEGIN
238: declare
239: update_exemption_letter_id JE_IT_EXEMPT_LETTERS.exemption_letter_id%TYPE;
240: update_vendor_id JE_IT_EXEMPT_LETTERS.vendor_id%TYPE;
241: exchange_rate NUMBER;
242: c_ledger_id NUMBER;
243: begin

Line 240: update_vendor_id JE_IT_EXEMPT_LETTERS.vendor_id%TYPE;

236:
237: BEGIN
238: declare
239: update_exemption_letter_id JE_IT_EXEMPT_LETTERS.exemption_letter_id%TYPE;
240: update_vendor_id JE_IT_EXEMPT_LETTERS.vendor_id%TYPE;
241: exchange_rate NUMBER;
242: c_ledger_id NUMBER;
243: begin
244: SELECT vendor_id,exemption_letter_id

Line 246: FROM je_it_exempt_letters

242: c_ledger_id NUMBER;
243: begin
244: SELECT vendor_id,exemption_letter_id
245: INTO update_vendor_id, update_exemption_letter_id
246: FROM je_it_exempt_letters
247: WHERE rowid =x_rowid;
248:
249: UPDATE JE_IT_EXEMPT_LETTERS
250: SET

Line 249: UPDATE JE_IT_EXEMPT_LETTERS

245: INTO update_vendor_id, update_exemption_letter_id
246: FROM je_it_exempt_letters
247: WHERE rowid =x_rowid;
248:
249: UPDATE JE_IT_EXEMPT_LETTERS
250: SET
251: legal_entity_id = X_Legal_Entity_Id,
252: set_of_books_id = X_Set_of_Books_Id,
253: vendor_id = X_Vendor_Id,

Line 280: UPDATE JE_IT_EXEMPT_LETTERS

276: -- get exchange rate for the additional ledger currency
277: exchange_rate :=gl_currency_api.get_rate_sql(rledger_rec.ledger_id,
278: rledger_rec.currency_code,NULL,NULL);
279:
280: UPDATE JE_IT_EXEMPT_LETTERS
281: SET
282: legal_entity_id = X_Legal_Entity_Id,
283: set_of_books_id = rledger_rec.ledger_id,
284: vendor_id = X_Vendor_Id,

Line 326: delete_exemption_letter_id JE_IT_EXEMPT_LETTERS.exemption_letter_id%TYPE;

322:
323:
324: BEGIN
325: declare
326: delete_exemption_letter_id JE_IT_EXEMPT_LETTERS.exemption_letter_id%TYPE;
327: delete_vendor_id JE_IT_EXEMPT_LETTERS.vendor_id%TYPE;
328: exchange_rate NUMBER;
329: c_ledger_id NUMBER;
330: begin

Line 327: delete_vendor_id JE_IT_EXEMPT_LETTERS.vendor_id%TYPE;

323:
324: BEGIN
325: declare
326: delete_exemption_letter_id JE_IT_EXEMPT_LETTERS.exemption_letter_id%TYPE;
327: delete_vendor_id JE_IT_EXEMPT_LETTERS.vendor_id%TYPE;
328: exchange_rate NUMBER;
329: c_ledger_id NUMBER;
330: begin
331: SELECT vendor_id,exemption_letter_id

Line 333: FROM je_it_exempt_letters

329: c_ledger_id NUMBER;
330: begin
331: SELECT vendor_id,exemption_letter_id
332: INTO delete_vendor_id, delete_exemption_letter_id
333: FROM je_it_exempt_letters
334: WHERE rowid = x_rowid;
335:
336:
337: DELETE FROM JE_IT_EXEMPT_LETTERS

Line 337: DELETE FROM JE_IT_EXEMPT_LETTERS

333: FROM je_it_exempt_letters
334: WHERE rowid = x_rowid;
335:
336:
337: DELETE FROM JE_IT_EXEMPT_LETTERS
338: WHERE rowid = X_Rowid;
339:
340: FOR rledger_rec IN c_alc_ledger(c_ledger_id)
341: loop

Line 343: DELETE FROM JE_IT_EXEMPT_LETTERS

339:
340: FOR rledger_rec IN c_alc_ledger(c_ledger_id)
341: loop
342:
343: DELETE FROM JE_IT_EXEMPT_LETTERS
344: WHERE set_of_books_id = rledger_rec.ledger_id
345: AND vendor_id = delete_vendor_id
346: AND exemption_letter_id = delete_exemption_letter_id;
347:

Line 356: END JE_IT_EXEMPT_LETTERS_PKG;

352: end;
353: END Delete_Row;
354:
355:
356: END JE_IT_EXEMPT_LETTERS_PKG;