APPS.FINANCIALS_PURGES_PKG dependencies on FINANCIALS_PURGES

Line 1: PACKAGE BODY FINANCIALS_PURGES_PKG as

1: PACKAGE BODY FINANCIALS_PURGES_PKG as
2: /* $Header: apifipub.pls 120.3.12020000.2 2012/07/06 09:50:48 kpasikan ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5:

Line 73: CURSOR C IS SELECT rowid FROM FINANCIALS_PURGES

69: X_calling_sequence IN VARCHAR2,
70: X_Org_Id NUMBER,
71: X_Pay_Alone VARCHAR2 DEFAULT NULL --bug 14237038 (11i)
72: ) IS
73: CURSOR C IS SELECT rowid FROM FINANCIALS_PURGES
74: WHERE purge_name = X_Purge_Name;
75: current_calling_sequence VARCHAR2(2000);
76: debug_info VARCHAR2(100);
77: BEGIN

Line 81: current_calling_sequence := 'FINANCIALS_PURGES_PKG.INSERT_ROW<-' ||

77: BEGIN
78:
79: -- Update the calling sequence
80: --
81: current_calling_sequence := 'FINANCIALS_PURGES_PKG.INSERT_ROW<-' ||
82: X_calling_sequence;
83:
84:
85: debug_info := 'Insert into FINANCIALS_PURGES';

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

81: current_calling_sequence := 'FINANCIALS_PURGES_PKG.INSERT_ROW<-' ||
82: X_calling_sequence;
83:
84:
85: debug_info := 'Insert into FINANCIALS_PURGES';
86:
87: INSERT INTO FINANCIALS_PURGES(
88:
89: purge_name,

Line 87: INSERT INTO FINANCIALS_PURGES(

83:
84:
85: debug_info := 'Insert into FINANCIALS_PURGES';
86:
87: INSERT INTO FINANCIALS_PURGES(
88:
89: purge_name,
90: creation_date,
91: created_by,

Line 313: FROM FINANCIALS_PURGES

309: X_Org_Id NUMBER
310: ) IS
311: CURSOR C IS
312: SELECT *
313: FROM FINANCIALS_PURGES
314: WHERE rowid = X_Rowid
315: FOR UPDATE of Purge_Name NOWAIT;
316: Recinfo C%ROWTYPE;
317:

Line 324: current_calling_sequence := 'FINANCIALS_PURGES_PKG.LOCK_ROW<-' ||

320:
321: BEGIN
322: -- Update the calling sequence
323: --
324: current_calling_sequence := 'FINANCIALS_PURGES_PKG.LOCK_ROW<-' ||
325: X_calling_sequence;
326:
327: debug_info := 'Open cursor C';
328: OPEN C;

Line 546: current_calling_sequence := 'FINANCIALS_PURGES_PKG.DELETE_ROW<-' ||

542: debug_info VARCHAR2(100);
543: BEGIN
544: -- Update the calling sequence
545: --
546: current_calling_sequence := 'FINANCIALS_PURGES_PKG.DELETE_ROW<-' ||
547: X_calling_sequence;
548:
549: debug_info := 'Delete from FINANCIALS_PURGES';
550: DELETE FROM FINANCIALS_PURGES

Line 549: debug_info := 'Delete from FINANCIALS_PURGES';

545: --
546: current_calling_sequence := 'FINANCIALS_PURGES_PKG.DELETE_ROW<-' ||
547: X_calling_sequence;
548:
549: debug_info := 'Delete from FINANCIALS_PURGES';
550: DELETE FROM FINANCIALS_PURGES
551: WHERE rowid = X_Rowid;
552:
553: if (SQL%NOTFOUND) then

Line 550: DELETE FROM FINANCIALS_PURGES

546: current_calling_sequence := 'FINANCIALS_PURGES_PKG.DELETE_ROW<-' ||
547: X_calling_sequence;
548:
549: debug_info := 'Delete from FINANCIALS_PURGES';
550: DELETE FROM FINANCIALS_PURGES
551: WHERE rowid = X_Rowid;
552:
553: if (SQL%NOTFOUND) then
554: Raise NO_DATA_FOUND;

Line 571: END FINANCIALS_PURGES_PKG;

567:
568: END Delete_Row;
569:
570:
571: END FINANCIALS_PURGES_PKG;