PACKAGE: APPS.HZ_STOCK_MARKETS_PKG

Source

1 PACKAGE HZ_STOCK_MARKETS_PKG AUTHID CURRENT_USER as
2 /* $Header: ARHOSMTS.pls 115.1 2002/11/21 19:06:10 sponnamb ship $ */
3 
4 
5 PROCEDURE Insert_Row(
6                   x_Rowid          IN OUT NOCOPY         VARCHAR2,
7                   x_STOCK_EXCHANGE_ID             NUMBER,
8                   x_COUNTRY_OF_RESIDENCE          VARCHAR2,
9                   x_STOCK_EXCHANGE_CODE           VARCHAR2,
10                   x_STOCK_EXCHANGE_NAME           VARCHAR2,
11                   x_CREATED_BY                    NUMBER,
12                   x_CREATION_DATE                 DATE,
13                   x_LAST_UPDATE_LOGIN             NUMBER,
14                   x_LAST_UPDATE_DATE              DATE,
15                   x_LAST_UPDATED_BY               NUMBER,
16                   x_REQUEST_ID                    NUMBER,
17                   x_PROGRAM_APPLICATION_ID        NUMBER,
18                   x_PROGRAM_ID                    NUMBER,
19                   x_PROGRAM_UPDATE_DATE           DATE,
20                   x_WH_UPDATE_DATE                DATE);
21 
22 
23 
24 PROCEDURE Lock_Row(
25                   x_Rowid                         VARCHAR2,
26                   x_STOCK_EXCHANGE_ID             NUMBER,
27                   x_COUNTRY_OF_RESIDENCE          VARCHAR2,
28                   x_STOCK_EXCHANGE_CODE           VARCHAR2,
29                   x_STOCK_EXCHANGE_NAME           VARCHAR2,
30                   x_CREATED_BY                    NUMBER,
31                   x_CREATION_DATE                 DATE,
32                   x_LAST_UPDATE_LOGIN             NUMBER,
33                   x_LAST_UPDATE_DATE              DATE,
34                   x_LAST_UPDATED_BY               NUMBER,
35                   x_REQUEST_ID                    NUMBER,
36                   x_PROGRAM_APPLICATION_ID        NUMBER,
37                   x_PROGRAM_ID                    NUMBER,
38                   x_PROGRAM_UPDATE_DATE           DATE,
39                   x_WH_UPDATE_DATE                DATE);
40 
41 
42 
43 PROCEDURE Update_Row(
44                   x_Rowid           IN OUT NOCOPY        VARCHAR2,
45                   x_STOCK_EXCHANGE_ID             NUMBER,
46                   x_COUNTRY_OF_RESIDENCE          VARCHAR2,
47                   x_STOCK_EXCHANGE_CODE           VARCHAR2,
48                   x_STOCK_EXCHANGE_NAME           VARCHAR2,
49                   x_CREATED_BY                    NUMBER,
50                   x_CREATION_DATE                 DATE,
51                   x_LAST_UPDATE_LOGIN             NUMBER,
52                   x_LAST_UPDATE_DATE              DATE,
53                   x_LAST_UPDATED_BY               NUMBER,
54                   x_REQUEST_ID                    NUMBER,
55                   x_PROGRAM_APPLICATION_ID        NUMBER,
56                   x_PROGRAM_ID                    NUMBER,
57                   x_PROGRAM_UPDATE_DATE           DATE,
58                   x_WH_UPDATE_DATE                DATE);
59 
60 
61 
62 PROCEDURE Delete_Row(                  x_STOCK_EXCHANGE_ID             NUMBER);
63 
64 END HZ_STOCK_MARKETS_PKG;