[Home] [Help]
PACKAGE: APPS.HZ_SECURITY_ISSUED_PKG
Source
1 PACKAGE HZ_SECURITY_ISSUED_PKG AUTHID CURRENT_USER as
2 /* $Header: ARHOSITS.pls 115.2 2002/11/21 19:19:46 sponnamb ship $ */
3
4
5 PROCEDURE Insert_Row(
6 x_Rowid IN OUT NOCOPY VARCHAR2,
7 x_SECURITY_ISSUED_ID NUMBER,
8 x_ESTIMATED_TOTAL_AMOUNT NUMBER,
9 x_PARTY_ID NUMBER,
10 x_STOCK_EXCHANGE_ID NUMBER,
11 x_SECURITY_ISSUED_CLASS VARCHAR2,
12 x_SECURITY_ISSUED_NAME VARCHAR2,
13 x_TOTAL_AMOUNT_IN_A_CURRENCY VARCHAR2,
14 x_STOCK_TICKER_SYMBOL VARCHAR2,
15 x_SECURITY_CURRENCY_CODE VARCHAR2,
16 x_BEGIN_DATE DATE,
17 x_END_DATE DATE,
18 x_CREATED_BY NUMBER,
19 x_CREATION_DATE DATE,
20 x_LAST_UPDATE_LOGIN NUMBER,
21 x_LAST_UPDATE_DATE DATE,
22 x_LAST_UPDATED_BY NUMBER,
23 x_REQUEST_ID NUMBER,
24 x_PROGRAM_APPLICATION_ID NUMBER,
25 x_PROGRAM_ID NUMBER,
26 x_PROGRAM_UPDATE_DATE DATE,
27 x_WH_UPDATE_DATE DATE,
28 x_STATUS VARCHAR2);
29
30
31
32 PROCEDURE Lock_Row(
33 x_Rowid VARCHAR2,
34 x_SECURITY_ISSUED_ID NUMBER,
35 x_ESTIMATED_TOTAL_AMOUNT NUMBER,
36 x_PARTY_ID NUMBER,
37 x_STOCK_EXCHANGE_ID NUMBER,
38 x_SECURITY_ISSUED_CLASS VARCHAR2,
39 x_SECURITY_ISSUED_NAME VARCHAR2,
40 x_TOTAL_AMOUNT_IN_A_CURRENCY VARCHAR2,
41 x_STOCK_TICKER_SYMBOL VARCHAR2,
42 x_SECURITY_CURRENCY_CODE VARCHAR2,
43 x_BEGIN_DATE DATE,
44 x_END_DATE DATE,
45 x_CREATED_BY NUMBER,
46 x_CREATION_DATE DATE,
47 x_LAST_UPDATE_LOGIN NUMBER,
48 x_LAST_UPDATE_DATE DATE,
49 x_LAST_UPDATED_BY NUMBER,
50 x_REQUEST_ID NUMBER,
51 x_PROGRAM_APPLICATION_ID NUMBER,
52 x_PROGRAM_ID NUMBER,
53 x_PROGRAM_UPDATE_DATE DATE,
54 x_WH_UPDATE_DATE DATE,
55 x_STATUS VARCHAR2);
56
57
58
59 PROCEDURE Update_Row(
60 x_Rowid IN OUT NOCOPY VARCHAR2,
61 x_SECURITY_ISSUED_ID NUMBER,
62 x_ESTIMATED_TOTAL_AMOUNT NUMBER,
63 x_PARTY_ID NUMBER,
64 x_STOCK_EXCHANGE_ID NUMBER,
65 x_SECURITY_ISSUED_CLASS VARCHAR2,
66 x_SECURITY_ISSUED_NAME VARCHAR2,
67 x_TOTAL_AMOUNT_IN_A_CURRENCY VARCHAR2,
68 x_STOCK_TICKER_SYMBOL VARCHAR2,
69 x_SECURITY_CURRENCY_CODE VARCHAR2,
70 x_BEGIN_DATE DATE,
71 x_END_DATE DATE,
72 x_CREATED_BY NUMBER,
73 x_CREATION_DATE DATE,
74 x_LAST_UPDATE_LOGIN NUMBER,
75 x_LAST_UPDATE_DATE DATE,
76 x_LAST_UPDATED_BY NUMBER,
77 x_REQUEST_ID NUMBER,
78 x_PROGRAM_APPLICATION_ID NUMBER,
79 x_PROGRAM_ID NUMBER,
80 x_PROGRAM_UPDATE_DATE DATE,
81 x_WH_UPDATE_DATE DATE,
82 x_STATUS VARCHAR2);
83
84
85
86 PROCEDURE Delete_Row( x_SECURITY_ISSUED_ID NUMBER);
87
88 END HZ_SECURITY_ISSUED_PKG;