APPS.JTF_TASKS_PUB dependencies on DUAL

Line 3303: FROM DUAL;

3299: RAISE fnd_api.g_exc_unexpected_error;
3300: ELSE
3301: SELECT DECODE(l_task_id, fnd_api.g_miss_num, NULL, l_task_id)
3302: INTO l_task_id
3303: FROM DUAL;
3304:
3305: SELECT DECODE(l_task_number, fnd_api.g_miss_char, NULL, l_task_number)
3306: INTO l_task_number
3307: FROM DUAL;

Line 3307: FROM DUAL;

3303: FROM DUAL;
3304:
3305: SELECT DECODE(l_task_number, fnd_api.g_miss_char, NULL, l_task_number)
3306: INTO l_task_number
3307: FROM DUAL;
3308:
3309: jtf_task_utl.validate_task(
3310: p_task_id => l_task_id
3311: , p_task_number => l_task_number

Line 3544: FROM DUAL;

3540: OR p_customer_number IS NULL
3541: ) THEN
3542: SELECT DECODE(p_customer_id, fnd_api.g_miss_num, NULL, p_customer_id)
3543: INTO l_customer_id
3544: FROM DUAL;
3545:
3546: SELECT DECODE(p_customer_number, fnd_api.g_miss_char, NULL, p_customer_number)
3547: INTO l_customer_number
3548: FROM DUAL;

Line 3548: FROM DUAL;

3544: FROM DUAL;
3545:
3546: SELECT DECODE(p_customer_number, fnd_api.g_miss_char, NULL, p_customer_number)
3547: INTO l_customer_number
3548: FROM DUAL;
3549:
3550: jtf_task_utl.validate_party(
3551: p_party_id => l_customer_id
3552: , p_party_number => l_customer_number

Line 3566: FROM DUAL;

3562: -----------
3563: IF (p_address_id <> fnd_api.g_miss_num OR p_address_number <> fnd_api.g_miss_char) THEN
3564: SELECT DECODE(p_address_id, fnd_api.g_miss_num, NULL, p_address_id)
3565: INTO l_address_id
3566: FROM DUAL;
3567:
3568: SELECT DECODE(p_address_number, fnd_api.g_miss_char, NULL, p_address_number)
3569: INTO l_address_number
3570: FROM DUAL;

Line 3570: FROM DUAL;

3566: FROM DUAL;
3567:
3568: SELECT DECODE(p_address_number, fnd_api.g_miss_char, NULL, p_address_number)
3569: INTO l_address_number
3570: FROM DUAL;
3571:
3572: jtf_task_utl.validate_party_site(
3573: p_party_site_id => l_address_id
3574: , p_party_site_number => l_address_number

Line 3588: FROM DUAL;

3584: -----------
3585: IF (p_cust_account_id <> fnd_api.g_miss_num OR p_cust_account_number <> fnd_api.g_miss_char) THEN
3586: SELECT DECODE(p_cust_account_id, fnd_api.g_miss_num, NULL, p_cust_account_id)
3587: INTO l_cust_account_id
3588: FROM DUAL;
3589:
3590: SELECT DECODE(p_cust_account_number, fnd_api.g_miss_char, NULL, p_cust_account_number)
3591: INTO l_cust_account_number
3592: FROM DUAL;

Line 3592: FROM DUAL;

3588: FROM DUAL;
3589:
3590: SELECT DECODE(p_cust_account_number, fnd_api.g_miss_char, NULL, p_cust_account_number)
3591: INTO l_cust_account_number
3592: FROM DUAL;
3593:
3594: jtf_task_utl.validate_cust_account(
3595: p_cust_account_id => l_cust_account_id
3596: , p_cust_account_number => l_cust_account_number

Line 4379: FROM DUAL;

4375: IF (p_parent_task_id IS NOT NULL AND p_parent_task_id <> fnd_api.g_miss_num)
4376: OR (p_parent_task_number IS NOT NULL AND p_parent_task_number <> fnd_api.g_miss_char) THEN
4377: SELECT DECODE(p_parent_task_id, fnd_api.g_miss_num, NULL, p_parent_task_id)
4378: INTO l_parent_task_id
4379: FROM DUAL;
4380:
4381: SELECT DECODE(p_parent_task_number, fnd_api.g_miss_char, NULL, p_parent_task_number)
4382: INTO l_parent_task_number
4383: FROM DUAL;

Line 4383: FROM DUAL;

4379: FROM DUAL;
4380:
4381: SELECT DECODE(p_parent_task_number, fnd_api.g_miss_char, NULL, p_parent_task_number)
4382: INTO l_parent_task_number
4383: FROM DUAL;
4384:
4385: jtf_task_utl.validate_task(
4386: p_task_id => l_parent_task_id
4387: , p_task_number => l_parent_task_number

Line 6741: FROM DUAL;

6737: jtf_notes_pub.writelobtodata(notes_rec.jtf_note_id, l_notes_detail);
6738:
6739: SELECT jtf_notes_s.NEXTVAL
6740: INTO l_note_id
6741: FROM DUAL;
6742:
6743: jtf_notes_pkg.insert_row(
6744: x_rowid => l_rowid
6745: , x_jtf_note_id => l_note_id