eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ECX_CODE_CONVERSION_PVT dependencies on STANDARD

Line 17: p_standard_id IN NUMBER,

13: p_init_msg_list IN VARCHAR2 := G_FALSE,
14: p_simulate IN VARCHAR2 := G_FALSE,
15: p_commit IN VARCHAR2 := G_FALSE,
16: p_validation_level IN NUMBER := G_VALID_LEVEL_FULL,
17: p_standard_id IN NUMBER,
18: p_return_status OUT NOCOPY VARCHAR2,
19: p_msg_count OUT NOCOPY PLS_INTEGER,
20: p_msg_data OUT NOCOPY VARCHAR2,
21: p_level IN PLS_INTEGER,

Line 38: l_standard_id NUMBER; /* Bug 2110362

34: i PLS_INTEGER;
35: xref_success CONSTANT VARCHAR2(1) := 0;
36: xref_warning CONSTANT VARCHAR2(1) := 1;
37:
38: l_standard_id NUMBER; /* Bug 2110362
39: The standard_id for the custom
40: standard. */
41: l_univ_std_id pls_integer;
42: l_standard_type Varchar2(200);

Line 39: The standard_id for the custom

35: xref_success CONSTANT VARCHAR2(1) := 0;
36: xref_warning CONSTANT VARCHAR2(1) := 1;
37:
38: l_standard_id NUMBER; /* Bug 2110362
39: The standard_id for the custom
40: standard. */
41: l_univ_std_id pls_integer;
42: l_standard_type Varchar2(200);
43:

Line 40: standard. */

36: xref_warning CONSTANT VARCHAR2(1) := 1;
37:
38: l_standard_id NUMBER; /* Bug 2110362
39: The standard_id for the custom
40: standard. */
41: l_univ_std_id pls_integer;
42: l_standard_type Varchar2(200);
43:
44: BEGIN

Line 42: l_standard_type Varchar2(200);

38: l_standard_id NUMBER; /* Bug 2110362
39: The standard_id for the custom
40: standard. */
41: l_univ_std_id pls_integer;
42: l_standard_type Varchar2(200);
43:
44: BEGIN
45: if (l_procedureEnabled) then
46: ecx_debug.push(i_method_name);

Line 56: -- Standard Start of API savepoint

52: ecx_debug.log(l_statement, 'p_commit: ',p_commit,i_method_name);
53: ecx_debug.log(l_statement, 'p_validation_level: ',p_validation_level,i_method_name);
54: end if;
55:
56: -- Standard Start of API savepoint
57: SAVEPOINT populate_plsql_tbl_ext_PVT;
58:
59: -- Initialize API return status to success
60: p_return_status := g_ret_sts_success;

Line 63: select standard_type

59: -- Initialize API return status to success
60: p_return_status := g_ret_sts_success;
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

Line 64: into l_standard_type

60: p_return_status := g_ret_sts_success;
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

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 66: where standard_id = p_standard_id;

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';
70: end;

Line 69: l_standard_type := 'XML';

65: from ecx_standards
66: where standard_id = p_standard_id;
67: exception
68: when others then
69: l_standard_type := 'XML';
70: end;
71:
72: /* Bug 2110362
73: The Code conversion now has the following approach,

Line 74: 1. Obtain standard id meant for the standard CUSTOM.

70: end;
71:
72: /* Bug 2110362
73: The Code conversion now has the following approach,
74: 1. Obtain standard id meant for the standard CUSTOM.
75: 2. Determine if code conversion is defined for CUSTOM.
76: If yes, return the value defined.
77: 3. If No, determine if conversion is defined for the
78: transaction's standard (based on p_standard) and return

Line 78: transaction's standard (based on p_standard) and return

74: 1. Obtain standard id meant for the standard CUSTOM.
75: 2. Determine if code conversion is defined for CUSTOM.
76: If yes, return the value defined.
77: 3. If No, determine if conversion is defined for the
78: transaction's standard (based on p_standard) and return
79: the value accordingly. */
80:
81: BEGIN
82: SELECT standard_id

Line 82: SELECT standard_id

78: transaction's standard (based on p_standard) and return
79: the value accordingly. */
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;

Line 83: INTO l_standard_id

