PACKAGE: APPS.MTL_STATUS_TRX_CONTROL_PKG

Source

1 PACKAGE MTL_STATUS_TRX_CONTROL_PKG AS
2 /* $Header: INVMSTCS.pls 120.1 2005/06/11 11:34:36 appldev  $ */
3 
4 PROCEDURE INSERT_ROW (
5    x_ROWID                      IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2
6   ,p_STATUS_ID              	IN      NUMBER
7   ,p_TRANSACTION_TYPE_ID        IN      NUMBER
8   ,p_IS_ALLOWED                 IN      NUMBER
9   ,p_CREATION_DATE              IN      DATE
10   ,p_CREATED_BY                 IN      NUMBER
11   ,p_LAST_UPDATED_BY            IN      NUMBER
12   ,p_LAST_UPDATE_DATE           IN      DATE
13   ,p_LAST_UPDATE_LOGIN          IN      NUMBER
14   ,p_PROGRAM_APPLICATION_ID     IN      NUMBER
15   ,p_PROGRAM_ID                 IN      NUMBER
16 );
17 
18 PROCEDURE LOCK_ROW (
19    p_STATUS_ID                  IN      NUMBER
20   ,p_TRANSACTION_TYPE_ID        IN      NUMBER
21   ,p_IS_ALLOWED                 IN      NUMBER
22 );
23 
24 PROCEDURE UPDATE_ROW (
25    p_STATUS_ID                  IN      NUMBER
26   ,p_TRANSACTION_TYPE_ID        IN      NUMBER
27   ,p_IS_ALLOWED                 IN      NUMBER
28   ,p_LAST_UPDATED_BY            IN      NUMBER
29   ,p_LAST_UPDATE_DATE           IN      DATE
30   ,p_LAST_UPDATE_LOGIN          IN      NUMBER
31   ,p_PROGRAM_APPLICATION_ID     IN      NUMBER
32   ,p_PROGRAM_ID                 IN      NUMBER
33 );
34 
35 
36 PROCEDURE INSERT_EXTRA_ROWS(
37     p_STATUS_ID                  IN      NUMBER);
38 END MTL_STATUS_TRX_CONTROL_PKG;