DBA Data[Home] [Help]

PACKAGE: APPS.IGI_RPI_UPDATE_LINES_C_PKG

Source


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