79: the value accordingly. */
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

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 85: WHERE standard_code = 'CUSTOM'

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
89: l_standard_id := -1;

Line 86: and standard_type = l_standard_type;

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
89: l_standard_id := -1;
90: END;

Line 89: l_standard_id := -1;

85: WHERE standard_code = 'CUSTOM'
86: and standard_type = l_standard_type;
87: EXCEPTION
88: WHEN OTHERS THEN
89: l_standard_id := -1;
90: END;
91:
92: i := ecx_utils.g_source_levels(p_level).file_start_pos;
93: LOOP

Line 112: standard_id = l_standard_id AND

108: INTO l_ext_val
109: FROM ecx_xref_dtl
110: WHERE tp_header_id = p_tp_id AND
111: xref_int_value = p_tbl(i).value AND
112: standard_id = l_standard_id AND
113: xref_category_id = p_tbl(i).xref_category_id AND
114: direction = 'OUT';
115:
116: p_tbl(i).value := nvl(l_ext_val,l_var_value);

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 126: WHERE standard_id = p_standard_id

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
130: ecx_debug.log(l_statement,'Using Standard Conversion',i_method_name);

Line 130: ecx_debug.log(l_statement,'Using Standard Conversion',i_method_name);

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
130: ecx_debug.log(l_statement,'Using Standard Conversion',i_method_name);
131: end if;
132: p_tbl(i).value := nvl(l_ext_val,l_var_value);
133: p_tbl(i).xref_retcode := xref_success;
134: EXCEPTION

Line 137: SELECT standard_id

133: p_tbl(i).xref_retcode := xref_success;
134: EXCEPTION
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;

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 140: WHERE standard_code = 'UNIVERSAL'

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
144: l_univ_std_id := -1;

Line 141: and standard_type = l_standard_type;

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
144: l_univ_std_id := -1;
145: END;

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 150: WHERE standard_id = l_univ_std_id

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
154: ecx_debug.log(l_statement,'Using Universal Conversion',i_method_name);

Line 179: ' standard code conversion value for '||

175: /* Start of changes for Bug #2242061 */
176: WHEN TOO_MANY_ROWS THEN
177: if(l_unexpectedEnabled) then
178: ecx_debug.log(l_unexpected, 'Data is Corrupted, Cannot resolve a unique' ||
179: ' standard code conversion value for '||
180: p_tbl(i).attribute_name, l_var_value,i_method_name);
181: end if;
182: p_tbl(i).value := l_var_value;
183: p_tbl(i).xref_retcode := xref_warning;

Line 252: p_standard_id IN NUMBER ,

248: p_init_msg_list IN VARCHAR2 := G_FALSE,
249: p_simulate IN VARCHAR2 := G_FALSE,
250: p_commit IN VARCHAR2 := G_FALSE,
251: p_validation_level IN NUMBER := G_VALID_LEVEL_FULL,
252: p_standard_id IN NUMBER ,
253: p_return_status OUT NOCOPY VARCHAR2,
254: p_msg_count OUT NOCOPY PLS_INTEGER,
255: p_msg_data OUT NOCOPY VARCHAR2,
256: p_level IN PLS_INTEGER,

Line 285: -- Standard Start of API savepoint

281: ecx_debug.log(l_statement, 'p_simulate: ',p_simulate,i_method_name);
282: ecx_debug.log(l_statement, 'p_commit: ',p_commit,i_method_name);
283: ecx_debug.log(l_statement, 'p_validation_level: ',p_validation_level,i_method_name);
284: end if;
285: -- Standard Start of API savepoint
286: SAVEPOINT populate_plsql_tbl_int_PVT;
287:
288: -- Initialize API return status to success
289: p_return_status := g_ret_sts_success;

Line 308: standard_id = p_standard_id AND

304: SELECT xref_int_value
305: INTO l_int_val
306: FROM ecx_xref_dtl
307: WHERE tp_header_id = p_tp_id AND
308: standard_id = p_standard_id AND
309: xref_category_id = p_apps_tbl(j).xref_category_id AND
310: xref_ext_value = p_apps_tbl(j).value AND
311: direction = 'IN';
312: p_apps_tbl(j).value := l_int_val;

Line 317: ecx_debug.log(l_unexpected, 'Using Standard Conversion',i_method_name);

