[Home] [Help]
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;