APPS.GMD_QC_MIGRATE_TO_1151J dependencies on FND_PROFILE

Line 5: G_display_precision PLS_INTEGER := to_number(NVL(fnd_profile.value('GMD_MIG_TEST_STORAGE_PRECISION'),'0'));

1: PACKAGE BODY GMD_QC_MIGRATE_TO_1151J AS
2: /* $Header: GMDQCMJB.pls 120.1 2006/08/29 21:14:28 rakulkar noship $ */
3:
4: --Bug 5025951
5: G_display_precision PLS_INTEGER := to_number(NVL(fnd_profile.value('GMD_MIG_TEST_STORAGE_PRECISION'),'0'));
6: G_report_precision PLS_INTEGER := to_number(NVL(fnd_profile.value('GMD_MIG_TEST_REPORT_PRECISION'), '0'));
7:
8: /*===========================================================================
9: -- FUNCTION:

Line 6: G_report_precision PLS_INTEGER := to_number(NVL(fnd_profile.value('GMD_MIG_TEST_REPORT_PRECISION'), '0'));

2: /* $Header: GMDQCMJB.pls 120.1 2006/08/29 21:14:28 rakulkar noship $ */
3:
4: --Bug 5025951
5: G_display_precision PLS_INTEGER := to_number(NVL(fnd_profile.value('GMD_MIG_TEST_STORAGE_PRECISION'),'0'));
6: G_report_precision PLS_INTEGER := to_number(NVL(fnd_profile.value('GMD_MIG_TEST_REPORT_PRECISION'), '0'));
7:
8: /*===========================================================================
9: -- FUNCTION:
10: -- Get_Base_Language

Line 2430: l_max_date := trunc(to_date(nvl(fnd_profile.value('SY$MAX_DATE'),'2010/12/31'), 'YYYY/MM/DD' ));

2426: l_1 := 1;
2427:
2428: -- Begin Bug 4252591 Clear VR end dates if those match SY$MAX_DATE
2429: BEGIN
2430: l_max_date := trunc(to_date(nvl(fnd_profile.value('SY$MAX_DATE'),'2010/12/31'), 'YYYY/MM/DD' ));
2431: EXCEPTION
2432: WHEN OTHERS THEN
2433: l_max_date := trunc(to_date('2010/12/31' , 'YYYY/MM/DD'));
2434: END;

Line 2637: l_owner_orgn_code := TRIM(FND_PROFILE.value_specific('GEMMS_DEFAULT_ORGN',update_rec.last_updated_by));

2633: OPEN c_get_last_update;
2634: FETCH c_get_last_update into update_rec;
2635: CLOSE c_get_last_update;
2636:
2637: l_owner_orgn_code := TRIM(FND_PROFILE.value_specific('GEMMS_DEFAULT_ORGN',update_rec.last_updated_by));
2638:
2639: IF l_version_end_date < l_todays_date THEN
2640:
2641: /* M. Grosser 27-Sep-2002 BUG 2593962 - Changed value from 900 to 1000

Line 5337: l_qc_lab_orgn_code := FND_PROFILE.VALUE('GEMMS_DEFAULT_LAB_TYPE');

5333: /* Get the installation's base language */
5334: l_base_lang := Get_Base_Language;
5335:
5336: /* Get the default lab type */
5337: l_qc_lab_orgn_code := FND_PROFILE.VALUE('GEMMS_DEFAULT_LAB_TYPE');
5338:
5339: /* Select results data that has not been migrated */
5340: OPEN c_get_results;
5341: FETCH c_get_results into rslt_rec;

Line 6004: l_max_date := trunc(fnd_date.canonical_to_date(nvl(fnd_profile.value('SY$MAX_DATE'),'2010/12/31') ));

6000: l_return_status VARCHAR2(4);
6001:
6002: BEGIN
6003:
6004: l_max_date := trunc(fnd_date.canonical_to_date(nvl(fnd_profile.value('SY$MAX_DATE'),'2010/12/31') ));
6005:
6006: GMA_MIGRATION.gma_insert_message (
6007: p_run_id => p_migration_id,
6008: p_table_name => 'GMD_WIP_SPEC_VRS',