DBA Data[Home] [Help]

APPS.ECX_CODE_CONVERSION_PVT dependencies on ECX_STANDARDS

Line 65: from ecx_standards

61:
62: begin
63: select standard_type
64: into l_standard_type
65: from ecx_standards
66: where standard_id = p_standard_id;
67: exception
68: when others then
69: l_standard_type := 'XML';

Line 84: FROM ecx_standards

80:
81: BEGIN
82: SELECT standard_id
83: INTO l_standard_id
84: FROM ecx_standards
85: WHERE standard_code = 'CUSTOM'
86: and standard_type = l_standard_type;
87: EXCEPTION
88: WHEN OTHERS THEN

Line 139: FROM ecx_standards

135: when no_data_found then
136: BEGIN
137: SELECT standard_id
138: INTO l_univ_std_id
139: FROM ecx_standards
140: WHERE standard_code = 'UNIVERSAL'
141: and standard_type = l_standard_type;
142: EXCEPTION
143: WHEN OTHERS THEN

Line 442: from ecx_standards

438:
439: begin
440: select standard_type
441: into l_standard_type
442: from ecx_standards
443: where standard_id = p_standard_id;
444: exception
445: when others then
446: l_standard_type := 'XML';

Line 461: FROM ecx_standards

457:
458: BEGIN
459: SELECT standard_id
460: INTO l_standard_id
461: FROM ecx_standards
462: WHERE standard_code = 'CUSTOM'
463: and standard_type = l_standard_type;
464: EXCEPTION
465: WHEN OTHERS THEN

Line 497: FROM ecx_standards

493: when no_data_found then
494: BEGIN
495: SELECT standard_id
496: INTO l_univ_std_id
497: FROM ecx_standards
498: WHERE standard_code = 'UNIVERSAL'
499: and standard_type = l_standard_type;
500: EXCEPTION
501: WHEN OTHERS THEN