DBA Data[Home] [Help]

PACKAGE: APPS.IGI_RPI_UPDATE_HDR_PKG

Source


1 PACKAGE IGI_RPI_UPDATE_HDR_PKG as
2 --- $Header: igiruphs.pls 120.4.12000000.1 2007/08/31 05:54:02 mbremkum ship $
3   PROCEDURE Insert_Row(
4       X_Rowid                IN OUT NOCOPY VARCHAR2,
5 	/*MOAC Impact Bug No 5905216*/
6       X_org_id		     NUMBER,
7       X_run_id         	     NUMBER,
8       X_item_id_from         NUMBER,
9       X_item_id_to           NUMBER,
10       X_effective_date       DATE,
11       X_option_flag          VARCHAR2,
12       X_amount               NUMBER,
13       X_percentage_amount    NUMBER,
14       X_status               VARCHAR2,
15       X_process_id           NUMBER,
16       X_Created_By           NUMBER,
17       X_Creation_Date        DATE,
18       X_Last_Updated_By      NUMBER,
19       X_Last_Update_Date     DATE,
20       X_Last_Update_Login    NUMBER,
21       X_incr_decr_flag	     VARCHAR2
22   );
23 
24   PROCEDURE Lock_Row(
25       X_Rowid                IN OUT NOCOPY VARCHAR2,
26       X_run_id         	     NUMBER,
27       X_item_id_from         NUMBER,
28       X_item_id_to           NUMBER,
29       X_effective_date       DATE,
30       X_option_flag          VARCHAR2,
31       X_amount               NUMBER,
32       X_percentage_amount    NUMBER,
33       X_status               VARCHAR2,
34       X_process_id           NUMBER,
35       X_Incr_decr_flag       VARCHAR2
36   );
37 
38   PROCEDURE Update_Row(
39       X_Rowid                IN OUT NOCOPY VARCHAR2,
40       X_run_id         	     NUMBER,
41       X_item_id_from         NUMBER,
42       X_item_id_to           NUMBER,
43       X_effective_date       DATE,
44       X_option_flag          VARCHAR2,
45       X_amount               NUMBER,
46       X_percentage_amount    NUMBER,
47       X_status               VARCHAR2,
48       X_process_id           NUMBER,
49       X_Last_Updated_By      NUMBER,
50       X_Last_Update_Date     DATE,
51       X_Last_Update_Login    NUMBER,
52       X_Incr_Decr_Flag       VARCHAR2
53 
54   );
55 
56   PROCEDURE Delete_Row(X_Rowid VARCHAR2);
57 
58 
59 END IGI_RPI_UPDATE_HDR_PKG;