1 package FND_RESP_FUNCTIONS_PKG as
2 /* $Header: AFSCRFNS.pls 120.1 2005/07/02 03:09:19 appldev ship $ */
3 /*#
4 * Table Handler to insert or update data in FND_RESP_FUNCTIONS table.
5 * @rep:scope public
6 * @rep:product FND
7 * @rep:displayname Responsibility Function
8 * @rep:lifecycle active
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY FND_FUNC_SECURITY
11 * @rep:ihelp FND/@o_funcsec#o_funcsec See the related online help
12 */
13
14
15 procedure INSERT_ROW (
16 X_ROWID in out nocopy VARCHAR2,
17 X_APPLICATION_ID in NUMBER,
18 X_RESPONSIBILITY_ID in NUMBER,
19 X_ACTION_ID in NUMBER,
20 X_RULE_TYPE in VARCHAR2,
21 X_CREATED_BY in NUMBER,
22 X_CREATION_DATE in DATE,
23 X_LAST_UPDATED_BY in NUMBER,
24 X_LAST_UPDATE_DATE in DATE,
25 X_LAST_UPDATE_LOGIN in NUMBER );
26
27 procedure LOCK_ROW (
28 X_APPLICATION_ID in NUMBER,
29 X_RESPONSIBILITY_ID in NUMBER,
30 X_ACTION_ID in NUMBER,
31 X_RULE_TYPE in VARCHAR2 );
32
33 procedure UPDATE_ROW (
34 X_APPLICATION_ID in NUMBER,
35 X_RESPONSIBILITY_ID in NUMBER,
36 X_ACTION_ID in NUMBER,
37 X_RULE_TYPE in VARCHAR2,
38 X_LAST_UPDATED_BY in NUMBER,
39 X_LAST_UPDATE_DATE in DATE,
40 X_LAST_UPDATE_LOGIN in NUMBER );
41
42 procedure DELETE_ROW (
43 X_APPLICATION_ID in NUMBER,
44 X_RESPONSIBILITY_ID in NUMBER,
45 X_RULE_TYPE in VARCHAR2,
46 X_ACTION_ID in NUMBER );
47
48 procedure LOAD_ROW (
49 X_APP_SHORT_NAME in VARCHAR2,
50 X_RESP_KEY in VARCHAR2,
51 X_RULE_TYPE in VARCHAR2,
52 X_ACTION in VARCHAR2,
53 X_OWNER in VARCHAR2 );
54
55 --Overloaded !!
56 /*#
57 * Creates or updates data in FND_RESP_FUNCTIONS as
58 * appropriate.
59 * @param x_app_short_name Application Short Name
60 * @param x_resp_key Responsibility Key
61 * @param x_rule_type Rule Type
62 * @param x_action Action
63 * @param x_owner Owner Name
64 * @param x_custom_mode Custom Mode
65 * @param x_last_update_date Insert/Update Date
66 * @rep:scope public
67 * @rep:lifecycle active
68 * @rep:displayname Create/Update Responsibility Function
69 * @rep:compatibility S
70 * @rep:ihelp FND/@dev_p_funcworks#dev_p_funcworks See the related online help
71 */
72 procedure LOAD_ROW (
73 X_APP_SHORT_NAME in VARCHAR2,
74 X_RESP_KEY in VARCHAR2,
75 X_RULE_TYPE in VARCHAR2,
76 X_ACTION in VARCHAR2,
77 X_OWNER in VARCHAR2,
78 X_CUSTOM_MODE in VARCHAR2,
79 X_LAST_UPDATE_DATE in VARCHAR2);
80
81
82 end FND_RESP_FUNCTIONS_PKG;