APPS.JTF_TASKS_PUB dependencies on DUAL

Line 3311: FROM DUAL;

3307: RAISE fnd_api.g_exc_unexpected_error;
3308: ELSE
3309: SELECT DECODE(l_task_id, fnd_api.g_miss_num, NULL, l_task_id)
3310: INTO l_task_id
3311: FROM DUAL;
3312:
3313: SELECT DECODE(l_task_number, fnd_api.g_miss_char, NULL, l_task_number)
3314: INTO l_task_number
3315: FROM DUAL;

Line 3315: FROM DUAL;

3311: FROM DUAL;
3312:
3313: SELECT DECODE(l_task_number, fnd_api.g_miss_char, NULL, l_task_number)
3314: INTO l_task_number
3315: FROM DUAL;
3316:
3317: jtf_task_utl.validate_task(
3318: p_task_id => l_task_id
3319: , p_task_number => l_task_number

Line 3552: FROM DUAL;

3548: OR p_customer_number IS NULL
3549: ) THEN
3550: SELECT DECODE(p_customer_id, fnd_api.g_miss_num, NULL, p_customer_id)
3551: INTO l_customer_id
3552: FROM DUAL;
3553:
3554: SELECT DECODE(p_customer_number, fnd_api.g_miss_char, NULL, p_customer_number)
3555: INTO l_customer_number
3556: FROM DUAL;

Line 3556: FROM DUAL;

3552: FROM DUAL;
3553:
3554: SELECT DECODE(p_customer_number, fnd_api.g_miss_char, NULL, p_customer_number)
3555: INTO l_customer_number
3556: FROM DUAL;
3557:
3558: jtf_task_utl.validate_party(
3559: p_party_id => l_customer_id
3560: , p_party_number => l_customer_number

Line 3574: FROM DUAL;

3570: -----------
3571: IF (p_address_id <> fnd_api.g_miss_num OR p_address_number <> fnd_api.g_miss_char) THEN
3572: SELECT DECODE(p_address_id, fnd_api.g_miss_num, NULL, p_address_id)
3573: INTO l_address_id
3574: FROM DUAL;
3575:
3576: SELECT DECODE(p_address_number, fnd_api.g_miss_char, NULL, p_address_number)
3577: INTO l_address_number
3578: FROM DUAL;

Line 3578: FROM DUAL;

3574: FROM DUAL;
3575:
3576: SELECT DECODE(p_address_number, fnd_api.g_miss_char, NULL, p_address_number)
3577: INTO l_address_number
3578: FROM DUAL;
3579:
3580: jtf_task_utl.validate_party_site(
3581: p_party_site_id => l_address_id
3582: , p_party_site_number => l_address_number

Line 3596: FROM DUAL;

3592: -----------
3593: IF (p_cust_account_id <> fnd_api.g_miss_num OR p_cust_account_number <> fnd_api.g_miss_char) THEN
3594: SELECT DECODE(p_cust_account_id, fnd_api.g_miss_num, NULL, p_cust_account_id)
3595: INTO l_cust_account_id
3596: FROM DUAL;
3597:
3598: SELECT DECODE(p_cust_account_number, fnd_api.g_miss_char, NULL, p_cust_account_number)
3599: INTO l_cust_account_number
3600: FROM DUAL;

Line 3600: FROM DUAL;

3596: FROM DUAL;
3597:
3598: SELECT DECODE(p_cust_account_number, fnd_api.g_miss_char, NULL, p_cust_account_number)
3599: INTO l_cust_account_number
3600: FROM DUAL;
3601:
3602: jtf_task_utl.validate_cust_account(
3603: p_cust_account_id => l_cust_account_id
3604: , p_cust_account_number => l_cust_account_number

Line 4404: FROM DUAL;

4400: IF (p_parent_task_id IS NOT NULL AND p_parent_task_id <> fnd_api.g_miss_num)
4401: OR (p_parent_task_number IS NOT NULL AND p_parent_task_number <> fnd_api.g_miss_char) THEN
4402: SELECT DECODE(p_parent_task_id, fnd_api.g_miss_num, NULL, p_parent_task_id)
4403: INTO l_parent_task_id
4404: FROM DUAL;
4405:
4406: SELECT DECODE(p_parent_task_number, fnd_api.g_miss_char, NULL, p_parent_task_number)
4407: INTO l_parent_task_number
4408: FROM DUAL;

Line 4408: FROM DUAL;

4404: FROM DUAL;
4405:
4406: SELECT DECODE(p_parent_task_number, fnd_api.g_miss_char, NULL, p_parent_task_number)
4407: INTO l_parent_task_number
4408: FROM DUAL;
4409:
4410: jtf_task_utl.validate_task(
4411: p_task_id => l_parent_task_id
4412: , p_task_number => l_parent_task_number

Line 6766: FROM DUAL;

6762: jtf_notes_pub.writelobtodata(notes_rec.jtf_note_id, l_notes_detail);
6763:
6764: SELECT jtf_notes_s.NEXTVAL
6765: INTO l_note_id
6766: FROM DUAL;
6767:
6768: jtf_notes_pkg.insert_row(
6769: x_rowid => l_rowid
6770: , x_jtf_note_id => l_note_id