PACKAGE: APPS.IGI_EXP_TU_HAND_PKG

Source

1 PACKAGE IGI_EXP_TU_HAND_PKG AUTHID CURRENT_USER AS
2 -- $Header: igiexpis.pls 115.9 2003/07/23 13:56:57 sdixit ship $
3  PROCEDURE Insert_Row( 	X_Rowid IN OUT NOCOPY VARCHAR2,
4 			X_Trans_Unit_Id NUMBER,
5 			X_Doc_Type_Id NUMBER,
6 			X_Trans_Unit_Num VARCHAR2,
7 			X_Trans_Unit_Num_Type VARCHAR2,
8 			X_Trans_Unit_Status VARCHAR2,
9 			X_Amount NUMBER,
10 			X_Creation_Date	DATE,
11 			X_Created_By NUMBER,
12 			X_Last_Update_Login NUMBER,
13 			X_Last_Update_Date DATE,
14 			X_Last_Updated_By NUMBER,
15                         --MOAC changes
16                         X_Org_Id NUMBER);
17 
18  PROCEDURE Lock_Row( 	X_Rowid  VARCHAR2,
19 			X_Trans_Unit_Id NUMBER,
20 			X_Doc_Type_Id NUMBER,
21 			X_Trans_Unit_Num VARCHAR2,
22 			X_Trans_Unit_Num_Type VARCHAR2,
23 			X_Trans_Unit_Status VARCHAR2,
24 			X_Amount NUMBER,
25 			X_Creation_Date	DATE,
26 			X_Created_By NUMBER,
27 			X_Last_Update_Login NUMBER,
28 			X_Last_Update_Date DATE,
29 			X_Last_Updated_By NUMBER);
30 
31  PROCEDURE Update_Row( 	X_Rowid VARCHAR2,
32 			X_Trans_Unit_Id NUMBER,
33 			X_Doc_Type_Id NUMBER,
34 			X_Trans_Unit_Num VARCHAR2,
35 			X_Trans_Unit_Num_Type VARCHAR2,
36 			X_Trans_Unit_Status VARCHAR2,
37 			X_Amount NUMBER,
38 			X_Creation_Date	DATE,
39 			X_Created_By NUMBER,
40 			X_Last_Update_Login NUMBER,
41 			X_Last_Update_Date DATE,
42 			X_Last_Updated_By NUMBER);
43 
44  PROCEDURE Delete_Row( 	X_Rowid VARCHAR2);
45 
46 /* Added the following  procedure for bug 2661438*/
47 
48  PROCEDURE Check_App_Note_Status(p_trans_unit_id IN NUMBER,
49                                  p_username      IN VARCHAR2,
50                                  p_status        OUT NOCOPY VARCHAR2
51                                 );
52 
53 /* Added the following  procedure for bug 2661438*/
54  PROCEDURE Check_Acc_Note_Status(p_trans_unit_id IN NUMBER,
55                                  p_username      IN VARCHAR2,
56                                  p_status        OUT NOCOPY VARCHAR2
57                                 );
58 
59 /* Added the following  procedure for bug 2661438*/
60  PROCEDURE Check_Req_Note_Status(p_trans_unit_id IN NUMBER,
61                                  p_username      IN VARCHAR2,
62                                  p_status        OUT NOCOPY VARCHAR2
63                                 );
64 END IGI_EXP_TU_HAND_PKG;