APPS.FUN_RULE_DFF_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 44

                 'SELECT COUNT(1) FROM ' || X_TABLE_NAME || ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID' ,
                  DBMS_SQL.native);

Line: 50

                 'SELECT COUNT(1) FROM ' || X_TABLE_NAME || ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID' ,
                  DBMS_SQL.native);

Line: 66

	FUN_RULE_DFF_PKG.Insert_Row (
                X_TABLE_NAME,
		X_RULE_DETAIL_ID,
		X_ATTRIBUTE_CATEGORY,
		X_ATTRIBUTE1,
		X_ATTRIBUTE2,
		X_ATTRIBUTE3,
		X_ATTRIBUTE4,
		X_ATTRIBUTE5,
		X_ATTRIBUTE6,
		X_ATTRIBUTE7,
		X_ATTRIBUTE8,
		X_ATTRIBUTE9,
		X_ATTRIBUTE10,
		X_ATTRIBUTE11,
		X_ATTRIBUTE12,
		X_ATTRIBUTE13,
		X_ATTRIBUTE14,
		X_ATTRIBUTE15,
		X_RULE_OBJECT_ID);

Line: 87

	   FUN_RULE_DFF_PKG.Update_Row (
                   X_TABLE_NAME,
	           X_RULE_DETAIL_ID,
 	           X_ATTRIBUTE_CATEGORY,
	           X_ATTRIBUTE1,
	           X_ATTRIBUTE2,
	           X_ATTRIBUTE3,
	           X_ATTRIBUTE4,
	           X_ATTRIBUTE5,
	           X_ATTRIBUTE6,
	           X_ATTRIBUTE7,
	           X_ATTRIBUTE8,
	           X_ATTRIBUTE9,
	           X_ATTRIBUTE10,
	           X_ATTRIBUTE11,
	           X_ATTRIBUTE12,
	           X_ATTRIBUTE13,
	           X_ATTRIBUTE14,
                   X_ATTRIBUTE15,
		   X_RULE_OBJECT_ID);

Line: 114

PROCEDURE Insert_Row (
    X_TABLE_NAME                            IN     VARCHAR2,
    X_RULE_DETAIL_ID		            IN     NUMBER,
    X_ATTRIBUTE_CATEGORY	            IN     VARCHAR2,
    X_ATTRIBUTE1			    IN     VARCHAR2,
    X_ATTRIBUTE2			    IN     VARCHAR2,
    X_ATTRIBUTE3			    IN     VARCHAR2,
    X_ATTRIBUTE4			    IN     VARCHAR2,
    X_ATTRIBUTE5			    IN     VARCHAR2,
    X_ATTRIBUTE6			    IN     VARCHAR2,
    X_ATTRIBUTE7			    IN     VARCHAR2,
    X_ATTRIBUTE8			    IN     VARCHAR2,
    X_ATTRIBUTE9			    IN     VARCHAR2,
    X_ATTRIBUTE10			    IN     VARCHAR2,
    X_ATTRIBUTE11			    IN     VARCHAR2,
    X_ATTRIBUTE12			    IN     VARCHAR2,
    X_ATTRIBUTE13			    IN     VARCHAR2,
    X_ATTRIBUTE14			    IN     VARCHAR2,
    X_ATTRIBUTE15			    IN     VARCHAR2,
    X_RULE_OBJECT_ID		            IN     NUMBER
) IS

   destination_cursor INTEGER;

Line: 150

                     'INSERT INTO ' || X_TABLE_NAME ||' ( '||
                     ' RULE_DETAIL_ID, '||
               	     ' ATTRIBUTE_CATEGORY, '||
		     ' ATTRIBUTE1, '||
    	             ' ATTRIBUTE2, '||
	             ' ATTRIBUTE3, '||
	             ' ATTRIBUTE4, '||
	             ' ATTRIBUTE5, '||
	             ' ATTRIBUTE6, '||
	             ' ATTRIBUTE7, '||
	             ' ATTRIBUTE8, '||
	             ' ATTRIBUTE9, '||
       	             ' ATTRIBUTE10, '||
 	             ' ATTRIBUTE11, '||
	             ' ATTRIBUTE12, '||
	             ' ATTRIBUTE13, '||
	             ' ATTRIBUTE14, '||
	             ' ATTRIBUTE15, '||
                     ' CREATED_BY, '||
                     ' CREATION_DATE, '||
                     ' LAST_UPDATE_LOGIN, '||
                     ' LAST_UPDATE_DATE, '||
                     ' LAST_UPDATED_BY, '||
                     ' RULE_OBJECT_ID '||
                     ' ) '||
                     ' VALUES( '||
		     '		:X_RULE_DETAIL_ID , '||
                     '		:X_ATTRIBUTE_CATEGORY , '||
                     '		:X_ATTRIBUTE1, '||
                     '		:X_ATTRIBUTE2, '||
                     '		:X_ATTRIBUTE3, '||
                     '		:X_ATTRIBUTE4, '||
                     '		:X_ATTRIBUTE5, '||
                     '		:X_ATTRIBUTE6, '||
                     '		:X_ATTRIBUTE7, '||
                     '		:X_ATTRIBUTE8, '||
                     '		:X_ATTRIBUTE9, '||
                     '		:X_ATTRIBUTE10, '||
                     '		:X_ATTRIBUTE11, '||
                     '		:X_ATTRIBUTE12, '||
                     '		:X_ATTRIBUTE13, '||
                     '		:X_ATTRIBUTE14, '||
                     '		:X_ATTRIBUTE15, '||
		     '		FUN_RULE_UTILITY_PKG.CREATED_BY, '||
                     '		FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
                     '		FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
                     '		FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
                     '		FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY, '||
                     '		:X_RULE_OBJECT_ID )',
		     DBMS_SQL.native);

Line: 202

                     'INSERT INTO ' || X_TABLE_NAME ||' ( '||
                     ' RULE_DETAIL_ID, '||
               	     ' ATTRIBUTE_CATEGORY, '||
		     ' ATTRIBUTE1, '||
    	             ' ATTRIBUTE2, '||
	             ' ATTRIBUTE3, '||
	             ' ATTRIBUTE4, '||
	             ' ATTRIBUTE5, '||
	             ' ATTRIBUTE6, '||
	             ' ATTRIBUTE7, '||
	             ' ATTRIBUTE8, '||
	             ' ATTRIBUTE9, '||
       	             ' ATTRIBUTE10, '||
 	             ' ATTRIBUTE11, '||
	             ' ATTRIBUTE12, '||
	             ' ATTRIBUTE13, '||
	             ' ATTRIBUTE14, '||
	             ' ATTRIBUTE15, '||
                     ' CREATED_BY, '||
                     ' CREATION_DATE, '||
                     ' LAST_UPDATE_LOGIN, '||
                     ' LAST_UPDATE_DATE, '||
                     ' LAST_UPDATED_BY '||
                     ' ) '||
                     ' VALUES( '||
		     '		:X_RULE_DETAIL_ID , '||
                     '		:X_ATTRIBUTE_CATEGORY , '||
                     '		:X_ATTRIBUTE1, '||
                     '		:X_ATTRIBUTE2, '||
                     '		:X_ATTRIBUTE3, '||
                     '		:X_ATTRIBUTE4, '||
                     '		:X_ATTRIBUTE5, '||
                     '		:X_ATTRIBUTE6, '||
                     '		:X_ATTRIBUTE7, '||
                     '		:X_ATTRIBUTE8, '||
                     '		:X_ATTRIBUTE9, '||
                     '		:X_ATTRIBUTE10, '||
                     '		:X_ATTRIBUTE11, '||
                     '		:X_ATTRIBUTE12, '||
                     '		:X_ATTRIBUTE13, '||
                     '		:X_ATTRIBUTE14, '||
                     '		:X_ATTRIBUTE15, '||
		     '		FUN_RULE_UTILITY_PKG.CREATED_BY, '||
                     '		FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
                     '		FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
                     '		FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
                     '		FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY )',
		     DBMS_SQL.native);

Line: 285

END Insert_Row;

Line: 287

