1785: BEGIN
1786:
1787:
1788:
1789: IEC_COMMON_UTIL_PVT.Get_ListName(p_list_id, l_name);
1790:
1791:
1792:
1793: RETURN l_name;
1817: BEGIN
1818:
1819:
1820:
1821: IEC_COMMON_UTIL_PVT.Get_ScheduleName(p_schedule_id, l_name);
1822:
1823:
1824:
1825: RETURN l_name;
1849: BEGIN
1850:
1851:
1852:
1853: IEC_COMMON_UTIL_PVT.Get_SubsetName(p_subset_id, l_name);
1854:
1855:
1856:
1857: RETURN l_name;
1941: -- Get Source Type of List
1942:
1943: BEGIN
1944:
1945: IEC_COMMON_UTIL_PVT.Get_SourceTypeView(p_list_id, l_source_type_view);
1946:
1947: EXCEPTION
1948:
1949: WHEN OTHERS THEN
8606: -- get list header id corresponding to schedule id
8607:
8608: BEGIN
8609:
8610: IEC_COMMON_UTIL_PVT.Get_ListId(p_schedule_id, l_list_id);
8611:
8612: EXCEPTION
8613:
8614: WHEN OTHERS THEN
9798: BEGIN
9799:
9800:
9801:
9802: IEC_COMMON_UTIL_PVT.Get_ScheduleId(p_list_id, l_campaign_schedule_id);
9803:
9804: RETURN l_campaign_schedule_id;
9805:
9806:
13129: -- get list header ids corresponding to schedule ids
13130:
13131: BEGIN
13132:
13133: IEC_COMMON_UTIL_PVT.Get_ListId(p_src_schedule_id, l_src_list_id);
13134:
13135: IEC_COMMON_UTIL_PVT.Get_ListId(p_dest_schedule_id, l_dest_list_id);
13136:
13137: EXCEPTION
13131: BEGIN
13132:
13133: IEC_COMMON_UTIL_PVT.Get_ListId(p_src_schedule_id, l_src_list_id);
13134:
13135: IEC_COMMON_UTIL_PVT.Get_ListId(p_dest_schedule_id, l_dest_list_id);
13136:
13137: EXCEPTION
13138:
13139: WHEN OTHERS THEN
13899: -- get list header ids corresponding to schedule ids
13900:
13901: BEGIN
13902:
13903: IEC_COMMON_UTIL_PVT.Get_ListId(p_src_schedule_id, l_src_list_id);
13904:
13905: IEC_COMMON_UTIL_PVT.Get_ListId(p_dest_schedule_id, l_dest_list_id);
13906:
13907: EXCEPTION
13901: BEGIN
13902:
13903: IEC_COMMON_UTIL_PVT.Get_ListId(p_src_schedule_id, l_src_list_id);
13904:
13905: IEC_COMMON_UTIL_PVT.Get_ListId(p_dest_schedule_id, l_dest_list_id);
13906:
13907: EXCEPTION
13908:
13909: WHEN OTHERS THEN