DBA Data[Home] [Help]

PACKAGE: APPS.FA_ADJUSTMENTS_PKG

Source


1 PACKAGE FA_ADJUSTMENTS_PKG as
2 /* $Header: faxiajs.pls 120.2 2005/06/24 17:50:02 yyoon ship $ */
3 
4 
5   PROCEDURE Insert_Row(X_Rowid                   IN OUT NOCOPY VARCHAR2,
6                        X_Transaction_Header_Id          NUMBER,
7                        X_Source_Type_Code               VARCHAR2,
8                        X_Adjustment_Type                VARCHAR2,
9                        X_Debit_Credit_Flag              VARCHAR2,
10                        X_Code_Combination_Id            NUMBER,
11                        X_Book_Type_Code                 VARCHAR2,
12                        X_Asset_Id                       NUMBER,
13                        X_Adjustment_Amount              NUMBER,
14                        X_Distribution_Id                NUMBER DEFAULT NULL,
15                        X_Last_Update_Date               DATE DEFAULT NULL,
16                        X_Last_Updated_By                NUMBER DEFAULT NULL,
17                        X_Last_Update_Login              NUMBER DEFAULT NULL,
18                        X_Annualized_Adjustment          NUMBER DEFAULT NULL,
19                        X_Je_Header_Id                   NUMBER DEFAULT NULL,
20                        X_Je_Line_Num                    NUMBER DEFAULT NULL,
21                        X_Period_Counter_Adjusted        NUMBER,
22                        X_Period_Counter_Created         NUMBER,
23                        X_Asset_Invoice_Id               NUMBER DEFAULT NULL,
24                        X_mrc_sob_type_code             VARCHAR2 DEFAULT 'P',
25 		       X_Calling_Fn			VARCHAR2,
26 		       p_log_level_rec    in      fa_api_types.log_level_rec_type default null
27                       );
28 
29   PROCEDURE Lock_Row(X_Rowid                            VARCHAR2,
30 
31                      X_Transaction_Header_Id            NUMBER,
32                      X_Source_Type_Code                 VARCHAR2,
33                      X_Adjustment_Type                  VARCHAR2,
34                      X_Debit_Credit_Flag                VARCHAR2,
35                      X_Code_Combination_Id              NUMBER,
36                      X_Book_Type_Code                   VARCHAR2,
37                      X_Asset_Id                         NUMBER,
38                      X_Adjustment_Amount                NUMBER,
39                      X_Distribution_Id                  NUMBER DEFAULT NULL,
40                      X_Annualized_Adjustment            NUMBER DEFAULT NULL,
41                      X_Je_Header_Id                     NUMBER DEFAULT NULL,
42                      X_Je_Line_Num                      NUMBER DEFAULT NULL,
43                      X_Period_Counter_Adjusted          NUMBER,
44                      X_Period_Counter_Created           NUMBER,
45                      X_Asset_Invoice_Id                 NUMBER DEFAULT NULL,
46 		     X_Calling_Fn			VARCHAR2,
47 		     p_log_level_rec    in      fa_api_types.log_level_rec_type default null
48                     );
49 
50 
51 
52   PROCEDURE Update_Row(X_Rowid                          VARCHAR2,
53 
54                        X_Transaction_Header_Id          NUMBER,
55                        X_Source_Type_Code               VARCHAR2,
56                        X_Adjustment_Type                VARCHAR2,
57                        X_Debit_Credit_Flag              VARCHAR2,
58                        X_Code_Combination_Id            NUMBER,
59                        X_Book_Type_Code                 VARCHAR2,
60                        X_Asset_Id                       NUMBER,
61                        X_Adjustment_Amount              NUMBER,
62                        X_Distribution_Id                NUMBER,
63                        X_Last_Update_Date               DATE,
64                        X_Last_Updated_By                NUMBER,
65                        X_Last_Update_Login              NUMBER,
66                        X_Annualized_Adjustment          NUMBER,
67                        X_Je_Header_Id                   NUMBER,
68                        X_Je_Line_Num                    NUMBER,
69                        X_Period_Counter_Adjusted        NUMBER,
70                        X_Period_Counter_Created         NUMBER,
71                        X_Asset_Invoice_Id               NUMBER,
72                        X_mrc_sob_type_code             VARCHAR2 DEFAULT 'P',
73 		       X_Calling_Fn			VARCHAR2,
74 		       p_log_level_rec    in      fa_api_types.log_level_rec_type default null
75                       );
76   PROCEDURE Delete_Row(X_Rowid 		VARCHAR2 DEFAULT NULL,
77 			X_Asset_Id	NUMBER DEFAULT NULL,
78                         X_mrc_sob_type_code            VARCHAR2 DEFAULT 'P',
79 			X_Calling_Fn			VARCHAR2,
80 			p_log_level_rec    in      fa_api_types.log_level_rec_type default null);
81 
82 END FA_ADJUSTMENTS_PKG;