313: p_apps_tbl(j).xref_retcode := xref_success;
314: EXCEPTION
315: WHEN NO_DATA_FOUND THEN
316: if(l_unexpectedEnabled) then
317: ecx_debug.log(l_unexpected, 'Using Standard Conversion',i_method_name);
318: end if;
319: null;
320: BEGIN
321: SELECT xref_std_value

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 324: WHERE standard_id = p_standard_id

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:
328: p_apps_tbl(j).value := nvl(l_int_val,l_var_value);

Line 350: -- Standard check of p_simulate and p_commit parameters

346: j := ecx_utils.g_source.next(j);
347: END LOOP;
348:
349: -- *******************************************************
350: -- Standard check of p_simulate and p_commit parameters
351: -- *******************************************************
352:
353: if (l_procedureEnabled) then
354: ecx_debug.pop(i_method_name);

Line 389: p_standard_id IN NUMBER,

385: p_init_msg_list IN VARCHAR2 := G_FALSE,
386: p_simulate IN VARCHAR2 := G_FALSE,
387: p_commit IN VARCHAR2 := G_FALSE,
388: p_validation_level IN NUMBER := G_VALID_LEVEL_FULL,
389: p_standard_id IN NUMBER,
390: p_return_status OUT NOCOPY VARCHAR2,
391: p_msg_count OUT NOCOPY PLS_INTEGER,
392: p_msg_data OUT NOCOPY VARCHAR2,
393: p_value IN OUT NOCOPY VARCHAR2,

Line 410: l_standard_id NUMBER; /* Bug 2110362

406: l_msg_data VARCHAR2(2000);
407: l_int_val VARCHAR2(4000) := NULL;
408: l_ext_val VARCHAR2(4000) := NULL;
409: l_var_value VARCHAR2(4000);
410: l_standard_id NUMBER; /* Bug 2110362
411: The standard_id for the custom
412: standard. */
413: l_univ_std_id pls_integer;
414: l_standard_type varchar2(200);

Line 411: The standard_id for the custom

407: l_int_val VARCHAR2(4000) := NULL;
408: l_ext_val VARCHAR2(4000) := NULL;
409: l_var_value VARCHAR2(4000);
410: l_standard_id NUMBER; /* Bug 2110362
411: The standard_id for the custom
412: standard. */
413: l_univ_std_id pls_integer;
414: l_standard_type varchar2(200);
415:

Line 412: standard. */

408: l_ext_val VARCHAR2(4000) := NULL;
409: l_var_value VARCHAR2(4000);
410: l_standard_id NUMBER; /* Bug 2110362
411: The standard_id for the custom
412: standard. */
413: l_univ_std_id pls_integer;
414: l_standard_type varchar2(200);
415:
416: BEGIN

Line 414: l_standard_type varchar2(200);

410: l_standard_id NUMBER; /* Bug 2110362
411: The standard_id for the custom
412: standard. */
413: l_univ_std_id pls_integer;
414: l_standard_type varchar2(200);
415:
416: BEGIN
417: if (l_procedureEnabled) then
418: ecx_debug.push(i_method_name);

Line 428: -- Standard Start of API savepoint

424: ecx_debug.log(l_statement, 'p_snd_tp_id: ',p_snd_tp_id,i_method_name);
425: ecx_debug.log(l_statement, 'p_rec_tp_id: ',p_rec_tp_id,i_method_name);
426: end if;
427:
428: -- Standard Start of API savepoint
429: SAVEPOINT populate_value_extpt_PVT;
430:
431: -- Initialize API return status to success
432: p_return_status := g_ret_sts_success;

Line 440: select standard_type

436: end if;
437: l_var_value := p_value;
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

Line 441: into l_standard_type

437: l_var_value := p_value;
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

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 443: where standard_id = p_standard_id;

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';
447: end;

Line 446: l_standard_type := 'XML';

