DBA Data[Home] [Help]

APPS.AHL_RM_RT_OPER_RESOURCE_PVT dependencies on STANDARD

Line 1184: -- Standard Start of API savepoint

1180: BEGIN
1181: -- Initialize API return status to success
1182: x_return_status := FND_API.G_RET_STS_SUCCESS;
1183:
1184: -- Standard Start of API savepoint
1185: SAVEPOINT process_rt_oper_resource_pvt;
1186:
1187: -- Standard call to check for call compatibility.
1188: IF NOT FND_API.compatible_api_call

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

1183:
1184: -- Standard Start of API savepoint
1185: SAVEPOINT process_rt_oper_resource_pvt;
1186:
1187: -- Standard call to check for call compatibility.
1188: IF NOT FND_API.compatible_api_call
1189: (
1190: l_api_version,
1191: p_api_version,

Line 1903: -- Convert / Validate standard_rate_flag

1899: END IF;
1900:
1901: END IF;
1902:
1903: -- Convert / Validate standard_rate_flag
1904: IF ( ( p_x_rt_oper_cost_rec.standard_rate_flag IS NOT NULL AND
1905: p_x_rt_oper_cost_rec.standard_rate_flag <> FND_API.G_MISS_NUM ) OR
1906: ( p_x_rt_oper_cost_rec.standard_rate IS NOT NULL AND
1907: p_x_rt_oper_cost_rec.standard_rate <> FND_API.G_MISS_CHAR ) )

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

1900:
1901: END IF;
1902:
1903: -- Convert / Validate standard_rate_flag
1904: IF ( ( p_x_rt_oper_cost_rec.standard_rate_flag IS NOT NULL AND
1905: p_x_rt_oper_cost_rec.standard_rate_flag <> FND_API.G_MISS_NUM ) OR
1906: ( p_x_rt_oper_cost_rec.standard_rate IS NOT NULL AND
1907: p_x_rt_oper_cost_rec.standard_rate <> FND_API.G_MISS_CHAR ) )
1908: THEN

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

1901: END IF;
1902:
1903: -- Convert / Validate standard_rate_flag
1904: IF ( ( p_x_rt_oper_cost_rec.standard_rate_flag IS NOT NULL AND
1905: p_x_rt_oper_cost_rec.standard_rate_flag <> FND_API.G_MISS_NUM ) OR
1906: ( p_x_rt_oper_cost_rec.standard_rate IS NOT NULL AND
1907: p_x_rt_oper_cost_rec.standard_rate <> FND_API.G_MISS_CHAR ) )
1908: THEN
1909:

Line 1906: ( p_x_rt_oper_cost_rec.standard_rate IS NOT NULL AND

1902:
1903: -- Convert / Validate standard_rate_flag
1904: IF ( ( p_x_rt_oper_cost_rec.standard_rate_flag IS NOT NULL AND
1905: p_x_rt_oper_cost_rec.standard_rate_flag <> FND_API.G_MISS_NUM ) OR
1906: ( p_x_rt_oper_cost_rec.standard_rate IS NOT NULL AND
1907: p_x_rt_oper_cost_rec.standard_rate <> FND_API.G_MISS_CHAR ) )
1908: THEN
1909:
1910: AHL_RM_ROUTE_UTIL.validate_mfg_lookup

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

1903: -- Convert / Validate standard_rate_flag
1904: IF ( ( p_x_rt_oper_cost_rec.standard_rate_flag IS NOT NULL AND
1905: p_x_rt_oper_cost_rec.standard_rate_flag <> FND_API.G_MISS_NUM ) OR
1906: ( p_x_rt_oper_cost_rec.standard_rate IS NOT NULL AND
1907: p_x_rt_oper_cost_rec.standard_rate <> FND_API.G_MISS_CHAR ) )
1908: THEN
1909:
1910: AHL_RM_ROUTE_UTIL.validate_mfg_lookup
1911: (

Line 1915: p_lookup_meaning => p_x_rt_oper_cost_rec.standard_rate,

1911: (
1912: x_return_status => l_return_status,
1913: x_msg_data => l_msg_data,
1914: p_lookup_type => 'SYS_YES_NO',
1915: p_lookup_meaning => p_x_rt_oper_cost_rec.standard_rate,
1916: p_x_lookup_code => p_x_rt_oper_cost_rec.standard_rate_flag
1917: );
1918:
1919: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

Line 1916: p_x_lookup_code => p_x_rt_oper_cost_rec.standard_rate_flag

1912: x_return_status => l_return_status,
1913: x_msg_data => l_msg_data,
1914: p_lookup_type => 'SYS_YES_NO',
1915: p_lookup_meaning => p_x_rt_oper_cost_rec.standard_rate,
1916: p_x_lookup_code => p_x_rt_oper_cost_rec.standard_rate_flag
1917: );
1918:
1919: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1920: IF ( l_msg_data = 'AHL_RM_INVALID_MFG_LOOKUP' ) THEN

Line 1928: IF ( p_x_rt_oper_cost_rec.standard_rate IS NULL OR

1924: ELSE
1925: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1926: END IF;
1927:
1928: IF ( p_x_rt_oper_cost_rec.standard_rate IS NULL OR
1929: p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN
1930: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.standard_rate_flag ) );
1931: ELSE
1932: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.standard_rate );

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

1925: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1926: END IF;
1927:
1928: IF ( p_x_rt_oper_cost_rec.standard_rate IS NULL OR
1929: p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN
1930: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.standard_rate_flag ) );
1931: ELSE
1932: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.standard_rate );
1933: END IF;

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

