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.CSF_TASK_ADDRESS_PVT dependencies on JTF_TASKS_B

Line 689: task_id jtf_tasks_b.task_id%TYPE,

685: l_query VARCHAR2(4000);
686: l_geo_coder_url VARCHAR2(50);
687:
688: TYPE task_address_rec_type IS RECORD (
689: task_id jtf_tasks_b.task_id%TYPE,
690: task_number jtf_tasks_b.task_number%TYPE,
691: location_id hz_locations.location_id%TYPE,
692: address_style hz_locations.address_style%TYPE,
693: address1 hz_locations.address1%TYPE,

Line 690: task_number jtf_tasks_b.task_number%TYPE,

686: l_geo_coder_url VARCHAR2(50);
687:
688: TYPE task_address_rec_type IS RECORD (
689: task_id jtf_tasks_b.task_id%TYPE,
690: task_number jtf_tasks_b.task_number%TYPE,
691: location_id hz_locations.location_id%TYPE,
692: address_style hz_locations.address_style%TYPE,
693: address1 hz_locations.address1%TYPE,
694: address2 hz_locations.address2%TYPE,

Line 728: FROM jtf_tasks_b t,

724: l.province,
725: tl.territory_short_name country,
726: l.country country_code,
727: l.timezone_id
728: FROM jtf_tasks_b t,
729: jtf_task_types_b tt,
730: hz_locations l,
731: fnd_territories_tl tl,
732: jtf_task_statuses_vl jts,

Line 771: FROM jtf_tasks_b t,

767: l.province,
768: tl.territory_short_name country,
769: l.country country_code,
770: l.timezone_id
771: FROM jtf_tasks_b t,
772: jtf_task_types_b tt,
773: hz_party_sites hps,
774: hz_locations l,
775: fnd_territories_tl tl,

Line 815: FROM jtf_tasks_b t,

811: l.province,
812: tl.territory_short_name country,
813: l.country country_code,
814: l.timezone_id
815: FROM jtf_tasks_b t,
816: jtf_task_types_b tt,
817: hz_locations l,
818: fnd_territories_tl tl,
819: jtf_task_statuses_vl jts,

Line 856: FROM jtf_tasks_b t,

852: l.province,
853: tl.territory_short_name country,
854: l.country country_code,
855: l.timezone_id
856: FROM jtf_tasks_b t,
857: jtf_task_types_b tt,
858: hz_party_sites hps,
859: hz_locations l,
860: fnd_territories_tl tl,

Line 2341: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,

2337: p_api_version IN NUMBER,
2338: p_init_msg_list IN VARCHAR2,
2339: p_commit IN VARCHAR2,
2340: p_validation_level IN NUMBER,
2341: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,
2342: p_location_id IN hz_locations.location_id%TYPE,
2343: p_address1 IN hz_locations.address1%TYPE,
2344: p_address2 IN hz_locations.address2%TYPE,
2345: p_address3 IN hz_locations.address3%TYPE,

Line 2554: FUNCTION is_task_address_valid (p_task_id IN jtf_tasks_b.task_id%TYPE)

2550: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2551: p_data => x_msg_data);
2552: END validate_task_data;
2553:
2554: FUNCTION is_task_address_valid (p_task_id IN jtf_tasks_b.task_id%TYPE)
2555: RETURN BOOLEAN
2556: IS
2557: CURSOR l_check_address_csr (l_task_id jtf_tasks_b.task_id%TYPE)
2558: IS

Line 2557: CURSOR l_check_address_csr (l_task_id jtf_tasks_b.task_id%TYPE)

2553:
2554: FUNCTION is_task_address_valid (p_task_id IN jtf_tasks_b.task_id%TYPE)
2555: RETURN BOOLEAN
2556: IS
2557: CURSOR l_check_address_csr (l_task_id jtf_tasks_b.task_id%TYPE)
2558: IS
2559: SELECT task_id
2560: FROM csf_validate_tasks_v
2561: WHERE task_id = l_task_id AND validated_flag = 'N';

Line 2563: l_task_id jtf_tasks_b.task_id%TYPE;

2559: SELECT task_id
2560: FROM csf_validate_tasks_v
2561: WHERE task_id = l_task_id AND validated_flag = 'N';
2562:
2563: l_task_id jtf_tasks_b.task_id%TYPE;
2564: BEGIN
2565: BEGIN
2566: OPEN l_check_address_csr (p_task_id);
2567: