DBA Data[Home] [Help]

APPS.AHL_RM_RT_OPER_RESOURCE_PVT dependencies on STANDARD

Line 1226: -- Standard Start of API savepoint

1222: BEGIN
1223: -- Initialize API return status to success
1224: x_return_status := FND_API.G_RET_STS_SUCCESS;
1225:
1226: -- Standard Start of API savepoint
1227: SAVEPOINT process_rt_oper_resource_pvt;
1228:
1229: -- Standard call to check for call compatibility.
1230: IF NOT FND_API.compatible_api_call

Line 1229: -- Standard call to check for call compatibility.

1225:
1226: -- Standard Start of API savepoint
1227: SAVEPOINT process_rt_oper_resource_pvt;
1228:
1229: -- Standard call to check for call compatibility.
1230: IF NOT FND_API.compatible_api_call
1231: (
1232: l_api_version,
1233: p_api_version,

Line 1945: -- Convert / Validate standard_rate_flag

1941: END IF;
1942:
1943: END IF;
1944:
1945: -- Convert / Validate standard_rate_flag
1946: IF ( ( p_x_rt_oper_cost_rec.standard_rate_flag IS NOT NULL AND
1947: p_x_rt_oper_cost_rec.standard_rate_flag <> FND_API.G_MISS_NUM ) OR
1948: ( p_x_rt_oper_cost_rec.standard_rate IS NOT NULL AND
1949: p_x_rt_oper_cost_rec.standard_rate <> FND_API.G_MISS_CHAR ) )

Line 1946: IF ( ( p_x_rt_oper_cost_rec.standard_rate_flag IS NOT NULL AND

1942:
1943: END IF;
1944:
1945: -- Convert / Validate standard_rate_flag
1946: IF ( ( p_x_rt_oper_cost_rec.standard_rate_flag IS NOT NULL AND
1947: p_x_rt_oper_cost_rec.standard_rate_flag <> FND_API.G_MISS_NUM ) OR
1948: ( p_x_rt_oper_cost_rec.standard_rate IS NOT NULL AND
1949: p_x_rt_oper_cost_rec.standard_rate <> FND_API.G_MISS_CHAR ) )
1950: THEN

Line 1947: p_x_rt_oper_cost_rec.standard_rate_flag <> FND_API.G_MISS_NUM ) OR

1943: END IF;
1944:
1945: -- Convert / Validate standard_rate_flag
1946: IF ( ( p_x_rt_oper_cost_rec.standard_rate_flag IS NOT NULL AND
1947: p_x_rt_oper_cost_rec.standard_rate_flag <> FND_API.G_MISS_NUM ) OR
1948: ( p_x_rt_oper_cost_rec.standard_rate IS NOT NULL AND
1949: p_x_rt_oper_cost_rec.standard_rate <> FND_API.G_MISS_CHAR ) )
1950: THEN
1951:

Line 1948: ( p_x_rt_oper_cost_rec.standard_rate IS NOT NULL AND

1944:
1945: -- Convert / Validate standard_rate_flag
1946: IF ( ( p_x_rt_oper_cost_rec.standard_rate_flag IS NOT NULL AND
1947: p_x_rt_oper_cost_rec.standard_rate_flag <> FND_API.G_MISS_NUM ) OR
1948: ( p_x_rt_oper_cost_rec.standard_rate IS NOT NULL AND
1949: p_x_rt_oper_cost_rec.standard_rate <> FND_API.G_MISS_CHAR ) )
1950: THEN
1951:
1952: AHL_RM_ROUTE_UTIL.validate_mfg_lookup

Line 1949: p_x_rt_oper_cost_rec.standard_rate <> FND_API.G_MISS_CHAR ) )

1945: -- Convert / Validate standard_rate_flag
1946: IF ( ( p_x_rt_oper_cost_rec.standard_rate_flag IS NOT NULL AND
1947: p_x_rt_oper_cost_rec.standard_rate_flag <> FND_API.G_MISS_NUM ) OR
1948: ( p_x_rt_oper_cost_rec.standard_rate IS NOT NULL AND
1949: p_x_rt_oper_cost_rec.standard_rate <> FND_API.G_MISS_CHAR ) )
1950: THEN
1951:
1952: AHL_RM_ROUTE_UTIL.validate_mfg_lookup
1953: (

Line 1957: p_lookup_meaning => p_x_rt_oper_cost_rec.standard_rate,

1953: (
1954: x_return_status => l_return_status,
1955: x_msg_data => l_msg_data,
1956: p_lookup_type => 'SYS_YES_NO',
1957: p_lookup_meaning => p_x_rt_oper_cost_rec.standard_rate,
1958: p_x_lookup_code => p_x_rt_oper_cost_rec.standard_rate_flag
1959: );
1960:
1961: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

Line 1958: p_x_lookup_code => p_x_rt_oper_cost_rec.standard_rate_flag

1954: x_return_status => l_return_status,
1955: x_msg_data => l_msg_data,
1956: p_lookup_type => 'SYS_YES_NO',
1957: p_lookup_meaning => p_x_rt_oper_cost_rec.standard_rate,
1958: p_x_lookup_code => p_x_rt_oper_cost_rec.standard_rate_flag
1959: );
1960:
1961: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1962: IF ( l_msg_data = 'AHL_RM_INVALID_MFG_LOOKUP' ) THEN

Line 1970: IF ( p_x_rt_oper_cost_rec.standard_rate IS NULL OR

1966: ELSE
1967: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1968: END IF;
1969:
1970: IF ( p_x_rt_oper_cost_rec.standard_rate IS NULL OR
1971: p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN
1972: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.standard_rate_flag ) );
1973: ELSE
1974: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.standard_rate );

Line 1971: p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN

1967: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1968: END IF;
1969:
1970: IF ( p_x_rt_oper_cost_rec.standard_rate IS NULL OR
1971: p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN
1972: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.standard_rate_flag ) );
1973: ELSE
1974: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.standard_rate );
1975: END IF;

Line 1972: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.standard_rate_flag ) );

1968: END IF;
1969:
1970: IF ( p_x_rt_oper_cost_rec.standard_rate IS NULL OR
1971: p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN
1972: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.standard_rate_flag ) );
1973: ELSE
1974: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.standard_rate );
1975: END IF;
1976:

Line 1974: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.standard_rate );

1970: IF ( p_x_rt_oper_cost_rec.standard_rate IS NULL OR
1971: p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN
1972: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.standard_rate_flag ) );
1973: ELSE
1974: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.standard_rate );
1975: END IF;
1976:
1977: FND_MSG_PUB.add;
1978: END IF;

Line 2002: standard_rate_flag,

1998: scheduled_type_id,
1999: scheduled_type,
2000: autocharge_type_id,
2001: autocharge_type,
2002: standard_rate_flag,
2003: standard_rate
2004: FROM AHL_RT_OPER_RESOURCES_V
2005: WHERE rt_oper_resource_id = c_rt_oper_resource_id;
2006:

Line 2003: standard_rate

1999: scheduled_type,
2000: autocharge_type_id,
2001: autocharge_type,
2002: standard_rate_flag,
2003: standard_rate
2004: FROM AHL_RT_OPER_RESOURCES_V
2005: WHERE rt_oper_resource_id = c_rt_oper_resource_id;
2006:
2007: BEGIN

Line 2021: l_old_rt_oper_cost_rec.standard_rate_flag,

2017: l_old_rt_oper_cost_rec.scheduled_type_id,
2018: l_old_rt_oper_cost_rec.scheduled_type,
2019: l_old_rt_oper_cost_rec.autocharge_type_id,
2020: l_old_rt_oper_cost_rec.autocharge_type,
2021: l_old_rt_oper_cost_rec.standard_rate_flag,
2022: l_old_rt_oper_cost_rec.standard_rate;
2023:
2024: IF get_old_rec%NOTFOUND THEN
2025: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RES' );

Line 2022: l_old_rt_oper_cost_rec.standard_rate;

2018: l_old_rt_oper_cost_rec.scheduled_type,
2019: l_old_rt_oper_cost_rec.autocharge_type_id,
2020: l_old_rt_oper_cost_rec.autocharge_type,
2021: l_old_rt_oper_cost_rec.standard_rate_flag,
2022: l_old_rt_oper_cost_rec.standard_rate;
2023:
2024: IF get_old_rec%NOTFOUND THEN
2025: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RES' );
2026: FND_MSG_PUB.add;

Line 2082: IF ( p_x_rt_oper_cost_rec.standard_rate_flag = FND_API.G_MISS_NUM ) THEN

2078: ELSIF ( p_x_rt_oper_cost_rec.autocharge_type IS NULL ) THEN
2079: p_x_rt_oper_cost_rec.autocharge_type := l_old_rt_oper_cost_rec.autocharge_type;
2080: END IF;
2081:
2082: IF ( p_x_rt_oper_cost_rec.standard_rate_flag = FND_API.G_MISS_NUM ) THEN
2083: p_x_rt_oper_cost_rec.standard_rate_flag := null;
2084: ELSIF ( p_x_rt_oper_cost_rec.standard_rate_flag IS NULL ) THEN
2085: p_x_rt_oper_cost_rec.standard_rate_flag := l_old_rt_oper_cost_rec.standard_rate_flag;
2086: END IF;

Line 2083: p_x_rt_oper_cost_rec.standard_rate_flag := null;

2079: p_x_rt_oper_cost_rec.autocharge_type := l_old_rt_oper_cost_rec.autocharge_type;
2080: END IF;
2081:
2082: IF ( p_x_rt_oper_cost_rec.standard_rate_flag = FND_API.G_MISS_NUM ) THEN
2083: p_x_rt_oper_cost_rec.standard_rate_flag := null;
2084: ELSIF ( p_x_rt_oper_cost_rec.standard_rate_flag IS NULL ) THEN
2085: p_x_rt_oper_cost_rec.standard_rate_flag := l_old_rt_oper_cost_rec.standard_rate_flag;
2086: END IF;
2087:

Line 2084: ELSIF ( p_x_rt_oper_cost_rec.standard_rate_flag IS NULL ) THEN

2080: END IF;
2081:
2082: IF ( p_x_rt_oper_cost_rec.standard_rate_flag = FND_API.G_MISS_NUM ) THEN
2083: p_x_rt_oper_cost_rec.standard_rate_flag := null;
2084: ELSIF ( p_x_rt_oper_cost_rec.standard_rate_flag IS NULL ) THEN
2085: p_x_rt_oper_cost_rec.standard_rate_flag := l_old_rt_oper_cost_rec.standard_rate_flag;
2086: END IF;
2087:
2088: IF ( p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN

Line 2085: p_x_rt_oper_cost_rec.standard_rate_flag := l_old_rt_oper_cost_rec.standard_rate_flag;

2081:
2082: IF ( p_x_rt_oper_cost_rec.standard_rate_flag = FND_API.G_MISS_NUM ) THEN
2083: p_x_rt_oper_cost_rec.standard_rate_flag := null;
2084: ELSIF ( p_x_rt_oper_cost_rec.standard_rate_flag IS NULL ) THEN
2085: p_x_rt_oper_cost_rec.standard_rate_flag := l_old_rt_oper_cost_rec.standard_rate_flag;
2086: END IF;
2087:
2088: IF ( p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN
2089: p_x_rt_oper_cost_rec.standard_rate := null;

Line 2088: IF ( p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN

2084: ELSIF ( p_x_rt_oper_cost_rec.standard_rate_flag IS NULL ) THEN
2085: p_x_rt_oper_cost_rec.standard_rate_flag := l_old_rt_oper_cost_rec.standard_rate_flag;
2086: END IF;
2087:
2088: IF ( p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN
2089: p_x_rt_oper_cost_rec.standard_rate := null;
2090: ELSIF ( p_x_rt_oper_cost_rec.standard_rate IS NULL ) THEN
2091: p_x_rt_oper_cost_rec.standard_rate := l_old_rt_oper_cost_rec.standard_rate;
2092: END IF;

Line 2089: p_x_rt_oper_cost_rec.standard_rate := null;

2085: p_x_rt_oper_cost_rec.standard_rate_flag := l_old_rt_oper_cost_rec.standard_rate_flag;
2086: END IF;
2087:
2088: IF ( p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN
2089: p_x_rt_oper_cost_rec.standard_rate := null;
2090: ELSIF ( p_x_rt_oper_cost_rec.standard_rate IS NULL ) THEN
2091: p_x_rt_oper_cost_rec.standard_rate := l_old_rt_oper_cost_rec.standard_rate;
2092: END IF;
2093:

Line 2090: ELSIF ( p_x_rt_oper_cost_rec.standard_rate IS NULL ) THEN

2086: END IF;
2087:
2088: IF ( p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN
2089: p_x_rt_oper_cost_rec.standard_rate := null;
2090: ELSIF ( p_x_rt_oper_cost_rec.standard_rate IS NULL ) THEN
2091: p_x_rt_oper_cost_rec.standard_rate := l_old_rt_oper_cost_rec.standard_rate;
2092: END IF;
2093:
2094: END default_costing_unchanged;

Line 2091: p_x_rt_oper_cost_rec.standard_rate := l_old_rt_oper_cost_rec.standard_rate;

2087:
2088: IF ( p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN
2089: p_x_rt_oper_cost_rec.standard_rate := null;
2090: ELSIF ( p_x_rt_oper_cost_rec.standard_rate IS NULL ) THEN
2091: p_x_rt_oper_cost_rec.standard_rate := l_old_rt_oper_cost_rec.standard_rate;
2092: END IF;
2093:
2094: END default_costing_unchanged;
2095:

Line 2159: -- Standard Start of API savepoint

2155: BEGIN
2156: -- Initialize API return status to success
2157: x_return_status := FND_API.G_RET_STS_SUCCESS;
2158:
2159: -- Standard Start of API savepoint
2160: SAVEPOINT define_cost_parameter_pvt;
2161:
2162: -- Standard call to check for call compatibility.
2163: IF NOT FND_API.compatible_api_call

Line 2162: -- Standard call to check for call compatibility.

2158:
2159: -- Standard Start of API savepoint
2160: SAVEPOINT define_cost_parameter_pvt;
2161:
2162: -- Standard call to check for call compatibility.
2163: IF NOT FND_API.compatible_api_call
2164: (
2165: l_api_version,
2166: p_api_version,

Line 2406: standard_rate_flag = p_x_rt_oper_cost_rec.standard_rate_flag,

2402: activity_id = p_x_rt_oper_cost_rec.activity_id,
2403: cost_basis_id = p_x_rt_oper_cost_rec.cost_basis_id,
2404: scheduled_type_id = p_x_rt_oper_cost_rec.scheduled_type_id,
2405: autocharge_type_id = p_x_rt_oper_cost_rec.autocharge_type_id,
2406: standard_rate_flag = p_x_rt_oper_cost_rec.standard_rate_flag,
2407: last_update_date = SYSDATE,
2408: last_updated_by = FND_GLOBAL.user_id,
2409: last_update_login = FND_GLOBAL.login_id
2410: WHERE rt_oper_resource_id = p_x_rt_oper_cost_rec.rt_oper_resource_id

Line 3237: -- Standard Start of API savepoint

3233: BEGIN
3234: -- Initialize API return status to success
3235: x_return_status := FND_API.G_RET_STS_SUCCESS;
3236:
3237: -- Standard Start of API savepoint
3238: SAVEPOINT process_alternate_resource_pvt;
3239:
3240: -- Standard call to check for call compatibility.
3241: IF NOT FND_API.compatible_api_call

Line 3240: -- Standard call to check for call compatibility.

3236:
3237: -- Standard Start of API savepoint
3238: SAVEPOINT process_alternate_resource_pvt;
3239:
3240: -- Standard call to check for call compatibility.
3241: IF NOT FND_API.compatible_api_call
3242: (
3243: l_api_version,
3244: p_api_version,