79: ,x_FUNCTION_ID OUT NOCOPY NUMBER
80: ,x_return_status OUT NOCOPY VARCHAR2
81: ,x_msg_count OUT NOCOPY NUMBER
82: ,x_msg_data OUT NOCOPY VARCHAR2
83: ,p_REGION_CODE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
84: ,p_REGION_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
85: ,p_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
86: ,p_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
87: ,p_FUNCTIONAL_AREA_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
80: ,x_return_status OUT NOCOPY VARCHAR2
81: ,x_msg_count OUT NOCOPY NUMBER
82: ,x_msg_data OUT NOCOPY VARCHAR2
83: ,p_REGION_CODE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
84: ,p_REGION_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
85: ,p_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
86: ,p_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
87: ,p_FUNCTIONAL_AREA_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
88: );
81: ,x_msg_count OUT NOCOPY NUMBER
82: ,x_msg_data OUT NOCOPY VARCHAR2
83: ,p_REGION_CODE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
84: ,p_REGION_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
85: ,p_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
86: ,p_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
87: ,p_FUNCTIONAL_AREA_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
88: );
89:
82: ,x_msg_data OUT NOCOPY VARCHAR2
83: ,p_REGION_CODE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
84: ,p_REGION_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
85: ,p_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
86: ,p_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
87: ,p_FUNCTIONAL_AREA_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
88: );
89:
90: procedure UPDATE_ROW (
83: ,p_REGION_CODE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
84: ,p_REGION_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
85: ,p_APPLICATION_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
86: ,p_OBJECT_TYPE in VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
87: ,p_FUNCTIONAL_AREA_ID in NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
88: );
89:
90: procedure UPDATE_ROW (
91: X_USER_ID in NUMBER,
95:
96: -- mdamle 12/25/2003 - overloaded for additional functionality & error messaging
97: procedure UPDATE_ROW (
98: p_FUNCTION_ID IN NUMBER
99: ,p_USER_FUNCTION_NAME IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
100: ,p_PARAMETERS IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
101: ,p_DESCRIPTION IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
102: ,p_WEB_HTML_CALL IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
103: ,p_APPLICATION_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
96: -- mdamle 12/25/2003 - overloaded for additional functionality & error messaging
97: procedure UPDATE_ROW (
98: p_FUNCTION_ID IN NUMBER
99: ,p_USER_FUNCTION_NAME IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
100: ,p_PARAMETERS IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
101: ,p_DESCRIPTION IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
102: ,p_WEB_HTML_CALL IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
103: ,p_APPLICATION_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
104: ,p_OBJECT_TYPE IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
97: procedure UPDATE_ROW (
98: p_FUNCTION_ID IN NUMBER
99: ,p_USER_FUNCTION_NAME IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
100: ,p_PARAMETERS IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
101: ,p_DESCRIPTION IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
102: ,p_WEB_HTML_CALL IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
103: ,p_APPLICATION_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
104: ,p_OBJECT_TYPE IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
105: ,p_FUNCTIONAL_AREA_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
98: p_FUNCTION_ID IN NUMBER
99: ,p_USER_FUNCTION_NAME IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
100: ,p_PARAMETERS IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
101: ,p_DESCRIPTION IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
102: ,p_WEB_HTML_CALL IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
103: ,p_APPLICATION_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
104: ,p_OBJECT_TYPE IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
105: ,p_FUNCTIONAL_AREA_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
106: ,x_return_status OUT NOCOPY VARCHAR2
99: ,p_USER_FUNCTION_NAME IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
100: ,p_PARAMETERS IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
101: ,p_DESCRIPTION IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
102: ,p_WEB_HTML_CALL IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
103: ,p_APPLICATION_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
104: ,p_OBJECT_TYPE IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
105: ,p_FUNCTIONAL_AREA_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
106: ,x_return_status OUT NOCOPY VARCHAR2
107: ,x_msg_count OUT NOCOPY NUMBER
100: ,p_PARAMETERS IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
101: ,p_DESCRIPTION IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
102: ,p_WEB_HTML_CALL IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
103: ,p_APPLICATION_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
104: ,p_OBJECT_TYPE IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
105: ,p_FUNCTIONAL_AREA_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
106: ,x_return_status OUT NOCOPY VARCHAR2
107: ,x_msg_count OUT NOCOPY NUMBER
108: ,x_msg_data OUT NOCOPY VARCHAR2
101: ,p_DESCRIPTION IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
102: ,p_WEB_HTML_CALL IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
103: ,p_APPLICATION_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
104: ,p_OBJECT_TYPE IN VARCHAR2 := BIS_COMMON_UTILS.G_DEF_CHAR
105: ,p_FUNCTIONAL_AREA_ID IN NUMBER := BIS_COMMON_UTILS.G_DEF_NUM
106: ,x_return_status OUT NOCOPY VARCHAR2
107: ,x_msg_count OUT NOCOPY NUMBER
108: ,x_msg_data OUT NOCOPY VARCHAR2
109: ,p_REGION_CODE IN VARCHAR2 := NULL