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.JL_AR_AR_DOC_LETTER_PKG dependencies on JL_AR_AR_DOC_LETTER

Line 1: PACKAGE BODY JL_AR_AR_DOC_LETTER_PKG as

1: PACKAGE BODY JL_AR_AR_DOC_LETTER_PKG as
2: /* $Header: jlarrdob.pls 120.3 2003/07/11 18:52:23 appradha ship $ */
3:
4: PROCEDURE Insert_Row(X_rowid IN OUT NOCOPY VARCHAR2,
5: X_tax_category_id NUMBER,

Line 38: FROM jl_ar_ar_doc_letter

34: X_ATTRIBUTE15 VARCHAR2,
35: X_calling_sequence IN VARCHAR2
36: ) IS
37: CURSOR C IS SELECT rowid
38: FROM jl_ar_ar_doc_letter
39: WHERE tax_category_id = X_tax_category_id
40: AND org_tax_attribute_name = X_org_tax_attribute_name
41: AND org_tax_attribute_value = X_org_tax_attribute_value
42: AND con_tax_attribute_name = X_con_tax_attribute_name

Line 51: current_calling_sequence := 'JL_AR_AR_DOC_LETTER_PKG.INSERT_ROW<-' ||

47:
48: BEGIN
49: -- Update the calling sequence
50: --
51: current_calling_sequence := 'JL_AR_AR_DOC_LETTER_PKG.INSERT_ROW<-' ||
52: X_calling_sequence;
53: --
54: debug_info := 'Insert into JL_AR_AR_DOC_LETTER';
55: insert into jl_ar_ar_doc_letter(

Line 54: debug_info := 'Insert into JL_AR_AR_DOC_LETTER';

50: --
51: current_calling_sequence := 'JL_AR_AR_DOC_LETTER_PKG.INSERT_ROW<-' ||
52: X_calling_sequence;
53: --
54: debug_info := 'Insert into JL_AR_AR_DOC_LETTER';
55: insert into jl_ar_ar_doc_letter(
56: tax_category_id,
57: org_tax_attribute_name,
58: org_tax_attribute_value,

Line 55: insert into jl_ar_ar_doc_letter(

51: current_calling_sequence := 'JL_AR_AR_DOC_LETTER_PKG.INSERT_ROW<-' ||
52: X_calling_sequence;
53: --
54: debug_info := 'Insert into JL_AR_AR_DOC_LETTER';
55: insert into jl_ar_ar_doc_letter(
56: tax_category_id,
57: org_tax_attribute_name,
58: org_tax_attribute_value,
59: con_tax_attribute_name,

Line 177: FROM jl_ar_ar_doc_letter

173: X_ATTRIBUTE15 VARCHAR2,
174: X_calling_sequence IN VARCHAR2
175: ) IS
176: CURSOR C IS SELECT *
177: FROM jl_ar_ar_doc_letter
178: WHERE tax_category_id = X_tax_category_id
179: AND org_tax_attribute_name = X_org_tax_attribute_name
180: AND org_tax_attribute_value = X_org_tax_attribute_value
181: AND con_tax_attribute_name = X_con_tax_attribute_name

Line 197: current_calling_sequence := 'JL_AR_AR_DOC_LETTER_PKG.LOCK_ROW<-' ||

193:
194: BEGIN
195: -- Update the calling sequence
196: --
197: current_calling_sequence := 'JL_AR_AR_DOC_LETTER_PKG.LOCK_ROW<-' ||
198: X_calling_sequence;
199: debug_info := 'Open cursor C';
200: OPEN C;
201: debug_info := 'Fetch cursor C';

Line 317: UPDATE jl_ar_ar_doc_letter

313: X_calling_sequence IN VARCHAR2
314: ) IS
315:
316: BEGIN
317: UPDATE jl_ar_ar_doc_letter
318: SET tax_category_id = X_tax_category_id,
319: org_tax_attribute_name = X_org_tax_attribute_name,
320: org_tax_attribute_value = X_org_tax_attribute_value,
321: con_tax_attribute_name = X_con_tax_attribute_name,

Line 359: FROM jl_ar_ar_doc_letter

355: PROCEDURE Delete_Row( X_rowid VARCHAR2
356: ) IS
357: BEGIN
358: DELETE
359: FROM jl_ar_ar_doc_letter
360: WHERE rowid = X_rowid;
361:
362: IF (SQL%NOTFOUND)
363: THEN

Line 387: FROM jl_ar_ar_doc_letter

383: current_calling_sequence := 'JL_AR_AR_TX_DOC_LETTER_PKG.CHECK_UNIQUE<-' ||
384: X_calling_sequence;
385: SELECT COUNT(1)
386: INTO l_dummy
387: FROM jl_ar_ar_doc_letter
388: WHERE org_tax_attribute_name = X_org_tax_attribute_name
389: AND org_tax_attribute_value = X_org_tax_attribute_value
390: AND con_tax_attribute_name = X_con_tax_attribute_name
391: AND con_tax_attribute_value = X_con_tax_attribute_value

Line 427: 'JL_AR_AR_DOC_LETTER_PKG.<-CHECK_OVERLAPPED_DATES' ||

423: BEGIN
424: -- Update the calling sequence
425: --
426: current_calling_sequence :=
427: 'JL_AR_AR_DOC_LETTER_PKG.<-CHECK_OVERLAPPED_DATES' ||
428: X_calling_sequence;
429: SELECT COUNT(1)
430: INTO l_dummy
431: FROM jl_ar_ar_doc_letter a

Line 431: FROM jl_ar_ar_doc_letter a

427: 'JL_AR_AR_DOC_LETTER_PKG.<-CHECK_OVERLAPPED_DATES' ||
428: X_calling_sequence;
429: SELECT COUNT(1)
430: INTO l_dummy
431: FROM jl_ar_ar_doc_letter a
432: WHERE a.org_tax_attribute_name = X_org_tax_attribute_name
433: AND a.org_tax_attribute_value = X_org_tax_attribute_value
434: AND a.con_tax_attribute_name = X_con_tax_attribute_name
435: AND a.con_tax_attribute_value = X_con_tax_attribute_value

Line 480: current_calling_sequence := 'JL_AR_AR_DOC_LETTER_PKG.CHECK_GAPS<-' ||

476: debug_info VARCHAR2(100);
477: BEGIN
478: -- Update the calling sequence
479: --
480: current_calling_sequence := 'JL_AR_AR_DOC_LETTER_PKG.CHECK_GAPS<-' ||
481: X_calling_sequence;
482: --
483: -- Check if there is one row with it's end date exactly one day
484: -- less than the current row's start date

Line 488: FROM jl_ar_ar_doc_letter a

484: -- less than the current row's start date
485: --
486: SELECT COUNT(1)
487: INTO l_dummy
488: FROM jl_ar_ar_doc_letter a
489: WHERE a.org_tax_attribute_name = X_org_tax_attribute_name
490: AND a.org_tax_attribute_value = X_org_tax_attribute_value
491: AND a.con_tax_attribute_name = X_con_tax_attribute_name
492: AND a.con_tax_attribute_value = X_con_tax_attribute_value

Line 505: FROM jl_ar_ar_doc_letter a

501: -- the current row's end-date
502: --
503: SELECT COUNT(1)
504: INTO l_dummy1
505: FROM jl_ar_ar_doc_letter a
506: WHERE a.org_tax_attribute_name = X_org_tax_attribute_name
507: AND a.org_tax_attribute_value = X_org_tax_attribute_value
508: AND a.con_tax_attribute_name = X_con_tax_attribute_name
509: AND a.con_tax_attribute_value = X_con_tax_attribute_value

Line 521: FROM jl_ar_ar_doc_letter a

517: THEN
518: BEGIN
519: SELECT COUNT(1)
520: INTO l_dummy2
521: FROM jl_ar_ar_doc_letter a
522: WHERE a.org_tax_attribute_name = X_org_tax_attribute_name
523: AND a.org_tax_attribute_value = X_org_tax_attribute_value
524: AND a.con_tax_attribute_name = X_con_tax_attribute_name
525: AND a.con_tax_attribute_value = X_con_tax_attribute_value

Line 548: END JL_AR_AR_DOC_LETTER_PKG;

544: END;
545: END IF;
546: END Check_Gaps;
547:
548: END JL_AR_AR_DOC_LETTER_PKG;