1 package FND_FORM_PKG as
2 /* $Header: AFFMFBFS.pls 120.3 2005/10/05 23:03:42 stadepal ship $ */
3 /*#
4 * Table Handler to insert or update data in FND_FORM table.
5 * @rep:scope public
6 * @rep:product FND
7 * @rep:displayname Form
8 * @rep:lifecycle active
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY FND_FORM
11 * @rep:ihelp FND/@o_funcsec#o_funcsec See the related online help
12 */
13
14 procedure INSERT_ROW (
15 X_ROWID IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
16 X_APPLICATION_ID in NUMBER,
17 X_FORM_ID in NUMBER,
18 X_FORM_NAME in VARCHAR2,
19 X_AUDIT_ENABLED_FLAG in VARCHAR2,
20 X_USER_FORM_NAME in VARCHAR2,
21 X_DESCRIPTION in VARCHAR2,
22 X_CREATION_DATE in DATE,
23 X_CREATED_BY in NUMBER,
24 X_LAST_UPDATE_DATE in DATE,
25 X_LAST_UPDATED_BY in NUMBER,
26 X_LAST_UPDATE_LOGIN in NUMBER);
27 procedure LOCK_ROW (
28 X_APPLICATION_ID in NUMBER,
29 X_FORM_ID in NUMBER,
30 X_FORM_NAME in VARCHAR2,
31 X_AUDIT_ENABLED_FLAG in VARCHAR2,
32 X_USER_FORM_NAME in VARCHAR2,
33 X_DESCRIPTION in VARCHAR2
34 );
35 procedure UPDATE_ROW (
36 X_APPLICATION_ID in NUMBER,
37 X_FORM_ID in NUMBER,
38 X_FORM_NAME in VARCHAR2,
39 X_AUDIT_ENABLED_FLAG in VARCHAR2,
40 X_USER_FORM_NAME in VARCHAR2,
41 X_DESCRIPTION in VARCHAR2,
42 X_LAST_UPDATE_DATE in DATE,
43 X_LAST_UPDATED_BY in NUMBER,
44 X_LAST_UPDATE_LOGIN in NUMBER
45 );
46 /* Overloaded version below */
47 procedure LOAD_ROW (
48 X_APPLICATION_SHORT_NAME in VARCHAR2,
49 X_FORM_NAME in VARCHAR2,
50 X_AUDIT_ENABLED_FLAG in VARCHAR2,
51 X_USER_FORM_NAME in VARCHAR2,
52 X_DESCRIPTION in VARCHAR2,
53 X_OWNER in VARCHAR2,
54 X_CUSTOM_MODE in VARCHAR2
55 );
56 procedure DELETE_ROW (
57 X_APPLICATION_ID in NUMBER,
58 X_FORM_ID in NUMBER
59 );
60 procedure ADD_LANGUAGE;
61 /* Overloaded version below */
62 procedure TRANSLATE_ROW (
63 X_APPLICATION_ID in NUMBER,
64 X_FORM_ID in VARCHAR2,
65 X_USER_FORM_NAME in VARCHAR2,
66 X_DESCRIPTION in VARCHAR2,
67 X_OWNER in VARCHAR2,
68 X_CUSTOM_MODE in VARCHAR2
69 );
70 /* Overloaded version above */
71 /*#
72 * Creates or updates Form data as appropriate
73 * @param x_application_short_name Application Short Name
74 * @param x_form_name Form Name
75 * @param x_audit_enabled_flag Audit Enabled Flag
76 * @param x_user_form_name User Form Name
77 * @param x_description Description
78 * @param x_owner Owner Name
79 * @param x_custom_mode Custom Mode
80 * @param x_last_update_date Insert/Update Date
81 * @rep:scope public
82 * @rep:lifecycle active
83 * @rep:displayname Create/Update Form Data
84 * @rep:compatibility S
85 * @rep:ihelp FND/@dev_sp_subfunc#dev_sp_subfunc See the related online help
86 */
87 procedure LOAD_ROW (
88 X_APPLICATION_SHORT_NAME in VARCHAR2,
89 X_FORM_NAME in VARCHAR2,
90 X_AUDIT_ENABLED_FLAG in VARCHAR2,
91 X_USER_FORM_NAME in VARCHAR2,
92 X_DESCRIPTION in VARCHAR2,
93 X_OWNER in VARCHAR2,
94 X_CUSTOM_MODE in VARCHAR2,
95 X_LAST_UPDATE_DATE in VARCHAR2
96 );
97 /* Overloaded version above */
98 procedure TRANSLATE_ROW (
99 X_APPLICATION_ID in NUMBER,
100 X_FORM_ID in VARCHAR2,
101 X_USER_FORM_NAME in VARCHAR2,
102 X_DESCRIPTION in VARCHAR2,
103 X_OWNER in VARCHAR2,
104 X_CUSTOM_MODE in VARCHAR2,
105 X_LAST_UPDATE_DATE in VARCHAR2
106 );
107 end FND_FORM_PKG;