DBA Data[Home] [Help]

APPS.ECX_CODE_CONVERSION_PVT dependencies on ECX_XREF_STANDARDS

Line 125: FROM ecx_xref_standards

121: null;
122: BEGIN
123: SELECT xref_std_value
124: INTO l_ext_val
125: FROM ecx_xref_standards
126: WHERE standard_id = p_standard_id
127: AND xref_category_id = p_tbl(i).xref_category_id
128: AND xref_int_value = p_tbl(i).value;
129: if(l_statementEnabled) then

Line 149: FROM ecx_xref_standards

145: END;
146: begin
147: SELECT xref_std_value
148: INTO l_ext_val
149: FROM ecx_xref_standards
150: WHERE standard_id = l_univ_std_id
151: AND xref_category_id = p_tbl(i).xref_category_id
152: AND xref_int_value = p_tbl(i).value;
153: if(l_statementEnabled) then

Line 323: FROM ecx_xref_standards

319: null;
320: BEGIN
321: SELECT xref_std_value
322: INTO l_int_val
323: FROM ecx_xref_standards
324: WHERE standard_id = p_standard_id
325: AND xref_category_id = p_apps_tbl(j).xref_category_id
326: AND xref_int_value = p_apps_tbl(j).value;
327:

Line 487: FROM ecx_xref_standards

483: WHEN no_data_found then
484: begin
485: SELECT xref_int_value
486: INTO l_int_val
487: FROM ecx_xref_standards
488: WHERE standard_id = p_standard_id
489: AND xref_category_id = p_category_id
490: AND xref_std_value = rtrim(p_value);
491: p_return_status := 0;

Line 507: FROM ecx_xref_standards

503: END;
504: begin
505: SELECT xref_int_value
506: INTO l_int_val
507: FROM ecx_xref_standards
508: WHERE standard_id = l_univ_std_id
509: AND xref_category_id = p_category_id
510: AND xref_std_value = rtrim(p_value);
511: p_return_status := 0;

Line 547: FROM ecx_xref_standards

543: WHEN no_data_found then
544: begin
545: SELECT xref_std_value
546: INTO l_ext_val
547: FROM ecx_xref_standards
548: WHERE standard_id = p_standard_id
549: AND xref_category_id = p_category_id
550: AND xref_int_value = p_value;
551: p_return_status := 0;

Line 557: FROM ecx_xref_standards

553: when no_data_found then
554: begin
555: SELECT xref_std_value
556: INTO l_ext_val
557: FROM ecx_xref_standards
558: WHERE standard_id = l_univ_std_id
559: AND xref_category_id = p_category_id
560: AND xref_int_value = p_value;
561: p_return_status := 0;

Line 686: FROM ecx_xref_standards

682: WHEN no_data_found THEN
683: BEGIN
684: SELECT xref_int_value
685: INTO l_int_val
686: FROM ecx_xref_standards
687: WHERE standard_id = i_standard_id
688: AND xref_category_id = i_category_id
689: AND xref_std_value = rtrim(io_value);
690: o_return_status := 0;

Line 706: FROM ecx_xref_standards

702: END;
703: BEGIN
704: SELECT xref_int_value
705: INTO l_int_val
706: FROM ecx_xref_standards
707: WHERE standard_id = l_univ_std_id
708: AND xref_category_id = i_category_id
709: AND xref_std_value = rtrim(io_value);
710: o_return_status := 0;

Line 740: FROM ecx_xref_standards

736: WHEN no_data_found THEN
737: BEGIN
738: SELECT xref_std_value
739: INTO l_ext_val
740: FROM ecx_xref_standards
741: WHERE standard_id = i_standard_id
742: AND xref_category_id = i_category_id
743: AND xref_int_value = io_value;
744: o_return_status := 0;

Line 750: FROM ecx_xref_standards

746: WHEN no_data_found THEN
747: BEGIN
748: SELECT xref_std_value
749: INTO l_ext_val
750: FROM ecx_xref_standards
751: WHERE standard_id = l_univ_std_id
752: AND xref_category_id = i_category_id
753: AND xref_int_value = io_value;
754: o_return_status := 0;