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_ZZ_AR_TX_ATT_CLS_PKG dependencies on JL_ZZ_AR_TX_ATT_CLS

Line 1: PACKAGE BODY JL_ZZ_AR_TX_ATT_CLS_PKG as

1: PACKAGE BODY JL_ZZ_AR_TX_ATT_CLS_PKG as
2: /* $Header: jlzztclb.pls 120.2 2003/03/03 19:34:03 opedrega ship $ */
3:
4: -- Populate_All_Rows
5:

Line 13: Insert into JL_ZZ_AR_TX_ATT_CLS(attribute_class_id,

9: X_enabled_flag VARCHAR2,
10: X_org_id NUMBER) IS
11:
12: BEGIN
13: Insert into JL_ZZ_AR_TX_ATT_CLS(attribute_class_id,
14: tax_attr_class_type,
15: tax_attr_class_code,
16: tax_category_id,
17: tax_attribute_type,

Line 27: Select JL_ZZ_AR_TX_ATT_CLS_S.nextval,

23: last_updated_by,
24: last_update_login,
25: creation_date,
26: created_by)
27: Select JL_ZZ_AR_TX_ATT_CLS_S.nextval,
28: X_class_type,
29: X_class_code,
30: tcav.tax_category_id,
31: tcav.tax_attribute_type,

Line 66: Insert into JL_ZZ_AR_TX_ATT_CLS(attribute_class_id,

62: X_enabled_flag VARCHAR2,
63: X_org_id NUMBER) IS
64:
65: BEGIN
66: Insert into JL_ZZ_AR_TX_ATT_CLS(attribute_class_id,
67: tax_attr_class_type,
68: tax_attr_class_code,
69: tax_category_id,
70: tax_attribute_type,

Line 80: SELECT JL_ZZ_AR_TX_ATT_CLS_S.nextval,

76: last_updated_by,
77: last_update_login,
78: creation_date,
79: created_by)
80: SELECT JL_ZZ_AR_TX_ATT_CLS_S.nextval,
81: X_class_type,
82: X_class_code,
83: tcav.tax_category_id,
84: tcav.tax_attribute_type,

Line 156: FROM jl_zz_ar_tx_att_cls

152: X_calling_sequence IN VARCHAR2) IS
153:
154: CURSOR C IS
155: SELECT rowid
156: FROM jl_zz_ar_tx_att_cls
157: WHERE tax_attr_class_type = X_tax_attr_class_type
158: AND tax_attr_class_code = X_tax_attr_class_code
159: AND tax_category_id = X_tax_category_id
160: AND tax_attribute_type = X_tax_attribute_type

Line 171: current_calling_sequence := 'JL_ZZ_AR_TX_ATT_CLS_PKG.INSERT_ROW<-' ||

167: BEGIN
168:
169: -- Update the calling sequence
170:
171: current_calling_sequence := 'JL_ZZ_AR_TX_ATT_CLS_PKG.INSERT_ROW<-' ||
172: X_calling_sequence;
173:
174: debug_info := 'Insert into JL_ZZ_AR_TX_ATT_CLS ';
175:

Line 174: debug_info := 'Insert into JL_ZZ_AR_TX_ATT_CLS ';