PROCEDURE Update_Row (
    X_TABLE_NAME                            IN     VARCHAR2,
    X_RULE_DETAIL_ID		            IN     NUMBER,
    X_ATTRIBUTE_CATEGORY	            IN     VARCHAR2,
    X_ATTRIBUTE1			    IN     VARCHAR2,
    X_ATTRIBUTE2			    IN     VARCHAR2,
    X_ATTRIBUTE3			    IN     VARCHAR2,
    X_ATTRIBUTE4			    IN     VARCHAR2,
    X_ATTRIBUTE5			    IN     VARCHAR2,
    X_ATTRIBUTE6			    IN     VARCHAR2,
    X_ATTRIBUTE7			    IN     VARCHAR2,
    X_ATTRIBUTE8			    IN     VARCHAR2,
    X_ATTRIBUTE9			    IN     VARCHAR2,
    X_ATTRIBUTE10			    IN     VARCHAR2,
    X_ATTRIBUTE11			    IN     VARCHAR2,
    X_ATTRIBUTE12			    IN     VARCHAR2,
    X_ATTRIBUTE13			    IN     VARCHAR2,
    X_ATTRIBUTE14			    IN     VARCHAR2,
    X_ATTRIBUTE15			    IN     VARCHAR2,
    X_RULE_OBJECT_ID		            IN     NUMBER
) IS

   destination_cursor INTEGER;

Line: 323

                     'UPDATE ' || X_TABLE_NAME ||' SET '||
                     '    ATTRIBUTE_CATEGORY = :X_ATTRIBUTE_CATEGORY, '||
                     '    ATTRIBUTE1 = :X_ATTRIBUTE1, '||
                     '    ATTRIBUTE2 = :X_ATTRIBUTE2, '||
                     '    ATTRIBUTE3 = :X_ATTRIBUTE3, '||
                     '    ATTRIBUTE4 = :X_ATTRIBUTE4, '||
                     '    ATTRIBUTE5 = :X_ATTRIBUTE5, '||
                     '    ATTRIBUTE6 = :X_ATTRIBUTE6, '||
                     '    ATTRIBUTE7 = :X_ATTRIBUTE7, '||
                     '    ATTRIBUTE8 = :X_ATTRIBUTE8, '||
                     '    ATTRIBUTE9 = :X_ATTRIBUTE9, '||
                     '    ATTRIBUTE10 = :X_ATTRIBUTE10, '||
                     '    ATTRIBUTE11 = :X_ATTRIBUTE11, '||
                     '    ATTRIBUTE12 = :X_ATTRIBUTE12, '||
                     '    ATTRIBUTE13 = :X_ATTRIBUTE13, '||
                     '    ATTRIBUTE14 = :X_ATTRIBUTE14, '||
                     '    ATTRIBUTE15 = :X_ATTRIBUTE15, '||
                     '    CREATED_BY = FUN_RULE_UTILITY_PKG.CREATED_BY, '||
                     '    CREATION_DATE = FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
                     '    LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
                     '    LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
                     '    LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY '||
                     ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID',
		    DBMS_SQL.native);

Line: 349

                     'UPDATE ' || X_TABLE_NAME ||' SET '||
                     '    ATTRIBUTE_CATEGORY = :X_ATTRIBUTE_CATEGORY, '||
                     '    ATTRIBUTE1 = :X_ATTRIBUTE1, '||
                     '    ATTRIBUTE2 = :X_ATTRIBUTE2, '||
                     '    ATTRIBUTE3 = :X_ATTRIBUTE3, '||
                     '    ATTRIBUTE4 = :X_ATTRIBUTE4, '||
                     '    ATTRIBUTE5 = :X_ATTRIBUTE5, '||
                     '    ATTRIBUTE6 = :X_ATTRIBUTE6, '||
                     '    ATTRIBUTE7 = :X_ATTRIBUTE7, '||
                     '    ATTRIBUTE8 = :X_ATTRIBUTE8, '||
                     '    ATTRIBUTE9 = :X_ATTRIBUTE9, '||
                     '    ATTRIBUTE10 = :X_ATTRIBUTE10, '||
                     '    ATTRIBUTE11 = :X_ATTRIBUTE11, '||
                     '    ATTRIBUTE12 = :X_ATTRIBUTE12, '||
                     '    ATTRIBUTE13 = :X_ATTRIBUTE13, '||
                     '    ATTRIBUTE14 = :X_ATTRIBUTE14, '||
                     '    ATTRIBUTE15 = :X_ATTRIBUTE15, '||
                     '    CREATED_BY = FUN_RULE_UTILITY_PKG.CREATED_BY, '||
                     '    CREATION_DATE = FUN_RULE_UTILITY_PKG.CREATION_DATE, '||
                     '    LAST_UPDATE_LOGIN = FUN_RULE_UTILITY_PKG.LAST_UPDATE_LOGIN, '||
                     '    LAST_UPDATE_DATE = FUN_RULE_UTILITY_PKG.LAST_UPDATE_DATE, '||
                     '    LAST_UPDATED_BY = FUN_RULE_UTILITY_PKG.LAST_UPDATED_BY '||
                     ' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID',
		    DBMS_SQL.native);

Line: 409

END Update_Row;

Line: 434

    X_LAST_UPDATE_LOGIN                     IN     NUMBER,
    X_LAST_UPDATE_DATE                      IN     DATE,
    X_LAST_UPDATED_BY                       IN     NUMBER,
    X_RULE_OBJECT_ID		            IN     NUMBER
) IS

    CURSOR C IS
        SELECT * FROM FUN_RULE_DFF
        WHERE  RULE_DETAIL_ID = X_RULE_DETAIL_ID
        FOR UPDATE NOWAIT;

Line: 452

        FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

Line: 515

    AND ( ( LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN )
        OR ( ( LAST_UPDATE_LOGIN IS NULL )
            AND (  X_LAST_UPDATE_LOGIN IS NULL ) ) )
    AND ( ( LAST_UPDATE_DATE = X_LAST_UPDATE_DATE )
        OR ( ( LAST_UPDATE_DATE IS NULL )
            AND (  X_LAST_UPDATE_DATE IS NULL ) ) )
    AND ( ( LAST_UPDATED_BY = X_LAST_UPDATED_BY )
        OR ( ( LAST_UPDATED_BY IS NULL )
            AND (  X_LAST_UPDATED_BY IS NULL ) ) )
    ) THEN
        RETURN;

Line: 527

        FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

Line: 555

    X_LAST_UPDATE_LOGIN                     IN     NUMBER,
    X_LAST_UPDATE_DATE                      IN     DATE,
    X_LAST_UPDATED_BY                       IN     NUMBER,
    X_RULE_OBJECT_ID		            IN     NUMBER
) IS

     source_cursor                       INTEGER;

Line: 584

     LAST_UPDATE_LOGIN                   NUMBER;

Line: 585

     LAST_UPDATE_DATE                    DATE;

Line: 586

     LAST_UPDATED_BY                     NUMBER;

Line: 596

           'SELECT * FROM '|| X_TABLE_NAME || ' WHERE  RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID FOR UPDATE NOWAIT',
            DBMS_SQL.native);

Line: 600

           'SELECT * FROM '|| X_TABLE_NAME || ' WHERE  RULE_DETAIL_ID = :X_RULE_DETAIL_ID FOR UPDATE NOWAIT',
            DBMS_SQL.native);

Line: 629

     DBMS_SQL.DEFINE_COLUMN(source_cursor , 20,LAST_UPDATE_LOGIN);

Line: 630

     DBMS_SQL.DEFINE_COLUMN(source_cursor , 21,LAST_UPDATE_DATE);

Line: 631

     DBMS_SQL.DEFINE_COLUMN(source_cursor , 22,LAST_UPDATED_BY);

Line: 697

    AND ( ( LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN )
        OR ( ( LAST_UPDATE_LOGIN IS NULL )
            AND (  X_LAST_UPDATE_LOGIN IS NULL ) ) )
    AND ( ( LAST_UPDATE_DATE = X_LAST_UPDATE_DATE )
        OR ( ( LAST_UPDATE_DATE IS NULL )
            AND (  X_LAST_UPDATE_DATE IS NULL ) ) )
    AND ( ( LAST_UPDATED_BY = X_LAST_UPDATED_BY )
        OR ( ( LAST_UPDATED_BY IS NULL )
            AND (  X_LAST_UPDATED_BY IS NULL ) ) )
    ) THEN
        RETURN;

Line: 709

        FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

Line: 722

PROCEDURE Select_Row (
    X_TABLE_NAME                            IN     VARCHAR2,
    X_RULE_DETAIL_ID			    IN  OUT NOCOPY   NUMBER,
    X_ATTRIBUTE_CATEGORY	            OUT NOCOPY     VARCHAR2,
    X_ATTRIBUTE1			    OUT NOCOPY     VARCHAR2,
    X_ATTRIBUTE2			    OUT NOCOPY     VARCHAR2,
    X_ATTRIBUTE3			    OUT NOCOPY     VARCHAR2,
    X_ATTRIBUTE4			    OUT NOCOPY     VARCHAR2,
    X_ATTRIBUTE5			    OUT NOCOPY     VARCHAR2,
    X_ATTRIBUTE6			    OUT NOCOPY     VARCHAR2,
    X_ATTRIBUTE7			    OUT NOCOPY     VARCHAR2,
    X_ATTRIBUTE8			    OUT NOCOPY     VARCHAR2,
    X_ATTRIBUTE9			    OUT NOCOPY     VARCHAR2,
    X_ATTRIBUTE10			    OUT NOCOPY     VARCHAR2,
    X_ATTRIBUTE11			    OUT NOCOPY     VARCHAR2,
    X_ATTRIBUTE12			    OUT NOCOPY     VARCHAR2,
    X_ATTRIBUTE13			    OUT NOCOPY     VARCHAR2,
    X_ATTRIBUTE14			    OUT NOCOPY     VARCHAR2,
    X_ATTRIBUTE15			    OUT NOCOPY     VARCHAR2,
    X_RULE_OBJECT_ID		            OUT NOCOPY     NUMBER
) IS

l_select_stmt          VARCHAR2(2000);

Line: 760

	l_select_stmt :='SELECT '||
			'  RULE_DETAIL_ID, '||
			'  ATTRIBUTE_CATEGORY, '||
			'  ATTRIBUTE1, '||
			'  ATTRIBUTE2, '||
			'  ATTRIBUTE3, '||
			'  ATTRIBUTE4, '||
			'  ATTRIBUTE5, '||
			'  ATTRIBUTE6, '||
			'  ATTRIBUTE7, '||
			'  ATTRIBUTE8, '||
			'  ATTRIBUTE9, '||
			'  ATTRIBUTE10, '||
			'  ATTRIBUTE11, '||
			'  ATTRIBUTE12, '||
			'  ATTRIBUTE13, '||
			'  ATTRIBUTE14, '||
			'  ATTRIBUTE15 '||
			' FROM '|| X_TABLE_NAME ||
			'  WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID ' ||
			'  AND ROWNUM = 1 ';

Line: 782

	l_select_stmt :='SELECT '||
			'  RULE_DETAIL_ID, '||
			'  ATTRIBUTE_CATEGORY, '||
			'  ATTRIBUTE1, '||
			'  ATTRIBUTE2, '||
			'  ATTRIBUTE3, '||
			'  ATTRIBUTE4, '||
			'  ATTRIBUTE5, '||
			'  ATTRIBUTE6, '||
			'  ATTRIBUTE7, '||
			'  ATTRIBUTE8, '||
			'  ATTRIBUTE9, '||
			'  ATTRIBUTE10, '||
			'  ATTRIBUTE11, '||
			'  ATTRIBUTE12, '||
			'  ATTRIBUTE13, '||
			'  ATTRIBUTE14, '||
			'  ATTRIBUTE15 '||
			' FROM '|| X_TABLE_NAME ||
			'  WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID ' ||
			'  AND ROWNUM = 1 ';

Line: 804

     DBMS_SQL.PARSE(source_cursor,l_select_stmt , DBMS_SQL.native);

Line: 878

END Select_Row;

Line: 880

PROCEDURE Delete_Row (
    X_TABLE_NAME                             IN     VARCHAR2,
    X_RULE_DETAIL_ID	  		     IN     NUMBER,
    X_RULE_OBJECT_ID		             IN     NUMBER
) IS

source_cursor      INTEGER;

Line: 900

      DBMS_SQL.PARSE(source_cursor, 'delete from ' || X_TABLE_NAME ||' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID AND RULE_OBJECT_ID = :X_RULE_OBJECT_ID',
                     DBMS_SQL.native);

Line: 903

      DBMS_SQL.PARSE(source_cursor, 'delete from ' || X_TABLE_NAME ||' WHERE RULE_DETAIL_ID = :X_RULE_DETAIL_ID',
                     DBMS_SQL.native);

Line: 934

END Delete_Row;