DBA Data[Home] [Help]

APPS.CSF_TASK_ADDRESS_PVT dependencies on JTF_TASKS_B

Line 15: task_id jtf_tasks_b.task_id%TYPE,

11: g_debug BOOLEAN;
12:
13: TYPE task_rec_type IS RECORD (
14: ID csf_ext_locations.csf_ext_location_id%TYPE,
15: task_id jtf_tasks_b.task_id%TYPE,
16: task_number jtf_tasks_b.task_number%TYPE,
17: location_id hz_locations.location_id%TYPE,
18: address_style hz_locations.address_style%TYPE,
19: address1 hz_locations.address1%TYPE,

Line 16: task_number jtf_tasks_b.task_number%TYPE,

12:
13: TYPE task_rec_type IS RECORD (
14: ID csf_ext_locations.csf_ext_location_id%TYPE,
15: task_id jtf_tasks_b.task_id%TYPE,
16: task_number jtf_tasks_b.task_number%TYPE,
17: location_id hz_locations.location_id%TYPE,
18: address_style hz_locations.address_style%TYPE,
19: address1 hz_locations.address1%TYPE,
20: address2 hz_locations.address2%TYPE,

Line 140: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,

136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2,
138: p_commit IN VARCHAR2,
139: p_validation_level IN NUMBER,
140: p_invalid_task_id IN jtf_tasks_b.task_id%TYPE,
141: p_location_id IN hz_locations.location_id%TYPE,
142: p_address1 IN hz_locations.address1%TYPE,
143: p_address2 IN hz_locations.address2%TYPE,
144: p_address3 IN hz_locations.address3%TYPE,

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

156: x_msg_data OUT NOCOPY VARCHAR2
157: );
158:
159: -- Checks if a task has valid address data
160: FUNCTION is_task_address_valid (p_task_id IN jtf_tasks_b.task_id%TYPE)
161: RETURN BOOLEAN;
162:
163: -- Used to update the task data
164: PROCEDURE update_task_address (