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.JA_CN_FSG_XML_SUBMIT_PROG dependencies on FND_LOOKUP_VALUES

Line 757: lv_fsg_req_phase fnd_lookup_values.meaning%TYPE;

753: lv_dev_status VARCHAR2(100);
754: lv_message VARCHAR2(1000);
755: lb_xml_layout BOOLEAN;
756:
757: lv_fsg_req_phase fnd_lookup_values.meaning%TYPE;
758: lv_fsg_req_status fnd_lookup_values.meaning%TYPE;
759: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
760:
761: lv_cal_req_phase fnd_lookup_values.meaning%TYPE;

Line 758: lv_fsg_req_status fnd_lookup_values.meaning%TYPE;

754: lv_message VARCHAR2(1000);
755: lb_xml_layout BOOLEAN;
756:
757: lv_fsg_req_phase fnd_lookup_values.meaning%TYPE;
758: lv_fsg_req_status fnd_lookup_values.meaning%TYPE;
759: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
760:
761: lv_cal_req_phase fnd_lookup_values.meaning%TYPE;
762: lv_cal_req_status fnd_lookup_values.meaning%TYPE;

Line 759: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;

755: lb_xml_layout BOOLEAN;
756:
757: lv_fsg_req_phase fnd_lookup_values.meaning%TYPE;
758: lv_fsg_req_status fnd_lookup_values.meaning%TYPE;
759: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
760:
761: lv_cal_req_phase fnd_lookup_values.meaning%TYPE;
762: lv_cal_req_status fnd_lookup_values.meaning%TYPE;
763: lv_cal_req_status_code fnd_lookup_values.lookup_code%TYPE;

Line 761: lv_cal_req_phase fnd_lookup_values.meaning%TYPE;

757: lv_fsg_req_phase fnd_lookup_values.meaning%TYPE;
758: lv_fsg_req_status fnd_lookup_values.meaning%TYPE;
759: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
760:
761: lv_cal_req_phase fnd_lookup_values.meaning%TYPE;
762: lv_cal_req_status fnd_lookup_values.meaning%TYPE;
763: lv_cal_req_status_code fnd_lookup_values.lookup_code%TYPE;
764:
765: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;

Line 762: lv_cal_req_status fnd_lookup_values.meaning%TYPE;

758: lv_fsg_req_status fnd_lookup_values.meaning%TYPE;
759: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
760:
761: lv_cal_req_phase fnd_lookup_values.meaning%TYPE;
762: lv_cal_req_status fnd_lookup_values.meaning%TYPE;
763: lv_cal_req_status_code fnd_lookup_values.lookup_code%TYPE;
764:
765: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;
766: lv_comb_req_status fnd_lookup_values.meaning%TYPE;

Line 763: lv_cal_req_status_code fnd_lookup_values.lookup_code%TYPE;

759: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
760:
761: lv_cal_req_phase fnd_lookup_values.meaning%TYPE;
762: lv_cal_req_status fnd_lookup_values.meaning%TYPE;
763: lv_cal_req_status_code fnd_lookup_values.lookup_code%TYPE;
764:
765: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;
766: lv_comb_req_status fnd_lookup_values.meaning%TYPE;
767: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;

Line 765: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;

761: lv_cal_req_phase fnd_lookup_values.meaning%TYPE;
762: lv_cal_req_status fnd_lookup_values.meaning%TYPE;
763: lv_cal_req_status_code fnd_lookup_values.lookup_code%TYPE;
764:
765: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;
766: lv_comb_req_status fnd_lookup_values.meaning%TYPE;
767: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;
768:
769: ln_reqid_convert NUMBER;

Line 766: lv_comb_req_status fnd_lookup_values.meaning%TYPE;

762: lv_cal_req_status fnd_lookup_values.meaning%TYPE;
763: lv_cal_req_status_code fnd_lookup_values.lookup_code%TYPE;
764:
765: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;
766: lv_comb_req_status fnd_lookup_values.meaning%TYPE;
767: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;
768:
769: ln_reqid_convert NUMBER;
770:

Line 767: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;

763: lv_cal_req_status_code fnd_lookup_values.lookup_code%TYPE;
764:
765: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;
766: lv_comb_req_status fnd_lookup_values.meaning%TYPE;
767: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;
768:
769: ln_reqid_convert NUMBER;
770:
771: lv_convert_req_phase fnd_lookup_values.meaning%TYPE;

Line 771: lv_convert_req_phase fnd_lookup_values.meaning%TYPE;

767: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;
768:
769: ln_reqid_convert NUMBER;
770:
771: lv_convert_req_phase fnd_lookup_values.meaning%TYPE;
772: lv_convert_req_status fnd_lookup_values.meaning%TYPE;
773: lv_convert_req_status_code fnd_lookup_values.lookup_code%TYPE;
774:
775:

Line 772: lv_convert_req_status fnd_lookup_values.meaning%TYPE;

768:
769: ln_reqid_convert NUMBER;
770:
771: lv_convert_req_phase fnd_lookup_values.meaning%TYPE;
772: lv_convert_req_status fnd_lookup_values.meaning%TYPE;
773: lv_convert_req_status_code fnd_lookup_values.lookup_code%TYPE;
774:
775:
776: CURSOR C_COMPANY_NAME

Line 773: lv_convert_req_status_code fnd_lookup_values.lookup_code%TYPE;

769: ln_reqid_convert NUMBER;
770:
771: lv_convert_req_phase fnd_lookup_values.meaning%TYPE;
772: lv_convert_req_status fnd_lookup_values.meaning%TYPE;
773: lv_convert_req_status_code fnd_lookup_values.lookup_code%TYPE;
774:
775:
776: CURSOR C_COMPANY_NAME
777: IS

Line 1386: fnd_lookup_values

1382: lookup_code
1383: INTO
1384: lv_fsg_req_status_code
1385: FROM
1386: fnd_lookup_values
1387: WHERE lookup_type = 'CP_STATUS_CODE'
1388: AND view_application_id=0
1389: AND security_group_id=0
1390: AND meaning=lv_fsg_req_status

Line 1451: fnd_lookup_values

1447: lookup_code
1448: INTO
1449: lv_cal_req_status_code
1450: FROM
1451: fnd_lookup_values
1452: WHERE lookup_type = 'CP_STATUS_CODE'
1453: AND view_application_id=0
1454: AND security_group_id=0
1455: AND meaning=lv_cal_req_status

Line 1496: fnd_lookup_values

1492: lookup_code
1493: INTO
1494: lv_comb_req_status_code
1495: FROM
1496: fnd_lookup_values
1497: WHERE lookup_type = 'CP_STATUS_CODE'
1498: AND view_application_id=0
1499: AND security_group_id=0
1500: AND meaning=lv_comb_req_status

Line 1545: fnd_lookup_values

1541: lookup_code
1542: INTO
1543: lv_convert_req_status_code
1544: FROM
1545: fnd_lookup_values
1546: WHERE lookup_type = 'CP_STATUS_CODE'
1547: AND view_application_id=0
1548: AND security_group_id=0
1549: AND meaning=lv_comb_req_status

Line 1760: lv_fsg_req_phase fnd_lookup_values.meaning%TYPE;

1756: lv_dev_status VARCHAR2(100);
1757: lv_message VARCHAR2(1000);
1758: lb_xml_layout BOOLEAN;
1759:
1760: lv_fsg_req_phase fnd_lookup_values.meaning%TYPE;
1761: lv_fsg_req_status fnd_lookup_values.meaning%TYPE;
1762: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
1763:
1764: lv_cal_req_phase fnd_lookup_values.meaning%TYPE;

Line 1761: lv_fsg_req_status fnd_lookup_values.meaning%TYPE;

1757: lv_message VARCHAR2(1000);
1758: lb_xml_layout BOOLEAN;
1759:
1760: lv_fsg_req_phase fnd_lookup_values.meaning%TYPE;
1761: lv_fsg_req_status fnd_lookup_values.meaning%TYPE;
1762: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
1763:
1764: lv_cal_req_phase fnd_lookup_values.meaning%TYPE;
1765: lv_cal_req_status fnd_lookup_values.meaning%TYPE;

Line 1762: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;

1758: lb_xml_layout BOOLEAN;
1759:
1760: lv_fsg_req_phase fnd_lookup_values.meaning%TYPE;
1761: lv_fsg_req_status fnd_lookup_values.meaning%TYPE;
1762: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
1763:
1764: lv_cal_req_phase fnd_lookup_values.meaning%TYPE;
1765: lv_cal_req_status fnd_lookup_values.meaning%TYPE;
1766: lv_cal_req_status_code fnd_lookup_values.lookup_code%TYPE;

Line 1764: lv_cal_req_phase fnd_lookup_values.meaning%TYPE;

1760: lv_fsg_req_phase fnd_lookup_values.meaning%TYPE;
1761: lv_fsg_req_status fnd_lookup_values.meaning%TYPE;
1762: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
1763:
1764: lv_cal_req_phase fnd_lookup_values.meaning%TYPE;
1765: lv_cal_req_status fnd_lookup_values.meaning%TYPE;
1766: lv_cal_req_status_code fnd_lookup_values.lookup_code%TYPE;
1767:
1768: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;

Line 1765: lv_cal_req_status fnd_lookup_values.meaning%TYPE;

1761: lv_fsg_req_status fnd_lookup_values.meaning%TYPE;
1762: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
1763:
1764: lv_cal_req_phase fnd_lookup_values.meaning%TYPE;
1765: lv_cal_req_status fnd_lookup_values.meaning%TYPE;
1766: lv_cal_req_status_code fnd_lookup_values.lookup_code%TYPE;
1767:
1768: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;
1769: lv_comb_req_status fnd_lookup_values.meaning%TYPE;

Line 1766: lv_cal_req_status_code fnd_lookup_values.lookup_code%TYPE;

1762: lv_fsg_req_status_code fnd_lookup_values.lookup_code%TYPE;
1763:
1764: lv_cal_req_phase fnd_lookup_values.meaning%TYPE;
1765: lv_cal_req_status fnd_lookup_values.meaning%TYPE;
1766: lv_cal_req_status_code fnd_lookup_values.lookup_code%TYPE;
1767:
1768: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;
1769: lv_comb_req_status fnd_lookup_values.meaning%TYPE;
1770: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;

Line 1768: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;

1764: lv_cal_req_phase fnd_lookup_values.meaning%TYPE;
1765: lv_cal_req_status fnd_lookup_values.meaning%TYPE;
1766: lv_cal_req_status_code fnd_lookup_values.lookup_code%TYPE;
1767:
1768: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;
1769: lv_comb_req_status fnd_lookup_values.meaning%TYPE;
1770: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;
1771:
1772: ln_reqid_convert NUMBER;

Line 1769: lv_comb_req_status fnd_lookup_values.meaning%TYPE;

1765: lv_cal_req_status fnd_lookup_values.meaning%TYPE;
1766: lv_cal_req_status_code fnd_lookup_values.lookup_code%TYPE;
1767:
1768: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;
1769: lv_comb_req_status fnd_lookup_values.meaning%TYPE;
1770: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;
1771:
1772: ln_reqid_convert NUMBER;
1773:

Line 1770: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;

1766: lv_cal_req_status_code fnd_lookup_values.lookup_code%TYPE;
1767:
1768: lv_comb_req_phase fnd_lookup_values.meaning%TYPE;
1769: lv_comb_req_status fnd_lookup_values.meaning%TYPE;
1770: lv_comb_req_status_code fnd_lookup_values.lookup_code%TYPE;
1771:
1772: ln_reqid_convert NUMBER;
1773:
1774: CURSOR C_COMPANY_NAME

Line 2384: fnd_lookup_values

2380: lookup_code
2381: INTO
2382: lv_fsg_req_status_code
2383: FROM
2384: fnd_lookup_values
2385: WHERE lookup_type = 'CP_STATUS_CODE'
2386: AND view_application_id=0
2387: AND security_group_id=0
2388: AND meaning=lv_fsg_req_status

Line 2449: fnd_lookup_values

2445: lookup_code
2446: INTO
2447: lv_cal_req_status_code
2448: FROM
2449: fnd_lookup_values
2450: WHERE lookup_type = 'CP_STATUS_CODE'
2451: AND view_application_id=0
2452: AND security_group_id=0
2453: AND meaning=lv_cal_req_status

Line 2494: fnd_lookup_values

2490: lookup_code
2491: INTO
2492: lv_comb_req_status_code
2493: FROM
2494: fnd_lookup_values
2495: WHERE lookup_type = 'CP_STATUS_CODE'
2496: AND view_application_id=0
2497: AND security_group_id=0
2498: AND meaning=lv_comb_req_status