APPS.CSF_TASK_ADDRESS_PVT dependencies on JTF_TASKS_B

Line 413: FROM jtf_tasks_b t,

409: l.province,
410: l.country country_code,
411: tl.territory_short_name country,
412: l.timezone_id
413: FROM jtf_tasks_b t,
414: jtf_task_types_b tt,
415: hz_locations l,
416: fnd_territories_tl tl,
417: jtf_task_statuses_vl jts

Line 447: FROM jtf_tasks_b t,

443: l.province,
444: l.country country_code,
445: tl.territory_short_name country,
446: l.timezone_id
447: FROM jtf_tasks_b t,
448: jtf_task_types_b tt,
449: hz_party_sites hps,
450: hz_locations l,
451: fnd_territories_tl tl,

Line 485: FROM jtf_tasks_b t,

481: l.province,
482: l.country country_code,
483: tl.territory_short_name country,
484: l.timezone_id
485: FROM jtf_tasks_b t,
486: jtf_task_types_b tt,
487: hz_locations l,
488: fnd_territories_tl tl,
489: jtf_task_statuses_vl jts,

Line 522: FROM jtf_tasks_b t,

518: l.province,
519: l.country country_code,
520: tl.territory_short_name country,
521: l.timezone_id
522: FROM jtf_tasks_b t,
523: jtf_task_types_b tt,
524: hz_party_sites hps,
525: hz_locations l,
526: fnd_territories_tl tl,

Line 1895: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,

1891: p_api_version IN NUMBER,
1892: p_init_msg_list IN VARCHAR2,
1893: p_commit IN VARCHAR2,
1894: p_validation_level IN NUMBER,
1895: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,
1896: p_location_id IN hz_locations.location_id%TYPE,
1897: p_address1 IN hz_locations.address1%TYPE,
1898: p_address2 IN hz_locations.address2%TYPE,
1899: p_address3 IN hz_locations.address3%TYPE,

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

2096: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2097: p_data => x_msg_data);
2098: END validate_task_data;
2099:
2100: FUNCTION is_task_address_valid (p_task_id IN jtf_tasks_b.task_id%TYPE)
2101: RETURN BOOLEAN
2102: IS
2103: CURSOR l_check_address_csr (l_task_id jtf_tasks_b.task_id%TYPE)
2104: IS

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

2099:
2100: FUNCTION is_task_address_valid (p_task_id IN jtf_tasks_b.task_id%TYPE)
2101: RETURN BOOLEAN
2102: IS
2103: CURSOR l_check_address_csr (l_task_id jtf_tasks_b.task_id%TYPE)
2104: IS
2105: SELECT task_id
2106: FROM csf_validate_tasks_v
2107: WHERE task_id = l_task_id AND validated_flag = 'N';

Line 2109: l_task_id jtf_tasks_b.task_id%TYPE;

2105: SELECT task_id
2106: FROM csf_validate_tasks_v
2107: WHERE task_id = l_task_id AND validated_flag = 'N';
2108:
2109: l_task_id jtf_tasks_b.task_id%TYPE;
2110: BEGIN
2111: BEGIN
2112: OPEN l_check_address_csr (p_task_id);
2113: