APPS.JTF_RS_RESOURCE_PVT dependencies on JTF_RS_RESOURCE_PUB

Line 463: IF (G_RS_ID_PVT_FLAG = 'Y') OR (G_RS_ID_PVT_FLAG = 'N' AND JTF_RS_RESOURCE_PUB.G_RESOURCE_ID IS NULL) THEN

459: /* Check if the Global Variable Flag for Resource ID is Y or N */
460:
461: -- dbms_output.put_line ('Before checkin the Global flag in PVT API');
462:
463: IF (G_RS_ID_PVT_FLAG = 'Y') OR (G_RS_ID_PVT_FLAG = 'N' AND JTF_RS_RESOURCE_PUB.G_RESOURCE_ID IS NULL) THEN
464:
465: /* Get the next value of the Resource_id from the sequence. */
466:
467: LOOP

Line 479: l_resource_id := JTF_RS_RESOURCE_PUB.G_RESOURCE_ID;

475: CLOSE c_dup_resource_id;
476: END LOOP;
477: CLOSE c_dup_resource_id;
478: ELSE
479: l_resource_id := JTF_RS_RESOURCE_PUB.G_RESOURCE_ID;
480: END IF;
481:
482: /* Get the next value of the Resource_number from the sequence. */
483:

Line 1421: IF (G_RS_ID_PVT_FLAG = 'Y') OR (G_RS_ID_PVT_FLAG = 'N' AND JTF_RS_RESOURCE_PUB.G_RESOURCE_ID IS NULL) THEN

1417: /* Check if the Global Variable Flag for Resource ID is Y or N */
1418:
1419: -- dbms_output.put_line ('Before checkin the Global flag in PVT API');
1420:
1421: IF (G_RS_ID_PVT_FLAG = 'Y') OR (G_RS_ID_PVT_FLAG = 'N' AND JTF_RS_RESOURCE_PUB.G_RESOURCE_ID IS NULL) THEN
1422:
1423: /* Get the next value of the Resource_id from the sequence. */
1424:
1425: LOOP

Line 1437: l_resource_id := JTF_RS_RESOURCE_PUB.G_RESOURCE_ID;

1433: CLOSE c_dup_resource_id;
1434: END LOOP;
1435: CLOSE c_dup_resource_id;
1436: ELSE
1437: l_resource_id := JTF_RS_RESOURCE_PUB.G_RESOURCE_ID;
1438: END IF;
1439:
1440: /* Get the next value of the Resource_number from the sequence. */
1441:

Line 2209: --DECODE(p_location, jtf_rs_resource_pub.g_miss_location, location, p_location) location,

2205: DECODE(p_hold_reason_code, fnd_api.g_miss_char, hold_reason_code, p_hold_reason_code) hold_reason_code,
2206: DECODE(p_hold_payment, fnd_api.g_miss_char, hold_payment, p_hold_payment) hold_payment,
2207: DECODE(p_comp_service_team_id, fnd_api.g_miss_num, comp_service_team_id, p_comp_service_team_id) comp_service_team_id,
2208: DECODE(p_user_id, fnd_api.g_miss_num, user_id, p_user_id) user_id,
2209: --DECODE(p_location, jtf_rs_resource_pub.g_miss_location, location, p_location) location,
2210: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
2211: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
2212: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
2213: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,

Line 2650: -- Code changes to fix bug 4171623. (G_MISS_DATE DOESN'T WORK PROPERLY ON JTF_RS_RESOURCE_PUB).

2646:
2647: IF l_start_date_active <> fnd_api.g_miss_date OR
2648: l_end_date_active <> fnd_api.g_miss_date THEN
2649:
2650: -- Code changes to fix bug 4171623. (G_MISS_DATE DOESN'T WORK PROPERLY ON JTF_RS_RESOURCE_PUB).
2651:
2652: -- Changing the values being passed to "validate_input_dates" procedure,
2653: -- from l_end_date_active to resource_rec.end_date_active (same for start date)
2654: -- so that it validates the correct dates which its supposed to validate.

Line 4099: --DECODE(p_location, jtf_rs_resource_pub.g_miss_location, location, p_location) location,

4095: DECODE(p_hold_reason_code, fnd_api.g_miss_char, hold_reason_code, p_hold_reason_code) hold_reason_code,
4096: DECODE(p_hold_payment, fnd_api.g_miss_char, hold_payment, p_hold_payment) hold_payment,
4097: DECODE(p_comp_service_team_id, fnd_api.g_miss_num, comp_service_team_id, p_comp_service_team_id) comp_service_team_id,
4098: DECODE(p_user_id, fnd_api.g_miss_num, user_id, p_user_id) user_id,
4099: --DECODE(p_location, jtf_rs_resource_pub.g_miss_location, location, p_location) location,
4100: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
4101: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
4102: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
4103: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,

Line 4621: -- Code changes to fix bug 4171623. (G_MISS_DATE DOESN'T WORK PROPERLY ON JTF_RS_RESOURCE_PUB).

4617:
4618: IF l_start_date_active <> fnd_api.g_miss_date OR
4619: l_end_date_active <> fnd_api.g_miss_date THEN
4620:
4621: -- Code changes to fix bug 4171623. (G_MISS_DATE DOESN'T WORK PROPERLY ON JTF_RS_RESOURCE_PUB).
4622:
4623: -- Changing the values being passed to "validate_input_dates" procedure,
4624: -- from l_end_date_active to resource_rec.end_date_active (same for start date)
4625: -- so that it validates the correct dates which its supposed to validate.