DBA Data[Home] [Help]

PACKAGE: APPS.AS_INTEREST_TYPES_PKG

Source


1 package AS_INTEREST_TYPES_PKG AUTHID CURRENT_USER as
2 /* $Header: asxvitps.pls 115.12 2003/10/10 08:58:15 gbatra ship $ */
3 
4 -- This will be called by the Interest Types Forms UI
5 
6 procedure INSERT_ROW (
7   X_ROWID out nocopy VARCHAR2,
8   X_INTEREST_TYPE_ID in NUMBER,
9   X_MASTER_ENABLED_FLAG in VARCHAR2,
10   X_ENABLED_FLAG in VARCHAR2,
11   X_COMPANY_CLASSIFICATION_FLAG in VARCHAR2,
12   X_CONTACT_INTEREST_FLAG in VARCHAR2,
13   X_LEAD_CLASSIFICATION_FLAG in VARCHAR2,
14   X_EXPECTED_PURCHASE_FLAG in VARCHAR2,
15   X_CURRENT_ENVIRONMENT_FLAG in VARCHAR2,
16   X_ORG_ID in NUMBER,
17   X_INTEREST_TYPE in VARCHAR2,
18   X_DESCRIPTION in VARCHAR2,
19   X_CREATION_DATE in DATE,
20   X_CREATED_BY in NUMBER,
21   X_LAST_UPDATE_DATE in DATE,
22   X_LAST_UPDATED_BY in NUMBER,
23   X_LAST_UPDATE_LOGIN in NUMBER,
24   X_PROD_CAT_SET_ID in NUMBER,
25   X_PROD_CAT_ID in NUMBER);
26 
27 -- This will be called by the Interest Types Forms UI
28 
29 procedure LOCK_ROW (
30   X_INTEREST_TYPE_ID in NUMBER,
31   X_MASTER_ENABLED_FLAG in VARCHAR2,
32   X_ENABLED_FLAG in VARCHAR2,
33   X_COMPANY_CLASSIFICATION_FLAG in VARCHAR2,
34   X_CONTACT_INTEREST_FLAG in VARCHAR2,
35   X_LEAD_CLASSIFICATION_FLAG in VARCHAR2,
36   X_EXPECTED_PURCHASE_FLAG in VARCHAR2,
37   X_CURRENT_ENVIRONMENT_FLAG in VARCHAR2,
38   X_ORG_ID in number,
39   X_INTEREST_TYPE in VARCHAR2,
40   X_DESCRIPTION in VARCHAR2,
41   X_PROD_CAT_SET_ID in NUMBER,
42   X_PROD_CAT_ID in NUMBER
43 );
44 
45 -- This will be called by the Interest Types Forms UI
46 
47 procedure UPDATE_ROW (
48   X_INTEREST_TYPE_ID in NUMBER,
49   X_MASTER_ENABLED_FLAG in VARCHAR2,
50   X_ENABLED_FLAG in VARCHAR2,
51   X_COMPANY_CLASSIFICATION_FLAG in VARCHAR2,
52   X_CONTACT_INTEREST_FLAG in VARCHAR2,
53   X_LEAD_CLASSIFICATION_FLAG in VARCHAR2,
54   X_EXPECTED_PURCHASE_FLAG in VARCHAR2,
55   X_CURRENT_ENVIRONMENT_FLAG in VARCHAR2,
56   X_ORG_ID in number,
57   X_INTEREST_TYPE in VARCHAR2,
58   X_DESCRIPTION in VARCHAR2,
59   X_LAST_UPDATE_DATE in DATE,
60   X_LAST_UPDATED_BY in NUMBER,
61   X_LAST_UPDATE_LOGIN in NUMBER,
62   X_PROD_CAT_SET_ID in NUMBER,
63   X_PROD_CAT_ID in NUMBER
64 );
65 
66 -- This will be called by the Interest Types Forms UI
67 
68 procedure DELETE_ROW (
69   X_INTEREST_TYPE_ID in NUMBER
70 );
71 
72 
73 procedure TRANSLATE_ROW (
74   X_INTEREST_TYPE_ID in NUMBER,
75   X_INTEREST_TYPE in VARCHAR2,
76   X_DESCRIPTION in VARCHAR2,
77   X_OWNER in VARCHAR2);
78 
79 -- This will be called by the Interest Types Forms UI
80 
81 procedure ADD_LANGUAGE;
82 
83 -- this procedure is called from forms UI to update only the
84 --	_ALL table.
85 
86 procedure insert_as_int_types_all (
87   X_INTEREST_TYPE_ID in NUMBER,
88   X_ENABLED_FLAG in VARCHAR2,
89   X_ORG_ID in NUMBER,
90   X_CREATION_DATE in DATE,
91   X_CREATED_BY in NUMBER,
92   X_LAST_UPDATE_DATE in DATE,
93   X_LAST_UPDATED_BY in NUMBER,
94   X_LAST_UPDATE_LOGIN in NUMBER);
95 
96 END AS_INTEREST_TYPES_PKG;
97