1926: END IF;
1927:
1928: IF ( p_x_rt_oper_cost_rec.standard_rate IS NULL OR
1929: p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN
1930: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.standard_rate_flag ) );
1931: ELSE
1932: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.standard_rate );
1933: END IF;
1934:

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

1928: IF ( p_x_rt_oper_cost_rec.standard_rate IS NULL OR
1929: p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN
1930: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_rt_oper_cost_rec.standard_rate_flag ) );
1931: ELSE
1932: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_cost_rec.standard_rate );
1933: END IF;
1934:
1935: FND_MSG_PUB.add;
1936: END IF;

Line 1960: standard_rate_flag,

1956: scheduled_type_id,
1957: scheduled_type,
1958: autocharge_type_id,
1959: autocharge_type,
1960: standard_rate_flag,
1961: standard_rate
1962: FROM AHL_RT_OPER_RESOURCES_V
1963: WHERE rt_oper_resource_id = c_rt_oper_resource_id;
1964:

Line 1961: standard_rate

1957: scheduled_type,
1958: autocharge_type_id,
1959: autocharge_type,
1960: standard_rate_flag,
1961: standard_rate
1962: FROM AHL_RT_OPER_RESOURCES_V
1963: WHERE rt_oper_resource_id = c_rt_oper_resource_id;
1964:
1965: BEGIN

Line 1979: l_old_rt_oper_cost_rec.standard_rate_flag,

1975: l_old_rt_oper_cost_rec.scheduled_type_id,
1976: l_old_rt_oper_cost_rec.scheduled_type,
1977: l_old_rt_oper_cost_rec.autocharge_type_id,
1978: l_old_rt_oper_cost_rec.autocharge_type,
1979: l_old_rt_oper_cost_rec.standard_rate_flag,
1980: l_old_rt_oper_cost_rec.standard_rate;
1981:
1982: IF get_old_rec%NOTFOUND THEN
1983: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RES' );

Line 1980: l_old_rt_oper_cost_rec.standard_rate;

1976: l_old_rt_oper_cost_rec.scheduled_type,
1977: l_old_rt_oper_cost_rec.autocharge_type_id,
1978: l_old_rt_oper_cost_rec.autocharge_type,
1979: l_old_rt_oper_cost_rec.standard_rate_flag,
1980: l_old_rt_oper_cost_rec.standard_rate;
1981:
1982: IF get_old_rec%NOTFOUND THEN
1983: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_RES' );
1984: FND_MSG_PUB.add;

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

2036: ELSIF ( p_x_rt_oper_cost_rec.autocharge_type IS NULL ) THEN
2037: p_x_rt_oper_cost_rec.autocharge_type := l_old_rt_oper_cost_rec.autocharge_type;
2038: END IF;
2039:
2040: IF ( p_x_rt_oper_cost_rec.standard_rate_flag = FND_API.G_MISS_NUM ) THEN
2041: p_x_rt_oper_cost_rec.standard_rate_flag := null;
2042: ELSIF ( p_x_rt_oper_cost_rec.standard_rate_flag IS NULL ) THEN
2043: p_x_rt_oper_cost_rec.standard_rate_flag := l_old_rt_oper_cost_rec.standard_rate_flag;
2044: END IF;

Line 2041: p_x_rt_oper_cost_rec.standard_rate_flag := null;

2037: p_x_rt_oper_cost_rec.autocharge_type := l_old_rt_oper_cost_rec.autocharge_type;
2038: END IF;
2039:
2040: IF ( p_x_rt_oper_cost_rec.standard_rate_flag = FND_API.G_MISS_NUM ) THEN
2041: p_x_rt_oper_cost_rec.standard_rate_flag := null;
2042: ELSIF ( p_x_rt_oper_cost_rec.standard_rate_flag IS NULL ) THEN
2043: p_x_rt_oper_cost_rec.standard_rate_flag := l_old_rt_oper_cost_rec.standard_rate_flag;
2044: END IF;
2045:

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

2038: END IF;
2039:
2040: IF ( p_x_rt_oper_cost_rec.standard_rate_flag = FND_API.G_MISS_NUM ) THEN
2041: p_x_rt_oper_cost_rec.standard_rate_flag := null;
2042: ELSIF ( p_x_rt_oper_cost_rec.standard_rate_flag IS NULL ) THEN
2043: p_x_rt_oper_cost_rec.standard_rate_flag := l_old_rt_oper_cost_rec.standard_rate_flag;
2044: END IF;
2045:
2046: IF ( p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN

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

2039:
2040: IF ( p_x_rt_oper_cost_rec.standard_rate_flag = FND_API.G_MISS_NUM ) THEN
2041: p_x_rt_oper_cost_rec.standard_rate_flag := null;
2042: ELSIF ( p_x_rt_oper_cost_rec.standard_rate_flag IS NULL ) THEN
2043: p_x_rt_oper_cost_rec.standard_rate_flag := l_old_rt_oper_cost_rec.standard_rate_flag;
2044: END IF;
2045:
2046: IF ( p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN
2047: p_x_rt_oper_cost_rec.standard_rate := null;

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

2042: ELSIF ( p_x_rt_oper_cost_rec.standard_rate_flag IS NULL ) THEN
2043: p_x_rt_oper_cost_rec.standard_rate_flag := l_old_rt_oper_cost_rec.standard_rate_flag;
2044: END IF;
2045:
2046: IF ( p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN
2047: p_x_rt_oper_cost_rec.standard_rate := null;
2048: ELSIF ( p_x_rt_oper_cost_rec.standard_rate IS NULL ) THEN
2049: p_x_rt_oper_cost_rec.standard_rate := l_old_rt_oper_cost_rec.standard_rate;
2050: END IF;

Line 2047: p_x_rt_oper_cost_rec.standard_rate := null;

2043: p_x_rt_oper_cost_rec.standard_rate_flag := l_old_rt_oper_cost_rec.standard_rate_flag;
2044: END IF;
2045:
2046: IF ( p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN
2047: p_x_rt_oper_cost_rec.standard_rate := null;
2048: ELSIF ( p_x_rt_oper_cost_rec.standard_rate IS NULL ) THEN
2049: p_x_rt_oper_cost_rec.standard_rate := l_old_rt_oper_cost_rec.standard_rate;
2050: END IF;
2051:

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

2044: END IF;
2045:
2046: IF ( p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN
2047: p_x_rt_oper_cost_rec.standard_rate := null;
2048: ELSIF ( p_x_rt_oper_cost_rec.standard_rate IS NULL ) THEN
2049: p_x_rt_oper_cost_rec.standard_rate := l_old_rt_oper_cost_rec.standard_rate;
2050: END IF;
2051:
2052: END default_costing_unchanged;

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

2045:
2046: IF ( p_x_rt_oper_cost_rec.standard_rate = FND_API.G_MISS_CHAR ) THEN
2047: p_x_rt_oper_cost_rec.standard_rate := null;
2048: ELSIF ( p_x_rt_oper_cost_rec.standard_rate IS NULL ) THEN
2049: p_x_rt_oper_cost_rec.standard_rate := l_old_rt_oper_cost_rec.standard_rate;
2050: END IF;
2051:
2052: END default_costing_unchanged;
2053:

Line 2117: -- Standard Start of API savepoint

2113: BEGIN
2114: -- Initialize API return status to success
2115: x_return_status := FND_API.G_RET_STS_SUCCESS;
2116:
2117: -- Standard Start of API savepoint
2118: SAVEPOINT define_cost_parameter_pvt;
2119:
2120: -- Standard call to check for call compatibility.
2121: IF NOT FND_API.compatible_api_call

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

2116:
2117: -- Standard Start of API savepoint
2118: SAVEPOINT define_cost_parameter_pvt;
2119:
2120: -- Standard call to check for call compatibility.
2121: IF NOT FND_API.compatible_api_call
2122: (
2123: l_api_version,
2124: p_api_version,

Line 2364: standard_rate_flag = p_x_rt_oper_cost_rec.standard_rate_flag,

2360: activity_id = p_x_rt_oper_cost_rec.activity_id,
2361: cost_basis_id = p_x_rt_oper_cost_rec.cost_basis_id,
2362: scheduled_type_id = p_x_rt_oper_cost_rec.scheduled_type_id,
2363: autocharge_type_id = p_x_rt_oper_cost_rec.autocharge_type_id,
2364: standard_rate_flag = p_x_rt_oper_cost_rec.standard_rate_flag,
2365: last_update_date = SYSDATE,
2366: last_updated_by = FND_GLOBAL.user_id,
2367: last_update_login = FND_GLOBAL.login_id
2368: WHERE rt_oper_resource_id = p_x_rt_oper_cost_rec.rt_oper_resource_id

Line 3183: -- Standard Start of API savepoint

3179: BEGIN
3180: -- Initialize API return status to success
3181: x_return_status := FND_API.G_RET_STS_SUCCESS;
3182:
3183: -- Standard Start of API savepoint
3184: SAVEPOINT process_alternate_resource_pvt;
3185:
3186: -- Standard call to check for call compatibility.
3187: IF NOT FND_API.compatible_api_call

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

3182:
3183: -- Standard Start of API savepoint
3184: SAVEPOINT process_alternate_resource_pvt;
3185:
3186: -- Standard call to check for call compatibility.
3187: IF NOT FND_API.compatible_api_call
3188: (
3189: l_api_version,
3190: p_api_version,