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_CAT_ATT_PKG dependencies on JL_ZZ_AR_TX_CAT_ATT

Line 1: PACKAGE BODY JL_ZZ_AR_TX_CAT_ATT_PKG as

1: PACKAGE BODY JL_ZZ_AR_TX_CAT_ATT_PKG as
2: /* $Header: jlzztatb.pls 120.3 2005/10/30 02:08:56 appldev ship $ */
3:
4: PROCEDURE Insert_Row
5: (X_rowid IN OUT NOCOPY VARCHAR2,

Line 40: FROM jl_zz_ar_tx_cat_att

36: X_calling_sequence IN VARCHAR2) IS
37:
38: CURSOR C IS
39: SELECT rowid
40: FROM jl_zz_ar_tx_cat_att
41: WHERE tax_categ_attr_id = X_tax_categ_attr_id;
42:
43: current_calling_sequence VARCHAR2(2000);
44: debug_info VARCHAR2(100);

Line 49: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_ATT_PKG.INSERT_ROW<-' ||

45:
46: BEGIN
47: -- Update the calling sequence
48: --
49: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_ATT_PKG.INSERT_ROW<-' ||
50: X_calling_sequence;
51:
52: debug_info := 'Insert into JL_ZZ_AR_TX_CAT_ATT';
53: insert into jl_zz_ar_tx_cat_att(tax_categ_attr_id,

Line 52: debug_info := 'Insert into JL_ZZ_AR_TX_CAT_ATT';

48: --
49: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_ATT_PKG.INSERT_ROW<-' ||
50: X_calling_sequence;
51:
52: debug_info := 'Insert into JL_ZZ_AR_TX_CAT_ATT';
53: insert into jl_zz_ar_tx_cat_att(tax_categ_attr_id,
54: tax_category_id,
55: tax_attribute_type,
56: tax_attribute_name,

Line 53: insert into jl_zz_ar_tx_cat_att(tax_categ_attr_id,

49: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_ATT_PKG.INSERT_ROW<-' ||
50: X_calling_sequence;
51:
52: debug_info := 'Insert into JL_ZZ_AR_TX_CAT_ATT';
53: insert into jl_zz_ar_tx_cat_att(tax_categ_attr_id,
54: tax_category_id,
55: tax_attribute_type,
56: tax_attribute_name,
57: mandatory_in_class,

Line 176: FROM jl_zz_ar_tx_cat_att

172: X_calling_sequence IN VARCHAR2) IS
173:
174: CURSOR C IS
175: SELECT *
176: FROM jl_zz_ar_tx_cat_att
177: WHERE tax_categ_attr_id = X_tax_categ_attr_id
178: FOR UPDATE of tax_categ_attr_id
179: NOWAIT;
180:

Line 189: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_ATT_PKG.LOCK_ROW<-' ||

185:
186: BEGIN
187: -- Update the calling sequence
188: --
189: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_ATT_PKG.LOCK_ROW<-' ||
190: X_calling_sequence;
191:
192: debug_info := 'Open cursor C';
193: OPEN C;

Line 335: UPDATE jl_zz_ar_tx_cat_att

331: X_attribute15 VARCHAR2,
332: X_calling_sequence IN VARCHAR2) IS
333:
334: BEGIN
335: UPDATE jl_zz_ar_tx_cat_att
336: SET tax_categ_attr_id = X_tax_categ_attr_id,
337: tax_category_id = X_tax_category_id,
338: tax_attribute_type = X_tax_attribute_type,
339: tax_attribute_name = X_tax_attribute_name,

Line 386: FROM jl_zz_ar_tx_cat_att

382: SELECT tax_category_id,
383: tax_attribute_type,
384: tax_attribute_name,
385: org_id
386: FROM jl_zz_ar_tx_cat_att
387: WHERE rowid = X_rowid;
388:
389: CURSOR c1 IS
390: SELECT rowid

Line 416: FROM jl_zz_ar_tx_cat_att

412: CLOSE c;
413:
414: -- delete the master
415: DELETE
416: FROM jl_zz_ar_tx_cat_att
417: WHERE rowid = X_rowid;
418:
419: IF (SQL%NOTFOUND) THEN
420: raise NO_DATA_FOUND;

Line 439: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_ATT_PKG.CHECK_UNIQUE<-' ||

435:
436: BEGIN
437: -- Update the calling sequence
438: --
439: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_ATT_PKG.CHECK_UNIQUE<-' ||
440: X_calling_sequence;
441:
442: SELECT COUNT(1)
443: INTO l_dummy

Line 444: FROM jl_zz_ar_tx_cat_att

440: X_calling_sequence;
441:
442: SELECT COUNT(1)
443: INTO l_dummy
444: FROM jl_zz_ar_tx_cat_att
445: WHERE tax_category_id = X_tax_category_id
446: AND tax_attribute_type = X_tax_attribute_type
447: AND tax_attribute_name = X_tax_attribute_name
448: AND org_id = X_org_id

Line 479: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_ATT_PKG.CHECK_DETERMINING_FACTOR<-' ||

475:
476: BEGIN
477: -- Update the calling sequence
478: --
479: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_ATT_PKG.CHECK_DETERMINING_FACTOR<-' ||
480: X_calling_sequence;
481: SELECT COUNT(1)
482: INTO l_dummy
483: FROM jl_zz_ar_tx_cat_att

Line 483: FROM jl_zz_ar_tx_cat_att

479: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_ATT_PKG.CHECK_DETERMINING_FACTOR<-' ||
480: X_calling_sequence;
481: SELECT COUNT(1)
482: INTO l_dummy
483: FROM jl_zz_ar_tx_cat_att
484: WHERE tax_category_id = X_tax_category_id
485: AND tax_attribute_type = X_tax_attribute_type
486: AND determining_factor = X_determining_factor
487: AND org_id = X_org_id

Line 515: FROM JL_ZZ_AR_TX_CAT_ATT

511: X_calling_sequence VARCHAR2) IS
512:
513: CURSOR C IS
514: SELECT *
515: FROM JL_ZZ_AR_TX_CAT_ATT
516: WHERE rowid = X_Rowid
517: FOR UPDATE of priority_number
518: NOWAIT;
519:

Line 528: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_ATT_PKG.LOCK_ROW_PRIORITY_NUMBER<-' ||

524:
525: BEGIN
526: -- Update the calling sequence
527: --
528: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_ATT_PKG.LOCK_ROW_PRIORITY_NUMBER<-' ||
529: X_calling_sequence;
530: debug_info := 'Open cursor C';
531: OPEN C;
532: debug_info := 'Fetch cursor C';

Line 585: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_ATT_PKG.UPDATE_ROW_PRIORITY_NUMBER<-' ||

581:
582: BEGIN
583: -- Update the calling sequence
584: --
585: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_ATT_PKG.UPDATE_ROW_PRIORITY_NUMBER<-' ||
586: X_calling_sequence;
587: debug_info := 'Update JL_ZZ_AR_TX_CAT_ATT';
588: UPDATE JL_ZZ_AR_TX_CAT_ATT
589: SET PRIORITY_NUMBER = X_PRIORITY_NUMBER,

Line 587: debug_info := 'Update JL_ZZ_AR_TX_CAT_ATT';

583: -- Update the calling sequence
584: --
585: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_ATT_PKG.UPDATE_ROW_PRIORITY_NUMBER<-' ||
586: X_calling_sequence;
587: debug_info := 'Update JL_ZZ_AR_TX_CAT_ATT';
588: UPDATE JL_ZZ_AR_TX_CAT_ATT
589: SET PRIORITY_NUMBER = X_PRIORITY_NUMBER,
590: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
591: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 588: UPDATE JL_ZZ_AR_TX_CAT_ATT

584: --
585: current_calling_sequence := 'JL_ZZ_AR_TX_CAT_ATT_PKG.UPDATE_ROW_PRIORITY_NUMBER<-' ||
586: X_calling_sequence;
587: debug_info := 'Update JL_ZZ_AR_TX_CAT_ATT';
588: UPDATE JL_ZZ_AR_TX_CAT_ATT
589: SET PRIORITY_NUMBER = X_PRIORITY_NUMBER,
590: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
591: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
592: CREATION_DATE = X_CREATION_DATE,

Line 618: END JL_ZZ_AR_TX_CAT_ATT_PKG;

614: END IF;
615: APP_EXCEPTION.RAISE_EXCEPTION;
616: END Update_Row_Priority_Number;
617:
618: END JL_ZZ_AR_TX_CAT_ATT_PKG;