DBA Data[Home] [Help]

APPS.WF_MAINTENANCE dependencies on WF_DIRECTORY_PARTITIONS

Line 1987: l_partitionID WF_DIRECTORY_PARTITIONS.PARTITION_ID%TYPE;

1983: function GetUsernameChangeCounts(p_name VARCHAR2) RETURN wfcount_tab pipelined is
1984: --l_wfcount_tab wfcount_tab;
1985: l_wfcount_tab wfcount_type;
1986: l_roleInfoTAB WF_DIRECTORY.wf_local_roles_tbl_type;
1987: l_partitionID WF_DIRECTORY_PARTITIONS.PARTITION_ID%TYPE;
1988: l_partitionName WF_DIRECTORY_PARTITIONS.ORIG_SYSTEM%TYPE;
1989: l_pvalue varchar2(10) := FND_PROFILE.value('WF_MAINT_COMPLETED_ITEMS');
1990: begin
1991: -- First etermine if the username actually exists

Line 1988: l_partitionName WF_DIRECTORY_PARTITIONS.ORIG_SYSTEM%TYPE;

1984: --l_wfcount_tab wfcount_tab;
1985: l_wfcount_tab wfcount_type;
1986: l_roleInfoTAB WF_DIRECTORY.wf_local_roles_tbl_type;
1987: l_partitionID WF_DIRECTORY_PARTITIONS.PARTITION_ID%TYPE;
1988: l_partitionName WF_DIRECTORY_PARTITIONS.ORIG_SYSTEM%TYPE;
1989: l_pvalue varchar2(10) := FND_PROFILE.value('WF_MAINT_COMPLETED_ITEMS');
1990: begin
1991: -- First etermine if the username actually exists
1992: WF_DIRECTORY.GetRoleInfo2(p_name, l_roleInfoTAB);