442: from ecx_standards
443: where standard_id = p_standard_id;
444: exception
445: when others then
446: l_standard_type := 'XML';
447: end;
448:
449: /* Bug 2110362
450: The Code conversion now has the following approach,

Line 451: 1. Obtain standard id meant for the standard CUSTOM.

447: end;
448:
449: /* Bug 2110362
450: The Code conversion now has the following approach,
451: 1. Obtain standard id meant for the standard CUSTOM.
452: 2. Determine if code conversion is defined for CUSTOM.
453: If yes, return the value defined.
454: 3. If No, determine if conversion is defined for the
455: transaction's standard (based on p_standard) and return

Line 455: transaction's standard (based on p_standard) and return

451: 1. Obtain standard id meant for the standard CUSTOM.
452: 2. Determine if code conversion is defined for CUSTOM.
453: If yes, return the value defined.
454: 3. If No, determine if conversion is defined for the
455: transaction's standard (based on p_standard) and return
456: the value accordingly. */
457:
458: BEGIN
459: SELECT standard_id

Line 459: SELECT standard_id

455: transaction's standard (based on p_standard) and return
456: the value accordingly. */
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;

Line 460: INTO l_standard_id

456: the value accordingly. */
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

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 462: WHERE standard_code = 'CUSTOM'

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
466: l_standard_id := -1;

Line 463: and standard_type = l_standard_type;

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
466: l_standard_id := -1;
467: END;

Line 466: l_standard_id := -1;

462: WHERE standard_code = 'CUSTOM'
463: and standard_type = l_standard_type;
464: EXCEPTION
465: WHEN OTHERS THEN
466: l_standard_id := -1;
467: END;
468:
469: IF p_value IS NOT NULL THEN
470: BEGIN

Line 472: Replaced reference to p_standard_id with l_standard_id. */

468:
469: IF p_value IS NOT NULL THEN
470: BEGIN
471: /* Bug 2110362
472: Replaced reference to p_standard_id with l_standard_id. */
473: SELECT xref_int_value
474: INTO l_int_val
475: FROM ecx_xref_dtl
476: WHERE tp_header_id = p_snd_tp_id AND

Line 477: standard_id = l_standard_id AND

473: SELECT xref_int_value
474: INTO l_int_val
475: FROM ecx_xref_dtl
476: WHERE tp_header_id = p_snd_tp_id AND
477: standard_id = l_standard_id AND
478: xref_category_id = p_category_id AND
479: xref_ext_value = p_value AND
480: direction = 'IN';
481: p_return_status := 0;

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 488: WHERE standard_id = p_standard_id

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;
492: exception

Line 495: SELECT standard_id

491: p_return_status := 0;
492: exception
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;

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

Line 498: WHERE standard_code = 'UNIVERSAL'

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
502: l_univ_std_id := -1;

Line 499: and standard_type = l_standard_type;

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
502: l_univ_std_id := -1;
503: END;

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 508: WHERE standard_id = l_univ_std_id

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;
512: exception

Line 531: Replaced reference to p_standard_id with

527:
528: IF (l_int_val IS NOT NULL AND p_rec_tp_id IS NOT NULL) THEN
529: BEGIN
530: /* Bug 2110362
531: Replaced reference to p_standard_id with
532: l_standard_id. */
533: SELECT xref_ext_value
534: INTO l_ext_val
535: FROM ecx_xref_dtl

Line 532: l_standard_id. */

528: IF (l_int_val IS NOT NULL AND p_rec_tp_id IS NOT NULL) THEN
529: BEGIN
530: /* Bug 2110362
531: Replaced reference to p_standard_id with
532: l_standard_id. */
533: SELECT xref_ext_value
534: INTO l_ext_val
535: FROM ecx_xref_dtl
536: WHERE tp_header_id = p_rec_tp_id AND

Line 537: standard_id = l_standard_id AND

533: SELECT xref_ext_value
534: INTO l_ext_val
535: FROM ecx_xref_dtl
536: WHERE tp_header_id = p_rec_tp_id AND
537: standard_id = l_standard_id AND
538: xref_category_id = p_category_id AND
539: xref_int_value = l_int_val AND
540: direction = 'OUT';
541: 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 548: WHERE standard_id = p_standard_id

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;
552: exception

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 558: WHERE standard_id = l_univ_std_id

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;
562: exception

Line 586: -- Standard check of p_simulate and p_commit parameters

582: end if;
583:
584:
585: -- *******************************************************
586: -- Standard check of p_simulate and p_commit parameters
587: -- *******************************************************
588:
589: if (l_procedureEnabled) then
590: ecx_debug.pop(i_method_name);