APPS.FA_TRANSFER_DETAILS_PKG SQL Statements

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

Line: 4

  PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,
                       X_Transfer_Header_Id             NUMBER,
                       X_Distribution_Id                NUMBER,
                       X_Book_Header_Id                 NUMBER,
			X_Calling_Fn			VARCHAR2
  , p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type) IS
    CURSOR C IS SELECT rowid FROM fa_transfer_details
                 WHERE transfer_header_id = X_Transfer_Header_Id
                 AND   distribution_id = X_Distribution_Id;

Line: 14

       INSERT INTO fa_transfer_details(
              transfer_header_id,
              distribution_id,
              book_header_id
             ) VALUES (
              X_Transfer_Header_Id,
              X_Distribution_Id,
              X_Book_Header_Id
             );

Line: 34

                        calling_fn => 'FA_TRANSFER_DETAILS_PKG.insert_row', p_log_level_rec => p_log_level_rec);

Line: 37

			(Called_Fn => 'FA_TRANSFER_DETAILS_PKG.Insert_Row',
			Calling_Fn => X_Calling_Fn, p_log_level_rec => p_log_level_rec); */

Line: 39

  END Insert_Row;

Line: 48

        SELECT	transfer_header_id,
		distribution_id,
		book_header_id
        FROM   fa_transfer_details
        WHERE  rowid = X_Rowid
        FOR UPDATE of Transfer_Header_Id NOWAIT;

Line: 61

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

Line: 76

  PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
                       X_Transfer_Header_Id             NUMBER,
                       X_Distribution_Id                NUMBER,
                       X_Book_Header_Id                 NUMBER,
			X_Calling_Fn			VARCHAR2

  , p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type) IS
  BEGIN
    UPDATE fa_transfer_details
    SET
       transfer_header_id              =     X_Transfer_Header_Id,
       distribution_id                 =     X_Distribution_Id,
       book_header_id                  =     X_Book_Header_Id
    WHERE rowid = X_Rowid;

Line: 97

                        calling_fn => 'FA_TRANSFER_DETAILS_PKG.update_row', p_log_level_rec => p_log_level_rec);

Line: 100

			(Called_Fn => 'FA_TRANSFER_DETAILS_PKG.Update_Row',
			Calling_Fn => X_Calling_Fn, p_log_level_rec => p_log_level_rec); */

Line: 102

  END Update_Row;

Line: 104

  PROCEDURE Delete_Row(X_Rowid 			VARCHAR2 DEFAULT NULL,
			X_Transfer_Header_Id 	NUMBER DEFAULT NULL,
			X_Calling_Fn			VARCHAR2, p_log_level_rec        IN     FA_API_TYPES.log_level_rec_type) IS
  BEGIN
    if X_Rowid is not null then
    	DELETE FROM fa_transfer_details
    	WHERE rowid = X_Rowid;

Line: 112

	DELETE FROM fa_transfer_details
	WHERE transfer_header_id = X_Transfer_Header_Id;

Line: 124

                        calling_fn => 'FA_TRANSFER_DETAILS_PKG.delete_row', p_log_level_rec => p_log_level_rec);

Line: 127

			(Called_Fn => 'FA_TRANSFER_DETAILS_PKG.Delete_Row',
			Calling_Fn => X_Calling_Fn, p_log_level_rec => p_log_level_rec); */

Line: 129

  END Delete_Row;