APPS.OKC_EXTEND_PVT dependencies on OKC_TIMEVALUES

Line 938: CURSOR CUR_TIME_VALUES (p_tve_id in okc_timevalues.id%type)is

934:
935: l_isev_rec OKC_TIME_PUB.isev_ext_rec_type;
936: i_isev_rec OKC_TIME_PUB.isev_ext_rec_type;
937:
938: CURSOR CUR_TIME_VALUES (p_tve_id in okc_timevalues.id%type)is
939: SELECT id,object_version_number
940: FROM okc_timevalues
941: WHERE id = p_tve_id;
942:

Line 940: FROM okc_timevalues

936: i_isev_rec OKC_TIME_PUB.isev_ext_rec_type;
937:
938: CURSOR CUR_TIME_VALUES (p_tve_id in okc_timevalues.id%type)is
939: SELECT id,object_version_number
940: FROM okc_timevalues
941: WHERE id = p_tve_id;
942:
943: CURSOR CUR_IS_ISE(p_tve_id okc_timevalues.id%type) is
944: SELECT 'x'

Line 943: CURSOR CUR_IS_ISE(p_tve_id okc_timevalues.id%type) is

939: SELECT id,object_version_number
940: FROM okc_timevalues
941: WHERE id = p_tve_id;
942:
943: CURSOR CUR_IS_ISE(p_tve_id okc_timevalues.id%type) is
944: SELECT 'x'
945: FROM okc_time_ia_startend_val_v
946: WHERE id = p_tve_id;
947:

Line 949: l_id okc_timevalues.id%type;

945: FROM okc_time_ia_startend_val_v
946: WHERE id = p_tve_id;
947:
948: l_flag varchar2(1);
949: l_id okc_timevalues.id%type;
950: l_object_version_number okc_timevalues.object_version_number%type;
951: l_api_name constant varchar2(30) := 'update_time_values';
952:
953: BEGIN

Line 950: l_object_version_number okc_timevalues.object_version_number%type;

946: WHERE id = p_tve_id;
947:
948: l_flag varchar2(1);
949: l_id okc_timevalues.id%type;
950: l_object_version_number okc_timevalues.object_version_number%type;
951: l_api_name constant varchar2(30) := 'update_time_values';
952:
953: BEGIN
954: --dbms_output.put_line('update time (+)');