APPS.JL_ZZ_AR_TX_NAT_RAT_PKG dependencies on JL_ZZ_AR_TX_NAT_RAT_PKG

Line 1: PACKAGE BODY JL_ZZ_AR_TX_NAT_RAT_PKG AS

1: PACKAGE BODY JL_ZZ_AR_TX_NAT_RAT_PKG AS
2: /* $Header: jlzztnrb.pls 120.3 2003/09/02 22:00:24 opedrega ship $*/
3:
4: PROCEDURE Insert_row
5: (X_rowid IN OUT NOCOPY VARCHAR2,

Line 50: current_calling_sequence := 'JL_ZZ_AR_TX_NAT_RAT_PKG.INSERT_ROW<-' ||

46: current_calling_sequence VARCHAR2(2000);
47: debug_info VARCHAR2(100);
48:
49: BEGIN
50: current_calling_sequence := 'JL_ZZ_AR_TX_NAT_RAT_PKG.INSERT_ROW<-' ||
51: X_calling_sequence;
52: debug_info:= 'Insert into JL_ZZ_AR_TX_NAT_RAT';
53:
54: INSERT INTO JL_ZZ_AR_TX_NAT_RAT(txn_nature_id,

Line 221: current_calling_sequence := 'JL_ZZ_AR_TX_NAT_RAT_PKG.lock_row<-'||

217:
218: BEGIN
219: -- Sequence assigned in form(X_calling_sequence).
220: debug_info := 'Insert into JL_ZZ_AR_TX_NAT_RAT';
221: current_calling_sequence := 'JL_ZZ_AR_TX_NAT_RAT_PKG.lock_row<-'||
222: X_calling_sequence;
223:
224: debug_info := 'Open cursor C';
225: OPEN c;

Line 381: current_calling_sequence := 'JL_ZZ_AR_TX_NAT_RAT_PKG.UPDATE_ROW<-' ||

377: current_calling_sequence VARCHAR2(2000);
378: debug_info VARCHAR2(100);
379:
380: BEGIN
381: current_calling_sequence := 'JL_ZZ_AR_TX_NAT_RAT_PKG.UPDATE_ROW<-' ||
382: X_calling_sequence;
383: debug_info:= 'Update into JL_ZZ_AR_TX_NAT_RAT';
384:
385: UPDATE jl_zz_ar_tx_nat_rat

Line 446: current_calling_sequence := 'JL_ZZ_AR_TX_NAT_RAT_PKG.DELETE_ROW<-' ||

442: current_calling_sequence VARCHAR2(2000);
443: debug_info VARCHAR2(100);
444:
445: BEGIN
446: current_calling_sequence := 'JL_ZZ_AR_TX_NAT_RAT_PKG.DELETE_ROW<-' ||
447: X_calling_sequence;
448: debug_info:= 'Delete into JL_ZZ_AR_TX_NAT_RAT';
449: DELETE FROM jl_zz_ar_tx_nat_rat
450: WHERE rowid = X_rowid;

Line 482: current_calling_sequence := 'JL_ZZ_AR_TX_NAT_RAT_PKG.Check Unique<-' ||

478: current_calling_sequence VARCHAR2(2000);
479: debug_info VARCHAR2(100);
480:
481: BEGIN
482: current_calling_sequence := 'JL_ZZ_AR_TX_NAT_RAT_PKG.Check Unique<-' ||
483: X_calling_sequence;
484:
485: debug_info:= 'Check Unique';
486:

Line 523: current_calling_sequence := 'JL_ZZ_AR_TX_NAT_RAT_PKG.<-CHECK_OVERLAPPED_DATES' ||

519:
520: BEGIN
521: -- Update the calling sequence
522: --
523: current_calling_sequence := 'JL_ZZ_AR_TX_NAT_RAT_PKG.<-CHECK_OVERLAPPED_DATES' ||
524: X_calling_sequence;
525: debug_info:= 'Check Overlapped dates';
526:
527: SELECT COUNT(1)

Line 570: current_calling_sequence := 'JL_ZZ_AR_TX_NAT_RAT_PKG.CHECK_GAPS<-' ||

566:
567: BEGIN
568: -- Update the calling sequence
569: --
570: current_calling_sequence := 'JL_ZZ_AR_TX_NAT_RAT_PKG.CHECK_GAPS<-' ||
571: X_calling_sequence;
572: --
573: -- Check if there is one row with it's end date exactly one day
574: -- less than the current row's start date

Line 627: END JL_ZZ_AR_TX_NAT_RAT_PKG;

623: END;
624: END IF;
625: END Check_Gaps;
626:
627: END JL_ZZ_AR_TX_NAT_RAT_PKG;