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_RECURRING_PAYMENTS_PKG dependencies on AP_RECURRING_PAYMENTS

Line 1: PACKAGE BODY AP_RECURRING_PAYMENTS_PKG AS

1: PACKAGE BODY AP_RECURRING_PAYMENTS_PKG AS
2: /* $Header: apircupb.pls 120.7.12010000.2 2008/11/20 14:16:08 dcshanmu ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Recurring_Payment_Id IN OUT NOCOPY NUMBER,

Line 109: CURSOR C IS SELECT rowid FROM AP_RECURRING_PAYMENTS

105: X_REMIT_TO_SUPPLIER_SITE VARCHAR2 DEFAULT NULL,
106: X_REMIT_TO_SUPPLIER_SITE_ID NUMBER DEFAULT NULL,
107: X_RELATIONSHIP_ID NUMBER DEFAULT NULL
108: ) IS
109: CURSOR C IS SELECT rowid FROM AP_RECURRING_PAYMENTS
110: WHERE recurring_payment_id = X_Recurring_Payment_Id;
111: CURSOR C2 IS SELECT ap_recurring_payments_s.nextval FROM sys.dual;
112: current_calling_sequence VARCHAR2(2000);
113: debug_info VARCHAR2(100);

Line 111: CURSOR C2 IS SELECT ap_recurring_payments_s.nextval FROM sys.dual;

107: X_RELATIONSHIP_ID NUMBER DEFAULT NULL
108: ) IS
109: CURSOR C IS SELECT rowid FROM AP_RECURRING_PAYMENTS
110: WHERE recurring_payment_id = X_Recurring_Payment_Id;
111: CURSOR C2 IS SELECT ap_recurring_payments_s.nextval FROM sys.dual;
112: current_calling_sequence VARCHAR2(2000);
113: debug_info VARCHAR2(100);
114:
115: BEGIN

Line 119: 'AP_RECURRING_PAYMENTS_PKG.INSERT_ROW<-'||X_calling_sequence;

115: BEGIN
116: -- Update the calling sequence
117: --
118: current_calling_sequence :=
119: 'AP_RECURRING_PAYMENTS_PKG.INSERT_ROW<-'||X_calling_sequence;
120:
121: if (X_Recurring_Payment_Id is NULL) then
122: debug_info := 'Open cursor C2';
123: OPEN C2;

Line 130: debug_info := 'Insert into AP_RECURRING_PAYMENTS';

126: debug_info := 'Close cursor C2';
127: CLOSE C2;
128: end if;
129:
130: debug_info := 'Insert into AP_RECURRING_PAYMENTS';
131: INSERT INTO AP_RECURRING_PAYMENTS(
132: recurring_payment_id,
133: last_update_date,
134: last_updated_by,

Line 131: INSERT INTO AP_RECURRING_PAYMENTS(

127: CLOSE C2;
128: end if;
129:
130: debug_info := 'Insert into AP_RECURRING_PAYMENTS';
131: INSERT INTO AP_RECURRING_PAYMENTS(
132: recurring_payment_id,
133: last_update_date,
134: last_updated_by,
135: creation_date,

Line 469: FROM AP_RECURRING_PAYMENTS

465: X_RELATIONSHIP_ID NUMBER DEFAULT NULL
466: ) IS
467: CURSOR C IS
468: SELECT *
469: FROM AP_RECURRING_PAYMENTS
470: WHERE rowid = X_Rowid
471: FOR UPDATE of Recurring_Payment_Id NOWAIT;
472: Recinfo C%ROWTYPE;
473: current_calling_sequence VARCHAR2(2000);

Line 480: 'AP_RECURRING_PAYMENTS_PKG.LOCK_ROW<-'||X_calling_sequence;

476: BEGIN
477: -- Update the calling sequence
478: --
479: current_calling_sequence :=
480: 'AP_RECURRING_PAYMENTS_PKG.LOCK_ROW<-'||X_calling_sequence;
481:
482: debug_info := 'Open cursor C';
483: OPEN C;
484: debug_info := 'Fetch cursor C';

Line 901: 'AP_RECURRING_PAYMENTS_PKG.UPDATE_ROW<-'||X_calling_sequence;

897: BEGIN
898: -- Update the calling sequence
899: --
900: current_calling_sequence :=
901: 'AP_RECURRING_PAYMENTS_PKG.UPDATE_ROW<-'||X_calling_sequence;
902:
903: debug_info := 'Update AP_RECURRING_PAYMENTS';
904: UPDATE AP_RECURRING_PAYMENTS_ALL
905: SET

Line 903: debug_info := 'Update AP_RECURRING_PAYMENTS';

899: --
900: current_calling_sequence :=
901: 'AP_RECURRING_PAYMENTS_PKG.UPDATE_ROW<-'||X_calling_sequence;
902:
903: debug_info := 'Update AP_RECURRING_PAYMENTS';
904: UPDATE AP_RECURRING_PAYMENTS_ALL
905: SET
906: recurring_payment_id = X_Recurring_Payment_Id,
907: last_update_date = X_Last_Update_Date,

Line 904: UPDATE AP_RECURRING_PAYMENTS_ALL

900: current_calling_sequence :=
901: 'AP_RECURRING_PAYMENTS_PKG.UPDATE_ROW<-'||X_calling_sequence;
902:
903: debug_info := 'Update AP_RECURRING_PAYMENTS';
904: UPDATE AP_RECURRING_PAYMENTS_ALL
905: SET
906: recurring_payment_id = X_Recurring_Payment_Id,
907: last_update_date = X_Last_Update_Date,
908: last_updated_by = X_Last_Updated_By,

Line 1038: 'AP_RECURRING_PAYMENTS_PKG.DELETE_ROW<-'||X_calling_sequence;

1034:
1035: -- Update the calling sequence
1036: --
1037: current_calling_sequence :=
1038: 'AP_RECURRING_PAYMENTS_PKG.DELETE_ROW<-'||X_calling_sequence;
1039:
1040: debug_info := 'Delete from AP_RECURRING_PAYMENTS';
1041: DELETE FROM AP_RECURRING_PAYMENTS_ALL
1042: WHERE rowid = X_Rowid;

Line 1040: debug_info := 'Delete from AP_RECURRING_PAYMENTS';

1036: --
1037: current_calling_sequence :=
1038: 'AP_RECURRING_PAYMENTS_PKG.DELETE_ROW<-'||X_calling_sequence;
1039:
1040: debug_info := 'Delete from AP_RECURRING_PAYMENTS';
1041: DELETE FROM AP_RECURRING_PAYMENTS_ALL
1042: WHERE rowid = X_Rowid;
1043:
1044: if (SQL%NOTFOUND) then

Line 1041: DELETE FROM AP_RECURRING_PAYMENTS_ALL

1037: current_calling_sequence :=
1038: 'AP_RECURRING_PAYMENTS_PKG.DELETE_ROW<-'||X_calling_sequence;
1039:
1040: debug_info := 'Delete from AP_RECURRING_PAYMENTS';
1041: DELETE FROM AP_RECURRING_PAYMENTS_ALL
1042: WHERE rowid = X_Rowid;
1043:
1044: if (SQL%NOTFOUND) then
1045: Raise NO_DATA_FOUND;

Line 1061: END AP_RECURRING_PAYMENTS_PKG;

1057: APP_EXCEPTION.RAISE_EXCEPTION;
1058:
1059: END Delete_Row;
1060:
1061: END AP_RECURRING_PAYMENTS_PKG;