APPS.GMD_QC_MIGRATE_TO_1151J dependencies on FND_LANGUAGES

Line 500: l_base_lang FND_LANGUAGES.LANGUAGE_CODE%TYPE;

496: FUNCTION Get_Base_Language RETURN VARCHAR2
497: IS
498:
499: /* ------------- LOCAL VARIABLES ------------------- */
500: l_base_lang FND_LANGUAGES.LANGUAGE_CODE%TYPE;
501:
502: /* ------------------ CURSORS ---------------------- */
503: /* Get the installation's base language */
504: CURSOR c_get_base_lang IS

Line 506: FROM fnd_languages

502: /* ------------------ CURSORS ---------------------- */
503: /* Get the installation's base language */
504: CURSOR c_get_base_lang IS
505: SELECT language_code
506: FROM fnd_languages
507: WHERE installed_flag = 'B';
508:
509: BEGIN
510: OPEN c_get_base_lang;

Line 547: l_base_lang FND_LANGUAGES.LANGUAGE_CODE%TYPE;

543:
544: /* ------------- LOCAL VARIABLES ------------------- */
545: l_table_name VARCHAR2(40);
546: l_rec_count NUMBER;
547: l_base_lang FND_LANGUAGES.LANGUAGE_CODE%TYPE;
548:
549:
550:
551: BEGIN

Line 750: l_base_lang FND_LANGUAGES.LANGUAGE_CODE%TYPE;

746:
747: /* ------------- LOCAL VARIABLES ------------------- */
748: l_table_name VARCHAR2(40);
749: l_rec_count NUMBER;
750: l_base_lang FND_LANGUAGES.LANGUAGE_CODE%TYPE;
751:
752: BEGIN
753:
754: /* Get the installation's base language */

Line 955: l_base_lang FND_LANGUAGES.LANGUAGE_CODE%TYPE;

951:
952: /* ------------- LOCAL VARIABLES ------------------- */
953: l_table_name VARCHAR2(40);
954: l_rec_count NUMBER;
955: l_base_lang FND_LANGUAGES.LANGUAGE_CODE%TYPE;
956:
957: BEGIN
958:
959: /* Get the installation's base language */

Line 2095: l_base_lang FND_LANGUAGES.LANGUAGE_CODE%TYPE;

2091:
2092: /* ------------- LOCAL VARIABLES ------------------- */
2093: l_first NUMBER;
2094: l_owner_orgn_code SY_ORGN_MST.orgn_code%TYPE;
2095: l_base_lang FND_LANGUAGES.LANGUAGE_CODE%TYPE;
2096: l_spec_name VARCHAR2(80);
2097: l_spec_version NUMBER;
2098: l_test_seq NUMBER;
2099: l_spec_id NUMBER;

Line 5195: l_base_lang FND_LANGUAGES.LANGUAGE_CODE%TYPE;

5191: l_additional_test_ind VARCHAR2(4);
5192: l_qc_lab_orgn_code GMD_RESULTS.qc_lab_orgn_code%TYPE;
5193: l_evaluation_ind GMD_SPEC_RESULTS.evaluation_ind%TYPE;
5194: l_return_status VARCHAR2(4);
5195: l_base_lang FND_LANGUAGES.LANGUAGE_CODE%TYPE;
5196: l_test_seq NUMBER;
5197: l_retest_lot_exp_ind VARCHAR2(1);
5198: l_temp NUMBER;
5199: l_commit_count NUMBER:=0;