APPS.PA_BILLING_SCHEDULE_PVT dependencies on PA_LABOR_MULTIPLIERS

Line 971: SELECT pa_labor_multipliers_s.NEXTVAL INTO l_labor_multiplier_id

967: l_labor_multiplier_id,
968: l_return_status
969: )
970: THEN
971: SELECT pa_labor_multipliers_s.NEXTVAL INTO l_labor_multiplier_id
972: FROM dual;
973: x_labor_multiplier_id := l_labor_multiplier_id;
974: INSERT INTO pa_labor_multipliers(
975: labor_multiplier_id,

Line 974: INSERT INTO pa_labor_multipliers(

970: THEN
971: SELECT pa_labor_multipliers_s.NEXTVAL INTO l_labor_multiplier_id
972: FROM dual;
973: x_labor_multiplier_id := l_labor_multiplier_id;
974: INSERT INTO pa_labor_multipliers(
975: labor_multiplier_id,
976: PROJECT_ID,
977: TASK_ID ,
978: LABOR_MULTIPLIER ,

Line 1178: FROM pa_labor_multipliers

1174: IF p_validate_only <> FND_API.G_TRUE
1175: THEN
1176: BEGIN
1177: SELECT 'x' INTO l_dummy_char
1178: FROM pa_labor_multipliers
1179: WHERE labor_multiplier_id = p_labor_multiplier_id
1180: AND record_version_number = p_record_version_number
1181: FOR UPDATE OF record_version_number NOWAIT;
1182: EXCEPTION

Line 1212: FROM pa_labor_multipliers

1208: END;
1209: ELSE
1210: BEGIN
1211: SELECT 'x' INTO l_dummy_char
1212: FROM pa_labor_multipliers
1213: WHERE labor_multiplier_id = p_labor_multiplier_id
1214: AND record_version_number = p_record_version_number;
1215: EXCEPTION
1216: WHEN NO_DATA_FOUND THEN

Line 1253: UPDATE pa_labor_multipliers

1249: p_labor_multiplier_id,
1250: l_return_status
1251: )
1252: THEN
1253: UPDATE pa_labor_multipliers
1254: SET LABOR_MULTIPLIER = p_labor_multiplier,
1255: START_DATE_ACTIVE = p_effective_from_date,
1256: END_DATE_ACTIVE = l_effective_to_date,
1257: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 1384: FROM pa_labor_multipliers

1380: IF p_validate_only <> FND_API.G_TRUE
1381: THEN
1382: BEGIN
1383: SELECT 'x' INTO l_dummy_char
1384: FROM pa_labor_multipliers
1385: WHERE labor_multiplier_id = p_labor_multiplier_id
1386: AND record_version_number = p_record_version_number
1387: FOR UPDATE OF record_version_number NOWAIT;
1388: EXCEPTION

Line 1418: FROM pa_labor_multipliers

1414: END;
1415: ELSE
1416: BEGIN
1417: SELECT 'x' INTO l_dummy_char
1418: FROM pa_labor_multipliers
1419: WHERE labor_multiplier_id = p_labor_multiplier_id
1420: AND record_version_number = p_record_version_number;
1421: EXCEPTION
1422: WHEN NO_DATA_FOUND THEN

Line 1450: DELETE pa_labor_multipliers

1446: x_return_status := 'E';
1447: RAISE FND_API.G_EXC_ERROR;
1448: END IF;
1449:
1450: DELETE pa_labor_multipliers
1451: WHERE labor_multiplier_id = p_labor_multiplier_id
1452: AND RECORD_VERSION_NUMBER = p_RECORD_VERSION_NUMBER;
1453: EXCEPTION
1454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN