DBA Data[Home] [Help]

APPS.IGS_SC_DATA_SEC_APIS_PKG dependencies on WF_LOCAL_USER_ROLES

Line 1907: p_user_name IN wf_local_user_roles.user_name%TYPE,

1903: ******************************************************************/
1904: PROCEDURE Insert_Local_User_Role (p_api_version IN NUMBER,
1905: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1906: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1907: p_user_name IN wf_local_user_roles.user_name%TYPE,
1908: p_role_name IN wf_local_user_roles.role_name%TYPE,
1909: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
1910: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
1911: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,

Line 1908: p_role_name IN wf_local_user_roles.role_name%TYPE,

1904: PROCEDURE Insert_Local_User_Role (p_api_version IN NUMBER,
1905: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1906: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1907: p_user_name IN wf_local_user_roles.user_name%TYPE,
1908: p_role_name IN wf_local_user_roles.role_name%TYPE,
1909: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
1910: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
1911: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
1912: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,

Line 1909: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,

1905: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1906: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1907: p_user_name IN wf_local_user_roles.user_name%TYPE,
1908: p_role_name IN wf_local_user_roles.role_name%TYPE,
1909: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
1910: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
1911: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
1912: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
1913: p_start_date IN wf_local_user_roles.start_date%TYPE,

Line 1910: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,

1906: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1907: p_user_name IN wf_local_user_roles.user_name%TYPE,
1908: p_role_name IN wf_local_user_roles.role_name%TYPE,
1909: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
1910: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
1911: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
1912: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
1913: p_start_date IN wf_local_user_roles.start_date%TYPE,
1914: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,

Line 1911: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,

1907: p_user_name IN wf_local_user_roles.user_name%TYPE,
1908: p_role_name IN wf_local_user_roles.role_name%TYPE,
1909: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
1910: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
1911: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
1912: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
1913: p_start_date IN wf_local_user_roles.start_date%TYPE,
1914: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
1915: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,

Line 1912: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,

1908: p_role_name IN wf_local_user_roles.role_name%TYPE,
1909: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
1910: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
1911: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
1912: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
1913: p_start_date IN wf_local_user_roles.start_date%TYPE,
1914: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
1915: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,
1916: x_return_status OUT NOCOPY VARCHAR2,

Line 1913: p_start_date IN wf_local_user_roles.start_date%TYPE,

1909: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
1910: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
1911: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
1912: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
1913: p_start_date IN wf_local_user_roles.start_date%TYPE,
1914: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
1915: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,
1916: x_return_status OUT NOCOPY VARCHAR2,
1917: x_return_message OUT NOCOPY VARCHAR2

Line 1914: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,

1910: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
1911: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
1912: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
1913: p_start_date IN wf_local_user_roles.start_date%TYPE,
1914: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
1915: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,
1916: x_return_status OUT NOCOPY VARCHAR2,
1917: x_return_message OUT NOCOPY VARCHAR2
1918: )

Line 1915: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,

1911: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
1912: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
1913: p_start_date IN wf_local_user_roles.start_date%TYPE,
1914: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
1915: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,
1916: x_return_status OUT NOCOPY VARCHAR2,
1917: x_return_message OUT NOCOPY VARCHAR2
1918: )
1919: IS

Line 2460: p_user_name IN wf_local_user_roles.user_name%TYPE,

2456: ******************************************************************/
2457: PROCEDURE Update_Local_User_Role (p_api_version IN NUMBER,
2458: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2459: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2460: p_user_name IN wf_local_user_roles.user_name%TYPE,
2461: p_role_name IN wf_local_user_roles.role_name%TYPE,
2462: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
2463: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
2464: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,

Line 2461: p_role_name IN wf_local_user_roles.role_name%TYPE,

2457: PROCEDURE Update_Local_User_Role (p_api_version IN NUMBER,
2458: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2459: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2460: p_user_name IN wf_local_user_roles.user_name%TYPE,
2461: p_role_name IN wf_local_user_roles.role_name%TYPE,
2462: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
2463: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
2464: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
2465: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,

Line 2462: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,

2458: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2459: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2460: p_user_name IN wf_local_user_roles.user_name%TYPE,
2461: p_role_name IN wf_local_user_roles.role_name%TYPE,
2462: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
2463: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
2464: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
2465: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
2466: p_start_date IN wf_local_user_roles.start_date%TYPE,

Line 2463: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,

2459: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2460: p_user_name IN wf_local_user_roles.user_name%TYPE,
2461: p_role_name IN wf_local_user_roles.role_name%TYPE,
2462: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
2463: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
2464: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
2465: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
2466: p_start_date IN wf_local_user_roles.start_date%TYPE,
2467: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,

Line 2464: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,

2460: p_user_name IN wf_local_user_roles.user_name%TYPE,
2461: p_role_name IN wf_local_user_roles.role_name%TYPE,
2462: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
2463: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
2464: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
2465: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
2466: p_start_date IN wf_local_user_roles.start_date%TYPE,
2467: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
2468: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,

Line 2465: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,

2461: p_role_name IN wf_local_user_roles.role_name%TYPE,
2462: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
2463: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
2464: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
2465: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
2466: p_start_date IN wf_local_user_roles.start_date%TYPE,
2467: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
2468: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,
2469: x_return_status OUT NOCOPY VARCHAR2,

Line 2466: p_start_date IN wf_local_user_roles.start_date%TYPE,

2462: p_user_orig_system IN wf_local_user_roles.user_orig_system%TYPE,
2463: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
2464: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
2465: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
2466: p_start_date IN wf_local_user_roles.start_date%TYPE,
2467: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
2468: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,
2469: x_return_status OUT NOCOPY VARCHAR2,
2470: x_return_message OUT NOCOPY VARCHAR2

Line 2467: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,

2463: p_user_orig_system_id IN wf_local_user_roles.user_orig_system_id%TYPE,
2464: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
2465: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
2466: p_start_date IN wf_local_user_roles.start_date%TYPE,
2467: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
2468: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,
2469: x_return_status OUT NOCOPY VARCHAR2,
2470: x_return_message OUT NOCOPY VARCHAR2
2471: ) IS

Line 2468: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,

2464: p_role_orig_system IN wf_local_user_roles.role_orig_system%TYPE,
2465: p_role_orig_system_id IN wf_local_user_roles.role_orig_system_id%TYPE,
2466: p_start_date IN wf_local_user_roles.start_date%TYPE,
2467: p_expiration_date IN wf_local_user_roles.expiration_date%TYPE,
2468: p_security_group_id IN wf_local_user_roles.security_group_id%TYPE,
2469: x_return_status OUT NOCOPY VARCHAR2,
2470: x_return_message OUT NOCOPY VARCHAR2
2471: ) IS
2472: