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.

[Home] [Help]

APPS.IGS_AD_GEN_016 dependencies on DBMS_UTILITY

Line 52: ln_hash_lkcode_idx := DBMS_UTILITY.get_hash_value (

48:
49: ELSE
50: lv_ret_success := 'FALSE';
51: -- Get the hash value of the Type + Code + View Appl ID
52: ln_hash_lkcode_idx := DBMS_UTILITY.get_hash_value (
53: p_lookup_type||'@*?'||p_lookup_code||'@*?'||igs_ge_number.to_cann(p_application_id)
54: ||'@*?'||l_language||'@*?'||igs_ge_number.to_cann(l_security_group_id),
55: 1000,
56: 25000);

Line 69: ln_hash_lktype_idx := DBMS_UTILITY.get_hash_value (

65:
66: ELSE
67: -- Check if the Type is already cached
68: -- Get the hash value of the Type + View Appl ID
69: ln_hash_lktype_idx := DBMS_UTILITY.get_hash_value (
70: p_lookup_type||'@*?'||igs_ge_number.to_cann(p_application_id)
71: ||'@*?'||igs_ge_number.to_cann(l_security_group_id),
72: 1000,
73: 25000);

Line 96: ln_hash_lkcode_idx := DBMS_UTILITY.get_hash_value (

92: lb_is_lktype_cached := TRUE;
93: g_hash_lookup_type_tab(ln_hash_lktype_idx) := p_lookup_type;
94: END IF;
95:
96: ln_hash_lkcode_idx := DBMS_UTILITY.get_hash_value (
97: p_lookup_type||'@*?'||lr_fetched_lkcode.lookup_code||'@*?'||igs_ge_number.to_cann(p_application_id)
98: ||'@*?'||l_language||'@*?'||igs_ge_number.to_cann(l_security_group_id),
99: 1000,
100: 25000);

Line 161: ln_hash_lkcode_idx := DBMS_UTILITY.get_hash_value (

157: p_lookup_code => p_lookup_code,
158: p_application_id => p_application_id) = 'TRUE' THEN
159:
160: -- Get the hash value of the Type + Code + View Appl ID
161: ln_hash_lkcode_idx := DBMS_UTILITY.get_hash_value (
162: p_lookup_type||'@*?'||p_lookup_code||'@*?'||igs_ge_number.to_cann(p_application_id)
163: ||'@*?'||l_language||'@*?'||igs_ge_number.to_cann(l_security_group_id),
164: 1000,
165: 25000);

Line 215: ln_hash_msg_type_idx := DBMS_UTILITY.get_hash_value (

211:
212: ELSE
213: lv_ret_success := 'FALSE';
214: -- Get the hash value of the Type + Code + View Appl ID
215: ln_hash_msg_type_idx := DBMS_UTILITY.get_hash_value (
216: p_message_name||'@*?'||igs_ge_number.to_cann(ln_application_id)||'@*?'||l_language,
217: 1000,
218: 25000);
219:

Line 234: ln_hash_msg_type_idx := DBMS_UTILITY.get_hash_value (

230: LOOP
231: FETCH c_msg_type into lr_fetched_msg_type;
232: EXIT WHEN c_msg_type%NOTFOUND;
233:
234: ln_hash_msg_type_idx := DBMS_UTILITY.get_hash_value (
235: p_message_name||'@*?'||igs_ge_number.to_cann(ln_application_id)||'@*?'||l_language,
236: 1000,
237: 25000);
238:

Line 338: ln_hash_srccat_idx := DBMS_UTILITY.get_hash_value (

334:
335: ELSE
336: lv_ret_success := 'FALSE';
337: -- Get the hash value of the Source Type ID + Category
338: ln_hash_srccat_idx := DBMS_UTILITY.get_hash_value (
339: igs_ge_number.to_cann(p_source_type_id)||'@*?'||p_category_name,
340: 1000,
341: 25000);
342:

Line 373: ln_hash_stypeid_idx := DBMS_UTILITY.get_hash_value (

369:
370: ELSE
371: -- Check if the Source Type ID is already cached
372: -- Get the hash value of the Source Type ID
373: ln_hash_stypeid_idx := DBMS_UTILITY.get_hash_value (
374: igs_ge_number.to_cann(p_source_type_id),
375: 1000,
376: 25000);
377:

Line 399: ln_hash_srccat_idx := DBMS_UTILITY.get_hash_value (

395: lb_is_stypeid_cached := TRUE;
396: g_hash_stypeid_tab(ln_hash_stypeid_idx) := p_source_type_id;
397: END IF;
398:
399: ln_hash_srccat_idx := DBMS_UTILITY.get_hash_value (
400: igs_ge_number.to_cann(p_source_type_id)||'@*?'||lr_fetched_srccat.category_name,
401: 1000,
402: 25000);
403:

Line 518: ln_hash_dflt_cc_id_hashidx_idx := DBMS_UTILITY.get_hash_value (

514: IF (p_class IS NULL OR p_system_status IS NULL) THEN
515: RETURN ('FALSE');
516:
517: ELSE
518: ln_hash_dflt_cc_id_hashidx_idx := DBMS_UTILITY.get_hash_value (
519: p_class||'@*?'||p_system_status||'@*?'||'Y',
520: 1000,
521: 25000);
522:

Line 578: ln_hash_name_cc_id_hashidx_idx := DBMS_UTILITY.get_hash_value (

574: ELSE
575: -- Code name has been passed
576: IF p_name IS NOT NULL THEN
577: -- Get the hash value of the Class + Code Name
578: ln_hash_name_cc_id_hashidx_idx := DBMS_UTILITY.get_hash_value (
579: p_class||'@*?'||p_name,
580: 1000,
581: 25000);
582:

Line 589: ln_hash_ccode_idx := DBMS_UTILITY.get_hash_value (

585: END IF;
586:
587: ELSIF p_code_id IS NOT NULL THEN
588: -- Get the hash value of the Type + Code ID
589: ln_hash_ccode_idx := DBMS_UTILITY.get_hash_value (
590: p_class||'@*?'||igs_ge_number.to_cann(p_code_id),
591: 1000,
592: 25000);
593: END IF;

Line 637: ln_hash_cclass_idx := DBMS_UTILITY.get_hash_value (

633:
634: ELSE
635: -- Check if the Class is already cached
636: -- Get the hash value of the Class
637: ln_hash_cclass_idx := DBMS_UTILITY.get_hash_value (
638: p_class,
639: 1000,
640: 25000);
641:

Line 663: ln_hash_ccode_idx := DBMS_UTILITY.get_hash_value (

659: lb_is_cclass_cached := TRUE;
660: g_hash_cclass_tab(ln_hash_cclass_idx) := p_class;
661: END IF;
662:
663: ln_hash_ccode_idx := DBMS_UTILITY.get_hash_value (
664: p_class||'@*?'||igs_ge_number.to_cann(lr_fetched_ccode.code_id),
665: 1000,
666: 25000);
667:

Line 674: ln_hash_name_cc_id_hashidx_idx := DBMS_UTILITY.get_hash_value (

670: g_hash_ccode_tab(ln_hash_ccode_idx).system_status := lr_fetched_ccode.system_status;
671: g_hash_ccode_tab(ln_hash_ccode_idx).closed_ind := lr_fetched_ccode.closed_ind;
672: g_hash_ccode_tab(ln_hash_ccode_idx).system_default := lr_fetched_ccode.system_default;
673:
674: ln_hash_name_cc_id_hashidx_idx := DBMS_UTILITY.get_hash_value (
675: p_class||'@*?'||lr_fetched_ccode.name,
676: 1000,
677: 25000);
678:

Line 684: ln_hash_dflt_cc_id_hashidx_idx := DBMS_UTILITY.get_hash_value (

680:
681: IF lr_fetched_ccode.closed_ind = 'N' AND
682: NVL(lr_fetched_ccode.system_default,'N') = 'Y' AND
683: lr_fetched_ccode.system_status IS NOT NULL THEN
684: ln_hash_dflt_cc_id_hashidx_idx := DBMS_UTILITY.get_hash_value (
685: p_class||'@*?'||lr_fetched_ccode.system_status||'@*?'||'Y',
686: 1000,
687: 25000);
688:

Line 777: ln_hash_appl_type_apc_idx := DBMS_UTILITY.get_hash_value (

773: RETURN ('FALSE');
774:
775: ELSE
776: -- Get the hash value of the Application Type
777: ln_hash_appl_type_apc_idx := DBMS_UTILITY.get_hash_value (
778: p_application_type,
779: 1000,
780: 25000);
781:

Line 799: ln_hash_appl_type_apc_idx := DBMS_UTILITY.get_hash_value (

795: LOOP
796: FETCH c_appl_type_apc into lr_fetched_appl_type_apc;
797: EXIT WHEN c_appl_type_apc%NOTFOUND;
798:
799: ln_hash_appl_type_apc_idx := DBMS_UTILITY.get_hash_value (
800: lr_fetched_appl_type_apc.admission_application_type,
801: 1000,
802: 25000);
803:

Line 902: ln_hash_apcs_idx := DBMS_UTILITY.get_hash_value (

898: RETURN ('FALSE');
899:
900: ELSE
901: -- Get the hash value of the Admission Category + System Process Type + System Step
902: ln_hash_apcs_idx := DBMS_UTILITY.get_hash_value (
903: p_admission_cat||'@*?'||p_s_admission_process_type||'@*?'||p_s_admission_step_type,
904: 1000,
905: 25000);
906:

Line 928: ln_hash_apc_idx := DBMS_UTILITY.get_hash_value (

924:
925: ELSE
926: -- Check if the Admission Category + System Process Type is already cached
927: -- Get the hash value of the Admission Category + System Process Type
928: ln_hash_apc_idx := DBMS_UTILITY.get_hash_value (
929: p_admission_cat||'@*?'||p_s_admission_process_type,
930: 1000,
931: 25000);
932:

Line 955: ln_hash_apcs_idx := DBMS_UTILITY.get_hash_value (

951: g_hash_apc_tab(ln_hash_apc_idx).admission_cat := p_admission_cat;
952: g_hash_apc_tab(ln_hash_apc_idx).s_admission_process_type := p_s_admission_process_type;
953: END IF;
954:
955: ln_hash_apcs_idx := DBMS_UTILITY.get_hash_value (
956: p_admission_cat||'@*?'||p_s_admission_process_type||'@*?'||lr_fetched_apcs.s_admission_step_type,
957: 1000,
958: 25000);
959: