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.JAI_CMN_UTILS_PKG dependencies on JAI_CMN_UTILS_PKG

Line 1: PACKAGE BODY jai_cmn_utils_pkg AS

1: PACKAGE BODY jai_cmn_utils_pkg AS
2: /* $Header: jai_cmn_utils.plb 120.8 2007/05/18 12:16:51 bgowrava ship $ */
3:
4: /********************************************************************************************************
5: FILENAME : ja_in_util_pkg_b.sql

Line 273: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_utils_pkg.update_rg_slno';

269: ln_slno NUMBER;
270: ln_closing_balance NUMBER;
271:
272: /* Added by Ramananda for bug#4407165 */
273: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_utils_pkg.update_rg_slno';
274:
275:
276: PROCEDURE insert_record(
277: pn_organization_id NUMBER,

Line 361: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_utils_pkg.currency_conversion';

357: Select currency_code from gl_sets_of_books
358: where set_of_books_id = c_set_of_books_id;
359:
360: /* Added by Ramananda for bug#4407165 */
361: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_utils_pkg.currency_conversion';
362:
363: Begin
364: -- Bug 5148770. Added by Lakshmi Gopalsami
365:

Line 366: print_log('jai_cmn_utils_pkg.currency_conversion.log',' SOB'|| c_set_of_books_id);

362:
363: Begin
364: -- Bug 5148770. Added by Lakshmi Gopalsami
365:
366: print_log('jai_cmn_utils_pkg.currency_conversion.log',' SOB'|| c_set_of_books_id);
367:
368: Open currency_code_cur;
369: Fetch currency_code_cur Into v_func_curr;
370: Close currency_code_cur;

Line 374: print_log('jai_cmn_utils_pkg.currency_conversion.log',' Func curr '|| v_func_curr);

370: Close currency_code_cur;
371:
372: -- Bug 5148770. Added by Lakshmi Gopalsami
373:
374: print_log('jai_cmn_utils_pkg.currency_conversion.log',' Func curr '|| v_func_curr);
375: print_log('jai_cmn_utils_pkg.currency_conversion.log', 'FROM curr code '|| c_from_currency_code);
376:
377: If NVL(v_func_curr,'NO') = c_from_currency_code Then
378: -- Bug 5148770. Added by Lakshmi Gopalsami

Line 375: print_log('jai_cmn_utils_pkg.currency_conversion.log', 'FROM curr code '|| c_from_currency_code);

371:
372: -- Bug 5148770. Added by Lakshmi Gopalsami
373:
374: print_log('jai_cmn_utils_pkg.currency_conversion.log',' Func curr '|| v_func_curr);
375: print_log('jai_cmn_utils_pkg.currency_conversion.log', 'FROM curr code '|| c_from_currency_code);
376:
377: If NVL(v_func_curr,'NO') = c_from_currency_code Then
378: -- Bug 5148770. Added by Lakshmi Gopalsami
379: print_log('jai_cmn_utils_pkg.currency_conversion.log',

Line 379: print_log('jai_cmn_utils_pkg.currency_conversion.log',

375: print_log('jai_cmn_utils_pkg.currency_conversion.log', 'FROM curr code '|| c_from_currency_code);
376:
377: If NVL(v_func_curr,'NO') = c_from_currency_code Then
378: -- Bug 5148770. Added by Lakshmi Gopalsami
379: print_log('jai_cmn_utils_pkg.currency_conversion.log',
380: ' func curr and from curr same - return 1');
381:
382: ret_value := 1;
383:

Line 386: print_log('jai_cmn_utils_pkg.currency_conversion.log',

382: ret_value := 1;
383:
384: Elsif upper(c_conversion_type) = 'USER' Then
385: -- Bug 5148770. Added by Lakshmi Gopalsami
386: print_log('jai_cmn_utils_pkg.currency_conversion.log',
387: ' User entered the rate - return '|| c_conversion_rate);
388: ret_value := c_conversion_rate;
389:
390: Else

Line 422: print_log('jai_cmn_utils_pkg.currency_conversion.log',

418: FETCH Chk_Derived_Type_Cur INTO v_dr_type;
419: CLOSE Chk_Derived_Type_Cur;
420:
421: -- Bug 5148770. Added by Lakshmi Gopalsami
422: print_log('jai_cmn_utils_pkg.currency_conversion.log',
423: ' derived type '|| v_dr_type);
424:
425: IF v_dr_type IS NULL THEN
426:

Line 436: print_log('jai_cmn_utils_pkg.currency_conversion.log',

432: FETCH get_curr_rate INTO ret_value;
433: CLOSE get_curr_rate;
434:
435: -- Bug 5148770. Added by Lakshmi Gopalsami
436: print_log('jai_cmn_utils_pkg.currency_conversion.log',
437: ' derive type null - return value '|| ret_value);
438: ELSE
439:
440: IF v_dr_type in('EMU','EURO') THEN

Line 454: print_log('jai_cmn_utils_pkg.currency_conversion.log',

450: FETCH get_curr_rate INTO ret_value;
451: CLOSE get_curr_rate;
452:
453: -- Bug 5148770. Added by Lakshmi Gopalsami
454: print_log('jai_cmn_utils_pkg.currency_conversion.log',
455: ' EURO/EMU - derive type - return value '|| ret_value);
456: END IF;
457:
458: END IF;

Line 537: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_utils_pkg.opm_uom_version';

533: Select item_um From ic_item_mst
534: Where item_id = p_item_id;
535:
536: Added by Ramananda for bug#4407165
537: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_utils_pkg.opm_uom_version';
538:
539: BEGIN
540: OPEN C_Uom_Type(from_uom);
541: FETCH C_Uom_Type INTO f_uom_type,f_ref_um;

Line 581: x:= jai_cmn_utils_pkg.opm_uom_version(to_uom,from_uom,p_item_id);

577: ELSE
578: return(round((l_std_factor/(l_std_factor_typ_1*l_std_factor_t)),9));
579: END IF;
580: ELSIF l_item_um = to_uom THEN
581: x:= jai_cmn_utils_pkg.opm_uom_version(to_uom,from_uom,p_item_id);
582: IF x = 0 THEN
583: return(x);
584: ELSE
585: return(1/x);

Line 588: x := jai_cmn_utils_pkg.opm_uom_version(l_item_um,from_uom,p_item_id);

584: ELSE
585: return(1/x);
586: END IF;
587: ELSE
588: x := jai_cmn_utils_pkg.opm_uom_version(l_item_um,from_uom,p_item_id);
589: y := jai_cmn_utils_pkg.opm_uom_version(l_item_um,to_uom,p_item_id);
590: IF x > 0 THEN
591: z := y/x;
592: ELSE

Line 589: y := jai_cmn_utils_pkg.opm_uom_version(l_item_um,to_uom,p_item_id);

585: return(1/x);
586: END IF;
587: ELSE
588: x := jai_cmn_utils_pkg.opm_uom_version(l_item_um,from_uom,p_item_id);
589: y := jai_cmn_utils_pkg.opm_uom_version(l_item_um,to_uom,p_item_id);
590: IF x > 0 THEN
591: z := y/x;
592: ELSE
593: z := 0;

Line 617: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_utils_pkg.get_opm_assessable_value';

613: From JAI_OPM_ITM_MASTERS
614: Where item_id = p_item_id;
615:
616: -- Added by Ramananda for bug#4407165
617: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_utils_pkg.get_opm_assessable_value';
618:
619: ---Added For OPM Localization By A.Raina on 22-02-2000
620: ---Code Added For Fetching the Assessable_value at the customer level
621:

Line 831: END jai_cmn_utils_pkg;

827: RETURN b_process_po;
828: END validate_po_type;
829:
830:
831: END jai_cmn_utils_pkg;