DBA Data[Home] [Help]

APPS.AP_PBATCH_SET_LINES_PKG dependencies on AP_PBATCH_SET_LINES_PKG

Line 1: PACKAGE BODY AP_PBATCH_SET_LINES_PKG as

1: PACKAGE BODY AP_PBATCH_SET_LINES_PKG as
2: /* $Header: apbsetlb.pls 120.3 2003/09/25 22:34:58 pjena noship $ */
3: /* BUG 2124337 :Parameters X_attribute_category to X_attribute15 added */
4: PROCEDURE Insert_Row(
5: X_Rowid IN OUT NOCOPY VARCHAR2,

Line 68: 'AP_PBATCH_SET_LINES_PKG.INSERT_ROW<-'||X_Calling_Sequence;

64: BEGIN
65: -- Update the calling sequence
66: --
67: current_calling_sequence :=
68: 'AP_PBATCH_SET_LINES_PKG.INSERT_ROW<-'||X_Calling_Sequence;
69:
70: -- Get next batch set line id
71: debug_info := 'Get next Batch set line Id';
72:

Line 279: 'AP_PBATCH_SET_LINES_PKG.LOCK_ROW<-'||X_Calling_Sequence;

275: BEGIN
276: -- Update the calling sequence
277: --
278: current_calling_sequence :=
279: 'AP_PBATCH_SET_LINES_PKG.LOCK_ROW<-'||X_Calling_Sequence;
280:
281: debug_info := 'Open cursor C';
282: OPEN C;
283: debug_info := 'Fetch cursor C';

Line 498: 'AP_PBATCH_SET_LINES_PKG.UPDATE_ROW<-'||X_Calling_Sequence;

494: BEGIN
495: -- Update the calling sequence
496: --
497: current_calling_sequence :=
498: 'AP_PBATCH_SET_LINES_PKG.UPDATE_ROW<-'||X_Calling_Sequence;
499:
500:
501: debug_info := 'Update ap_pbatch_set_lines';
502: UPDATE ap_pbatch_set_lines

Line 581: 'AP_PBATCH_SET_LINES_PKG.DELETE_ROW<-'||X_Calling_Sequence;

577: BEGIN
578: -- Update the calling sequence
579: --
580: current_calling_sequence :=
581: 'AP_PBATCH_SET_LINES_PKG.DELETE_ROW<-'||X_Calling_Sequence;
582:
583: debug_info := 'Delete from ap_pbatch_set_lines';
584: DELETE FROM ap_pbatch_set_lines
585: WHERE rowid = X_Rowid;

Line 615: 'AP_PBATCH_SET_LINES_PKG.CHECK_UNIQUE_RUN<-'||X_Calling_Sequence;

611: BEGIN
612: -- Update the calling sequence
613: --
614: current_calling_sequence :=
615: 'AP_PBATCH_SET_LINES_PKG.CHECK_UNIQUE_RUN<-'||X_Calling_Sequence;
616:
617: debug_info := 'Count for batch run name';
618: select count(1)
619: into dummy

Line 655: 'AP_PBATCH_SET_LINES_PKG.CHECK_UNIQUE_BATCH<-'||X_Calling_Sequence;

651: BEGIN
652: -- Update the calling sequence
653: --
654: current_calling_sequence :=
655: 'AP_PBATCH_SET_LINES_PKG.CHECK_UNIQUE_BATCH<-'||X_Calling_Sequence;
656:
657: debug_info := 'Count for check run name';
658: select count(1)
659: into dummy

Line 682: END AP_PBATCH_SET_LINES_PKG;

678: APP_EXCEPTION.RAISE_EXCEPTION;
679:
680: end Check_Unique_Batch;
681:
682: END AP_PBATCH_SET_LINES_PKG;