170:
171: current_calling_sequence := 'JL_ZZ_AR_TX_ATT_CLS_PKG.INSERT_ROW<-' ||
172: X_calling_sequence;
173:
174: debug_info := 'Insert into JL_ZZ_AR_TX_ATT_CLS ';
175:
176: INSERT INTO JL_ZZ_AR_TX_ATT_CLS(attribute_class_id,
177: tax_attr_class_type,
178: tax_attr_class_code,

Line 176: INSERT INTO JL_ZZ_AR_TX_ATT_CLS(attribute_class_id,

172: X_calling_sequence;
173:
174: debug_info := 'Insert into JL_ZZ_AR_TX_ATT_CLS ';
175:
176: INSERT INTO JL_ZZ_AR_TX_ATT_CLS(attribute_class_id,
177: tax_attr_class_type,
178: tax_attr_class_code,
179: tax_category_id,
180: tax_attribute_type,

Line 300: UPDATE JL_ZZ_AR_TX_ATT_CLS

296: X_attribute15 VARCHAR2,
297: X_calling_sequence IN VARCHAR2) IS
298:
299: BEGIN
300: UPDATE JL_ZZ_AR_TX_ATT_CLS
301: SET tax_attr_class_type = X_tax_attr_class_type,
302: tax_attr_class_code = X_tax_attr_class_code,
303: tax_category_id = X_tax_category_id,
304: tax_attribute_type = X_tax_attribute_type,

Line 343: FROM JL_ZZ_AR_TX_ATT_CLS

339: (X_rowid VARCHAR2) IS
340:
341: BEGIN
342: DELETE
343: FROM JL_ZZ_AR_TX_ATT_CLS
344: WHERE rowid = X_rowid;
345:
346: IF (SQL%NOTFOUND) THEN
347: raise NO_DATA_FOUND;

Line 417: FROM JL_ZZ_AR_TX_ATT_CLS

413: ATTRIBUTE12,
414: ATTRIBUTE13,
415: ATTRIBUTE14,
416: ATTRIBUTE15
417: FROM JL_ZZ_AR_TX_ATT_CLS
418: WHERE tax_attr_class_type = X_tax_attr_class_type
419: AND tax_attr_class_code = X_tax_attr_class_code
420: AND tax_category_id = X_tax_category_id
421: AND tax_attribute_type = X_tax_attribute_type

Line 439: current_calling_sequence := 'JL_ZZ_AR_TX_ATT_CLS_PKG.LOCK_ROW<-' ||

435: debug_info VARCHAR2(100);
436:
437: BEGIN
438:
439: current_calling_sequence := 'JL_ZZ_AR_TX_ATT_CLS_PKG.LOCK_ROW<-' ||
440: X_calling_sequence;
441: debug_info := 'Open cursor C';
442: OPEN C;
443: debug_info := 'Fetch cursor C';

Line 568: 'JL_ZZ_AR_TX_ATT_CLS_PKG.CHECK_UNIQUE<-' ||

564: BEGIN
565: -- Update the calling sequence
566: --
567: current_calling_sequence :=
568: 'JL_ZZ_AR_TX_ATT_CLS_PKG.CHECK_UNIQUE<-' ||
569: X_calling_sequence;
570: SELECT COUNT(1)
571: INTO l_dummy
572: FROM JL_ZZ_AR_TX_ATT_CLS

Line 572: FROM JL_ZZ_AR_TX_ATT_CLS

568: 'JL_ZZ_AR_TX_ATT_CLS_PKG.CHECK_UNIQUE<-' ||
569: X_calling_sequence;
570: SELECT COUNT(1)
571: INTO l_dummy
572: FROM JL_ZZ_AR_TX_ATT_CLS
573: WHERE tax_attr_class_type = X_tax_attr_class_type
574: AND tax_attr_class_code = X_tax_attr_class_code
575: AND tax_category_id = X_tax_category_id
576: AND tax_attribute_type = X_tax_attribute_type

Line 615: FROM jl_zz_ar_tx_att_cls attc

611:
612: -- Each class with the same records in the screen.
613: CURSOR c_class IS
614: SELECT tax_attr_class_code
615: FROM jl_zz_ar_tx_att_cls attc
616: WHERE tax_attr_class_type = X_lookup_type
617: AND tax_attr_class_code <> X_lookup_code
618: AND org_id = X_org_id
619: GROUP BY tax_attr_class_code

Line 626: 'JL_ZZ_AR_TX_ATT_CLS_ALL_PKG.CHECK_UNIQUE_DETAIL<-' ||X_calling_sequence;

622: BEGIN
623: -- Update the calling sequence
624: --
625: current_calling_sequence :=
626: 'JL_ZZ_AR_TX_ATT_CLS_ALL_PKG.CHECK_UNIQUE_DETAIL<-' ||X_calling_sequence;
627:
628: X_lookup_code_out := NULL;
629:
630: -- Records in Forms(detail).

Line 633: FROM jl_zz_ar_tx_att_cls jrf

629:
630: -- Records in Forms(detail).
631: SELECT count(1)
632: INTO l_count_cls
633: FROM jl_zz_ar_tx_att_cls jrf
634: WHERE jrf.tax_attr_class_type = X_lookup_type
635: AND jrf.tax_attr_class_code = X_lookup_code
636: AND org_id = X_org_id;
637:

Line 646: FROM jl_zz_ar_tx_att_cls jrf1

642: SELECT jrf1.tax_attr_class_code,
643: count(1)
644: INTO X_lookup_code_out,
645: l_count_other
646: FROM jl_zz_ar_tx_att_cls jrf1
647: WHERE jrf1.tax_attr_class_type = X_lookup_type
648: AND jrf1.tax_attr_class_code = cls_rec.tax_attr_class_code
649: AND org_id = X_org_id
650: AND EXISTS(SELECT '1'

Line 651: FROM jl_zz_ar_tx_att_cls jrf

647: WHERE jrf1.tax_attr_class_type = X_lookup_type
648: AND jrf1.tax_attr_class_code = cls_rec.tax_attr_class_code
649: AND org_id = X_org_id
650: AND EXISTS(SELECT '1'
651: FROM jl_zz_ar_tx_att_cls jrf
652: WHERE jrf.tax_attr_class_type = jrf1.tax_attr_class_type
653: AND jrf.tax_attr_class_code = X_lookup_code
654: AND jrf.tax_category_id = jrf1.tax_category_id
655: AND jrf.tax_attribute_name = jrf1.tax_attribute_name

Line 675: END JL_ZZ_AR_TX_ATT_CLS_PKG;

671: RETURN(l_find);
672: END Check_Unique_Detail;
673:
674:
675: END JL_ZZ_AR_TX_ATT_CLS_PKG;