APPS.JL_ZZ_AR_TX_FSC_CLS_PKG dependencies on JL_ZZ_AR_TX_FSC_CLS_PKG

Line 1: PACKAGE BODY JL_ZZ_AR_TX_FSC_CLS_PKG as

1: PACKAGE BODY JL_ZZ_AR_TX_FSC_CLS_PKG as
2: /* $Header: jlzztfcb.pls 120.3 2005/02/02 19:12:03 pla ship $ */
3:
4: PROCEDURE Insert_Row
5: (X_Rowid IN OUT NOCOPY VARCHAR2,

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

47:
48: BEGIN
49: -- Update the calling sequence
50: --
51: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.INSERT_ROW<-' ||
52: X_calling_sequence;
53:
54: debug_info := 'Insert into JL_ZZ_AR_TX_FSC_CLS';
55: INSERT INTO JL_ZZ_AR_TX_FSC_CLS (fsc_cls_id,

Line 222: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.LOCK_ROW<-' ||

218:
219: BEGIN
220: -- Update the calling sequence
221: --
222: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.LOCK_ROW<-' ||
223: X_calling_sequence;
224: debug_info := 'Open cursor C';
225: OPEN C;
226: debug_info := 'Fetch cursor C';

Line 365: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.UPDATE_ROW<-' ||

361:
362: BEGIN
363: -- Update the calling sequence
364: --
365: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.UPDATE_ROW<-' ||
366: X_calling_sequence;
367: debug_info := 'Update JL_ZZ_AR_TX_FSC_CLS';
368:
369: UPDATE JL_ZZ_AR_TX_FSC_CLS

Line 430: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.DELETE_ROW<-' ||

426:
427: BEGIN
428: -- Update the calling sequence
429: --
430: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.DELETE_ROW<-' ||
431: X_calling_sequence;
432: debug_info := 'Delete from JL_ZZ_AR_TX_FSC_CLS';
433:
434: DELETE FROM JL_ZZ_AR_TX_FSC_CLS

Line 470: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.CHECK_UNIQUE<-' ||

466:
467: BEGIN
468: -- Update the calling sequence
469: --
470: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.CHECK_UNIQUE<-' ||
471: X_calling_sequence;
472: SELECT COUNT(1)
473: INTO l_dummy
474: FROM jl_zz_ar_tx_fsc_cls

Line 510: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.<-CHECK_OVERLAPPED_DATES' ||

506:
507: BEGIN
508: -- Update the calling sequence
509: --
510: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.<-CHECK_OVERLAPPED_DATES' ||
511: X_calling_sequence;
512: SELECT COUNT(1)
513: INTO l_dummy
514: FROM jl_zz_ar_tx_fsc_cls a

Line 558: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.CHECK_GAPS<-' ||

554:
555: BEGIN
556: -- Update the calling sequence
557: --
558: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.CHECK_GAPS<-' ||
559: X_calling_sequence;
560: --
561: -- Check if there is one row with it's end date exactly one day
562: -- less than the current row's start date

Line 660: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.CREATE_CATEGORY<-' ||

656:
657: BEGIN
658: -- Update the calling sequence
659: --
660: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.CREATE_CATEGORY<-' ||
661: X_calling_sequence;
662:
663: debug_info := 'calling INV_ITEM_CATEGORY_PUB.CREATE_CATEGORY';
664:

Line 796: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.UPDATE_CATEGORY<-' ||

792:
793: BEGIN
794: -- Update the calling sequence
795: --
796: current_calling_sequence := 'JL_ZZ_AR_TX_FSC_CLS_PKG.UPDATE_CATEGORY<-' ||
797: X_calling_sequence;
798:
799: debug_info := 'calling INV_ITEM_CATEGORY_PUB.UPDATE_CATEGORY';
800:

Line 891: END JL_ZZ_AR_TX_FSC_CLS_PKG;

887: APP_EXCEPTION.RAISE_EXCEPTION;
888: END Update_Category;
889:
890:
891: END JL_ZZ_AR_TX_FSC_CLS_PKG;