DBA Data[Home] [Help]

PACKAGE: APPS.IGI_RPI_UPDATE_LINES_D_PKG

Source


1 PACKAGE IGI_RPI_UPDATE_LINES_D_PKG as
2 --- $Header: igirulds.pls 120.4.12000000.1 2007/08/31 05:53:55 mbremkum ship $
3   PROCEDURE Insert_Row(
4       X_Rowid                   IN OUT NOCOPY VARCHAR2,
5       X_run_id         	        NUMBER,
6       X_standing_charge_id      NUMBER,
7       X_line_item_id         	NUMBER,
8       X_item_id                 NUMBER,
9       X_price                   NUMBER,
10       X_effective_date          DATE,
11       X_revised_price           NUMBER,
12       X_revised_effective_date  DATE,
13       X_previous_price          NUMBER,
14       X_previous_effective_date DATE,
15       X_updated_price           NUMBER,
16       X_select_flag             VARCHAR2,
17       X_Created_By              NUMBER,
18       X_Creation_Date           DATE,
19       X_Last_Updated_By         NUMBER,
20       X_Last_Update_Date        DATE,
21       X_Last_Update_Login       NUMBER
22   );
23 
24   PROCEDURE Lock_Row(
25       X_Rowid                   IN OUT NOCOPY VARCHAR2,
26       X_run_id         	        NUMBER,
27       X_standing_charge_id      NUMBER,
28       X_line_item_id         	NUMBER,
29       X_item_id                 NUMBER,
30       X_price                   NUMBER,
31       X_effective_date          DATE,
32       X_revised_price           NUMBER,
33       X_revised_effective_date  DATE,
34       X_previous_price          NUMBER,
35       X_previous_effective_date DATE,
36       X_updated_price           NUMBER,
37       X_select_flag             VARCHAR2
38   );
39 
40   PROCEDURE Update_Row(
41       X_Rowid                   IN OUT NOCOPY VARCHAR2,
42       X_run_id         	        NUMBER,
43       X_standing_charge_id      NUMBER,
44       X_line_item_id         	NUMBER,
45       X_item_id                 NUMBER,
46       X_price                   NUMBER,
47       X_effective_date          DATE,
48       X_revised_price           NUMBER,
49       X_revised_effective_date  DATE,
50       X_previous_price          NUMBER,
51       X_previous_effective_date DATE,
52       X_updated_price           NUMBER,
53       X_select_flag             VARCHAR2,
54       X_Last_Updated_By         NUMBER,
55       X_Last_Update_Date        DATE,
56       X_Last_Update_Login       NUMBER
57   );
58 
59   PROCEDURE Delete_Row(X_Rowid VARCHAR2);
60 
61 
62 END IGI_RPI_UPDATE_LINES_D_PKG;