27: -- Version Initial version number = 1.0
28: -- History Current version number = 1.0
29: --=======================================================
30: procedure CREATE_EXCLUDED_ITEM (
31: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32: p_api_version_number IN NUMBER,
33: p_init_msg_tbl IN BOOLEAN := FALSE,
34: p_msg_count OUT NOCOPY NUMBER,
35: p_msg_data OUT NOCOPY VARCHAR2,
37: p_responsibility_id IN NUMBER,
38: p_resp_application_id IN NUMBER,
39: p_attribute_code IN VARCHAR2,
40: p_attribute_application_id IN NUMBER,
41: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
42: p_creation_date IN DATE := FND_API.G_MISS_DATE,
43: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
44: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
45: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
38: p_resp_application_id IN NUMBER,
39: p_attribute_code IN VARCHAR2,
40: p_attribute_application_id IN NUMBER,
41: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
42: p_creation_date IN DATE := FND_API.G_MISS_DATE,
43: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
44: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
45: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
46: );
39: p_attribute_code IN VARCHAR2,
40: p_attribute_application_id IN NUMBER,
41: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
42: p_creation_date IN DATE := FND_API.G_MISS_DATE,
43: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
44: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
45: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
46: );
47:
40: p_attribute_application_id IN NUMBER,
41: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
42: p_creation_date IN DATE := FND_API.G_MISS_DATE,
43: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
44: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
45: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
46: );
47:
48: --=======================================================
41: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
42: p_creation_date IN DATE := FND_API.G_MISS_DATE,
43: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
44: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
45: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
46: );
47:
48: --=======================================================
49: -- Procedure CREATE_RESP_SECURITY_ATTR
63: -- Version Initial version number = 1.0
64: -- History Current version number = 1.0
65: --=======================================================
66: procedure CREATE_RESP_SECURITY_ATTR (
67: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68: p_api_version_number IN NUMBER,
69: p_init_msg_tbl IN BOOLEAN := FALSE,
70: p_msg_count OUT NOCOPY NUMBER,
71: p_msg_data OUT NOCOPY VARCHAR2,
73: p_responsibility_id IN NUMBER,
74: p_resp_application_id IN NUMBER,
75: p_attribute_code IN VARCHAR2,
76: p_attribute_application_id IN NUMBER,
77: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
78: p_creation_date IN DATE := FND_API.G_MISS_DATE,
79: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
80: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
81: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
74: p_resp_application_id IN NUMBER,
75: p_attribute_code IN VARCHAR2,
76: p_attribute_application_id IN NUMBER,
77: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
78: p_creation_date IN DATE := FND_API.G_MISS_DATE,
79: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
80: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
81: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
82: );
75: p_attribute_code IN VARCHAR2,
76: p_attribute_application_id IN NUMBER,
77: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
78: p_creation_date IN DATE := FND_API.G_MISS_DATE,
79: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
80: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
81: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
82: );
83:
76: p_attribute_application_id IN NUMBER,
77: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
78: p_creation_date IN DATE := FND_API.G_MISS_DATE,
79: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
80: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
81: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
82: );
83:
84: --========================================================
77: p_created_by IN NUMBER := FND_API.G_MISS_NUM,
78: p_creation_date IN DATE := FND_API.G_MISS_DATE,
79: p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
80: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
81: p_last_update_login IN NUMBER := FND_API.G_MISS_NUM
82: );
83:
84: --========================================================
85: -- Procedure DOWNLOAD_RESP
125: -- Version Initial version number = 1.0
126: -- History Current version number = 1.0
127: --=======================================================
128: procedure DOWNLOAD_RESP (
129: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: p_api_version_number IN NUMBER,
131: p_init_msg_tbl IN BOOLEAN := FALSE,
132: p_msg_count OUT NOCOPY NUMBER,
133: p_msg_data OUT NOCOPY VARCHAR2,
131: p_init_msg_tbl IN BOOLEAN := FALSE,
132: p_msg_count OUT NOCOPY NUMBER,
133: p_msg_data OUT NOCOPY VARCHAR2,
134: p_return_status OUT NOCOPY VARCHAR2,
135: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
137: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_excluded_pk_tbl IN AK_SECURITY_PUB.Resp_PK_Tbl_Type :=
139: AK_SECURITY_PUB.G_MISS_RESP_PK_TBL,
132: p_msg_count OUT NOCOPY NUMBER,
133: p_msg_data OUT NOCOPY VARCHAR2,
134: p_return_status OUT NOCOPY VARCHAR2,
135: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
137: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_excluded_pk_tbl IN AK_SECURITY_PUB.Resp_PK_Tbl_Type :=
139: AK_SECURITY_PUB.G_MISS_RESP_PK_TBL,
140: p_resp_pk_tbl IN AK_SECURITY_PUB.Resp_PK_Tbl_Type :=
133: p_msg_data OUT NOCOPY VARCHAR2,
134: p_return_status OUT NOCOPY VARCHAR2,
135: p_nls_language IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_application_id IN NUMBER := FND_API.G_MISS_NUM,
137: p_application_short_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_excluded_pk_tbl IN AK_SECURITY_PUB.Resp_PK_Tbl_Type :=
139: AK_SECURITY_PUB.G_MISS_RESP_PK_TBL,
140: p_resp_pk_tbl IN AK_SECURITY_PUB.Resp_PK_Tbl_Type :=
141: AK_SECURITY_PUB.G_MISS_RESP_PK_TBL