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.AP_PBATCH_SET_LINES_PKG dependencies on AP_PBATCH_SET_LINES

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 58: CURSOR C IS SELECT rowid FROM ap_pbatch_set_lines

54: X_Vendor_Id NUMBER,
55: X_days_between_check_cycles NUMBER
56: ) IS
57: l_batch_set_line_id NUMBER;
58: CURSOR C IS SELECT rowid FROM ap_pbatch_set_lines
59: WHERE batch_name = X_Batch_Name
60: AND batch_set_line_id = l_Batch_Set_Line_Id;
61: current_calling_sequence VARCHAR2(2000);
62: debug_info VARCHAR2(100);

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 80: select ap_pbatch_set_lines_s.nextval

76: --
77: l_batch_set_line_id := X_Batch_Set_Line_Id;
78:
79: if (l_batch_set_line_id is NULL) then
80: select ap_pbatch_set_lines_s.nextval
81: into l_batch_set_line_id
82: from sys.dual;
83: end if;
84:

Line 85: debug_info := 'Insert into ap_pbatch_set_lines';

81: into l_batch_set_line_id
82: from sys.dual;
83: end if;
84:
85: debug_info := 'Insert into ap_pbatch_set_lines';
86: INSERT INTO ap_pbatch_set_lines (
87: batch_name,
88: batch_set_id,
89: batch_set_line_id,

Line 86: INSERT INTO ap_pbatch_set_lines (

82: from sys.dual;
83: end if;
84:
85: debug_info := 'Insert into ap_pbatch_set_lines';
86: INSERT INTO ap_pbatch_set_lines (
87: batch_name,
88: batch_set_id,
89: batch_set_line_id,
90: include_in_set,

Line 267: FROM ap_pbatch_set_lines

263: X_days_between_check_cycles NUMBER
264: ) IS
265: CURSOR C IS
266: SELECT *
267: FROM ap_pbatch_set_lines
268: WHERE rowid = X_Rowid
269: FOR UPDATE of Batch_Name NOWAIT;
270: Recinfo C%ROWTYPE;
271: current_calling_sequence VARCHAR2(2000);

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 501: debug_info := 'Update ap_pbatch_set_lines';

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
503: SET
504: batch_name = X_Batch_Name,
505: batch_set_id = X_Batch_Set_Id,

Line 502: UPDATE ap_pbatch_set_lines

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
503: SET
504: batch_name = X_Batch_Name,
505: batch_set_id = X_Batch_Set_Id,
506: batch_set_line_id = X_Batch_Set_Line_Id,

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 583: debug_info := 'Delete from ap_pbatch_set_lines';

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;
586:
587: if (SQL%NOTFOUND) then

Line 584: DELETE FROM ap_pbatch_set_lines

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;
586:
587: if (SQL%NOTFOUND) then
588: Raise NO_DATA_FOUND;

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;