1 PACKAGE ASG_PUB_SEQUENCE_PKG as
2 /* $Header: asgpseqs.pls 120.1 2005/08/12 02:54:36 saradhak noship $ */
3
4 --
5 -- NAME
6 -- ASG_PUB_SEQUENCE
7 --
8 -- PURPOSE
9 --
10 -- HISTORY
11 -- JUN 03, 2002 ytian changed _id pk type to varchar2.
12 -- MAR 11, 2002 ytian added insert_row, update_row, upload_row
13 -- Mar 08, 2002 yazhang add Get_Next_Client_Number function
14 -- Mar 07, 2002 ytian created
15
16 /* get the next client_number for user.*/
17 Function Get_Next_Client_Number return INTEGER;
18
19 /* get the clientnumber */
20 Function getCLIENT_NUMBER(X_CLIENTID IN Varchar2) RETURN number;
21
22 /* Get me next value */
23 Function getNEXT_VALUE RETURN number;
24
25 /* Get me start value */
26 Function getSTART_VALUE(X_CLIENT_NUMBER number, X_TABLE_NAME varchar2,
27 X_PRIMARY_KEY varchar2, X_START_MOBILE varchar2 ) RETURN number;
28
29 procedure insert_row (
30 x_SEQUENCE_ID in VARCHAR2,
31 x_SEQUENCE_NAME in VARCHAR2,
32 x_PUBLICATION_ID in VARCHAR2,
33 x_B_SCHEMA in VARCHAR2,
34 x_B_TABLE in VARCHAR2,
35 x_B_COLUMN in VARCHAR2,
36 x_MOBILE_VALUE in VARCHAR2,
37 x_ENABLED in VARCHAR2,
38 x_STATUS in VARCHAR2,
39 x_CURRENT_RELEASE_VERSION in NUMBER,
40 x_LAST_RELEASE_VERSION in NUMBER,
41 x_CREATION_DATE in DATE,
42 x_CREATED_BY in NUMBER,
43 x_LAST_UPDATE_DATE in DATE,
44 x_LAST_UPDATED_BY in NUMBER );
45
46 procedure update_row (
47 x_SEQUENCE_ID in VARCHAR2,
48 x_SEQUENCE_NAME in VARCHAR2,
49 x_PUBLICATION_ID in VARCHAR2,
50 x_B_SCHEMA in VARCHAR2,
51 x_B_TABLE in VARCHAR2,
52 x_B_COLUMN in VARCHAR2,
53 x_MOBILE_VALUE in VARCHAR2,
54 x_ENABLED in VARCHAR2,
55 x_STATUS in VARCHAR2,
56 x_CURRENT_RELEASE_VERSION in NUMBER,
57 x_LAST_RELEASE_VERSION in NUMBER,
58 x_CREATION_DATE in DATE,
59 x_CREATED_BY in NUMBER,
60 x_LAST_UPDATE_DATE in DATE,
61 x_LAST_UPDATED_BY in NUMBER );
62
63 procedure load_row (
64 x_SEQUENCE_ID in VARCHAR2,
65 x_SEQUENCE_NAME in VARCHAR2,
66 x_PUBLICATION_ID in VARCHAR2,
67 x_B_SCHEMA in VARCHAR2,
68 x_B_TABLE in VARCHAR2,
69 x_B_COLUMN in VARCHAR2,
70 x_MOBILE_VALUE in VARCHAR2,
71 x_ENABLED in VARCHAR2,
72 x_STATUS in VARCHAR2,
73 x_CURRENT_RELEASE_VERSION in NUMBER,
74 x_LAST_RELEASE_VERSION in NUMBER,
75 x_CREATION_DATE in DATE,
76 x_CREATED_BY in NUMBER,
77 x_LAST_UPDATE_DATE in DATE,
78 x_LAST_UPDATED_BY in NUMBER,
79 p_owner in VARCHAR2);
80
81 END ASG_PUB_SEQUENCE_PKG;
82
83