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 2208: --DECODE(p_location, jtf_rs_resource_pub.g_miss_location, location, p_location) location,

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

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

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

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

4103: DECODE(p_hold_reason_code, fnd_api.g_miss_char, hold_reason_code, p_hold_reason_code) hold_reason_code,
4104: DECODE(p_hold_payment, fnd_api.g_miss_char, hold_payment, p_hold_payment) hold_payment,
4105: DECODE(p_comp_service_team_id, fnd_api.g_miss_num, comp_service_team_id, p_comp_service_team_id) comp_service_team_id,
4106: DECODE(p_user_id, fnd_api.g_miss_num, user_id, p_user_id) user_id,
4107: --DECODE(p_location, jtf_rs_resource_pub.g_miss_location, location, p_location) location,
4108: DECODE(p_attribute1, fnd_api.g_miss_char, attribute1, p_attribute1) attribute1,
4109: DECODE(p_attribute2, fnd_api.g_miss_char, attribute2, p_attribute2) attribute2,
4110: DECODE(p_attribute3, fnd_api.g_miss_char, attribute3, p_attribute3) attribute3,
4111: DECODE(p_attribute4, fnd_api.g_miss_char, attribute4, p_attribute4) attribute4,

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

4626:
4627: IF l_start_date_active <> fnd_api.g_miss_date OR
4628: l_end_date_active <> fnd_api.g_miss_date THEN
4629:
4630: -- Code changes to fix bug 4171623. (G_MISS_DATE DOESN'T WORK PROPERLY ON JTF_RS_RESOURCE_PUB).
4631:
4632: -- Changing the values being passed to "validate_input_dates" procedure,
4633: -- from l_end_date_active to resource_rec.end_date_active (same for start date)
4634: -- so that it validates the correct dates which its supposed to validate.